Just another tech site

Database Connection (API)


Data API

Application have basic need to access data.
type of data

  • Flat File
  • structured file (CSV)
  • XML files
  • Blob file (images etc..)
  • Databases

The application will use API to access the data

[ref 2]

ODBC and OLEDB are data source interface drivers. These operate on a lower level then ADO.

DATA INTERFACES

MDAC

Microsoft Data Access Components

(From MS) The Microsoft Data Access Components are the key technologies that enable Universal Data Access. They include ActiveX Data Objects (ADO), Remote Data Service (RDS, formerly known as Advanced Data Connector or ADC), OLE DB, and Open Database Connectivity (ODBC).

MDAC Stack

The drivers

UDA

Universal Data Access. Here’s the UDA architecture as seen on MS site:
OLE DB + ADO

RDS

(MS) Remote Data Service (RDS) is a feature of ADO. RDS delivers a new Web data access technology that allows developers to create data-centric applications within ActiveX®-enabled browsers such as Microsoft® Internet Explorer.

DAO/RDO

ADO.NET

ADO is an application library

ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain.

These data providers include:
.NET Framework Data Provider for SQL Server.
.NET Framework Data Provider for OLE DB.
.NET Framework Data Provider for ODBC.
.NET Framework Data Provider for Oracle.

OLE DB

ODBC and OLEDB are data source interface drivers. These operate on a lower level then ADO.

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing data from a variety of sources in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL. [4]

ODBC

Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language. [3]

  • DSN = Data Source Name, ie. name given in ODBC to a connection profile.
  • User DSN = user-specific connections;
  • System DSN = system-wide connections, (ie. any user who logs on to this computer can use those DSN’s;)
  • File DSN = access to DSN definition files (*.DSN)?;
  • ODBC Drivers = list of drivers installed

Version History

1.0: released in September 1992
2.0: ca 1994
3.0: ca 1995
3.5: ca 1997
3.8: ca 2009, with Windows 7

JDBC

The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases – SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access.[5]

Reference

[1] http://msdn.microsoft.com/en-us/library/h43ks021.aspx
[2] https://msmvps.com/blogs/siva/archive/2010/10/14/o-data.aspx
[3] http://www.fredshack.com/docs/databases.html
[4] http://en.wikipedia.org/wiki/OLE_DB
[5] http://www.oracle.com/technetwork/java/javase/tech/index-jsp-136101.html
[6] http://msdn.microsoft.com/en-us/library/ms810829.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Tag Cloud

%d bloggers like this: