Services Provided by the Microsoft Jet Database Engine
Microsoft Jet provides a variety of database management services, including data definition, data manipulation, data integrity, and security. There are seven basic services that a DBMS should provide. This section introduces these services and shows how Microsoft Jet accomplishes each one. The seven basic functions of a DBMS are:
-
Data definition and integrity: create and modify structures for holding data, such as tables and fields, and ensure that rules to prevent data corruption from invalid entries or operations are applied to data operations.
-
Data storage: store data in the file system.
-
Data manipulation: add new data, modify or delete existing data.
-
Data retrieval: retrieve data from the system.
-
Security: control users’ access to database objects and data, thereby protecting the objects and data against unauthorized use.
-
Data sharing: share data in a multiuser environment.
-
Database maintenance: compact, repair, and convert data and database objects.