Cantitate/Preț
Produs

Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS)

Autor Angelo R. Bobak
en Limba Engleză Paperback – 24 sep 2012
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. The 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.
Citește tot Restrânge

Preț: 19184 lei

Preț vechi: 23979 lei
-20% Nou

Puncte Express: 288

Preț estimativ în valută:
3672 3818$ 3072£

Carte disponibilă

Livrare economică 22 februarie-08 martie

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781935504221
ISBN-10: 1935504223
Pagini: 244
Dimensiuni: 201 x 251 x 18 mm
Greutate: 0.59 kg
Editura: TECHNICS PUBN LLC

Cuprins

Introduction & Roadmap; What is an Operational Data Store (ODS)?; What is Schema Integration?; The Role of the ODS within DW Architectures; Reverse Engineering the four Source Schema; Designing the Interim Schema; Preparing the ETL Specifications; Designing the Physical ODS Database Model; Designing Our ETL processes with SSIS; Data Quality Profiling.