Hirs / Meta Integration Christian Bremeau

Sizin üçün oyun:

Google Play'də əldə edin


Yüklə 461 b.
tarix17.08.2018
ölçüsü461 b.


HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers

Meta Integration’s Government Business: HIRS Partnership & GOTS Software





DoD



HIRS Repository Architecture



HIRS Products and Solutions



HIRS Data Works: Motivations & Goals

  • Metadata (data, object & process models) will survive the methodologies & design tools used to manipulate them.

  • => We need to provide solutions independently of modeling techniques, metadata standards, and current design tools => Future proof solutions protecting our metadata assets!

  • Data administration & data standardization are not goals, but key steps towards a complete solution to business problems such as:

    • legacy data migration, database re-engineering
    • database (and application) integration, data warehousing, etc.
  • =>We need to provide total solutions from data standardization to actual system & data integration: providing measurable results and return on investment!



HIRS Data Movement Solutions Business Case & Motivations

  • Implement a Key Component of the MHS IM/IT's Mission:

    • “Provide the right information to the right people at the right time to improve and maintain health status across the entire continuum of health care operations”
  • Support the DoD Directives on adopting COTS instead of GOTS requires data movement solutions for legacy data migration & application integration.

  • Provide TIMPO with a Total Infrastructure Solution (as defined in Tab G) from networking to actual application integration.

  • Support the Data Administration & Standardization Efforts, and provide Return On Investment (ROI) for these activities:

    • Implement the Health Data Standards (FAM-D) in legacy data migrations, or in Health Data Hubs for MTF Application integration.
    • Protect the government assets: the health data model standards will survive the methodologies & design tools used to develop and maintain them.


HIRS Data Works: Both GOTS & COTS

  • Full rights to use everywhere within the Government as Government-Off-The-Shelf (GOTS) Software.

  • Also available Commercially-Off-The-Shelf (COTS ) outside the Government:

  • Copyright © Meta Integration Technology, Inc. 1997-1999 With acknowledgment for the sponsorship of the U.S. Government

  • under the contracts

  • Meta Integration technology, Inc. GS-35F-0035J, All Rights Reserved.

  • Easy installation available through the Web.

  • Minimal dependency on COTS products:

    • available on a variety of OS/DB combinations
    • rigorous selection of middleware in order to avoid paying license fees (e.g. free Java RMI vs. CORBA)


HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


Data Movement News: XML is everywhere!

  • XML is playing a more and more important role in data integration as a driving force from Enterprise Application Integration (EAI) to Internet Application Integration (IAI).

  • XML also plays a key role in Microsoft, Oracle and IBM’s Business Intelligence (BI) and Knowledge Management (KM) initiatives.

  • Database suppliers have integrated XML as a way to insert, update, delete data (as well as query data): Microsoft SQL Server 7.5, Oracle 8i.

  • XML is everywhere MS Office 2000, Visual Studio, IBM tools, etc.



Data Movement News: What you should know about XML…

  • XML is noisy! Only 10 to 20% of an XML file is actual data, most of it is XML “metatag noise”…

  • New database releases provide XML support that may not solve your needs, because the XML DTD is imposed and automatically generated from the database DDL. Therefore, it does not solve the data integration between an RDBMS and an externally defined XML DTD (home made or standard like HL7 or FpML).

  • XML is still evolving a lot and is still very incomplete in many areas like data types for which there are many variations from the W3C proposed DCD, to vertical market solutions by HL7, FpML, OMG, MS BizTalk.



OMG vs. MDC At a glance…



MDC XML : Open Information Model (OIM) Overview

  • Analysis and Design Model

    • Unified Modeling Language
    • UML Extensions
    • Common Data Types
    • Generic Elements
    • Entity Relationship Modeling
  • Object and Component Model

    • Component Description Model
  • Database and Warehousing Model



MDC XML : Open Information Model (OIM) Overview (cont.)

  • Business Engineering Model

    • Business Goals
    • Organizational Elements
    • Business Rules
    • Business Processes
  • Knowledge Management Model

    • Knowledge Description Format
    • Semantic Definitions




OMG XMI : Overview



OMG XMI : Proof of Concept OMG Demo - Nov 1998





HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI amd MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


Meta Integration Products & Services



Meta Integration Functionalities



Meta Integration Architecture



HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


Meta Integration Model Bridge Supported Design Tools



Meta Integration Model Bridge Supported XML



Metadata Movement News: The Design Tool Market

  • CA/Platinum currently plans to release ERwin 4.0 in Q1 or Q2 of 2000 with new features such as:

    • An API and MDC XML will replace the ERX files,
    • Support for multiple physical models for one logical model
  • Rational will release Rose 2000 and more…

  • New players to watch:

    • Embarcadero ER/Studio.
    • Visio has been acquired by Microsoft and is evolving
      • from a good drawing tool with support of UML and IDEF1X notations
      • to a design tool with C++, Java, DDL forward and reverse engineering, Microsoft Repository, and XMI support.


HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


Data Movement Solutions: Your Corporate Data is everywhere !



Data Movement Solutions: Centralized / Corporate Database



Data Movement Solutions: The problem has multiple dimensions

  • Business Cases:

          • Legacy Data Migration (LDM)
          • Enterprise Application Integration (EAI)
          • Enterprise Application Portals (EAP)
          • Electronic Data Interchange (EDI)
          • Data Warehousing (DW) & Data Marts
          • Knowledge Management (KM)
          • Data Mining (DM)
  • Integration Architectures/Technologies:

  • Application Architectures/Technologies:

          • Mainframes (e.g. ISAM, VSAM file access)
          • Client/Server (e.g. ODBC access to an RDBMS)
          • Modern 3 Tier Architectures (e.g. BAPI access to the application)


Data Movement Business Cases: Legacy Data Migration (LDM)



Data Movement Business Cases: Enterprise Application Integration (EAI)



Data Movement Business Cases: Electronic Data Interchange (EDI)



Data Movement Business Cases: Data Warehousing (DW)



Data Movement Business Cases: Data Mining (DM)



Data Movement Architectures: Point to Point Data Bridges



Data Movement Architectures: Data Hub (DH)



Data Movement Architectures: Data Bus (DB)



The Problem: data is everywhere! Many data movements are needed…



Meta Integration Data Movement Solution

  • HIRS Data Works is a Government-Off-The-Shelf (GOTS) version of Meta Integration’s Data & Metadata Movement Toolset.

  • HIRS Data Works’ data movement solution is a development environment which generates data movement, better known as data bridges (executable code that moves data from a source to a destination database/application) and which solves three major categories of business problems:

    • Legacy Data Migration (LDM) - in which case the source database is a legacy system that will be shutdown after the data movement. This situation happens when migrating to a new database delivered with a new application, or as part of the database re-engineering of the same application.
    • Enterprise Application Integration (EAI) - in which case both source and target applications are current systems that usually complement each other and require periodic data updates. The data movement can be enacted in real time (triggers), overnight (batch) updates, replication, etc.
    • Data Warehousing (DW) - in which case the source databases are under corporate business applications and the target database is in fact your corporate data warehouse.


Meta Integration Past Data Movement Solutions

  • In the past, Data Movement has been solved by developing expensive custom software, in other words by programming data bridges "by hand".

  • This solution is obviously programming intensive and not at all cost effective.

  • In addition, such data bridges are also expensive to maintain with the evolution (version upgrades) of both the source and target databases.

  • Most data/application integration problems are still approached in this expensive and inefficient way today.



Meta Integration Other Data Movement Solutions

  • Most data movement solutions offered by DW or ETL products make use of scripting languages often derived from the Basic language, creating several major drawbacks and complications:

    • Such scripting languages are derived from Basic, but are still different from Visual Basic. Therefore, there can be a steep learning curve for the implementation.
    • Data movement applications built with interpreted scripting languages (e.g. Basic) are much slower than the ones built with compiled native languages like C/C++.
    • Data movement applications built with scripting languages (e.g. Basic) often rely on so called data movement servers (interpreting the data transformations) which require more system administration.
    • These data movement servers and/or libraries often involve costly runtime fees.


Meta Integration Solution Benefits

  • The MITI data movement toolset offers several unique and exciting benefits not found elsewhere:

    • Built-in repository with true support for version management of the perpetually changing data sources (includes support for model management, model mapping, model comparison, and model integration).
    • Data Connectors for multiple technologies / applications (SDK available)
      • Client/Server Architectures via ODBC (e.g. Oracle, Sybase, MS SQL Server),
      • Modern 3-tier Architectures via API (e.g. ERP BAPI like SAP, PeopleSoft),
      • Web Enabled Architectures via XML (e.g. E-business, Portals).
    • Generation of fast C++ code, portable across any Windows or Unix operating system, and producing data movement solutions as standalone utilities, or (plug&play) software components for business applications


Meta Integration’s Data Movement Solution Benefits

  • The MITI data movement toolset offers several unique and exciting benefits not found elsewhere:

    • Built-in repository with true support for version management of the perpetually changing data sources (includes support for model management, model mapping, model comparison, and model integration).
    • Data Connectors for multiple technologies / applications (SDK available)
      • Client/Server Architectures via ODBC (e.g. Oracle, Sybase, MS SQL Server),
      • Modern 3-tier Architectures via API (e.g. ERP BAPI like SAP, PeopleSoft),
      • Web Enabled Architectures via XML (e.g. E-business, Portals).
    • Generation of fast C++ code, portable across any Windows or Unix operating system, and producing data movement solutions as standalone utilities, or (plug&play) software components for business applications


Data Connectors for all generations of Application Architectures



Data Connectors for direct access to the data stores



Data Connector to the 1st Tier Direct Database Access



Application Technologies: Supporting Heterogeneous Architectures



Application Technologies: Supporting Heterogeneous Software



Meta Integration Architecture of the produced Data Bridge



HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers


Your Choice of Platforms (OS/DB) !

  • Not only does the repository solution need to adjust to your methodologies and design tools, its’ implementation also needs to be supported by your existing platforms:

    • Operating Systems (OS):
      • Windows: Microsoft Windows NT 4.0 Server (Enterprise Edition) Microsoft Windows 95/98 (Personal Edition)
      • Unix: Sun Solaris 2.5 to 7, Linux
    • and Databases:
      • RDBMS (ODBC / ANSI/ISO SQL standards))
        • Microsoft SQL Server 6.5-7,
        • Oracle 7 (Enterprise Edition)
        • Microsoft Access (Personal Edition)
      • ORDBMS (ANSI SQL3 standards)
        • Oracle 8
      • OODBMS (ODMG standards)
        • ODI’s Object Store, Versant, Objectivity, O2)


3-Tier Architecture Persistent vs. Non-Persistent Repository



Some facts on our technologies

  • About 500,000 Lines Of Code (LOC) of both Windows/Unix C++ and Java 2

  • The Meta Integration Works (MIW) GUI is 100 KLOC (swing based) Java 2

  • The Meta Integration Repository SDK is decomposed into

    • A non persistent repository (in memory)
      • Developed in UML with Rational Rose, and from which a programming language independent script (shell like) is maintained.
      • The C++ and Java SDK are automatically generated (about 100 KLOC each)
      • The C++ to Java and Java to C++ layers are also automatically generated
      • The Java SDK includes extra features:
        • Support for Internet network distribution (client/server):
          • Java RMI for the Repository Manager
          • Java serialization of a non persistent repository (model metadata)
        • Support for customizable metadata views in the Model Browser filtering the metadata and adjusting their names and icons for IDEF1X, UML, MIR, or others.
    • A persistent repository portable across RDBMS
      • The data model is developed and maintained in IDEF1X with CA/Platinum ERwin
      • DDL is generated and tuned for MS NT SQL Server, Access, Oracle 7 to 8
      • The MIRDB layer is written in Windows/Unix portable C++ code


HIRS / Meta Integration

  • Christian Bremeau

  • Meta Integration Technology, Inc. bremeau@metaintegration.com

  • Agenda

    • About Health Information Resources Service (HIRS)
    • From XML to OMG’s XMI and MDC XML
    • Meta Integration Solutions
      • Metadata Movement
      • Data Movement
      • Technologies
    • Demos
    • Questions & Answers



Dostları ilə paylaş:
Orklarla döyüş:

Google Play'də əldə edin


Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2017
rəhbərliyinə müraciət

    Ana səhifə