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.

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.

• 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

• 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