D426 Database Management Foundations Study Guide
1.database application: A database application is software that helps
business users interact with database systems.
2.database administrator: A database administrator is responsible for
securing the database system against unauthorized users.
3.Authorization: Many database users should have limited access to
specific tables, columns, or rows of a database.
4.Rules: Database systems ensure data is consistent with structural and
business rules.
5.query processor: The query processor interprets queries, creates a
plan to modify the database or retrieve data, and returns query results
to the application.
6.query optimization: The query processor performs query optimization
to ensure the most efficient instructions are executed on the data.
7.storage manager: The storage manager translates the query processor
instruc- tions into low-level file-system commands that modify or
retrieve data.
8.indexes: The storage manager uses indexes to quickly locate data.
9.transaction manager: The transaction manager ensures transactions
are prop- erly executed.
10.Metadata: Metadata is data about the database, such as column
names and the number of rows in each table.
11.relational database: A relational database stores data in tables,
columns, and rows, similar to a spreadsheet.
12.SQL: SQL stands for Structured Query Language and includes
statements that read and write data, create and delete tables, and
administer the database system.
13.big data: The growth of the internet in the 1990s generated massive
volumes of online data, called big data, often with poorly structured or
missing information.
14.NoSQL: The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data.
15.INSERT: INSERT inserts rows into a table.
16.SELECT: SELECT retrieves data from a table.
17.UPDATE: UPDATE modifies data in a table.
18.DELETE: DELETE deletes rows from a table.
19.CREATE TABLE: The SQL CREATE TABLE statement creates a new
table by specifying the table and column names.
20.database design: analysis: The analysis phase specifies database
require- ments without regard to a specific database system.
1/
13
, D426 Database Management Foundations Study Guide
21.ER diagrams: ER diagrams are used to represent entities,
relationships, and attributes in database design.
22.database design: logical design: The logical design phase implements
data- base requirements in a specific database system.
2/
13
1.database application: A database application is software that helps
business users interact with database systems.
2.database administrator: A database administrator is responsible for
securing the database system against unauthorized users.
3.Authorization: Many database users should have limited access to
specific tables, columns, or rows of a database.
4.Rules: Database systems ensure data is consistent with structural and
business rules.
5.query processor: The query processor interprets queries, creates a
plan to modify the database or retrieve data, and returns query results
to the application.
6.query optimization: The query processor performs query optimization
to ensure the most efficient instructions are executed on the data.
7.storage manager: The storage manager translates the query processor
instruc- tions into low-level file-system commands that modify or
retrieve data.
8.indexes: The storage manager uses indexes to quickly locate data.
9.transaction manager: The transaction manager ensures transactions
are prop- erly executed.
10.Metadata: Metadata is data about the database, such as column
names and the number of rows in each table.
11.relational database: A relational database stores data in tables,
columns, and rows, similar to a spreadsheet.
12.SQL: SQL stands for Structured Query Language and includes
statements that read and write data, create and delete tables, and
administer the database system.
13.big data: The growth of the internet in the 1990s generated massive
volumes of online data, called big data, often with poorly structured or
missing information.
14.NoSQL: The newer non-relational systems are called NoSQL, for 'not
only SQL', and are optimized for big data.
15.INSERT: INSERT inserts rows into a table.
16.SELECT: SELECT retrieves data from a table.
17.UPDATE: UPDATE modifies data in a table.
18.DELETE: DELETE deletes rows from a table.
19.CREATE TABLE: The SQL CREATE TABLE statement creates a new
table by specifying the table and column names.
20.database design: analysis: The analysis phase specifies database
require- ments without regard to a specific database system.
1/
13
, D426 Database Management Foundations Study Guide
21.ER diagrams: ER diagrams are used to represent entities,
relationships, and attributes in database design.
22.database design: logical design: The logical design phase implements
data- base requirements in a specific database system.
2/
13
