Multidimensional Databases(c) Problems and Solutions

Multidimensional Databases: Problems and Solutions

ISBN: 1591400538
EAN: 2147483647

Year: 2003
Pages: 150

Authors: Maurizio Rafanelli

BUY ON AMAZON

Table of Contents
BackCover
Multidimensional Databases--Problems and Solutions
Foreword
Preface
Chapter I: Basic Notions
THE MULTIDIMENSIONAL AGGREGATE DATA STRUCTURE
DIFFERENT USE OF MULTIDIMENSIONAL DATA: OLAP APPLICATIONS
MULTIDIMENSIONAL AGGREGATE DATA
REPRESENTING AND INTERPRETING NULLS IN MULTIDIMENSIONAL AGGREGATE DATA
GRAPH MODELS
REFERENCES
Chapter II: Multidimensionality in Statistical, OLAP, and Scientific Databases
SUMMARY DATABASES
SCIENTIFIC MULTIDIMENSIONAL DATABASES
REFERENCES
Chapter III: Conceptual Multidimensional Models
BACKGROUND AND TERMINOLOGY
A CONCEPTUAL MULTIDIMENSIONAL MODEL
AN OVERVIEW OF MULTIDIMENSIONAL DATA MODELS
FUTURE TRENDS AND CONCLUSIONS
REFERENCES
Chapter IV: Hierarchies
CHARACTERIZATION OF HIERARCHIES
CHARACTERIZATION OF OLAP OPERATORS ON HIERARCHIES
AN ENLARGEMENT OF OPERATORS FOR HIERARCHIES
CONCLUSIONS
REFERENCES
Chapter V: Operators for Multidimensional Aggregate Data
OPERATORS FOR MULTIDIMENSIONAL AGGREGATE DATA WHICH EXTEND RELATIONAL ALGEBRA AND RELATIONAL CALCULUS
OPERATORS FOR MULTIDIMENSIONAL AGGREGATE DATA DEFINED IN A TABULAR ENVIRONMENT
OPERATORS FOR OLAP APPLICATIONS
THE BASIC ALGEBRA FOR MULTIDIMENSIONAL AGGREGATE DATA
SUMMARIZATION
MACRO-UNION
MACRO-SELECT
RESTRICTION
RECLASSIFICATION
COMPARISON
ROLL-UP
GROUP-BY
DRILL-DOWN
PUSH
PULL
DATA CUBE
AGGREGATE FORMATION
AGGREGATION-BY-TEMPLATE
PACK
UNPACK
DIFFERENCE
DUPLICATE REMOVAL
SQL-LIKE AGGREGATION
JOIN
FOLD
UNFOLD
REFERENCES
Chapter VI: Time in Multidimensional Databases
EXAMPLE
BACKGROUND
THE TEMPORAL MULTIDIMENSIONAL MODEL
CONCLUSION
REFERENCES
ENDNOTES
Chapter VII: Dynamic Multidimensional Data Cubes
BACKGROUND
DATA CUBES FOR INVERTIBLE AGGREGATE OPERATORS
DATA CUBES FOR OTHER AGGREGATE OPERATORS
SPARSE DATA SETS
THE DATA CUBE OPERATOR CUBE
CONCLUSIONS AND FUTURE TRENDS
ACKNOWLEDGMENTS
REFERENCES
Chapter VIII: Materialized Views in Multidimensional Databases
MATERIALIZED VIEWS
MULTIDIMENSIONAL DATABASES
MAINTENANCE OF MATERIALIZED VIEWS
FINDING THE OPTIMAL SET OF MATERIALIZATIONS
COMMERCIAL SOLUTIONS
CONCLUSIONS
REFERENCES
Chapter IX: Querying Multidimensional Data
BACKGROUND
KEY FEATURES OF MULTIDIMENSIONAL QUERYING
QUERY LANGUAGES BASED ON MULTIDIMENSIONAL MODELS
MULTIDIMENSIONAL QUERY EVALUATION
CONCLUSIONS
REFERENCES
Chapter X: Incomplete Information in Multidimensional Databases
BACKGROUND
INCOMPLETE INFORMATION IN DATABASE MANAGEMENT SYSTEMS
INCOMPLETE INFORMATION IN MULTIDIMENSIONAL DATABASES
TECHNIQUES FOR HANDLING INCOMPLETENESS
INCOMPLETE MEASURES
INCOMPLETE GROUPING ATTRIBUTES
INCOMPLETE INFORMATION IN THE HIERARCHY
INCOMPLETE METADATA
FUTURE TRENDS
CONCLUSION
REFERENCES
Chapter XI: Privacy in Multidimensional Databases
ADDITIVE QUERIES
THE USER S INFERENCE MODEL
GRAPHICAL QUERY SETS
SAFETY
AN AUDITING PROCEDURE
TWO-DIMENSIONAL TABLES
FUTURE DIRECTIONS
CONCLUSIONS
REFERENCES
Chapter XII: Source Integration for Data Warehousing
BACKGROUND
SCHEMA INTEGRATION
DATA INTEGRATION
DATA CLEANING AND RECONCILIATION
CONCLUSIONS
REFERENCES
Chapter XIII: Cooperation with Geographic Databases
FUNDAMENTAL CHARACTERISTICS OF GEOGRAPHIC DATABASES
BASIC NOTIONS
MULTIDIMENSIONAL DATA
RELATED WORKS
COOPERATION BY BINDING ELEMENTS
INFERRING BINDING ATTRIBUTES
CONCLUSIONS
REFERENCES
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I-J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
List of Figures
List of Tables
List of Sidebars