Foundations of Business Intelligence: Databases and Information Management

In the data hierarchy, what is the term for a grouping of characters into a word, a group of words, or a complete number?

Which of the following problems in a traditional file environment is characterized by the presence of duplicate data in multiple data files?

What is the primary role of a Database Management System (DBMS)?

In a relational database, what is the purpose of a primary key?

Which of the three basic operations of a relational DBMS is used to combine relational tables to provide the user with more information than is available in individual tables?

What is the primary purpose of the process known as normalization in database design?

According to the chapter, what is the term for a database that stores current and historical data of potential interest to decision makers throughout the company?

What technology is described as an open source software framework that enables distributed parallel processing of huge amounts of data across inexpensive computers?

Which of the following analytical techniques is more discovery-driven, finding hidden patterns and relationships in large databases?

What is the function of an information policy in an organization?

A person, place, thing, or event on which we store and maintain information is known as what?

Program-data dependence is the term used to describe the coupling of data stored in files and the specific programs required to update them. What is a major consequence of this dependence?

Which of the following is an example of a non-relational database technology?

An automated or manual file that stores definitions of data elements and their characteristics is called a:

What is the most prominent data manipulation language used in DBMS for large and midrange computers today?

The conceptual design of a database is modeled from which perspective?

Rules that ensure relationships between coupled tables in a relational database remain consistent are called what?

What is the term for datasets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, and analyze?

A subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users is called a:

What type of data mining analysis would be used to identify that when corn chips are purchased, a cola drink is purchased 65 percent of the time?

The discovery and analysis of useful patterns and information from the World Wide Web is referred to as:

What is the primary function of data cleansing, also known as data scrubbing?

According to a Gartner Inc. report mentioned in the chapter, what percentage of critical data in large Fortune 1000 companies’ databases is inaccurate or incomplete?

How does a DBMS separate the logical and physical views of data?

What is the primary business advantage of using a data warehouse?

Which technology relies on a computer's main memory (RAM) for data storage to dramatically shorten query response times?

What type of Web mining examines user interaction data recorded by a Web server whenever requests for a Web site's resources are received?

The BAE Systems case study highlighted the challenges of what primary issue before implementing its new data management solution?

In an entity-relationship diagram, a line connecting two entities that ends in a crow's foot topped by a short mark designates what kind of relationship?

What is the primary reason that a traditional file system cannot deliver ad hoc reports in a timely fashion?

What type of data mining is used to discover different groupings within data, such as finding affinity groups for bank cards?

What is the primary technology that allows a user with a Web browser to access an organization's internal database?

What is the function of data administration?

The case of Famous Footwear's inability to get the 'right style of shoe in the right store' illustrates a failure in what area?

What technology did TicketDirect adopt to improve management of peak system loads during major ticket sales?

How many terabytes of data does Twitter generate daily, according to the chapter?

In the human resources database example (Figure 6.3), what would be the logical view for a benefits specialist?

What type of analytical tool enables users to view the same data in different ways using multiple dimensions?

Sentiment analysis software is used to mine what type of data?

What is the primary concern of the controversy surrounding the Consumer Product Safety Database described in the chapter?

A structured survey of the accuracy and level of completeness of the data in an information system is called a:

Which of the following best describes the database approach to data management?

What key services are part of the Hadoop framework?

Which business intelligence infrastructure component is described as featuring preconfigured hardware-software systems specifically designed for query processing and analytics, like IBM Netezza?

The case of Caesars Entertainment using customer data to build detailed profiles and guide management decisions is a prime example of applying what technology?

What is the primary difference between a logical design and a physical design of a database?

How much data can a single jet engine generate in just 30 minutes, according to the chapter's discussion on big data?

What is the primary function of a foreign key in a relational database table?

Which of the following is a primary problem that a DBMS helps solve?

What type of business intelligence infrastructure component did Barnes & Noble use to maintain separate databases for retail store sales, college bookstore sales, and online sales?