Multidimensional databases and data warehousing

  • 0 Ratings
  • 0 Want to read
  • 0 Currently reading
  • 0 Have read
Not in Library

My Reading Lists:

Create a new list

Check-In

×Close
Add an optional check-in date. Check-in dates are used to track yearly reading goals.
Today

  • 0 Ratings
  • 0 Want to read
  • 0 Currently reading
  • 0 Have read

Buy this book

Last edited by ImportBot
December 20, 2023 | History

Multidimensional databases and data warehousing

  • 0 Ratings
  • 0 Want to read
  • 0 Currently reading
  • 0 Have read

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.

Publish Date
Language
English
Pages
95

Buy this book

Previews available in: English

Edition Availability
Cover of: Multidimensional databases and data warehousing
Multidimensional databases and data warehousing
2010, Morgan & Claypool, Morgan & Claypool Publishers
electronic resource / in English

Add another edition?

Book Details


Table of 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.

Edition Notes

Part of: Synthesis digital library of engineering and computer science.

Series from website.

Includes bibliographical references (p. 83-90) and index.

Abstract freely available; full-text restricted to subscribers or individual document purchasers.

Also available in print.

Mode of access: World Wide Web.

System requirements: Adobe Acrobat Reader.

Published in
San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA)
Series
Synthesis lectures on data management -- # 9
Other Titles
Synthesis digital library of engineering and computer science.

Classifications

Dewey Decimal Class
658.40380285574
Library of Congress
QA76.9.D37 J455 2010, QA76.9.D3 J46 2010

The Physical Object

Format
[electronic resource] /
Number of pages
95

ID Numbers

Open Library
OL27076149M
Internet Archive
multidimensional00jens
ISBN 13
9781608455386, 9781608455379
OCLC/WorldCat
658158030

Community Reviews (0)

Feedback?
No community reviews have been submitted for this work.

Lists

This work does not appear on any lists.

History

Download catalog record: RDF / JSON
December 20, 2023 Edited by ImportBot import existing book
July 5, 2019 Created by MARC Bot import new book