![]() "Data Warehouse is a subject-oriented, integrated, and time-variant store of information in support of management's decisions." Characteristics of Data Warehouse Subject-OrientedĪ data warehouse target on the modeling and analysis of data for decision-makers. It includes current and historical data to provide a historical perspective of information.It supports a relatively small number of clients with relatively long interactions.It is a database designed for investigative tasks, using data from various applications.It is not used for daily operations and transaction processing but used for making decisions.Ī Data Warehouse can be viewed as a data system with the following attributes: It includes historical data derived from transaction data from single and multiple sources.Ī Data Warehouse provides integrated, enterprise-wide, historical data and focuses on providing support for decision-makers for data modeling and analysis.Ī Data Warehouse is a group of data specific to the entire organization, not only to a particular group of users. What is a Data Warehouse?Ī Data Warehouse (DW) is a relational database that is designed for query and analysis rather than transaction processing. So, Data Warehousing support architectures and tool for business executives to systematically organize, understand and use their information to make strategic decisions.ĭata Warehouse environment contains an extraction, transportation, and loading (ETL) solution, an online analytical processing (OLAP) engine, customer analysis tools, and other applications that handle the process of gathering information and delivering it to business users. It is a group of decision support technologies, targets to enabling the knowledge worker (executive, manager, and analyst) to make superior and higher decisions. It is a database that stores information oriented to satisfy decision-making requests. It can be loosely described as any centralized data repository which can be queried for business benefits. Datenbanksysteme in Büro, Technik und Wissenschaft: GI-Fachtagung, Springer-Verlag, Ulm, 1997.Data Warehouse is a relational database management system (RDBMS) construct to meet the requirement of transaction processing systems. of the ACM Workshop on Materialized Views: Techniques and Applications, Montreal, June 7, 1996. A System Prototype for Warehouse View Maintenace. Communications of the ACM, 41(9), September 1998. Data Warehousing: Managerial Considerations. BTW 1999 (Datenbanksysteme in Büro, Technik und Wissenschaft), Freiburg, März 1999. The SIRIUS Approach for Refreshing Data Warehouses Incrementally. ![]() Multi-Table Joins through Bitmapped Join Indices. IEEE Transactions on Knowledge and Data Engineering, 7(6), December 1995. Utilizing Page-Level Join Index for Optimization in Parallel Join Execution. Technical Report 98.07, Department of Computer Science, University of Zurich, June 1998.Ĭ. SIRIUS: An Approach for Data Warehouse Refreshment. Data Warehouse from Architecture to Implementation. ACM SIGMOD Record, 26:1, March 1997.ĭigital Consulting Inc. An Overview of Data Warehousing and OLAP Technology. of the 13th Intl Conference on Data Engineering, Birmingham U.K., April 1997.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |