Exam 5: Database Systems, Data Centers, and Business Intelligence

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Big data refers to large amounts of unstructured data from sources such as the Internet, photos, videos, audio, social networks, and sensors that is difficult to capture, store, and manipulate using traditional database management systems.

When organizing a database, key considerations include determining what data to collect, who will have access to it, how they might want to use it, and how to monitor database performance.

The smallest piece of data used by a computer is the _____.

Selecting involves combining two or more tables.

Online Analytical Processing and data mining are essentially the same thing.

A data warehouse stores historical data that has been extracted from operational systems, external sources, and, sometimes, even unique sources.

When creating backup databases, some companies use software to eliminate any duplicated data to save storage capacity and reduce costs, an approach some call data ______ .

The allowable values for an attribute is called its _____.

______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

A database, a database management system, and the application programs that use the data make up a database environment.

Counterintelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

A collection of fields about a specific object is a record.

Data query involves the automated discovery of patterns and relationships in a data warehouse.

_____ involves eliminating columns in a table.

Developing a seamless integration of databases with the Internet is sometimes called a _____.

Climate control is an important component of modern data centers..

The specific value of an attribute is called a data entity.

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

A(n) _____ is a simple database program whose records have no relationship to one another.