Meeting/Event Information

 Directions

May 16, 2019

Angelo R. Bobak, Designing an ODS using Schema Integration Techniques
May 16, 2019
9:00 AM - 12:30 PM
NYU KIMMEL CENTER room 802
60 Washington Square South room 802
New York, NY 00000
Angelo R. Bobak, Designing an ODS using Schema Integration Techniques

$0.00 Member Ticket

$0.00 Non-Member Ticket

Designing an ODS using Schema Integration Techniques
Angelo R. Bobak
 
Schema Integration steps discussed in this presentation are based on a theoretical process that was first presented and discussed by pioneers in the data field M. Tamer Ozsu and P. Valduriez. 
The goals of the presentation are to discuss how schema integration techniques can be applied to the design and implementation of an ODS (Operational Data Store).
An Operational Data Store is a data integration hub and is a critical component of any Data Architecture that accepts data from multiple heterogeneous data sources in order to merge them into a unified database that will act as a source to downstream platforms like data warehouses and data marts.  The main goal is to present and define schema integration and to highlight the main steps, processes and deliverable artifacts generated when using this approach .
Specific topics discussed are:
  • What is Schema Integration?
  • Examine and model sources like:
    • JSON Documents
    • XML Documents
    • CSV EXCEL Files
    • Relational Data Feeds
  • Integration Sequence & Steps
  • Discuss data conflicts typical when merging schema and data
  • Preparation of Data Dictionaries for integration process
  • Perform Integration steps
  • Generation of the final integrated model
Suggested reading: Principles of Distributed Database Systems (2nd Edition) Jan 29,1999 by M. Tamer Ozsu and Patrick Valduriez
   Angelo R. Bobak      Biography:
Certified CIMP data warehouse, data architecture professional and published author  with over 25 years of experience in Business Intelligence, Data Architecture, Data Modeling, Master Data Management, and Data Quality in Finance, Telecommunications, Automotive, ITIL Service Delivery and other industries using Microsoft BI Stack. 
 Education
Masters In Computer Science -  Polytechnic Institute of New York, 1986
Bachelor’s Electrical Engineering – Pratt Institute, Brooklyn New York, 1982
        Accomplishments and Publications
Published author of several client/server, data modeling and data architecture books. CIMP Certification in master data and data quality.            


Future Meetings

May 16, 2019

Angelo R. Bobak, Designing an ODS using Schema Integration Techniques

May 16, 2019
9:00 AM - 12:30 PM

NYU KIMMEL CENTER room 802
60 Washington Square South room 802
New York, NY 00000

Angelo R. Bobak, Designing an ODS using Schema Integration Techniques
 

June 20, 2019

"Unleash the Power of Your Data" AIG 175 Water St 18th fl

June 20, 2019
9:00 AM - 5:00 PM

AMERICAN INTERNATIONAL GROUP
175 Water Street 18th floor
New York, NY 00000

"Unleash the Power of Your Data" AIG 175 Water ST