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:
"synopsis" may belong to another edition of this title.
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 modelling and distributed database architectures. Angelo lives in New York with his wife Cathy.
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
"About this title" may belong to another edition of this title.
£ 9.59 shipping from U.S.A. to United Kingdom
Destination, rates & speedsSeller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.4. Seller Inventory # G1935504223I4N00
Quantity: 1 available
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Condition: New. Seller Inventory # 18956237-n
Quantity: 9 available
Seller: THE SAINT BOOKSTORE, Southport, United Kingdom
Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 621. Seller Inventory # C9781935504221
Quantity: Over 20 available
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Condition: As New. Unread book in perfect condition. Seller Inventory # 18956237
Quantity: 9 available
Seller: Rarewaves USA United, OSWEGO, IL, U.S.A.
Paperback. Condition: New. Seller Inventory # LU-9781935504221
Quantity: Over 20 available
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Paperback or Softback. Condition: New. Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS) 1.3. Book. Seller Inventory # BBS-9781935504221
Quantity: 5 available
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GZ-9781935504221
Quantity: 9 available
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781935504221
Quantity: 15 available
Seller: Chiron Media, Wallingford, United Kingdom
PF. Condition: New. Seller Inventory # 6666-IUK-9781935504221
Quantity: 10 available
Seller: California Books, Miami, FL, U.S.A.
Condition: New. Seller Inventory # I-9781935504221
Quantity: Over 20 available