Exam 7: Databases and Data Warehouses

_________is a magnification or expansion of the amount,types,and level of detail of data that is collected and stored.

_________has become the query language of choice for many developers of relational DBMSs.

Database fields are limited to holding text and numbers.

A(n) _________is unique if the value (content) in that field appears only in one record.

While a database itself is a collection of several related files,the program used to build databases,populate them with data,and manipulate the data is called a(n) _________.

To link records from one table with records of another table,the tables must have at least one field in common,and that field must be a _________field for one of the tables.

Data warehouses replace transactional databases.

A(n)_________ is one piece of information about an entity,such as the last name or first name of a student,or the student's street address.

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

_________should first be done to decide which data should be collected and how it should be organized.

Explain the impact of databases on businesses.

The messages sent to access data in a database are called protocols.

For some business needs you must use a(n)_________ ,a combination of two or more fields that together serve as a primary key,because it is impractical to use a single field as a primary key.

A schema describes the structure of the database being designed: the names and types of fields in each record type and the general relationships among different sets of records or files.

The lack of a_________ in Big Data can make data collected from nontraditional sources a challenge to analyze.

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.

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.

If _________need to be used as one large data warehouse,special software tools can unify them and make them appear as one large data warehouse.

Online databases that are used with web browsers_________ .

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 _________.