Implementing operations to navigate semantic star schemas

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

Volumn , Issue , 2003, Pages 56-62

  Abelló, Alberto ^a   Samos, José ^b   Saltor, Fèlix ^a  

^a UNIVERSITAT POLITÈCNICA DE CATALUNYA   (Spain)

^b UNIVERSITY OF GRANADA   (Spain)

Author keywords

Drill across; OLAP operations; Semantic Relationships; SQL; Star schema

Indexed keywords

ALGEBRA; DATA REDUCTION; MATHEMATICAL MODELS; ONLINE SYSTEMS; PROBLEM SOLVING; SEMANTICS;

DRILL-ACROSS; ONLINE ANALYTICAL PROCESSING (OLAP) OPERATIONS; SEMANTIC RELATIONSHIPS; SQL; STAR SCHEMA;

DATA WAREHOUSES;

EID: 19544381888     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/956060.956071     Document Type: Conference Paper

References (27)

1. A. Abelló, J. Samos, and F. Saltor. On Relationships Offering New Drill-across Possibilities. In Int. Workshop on Data Warehousing and OLAP (DOLAP 2002). ACM, 2002.
2. 2 (Yet Another Multidimensional Model): An extension of UML. In Int. Database Engineering and Applications Symposium. IEEE, 2002.
3. S. Abiteboul, R. Hull, and V. Vianu. Foundations of Databases. Addison-Wesley, 1995.
4. R. Agrawal, A. Gupta, and S. Sarawagi. Modeling Multidimensional Databases. In Int. Conf. on Data Engineering (ICDE'97). IEEE, 1997.
5. J. Akoka, I. Comyn-Wattiau, and N. Prat. Dimension Hierarchies Design from UML Generalizations and Aggregations. In Int. Conf. on Conceptual Modeling (ER 2001), volume 2224 of LNCS. Springer, 2001.
6. A. Bauer, W. Hümmer, and W. Lehner. An Alternative Relational OLAP Modeling Approach. In Int. Conf. on Data Warehousing and Knowledge Discovery (DaWaK 2000), volume 1944 of LNCS. Springer, 2000.
7. L. Cabibbo and R. Torlone. A Logical Approach to Multidimensional Databases. In Advances in Database Technology - EDBT'98, volume 1377 of LNCS. Springer, 1998.
8. A. Datta and H. Thomas. A Conceptual Model and an algebra for On-Line Analytical Processing in Data Warehouses. In Workshop on Information Technologies and Systems (WITS'97), 1997.
9. J. Eder and C. Koncilia. Changes of Dimension Data in Temporal Data Warehouses. In Int. Conf. on Data Warehousing and Knowledge Discovery (DaWaK 2001), volume 2114 of LNCS. Springer, 2001.
10. E. Franconi, F. Baader, U. Sattler, and P. Vassiliadis. Fundamentals of Data Warehousing, chapter Multidimensional Data Models and Aggregation. Springer, 2000. M. Jarke, M. Lenzerini, Y. Vassilious and P. Vassiliadis editors.
11. M. Gyssens and L. V. S. Lakshmanan. A Foundation for Multi-dimensional Databases. In Int. Conf. on Very Large Data Bases (VLDB'97). Morgan Kaufmann, 1997.
12. M.-S. Hacid and U. Sattler. An Object-Centered Multi-dimensional Data Model with Hierarchically Structured Dimensions. In IEEE Knowledge and Data Engineering Exchange Workshop (KDEX'97). IEEE, 1997.
13. ISO. ISO/IEC 9075:1999: Information technology - Database languages - SQL. International Organization for Standardization, 1999.
14. H. V. Jagadish, L. V. S. Lakshmanan, and D. Srivastava. What can Hierarchies do for Data Warehouses? In Int. Conf. on Very Large Data Bases (VLDB 1999). Morgan Kaufmann, 1999.
15. R. Kimball. The Data Warehouse toolkit. John Wiley & Sons, 1996.
16. W. Lehner. Modeling Large Scale OLAP Scenarios. In Advances in Database Technology - EDBT'98, volume 1377 of LNCS. Springer, 1998.
17. C. Li and X. S. Wang. A data model for supporting on-line analytical processing. In Int. Conf. on Information and Knowledge Management (CIKM'96), 1996.
18. D. L. Moody and M. A. Kortink. From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. In Int. Workshop on Design and Management of Data Warehouses (DMDW'2000). CEUR-WS (www.ceur-ws.org), 2000.
19. OLAP Council. OLAP and OLAP Server Definitions. Available at the URL www.olapcouncil.org/research/glossaryly.htm, 1997.
20. OMG. Unified Modeling Language Specification, September 2001. Version 1.4. Available at http://www.omg.org/cgi-bin/doc?formal/01-09-67.
21. T. B. Pedersen and C. S. Jensen. Multidimensional Data Modeling for Complex Data. In Int. Conf. on Data Engineering (ICDE'99). IEEE, 1999.
22. T. B. Pedersen and C. S. Jensen. Multidimensional Database Technology. IEEE Computer, 34(12), 2001.
23. I.-Y. Song, W. Rowen, C. Medsker, and E. Ewen. An An alysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling. In Int. Workshop on Design and Management of Data Warehouses (DMDW'2001). CEUR-WS (www.ceur-ws.org), 2001.
24. O. Teste. Towards Conceptual Multidimensional Design in Decision Support Systems. In East-European Conf. on Advances in Databases and Information Systems (ADBIS 2001), 2001.
25. J. C. Trujillo, M. Palomar, J. Gómez, and I.-Y. Song. Designing Data Warehouses with OO Conceptual Models. IEEE Computer, 34(12), 2001.
26. N. Tryfona, F. Busborg, and J. G. B. Christiansen. starER: A conceptual model for data warehouse design. In Int. Workshop on Data Warehousing and OLAP (DOLAP 99). ACM, 1999.
27. P. Vassiliadis. Modeling Multidimensional Databases, Cubes and Cube operations. In Int. Conf., on Scientific & Statistical Database Management (SSDBM'98). IEEE, 1998.