Data warehouse design : modern principles and methodologies / Matteo Golfarelli, Stefano Rizzi ; translated by Claudio Pagliarani.

By:

Golfarelli, Matteo

Contributor(s):

Rizzi, Stefano

Material type: Text

TextPublication details: New Delhi : New York : McGraw-Hill, c2009.Description: xxi, 458 p. : ill. ; 24 cmISBN:

9780071610391
9780070677524
0071610391 (alk. paper)

Uniform titles:

Data warehouse. English

Subject(s):

DDC classification:

005.745 22 GOL

Contents:

Introduction to data warehousing -- Data warehouse system lifecycle -- Analysis and reconciliation of data sources -- User requirement analysis -- Conceptual modeling -- Conceptual design -- Workload and data volume -- Logical modeling -- Logical design -- Data-staging design -- Indexes for the data warehouse -- Physical design -- Data warehouse project documentation -- A case study -- Business intelligence : beyond the data warehouse.

Summary: "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 approachesCreate a reconciled database to boost data mart architectureCapture and expressively represent end-user requirementsBuild a conceptual data mart schema using the Dimensional Fact ModelEstimate data mart volume and workloadImprove performance using advanced logical modeling techniquesExtract, transform, cleanse, and load data from operational sourcesUse sophisticated indexing techniques to optimize query execution plansComprehensively document data warehouse projectsDiscover innovative business intelligence techniques"

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
General Books	CUTN Central Library Generalia	Non-fiction	005.745 GOL (Browse shelf(Opens below))	Available		33096

Introduction to data warehousing --
Data warehouse system lifecycle --
Analysis and reconciliation of data sources --

User requirement analysis --

Conceptual modeling --

Conceptual design --

Workload and data volume --

Logical modeling --

Logical design --

Data-staging design --

Indexes for the data warehouse --

Physical design --

Data warehouse project documentation --

A case study --

Business intelligence : beyond the data warehouse.

Includes bibliographical references (p. 429-443) and 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 approachesCreate a reconciled database to boost data mart architectureCapture and expressively represent end-user requirementsBuild a conceptual data mart schema using the Dimensional Fact ModelEstimate data mart volume and workloadImprove performance using advanced logical modeling techniquesExtract, transform, cleanse, and load data from operational sourcesUse sophisticated indexing techniques to optimize query execution plansComprehensively document data warehouse projectsDiscover innovative business intelligence techniques"

There are no comments on this title.

to post a comment.