Middleware increases the flexibility, interoperability, and portability of existing infrastructure by linking or “gluing” two otherwise separate applications.
- Database Access: ISQL/w
Microsoft’s implementation of ANSI SQL
- Database Access: NET8
NET8 (called SQL*NET prior to Oracle8) is Oracle’s client/server middleware product that offers transparent connection from client tools to the database, or from one database to another. SQL*Net/ Net8 works across multiple network protocols and operating systems. Previous versions referred to as SQL*Net.
- Database Access: OPEN ANSI SQL/92
SQL is the information processing industry standard language of relational database management systems (RDMS). ANSI X3.135-1992 (also referred to as SQL-92 and ANSI SQL) is the industry standard for Database Language SQL. This standard promotes the portability and interoperability of database application programs and facilitates maintenance of database systems across heterogeneous data processing environments. SQL-92 provides a standardized way for embedding SQL statements into application development languages.
- Database Access: PL/SQL
Oracle’s procedural extension to industry-standard SQL.
- Message-Oriented Middleware (MOM): IBM Websphere MQ
Software solution providing APIs, queue management, message routing, automatic fail-over, and workload balancing.
- Message-Oriented Middleware (MOM): Microsoft Message Queue (MSMQ)
Software technology providing synchronous and asynchronous message queueing, routing, and security.
- Object Request Broker (ORB): Common Object Request Broker Architecture (CORBA)
An architecture that enables objects to communicate with one another regardless of what programming language they were written in or what operating system they’re running on.
- Object Request Broker (ORB): Component Object Model (COM)
A software architecture created by Microsoft to design and build component-based applications. COM object capabilities are accessible from exposed interfaces.
- Object Request Broker (ORB): Component Object Model + (COM+)
COM+ is an extension of the COM that provides a runtime and services that are readily used from any programming language or tool, and enables extensive interoperability between components regardless of how they were implemented.
- Object Request Broker (ORB): Distributed Component Object Model (DCOM)
An extension of the Component Object Model (COM) that allows COM components to communicate across network boundaries. Traditional COM components can only perform interprocess communication across process boundaries on the same machine.
- Remote Procedure Call (RPC)
RPC is a protocol allowing a program on a client computer to invoke a program on a server computer.
- Transaction Processing Monitor
Software providing synchronous messaging and queuing along with other transaction management services designed to support the efficient processing of high volumes of transactions. Core services include load balancing, rollback/commit, and recovery. Transaction Processing provides cost-effective scalability to applications and database systems by managing and throttling transactions on behalf of the database system.
