Managing Complex Multidimensional Data

Multidimensional database concepts such as cubes, dimensions with hierarchies, and measures are a cornerstone of business intelligence. However, the standard data models and system implementations (OLAP) for multidimensional databases are sometimes not able to capture the complexities of advanced real-world application domains. This lecture will focus on how to manage such complex multidimensional data, including complex dimension hierarchies, complex measures, and integration of multidimensional data with complex external data. We will look at how complex multidimensional data emerge in complex application domains such as medical data, location-based services, music data, web data, and text data, and present solutions for these domains that support multidimensional business intelligence.

[1]  Torben Bach Pedersen,et al.  Integrating XML Data in the TARGITOLAP System , 2004, ICDE.

[2]  Torben Bach Pedersen,et al.  Fuzzy Song Sets for Music Warehouses , 2007, ISMIR.

[3]  Jim Melton,et al.  SQL standardization: the next steps , 2000, SGMD.

[4]  Alberto O. Mendelzon,et al.  Temporal Queries in OLAP , 2000, VLDB.

[5]  Torben Bach Pedersen,et al.  Using Fuzzy Lists for Playlist Management , 2008, MMM.

[6]  Torben Bach Pedersen,et al.  Incomplete Information in Multidimensional Databases , 2003, Multidimensional Databases.

[7]  Christian S. Jensen,et al.  A foundation for capturing and querying complex multidimensional data , 2001, Inf. Syst..

[8]  Markus Sinnwell,et al.  Datawarehousing Has More Colours Than Just Black & White , 1999, VLDB.

[9]  Torben Bach Pedersen,et al.  Position list word aligned hybrid: optimizing space and performance for compressed bitmaps , 2010, EDBT '10.

[10]  Wolfgang Lehner,et al.  A Redundancy-Based Optimization Approach for Aggregation in Multidimensional Scientific and Atatistical Databases , 1997, DASFAA.

[11]  Esteban Zimányi,et al.  What Is Spatio-Temporal Data Warehousing? , 2009, DaWaK.

[12]  Sebastian Maneth,et al.  Efficient Memory Representation of XML Documents , 2005, DBPL.

[13]  Laks V. S. Lakshmanan,et al.  What can Hierarchies do for Data Warehouses? , 1999, VLDB.

[14]  Esteban Zimányi,et al.  Hierarchies in a multidimensional model: From conceptual modeling to logical representation , 2006, Data Knowl. Eng..

[15]  Torben Bach Pedersen,et al.  Contextualizing data warehouses with documents , 2008, Decis. Support Syst..

[16]  Torben Bach Pedersen,et al.  High-Level Audio Features: Distributed Extraction and Similarity Search , 2008, ISMIR.

[17]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[18]  Omar Boussaïd,et al.  Multidimensional Modeling of Complex Data , 2009, Encyclopedia of Data Warehousing and Mining.

[19]  Torben Bach Pedersen,et al.  R-Cubes: OLAP Cubes Contextualized with Documents , 2007, 2007 IEEE 23rd International Conference on Data Engineering.

[20]  Torben Bach Pedersen,et al.  A Data and Query Model for Dynamic Playlist Generation , 2007, 2007 IEEE 23rd International Conference on Data Engineering Workshop.

[21]  Torben Bach Pedersen.  Warehousing The World: A Vision for Data Warehouse Research , 2009, New Trends in Data Warehousing and Data Analysis.

[22]  Arie Shoshani,et al.  STORM: A Statistical Object Representation Model , 1990, IEEE Data Eng. Bull..

[23]  Curtis E. Dyreson,et al.  Information Retrieval from an Incomplete Data Cube , 1996, VLDB.

[24]  Torben Bach Pedersen,et al.  Extending Practical Pre-Aggregation in On-Line Analytical Processing , 1999, VLDB.

[25]  Wenfei Fan,et al.  Keys with Upward Wildcards for XML , 2001, DEXA.

[26]  Luca Cabibbo,et al.  Querying Multidimensional Databases , 1997, DBPL.

[27]  Torben Bach Pedersen,et al.  Integrating Data Warehouses with Web Data: A Survey , 2008, IEEE Transactions on Knowledge and Data Engineering.

[28]  Erick Thomsen,et al.  Microsoft? OLAP Solutions , 1999 .

[29]  Matthieu Guillaumin,et al.  Combining Image-Level and Segment-Level Models for Automatic Annotation , 2012, MMM.

[30]  Alberto O. Mendelzon,et al.  Capturing summarizability with integrity constraints in OLAP , 2005, TODS.

[31]  Torben Bach Pedersen,et al.  Multidimensional data modeling for complex data , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[32]  Torben Bach Pedersen,et al.  Research challenges for cloud intelligence: invited talk , 2010, EDBT '10.

[33]  Erik Thomsen,et al.  OLAP Solutions - Building Multidimensional Information Systems , 1997 .

[34]  Torben Bach Pedersen,et al.  Effective Bitmap Indexing for Non-metric Similarities , 2010, DEXA.

[35]  José Samos,et al.  YAM2: a multidimensional conceptual model extending UML , 2006, Inf. Syst..

[36]  George Spofford,et al.  MDX Solutions With Microsoft SQL Server Analysis Services 2005 And Hyperion Essbase , 2001 .

[37]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[38]  Nectaria Tryfona,et al.  Pre-aggregation in Spatial Data Warehouses , 2001, SSTD.

[39]  Torben Bach Pedersen,et al.  3XL: Supporting efficient operations on very large OWL Lite triple-stores , 2011, Inf. Syst..

[40]  Wolfgang Lehner,et al.  Modelling Large Scale OLAP Scenarios , 1998, EDBT.

[41]  Anindya Datta,et al.  A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases , 2001, Inf. Syst. Res..

[42]  Maurizio Rafanelli.  Multidimensional Databases: Problems and Solutions , 2003 .

[43]  Torben Bach Pedersen,et al.  A relevance-extended multi-dimensional model for a data warehouse contextualized with documents , 2005, DOLAP '05.

[44]  Christian S. Jensen,et al.  Clinical Data Warehousing - A Survey , 1998 .

[45]  Torben Bach Pedersen,et al.  A Survey of Open Source Tools for Business Intelligence , 2009, Int. J. Data Warehous. Min..

[46]  Torben Bach Pedersen,et al.  XML-extended OLAP querying , 2002, Proceedings 14th International Conference on Scientific and Statistical Database Management.

[47]  Torben Bach Pedersen,et al.  Research issues in clinical data warehousing , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[48]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[49]  Panos Vassiliadis,et al.  Modeling multidimensional databases, cubes and cube operations , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[50]  Torben Bach Pedersen,et al.  MIRABEL DW: Managing Complex Energy Data in a Smart Grid , 2012, DaWaK.

[51]  Isidro Ramos,et al.  Advances in Database Technology — EDBT'98 , 1998, Lecture Notes in Computer Science.

[52]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[53]  David Mason,et al.  Encyclopedia of Data Warehousing and Mining, 2nd ed. , 2009 .

[54]  Torben Bach Pedersen,et al.  The decoration operator: a foundation for on-line dimensional data integration , 2004, Proceedings. International Database Engineering and Applications Symposium, 2004. IDEAS '04..

[55]  Chang Li,et al.  A data model for supporting on-line analytical processing , 1996, CIKM '96.

[56]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[57]  Arie Shoshani,et al.  Summarizability in OLAP and statistical data bases , 1997, Proceedings. Ninth International Conference on Scientific and Statistical Database Management (Cat. No.97TB100150).

[58]  Torben Bach Pedersen,et al.  A Hybrid Approach to Web Usage Mining , 2002, DaWaK.