Coverart for item
The Resource Multidimensional databases and data warehousing, Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen, (electronic book)

Multidimensional databases and data warehousing, Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen, (electronic book)

Label
Multidimensional databases and data warehousing
Title
Multidimensional databases and data warehousing
Statement of responsibility
Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen
Creator
Contributor
Subject
Language
eng
Summary
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
Member of
Cataloging source
CaBNvSL
http://library.link/vocab/creatorDate
1963-
http://library.link/vocab/creatorName
Jensen, Christian S.
Illustrations
illustrations
Index
index present
Literary form
non fiction
Nature of contents
  • dictionaries
  • abstracts summaries
  • bibliography
http://library.link/vocab/relatedWorkOrContributorDate
1979-
http://library.link/vocab/relatedWorkOrContributorName
  • Pedersen, Torben Bach.
  • Thomsen, Christian
Series statement
  • Synthesis digital library of engineering and computer science.
  • Synthesis lectures on data management
Series volume
9.
http://library.link/vocab/subjectName
  • Multidimensional databases
  • Data warehousing
Target audience
  • adult
  • specialized
Label
Multidimensional databases and data warehousing, Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen, (electronic book)
Instantiates
Publication
Bibliography note
Includes bibliographical references (p. 83-90) and index
Color
multicolored
Contents
  • 1. Introduction -- Multidimensional data management -- Multidimensional history -- Related terminology -- Shortcomings of spreadsheets and relations -- OLAP versus OLTP --
  • 2. Fundamental concepts -- Cubes -- Dimensions -- Facts -- Measures -- Relational representations -- Star schemas -- Snowflake schemas -- Data warehouses and data marts -- Multidimensional modeling processes -- Analysis and querying -- Roll-up, drill-down, and drill-out -- Slicing and dicing -- Drill-across -- Pivot tables -- Ranking -- Multidimensional querying in MDX and SQL -- Graphical querying and visualisations -- Summarizing example -- Exercises --
  • 3. Advanced concepts -- Slowly changing dimensions -- The problem -- Solutions -- Other special kinds of dimensions -- Minidimensions -- Outriggers -- Degenerate dimensions -- Junk dimensions -- Time dimensions -- Data quality dimensions -- Advanced hierarchies -- Parent-child hierarchies -- Unbalanced hierarchies -- Non-covering hierarchies -- Non-strict hierarchies -- Multiple hierarchies and parallel hierarchies -- Summarizability -- Summarizing example -- Exercises --
  • 4. Implementation issues -- Materialized views -- Indexing -- Indexing overview -- Bitmap indices -- Join indices -- Query processing -- OLAP implementations -- Extract-transform-load -- Exercises --
  • 5. Further readings -- Background readings -- Advanced topics -- Software resources -- References -- Authors' biographies -- Index
Dimensions
unknown
Extent
1 electronic text (xiii, 95 p. : ill.)
File format
multiple file formats
Form of item
electronic
Isbn
9781608455386
Issn
2153-5426
Other physical details
digital file.
Reformatting quality
access
Specific material designation
remote
System details
System requirements: Adobe Acrobat Reader
Label
Multidimensional databases and data warehousing, Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen, (electronic book)
Publication
Bibliography note
Includes bibliographical references (p. 83-90) and index
Color
multicolored
Contents
  • 1. Introduction -- Multidimensional data management -- Multidimensional history -- Related terminology -- Shortcomings of spreadsheets and relations -- OLAP versus OLTP --
  • 2. Fundamental concepts -- Cubes -- Dimensions -- Facts -- Measures -- Relational representations -- Star schemas -- Snowflake schemas -- Data warehouses and data marts -- Multidimensional modeling processes -- Analysis and querying -- Roll-up, drill-down, and drill-out -- Slicing and dicing -- Drill-across -- Pivot tables -- Ranking -- Multidimensional querying in MDX and SQL -- Graphical querying and visualisations -- Summarizing example -- Exercises --
  • 3. Advanced concepts -- Slowly changing dimensions -- The problem -- Solutions -- Other special kinds of dimensions -- Minidimensions -- Outriggers -- Degenerate dimensions -- Junk dimensions -- Time dimensions -- Data quality dimensions -- Advanced hierarchies -- Parent-child hierarchies -- Unbalanced hierarchies -- Non-covering hierarchies -- Non-strict hierarchies -- Multiple hierarchies and parallel hierarchies -- Summarizability -- Summarizing example -- Exercises --
  • 4. Implementation issues -- Materialized views -- Indexing -- Indexing overview -- Bitmap indices -- Join indices -- Query processing -- OLAP implementations -- Extract-transform-load -- Exercises --
  • 5. Further readings -- Background readings -- Advanced topics -- Software resources -- References -- Authors' biographies -- Index
Dimensions
unknown
Extent
1 electronic text (xiii, 95 p. : ill.)
File format
multiple file formats
Form of item
electronic
Isbn
9781608455386
Issn
2153-5426
Other physical details
digital file.
Reformatting quality
access
Specific material designation
remote
System details
System requirements: Adobe Acrobat Reader

Library Locations

Processing Feedback ...