1 / 11

OpenDM - Open Database Middleware

Fari Schlake fschlake@c-lab.de. OpenDM - Open Database Middleware. - Efficient Homogeneous Access to Heterogeneous Databases -. User/ Tool. User/ Tool. User/ Tool. User/ Tool. - Isolated DBMS with heterogeneous interfaces - Many data is stored in legacy systems

muncel
Download Presentation

OpenDM - Open Database Middleware

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. Fari Schlake fschlake@c-lab.de OpenDM - Open Database Middleware -Efficient Homogeneous Access to Heterogeneous Databases -

  2. User/ Tool User/ Tool User/ Tool User/ Tool - Isolated DBMS with heterogeneous interfaces - Many data is stored in legacy systems - Data redundancy and inconsistency - Application using DBS specific interface functions User/ Tool User/ Tool User/ Tool User/ Tool Database Problems Enterprise SQL Oracle Sybase ? Hierarchical DBS OODBS (ODMG) Informix ? ? ? Lotus Notes File System

  3. User/Tool User/Tool User/Tool User/Tool Database Middleware Solution: Database Coupling • Database independency by offering standard interfaces on top of arbitrary database systems • Federation of heterogeneous database systems • Migration of data across database systems • Schema integration and multiple schema handling via a nested object model • Flexible adapter technology for front-end and back-end (database adapter) integration • Tool support for system administration and configuration Database Middleware File System OODBS Oracle

  4. Other Solutions • Database Integration: Choosing only one database vendor for the whole enterprise and replacing every single existing database!? • Gate-Ways: A database system supports the coupling of other systems (no deep integration) • Export/Import: Only offline data exchange possible

  5. Areas of Implementation • Technical or scientific organizations • Integration of heterogeneous database systems required • Product vendors • Introducing modern product management systems like SAP/R3 or Metaphase and need data migration for the existing product data • Enterprises using or developing CAX systems • using relational as well as object-oriented databases • Enterprises developing CASE tools • support of object-oriented design including object-oriented database access but storing of data in relational databases • Enterprises with decentralized structure • Remote access for autonomous subsidiary and tele-workers

  6. User Values • New Functionality • Overcoming diversity of databases (database federation and database independency) • Open for new technologies like object-orientation • Data migration among heterogeneous database sources • Transaction integration over distributed databases (coexistence of local and global transactions) • Schema integration combines the different schemas of the databases to one or few federated schema • Ensure autonomy of the databases and their appl. • Performance • Worst Case: 20 -30% slower than direct database access • Best Case: 20 times faster than direct database access

  7. Application n Application 1 Adapt. Adapt. Adapt. Data Dictionary Transaction Man. Process Manager Coupling Control Object Manager Identifier Mapping User Admin. Adapt. Adapt. Adapt. Local Applications File System RDB OpenDM Modules ... Application 2 • Data Dictionary represents the different data schemas in a uniform way • Object Manager co-ordinates the data access to the different databases and combines the partial results to a total result • Storage Manager support efficient client-caching where results are buffered in the application • Transaction Manager starts and commits transactions of the coupled database Common Internal IF Storage Manager Coupling Layer ... ... OODB

  8. Product Characteristics • Application Programming Interfaces • ODMG (ODL, OQL, C++ binding, and JAVA binding) • ODBC • generic API • Supported Databases • ODBC drivers • Oracle • Informix • MS SQL Server • Adabas D • Web-Application • Online database access via WWW • File system • Lotus Notes • MAPI (emails) • Sybase (near future)

  9. JAVA Beans JAVA Beans JAVA Internet JAVA RMI File System RDB OODB OpenWeb Internet Adapter for OpenDM

  10. Areas of Implementation • Technical or scientific organizations • Remote access to heterogeneous database systems required • Financial organizations • Consultants • Tele-workers • Enterprises with decentralized structure • Autonomous remote access for subsidiary

  11. User Values • Remote accessto enterprise information stored in different database management systems • Open to new technologieslike internet, interanet and object orientation • No inconsistency and redundancybetween the actual database and the web pages • Create and modify data in the enterprise databases remotely (not only read and search), tele-working • Simultanuous remote and local access to the enterprise database

More Related