FACTOID # 10: The total number of state executions in 2005 was 60: 19 in Texas and 41 elsewhere. The racial split was 19 Black and 41 White.
 
 Home   Encyclopedia   Statistics   States A-Z   Flags   Maps   FAQ   About 
   
 
WHAT'S NEW
 

SEARCH ALL

FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:

 

 

(* = Graphable)

 

 


Encyclopedia > Microsoft Jet Database Engine
Jet is the database engine behind Microsoft's Access.

The Microsoft Jet Database Engine is a database engine on which several Microsoft products were built. A database engine is the underlying component of a database, a collection of information stored on a computer in a systematic way. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database. Image File history File links MicrosoftJet. ... Image File history File links MicrosoftJet. ... This article does not cite any references or sources. ... A dfgyfgdcdfgis the underlying component that a Database Management System (DBMS) uses to create, retrieve, update and delete (CRUD) data from a database. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... This article does not cite any references or sources. ... Year 1992 (MCMXCII) was a leap year starting on Wednesday (link will display full 1992 Gregorian calendar). ... It has been suggested that this article or section be merged into Modularity (programming). ...


JET stands for Joint Engine Technology, sometimes being referred to as Microsoft JET Engine or simply Jet. Microsoft Access and Visual Basic use or have used Jet as their underlying database engine. It has since been superseded, however, first by Microsoft Desktop Engine (MSDE), then later by SQL Server 2005 Express Edition and most recently by SQL Server 2005 Compact Edition, and no longer exists as a component of Microsoft Data Access Components (MDAC). For larger database needs, Jet databases can be upgraded (or in Microsoft parlance, "up-sized") to Microsoft's flagship database product, SQL Server 2005. This article does not cite any references or sources. ... Visual Basic (VB) is an event driven programming language and associated development environment from Microsoft for its COM programming model. ... MSDE stands for Microsoft Desktop Engine. ... SQL Server 2005 Express Edition is a free, light-weight, and redistributable edition of Microsoft SQL Server 2005. ... SQLCE (full name Microsoft Server Compact 2005 Edition) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. ... Microsoft Data Access Components (commonly abbreviated MDAC) is a group of Microsoft technologies that interact together as a framework that allows programmers a uniform and comprehensive way of developing applications for accessing almost any data store. ...

Contents

Architecture

Jet allowed the manipulation of relational database and was part of a Relational Database Management System (RDBMS). It offered a single interface that other software could use to access Microsoft databases and provided support for security, referential integrity, transaction processing, indexing, record and page locking, and data replication. In later versions, the engine was extended to be able to run SQL queries, store character data in Unicode format, create database views and allowed bi-directional replication with Microsoft SQL Server. A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... An interface defines the communication boundary between two entities, such as a piece of software, a hardware device, or a user. ... An example of a database that has not enforced referential integrity. ... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions that must be either entirely completed or aborted. ... In computer science, transaction processing is information processing that is divided into individual, indivisible operations, called Each transaction must succeed or fail as a complete unit; it cannot remain in an intermediate state. ... It has been suggested that Bitmap index be merged into this article or section. ... Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results. ... SQL (IPA: or IPA: ), commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... Unicode is an industry standard allowing computers to consistently represent and manipulate text expressed in any of the worlds writing systems. ... In database theory, a view is a virtual or logical table composed of the result set of a query. ...


There were three modules to Jet. One was the Native Jet ISAM Driver, a dynamic link library (DLL) that could directly manipulate Microsoft Access database files (MDB), which was a modified form of an Indexed Sequential Access Method (ISAM) database. Another one of the modules were the ISAM Drivers, DLLs that allowed access to ISAM databases, among them being Xbase, Paradox, Btrieve and FoxPro files. The final module was the Data Access Objects (DAO) DLL, DAO allowed programmers access to the Jet engine. It was basically an object-oriented data language used by Visual Basic for Applications and Visual Basic programmers to access Jet. Illustration of an application which may use libvorbisfile. ... ISAM stands for Indexed Sequential Access Method, a method for storing data for fast retreival. ... xBase is the generic term for all programming languages that derive from the original dBASE (Ashton-Tate) programming language and database formats. ... Paradox is a relational database management system currently published by Corel Corporation. ... In computing, Btrieve is a navigational database based on Indexed Sequential Access Method (ISAM), a way of storing data for fast retrieval. ... Visual FoxPro is a data-centric object-oriented and procedural programming language by Microsoft. ... Data Access Objects (DAO) were an object oriented interface created by Microsoft which allowed early versions of Microsoft Access and Visual Basic the Jet database engine. ... Object-oriented programming (OOP) is a computer programming paradigm in which a software system is modeled as a set of objects that interact with each other. ... // Description Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated development environment which is built into most Microsoft Office applications (including Apple Mac OS versions), some other Microsoft applications such as Microsoft MapPoint and Microsoft Visio - a former independent... Visual Basic (VB) is an event driven programming language and associated development environment from Microsoft for its COM programming model. ...


Locking

Jet allowed multiple users to access the database concurrently. To prevent that data from being corrupted or invalidated when multiple users tried to write to the database, Jet employed a data write locking policy. Any single user could only modify those database records (that is, items in the database) to which they had applied a lock that gave them exclusive access to the record until the lock was released. Up to Jet 4, a page locking model was used, and in Jet 4 a record locking model was employed. Microsoft databases are organised into data "pages", which are fixed length (2 kB before Jet 4, 4 kB in Jet 4) data structures that divide up the database. Data is stored in "records", but these are of variable length and so may take up less or more than one page. The page locking model worked by locking the pages, instead of individual records, which though less resource intensive also meant that more than one record might be locked at any one time. Record locking was introduced in Jet 4. In computer science, a database record is a description of a single item as stored in a database. ... In computer science, a lock is a synchronization mechanism for enforcing limits on access to a resource in an environment where there are many threads of execution. ... A kilobyte (derived from the SI prefix kilo-, meaning 1000) is a unit of information or computer storage equal to the decimal 1024 bytes (2 to the 10th power, or 1,024 bytes based in the binary system). ...


There were two mechanisms that Microsoft used for locking: pessimistic locking, and optimistic locking. With pessimistic locking, the record or page is locked immediately when the lock is requested, while with optimistic locking, the synchronization is delayed for transactions until the operations are actually performed. Conflicts are less likely to occur with optimistic locking; since the record is locked for a shorter duration of time, there is a lesser chance of someone needing to access it while it is locked. However, it cannot be certain that the update will succeed because another user could potentially update the record first. With pessimistic locking, the update is guaranteed to succeed once the lock is obtained, but other users are unable to make their own changes until the lock is released. Lock conflicts, which either require the user to wait, or cause the request to fail (usually after a timeout) are more common with this policy. In computer science -- more specifically, in the field of databases -- concurrency control is a method used to ensure that database transactions are executed in a safe manner (i. ...


Transaction processing

Jet supported transaction processing for database systems that had this capability (ODBC systems had one level transaction processing, while several ISAM systems like Paradox did not have transaction processing capability). A transaction is a series of operations performed on a database that must be done together — this is known as atomicity and is a part of ACID (Atomicity, Consistency, Isolation, and Durability), concepts considered to be the key transaction processing features of a database management system. For transaction processing to work (until Jet 3.0), the programmer needed to begin the transaction manually, perform the operations needed to be performed in the transaction, and then commit (save) the transaction. Until the transaction is committed, changes are made only in memory and not actually written to disk.[1] Transactions have a number of advantages over independent database updates. One of the main advantages is that transactions can be abandoned if a problem occurs during the transaction. This is called rolling back the transaction, or just rollback, and it restores the state of the database records to precisely the state before the transaction began. Transactions also permit the state of the database to remain consistent if a system failure occurs in the middle of a sequence of updates required to be atomic. There is no chance that only some of the updates will end up written to the database; either all will succeed, or the changes will be discarded when the database system restarts. With ODBC's in-memory policy, transactions also allow for many updates to a record to occur entirely within memory, with only one expensive disk write at the end. In computer science, transaction processing is information processing that is divided into individual, indivisible operations, called Each transaction must succeed or fail as a complete unit; it cannot remain in an intermediate state. ... In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ... In computer science, an atomic operation is one that either completes fully, or has no lasting effect. ... Acidity redirects here. ... A database management system (DBMS) is computer software designed for the purpose of managing databases. ...


Implicit transactions were supported in Jet 3.0 onwards. These are transactions that are started automatically after the last transaction was committed to the database. Implicit transactions in Jet occurred when an SQL DML statement was issued. However, it was found that this had a negative performance impact, so in Jet 3.5 Microsoft removed implicit transactions when SQL DML statements were made.[2] SQL (IPA: or IPA: ), commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... Data Manipulation Language (DML): is a family of computer languages used by computer programs or database users to retrieve, insert, delete and update data in a database. ...


Data integrity

An example of a database that has not enforced referential integrity. In this example, there is a foreign key (artist_id) value in the album table that references a non-existent artist — in other words there is a foreign key value with no corresponding primary key value in the referenced table. What happened here was that there was an artist called "Aerosmith", with an artist_id of "4", which was deleted from the artist table. However, the album Eat the rich referred to this artist. With referential integrity enforced, this would not have been possible.
An example of a database that has not enforced referential integrity. In this example, there is a foreign key (artist_id) value in the album table that references a non-existent artist — in other words there is a foreign key value with no corresponding primary key value in the referenced table. What happened here was that there was an artist called "Aerosmith", with an artist_id of "4", which was deleted from the artist table. However, the album Eat the rich referred to this artist. With referential integrity enforced, this would not have been possible.

Jet enforces entity integrity and referential integrity. Entity integrity is one of the key concepts of relational databases, and ensures that no record is able to be duplicated and also ensures that no field (or group of fields) that identify the record (the primary key) are NULL. Thus, Jet supports primary keys. Referential integrity is where the fields that identify data that exist in a database table (the foreign key) must correspond with an existing primary key in that database. If a foreign key value exists that does not have a corresponding primary key in the referenced table, then the referential integrity is broken and the data between tables will no longer be synchronised. Image File history File links An example of a database that has not enforced referential integrity. ... Image File history File links An example of a database that has not enforced referential integrity. ... An example of a database that has not enforced referential integrity. ... In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ... In database design, a primary key is a value that can be used to identify a unique row in a table. ... In a relational database, entity integrity is a property that ensures that no records are duplicated and that no attributes that make up the primary key are NULL. It is one of the properties necessary to ensure the consistency of the database. ... An example of a database that has not enforced referential integrity. ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ... In database design, a primary key is a value that can be used to identify a unique row in a table. ... Look up null in Wiktionary, the free dictionary. ... In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ...


For instance, a music lover may have a database that stores information about a record collection, and need to store data about an artist and his/her music. In this example, the artist can record many albums, but the album is only recorded by one artist, so two database tables are created: Artist and Album. The Artist table uses the field artist_id as its primary key, and the Album table uses album_id. The album table references the artist table using artist_id as a foreign key. If, for some reason, an artist is deleted and there is an album in the system that contains a reference to that artist then the referential integrity of this record would be broken. Jet will by default prevent this from happening. Jet is also capable of doing cascading updates and deletes. With cascading deletes enabled for the Album table, if the artist in the previous example were deleted, then all the artists' albums would also be deleted.


Jet also supports "business rules" (also known as "constraints"), or rules that apply to any column to enforce what data might be placed into the table or column. For example, a rule might be applied that does not allow a date to be entered into a date_logged column that is earlier than the current date and time, or a rule might be applied that forces people to enter a positive value into a numeric only field. In the context of a relational database, a column of a table is a set of data values of a particular simple type, one for each row of the table. ...


Security

Access to Jet databases is done on a per user-level. The user information is kept in a separate system database, and access is controlled on each object in the system (for instance by table or by query). In Jet 4, Microsoft implemented functionality that allowed database administrators to set security via the SQL commands CREATE, ADD, ALTER, DROP USER and DROP GROUP. These commands were a subset of ANSI SQL 92 standard, and they also applied to the GRANT/REVOKE commands.[3] When Jet 2 was released, security could also be set programmatically through DAO. Data Access Objects (DAO) were an object oriented interface created by Microsoft which allowed early versions of Microsoft Access and Visual Basic the Jet database engine. ...


Queries

Queries are the mechanisms that Jet uses to retrieve data from the database. They can be defined in Microsoft QBE (Query By Example), through the Microsoft Access SQL Window or through Access Basic's Data Access Objects (DAO) language. These are then converted to an SQL SELECT statement. The query is then compiled — this involves parsing the query (involves syntax checking and determining the columns to query in the database table), then converted into an internal Jet query object format, which is then tokenized and organised into a tree like structure. In Jet 3.0 onwards these were then optimised using the Microsoft Rushmore query optimisation technology. The query is then executed and the results passed back to the application or user who requested the data. Microsoft Query by Example (QBE) is a method of creating database queries using examples based on a text string, the name of a document or a list of documents. ... A SELECT statement in SQL returns a result set of records from one or more tables. ... It has been suggested that this article or section be merged with Compile (software company). ... Tokenizing is the operation of splitting up a string of characters into a set of tokens. ...


Jet passes the data retrieved for the query in a dynaset. This is a set of data that is dynamically linked back to the database. Instead of having the query result stored in a temporary table, where the data cannot be updated directly by the user, the dynaset allows the user to view and update the data contained in the dynaset. Thus, if a university lecturer queried all students who received a distinction in their assignment and found an error in that student's record, they would only need to update the data in the dynaset, which would automatically update the student's database record without the need for them to send a specific update query after storing the query results in a temporary table. A dynaset (short for dynamic set) is a set of data that is dynamically linked back to the database. ...


History

Jet DLLs
Jet version Jet engine DLL file name MDB version
1.1 1.10.0001 MSAJT110.DLL 1.0 / 1.1
2.0 (comlyr) 2.00.0000 MSAJT200.DLL 1.0 / 1.1 / 2.0
2.5 (accsvc) 2.50.1606 MSAJT200.DLL 1.0 / 1.1 / 2.0 / 3.0
2.5 (VB4 16) 2.50.1606 MSAJT200.DLL 1.0 / 1.1 / 2.0 / 3.0
3.0 3.0.0.2118 MSJT3032.DLL 1.0 / 1.1 / 2.0 / 3.0
3.5 MSJET35.DLL 1.0 / 1.1 / 2.0 / 3.0
4.0 (SP7) 4.0.7328.0 MSJET40.DLL 1.0 / 1.1 / 2.0 / 3.0 / 4.0
Application/Version Jet version
Microsoft Access 1.0 1.0
Microsoft Access 1.1 1.1
Microsoft Access 2.0 2.0
Microsoft Access 2.0 2.5 with Microsoft Access Service Pack
Microsoft Access 7.0 3.0
Microsoft Access 97 3.5 with Office 97
Microsoft Access 97 SR1 3.5 with Office 97SR1
Visual Basic 3.0 1.1
Visual Basic 3.0 2.0 with Visual Basic Compatibility Layer
Visual Basic 3.0 2.5 with Microsoft Access Service Pack
Visual Basic 4.0 16-bit 2.5
Visual Basic 4.0 32-bit 3.0
Visual Basic 5.0 32-bit 3.0
Visual Basic 5.0 32-bit 3.5
Visual C++ 4.X 3.0
Visual C++ 5.0 3.5
Jet 3.51 (web download) 3.51 (3.5 Binary compatible)
Microsoft Access 2000 Standard Edition
Microsoft Access 2002 Standard Edition
Microsoft Access 2003 Standard Edition
4.0

Jet originally started in 1992 as an underlying data access technology that came from a Microsoft internal database product development project, code named Cirrus. Cirrus was developed from a pre-release version of Visual Basic code and was used as the database engine of Microsoft Access. Tony Goodhew, who worked for Microsoft at the time, says Image File history File links Download high resolution version (899x406, 28 KB)Conceptual diagram of Microsoft Jet DLLs. ... This article does not cite any references or sources. ... Visual Basic (VB) is an event driven programming language and associated development environment from Microsoft for its COM programming model. ... Visual C++ 6. ... This article does not cite any references or sources. ... Year 1992 (MCMXCII) was a leap year starting on Wednesday (link will display full 1992 Gregorian calendar). ... This article does not cite any references or sources. ...

"It would be reasonably accurate to say that up until that stage Jet was more the name of the team that was assigned to work on the DB engine modules of Access rather than a component team. For VB [Visual Basic] 3.0 they basically had to tear it out of Access and graft it onto VB. That's why they've had all those Jet/ODBC problems in VB 3.0."

Jet became more componentised when Access 2.0 was released because the Access ODBC developers used parts of the Jet code to produce the ODBC driver. A retrofit was provided that allowed Visual Basic 3.0 users to use the updated Jet issued in Access 2.0.[4]


Jet 2.0 was released as several dynamic linked libraries (DLLs) that were utilised by application software, such as Microsoft's Access database. DLLs in Windows are "libraries" of common code that can be used by more than one application — by keeping code that more than one application uses under a common library which each of these applications can use independently code maintenance is reduced and the functionality of applications increases, with less development effort. The three dlls that comprised Jet 2.0 were the Jet DLL, the Data Access Objects (DAO) DLL and several external ISAM DLLs. The Jet DLL determined what sort of database it was accessing, and how to perform what was requested of it. If the data source was an MDB file (a Microsoft Access format) then it would directly read and write the data to the file. If the data source was external, then it would call on the correct ODBC driver to perform its request. The DAO DLL was a component that programmers could use to interface with the Jet engine, and was mainly used by Visual Basic and Access Basic programmers. The ISAM DLLs were a set of modules that allowed Jet to access three ISAM based databases: Xbase, Paradox and Btrieve.[5] Illustration of an application which may use libvorbisfile. ... This article does not cite any references or sources. ... To meet Wikipedias quality standards, the lead section of this article may need to be expanded. ... Data Access Objects (DAO) were an object oriented interface created by Microsoft which allowed early versions of Microsoft Access and Visual Basic the Jet database engine. ... xBase is the generic term for all programming languages that derive from the original dBASE (Ashton-Tate) programming language and database formats. ... Look up paradox in Wiktionary, the free dictionary. ... In computing, Btrieve is a navigational database based on Indexed Sequential Access Method (ISAM), a way of storing data for fast retrieval. ...


Jet 3.0 included many enhancements, including a new index structure that reduced storage size and the time that was taken to create indices that are highly duplicated, the removal of read locks on index pages, a new mechanism for page reuse, a new compacting method for which compacting the database resulted in the indices being stored in a clustered-index format, a new page allocation mechanism to improve Jet's read-ahead capabilities, improved delete operations that speeded processing, multithreading (three threads were used to perform read ahead, write behind, and cache maintenance), implicit transactions (users did not have to instruct the engine to start manually and commit transactions to the database), a new sort engine, long values (such as memos or binary data types) were stored in separate tables, and dynamic buffering (whereby Jet's cache was dynamically allocated at start up and had no limit and which changed from a first in, first out (FIFO) buffer replacement policy to a least recently used (LRU) buffer replacement policy).[6] Jet 3.0 also allowed for database replication. It has been suggested that Bitmap index be merged into this article or section. ... In computer science, a lock is a mechanism for enforcing limits on access to a resource in an environment where there are many threads of execution. ... Many programming languages, operating systems, and other software development environments support what are called threads of execution. ... FIFO is an acronym for First In, First Out. ... Cache algorithms are optimizing instructions â€“ algorithms â€“ that a computer program can follow to manage a cache of information stored on the computer. ...


Jet 4.0 was the last version produced by Microsoft. It had numerous additional features and enhancements:[7]

  • Unicode character storage support, along with an NT sorting method that was also implemented in the Windows 95 version;
  • Changes to data types to be more like SQL Server's (LongText or Memo; Binary; LongBinary; Date/Time; Real; Float4; IEEESingle; Double; Byte or Tinyint; Integer or Integer synonyms Smallint, Integer2, and Short; LongInteger or LongInteger synonyms Int, Integer, and Counter; Auto-Increment support was dropped; Currency or Money; Boolean and GUID); a new decimal data type
  • Memo files could be indexed
  • Compressible data types
  • SQL enhancements to make Jet conform more closely to ANSI SQL 92
  • Finer grained security; views support; procedure support
  • Invocation and termination (committing or rolling back) of transactions
  • Enhanced table creation and modification
  • Referential integrity support
  • Connection control (connected users remain connected, but once disconnected they cannot reconnect, and new connections cannot be made. This was useful for database administrators to gain control of the database)
  • A user list, which allows administrators to determine who is connected to the database
  • Record-level locking (previous versions only supported page-locking)
  • Bi-directional replication with MS SQL Server.

Jet 4 databases can be "upsized" (upgraded) to "an equivalent database on SQL Server with the same table structure, data, and many other attributes of the original database" if the developer has a copy of Microsoft Office 2000 Professional Edition via a Microsoft Access Upsizing Wizard utility. Reports, queries, macros and security is not handled by this tool, meaning that some manual modifications may need to be done if the developer has been heavily reliant on these Jet features.[8] Unicode is an industry standard allowing computers to consistently represent and manipulate text expressed in any of the worlds writing systems. ... Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993. ... Windows 95 is a consumer-oriented graphical user interface-based operating system. ... Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. ... SQL (IPA: or IPA: ), commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... An example of a database that has not enforced referential integrity. ... Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server. ... Microsoft Office is an office suite from Microsoft, which is available on the Microsoft Windows and Apple Mac OS X operating systems. ...


Future

From a data access technology standpoint, Jet is considered a deprecated technology by Microsoft.[9] The Jet engine is no longer distributed with the latest Microsoft Data Access Components. However, Jet is and will continue to be the primary database engine for Microsoft Access. In fact, Jet is essentially going back to its roots with Access 2007, by being distributed (and supported) only within Access.[10] Microsoft Data Access Components (commonly abbreviated MDAC) is a group of Microsoft technologies that interact together as a framework that allows programmers a uniform and comprehensive way of developing applications for accessing almost any data store. ...


The Jet Database Engine will remain 32-bit for the foreseeable future. Microsoft has no plans to natively support Jet under 64-bit versions of Windows. This means that native 64-bit applications (such as the 64-bit versions of SQL Server) cannot access data stored in MDB files through ODBC, OLE DB, or any other means, except through intermediate 32-bit software that acts as a proxy for the 64 bit client.[1] 32-bit is a term applied to processors, and computer architectures which manipulate the address and data in 32-bit chunks. ... In computing, a 64-bit component is one in which data are processed or stored in 64-bit units (words). ... OLE DB (sometimes written as OLEDB or OLE-DB), Object Linking and Embedding for Databases, is a means Microsoft use for accessing different types of data stores in a uniform manner. ...


References

Wikibooks
Wikibooks has a book on the topic of
JET Database
  1. ^ Gorm Braarvig. Access database from SQL 2005/64. Retrieved on 2007-06-18.
  1. ^  Microsoft Jet Database Engine 2.0: A User's Overview (see "Jet Transactions" section), retrieved August 2, 2005
  2. ^  Kevin Collins (Microsoft Jet Program Management), "Microsoft Jet 3.5 Performance Overview and Optimization Techniques", MSDN. Retrieved July 19, 2005.
  3. ^  Microsoft, MS KB article 275561: "Description of the new features that are included in Microsoft Jet 4.0"
  4. ^  Tony Goodhew, "Jet Engine: History". Accessed July 14, 2005.
  5. ^  Paul Litwin (1994), Microsoft Jet Database Engine 2.0: A User's Overview, retrieved July 14, 2005.
  6. ^  Microsoft, MS KB article 137039 New Features in Microsoft Jet Version 3.0, last updated December 9, 2003, retrieved July 14, 2005.
  7. ^  Microsoft, MS KB article Q275561 Description of the new features that are included in Microsoft Jet 4.0
  8. ^  Microsoft, "Microsoft® Access 2000 Data Engine Options", white paper.
  9. ^  Microsoft, Data Access Technologies RoadMap
  10. ^  Erik Rucker (Microsoft Access - Group Program Manager), Access 12's new data engine retrieved July 10, 2006

  Results from FactBites:
 
Microsoft Jet Database Engine - Wikipedia, the free encyclopedia (2675 words)
Microsoft databases are organised into data "pages", which are fixed length (2 kB) data structures that divide up the database.
Jet passes the data retrieved for the query in a dynaset.
Jet 4 databases can be "upsized" (upgraded) to "an equivalent database on SQL Server with the same table structure, data, and many other attributes of the original database" if the developer has a copy of Microsoft Office 2000 Professional Edition via a Microsoft Access Upsizing Wizard utility.
DataBase Engines (481 words)
However, the 3.0 version of the Microsoft Jet database engine, which appeared in Microsoft Access 95, was completely rewritten as a 32-bit multithreaded process.
In querying situations, in particular, the difference between the two engines may be small, due to the fact that the Microsoft Jet engine was rewritten to use many of the performance techniques originally found in the FoxPro engine.
One reason SQL Server may outperform those engines is that its processing power resides on a high-end machine that is not restricted by bottlenecks such as slow network infrastructure (that is, NIC cards, slow protocol, and transport).
  More results at FactBites »

 
 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments

Want to know more?
Search encyclopedia, statistics and forums:

 


Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms, 1022, m