Star Schema The Complete Reference

Star Schema The Complete Reference, 9780071744324 (0071744320), McGraw-Hill, 2010

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

Comments

Amazing Books

Palliative and End of Life Care for Children and Young People: Home, Hospice, Hospital

John Wiley & Sons, 2012

“Anne’s contribution to our understanding of the needs of young people with cancer has been unparalleled and without her extraordinary insights our services would be that much poorer.” From the foreword by Simon Davies , CEO Teenage Cancer Trust

This topical and timely text provides valuable insights...

Practical DWR 2 Projects (Expert's Voice in Java)

Apress, 2008

The Ajax craze is sweeping the world, and there is no shortage of libraries from which to choose to make it all easier to develop. One of those libraries has risen near the top in the Java space, and that library is DWR. DWR, or Direct Web Remoting, allows you to treat your Java classes running on the server as if they were local objects running...

Finite Element Methods for Engineering Sciences: Theoretical Approach and Problem Solving Techniques

Springer, 2008

This self-tutorial offers a concise yet thorough grounding in the mathematics necessary for successfully applying FEMs to practical problems in science and engineering. The unique approach first summarizes and outlines the finite-element mathematics in general and then, in the second and major part, formulates problem examples that clearly...

Leadership Sopranos Style: How to Become a More Effective Boss

Dearborn Publishing, 2004

Conflicting loyalties. Terminations. A changing culture. New competitive threats. These phrases describe the challenges facing many of today's most successful businesses. They also describe the challenges facing another profitable organization-television's Soprano family. As the boss of the family, Tony Soprano knows the difficulties...

Principles of the Spin Model Checker

Springer, 2008

Principles of Spin is an introductory book, the only requirement is a background in programming. Spin models are written in the Promela language which is easily learned by students and programmers. Spin is easy to install and use.

The Spin model checker is not only a widely used professional tool but it is also a superb tool for teaching...

Java Regular Expressions: Taming the java.util.regex Engine

Apress, 2003

Java has always been an excellent language for working with objects. But Java’s text manipulation mechanisms have always been limited, compared to languages like AWK and Perl. On the flip side, a new regular expressions package in Java 2 Standard Edition (J2SE) brings hope to the Java text mechanisms. This package provides you...