Meeting/Event Information


May 16, 2019

Angelo R. Bobak, Designing an ODS using Schema Integration Techniques
May 16, 2019
9:00 AM - 12:30 PM
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. 
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

January 22, 2020

Data Governance must lead Data Literacy Hochun Ho, JLL

January 22, 2020
8:45 AM - 12:30 PM

NYU East 17th street
105 East 17th Street
New York, NY 10000

Data Governance must lead Data Literacy Hochun Ho Global Head of Data Governance Management

March 26, 2020

March 19th DAMA Meeting TBD

March 26, 2020
8:45 AM - 12:30 PM

NYU Admin Building 105 E 17th st 1st fl Training
105 E 17TH St 1st FL Training