Research in data warehouse modeling and design: Dead or alive?

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2006, Pages 3-10

  Rizzi, Stefano ^a   Abelló, Alberto ^b   Lechtenbörger, Jens ^c   Trujillo, Juan ^d  

^a UNIVERSITY OF BOLOGNA   (Italy)

^b UNIVERSITAT POLITÈCNICA DE CATALUNYA   (Spain)

^c UNIVERSITY OF MÜNSTER   (Germany)

^d UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Data warehouse design; Multidimensional modeling

Indexed keywords

CONCEPTUAL DESIGN; FORMAL LOGIC; INTEROPERABILITY; MATHEMATICAL MODELS;

CONCEPTUAL MODELS; DESIGN METHODS; MULTIDIMENSIONAL MODELING;

DATA WAREHOUSES;

EID: 34547643009     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1183512.1183515     Document Type: Conference Paper

References (86)

1. 2: a multidimensional conceptual model extending UML. Information Systems, 31(6):541-567, 2006.
2. S. Abiteboul, I. Manolescu, and N. Preda. Constructing and querying peer-to-peer warehouses of XML resources. In Proc. ICDE, pages 1122-1123, 2005.
3. B. Bȩbel, J. Eder, C. Koncilia, T. Morzy, and R. Wrembel. Creation and management of versions in multiversion data warehouse. In Proc. ACM SAC, pages 717-723, 2004.
4. S. Bimonte, A. Tchounikine, and M. Miquel. Towards a spatial multidimensional model. In Proc. DOLAP, pages 39-46, 2005.
5. M. Blaschka, C. Sapia, and G. Höfling. On schema evolution in multidimensional databases. In Proc. DaWaK, pages 153-164, 1999.
6. M. Bouzeghoub, F. Fabret, and M. Matulovic. Modeling data warehouse refreshment process as a workflow application. In Proc. DMDW, 1999.
7. M. Bouzeghoub and Z. Kedad. A quality-based framework for physical data warehouse design. In Proc. DMDW, 2000.
8. L. Cabibbo and R. Torlone. On the integration of autonomous data marts. In Proc. SSDBM, pages 223-231, 2004.
9. C. Calero, M. Piattini, C. Pascual, and M. A. Serrano. Towards data warehouse quality metrics. In Proc. DMDW, 2001.
10. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, and R. Rosati. Information integration: Conceptual modeling and reasoning support. In Proc. CoopIS, pages 280-291, 1998.
11. D. Calvanese, L. Dragone, D. Nardi, R. Rosati, and S. M. Trisolini. Enterprise modeling and data warehousing in Telecom Italia. Information Systems, 31(1):1-32, 2006.
12. J. Cavero, M. Piattini, and E. Marcos. MIDEA: A multidimensional data warehouse methodology. In Proc. ICEIS, pages 138-144, 2001.
13. S. Chaudhuri. Data mining and database systems: Where is the intersection? IEEE Data Engineering Bulletin, 21(1):4-8, 1998.
14. B. Chen, L. Chen, Y. Lin, and R. Ramakrishnan. Prediction cubes. In Proc. VLDB, pages 982-993, 2005.
15. X. Chen and I. Petrounias. Mining temporal features in association rules. In Proc. PKDD, pages 295-300, 1999.
16. J. Feng, Q. Fang, and H. Ding. Prefixcube: Prefix-sharing condensed data cube. In Proc. DOLAP, pages 38-47, 2004.
17. E. Fernandez-Medina, J. Trujillo, R. Villaroel, and M. Piattini. Extending UML for designing secure data warehouses. In Decision Support Systems, 2006. In press.
18. E. Franconi and A. Kamble. A data warehouse conceptual data model. In Proc. SSDBM, pages 435-436, 2004.
19. S. Gardner. Building the data warehouse. Comm. ACM, 41(9):52-60, 1998.
20. P. Giorgini, S. Rizzi, and M. Garzetti. Goal-oriented requirement analysis for data warehouse design. In Proc. DOLAP, pages 47-56, 2005.
21. M. Golfarelli, J. Lechtenbörger, S. Rizzi, and G. Vossen. Schema versioning in data warehouses: enabling cross-version querying via schema augmentation. In Data & Knowledge Engineering, 2006. In press.
22. M. Golfarelli, D. Maio, and S. Rizzi. The Dimensional Fact Model: A conceptual model for data warehouses. Int. Journ. of Coop. Inf. Syst., 7(2-3):215-247, 1998.
23. M. Golfarelli, V. Maniezzo, and S. Rizzi. Materialization of fragmented views in multidimensional databases. Data & Knowledge Engineering, 49(3):325-351, 2004.
24. M. Golfarelli and S. Rizzi. A methodological framework for data warehouse design. In Proc. DOLAP, pages 3-9, 1998.
25. M. Golfarelli and S. Rizzi. WAND: A CASE tool for data warehouse design. In Proc. ICDE, pages 7-9, 2001.
26. M. Golfarelli, S. Rizzi, and I. Cella. Beyond data warehousing: What's next in business intelligence? In Proc. DOLAP, pages 1-6, 2004.
27. M. Golfarelli, S. Rizzi, and E. Saltarelli. Index selection for data warehousing. In Proc. DMDW, pages 33-42, 2002.
28. J. Han. Towards on-line analytical mining in large databases. ACM SIGMOD Records, 27(1):97-107, 1998.
29. J. Horner, I. Y. Song, and P. P. Chen. An analysis of additivity in OLAP systems. In Proc. DOLAP, pages 83-91, 2004.
30. C. A. Hurtado and A. O. Mendelzon. OLAP dimension constraints. In Proc. ACM PODS, pages 169-179, 2004.
31. B. Hüsemann, J. Lechtenbörger, and G. Vossen. Conceptual data warehouse design. In Proc. DMDW, pages 3-9, 2000.
32. S. Jajodia and D. Wijesekera. Securing OLAP data cubes against privacy breaches. In Proc. IEEE Symp. on Security and Privacy, pages 161-178, 2004.
33. M. Jarke, M. A. Jeusfeld, C. Quix, and P. Vassiliadis. Architecture and quality in data warehouses: An extended repository approach. Information Systems, 24(3):229-253, 1999.
34. M. Jarke, M. Lenzerini, Y. Vassiliou, and P. Vassiliadis, editors. Fundamentals of Data Warehousing. Springer-Verlag, 2000.
35. M. R. Jensen, T. H. Møller, and T. B. Pedersen. Converting XML DTDs to UML diagrams for conceptual data integration. Data & Knowledge Engineering, 44(3):323-346, 2003.
36. M. E. Jones and I.-Y. Song. Dimensional modeling: identifying, classifying & applying patterns. In Proc. DOLAP, pages 29-38, 2005.
37. M. Kaya and R. Alhajj. Fuzzy OLAP association rules mining based novel approach for multiagent cooperative learning. In Int. Conf. on Industrial & Engin. Appl. of AI & Expert Syst., pages 56-65, 2004.
38. R. Kimball, L. Reeves, M. Ross, and W. Thornthwaite. The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, 1998.
39. R. Kirkgöze, N. Katie, M. Stolda, and A. M. Tjoa. A security concept for OLAP. In Proc. DEXA, pages 619-626, 1997.
40. L. V. S. Lakshmanan, J. Pei, and Y. Zhao. QC-Trees: an efficient summary structure for semantic OLAP. In Proc. ACM SIGMOD, pages 64-75, 2003.
41. D. Laurent, J. Lechtenbörger, G. Vossen, and N. Spyratos. Monotonic complements for independent data warehouses. VLDB Journal, 10(4):295-315, 2001.
42. J. Lechtenbörger and G. Vossen. Multidimensional normal forms for data warehouse design. Information Systems, 28(5):415-434, 2003.
43. W. Lehner, J. Albrecht, and H. Wedekind. Normal forms for multidimensional databases. In Proc. SSDBM, pages 63-72, 1998.
44. M. Levene and G. Loizou. Why is the snowflake schema a good data warehouse design? Information Systems, 28(3):225-240, 2003.
45. S. Luján-Mora and J. Trujillo. A comprehensive method for data warehouse design. In Proc. DMDW, 2003.
46. S. Luján-Mora, J. Trujillo, and I. Song. A UML profile for multidimensional modeling in data warehouses. In Data & Knowledge Engineering, 2006. In press.
47. E. Malinowski and E. Zimányi. Representing spatiality in a conceptual multidimensional model. In ACM Int. Work, on GIS, pages 12-22, 2004.
48. E. Malinowski and E. Zimányi. Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering, 2006. In press.
49. A. Marotta, F. Piedrabuena, and A. Abelló. Managing quality properties in a ROLAP environment. In Proc. CAiSE, pages 127-141, 2006.
50. J. Mazón, J. Trujillo, M. Serrano, and M. Piattini. Applying mda to the development of data warehouses. In Proc. DOLAP, pages 57-66, 2005.
51. J. Mazón, J. Trujillo, M. Serrano, and M. Piattini. Designing data warehouses: From business requirement analysis to multidimensional modeling. In Proc. Int. Work. on Requirements Engineering for Business Needs and IT Alignment, 2005.
52. MDC. Open Information Model, V1.0. http://www.MDCinfo.com, 1999.
53. P. Miksovský and Z. Kouba. GOLAP - geographical online analytical processing. In Proc. DEXA, pages 442-449, 2001.
54. D. Munneke, K. Wahlstrom, and M. Mohania. Fragmentation of multidimensional databases. In Proc. Australasian Database Conference, pages 153-164, 1999.
55. T. Niemi, J. Nummenmaa, and P. Thanisch. Normalising OLAP cubes for controlling sparsity. Data & Knowledge Engineering, 46(3):317-343, 2003.
56. OMG. Common warehouse metamodel specification. http://www.omg.org/, 2004.
57. J. Park and C. Hwang. A design and practical use of spatial data warehouse. In Proc. IEEE Int. Geoscience and Remote Sensing Symp., pages 726-729, 2005.
58. M. Poess and R. Othayoth. Large scale data warehouses on grid: Oracle database 10g and HP ProLiant systems. In Proc. VLDB, pages 1055-1066, 2005.
59. E. Pourabbas. Cooperation with geographic databases. In M. Rafanelli, editor, Multidimensional databases: Problems and solutions, pages 393-432. Idea Group, 2003.
60. N. Prat, J. Akoka, and I. Comyn-Wattiau. A UML-based data warehouse design method. Decision Support Systems, 2006. In press.
61. T. Priebe and G. Pernul. A pragmatic approach to conceptual modeling of OLAP security. In Proc. ER, pages 311-324, 2000.
62. D. Quass, A. Gupta, I. S. Mumick, and J. Widom. Making views self-maintainable for data warehousing. In Proc. Int. Conf. on Parallel and Distributed Information Systems, pages 158-169, 1996.
63. S. Rizzi et al. Towards a logical model for patterns. In Proc. ER, pages 77-90, 2003.
64. L. I. Rusu, J. W. Rahayu, and D. Taniar. A methodology for building XML data warehouses. Int. Jour. of Data Warehousing and Mining, 1(2), 2005.
65. SAP. Multi-dimensional modeling with BW. Technical report, SAP America Inc. and SAP AG, 2000.
66. C. Sapia, M. Blaschka, G. Höfling, and B. Dinter. Extending the E/R model for the multidimensional paradigm. In Proc. ER Workshop on Data Warehousing and Data Mining, pages 105-116, 1998.
67. M. Scotch and B. Parmano. SOVAT: Spatial OLAP visualization and analysis tool. In Proc. HICSS, 2005.
68. M. Serrano, C. Calero, J. Trujillo, S. Luján-Mora, and M. Piattini. Empirical validation of metrics for conceptual models of data warehouses. In Proc. CAiSE, pages 506-520, 2004.
69. G. Shankaranarayanan and Y. Cai. Supporting data quality management in decision-making. Decision Support Systems, 2006. In press.
70. A. Simitsis. Mapping conceptual to logical models for ETL processes. In Proc. DOLAP, pages 67-76, 2005.
71. A. Simitsis, P. Vassiliadis, and T. K. Sellis. Optimizing ETL processes in data warehouses. In Proc. ICDE, pages 564-575, 2005.
72. Y. Sismanis, A. Deligiannakis, Y. Kotidis, and N. Roussopoulos. Hierarchical dwarfs for the rollup cube. In Proc. DOLAP, pages 17-24, 2003.
73. Y. Sismanis and N. Roussopoulos. The complexity of fully materialized coalesced cubes. In Proc. VLDB, pages 540-551, 2004.
74. D. Theodoratos and T. Sellis. Designing data warehouses. Data & Knowledge Engineering, 31(3):279-301, 1999.
75. J. Trujillo, S. Luján-Mora, and E. Medina. The Gold model case tool: An environment for designing OLAP applications. In Proc. ICEIS, pages 699-707, 2002.
76. A. Vaisman, A. Mendelzon, W. Ruaro, and S. Cymerman. Supporting dimension updates in an OLAP server. In Proc. CAiSE, pages 67-82, 2002.
77. P. Vassiliadis. Data Warehouse Modeling and Quality Issues. PhD thesis, NTUA, Athens, 2000.
78. P. Vassiliadis, A. Simitsis, P. Georgantas, M. Terrovitis, and S. Skiadopoulos. A generic and customizable framework for the design of ETL scenarios. Information Systems, 30(7):492-525, 2005.
79. P. Vassiliadis, A. Simitsis, and S. Skiadopoulos. Conceptual modeling for ETL processes. In Proc. DOLAP, pages 14-21, 2002.
80. T. Vetterli, A. Vaduva, and M. Staudt. Metadata standards for data, warehousing: Open Information Model vs. Common Warehouse Metamodel. ACM SIGMOD Records, 3(23), 2000.
81. B. Vrdoljak, M. Banek, and S. Rizzi. Designing web warehouses from XML schemas. In Proc. DaWaK, pages 89-98, 2003.
82. W. Wang, H. Lu, J. Feng, and J. X. Yu. Condensed cube: An efficient approach to reducing data cube size. In Proc. ICDE, pages 155-165, 2002.
83. R. Winter and B. Strauch. A method for demand-driven information requirements analysis in data warehousing projects. In Proc. HICSS, pages 1359-1365, 2003.
84. J. Zhang, T. W. Ling, R. Bruckner, and A. M. Tjoa. Building XML data warehouse based on frequent patterns in user queries. In Proc. DaWaK, pages 99-108, 2003.
85. L. Zhang, Y. Li, F. Rao, X. Yu, Y. Chen, and D. Liu. An approach to enabling spatial OLAP by aggregating on spatial hierarchy. In Proc. DaWaK, volume 2737, pages 35-44, 2003.
86. J. Zubcoff and J. Trujillo. Extending the UML for designing association rule mining models for data warehouses. In Proc. DaWaK, pages 11-21, 2005.