Definition
- The selection and design, the load from a star schema aggregates used in dimensional modeling of the first book to provide in-depth coverage and use for specific tasks and the results of demonstration projects
- Global navigation and basic design principles of a global and covers the advantages and disadvantages of different types of business solutions
- This development projects data storage throughout, including the growing importance of explaining development, first creates and loads the data from the iterative
Back cover
The first book
that offers in-depth coverage of the star maps overview
As the most
effective method for maximizing star schema performance Dubbed by Ralph Kimball
aggregates of dimensions more spectacular than any other technology is a
powerful and effective tool to accelerate data warehouse queries. Well
structured and implemented a database after verifying that it was built, the
overall performance of data storage must begin with the measures taken.
However, many
companies solve performance problems, rather than turn to aggregate custom
hardware and proprietary software products to ignore. This book fills a gap in
knowledge has led companies to costly and risky.
A series of
well-planned data warehouse expert Chris Adamson overall have a significant
effect on overall performance indicates that the data store. A role in avoiding
common pitfalls, or whatever the current level of star schema information, best
practices in this book, we will help you get an incredible performance
increase.
Collection
techniques have progressed from the database schema stars, tables, and the
impact of the life cycle of this book covers the entire data storage. The
approach of design data, including the warehouse star schema, after
establishing some key areas, the articles on shelf-life data of the main
phases. Topics are:
- The basic design principles of the global schema
- With or without the addition of a browser, how aggregate is used in a production environment
- Integration with ETL processing a total
- The standard tasks of development projects and data storage products that contain additives
- How overall existing star schema adds the ability to organize and execute a project
- The aggregation of bridge tables, stars such heterogeneous models or the instantaneous impact and plans advanced design
- Incorporate three-dimensional aggregates with life the views or IBM Oracle Implementation of special considerations query the tables
- How comprehensive, including security database and archiving strategy can add value in other areas
Wiley Publishing
Technology timely. Practice. Reliable.
Www.wiley.com /
compbooks / visit our website at
About the Author
Christopher
Adamson, data storage consultant and founder of Oakton Software LLC. Directed
and implemented a variety of industries, applications star schema data
warehouse, an expert in the design. Its clients Fortune 500 companies, small
and large businesses, government agencies and providers of data storage
devices, we have included. Dimensional Modeling and Data Warehouse Design
Solutions Adamson also (also from Wiley) teaches author. O, on its website, can
be reached through www.ChrisAdamson.net.
No comments:
Post a Comment