My Wish Lists Login / Join

Connecting the Data

Data Integration Techniques for Building an Operational Data Store (ODS)

By: Angelo R Bobak

Write A Review

Paperback | 15 October 2012

At a Glance

Paperback
244 Pages

Dimensions(cm)
24.7 x 20.2 x 1.5

Paperback

RRP $65.99

$59.75

or 4 interest-free payments of $14.94 with

Ships in 5 to 7 business days

Business data integration is a complex problem that must be solved when organizations change or enhance their internal structures. The goal of this book is to present a simple yet thorough resource that describes the challenges of business data integration and the solutions to these challenges such as schema integration, illustrated through an Operational Data Store (ODS) case study.

This book contains three sections spanning ten chapters. Section I, Foundational Concepts, will provide you with the necessary basic concepts and discuss schema integration. Section II, Preparation and Design, introduces the case study and we will reverse engineer each of the data sources to create a set of data dictionary reports which will provide us with the meta data we need to apply the schema integration process. Section III, Physical Implementation, will present scripts to populate each of the source databases and spreadsheets and use reports to create Extract, Transform, and Load (ETL) specifications. The ten chapters within these three sections are:

Chapter 1 - Introduction and Roadmap
Chapter 2 - What is an Operational Data Store (ODS)?
Chapter 3 - What is Schema Integration?
Chapter 4 - The Role of the ODS within DW Architectures

Chapter 5 - Reverse Engineering the four Source Schema
Chapter 6 - Designing the Interim Schema
Chapter 7 - Preparing the ETL Specifications
Chapter 8 - Designing the Physical ODS Database Model
Chapter 9 - Designing Our ETL processes with SSIS

Chapter 10 - Data Quality Profiling

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.