Management Information Systems Chapter 6

Play an AI-generated podcast conversation about this lesson

What is the primary purpose of OLAP?

To detect opinions in social media

To find hidden patterns in datasets

To extract key elements from large unstructured data sets

To provide rapid, online answers to ad hoc queries (correct)

What is the result of rotating the cube 90 degrees twice in the multidimensional data model?

Product versus customer buying patterns

Product versus actual and projected sales

Region versus actual and projected sales (correct)

Product versus region

What is the primary goal of data mining?

To find hidden patterns and relationships in datasets (correct)

To extract key elements from large unstructured data sets

To provide rapid, online answers to ad hoc queries

To detect opinions in social media

What type of information is obtainable from data mining?

Associations, sequences, classification, clustering, and forecasting Signup and view all the answers

What is the primary purpose of text mining?

To extract key elements from large unstructured data sets Signup and view all the answers

What is the purpose of sentiment analysis software?

To detect opinions in social media, emails, and blogs Signup and view all the answers

What is the primary function of the SELECT operation in a relational DBMS?

To create a subset of data based on specific criteria Signup and view all the answers

What is the main difference between relational and non-relational databases?

Relational databases are used for structured data, while non-relational databases are used for unstructured data Signup and view all the answers

What is the purpose of the JOIN operation in a relational DBMS?

To combine data from multiple tables Signup and view all the answers

What is an advantage of non-relational databases?

They are more flexible in their data model Signup and view all the answers

What is the primary function of the PROJECT operation in a relational DBMS?

To create a new table with a subset of columns Signup and view all the answers

Where are databases in the cloud typically hosted?

Private clouds Signup and view all the answers

What is a unit of data equivalent to 1024 bytes?

Kilobyte Signup and view all the answers

What is the term for massive sets of unstructured/semi-structured data from various sources?

Big data Signup and view all the answers

What is the term for a collection of data specifically designed for querying and analysis?

Data warehouse Signup and view all the answers

What is an example of a contemporary tool used for managing big data?

Hadoop Signup and view all the answers

What is a unit of data equivalent to 1024 petabytes?

Zettabyte Signup and view all the answers

What is the term for an infrastructure that includes an array of tools for separate systems and big data?

Business intelligence infrastructure Signup and view all the answers

What is the primary goal of web mining?

To discover and analyze useful patterns and information from the Web Signup and view all the answers

What type of web mining analyzes the links to and from a web page?

Web structure mining Signup and view all the answers

What is a common use of the Web by companies in relation to databases?

To make internal databases available to customers or partners Signup and view all the answers

What is an advantage of using the Web for database access?

It is ease of use of browser software Signup and view all the answers

What is the typical configuration of a system that uses the Web to access a database?

Web server, application server/middleware/CGI scripts, database server Signup and view all the answers

How do users access an organization's internal database through the Web?

Using a desktop PC and Web browser software Signup and view all the answers

What is the most granular unit of data representation?

Byte Signup and view all the answers

What is a major issue with the traditional file environment?

All of the above Signup and view all the answers

What is the result of each functional area developing specialized applications?

Data redundancy Signup and view all the answers

What is the logical grouping of related fields?

Record Signup and view all the answers

What issue arises when changes in a program require changes to the data accessed by the program?

Program-data dependence Signup and view all the answers

What is the outcome of using a traditional approach to file processing?

Data redundancy and inconsistency Signup and view all the answers