Exam 5: Data Resource Management

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

The _______________ model is the most widely used database structure today.

To solve the problems encountered with the file processing approach, the _______________ management approach was conceived. It is the foundation of modern methods of managing organizational data.

In the relational database model, all data elements within the database are viewed as being stored in the form of simple two-dimensional tables, sometimes referred to as _______________.

The tables in a relational database are flat files, which have rows and columns. Each column represents a _______________.

In _______________, the data in a data warehouse are analyzed to reveal hidden patterns and trends in historical business activity.

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

According to the textbook case, the innovation of the open-source product Hadoop is _______________.

Data models represent _______________ views of the data and relationships of the database.

A database with a network data structure can easily handle a many-to-many data relationship, whereas a hierarchical model cannot.

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Database management packages based on the _______________ model can link data elements from various tables to provide information to users.

The tables in a relational database are flat files which have rows and columns. Each column represents a _______________ in the file.

In a(n) _______________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.

_______________ are used to model the relationships among the many entities involved in business processes.

A(n) _______________ is an integrated collection of logically related data elements.

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

Which of the following is true of data in a data warehouse?

The _______________ database structure is considered one of the key technologies of a new generation of Web-based applications.

A _______________ is an integrated collection of logically related data elements.