Connecting the Data: Data Integration Techniques for Building an Operational Dat

Description: Connecting the Data by Angelo R. Bobak . 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. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description 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. Author Biography 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. Table of Contents 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. Details ISBN1935504223 Author Angelo R. Bobak Short Title CONNECTING THE DATA Language English ISBN-10 1935504223 ISBN-13 9781935504221 Media Book Format Paperback Illustrations Yes Year 2012 Edition Description First Edition 1st Subtitle Data Integration Techniques for Building an Operational Data Store (ODS) Imprint Technics Publications LLC Place of Publication Bradley Beach Country of Publication United States AU Release Date 2012-10-15 NZ Release Date 2012-10-15 UK Release Date 2012-10-15 Pages 248 Publisher Technics Publications LLC Audience Tertiary & Higher Education Publication Date 2012-10-05 US Release Date 2012-10-05 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:51359195;

Price: 88.5 AUD

Location: Melbourne

End Time: 2024-11-25T16:13:56.000Z

Shipping Cost: 4.47 AUD