{"title":"A Conceptual Query-Driven Design Framework for Data Warehouse","authors":"Resmi Nair, Campbell Wilson, Bala Srinivasan","volume":1,"journal":"International Journal of Computer and Information Engineering","pagesStart":62,"pagesEnd":68,"ISSN":"1307-6892","URL":"https:\/\/publications.waset.org\/pdf\/14457","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. ","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. ","publisher":"World Academy of Science, Engineering and Technology","index":"Open Science Index 1, 2007"}