Databases

Paper Summary:

This paper presents the many standards for accessing data including Open Database Connectivity (ODBC), OLE DB, Active Data Objects (ADO), and Common Object Request Broker Architecture (CORBA). The paper contends that the world of integration middleware is constantly evolving. Initial standards from Microsoft such as ODBC have been replaced by OLE DB, which it then enhanced with ADO. The paper claims that not only do replacement standards emerge, but competing standards vie for acceptance. DCOM and COBRA are two such examples that have pros and cons, forcing companies to make tradeoffs in their application development and interoperability decisions.

From the Paper:

"ODBC is an open standard application programming interface (API) for accessing a relational database (Open Database Connectivity, TechTarget). By using ODBC statements in a program, the application can access files in databases that support the standard. ODBC was created by the SQL Access Group and first released in 1992. Although Microsoft Windows was the first to provide an ODBC product, versions now exist for most platforms. ODBC is based on and closely aligned with The Open Group standard Structured Query Language (SQL) Call-Level Interface (Open Database Connectivity, TechTarget). It allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. ODBC handles the SQL request and converts it into a request the individual database system understands. In addition to the ODBC software, a separate module or driver is needed for each database to be accessed."

More papers on Databases:

• Essay # 73195 : "Distributed Databases"
• Research Paper # 54912 : "Federated Databases"
• Comparison Essay # 45339 : "Object and Relational Databases"
• Essay # 47187 : "Wallets and Databases"

APA Citation:

MLA Citation: