Exam 7: Databases and Data Warehouses

A database itself is a collection of several related files,but DBMSs do all the work-structuring files,storing data,and linking records.

In the ____________________ phase of transferring data from a transactional database to a data warehouse,the specialists transfer transformed files to the data warehouse.

The ability in object-oriented structures to create a new object automatically by replicating all or some of the characteristics of a previously developed object is called ____________________.

To retrieve records from a relational database,or to sort them,you must use a key.

When management decides to build a ____,the IT staff must carefully consider the hardware,software,and data involved in the effort.

A ____ is the general logical structure in which records are stored within a database and the method used to establish relationships among the records.

Many organizations have found that if they accumulate ____,they can use it for important management decisions,such as researching market trends or tracking down fraud.

In the ____ phase of transferring data from a transactional database to a data warehouse,the builders create the files from transactional databases and save them on the server that will hold the data warehouse.

The relational model consists of ____________________.

In the ____ phase of transferring data from a transactional database to a data warehouse,specialists "cleanse" the data and modify it into a form that allows insertion into the data warehouse.