Flashcards: Module 10 Databases: Understanding Data Storage

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/47

encourage image

There's no tags or description

Looks like no tags are added yet.

48 Terms

1
New cards

database management system (DBMS)

A software program that lets you create databases and then manipulate data in them.

2
New cards

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.

3
New cards

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.

4
New cards

primary key

The field in a database that contains unique information for each record; also called a unique identifier.

5
New cards

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.

6
New cards

data file

A collection of related records stored on a storage medium, such as a hard drive, or on cloud storage.

7
New cards

character

A letter, number, symbol, or punctuation mark.

8
New cards

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.

9
New cards

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.

10
New cards

data entry form

A window on the screen that provides areas for entering or modifying data in a database.

11
New cards

data dictionary

A DBMS element that contains data about each file in a database and each field in those files. Sometimes called a repository.

12
New cards

query language

query (database): A database object used to specify criteria that extract data based on criteria that the query creator specifies.

13
New cards

query by example (QBE)

query (web): A search term entered into a search engine on the web to obtain results.

14
New cards

Structured Query Language

A popular query language that allows users to manage, update, and retrieve data.

15
New cards

repository

A DBMS element that contains data about each file in a database and each field in those files. Sometimes called a data dictionary.

16
New cards

validation

The process of comparing data with a set of rules or values to determine if the data meets certain criteria.

17
New cards

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.

18
New cards

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.

19
New cards

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.

20
New cards

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.

21
New cards

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.

22
New cards

log

A listing of activities that modify the contents of a database.

23
New cards

relationship

An association between entities.

24
New cards

Continuous backup

A backup plan in which changes are backed up as they are made.

25
New cards

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.

26
New cards

one-to-many relationship

A database relationship that connects each record in one table to one or more records in another table.

27
New cards

NoSQL databases

An unstructured database that uses a variety of approaches to store many kinds of data. Also called a nonrelational database.

28
New cards

Key-value databases

A database that creates key-value pairs for each record.

29
New cards

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.

30
New cards

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.

31
New cards

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).

32
New cards

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.

33
New cards

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.

34
New cards

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.

35
New cards

database as a service (DBaaS)

A DBMS that runs on servers owned by a cloud provider and which users access remotely using a browser.

36
New cards

back-end database

Part of a split database that contains table objects and is stored on a file server that all users can access.

37
New cards

Data visualization

Power View tables, charts, and maps that present data in a visual way.

38
New cards

blockchain

A series (or chain) of records stored in encrypted blocks across a network.

39
New cards

check digit

Validity check consisting of a number(s) or character(s) that is appended to or inserted in a primary key value.

40
New cards

input mask

A field property that provides a visual guide for users as they enter data.

41
New cards

wizard

A tool that guides the user through the steps of a process or task by asking a series of questions or presenting options.

42
New cards

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).

43
New cards

business intelligence (BI)

Software tools designed to extract useful information from Big Data.

44
New cards

data warehouse

A central repository that stores data collected from existing databases and live data streams.

45
New cards

dashboards

A page or screen providing informative visuals of data, key performance indicators, and statistics.

46
New cards

data lake

A central repository that stores both structured and unstructured data collected from existing databases and live data streams.

47
New cards

data analytics

The study of data’s patterns and insights that help inform business decision and strategies.

48
New cards

Function creep

Problem that occurs when a company uses the technology intended for one purpose for an entirely different purpose.