Term
| Online Transaction Processing (OLTP) |
|
Definition
| gathering input information, processing it and then using it to update existing data |
|
|
Term
| Database and DBMS, referred to as ___________, are used to support ___________. |
|
Definition
OPERATIONAL DATABASES;
OLTP (Online Transaction Processing) |
|
|
Term
| Online Analytical Processing (OLAP) |
|
Definition
| Manipulation of data to support decision making. |
|
|
Term
| ________ ________ are used to support decision making. |
|
Definition
|
|
Term
| The information contained in a Data Warehouse comes from ________ databases. |
|
Definition
|
|
Term
| What type of Online Processing would be used for this question, "What new advertising strategies are needed to reach customers who can afford this expensive product?" |
|
Definition
| OLAP (You would need to gather information into a Data Warehouse using information from multiple Databases. |
|
|
Term
| A _______ is a collection of information that you organize and access according to the logical structure of that information. |
|
Definition
|
|
Term
| A ___________ database uses a series of of logically related, two-dimensional tables or files to store information in the form of a database. |
|
Definition
|
|
Term
| The term ________ describes each two-dimensional table or file in the relational model. |
|
Definition
|
|
Term
| What are the two parts of a relational database? |
|
Definition
1) The information itself, stored in two-dimensional tables/files/relations.
2) The Logical Structure of the info |
|
|
