Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R. Bobak
Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R. Bobak PDF, ePub eBook D0wnl0ad
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
From reader reviews:
Chad West:
Why don't make it to become your habit? Right now, try to ready your time to do the important work, like looking for your favorite publication and reading a book. Beside you can solve your short lived problem; you can add your knowledge by the publication entitled Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS). Try to stumble through book Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) as your friend. It means that it can to become your friend when you feel alone and beside regarding course make you smarter than before. Yeah, it is very fortuned for yourself. The book makes you far more confidence because you can know almost everything by the book. So , let us make new experience in addition to knowledge with this book.
Miguel Penix:
Information is provisions for anyone to get better life, information currently can get by anyone at everywhere. The information can be a understanding or any news even a problem. What people must be consider if those information which is inside the former life are challenging be find than now's taking seriously which one is suitable to believe or which one typically the resource are convinced. If you obtain the unstable resource then you understand it as your main information you will have huge disadvantage for you. All of those possibilities will not happen throughout you if you take Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) as your daily resource information.
John Wiser:
As we know that book is important thing to add our understanding for everything. By a e-book we can know everything we would like. A book is a pair of written, printed, illustrated or blank sheet. Every year seemed to be exactly added. This guide Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) was filled regarding science. Spend your time to add your knowledge about your science competence. Some people has diverse feel when they reading a book. If you know how big benefit from a book, you can truly feel enjoy to read a guide. In the modern era like now, many ways to get book that you just wanted.
Read Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R. Bobak for online ebook
Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R. Bobak Free PDF d0wnl0ad, audio books, books to read, good books to read, cheap books, good books, online books, books online, book reviews epub, read books online, books to read online, online library, greatbooks to read, PDF best books to read, top books to read Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) by Angelo R. Bobak books to read online.
No comments:
Post a Comment