Star Schema The Complete Reference

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales.

Star Schema The Complete Reference

Star Schema The Complete Reference

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts. This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology. Master the fundamentals of star schema design and slow change processing Identify situations that call for multiple stars or cubes Ensure compatibility across subject areas as your data warehouse grows Accommodate repeating attributes, recursive hierarchies, and poor data quality Support conflicting requirements for historic data Handle variation within a business process and correlation of disparate activities Boost performance using derived schemas and aggregates Learn when it's appropriate to adjust designs for BI and ETL tools

More Books:

Star Schema The Complete Reference
Language: en
Pages: 510
Authors: Christopher Adamson
Categories: Computers
Type: BOOK - Published: 2010-07-22 - Publisher: McGraw Hill Professional

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a
Star Schema The Complete Reference
Language: en
Pages: 510
Authors: Christopher Adamson
Categories: Computers
Type: BOOK - Published: 2010-07-28 - Publisher: McGraw-Hill Education

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a
The Star Schema Handbook
Language: en
Pages: 408
Authors: Christopher Adamson
Categories: Computers
Type: BOOK - Published: 2009-10-02 - Publisher: John Wiley and Sons

The first comprehensive handbook on star schema design The Star Schema Handbook is a comprehensive guide to dimensional modeling covering both basic and advanced topics. Organized around technical concepts rather than business examples, this is the perfect resource for data warehouse designers or developers. The book is architecture-neutral, providing full
Database Design and Relational Theory
Language: en
Pages: 451
Authors: C. J. Date
Categories: Computers
Type: BOOK - Published: 2019-12-12 - Publisher: Apress

Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems. This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is
Database and Expert Systems Applications
Language: en
Pages: 521
Authors: Sven Hartmann, Hui Ma, Abdelkader Hameurlain, Günther Pernul, Roland R. Wagner
Categories: Computers
Type: BOOK - Published: 2018-08-20 - Publisher: Springer

This two volume set of LNCS 11029 and LNCS 11030 constitutes the refereed proceedings of the 29th International Conference on Database and Expert Systems Applications, DEXA 2018, held in Regensburg, Germany, in September 2018. The 35 revised full papers presented together with 40 short papers were carefully reviewed and selected

Popular All Time

Rich Dad Poor Dad
A People's Guide to Capitalism
Atomic Habits
Deep Work
Rich Dad Poor Dad
Think Again
Getting to Yes
The Intelligent Investor, Rev. Ed
Extreme Ownership
The Scout Mindset
Get Good with Money
Dead Companies Walking
The 10X Rule
The Richest Man in Babylon
Never Split the Difference
Start with Why
Outliers
Lives of the Stoics