Udvidet returret til d. 31. januar 2025

Connecting the Data - Angelo R Bobak - Bog

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

Bag om Connecting the Data

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 RoadmapChapter 2 – What is an Operational Data Store (ODS)?Chapter 3 – What is Schema Integration?Chapter 4 – The Role of the ODS within DW ArchitecturesChapter 5 – Reverse Engineering the four Source SchemaChapter 6 – Designing the Interim SchemaChapter 7 – Preparing the ETL SpecificationsChapter 8 – Designing the Physical ODS Database ModelChapter 9 – Designing Our ETL processes with SSISChapter 10 – Data Quality Profiling

Vis mere
  • Sprog:
  • Engelsk
  • ISBN:
  • 9781935504221
  • Indbinding:
  • Paperback
  • Sideantal:
  • 248
  • Udgivet:
  • 5. oktober 2012
  • Størrelse:
  • 202x247x15 mm.
  • Vægt:
  • 624 g.
  • 2-3 uger.
  • 22. november 2024

Normalpris

  • BLACK NOVEMBER

Medlemspris

Prøv i 30 dage for 45 kr.
Herefter fra 79 kr./md. Ingen binding.

Beskrivelse af Connecting the Data

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 RoadmapChapter 2 – What is an Operational Data Store (ODS)?Chapter 3 – What is Schema Integration?Chapter 4 – The Role of the ODS within DW ArchitecturesChapter 5 – Reverse Engineering the four Source SchemaChapter 6 – Designing the Interim SchemaChapter 7 – Preparing the ETL SpecificationsChapter 8 – Designing the Physical ODS Database ModelChapter 9 – Designing Our ETL processes with SSISChapter 10 – Data Quality Profiling

Brugerbedømmelser af Connecting the Data



Find lignende bøger
Bogen Connecting the Data findes i følgende kategorier:

Gør som tusindvis af andre bogelskere

Tilmeld dig nyhedsbrevet og få gode tilbud og inspiration til din næste læsning.