Meeting/Event Information

 Directions

May 16, 2019

Angelo J. Bobak, Designing an ODS using Schema Integration Techniques
May 16, 2019
9:00 AM - 12:30 PM
NYU KIMMEL CENTER Room TBD
60 Washington Square South
New York, NY 00000
Angelo J. 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 J. 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 J 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

March 28, 2019

ANNE MARIE SMITH Data Governance - 8 Critical Steps to Success

March 28, 2019
8:30 AM - 12:30 PM

NYU E 17TH St
105 E 17TH St 1st FL Training Room 191
New York, NY 00000

ANNE MARIE SMITH Data Governance - 8 Critical Steps to Success
 

April 11, 2019

Analytic Governance, Ron Forino, & Bob Veracca D&B

April 11, 2019
9:00 AM - 12:30 PM

NYU KIMMEL CENTER Room 405
60 Washington Square South
New York, NY 00000

Analytic Data Governance, Ron Forino & Bob Veracca, Dun and Bradstreet
 

May 16, 2019

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

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

NYU KIMMEL CENTER Room TBD
60 Washington Square South
New York, NY 00000

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

June 20, 2019

"Put your Data to Work" 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

"Put your Data to Work" AIG 175 Water ST
 

October 17, 2019

DAMA FALL EVENT

October 17, 2019
5:00 PM

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

DAMA FALL EVENT THEME TBD