Home > Instructors > Angelo Bobak >

Data Integration Techniques for Designing an ODS
Data Integration Techniques for Designing an ODS - online training course
 
Alternative Views:


3-hour Online Course by Angelo Bobak
Single-user access license
Our Price: $295.00


Product Code: DI-03-A


Course Exam [Add $100.00]

Description Course Outline Exam Details
 

In today’s modern business environment, corporate entities are constantly merging or splitting, internal divisions are sold to different companies, and new business lines are created in order to meet the challenges of difficult economic times. Business data integration is a complex problem that must be solved when organizations change or enhance their internal structures. New IT departments must be merged with old ones, and transactional, operational, and master data must be integrated in order to be managed efficiently, if the business is expected to grow and be profitable.

Click to play Course Sneak Peek

The goal of this course is to present a simple yet thorough process that describes the challenges of business data integration and the solutions to these challenges. It will show you how the application of a technique called "schema integration" addresses these challenges.

Schema integration is both a theory and process that was pioneered by experts in the field of data management. We will discuss the techniques of two of these pioneers, M. Tamer Ozsu and Patrick Valduriez in the design of an Operational Data Store (ODS) for a small business.

You will learn:
  • The underlying architecture of the Operational Data Store (ODS)
  • The different types of ODS Architectures
  • The theory behind schema integration
  • The schema integration process
  • Identifying and resolving data conflicts when integrating data
  • The importance of master data and data quality in schema integration
This course is geared towards:
  • The Logical and Physical Data Modeler
  • The Data Architect
  • The Database Administrator
  • Project Managers
  • Data Warehouse Architects
  • Anyone wishing to enter the field of database design and ODS implementation

Average Customer Review: Average Customer Review: 4.5 of 5 4.5 of 5 Total Reviews: 4 Write a review.

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review from 2/12/2021 January 6, 2024
Reviewer: Pamela Garrett  
Content and examples were laid out and presented well.  The complexity of the examples was good to where it was not too overwhelming to comprehend.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review from 9/25/2020 January 5, 2024
Reviewer: Emily Lambert  
The visuals were great and really assisted the learning process.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 1/27/2020 January 3, 2024
Reviewer: Jamie Authement  
On slide 34 in The Theory of Schema Integration, on the schema 1 table FEATURE_ID should be part of the primary key.

Was this review helpful to you?

  1 of 1 people found the following review helpful:
 
4 of 5 Course Review March 4, 2015
Reviewer: Yonetaro Kawada  
Somewhat I feel inconsistency regarding definition of ODS compared with other courses.

Was this review helpful to you?


Browse for more products in the same category as this item:

Instructors > Angelo Bobak
Instructors
Courses