Multidimensional Databases and Data Warehousing

The present book's subject is multidimensional data models and data modeling concepts as they are applied in real data warehouses. The book aims to present the most important concepts within this subject in a precise and understandable manner. The book's coverage of fundamental concepts includes data cubes and their elements, such as dimensions, facts, and measures and their representation in a relational setting; it includes architecture-related concepts; and it includes the querying of multidimensional databases. The book also covers advanced multidimensional concepts that are considered to be particularly important. This coverage includes advanced dimension-related concepts such as slowly changing dimensions, degenerate and junk dimensions, outriggers, parent-child hierarchies, and unbalanced, non-covering, and non-strict hierarchies. The book offers a principled overview of key implementation techniques that are particularly important to multidimensional databases, including materialized views, bitmap indices, join indices, and star join processing. The book ends with a chapter that presents the literature on which the book is based and offers further readings for those readers who wish to engage in more in-depth study of specific aspects of the book's subject. Table of Contents: Introduction / Fundamental Concepts / Advanced Concepts / Implementation Issues / Further Readings

[1]  Dimpi Srivastava,et al.  ERP Systems , 2010 .

[2]  Bart Kuijpers,et al.  A Survey of Spatio-Temporal Data Warehousing , 2009, Int. J. Data Warehous. Min..

[3]  Jaroslav Pokorný.  Modelling stars using XML , 2001, DOLAP '01.

[4]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[5]  Beate List,et al.  Striving towards Near Real-Time Data Integration for Data Warehouses , 2002, DaWaK.

[6]  Matteo Golfarelli,et al.  A Survey on Temporal Data Warehousing , 2009, Int. J. Data Warehous. Min..

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

[8]  Wolfgang Lehner,et al.  Multi-objective scheduling for real-time data warehouses , 2009, Computer Science - Research and Development.

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

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

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

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

[13]  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).

[14]  Wolfgang Lehner,et al.  Partition-based workload scheduling in living data warehouse environments , 2009, Inf. Syst..

[15]  Thomas Armstrong,et al.  In Their Own Way , 1987 .

[16]  Arie Shoshani,et al.  Object-extended OLAP querying , 2009, Data Knowl. Eng..

[17]  Divyakant Agrawal.  The Reality of Real-Time Business Intelligence , 2008, BIRTE.

[18]  Raghu Ramakrishnan,et al.  Database Management Systems , 1976 .

[19]  Heikki Topi,et al.  Modern Database Management , 1999 .

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

[21]  Michael Alexander,et al.  Using Pivot Tables , 2011 .

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

[23]  Torben Bach Pedersen,et al.  Integrating XML data in the TARGIT OLAP system , 2004, Proceedings. 20th International Conference on Data Engineering.

[24]  Torben Bach Pedersen,et al.  Specifying OLAP Cubes on XML Data , 2004, Journal of Intelligent Information Systems.

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

[26]  Matteo Golfarelli.  Open Source BI Platforms: A Functional and Architectural Comparison , 2009, DaWaK.

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

[28]  Yvan Bédard,et al.  Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP) , 2001 .

[29]  Christian S. Jensen,et al.  Temporal Data Management , 1999, IEEE Trans. Knowl. Data Eng..

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

[31]  Philip Andrews.  The Next Level , 2007 .

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

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

[34]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

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

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

[37]  Jeffrey F. Naughton,et al.  Transaction Reordering and Grouping for Continuous Data Loading , 2006, BIRTE.

[38]  Kevin Wilkinson,et al.  Data integration flows for business intelligence , 2009, EDBT '09.

[39]  Christian S. Jensen,et al.  How Would You Like to Aggregate Your Temporal Data? , 2006, Thirteenth International Symposium on Temporal Representation and Reasoning (TIME'06).

[40]  Torben Bach Pedersen,et al.  Multidimensional Integrated Ontologies: A Framework for Designing Semantic Data Warehouses , 2009, J. Data Semant..

[41]  Torben Bach Pedersen,et al.  Probabilistic Data Modeling and Querying for Location-Based Data Warehouses , 2005, SSDBM.

[42]  Chetan Gupta,et al.  Leveraging web streams for contractual situational awareness in operational BI , 2010, EDBT '10.

[43]  Olaf R. P. Bininda-Emonds,et al.  Garbage in, Garbage out , 2004 .

[44]  Boris Vrdoljak,et al.  Data warehouse design from XML sources , 2001, DOLAP '01.

[45]  Torben Bach Pedersen,et al.  RiTE: Providing On-Demand Data for Right-Time Data Warehousing , 2008, 2008 IEEE 24th International Conference on Data Engineering.

[46]  W. H. Inmon,et al.  Dw 2.0: The Architecture for the Next Generation of Data Warehousing , 2008 .

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

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

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

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

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

[52]  Connolly,et al.  Database Systems , 2004 .

[53]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[54]  Torben Bach Pedersen,et al.  Supporting imprecision in multidimensional databases using granularities , 1999, Proceedings. Eleventh International Conference on Scientific and Statistical Database Management.

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

[56]  W. H. Inmon,et al.  Building the Operational Data Store , 1995 .

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

[58]  Alberto O. Mendelzon,et al.  Time in Multidimensional Databases , 2003, Multidimensional Databases.

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

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

[61]  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).

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

[63]  Alberto O. Mendelzon,et al.  A Temporal Query Language for OLAP: Implementation and a Case Study , 2001, DBPL.

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

[65]  Joann J. Ordille,et al.  Data integration: the teenage years , 2006, VLDB.

[66]  Christian S. Jensen,et al.  Semantics of Time-Varying Information , 1996, Inf. Syst..

[67]  Mark Sullivan,et al.  Quasi-cubes: exploiting approximations in multidimensional databases , 1997, SGMD.

[68]  Torben Bach Pedersen,et al.  What Can Hierarchies Do for Data Streams? , 2006, BIRTE.

[69]  Arie Shoshani,et al.  Statistical Databases: Characteristics, Problems, and some Solutions , 1982, VLDB.

[70]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[71]  Matteo Golfarelli,et al.  Data Warehouse Design: Modern Principles and Methodologies , 2009 .

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

[73]  Abraham Silberschatz,et al.  Database System Concepts , 1980 .

[74]  Christian S. Jensen,et al.  Systematic Change Management in Dimensional Data Warehousing , 1998 .

[75]  Raghu Ramakrishnan,et al.  Bottom-up computation of sparse and Iceberg CUBE , 1999, SIGMOD '99.

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

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

[78]  Donovan A. Schneider.  Practical Considerations for Real-Time Business Intelligence , 2006, BIRTE.

[79]  Peter Thanisch,et al.  Constructing an OLAP cube from distributed XML data , 2002, DOLAP '02.