Database Information Systems
Relational Database SQL
Database Management System (DBMS) Data
Information Value

 

A system that collects, processes, stores, analyzes, and disseminates information for a specific purpose. A structured set of data stored electronically.
Structured Query Language, a programming language used for managing relational databases. A type of database that organizes data into tables with rows and columns, and establishes relationships between tables.
Raw facts or figures that have not yet been processed or analyzed. A software system that manages databases, providing interfaces for users to interact with the data.
The worth or significance of data or information in a particular context. Processed and analyzed data that is meaningful and useful.

 

Accuracy Relevance
Interpretation Knowledge
Data Quality Data Processing
Decision Making Object-Oriented Database

 

The quality or state of being closely connected or appropriate to a specific purpose or topic. The degree to which data or information is correct, precise, and free from errors.
The understanding or awareness acquired through the interpretation and application of information. The act of explaining or making sense of data or information by considering its context and implications.
The transformation of raw data into a meaningful format through various operations and actions. The level of accuracy, completeness, and consistency of data.
A type of database that stores data as objects, which have their own properties and behaviors. The process of selecting a course of action or making a choice based on available data and information.

 

Graph Database Time-Series Database
Distributed Database Nosql Database
Flat File Database Record
Field Delimiter

 

A type of database optimized for storing and retrieving time-stamped or time-series data, such as sensor readings or financial market data. A type of database that uses graph structures to store, represent, and query relationships between complex interconnected data entities.
A type of database that provides a non-relational data model, flexible schema, and horizontal scalability, often used for big data and real-time applications. A type of database that stores data across multiple computers or servers, allowing for improved performance, fault tolerance, and scalability.
A unit of data in a flat file database that contains all relevant information about a specific entity or object. A type of database that stores data in a plain-text file without a complex structure.
A character used to separate fields or records within a flat file database, allowing for easy parsing and retrieval of data. A component of a record in a flat file database that represents a single attribute or property of the entity being stored.

 

Spatial Database In-Memory Database
Replication Data Partitioning
ACID Approach Transaction
Atomicity Consistency

 

A database system that primarily relies on the main memory (RAM) of a computer for data storage, instead of traditional disk storage. A database that is optimized for storing and querying spatial data, such as points, lines, and polygons.
A technique used in distributed databases to divide the data into smaller subsets or partitions, which are then stored on different nodes in the network. The process of creating and maintaining copies of data across multiple nodes in a distributed database for increased fault tolerance and availability.
A unit of work performed on a database that follows the ACID approach. A set of properties that guarantee that database transactions are processed reliably.
The property that ensures the database remains in a valid state after a transaction. The property of a transaction to be an indivisible operation, either all or none of its changes are applied.

 

Isolation Durability
Concurrency Redo Log
Undo Log Locking
Transaction Log Audit Trail

 

The property that ensures that committed transactions survive permanent system failures. The property that ensures transactions are executed in a way that they are unaware of each other.
A mechanism used in the recovery process of a database to bring it to a consistent state after a crash. The property that allows multiple transactions to execute concurrently without interfering with each other.
A mechanism used to control concurrent access to data, preventing conflicts and ensuring data consistency. A mechanism used in the recovery process of a database to revert the effects of incomplete or aborted transactions.
A sequential record of all the changes made to a database, stored in the transaction log. A file that records all the transactions and activities in a database system.

 

Log File Recovery
Logging Point-In-Time Recovery
Undo Operation Redo Operation
Database Transactions Commit

 

The process of restoring a database to a previous state using the information in the transaction log. A file that contains a systematic record of events, actions, or observations.
The ability to recover a database to a specific moment in time using the transaction log. The process of recording events, activities, and information to a log file or transaction log.
A process that reapplies the changes recorded in the transaction log during database recovery. A process that reverses the effects of a transaction by applying the opposite changes recorded in the transaction log.
The final step of a database transaction where all changes made within the transaction are permanently saved. The process of performing multiple database operations as a single unit of work, ensuring consistency and integrity of data.

 

Rollback Isolation Level
Deadlock Concurrency Control
Savepoint Serializability
Transaction Scheduling Timestamp Ordering

 

A property that determines how concurrent transactions interact with each other and the level of data visibility. The process of undoing all changes made within a transaction and returning the database to its previous state.
Techniques and mechanisms used to manage the simultaneous execution of transactions without interference or inconsistency. A situation where two or more transactions are unable to proceed because each is waiting for the other to release a resource.
A property of transactions that allows them to behave as if they were executed sequentially, even though they may be executed concurrently. A point within a transaction where you can roll back a part of the transaction instead of the entire transaction.
A concurrency control technique in database systems where transactions are ordered based on their timestamp values. The process of determining the order in which transactions should be executed in a database system.

 

Serialization Two-Phase Locking
Operation Query
Database Management Systems Normalization
Index Backup

 

A concurrency control protocol where a transaction acquires all its required locks before starting execution and releases them all at the end. It enforces serializability. Ensuring that the execution of multiple transactions produces the same result as if they were executed sequentially.
A request for data or information from a database. A specific action carried out on a database.
The process of organizing data in a database to eliminate redundancy and improve efficiency. A software system that manages databases and allows users to access and manipulate data.
The process of creating copies of data to ensure its availability in case of data loss or corruption. A data structure that improves the speed of data retrieval operations in a database.

 

Data Warehousing Database Administrator
Database Storage Engine Sqlite
Database Security Query Optimization
Indexing Data Redundancy

 

A professional responsible for managing and maintaining a database system. The process of collecting and managing data from various sources for business intelligence and analysis purposes.
A lightweight relational database management system (RDBMS) that uses its own storage engine and is contained in a single disk file without a separate server process. A software program or module that is responsible for managing how data is stored, organized, and accessed in a database.
The process of selecting the most efficient execution plan for a query in a database management system. The protection of electronic databases from unauthorized access, use, disclosure, disruption, modification, or destruction.
The storage of the same data in multiple places within a database, which can lead to inconsistency and inefficiency. The technique of creating data structures, called indexes, to improve the speed of data retrieval operations in a database.

 

Data Integrity Database Management System
Data Backup Data Recovery
Database Performance Tuning Data Migration
Database Design Data Manipulation

 

A software application or system that allows for the management and organization of databases, including handling data storage, retrieval, and manipulation. The accuracy, consistency, and reliability of data stored in a database, ensuring it is valid and trustworthy.
The process of retrieving or restoring data that has been lost, damaged, or accidentally deleted from a database, usually through the use of backup copies. The process of creating copies of data and storing them in a separate location for disaster recovery purposes or as a precaution against data loss.
The process of transferring data from one database system or storage system to another. The process of optimizing a database system to improve its efficiency, response time, and overall performance by adjusting various parameters and configurations.
The process of using SQL commands to modify data within a database, including operations like update, insert, and delete. The process of planning and creating a database structure that meets the requirements of the organization, including determining tables, relationships, and constraints.

 

Database Schema QBE
Graphical User Interface Non-Technical Users
Visual Query Systems Drag-And-Drop Interface
Natural Language Interfaces

 

A query method that allows users to build queries by filling in templates or grids. The structure that defines the organization of data, including the tables, fields, and relationships within a database.
Individuals who may lack specialized knowledge in programming or database languages. An interface that allows users to interact with software through visual indicators and elements.
A user-friendly method that enables users to select objects and manipulate them within a graphical environment for query creation. Tools that allow users to build queries using graphical elements rather than text-based commands.
Tools that enable users to communicate with databases using everyday language instead of programming languages.