Data Access Objects


Data Access Objects

Data Access Objects is a general programming interface for database access on Microsoft Windows systems and should not be confused with the Data Access Object design pattern used in object-oriented software design.

History

DAO were originally called VT Objects. DAO 1.0 came up in November 1992. In version 3.5 it was able to bypass the Jet engine altogether and directly access ODBC data sources, including Microsoft SQL Server and other enterprise database systems. DAO 3.6 was the final version developed by Microsoft. Microsoft says that DAO will not be available in its future 64-bit operating systems. [ [http://msdn2.microsoft.com/en-us/library/ms810810.aspx#mdac%20technologies%20road%20map%20old_topic9 Data Access Technologies Road Map ] ]

Design

DAO works by creating a "Workspace" object in which all database operations are performed. The workspace object exists as a session object that exists within a larger database engine object. There are two types of database engines: a Jet database engine object, and an ODBCDirect database engine.

Jet

The Jet database engine object consists of several objects:

* a workspace object containing
* a groups and users object
* a database object containing
* container objects which consist of
* containers of objects
* query definition (QueryDef) objects
* Recordset objects which are defined by a set of field objects
* relation objects which show the relationship between different fields in the database
* table definition (TableDef) objects which consists of fields and indexes of selected fields.
* a series of error objects

ODBCDirect

The ODBCDirect database engine consists of a workspace object and an errors object. The main differences between this database engine and the Jet database engine are:

* the workspace object contains only a series of ODBC connection objects
* the database object consists of a series of recordset objects

The ODBC connection objects consist of QueryDef objects and recordset objects.

See also

* Microsoft Data Access Components
* ActiveX Data Objects (ADO)
* Remote Data Objects (RDO)

References


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Data Access Objects — Saltar a navegación, búsqueda Data Access Objects (DAO, Objetos de Acceso a Datos) es una interfaz orientada a objetos creada por Microsoft la cual permitía a las primeras versiones de Microsoft Access y Visual Basic utilizar el motor de base de… …   Wikipedia Español

  • Data Access Objects — Data Access Objects, in der deutschsprachigen Dokumentation „Datenzugriffsobjekte“, üblicherweise mit der Abkürzung „DAO“ bezeichnet, ist eine Schnittstellen Bibliothek von Microsoft für den Zugriff auf Daten und Strukturen von Datenbanken,… …   Deutsch Wikipedia

  • Data Access Objects — Data Access Objects,   DAO …   Universal-Lexikon

  • Data Access Objects — У этого термина существуют и другие значения, см. DAO. Data Access Objects (DAO)  технология доступа к данным компании Microsoft. Содержание 1 История 2 DAO и системы клиент сервер …   Википедия

  • Data Access Objects — program interface of Microsoft used in applications that require access to databases, DAO …   English contemporary dictionary

  • Jet Data Access Objects — Not to be confused with Data access object. Jet Data Access Objects is a deprecated general programming interface for database access on Microsoft Windows systems. It is unrelated to the data access object design pattern used in object oriented… …   Wikipedia

  • Data Access Object — Saltar a navegación, búsqueda En software de computadores, un Data Access Object (DAO, Objeto de Acceso a Datos) es un componente de software que suministra una interfaz común entre la aplicación y uno o más dispositivos de almacenamiento de… …   Wikipedia Español

  • Data access object — This article is about the data access object design pattern in object oriented software design. For the Microsoft library of the same name, see Data Access Objects. In computer software, a data access object (DAO) is an object that provides an… …   Wikipedia

  • Data Access Object — This article is about the Data Access Object design pattern in object oriented software design, not about the Data Access Objects library from Microsoft. In computer software, a Data Access Object (DAO) is an object that provides an abstract… …   Wikipedia

  • Data Access Object — В программном обеспечении data access object (DAO)  это объект, который предоставляет абстрактный интерфейс к какому либо типу базы данных или механизму хранения. Определённые возможности предоставляются независимо от того, какой механизм… …   Википедия


Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.