Connecting the Data Data Integration Techniques for Building an Operational Data Store (ODS)
Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R Bobak is a comprehensive resource published by Technics Publications, LLC in 2012. This 244-page book is written in English and addresses the complexities of business data integration, particularly when organizations undergo changes or enhancements in their internal structures. It aims to provide readers with a thorough understanding of the challenges associated with data integration and presents solutions, including schema integration, illustrated through a detailed case study of an Operational Data Store (ODS).
The book is structured into three sections comprising ten chapters, each focusing on different aspects of data integration. Readers will find foundational concepts, preparation and design strategies, and physical implementation techniques. The first section introduces essential concepts and schema integration, while the second section delves into a case study that involves reverse engineering data sources to create data dictionary reports. The final section presents practical scripts for populating databases and developing Extract, Transform, and Load (ETL) specifications. Topics such as database administration, data science, and data warehousing are explored throughout the text, making it a valuable resource for those interested in data analytics and software development.
Official synopsis Publisher
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
Publisher
Topics
FAQ
What is “Connecting the Data Data Integration Techniques for Building an Operational Data Store (ODS)” about?
Who is the author of “Connecting the Data Data Integration Techniques for Building an Operational Data Store (ODS)”?
When was “Connecting the Data Data Integration Techniques for Building an Operational Data Store (ODS)” published?
What is the ISBN for “Connecting the Data Data Integration Techniques for Building an Operational Data Store (ODS)”?
What are the book details (language, pages, edition)?
