Web Infrastructure  «Prev  Next»
Lesson 5Data integration middleware
ObjectiveDescribe the function of data integration middleware

Data Integration Middleware

What is data integration middleware?

Data integration middleware provides services that allow applications and development tools to view different underlying data structures and data sources as a single data source. This means that an application is not affected by physical implementation of data structure. The illustration below explains why this is important:

This shows why data integration middleware. is so useful
This shows why data integration middleware. is so useful

A table can be created within a specific database, but to the user it will look like any database table. Data integration middleware can also make multiple tables look as if they are one.
Like other middleware tools, data integration middleware abstracts the details of underlying constructs such as data constructs, and it makes it easier for the software layer above (and the user) to use those constructs. Undoubtedly the most popular method of accessing data through this abstracted layer is throughODBC JDBC.
  1. ODBC(Open Database Connectivity): OBDC inserts a middle layer, better known as a database driver, making it possible to access any data from any application, regardless of which database management system handles the data. For this to occur, the application must be capable of issuing ODBC commands and the database management system must be capable of responding to them.
  2. JDBC (Java Database Connectivity): A programming interface that lets Java applications access a database via the SQL language. Since Java interpreters (Java Virtual Machines) are available for all major client platforms, this allows a platform-independent database application to be written. In 1996, JDBC was the first extension to the Java platform. JDBC is the Java counterpart of Microsoft's ODBC.

Remote data integration

Just as RPCs deal with process interoperability between remote programs, there are products, known as SQL Gateways,that support data integration remotely. SQL gateways are useful when dealing with applications that have a high number of temporarily connected users and that possess heterogeneous database sources. This is frequently true of B2C applications. Many application servers now possess a similar form of SQL gateway functionality.
The next lesson discusses distributed object middleware.