Exam 9: Data Management Layer Design

Data may be stored in the following formats _____.

Information systems consultants, Drew and Becky, have just visited the site of a potential customer. Video-Audio-Images Extra, Inc., is an old established organization that was one of the first companies to videotape weddings, high school musicals, and church presentations. Today they have transformed into a multinational company that performs audio and video recording and mixing, digital re-mastering, and computer graphics for feature films, MTV videos, commercials and video games. During the interview Becky learned that the company has a legacy database system that should soon be replaced. The new system should be able to handle only accounting, purchasing, human resources, and inventory control for the company. What object persistence format would you recommend to Becky and Drew? Support your answer.

A file that stores static values used for reference and validation is a look-up file.

Why should the object persistent classes be dependent on the associated problem domain classes instead of the other way around?

A transaction file is primarily used to update a master file.

There are several techniques that the project team can use to try to speed up access to the data: denormalization, clustering, and indexing.

Null values in a database are easy to interpret.

Explain the object persistence format type known as Object Oriented Databases.

Clustering similar records together is one way of reducing access time.

When implementing the object persistence in an ORDBMS, what types of issues must you address?

Explain the object persistence format type known as files.

The accountants at the Sears store in a local city have noticed that the appliance department is regularly short when items sold are compared to sales. The accountants feel that something is wrong and these systems must be checked for accuracy. The audit file system will reveal if appliances may have been stolen.

A file that stores core information important to the business is an audit file.

A master file stores core information that is important to the business, is normally kept for long periods of time, and is regularly updated.

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

The most efficient tables in a relational database in terms of storage space have redundant data and few null values.

There are many different types of NoSQL data stores including key-value stores, document stores, column-oriented stores, object databases, and RDBMSs.

If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.

The type of database that is most capable of supporting complex data types is _____.

_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.