deferred-write: The transaction do not immediate update database, instead, only update log file. Then when transaction reach commit point, it will update the physical database.
write-through: The database is update right away during the transaction execution.
a) Identify and describe FIVE characteristics of an efficient database
Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency
keywords
Database security is a term that is used to describe the saftey invested into a single database, or storage of numerous information and confidentials on a computer.
remote backup system.
Database software, such as Microsoft Access, allows users to maintain records of related information.
database management system that end users and programmers use to manipulate data in the database.
Database properties are also known as database attributes or characteristics. These properties describe the features and characteristics of the database, such as data types, constraints, relationships, and indexing among others. They are essential for defining the structure and behavior of a database system.
Concurrency means use of database by many users at the same time.Concurrency control techniques (Different techniques) are used control multiple transactions interfere each other to produce wrong results. therefore one of the main techniques used to control concurrent execution of transaction is based on the concept of locking of data item. A lock is a variable associated with a data item in the database and describes the status of that item with respect to possible operation that can be applied to that item. Generally there is a one lock for each data item in the database.
Data definition is the term used to describe expected data value.
A data dictionary is a document that describes database objects such as tables, columns, and their corresponding data types. It provides information about the structure, relationships, and constraints of the database schema.
Andrew H. Bullen has written: 'Database techniques for librarians' -- subject(s): Data processing, Database management, Libraries, Turbo Pascal (Computer file)