The connecting API includes
- CLI – Call Level Interface
- ODBC – Open Data Base Connectivity
- JDBC – Java Data Base Connectivity
Call Level Interface (CLI)
From implementation perspective, CLI is a collection of callable service routines that provide the interface between external applications and the Data Processing System.The Call Level Interface defines how a program should send queries to the data management system and how the returned result set should be handled by the application in a consistent way.
CLI sends requests to the DPS and provides the application with a response returned from the system.
CLI should provide support for:
- Managing multiple serially-executed requests on a session
- Managing multiple simultaneous sessions to the same, or different node
- Using cooperative processing so that the application can perform operations on the client and the DPS simultaneously
- Insulating the application from details in communicating with a DPS
Open Database Connectivity (ODBC)
Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). ODBC works independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side. A few changes to the data access code may be needed.
ODBC API uses ODBC “driver” as a translation layer between the application and the DPS. The application uses ODBC functions through an ODBC “driver manager” with which it is linked, and the driver passes the query to the Data Processing System. Any application that can use ODBC is referred to as “ODBC-compliant”.
Java DataBase Connectivity (JDBC)
Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is part of the Java Standard Edition platform, from Oracle Corporation. It provides methods to query and update data in a database, and is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the Java virtual machine (JVM) host environment.