Items related to Connecting the Data: Data Integration Techniques for...

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

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

Synopsis

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

"synopsis" may belong to another edition of this title.

About the Author

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.

From the Back Cover

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.

Buy Used

Condition: Very Good
May have limited writing in cover...
View this item

£ 9.59 shipping from U.S.A. to United Kingdom

Destination, rates & speeds

Search results for Connecting the Data: Data Integration Techniques for...

Stock Image

Bobak, Angelo
Published by Technics Publications, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
Used Paperback

Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

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

Contact seller

Buy Used

£ 11.11
Convert currency
Shipping: £ 9.59
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Seller Image

Bobak, Angelo R.
Published by Technics Publications, LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 18956237-n

Contact seller

Buy New

£ 30.04
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: 9 available

Add to basket

Stock Image

Angelo R. Bobak
Published by Technics Publications LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 621. Seller Inventory # C9781935504221

Contact seller

Buy New

£ 30.05
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Bobak, Angelo R.
Published by Technics Publications, LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
Used Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 18956237

Contact seller

Buy Used

£ 30.16
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: 9 available

Add to basket

Seller Image

Bobak, Angelo R.
Published by Technics Publications LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New Paperback

Seller: Rarewaves USA United, OSWEGO, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: New. Seller Inventory # LU-9781935504221

Contact seller

Buy New

£ 31.68
Convert currency
Shipping: FREE
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Bobak, Angelo
ISBN 10: 1935504223 ISBN 13: 9781935504221
New Paperback or Softback

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

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

Contact seller

Buy New

£ 24.54
Convert currency
Shipping: £ 8.65
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: 5 available

Add to basket

Stock Image

Angelo R Bobak
Published by Technics Publications LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New PAP

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # GZ-9781935504221

Contact seller

Buy New

£ 33.60
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: 9 available

Add to basket

Stock Image

Angelo R Bobak
Published by Technics Publications LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New PAP
Print on Demand

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

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

Contact seller

Buy New

£ 33.60
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: 15 available

Add to basket

Stock Image

Bobak, Angelo
Published by Technics Publications 2012-10, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New PF

Seller: Chiron Media, Wallingford, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

PF. Condition: New. Seller Inventory # 6666-IUK-9781935504221

Contact seller

Buy New

£ 31.34
Convert currency
Shipping: £ 2.49
Within United Kingdom
Destination, rates & speeds

Quantity: 10 available

Add to basket

Stock Image

Bobak, Angelo R.
Published by Technics Publications, LLC, 2012
ISBN 10: 1935504223 ISBN 13: 9781935504221
New Softcover

Seller: California Books, Miami, FL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # I-9781935504221

Contact seller

Buy New

£ 26.35
Convert currency
Shipping: £ 7.52
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

There are 20 more copies of this book

View all search results for this book