What Is Open Database Connectivity And What Are Its Advantages? Article

	1888 Articles Home \| Computer Articles \| Software Articles \| Windows Articles	Software RSS
What is Open Database Connectivity and what are its Advantages?

In web and software development, ODBC (Open Database Connectivity) presents a standard software API technique for using database management systems (DBMS).

Author: Anirban

Article Tools:

It represents a standard database access method working as SQL API software. Developed in the early 90’s, ODBC was intended to help developers access to any data through any application, no matter what database management system is used for managing data. One of the core advantages of an Open Database Connectivity is its platform independence. This is because the designers planned to make it independent of database systems, programming languages and operating systems.

Accessing data from an application to a database management system through ODBC is done through a specific system. An ODBC implementation contains more than one application: an important ODBC “Driver Manager” library and one or more “database drivers”. The Driver Manager is independent of the DBMS and applications. It acts as an “interpreter” between the database drivers and applications, whereas the database drivers act as a middle layer included between an application and DBMS in use. This ensures the application’s data queries get translated into commands that can be easily deciphered by the DBMS.

The modular nature of Open Database connectivity provides a web application development expert valuable independence in creating separate components of an ODBC implementation. Thus, a web & software development professional can use standard features in writing applications without worrying about the DBMS type that is accessed by an application.

Due to its offer to access a wider range of data sources than any other database access model, it is also used as an affordable web development tool by professional web development companies in India. It has transformed into a universal data access standard by working with a great variety of operating systems and provided access even to non-relational data like XML or text files.

About Author

I am the webmaster at www.synapseindia.com
– A web development company offering affordable web development to businesses in India and abroad.

Article Source: http://www.1888articles.com/author-anirban-406.html

What is Open Database Connectivity and what are its Advantages?