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

A database is a collection of integrated and related _____.

The _____ data model has become the most popular database model.

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

_____ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

In the relational data model, each row of a table represents a(n) _____.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers.

A ________ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-critical information and services.

_____ combines historical data with assumptions about future conditions to predict the outcomes of events.

Differentiate between the traditional and database approach to data management.

_____ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Define the term data mining and identify its objectives.

______ use basic graphical symbols to show the organization of and relationships between data.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

Briefly describe the hierarchy of data.

A description that tells the DBMS the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

A collection of related records is called a(n) _____.

A data model is a diagram of data attributes and their relationships.