Microsoft Jet Database Engine - Architecture

Architecture

Jet allows the manipulation of a relational database and is part of a Relational Database Management System (RDBMS). It offers a single interface that other software can use to access Microsoft databases and provides support for security, referential integrity, transaction processing, indexing, record and page locking, and data replication. In later versions, the engine has been extended to be able to run SQL queries, store character data in Unicode format, create database views and allow bi-directional replication with Microsoft SQL Server.

There are three modules to Jet: One is the Native Jet ISAM Driver, a dynamic link library (DLL) that can directly manipulate Microsoft Access database files (MDB) using Indexed Sequential Access Method (ISAM). Another one of the modules contains the ISAM Drivers, DLLs that allow access to a variety of ISAM databases, among them Xbase, Paradox, Btrieve and FoxPro, depending on the version of Jet. The final module is the Data Access Objects (DAO) DLL. DAO provides an API that allows programmers to access JET databases using any programming language.

Read more about this topic:  Microsoft Jet Database Engine

Famous quotes containing the word architecture:

    Art is a jealous mistress, and, if a man have a genius for painting, poetry, music, architecture or philosophy, he makes a bad husband and an ill provider.
    Ralph Waldo Emerson (1803–1882)

    No architecture is so haughty as that which is simple.
    John Ruskin (1819–1900)