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

The _____ is a description that involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

______ uses virtual servers and operating systems, to allow two or more database systems, including servers and database management systems, to act like a single unified database system.

A(n) _____ is a field or set of fields that uniquely identifies a record.

The DBA must have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

The commands that are used to manipulate the database are part of the _____ language.

_____ is a standardized data manipulation language developed in the 1970s that allows programmers to use one powerful language and use it on a variety of systems.

Some databases use ______, which is a visual approach to developing queries and requests.

The relational database model is by far the most widely used..

A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

The Database Administrator is an important non-technical responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

The _____ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

_____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers.

A ______ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.

Developing a seamless integration of databases with the Internet is something called a(n) ______.

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

A ________ is s field or set of fields in a record that uniquely defines the record.

Basic data manipulations include _____ which involves eliminating rows in a relational database.

What is meant by big data applications? Provide two examples of big data applications.

Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means.

A tool that database designers use to show the logical relationships among data is a(n) _____.