Database Interface Languages

CBK Applications and Systems Development Security (Part-1)

Written by Administrator

Thursday, 09 July 2009 08:54

Article Index
CBK Applications and Systems Development Security (Part-1)
Functionality vs Security
Database Management System
Database models
Database Interface Languages
Relational Database Components
Normalization
Integrity
Database Security Controls
Data Warehousing and Data Mining
Web Services
System Development
Functional Design Analysis and Planning
System Development Process Models
Verification vs Validation
Separation of Duties in System Development
Configuration management
All Pages

Page 5 of 17

Databases need some type of interface and communication mechanism. These include:

Open Database Connectivity (ODBC) An application programming interface (API) that allows an application to communicate with a database either locally or remotely. The application sends requests to the ODBC, which in turn translates them into database commands. ODBC tracks down the necessary database driver for the application.
Object Linking and Embedding Database (OLE DB) It separates data into components that run as middleware on a client or server. It provides a low level interface to link information across different databases.
ActiveX Data Objects (ADO) An API that allows applications to access back-end database systems. It is a set of ODBC interfaces that exposes the functionality of a database through accessible objects. ADO uses the OLE DB interface to connect with the database and can be developed with many different scripting languages.
Java Database Connectivity (JDBC) An API that allows a Java application to communicate with a database. The application can connect through ODBC or directly to the database.
Extensible Markup Language (XML) A standard for structuring data so that it can be easily shared by applications using web technologies.
<< Prev - Next >>

Last Updated on Friday, 28 August 2009 05:04

Please register or login to add your comments to this article.

SecurityArena