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


June 18, 2020

Bob Seiner - Data Governance Roles and Why Everyone is a Steward

June 18, 2020
9:00 AM - 11:30 AM

Zoom Webinar Presentation

New York, NY 10003

Bob Seiner: Data Governance Roles and Why Everyone is a Steward

October 29, 2020

DAMA DAY Oct 29, 2020 event

October 29, 2020
8:00 AM - 5:00 PM

American International Group
175 Water Street 18th floor
New York, NY 10038

"Realigning your data skills to fit 2020 challenges"