Data Modelling Book

[Steve Bennett]

I just read a post on a CORTEX blog about a book that sounds interesting for data miners. Many thanks to Arthur for the post. Here are the details: The Multidimensional Data Modeling Toolkit By John Paredes, OLAP World Press (March 1, 2009), 330 pages, US$47 from Amazon, ISBN: 978-0981775302 Table of Contents Part I: Preparing for the Journey Oveview What is OLAP? What is the Oracle OLAP DML? Pit Stop: Working with Analytic Workspaces Part II: Mastering Dimensions Creating Dimensions Describing Dimension Members with Labels Categorizing Dimension Members with Attributes Organizing Dimension Members into Hierarchies Unnatural, Ragged, and Other Hierarchy Variations Part III: Designing Multidimensional Data Storing Multidimensional Data in the Analytic Workspace Calculating Data On-the-Fly Filtering, Relationships, and Combinations Working with Sets Aggregations Part IV: Graphical User Interfaces for OLAP Exploring Metadata The Star Schema and Beyond Selectors Part V: OLAP DML Programming Writing DML Programs Programs for Getting Data In and Out of an Analytic Workspace Tune Up: Working with Analytic Workspaces Part VI: Analytical Alchemy Design Principles for Creating Multidimensional Information Migration Analysis: Showing Changes in Customer Choices The Relationship between OLAP, Statistics, and Data Mining Available on Amazon or directly from the author as an ebook. The book has been written from an Oracle 10g perspective but from what I can gather online most of the content is relevant for any RDBMS.

Get More from the original blog...