Abstract

In this study, a framework for building an Exploitation Database Approach (EDA) is provided. Suchan EDA requires tasks such as data warehouse change detection, EDA queries rebuilding and queries results delivering to all users across organization sites. For this purpose, we introduce an innovative approach for creating a new simple design, with high benefits, in order to manage and exploit On Line Analysis Processing (OLAP) queries and reporting information of OLAP applications across the overall organization sites without regard to latencies limitation and barriers. The latency requirements for delivering information span a wide range depending on specific business processes. Data Replication using EDA appears as a robust and perfect solution for eliminating requirements latencies in answering OLAP querying.

Keywords:

Business Intelligence (BI), Data Base (DB), Data Warehouse (DW), Exploitation Database Approach (EDA), On-Line Analytical Processing (OLAP),

References

1. Al-Debei, M.M., 2011. Data warehouse as a backbone for business intelligence: Issues and challenges. Eur. J. Econ. Financ. Admin. Sci., 33(33): 1-14.
   
2. Biere, M., 2003. Business Intelligence for the Enterprise. Prentice Hall PTR, Upper Saddle River, N.J.
   
3. Brian, S., 2008. DM Review Special Report, January.
   
4. Claudia, I., 2008. Database replication, real-time data movement for real-time business. SyBase, June 2008.
   
5. Eckerson, W., 2007. Predictive analytics: Extending the value of your data warehousing investment (Executive summary). First Quarter, TDWI, Best Intelligence Practices Report SAS, 2007.
   
6. Elmasri, R. and S.B. Navathe, 2002. Fundamental of Database Systems. 3rd Edn., Addison Wesley, Boston.
   PMid:12858525    
7. Goil, S. and A. Choudhary, 1997. High performance OLAP and data mining on parallel computers. Data Min. Knowl. Disc., 1(4): 391-417.
   CrossRef    
8. Holenstein, P.J., B.D. Holenstein and G.E. Strickler, 2011. Synchronization of plural databases in a database replication system when replication is slower than the synchronization process. United States Patent (10) Patent No.: US 7882062 B2, February 1, 2011, Gravic Inc.
   
9. LogiXML, 2010. 12 essential BI features that deliver immediate value to your applications: A LogiXML features guide. The Smart Choice of Business Intelligent, LogiXML Inc.
   
10. Marius, G., M. Aref and H. Bilal, 2009. Real time on-line analytical processing for business intelligence. U.P.B. Sci. Bull. Ser. C, 71(3): 79-88.
    
11. Soutou, C., 2002. De UML à SQL: Conception De Bases De Données. Eyrolles, Paris.
    
12. Todman, C., 2001. Designing a Data Warehouse: Supporting Customer Relationship Management. 1st Edn., Prentice-Hall PTR, Upper Saddle River, NJ.
    

Competing interests

The authors have no competing interests.

Open Access Policy

This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made.

Copyright

The authors have no competing interests.