Connecting the Data
by Angelo R. Bobak
Description
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:
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
Angelo Bobak currently holds the position of Director of Data Architecture for an international ITIL services company. He holds a Masters in Computer Science and Bachelor of Electrical Engineering degrees. He has written several books on data modeling and distributed database architectures. Angelo lives in New York with his wife Cathy.
More Information
Rights Information
World rights available.
Bibliographic Information
- Publisher Technics Publications
- Publication Date October 2012
- ISBN/Identifier 9781935504221
- Publication Country or regionUS
- Primary Price 38.95 USD
- Pages248
- Publish StatusPublished
- Dimensions8 x 10 inches
Thank you for proceeding with this offer.
Technics Publications has chosen to review this offer before it proceeds.
You will receive an email update that will bring you back to complete the process.
You can also check the status in the My Offers area
Technics Publications has chosen to review this offer before it proceeds.
You will receive an email update that will bring you back to complete the process.
You can also check the status in the My Offers area
Please wait while the payment is being prepared.
Do not close this window.
(c) Copyright 2024 - Frankfurt Rights. All Right Reserved