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, butkey 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:
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.
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:
Point to Point Data Bridges
Data Hubs (DH)
Data Bus (e.g.OMG CORBA, Microsoft DCOM)
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.
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
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
