Term
|
Definition
|
|
Term
| How many different kinds of data storage formats are there? |
|
Definition
|
|
Term
|
Definition
| An electronic list of data that have been optimized to perform a particular transaction |
|
|
Term
|
Definition
| a collection of grouping of information that are related to each other in some way |
|
|
Term
|
Definition
| a collection of grouping of information that are related to each other in some way |
|
|
Term
|
Definition
| Database Management System-software that creates and manipulates the databases |
|
|
Term
|
Definition
| an electronic list of information that is formatted for a particular transaction |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Stores core information that is important to the application |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Store information that can be used to update a master file |
|
|
Term
|
Definition
| record "before" and "after" images of data as the data are altered |
|
|
Term
|
Definition
| store past transaction data |
|
|
Term
|
Definition
| A database which is based on older technology that is seldom used to develop new applications |
|
|
Term
|
Definition
| Uses hierarchies, or inverted trees, to represent relationships |
|
|
Term
|
Definition
| Collections of records that are related to each other through pointers |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| The idea of ensuring that values linking the tables together are valid and correctly synchronized |
|
|
Term
|
Definition
| Structured Query Language |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| An instance of data in object databases |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| Object Oriented database management system |
|
|
Term
|
Definition
|
|
Term
| multidimensional database |
|
Definition
|
|
Term
|
Definition
| the practice of taking and storing data in a data warehouse |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Smaller databases based on data warehouse data, and support DSS for specific departments or functional areas of the organization. |
|
|
Term
|
Definition
|
|
Term
| What are some factors to consider in selecting a storage format? |
|
Definition
| 1) data types, 2) Types of application system, 3) Existing storage formats, 4) Future needs |
|
|
Term
|
Definition
| Entity relationship diagrams-depict the business view of the data, but omit implementation details. |
|
|
Term
| How many steps are involved in the transition from the logical to physical data model? |
|
Definition
|
|
Term
| DO the DFD and ERD need to be balanced? Y/N? |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| What are the two primary dimensions in which to optimize a relational database? |
|
Definition
| Storage efficiency and speed of access |
|
|
Term
|
Definition
|
|
Term
| The most efficient tables in a relational database have no redundant data...T/F? |
|
Definition
|
|
Term
| What are a few of the techniques of optimizing access speed? |
|
Definition
| 1) Denormalization, Clustering, Indexing, and estimating the size of data for hardware planning |
|
|
Term
|
Definition
| Adding redundancy back into the design |
|
|
Term
|
Definition
| Placing records together physically so that like records are stored close together |
|
|
Term
|
Definition
| Similar records in the table are stored together |
|
|
Term
|
Definition
| Combining records from more than one table that typically are retrieved together |
|
|
Term
|
Definition
| a minitable that contains values from one or more columns in a table and the location of the values within the table. |
|
|
Term
|
Definition
| technique of estimating the amount of data that the hardware will support |
|
|
Term
|
Definition
| all the data that is stored within the tables of the database |
|
|
Term
|
Definition
|
|
