Data Warehouse Design: Modern Principles and Methodologies
Produktdetaljer
Biografisk notat
Matteo Golfarelli is an associate professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in information systems, databases, and data mining.
Stefano Rizzi is a full professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in advanced information systems and software engineering.
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.
Foreword by Mark Stephen LaRow, Vice President of Products, MicroStrategy
"A unique and authoritative book that blends recent research developments with industry-level practices for researchers, students, and industry practitioners."Il-Yeol Song, Professor, College of Information Science and Technology, Drexel University
Chapter 2. Data Warehouse System Lifecycle
Chapter 3. Analysis and Reconciliation of Data Sources
Chapter 4. User Requirement Analysis
Chapter 5. Conceptual Modeling
Chapter 6. Conceptual Design
Chapter 7. Workload and Data Volume
Chapter 8. Logical Modeling
Chapter 9. Logical Design
Chapter 10. Data-staging Design
Chapter 11. Indexes for the Data Warehouse
Chapter 12. Physical Design
Chapter 13. Data Warehouse Project Documentation
Chapter 14. A Case Study
Chapter 15. Business Intelligence: Beyond the Data Warehouse
Glossary
Bibliography
Index
Plan, Design, and Document High-Performance Data Warehouses
Set up a reliable, secure decision-support infrastructure using the cuttingedge techniques contained in this comprehensive volume. Data Warehouse Design: Modern Principles and Methodologies presents a practical design approach based on solid software engineering principles. Find out how to interview end users, construct expressive conceptual schemata and translate them into relational schemata, and design state-of-the-art ETL procedures. You will also learn how to integrate heterogeneous data sources, implement star and snowflake schemata, manage dynamic and irregular hierarchies, and fine-tune performance by materializing and fragmenting views.
- Work with data- and requirement-driven methodological approaches
- Create a reconciled database to boost data mart architecture
- Capture and expressively represent end-user requirements
- Build a conceptual data mart schema using the Dimensional Fact Model
- Estimate data mart volume and workload
- Improve performance using advanced logical modeling techniques
- Extract, transform, cleanse, and load data from operational sources
- Use sophisticated indexing techniques to optimize query execution plans
- Comprehensively document data warehouse projects
- Discover innovative business intelligence techniques
Produktdetaljer
Biografisk notat
Matteo Golfarelli is an associate professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in information systems, databases, and data mining.
Stefano Rizzi is a full professor of Computer Science and Technology at the University of Bologna, Italy, where he teaches courses in advanced information systems and software engineering.