Chapter 11: Data Storage Design

Question 1

are electronic lists of data that have been optimized to perform a particular transaction.

Answer 1

Files

Question 2

is a collection of groupings of
information that are related to each other in some

Answer 2

Database

Question 3

Sometimes files are called ___ ___ because of the way the records are linked together by the
pointers.

Answer 3

linked lists

Question 4

___ ___ store core information that is important
to the business and, more specifically, to the
application, such as order information or customer
mailing information.

Answer 4

Master file

Question 5

contain static values, such as a list of valid codes or the name of the U.S. states.

Answer 5

Look-up Files

Question 6

holds information that can be
used to update a master file.

Answer 6

Transaction Files

Question 7

records “before” and “after” images of data as the data are altered, so that an audit can be performed if the integrity of the data is questioned.

Answer 7

Audit File

Question 8

stores past
transactions (e.g., old customers, past orders) that
are no longer needed by system users.

Answer 8

History or Archived File

Question 9

is given to those
databases which are based on older, sometimes
outdated technology that is seldom used to
develop new applications;

Answer 9

Legacy database

Question 10

Legacy systems are not usually used anymore, however be encountered in which types of databases

Answer 10

1. Network Database - inverted trees
2. Hierarchical Database - collection of records with each other

Question 11

The basic premise of object data base or object oriented database is that all things should be treated as objects who have?

Answer 11

1. Data (Attributes)
2. Processes (Behavior)

Question 12

In object databases, the attributes and behaviors determine an object’s?

Answer 12

object classes

Question 13

Object oriented database management systems are mainly used to suppport what type of data?

Answer 13

Multimedia and complex data

Question 14

A type of relational database that is used extensively on data warehousing

Answer 14

Multidimensional database

Question 15

are designed to
accept and process many simultaneous requests

Answer 15

Transaction processing systems

Question 16

Most efficient tables have no redundant values and very few null values (T or F)

Answer 16

True

Question 17

is the best way to optimize data
storage for efficiency.

Answer 17

Normalization

Question 18

Ways to speed up access to data: brings back redundancy to reduce joins in a query

Answer 18

Denormalization

Question 19

Ways to speed up access to data: reduce the number of times that the storage medium must be accessed during a transaction.

Answer 19

Clustering

Question 20

Ways to speed up access to data: Using values from one or more columns from each table to be able to find data faster

Answer 20

Indexing

Question 21

Ways to speed up access to data: estimating the amount of data that the hardware will need to
support.

Answer 21

Volumetrics