Microsoft Jet Engine

from Wikipedia, the free encyclopedia
This article or the following section is not adequately provided with supporting documents ( e.g. individual evidence ). Information without sufficient evidence could be removed soon. Please help Wikipedia by researching the information and including good evidence.

Microsoft Jet Engine ( Microsoft J oint E ngine T echnology Engine ) is an engine introduced in 1992 for relational databases under Windows operating systems. Microsoft developed two completely independent versions of the Jet: Red and Blue .

Jet Red

The Jet Red is a relational database and provides the interface between the database and the user requests. They are used in desktop databases. It is usually distributed in combination with other programs, such as B. Access or Visual Basic , but was part of the Microsoft Data Access Components ( MDAC , up to version 2.5), which can be downloaded from the Microsoft homepage (file name:) MDAC_TYP.EXE. The current Jet Engine can now be installed using Jet Engine Service Pack 8 . It is integrated into these programs via DLLs .

The Jet Engine offers:

  • Multiuser (theoretically up to 255, but realistically only up to 80 simultaneously, with write access rather less than 10)
  • Integrated query processor (commands are processed as follows: Definition # Compilation # Optimization # Execution)
  • built-in integrity check
  • Security functions (including user authorizations)
  • Remote access options

By default, Jet stores data in Microsoft Database Files ( .mdb), but it also supports other formats such as dBASE , Paradox , Microsoft FoxPro , Microsoft Excel, and ODBC .

Since Access 2007 with the JET version Access Connectivity Engine (ACE) is the standard format .accdb.

Versions of the jet engine and their use:

  • 1.0
    • Access 1.0
  • 1.1
    • Access 1.1
    • Visual Basic 3.0
  • 2.0
    • Access 2.0
  • 2.5
    • Access 2.0
    • Visual Basic 4.0 (16 bit)
  • 3.0
    • Access 95
    • Excel 95
    • Project 4.1
    • Project 95
    • MFC 4.x
    • Visual Basic 4.0 (32 bit)
  • 3.5
  • 4.0
    • Access 2000-2003
  • ACE 12.0
    • Access 2007
  • ACE 14.0
    • Access 2010
  • ACE 15.0
    • Access 2013

As an alternative and possible successor, the Microsoft Desktop Engine (MSDE), or from version 2005 called SQL Server Express , a free but somewhat restricted version of the MS SQL Server is available. It is used u. a. from SQL Server 7.0 and as a second engine for Access from Access 2000.

Jet blue

The Jet Blue, also known as the Extensible Storage Engine (ESE) , presents itself completely different . Jet Blue is also an RDBMS, but it is based on write-ahead logging with two-phase commit and is especially optimized for semi-structured data. It was used for the first time in Exchange Server 4.0 and is still the basis for this server in the current version of Exchange. In addition to the Exchange Server, the Jet Blue is also used in other products:

  • Active Directory Engine
  • WINS
  • File Replication Service
  • Security Configuration Editor
  • Certificate Services
  • Microsoft Update Client
  • Windows Desktop Search (as metadata store)

The engine is intended for a significantly larger number of accesses than the Jet from Access. Even more than 3,000 parallel connections are no problem, with 8 processors (currently the maximum), more than 10,000 simultaneous connections are possible. The current version number of the Jet Blue is 4.0.