| Description |
1 online resource (xiii, 95 pages) : illustrations |
| Series |
Synthesis lectures on data management, 2153-5426 ; #9 |
|
Synthesis lectures on data management ; #9.
|
| Contents |
1. Introduction -- Multidimensional data management -- Multidimensional history -- Related terminology -- Shortcomings of spreadsheets and relations -- OLAP versus OLTP |
| 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 |
| Analysis |
multidimensional database |
|
multidimensional model |
|
data warehouse |
|
data cube |
|
dimension |
|
dimension hierarchy |
|
multidimensional fact and measure |
|
star schema |
|
relational OLAP |
|
SQL |
|
MDX |
|
complex dimension |
|
materialized view |
|
bitmap index |
|
join index |
| Bibliography |
Includes bibliographical references (pages 83-90) and index |
| Subject |
Multidimensional databases.
|
|
Data warehousing.
|
|
BUSINESS & ECONOMICS -- Information Management.
|
|
BUSINESS & ECONOMICS -- Knowledge Capital.
|
|
Data warehousing
|
|
Multidimensional databases
|
| Form |
Electronic book
|
| Author |
Pedersen, Torben Bach.
|
|
Thomsen, Christian, 1979-
|
| ISBN |
9781608455386 |
|
1608455386 |
|
1608455378 |
|
9781608455379 |
|
9783031018411 |
|
3031018419 |
|
