Synopsis
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
"synopsis" may belong to another edition of this title.
About the Author
Christopher Adamson is the founder of Oakton Software LLC and a faculty member at The Data Warehousing Institute. He works with customers in all industries to establish data warehousing strategies, define and prioritize projects, and design solutions. Chris has taught dimensional design to thousands of students worldwide, and has written numerous books and articles.
"About this title" may belong to another edition of this title.
Search results for Star Schema The Complete Reference
Stock Image
Star Schema The Complete Reference
Published by
McGraw Hill (edition 1), 2010
ISBN 10: 0071744320
ISBN 13: 9780071744324
Used
Paperback
Seller: BooksRun, Philadelphia, PA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. 1. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting. Seller Inventory # 0071744320-11-1
Seller Image
Star Schema : The Complete Reference
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 9127812-n
Seller Image
Star Schema (Paperback or Softback)
Published by
McGraw-Hill/Osborne Media 7/28/2010, 2010
ISBN 10: 0071744320
ISBN 13: 9780071744324
New
Paperback or Softback
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Seller rating 5 out of 5 stars
Paperback or Softback. Condition: New. Star Schema. Book. Seller Inventory # BBS-9780071744324
Stock Image
Star Schema - The Complete Reference
Seller: medimops, Berlin, Germany
Seller rating 5 out of 5 stars
Condition: good. Befriedigend/Good: Durchschnittlich erhaltenes Buch bzw. Schutzumschlag mit Gebrauchsspuren, aber vollständigen Seiten. / Describes the average WORN book or dust jacket that has all the pages present. Seller Inventory # M00071744320-G
Stock Image
Star Schema The Complete Reference
Published by
McGraw-Hill Osborne Media, 2010
ISBN 10: 0071744320
ISBN 13: 9780071744324
Used
Paperback
Seller: Brit Books, Milton Keynes, United Kingdom
Seller rating 4 out of 5 stars
Paperback. Condition: Used; Very Good. ***Simply Brit*** Welcome to our online used book store, where affordability meets great quality. Dive into a world of captivating reads without breaking the bank. We take pride in offering a wide selection of used books, from classics to hidden gems, ensuring there is something for every literary palate. All orders are shipped within 24 hours and our lightning fast-delivery within 48 hours coupled with our prompt customer service ensures a smooth journey from ordering to delivery. Discover the joy of reading with us, your trusted source for affordable books that do not compromise on quality. Seller Inventory # 4387245
Buy Used
£ 19.24
£ 15.99 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
Star Schema The Complete Reference
Seller: California Books, Miami, FL, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. Seller Inventory # I-9780071744324
Stock Image
Star Schema The Complete Reference
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GB-9780071744324
Stock Image
Star Schema The Complete Reference
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 4 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GB-9780071744324
Buy New
£ 30.53
£ 6.76 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Seller Image
Star Schema : The Complete Reference
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 9127812
Stock Image
Star Schema The Complete Reference (Paperback)
Published by
McGraw-Hill Education - Europe, New York, 2010
ISBN 10: 0071744320
ISBN 13: 9780071744324
New
Paperback
Seller: Grand Eagle Retail, Bensenville, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The definitive guide to dimensional design for your data warehouseLearn 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 processingIdentify situations that call for multiple stars or cubesEnsure compatibility across subject areas as your data warehouse growsAccommodate repeating attributes, recursive hierarchies, and poor data qualitySupport conflicting requirements for historic dataHandle variation within a business process and correlation of disparate activitiesBoost performance using derived schemas and aggregatesLearn when it's appropriate to adjust designs for BI and ETL tools Filled with expert techniques and best practices, this comprehensive guide helps you unleash the full potential of data warehouses, regardless of architecture, implementation scope, or software tools. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9780071744324