1 / 16

Enhancing Information Integration: Technologies and Solutions

Explore the dimensions of interoperability, technology solutions, middleware usage, and transaction processing middleware in information integration. Learn about database gateways, multi-DBMS, data warehouses, and workflow management systems. Discover the CORBA approach, enterprise-wide data warehouses, and useful links for further exploration.

tanner-sweet
Télécharger la présentation

Enhancing Information Integration: Technologies and Solutions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Foundations of Information Integration Louiqa Raschid Smith School of Business, Department of C.S. and UMIACS Vladimir Zadorozhny UMIACS University of Maryland

  2. Preliminary Observations Information integration is pushing the state-of-the-art of current practice. Roadblocks to success will be inherent to the organization rather than technology limitations. Presentation to JRSA - June 15, 1999

  3. Dimensions of Interoperability(initial) • Platform (machine and O/S) • Programming Language • Application Semantics • Database Model • Query Language • Database Schema • Database Semantics Presentation to JRSA - June 15, 1999

  4. Technology Solutions and Interoperability Dimensions • Middleware • Focus on platform, language, application semantics. • Database Gateways, MultiDBMS, Heterogeneous DBMS • Focus on database integration, database query processing. • Data Warehouses • Focus on management decision support. • Workflow Management NONE OF the solutions address DATABASESEMANTICS. Additional dimensions: Multi-media (full text, images, video) Presentation to JRSA - June 15, 1999

  5. Middleware • Middleware allows an application to interoperate with other software. • Eliminates the need to understand and code different implementation details with different levels of implementation transparency. Presentation to JRSA - June 15, 1999

  6. Presentation to JRSA - June 15, 1999

  7. CORBA approach • PL neutral “contract language” OMG IDL • IDL/PL compiler based on standard Object Request Broker (ORB) architecture ensuring “common address space” and “common data format”. • ORB is a standard middleware that may have specific implementations in different environments • Iona Orbix, BEA ObjectBroker Presentation to JRSA - June 15, 1999

  8. Presentation to JRSA - June 15, 1999

  9. Transaction processing middleware • Facilitates and makes efficient data requests between application and DBMS • DB system may require an entire OS process per connected user, which is not scalable • Establishing a connection is slow. With many users system performance degrades • IBM CICS, BEA Tuxedo Presentation to JRSA - June 15, 1999

  10. Database Gateways, Multi-DBMS, Heterogeneous DBMS • Transparent access to multiple physical DBMS • Typically transparent to platform and DBMS product • Provides Logical Database Integration, i.e., transparent support of SQL queries over multiple DBMS • Support joins, unions, views over multiple DBMS • Example products • IBM DataJoiner, • Informix Enterprise Gateway Manager Presentation to JRSA - June 15, 1999

  11. Presentation to JRSA - June 15, 1999

  12. Presentation to JRSA - June 15, 1999

  13. Enterprise-wide Data Warehouses • Provides uniform access to snapshots of multiple legacy data sources or DBMS. • Create and populate warehouse tables. • Typically does not provide Logical Database Integration, i.e., transparent support of SQL queries over multiple underlying heterogeneous DBMS. • Support for data-marts and datacubes w.r.t. warehouse tables for management decision support. • OLAP (offline decision support) versus OLTP (real-time application). Presentation to JRSA - June 15, 1999

  14. Presentation to JRSA - June 15, 1999

  15. Workflow Management • Focus on business transactions / event management. • May be transparent to platform and DBMS product. • Typically does not provide Logical Database Integration i.e., transparent support of SQL queries over multiple heterogeneous DBMS. • Example products • Staffware • JetForm Presentation to JRSA - June 15, 1999

  16. Useful Links • A general product overview site of more then 900 products (formerly DBMS Buyer’s Guide): • http://www.iemagazine.com/pguide_frm.shtml • Comprehensive technology guides and articles: • http://www.techguide.com • http://www.intelligententerprise.com/archives.shtml • A comprehensive guide to Workflow Management: • http://www.concordium.co.uk Presentation to JRSA - June 15, 1999

More Related