The Data Warehouse Toolkit

Ralph Kimball 지음

Wiley 2013년 07월 01일 출간

작품소개

책소개

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!The first edition of Ralph Kimball'sThe Data Warehouse Toolkitintroduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligenceBegins with fundamental design recommendations and progresses through increasingly complex scenariosPresents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and moreDesign dimensional databases that are easy to understand and provide fast query response withThe Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

목차

Introduction xxvii1 Data Warehousing, Business Intelligence, and Dimensional Modeling Primer 1&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&Different Worlds of Data Capture and Data Analysis 2Goals of Data Warehousing and Business Intelligence 3Publishing Metaphor for DW/BI Managers 5Dimensional Modeling Introduction 7Star Schemas Versus OLAP Cubes 8Fact Tables for Measurements 10Dimension Tables for Descriptive Context 13Facts and Dimensions Joined in a Star Schema 16Kimball&'s DW/BI Architecture 18Operational Source Systems 18Extract, Transformation, and Load System 19Presentation Area to Support Business Intelligence 21Business Intelligence Applications 22Restaurant Metaphor for the Kimball Architecture 23Alternative DW/BI Architectures 26Independent Data Mart Architecture 26Hub-and-Spoke Corporate Information Factory Inmon Architecture 28Hybrid Hub-and-Spoke and Kimball Architecture 29Dimensional Modeling Myths 30Myth 1: Dimensional Models are Only for Summary Data 30Myth 2: Dimensional Models are Departmental, Not Enterprise 31Myth 3: Dimensional Models are Not Scalable 31Myth 4: Dimensional Models are Only for Predictable Usage 31Myth 5: Dimensional Models Can&'t Be Integrated 32More Reasons to Think Dimensionally 32Agile Considerations 34Summary2 Kimball Dimensional Modeling Techniques Overview 37Fundamental Concepts 37Gather Business Requirements and Data Realities 37Collaborative Dimensional Modeling Workshops 38Four-Step Dimensional Design Process 38Business Processes 39Grain 39Dimensions for Descriptiv

작가정보

저자(글) Ralph Kimball

저자 :

저자 :

저자 :

저자 :

저자 :
저자 :
저자 :
RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996.MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for more than 30 years.