A general model for the design of data warehouses

International Journal of Production Economics

Volumn 112, Issue 1, 2008, Pages 309-325

  Schneider, Michel ^a  

^a UNIVERSITÉ BLAISE PASCAL   (France)

Author keywords

Data warehouse; General model; Multidimensional; Relational mapping

Indexed keywords

ELECTRONIC COMMERCE; GRAPHIC METHODS; PROBLEM SOLVING; PRODUCTION; WAREHOUSES;

DATA WAREHOUSE; GENERAL MODEL; RELATIONAL MAPPING;

DATA MINING;

EID: 38749099780     PISSN: 09255273     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.ijpe.2006.11.027     Document Type: Article

References (27)

1. Abello, A., Samos, J., Saltor, F., 2001. Understanding analysis dimensions in a multidimensional object-oriented model. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, Interlaken, Switzerland.
2. Abello, A., Samos, J., Saltor, F., 2001b. A framework for the classification and description of multidimensional data models. In: Proceedings of the 12th International Conference on Database and Expert Systems Applications, Munich, Germany, pp. 668-677.
3. Abello A., Samos J., and Saltor F. YAM2 (yet another multidimensional model): An extension of UML. Proceedings of the International Database Engineering and Applications Symposium, Edmonton, Canada (2002) 172-181
4. Agrawal R., Gupta A., and Sarawagi S. Modelling multidimensional databases. Proceedings of the 13th International Conference on Data Engineering, Birmingham, UK (1997) 232-243
5. Blaschka M., Sapia C., Hofling G., and Dinter B. Finding your way through multidimensional data models. Proceedings of the 9th International Conference on Database and Expert Systems Applications, Vienna, Austria, LNCS 1460 (1998) 198-203
6. Czarnecki, K., Helsen, S., 2003. Classification of model transformation approaches. In: Proceedings of the OOPSLA Workshop on Generative Techniques in the Context of Model-Driven Architecture, Anaheim, USA.
7. Datta A., and Thomas H. The cube data model: A conceptual model and algebra for on-line analytical processing in data warehouses. Decision Support Systems 27 3 (1999) 289-301
8. Golfarelli M., Maio D., and Rizzi S. Conceptual design of data warehouses from E/R schemes. In: Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences 7 (1998) 334-343
9. Gyssens M., and Lakshmanan V.S. A foundation for multi-dimensional databases. In: Proceedings of the 23rd Conference on Very Large Databases (1997) 106-115
10. Hahn, K., Sapia, C., Blaschka, M., 2000. Automatically generating OLAP schemata from conceptual graphical models. In: Proceedings of the Third ACM International Workshop on Data Warehousing and OLAP, McLean, Virginia, USA 〈http://citeseer.ist.psu.edu/341251.html〉.
11. Huang, C.C, Tseng, T.L., Li, M.Z., Gung R.R., 2006. Model of multi-dimensional analysis for qualitative data and its application. European Journal of Operational Research. In press, available on Elsevier web site.
12. Hùsemann, B., Lechtenbörger, J., Vossen, G., 2000. Conceptual Data Warehouse Design. In: Proceedings of International Workshop on Design and Management of Data Warehouses, Stockholm, Sweden.
13. Lechtenbörger J., and Vossen G. Multidimensional normal forms for data warehouse design. Information Systems 28 5 (2003) 415-434
14. Lehner, W., Albrecht, J., Wedekind, H., 1998. Normal forms for multidimensional data bases. In: Proceedings of the l0th International Conference on Scientific and Statistical Data Management, Capri, Italy, pp. 63-72.
15. Lenz H.J., and Shoshani A. Summarizability in OLAP and statistical data bases. In: Proceedings of the nineth International Conference on Scientific and Statistical Data Management (1997) 132-143
16. Levene M., and Loizou G. Why is the star schema a good data warehouse design (1999). http://citeseer.ni.nec.com/457156.html
17. Levene M., and Loizou G. Why is the snowflake schema a good data warehouse design. Information Systems 28 3 (2003) 225-240
18. Li C., and Wang X.S. A data model for supporting on-line analytical processing. In: Proceedings of the Fifth International Conference on Information and Knowledge Management (1996) 81-88
19. Mansmann S., and Scholl M.H. Extending visual OLAP for handling irregular dimensional hierarchies. In: Proceedings of the International Conference on Data Warehousing and Knowledge Discovery, LNCS 4081 (2006) 95-105
20. Moody, L.D., Kortink, M.A.R., 2000. From enterprise models to dimensional models: A methodology for data warehouse and data mart design. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, Stockholm, Sweden. 〈http://citeseer.nj.nec.com/moody00from.html〉
21. Niemi, T., Nummenmaa, J., 2001. Logical multidimensional database design for ragged and unbalanced aggregation hierarchies. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, Interlaken, Switzerland. 〈http://citeseer.ist.psu.edu/472790.html〉
22. Pedersen T.B., and Jensen C.S. Multidimensional data modelling for complex data. In: Proceedings of the International Conference on Data Engineering (1999) 336-345
23. Pourabbas, E., Rafanelli, M., 1999. Characterization of hierarchies and some operators in OLAP environment. In: Proceedings of the ACM Second International Workshop on Data Warehousing and OLAP, Kansas City, USA, pp. 54-59.
24. Vassiliadis P., and Skiadopoulos S. Modelling and optimisation issues for multidimensional databases. In: Proceedings of the 12th International Conference on Advanced Information Systems Engineering, Stockholm, Sweden (2000) 482-497
25. Thalhammer T., Schrefl M., and Mohania M. Active data warehouses: Complementing OLAP with analysis rules. Data and Knowledge Engineering 39 (2001) 241-269
26. Theodoratos D., Ligoudistianos S., and Sellis T.K. View selection for designing the global data warehouse. Data and Knowledge Engineering 39 (2001) 219-240
27. Tsois, A., Karayannidis, N., Sellis, T., 2001. MAC: Conceptual data modeling for OLAP. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, Interlaken, Switzerland.