Chapter 5 Database Processing – Flashcards

Databases are required to keep track of lists with multiple themes.

A database is a self-describing collection of integrated records.

Bytes, which are characters of data, are grouped into rows in a database.

In a database, columns are also called records.

In a database, the collection of data for all columns is called a file.

In a database, a group of similar rows or records is called a table.

In a database, a key is a column or group of columns that identifies a unique row in a table.

Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.

The format of the metadata in a database depends on the software product that is processing the database.

To find out what a database contains, one can look at the metadata inside the database.

Most organizations develop their own database management systems.

DB2 is a popular database management system product that is licensed from Microsoft.

A database management system is also referred to as a database.

HyperText Markup Language is an international standard language for processing a database.

Structured query language statements can be issued directly to the database management system (DBMS) by an application program.

The database management system (DBMS) can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.

Database management system (DBMS) administrative functions include adding structures to improve the performance of database applications.

The administrative functions of a database management system (DBMS) include backing up database data.

A database application serves as an intermediary between users and database data.

Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.

Reports in database applications provide security, data consistency, and special-purpose processing.

All traditional databases require the Internet to transmit traffic between a user's computer and a database management system (DBMS) server computer.

In single-user databases, the application, the database management system (DBMS), and the database all reside on a user's computer.

Traditional database application programs are written in object-oriented languages such as C++.

Browser database application forms, reports, and queries are displayed and processed using HyperText Markup Language (HTML).

Browser applications are thin-client applications that need not be preinstalled on the users' computers.

Security requirements are more stringent for traditional applications than for browser-based ones.

The lost-update problem caused by multi-user processing in databases can be prevented by avoiding all types of database locking.

MySQL database management system refers to software systems that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.

NoSQL database management system products are very technical and can be used only by those with a deep background in computer science.