1/47
Looks like no tags are added yet.
database management system (DBMS)
A software program that lets you create databases and then manipulate data in them.
file processing system
System used to store and manage data in which each department or area within an organization has its own set of files.
navigation pane
In Access, a pane in the program window that lets the user move between objects (tables, queries, forms, reports, macros, and modules) in the database.
primary key
The field in a database that contains unique information for each record; also called a unique identifier.
Data redundancy
A condition that occurs when the user stores the same data in more than one place; it wastes space and can cause inconsistencies.
data file
A collection of related records stored on a storage medium, such as a hard drive, or on cloud storage.
character
A letter, number, symbol, or punctuation mark.
Information technology (IT)
The use of computers and other electronic devices, networks, and software for collecting, storing, retrieving, processing, manipulating, and distributing data and information.
data type
The field property that determines what field values the user can enter for the field and what other properties the field will have.
data entry form
A window on the screen that provides areas for entering or modifying data in a database.
data dictionary
A DBMS element that contains data about each file in a database and each field in those files. Sometimes called a repository.
query language
query (database): A database object used to specify criteria that extract data based on criteria that the query creator specifies.
query by example (QBE)
query (web): A search term entered into a search engine on the web to obtain results.
Structured Query Language
A popular query language that allows users to manage, update, and retrieve data.
repository
A DBMS element that contains data about each file in a database and each field in those files. Sometimes called a data dictionary.
validation
The process of comparing data with a set of rules or values to determine if the data meets certain criteria.
report writer
DBMS feature that allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. Also called a report generator.
recovery utility
Tool that uses logs and/or backups, and either a rollforward or a rollback technique, to restore a database when it becomes damaged or destroyed.
report generator
DBMS feature that allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. Also called a report writer.
rollforward
Recovery technique where the DBMS uses the log to reenter changes made to the database since the last save or backup. Also called forward recovery.
rollback
Recovery technique where the DBMS uses the log to undo any changes made to the database during a certain period. Also called backward recovery.
log
A listing of activities that modify the contents of a database.
relationship
An association between entities.
Continuous backup
A backup plan in which changes are backed up as they are made.
foreign key
A primary key field from one table that the user includes as a field in a second table to form a relationship between the two tables.
one-to-many relationship
A database relationship that connects each record in one table to one or more records in another table.
NoSQL databases
An unstructured database that uses a variety of approaches to store many kinds of data. Also called a nonrelational database.
Key-value databases
A database that creates key-value pairs for each record.
one-to-one relationship
A relationship between two tables in which each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table.
many-to-many relationship
A relationship between two tables in a database in which one record of one table relates to many records in the other table and vice versa; to create such a relationship, the user must establish a third table called a junction table that creates separate one-to-many relationships with the two original tables.
key-value pair
A database element that consists of two related items: a constant that defines the set (key) and variable that belongs to the set (value).
relational database management system (RDBMS)
A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.
database administrators (DBAs)
Specially trained person who works with a database’s back-end components to ensure a company’s business data is safe, secure, and well managed.
front-end database
Part of a split database that contains the user interface and other objects, but not the tables that are needed for an application.
database as a service (DBaaS)
A DBMS that runs on servers owned by a cloud provider and which users access remotely using a browser.
back-end database
Part of a split database that contains table objects and is stored on a file server that all users can access.
Data visualization
Power View tables, charts, and maps that present data in a visual way.
blockchain
A series (or chain) of records stored in encrypted blocks across a network.
check digit
Validity check consisting of a number(s) or character(s) that is appended to or inserted in a primary key value.
input mask
A field property that provides a visual guide for users as they enter data.
wizard
A tool that guides the user through the steps of a process or task by asking a series of questions or presenting options.
Confidentiality, Integrity, and Availability (CIA) triad
Classic security model that addresses database concerns by defining the need for confidentiality (C), integrity (I), and availability (A).
business intelligence (BI)
Software tools designed to extract useful information from Big Data.
data warehouse
A central repository that stores data collected from existing databases and live data streams.
dashboards
A page or screen providing informative visuals of data, key performance indicators, and statistics.
data lake
A central repository that stores both structured and unstructured data collected from existing databases and live data streams.
data analytics
The study of data’s patterns and insights that help inform business decision and strategies.
Function creep
Problem that occurs when a company uses the technology intended for one purpose for an entirely different purpose.