A Conceptual Query-Driven Design Framework for Data Warehouse

Authors: Resmi Nair, Campbell Wilson, Bala Srinivasan

Abstract:

Data warehouse is a dedicated database used for querying and reporting. Queries in this environment show special characteristics such as multidimensionality and aggregation. Exploiting the nature of queries, in this paper we propose a query driven design framework. The proposed framework is general and allows a designer to generate a schema based on a set of queries.

Keywords: Conceptual schema, data warehouse, queries, requirements.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1083007

References:

[1] A. Abello, J. Samos, and F. Saltor. A framework for the classification and description of multidimensional data models. In International Conference on Database and Expert Systems Applications, pages 668-677, 2001.
[2] A .Gupta, V. Harinarayan, and D. Quass. Aggregate-query processing in data warehousing environment. In International Conference on Very Large Databases, pages 358-369, 1995.
[3] A. Tsois, N. Karayannidis, and T. Sellis. MAC: Conceptual data modeling for OLAP. In International Workshop on Design and Management of Data Warehouses, page 5, 2001.
[4] C. Batini, S. Ceri, and S. Navathe. Conceptual Database Design. Benjamin/Cummings, 1992.
[5] B. List, J. Schiefer, and A.M. Tjoa. Process-oriented requirements analysis supporting the data warehouse design process a use case driven approach. pages 593-603, 2000.
[6] C. Sapia. PROMISE: Modeling and Predicting User Behavior for Online Analytical Applications. PhD dissertation, Technische Universitt Mnchen, vorauss, 2001.
[7] C. Sapia, M. Blaschka, G. Hofling, and B. Dinter. Extending the E/R model for the multidimensional paradigm. In ER Workshops, pages 105-116, 1998.
[8] D. l. Moody. From enterprise model to dimensional models: A methodology for data warehouse and data mart design. In International Workshop on Design and Management of Data, page 5, 2000.
[9] D. Theodoratos. Exploiting hierarchical clustering in evaluating multidimensional aggregation queries. In International Work-shop on Data Warehousing and OLAP, pages 63-70, 2003.
[10] D.W. Cheung, B. Zhou, B. Kao, H. Lu, T.W. Lam, and F. Ting. Requirement -based data cube schema design. In Conference on Information and Knowledge Management, pages 162-169, 1999.
[11] H-J. Lenz and A. Shoshani. Summarizability in OLAP and statistical data bases. In Statistical and Scientific Database Management, pages 132-143, 1997.
[12] B. Husemann, J. Lechtenborger, and G. Vossen. Conceptual data warehouse design. In International Workshop on Design and Management of Data Warehouses, page 6, 2000.
[13] J.A. Bubenko Jr. On the role of understanding models in conceptual schema design. In International Conference on Very Large Databases, pages 129-139, 1979.
[14] J. Zhang, W. Wang, H. Liu, and S. Zhang. X- warehouse: Building query pattern-driven data. In International World Wide Web Conference, pages 896-897, 2005.
[15] L. Cabibbo and R. Torlone. A logical approach to multidimensional databases. In International Conference on Extending Database Technology, pages 183-197, 1998.
[16] M. Golfarelli, D. Maio, and S. Rizzi. Conceptual design of data warehouses from ER schemes. In International Conference on System Sciences, pages 334-343, 1998.
[17] M. Golfarelli, D..Maio, and S. Rizzi. The dimensional fact model: A conceptual model for data warehouses. International Journal of Cooperative Information Systems, 7(2-3):215-247, 1998.
[18] O.Herden. A design methodology for data warehouses. In International Baltic Workshop on Databases and Information systems, pages 292-293, 2000.
[19] P. R. Niven. Balanced Scorecard Step-by-step Maximizing Performance and Maintaining Results. John Wiley, Inc, 2002.
[20] R. Winter and B. S trauch. A method for demand-driven information requirements analysis in data warehousing projects. In International conference on Systems Sciences, pages 231-239, 2003.
[21] T. B. Pedrsen and C.S.Jensen. Multidimensional database technology. Computer, 34:40-46, 2001.
[22] T. Niemi, J. Nummenmaa, and P. Thanisch. Constructing OLAP cubes based on queries. In International Workshop on Data Warehousing and OLAP, pages 9-15, 2001.