Object-extended OLAP querying

Data and Knowledge Engineering

Volumn 68, Issue 5, 2009, Pages 453-480

  Pedersen, Torben Bach ^a   Gu, Junmin ^b   Shoshani, Arie ^b   Jensen, Christian S ^a  

^a AALBORG UNIVERSITY   (Denmark)

^b LAWRENCE BERKELEY NATIONAL LABORATORY   (United States)

Author keywords

Data integration; Multidimensional databases; Object databases; On line analytical processing (OLAP); Summarizability

Indexed keywords

APPLICATIONS; DATA WAREHOUSES; INFORMATION THEORY; LINGUISTICS; MARKUP LANGUAGES; SOFTWARE PROTOTYPING;

DATA INTEGRATION; MULTIDIMENSIONAL DATABASES; OBJECT DATABASES; ON-LINE ANALYTICAL PROCESSING (OLAP); SUMMARIZABILITY;

QUERY LANGUAGES;

EID: 62849125006     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2008.10.008     Document Type: Article

References (63)

1. A. Abelló, M. Oliva, J. Samos, F. Saltor, Information system architecture for data warehousing from a federation, in: Proceedings of The Third Workshop on Engineering Federated Information Systems, 2000, pp. 33-40.
2. Abelló A., Samos J., and Saltor F. YAM2: a multidimensional conceptual model extending UML. Information Systems 31 6 (2006) 541-567
3. B. Amann, C. Beeri, I. Fundulaki, M. Scholl, Querying XML sources using an ontology-based mediator, in: Proceedings of the On the Move to Meaningful Internet Systems - DOA/CoopIS/ODBASE Confederated International Conferences, 2002, pp. 429-448.
4. T. Barsalou, D. Gangopadhyay, M(DM): an open framework for interoperation of multimodel multidatabase systems, in: Proceedings of the Eighth International Conference on Data Engineering, 1992, pp. 218-227.
5. M. Body, M. Miquel, Y. Bédard, A. Tchounikine, Handling evolutions in multidimensional structures, in: Proceedings of the Nineteenth International Conference on Data Engineering, 2003, pp. 581-591.
6. R.M. Bruckner, B. List, J. Schiefer, Striving towards near real-time data integration for data warehouses, in: Proceedings of the Fourth International Conference on Data Warehousing and Knowledge Discovery, 2002, pp. 317-326.
7. Budd T.A. Multiparadigm Programming in Leda (1995), Addison-Wesley
8. L. Cabibbo, R. Torlone, Querying multidimensional databases, in: Proceedings of the Sixth International Conference on Database Programming Languages, 1997, pp. 319-335.
9. R.G.G. Cattell, et al. (ed.), The Object Database Standard: ODMG 2.0, Morgan Kaufmann, 1997.
10. Chen I.-M.A., and Markowitz V.M. An overview of the object-protocol model (OPM) and OPM data management tools. Information Systems 20 5 (1995) 393-418
11. I.A. Chen, V.M. Markowitz, The Object-Protocol Model (OPM), Version 4.1, Lawrence Berkeley National Laboratory, Technical Report LBNL-32738 (revised), 1996.
12. I.A. Chen, A. Kosky, V.M. Markowitz, E. Szeto, The OPM Query Language and Translator - Version 4.1, Lawrence Berkeley National Laboratory, Technical Report LBNL-38180, 1996.
13. *QS: The Object-Protocol Model Multidatabase Query System, Lawrence Berkeley National Laboratory, Technical Report LBNL-38181, 1996.
14. Domenig R., and Dittrich K. An overview and classification of mediated query systems. ACM SIGMOD Record 28 3 (1999)
15. J. Eder, K. Wiggisser, Data warehouse maintenance, evolution, and versioning, in: L. Liu, M.T. Özsu (Eds.), Encyclopedia of Database Systems, Springer, NY, 2009.
16. Eisenberg A., and Melton J. Sql standardization: The next steps. SIGMODR 29 1 (2000) 63-67
17. Garcia-Molina H., et al. The TSIMMIS approach to mediation: data models and languages. Journal of Intelligent Information Systems 8 2 (1997) 117-132
18. Genelogic Corporation, Genelogic Home Page, , Current as of October 30, 2008.
19. F. Gingras, Laks V.S. Lakshmanan, nD-SQL: a multi-dimensional language for interoperability and OLAP, in: Proceedings of Twentyfourth International Conference on Very Large Data Bases, 1998, pp. 134-145.
20. R. Goldman, J. Widom, WSQ/DSQ: a practical approach for combined querying of databases and the web, in: Proceedings of the ACM SIGMOD Conference, 2000, pp. 285-296.
21. Gray J., et al. Data cube: a relational aggregation operator generalizing group-by, cross-tab and sub-totals. Data Mining and Knowledge Discovery 1 1 (1997) 29-54
22. J. Gu, T.B. Pedersen, A. Shoshani, OLAP++: powerful and easy-to-use federations of OLAP and object databases, in: Proceedings of the Twenty-Sixth International Conference on Very Large Databases, demo track, 2000, pp. 599-602.
23. Hellerstein J.M., and Stonebraker M. Independent open enterprise data integration. Data Engineering Bulletin 22 1 (1999) 43-49
24. D.K. Hsiao, M.N. Kamel, The multimodel, multilingual approach to interoperability of multidatabase systems, in: Proceedings of the First International Workshop on Research Issues on Data Engineering, 1991.
25. Hsiao D.K. Federated databases and systems: Part I - A tutorial on their data sharing. VLDB Journal 1 1 (1992) 127-179
26. Hsiao D.K. Federated databases and systems: Part II - A tutorial on their resource consolidation. VLDB Journal 1 2 (1992) 285-310
27. C.A. Hurtado, A.O. Mendelzon, A.A. Vaisman, Maintaining data cubes under dimension updates. in: Proceedings of the Fifteenth International Conference on Data Engineering, 1999, pp. 346-355.
28. IBM Corporation, DB2 DataJoiner, , Current as of October 30, 2008.
29. International Standards Organisation (ISO), ISO/IEC 9075-1:1999/Amd 1:2001: AMDT 1: On-Line Analytical Processing (SQL/OLAP) - Information Technology - Database Languages - SQL - Part 1: Framework (SQL/Framework), ISO, 2001.
30. H.V. Jagadish, L.V.S. Lakshmanan, D. Srivastava, What can hierarchies do for data warehouses? in: Proceedings of the Twenty-Fifth International Conference on Very Large Data Bases, 1999, pp. 530-541.
31. H.G. Kang, C.W. Chung, Exploiting versions for on-line data warehouse maintenance in MOLAP servers, in: Proceedings of the Twenty-Eighth International Conference on Very Large Databases, 2002, pp. 742-753.
32. T. Lahiri, S. Abiteboul, J. Widom, Ozone - integrating semistructured and structured data, in: Proceedings of the Eighth International Workshop on Database Programming Languages, 1999.
33. W. Lehner, Modeling large scale OLAP scenarios, in: Proceedings of the Sixth International Conference on Extending Database Technology, 1998, pp. 153-167.
34. H. Lenz, A. Shoshani, Summarizability in OLAP and statistical data bases, in: Proceedings of the Ninth International Conference on Statistical and Scientific Database Management, 1997, pp. 39-48.
35. V.M. Markowitz, et al. OPM Home Page, URL: , Current as of October 30, 2008.
36. Melton J., and Simon A.R. Understanding the New SQL - A Complete Guide (1993), Morgan Kaufmann
37. Microsoft Corporation, OLE DB for OLAP Version 1.0 Specification, Microsoft Technical Document, 1998.
38. Object Management Group, Unified Modeling Language (UML), version 2.1.2, URL: , Current as of October 30, 2008.
39. Oracle Corporation, Oracle Gateways , Current as of October 30, 2008.
40. Luján-Mora S., Trujillo J., and Song I.-Y. A UML profile for multidimensional modeling in data warehouses. Data and Knowledge Engineering 59 3 (2006) 725-769
41. T.B. Pedersen, C.S. Jensen, C.E. Dyreson, A foundation for capturing and querying complex multidimensional data, Information Systems 26(5) (2001) 383-423 (Special Issue: Data Warehousing).
42. T.B. Pedersen, C.S. Jensen, C.E. Dyreson, Extending practical pre-aggregation for on-line analytical processing, in: Proceedings of the Twenty-Fifth International Conference on Very Large Databases, 1999, pp. 663-674.
43. Pedersen T.B., Pedersen D., and Pedersen J. Integrating XML data in the TARGIT OLAP system. International Journal of Web Engineering and Technology 4 4 (2008) 495-533
44. T.B. Pedersen, A. Shoshani, J. Gu, C.S. Jensen, Extending OLAP querying to external object databases, in: Proceedings of the 2000 ACM CIKM International Conference on Information and Knowledge Management, pp. 405-413.
45. Perez J.M., Berlanga R., Aramburu M.J., and Pedersen T.B. Integrating data warehouses with web data: a survey. IEEE Transactions on Knowledge and Data Engineering 20 7 (2008) 940-955
46. Polyzotis N., Skiadopoulos S., Vassiliadis P., Simitsis A., and Frantzell N.-E. Meshing streaming updates with persistent data in an active data warehouse. IEEE Transactions on Knowledge and Data Engineering 20 7 (2008) 976-991
47. T. Priebe, G. Pernul, A pragmatic approach to conceptual modeling of OLAP security, in: Proceedings of the Twentieth International Conference on Conceptual Modeling, 2001, pp. 311-324.
48. M. Rafanelli, F. Ricci, Proposal of a logical model for statistical databases, in: Proceedings of the 2nd International Workshop on Statistical and Scientific Database Management, 1983, pp. 264-272.
49. M. Rafanelli, A. Shoshani, STORM: a statistical object representation model, in: Proceedings of the 5th Conference on Statistical and Scientific Database Management, 1990, pp. 14-29.
50. A. Renner, XML data and object databases: a perfect couple? in: Proceedings of the Seventeenth International Conference on Data Engineering, 2001, pp. 143-148.
51. M.T. Roth, M. Arya, L.M. Haas, M.J. Carey, W.F. Cody, R. Fagin, P.M. Schwarz, J. Thomas II, E.L. Wimmers, The garlic project, in: Proceedings of the ACM SIGMOD Conference, 1996, p. 557.
52. Sheth A.P., and Larson J.A. Federated database systems for managing distributed, heterogeneous, and autonomous databases. Computing Surveys 22 3 (1990) 183-236
53. C. Thomsen, T.B. Pedersen, W. Lehner, RiTE: providing on-demand data for right-time data warehousing, in: Proceedings of the Twentyfourth International Conference on Data Engineering, 2008, pp. 456-465.
54. Thomsen E. OLAP Solutions: Building Multidimensional Information Systems (1997), Wiley
55. Transaction Processing Council, The TPC-R Benchmark, , Current as of October 30, 2008.
56. Vassiliadis P., and Sellis T. A survey of logical models for OLAP databases. SIGMOD Record 28 4 (1999) 64-69
57. J. Widom, Research problems in data warehousing, in: Proceedings of the Fourth International Conference on Information and Knowledge Management, 1995, pp. 25-30.
58. World Health Organization, International Classification of Diseases (ICD-10), Tenth Revision, 1992.
59. World Wide Web Consortium (W3C), Extensible Markup Language (XML), , Current as of October 30, 2008.
60. W3C, XQuery 1.0: an XML query language, , Current as of October 30, 2008.
61. Yin X., and Pedersen T.B. Evaluating XML-extended OLAP queries based on a physical algebra. Journal of Database Management 17 2 (2006) 84-114
62. X. Yin, T.B. Pedersen, Algebra-based optimization of XML-extended OLAP queries, in: Proceedings of the Thirteenth International Conference on Management of Data, 2006, pp. 197-200.
63. X. Yin, T.B. Pedersen, Algebra-based optimization of XML-extended OLAP queries, DB Tech Report No. 17, Department of Computer Science, Aalborg University, , 2006, 52 p.