Home Page



An Organization For Information Management Professionals 

The Data Administration Management Association of New York, DAMA-NYC, explores the role of information management in today's competitive global market place. DAMA-NYC events bring together the best and the brightest to present and discuss the new strategies which are changing the way business is done in the information age.

DAMA-NYC is the organization for business executives with information needs, for information managers who must be aware of emerging management techniques, and for information management professionals who wish to acquire the latest skills.



Next Meeting

Angelo R. Bobak, Designing an ODS using Schema Integration Techniques
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

$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.