by DAN CALLOWAY
Published 8 February 2010 @ 14:16 UTC
WEAVERVILLE, NC - Middleware is computer software that sits between two or more applications, which runs a set of services that permit multiple processes running on one or more machines to interact with one another. In the case of databases in a DBMS, middleware addresses the problem of interoperability among different databases, and allows for transparent access to legacy database applications or DBMS via a Webserver without regard to database-specific characteristics. An example of middleware used in conjunction with DBMS is SQL-oriented Data Access, which is a form of middlware that allows for access between applications and database servers (“Middleware – Wikipedia, the free encyclopedia,” 2010).
The implementation of middleware to support DBMS or data warehousing is not necessary if the users are accessing traditional DBMS in closed environments through restricted networks or an enterprise’s intranet. However, with the advent of the World Wide Web, with the implementation of middleware for database support, users can access virtually any database in the world for which they have authorized user access and can utilize the data in their own applications running on their machines and their networks (“Middleware – Wikipedia, the free encyclopedia,” 2010).
The use of middleware definitely has an impact on whether the implementation and use of a DBMS or data warehouse will be successful and accepted since it: (1) permits the transparent location across the network, of databases, thus, in the case of disparate database structures, providing essential interaction with another service or application; (2) is independent from network services; and, (3) is reliable and always available (“Middleware – Wikipedia, the free encyclopedia,” 2010).
A prime example of DBMS middleware is Oracle Fusion Middleware 11g. Oracle, Inc., recently acquired Sun Microsystems. Oracle’s acquisition of Sun Microsystem further enhanced its top-rated middleware portfolio, which reinforced Oracle’s commitment to provide best-in-class software to meet the business and IT needs of well over 90,000 of its middleware customers worldwide (“Oracle Fusion Middleware,” 2010).
References:
Middleware – Wikipedia, the free encyclopedia. (2010). Middleware – Wikipedia, the free encyclopedia. Retrieved February 4, 2010, from http://en.wikipedia.org/wiki/Middleware
Oracle Fusion Middleware. (2010). Oracle Fusion Middleware. Retrieved February 4, 2010, from http://www.oracle.com/us/products/middleware/044270.html
Recent Comments