System Types by Data Structure

Question 1

___ ___ are characterized by independent programs and data sets, high degrees of data redundancy, and difficulty in achieving cross functional reporting.

Answer 1

Flat files

Question 2

This is a concept associated with data warehouses. It is the ability to move from summary information to more granular information and is called a ___ ___.

Answer 2

drill down

Question 3

___ ___ attempts to ensure that the right information is available at the right time to the right user. A variety of practices attempt to electronically capture and disseminate information throughout the organization.

Answer 3

Knowledge management

Question 4

___ ___ practices are those that seek specific outcomes, including shared intelligence, improved performance, competitive advantage, and more innovation.

Answer 4

Knowledge management

Question 5

The ability to view a single data item in multiple dimensions; for example, the sale of VCRs might be viewed by product, by region, by time period, by company, etc. is called ___ and ___ as it relates to data warehouses.

Answer 5

slicing and dicing

Question 6

An ___ ___ (___-___ ___) is a computer program that contains subject-specific knowledge derived from experts. The system consists of a set of rules that are used to analyze information provided by the user of the system. Based on the information provided, the system recommends a course of action.

Answer 6

expert system (knowledge-based system)

Question 7

A ___ ___ is a specialized version of a data warehouse that contains data that is pre-configured to meet the needs of specific departments.

Answer 7

data mart

Question 8

Companies often support ___ data marts within their organization.

Answer 8

multiple

Question 9

A component of a knowledge management system. A special type of database designed for retrieval of knowledge. It provides the means to collect and organize the information and develop relationships among information components.

Answer 9

knowledge base

Question 10

A ____ ____ is a database designed to archive an organization’s operational transactions (sales, purchases, production, payroll, etc.) over a period of years.

Answer 10

data warehouse

Question 11

External data that might be correlated with these transactions such as economic indicators, stock prices, exchange rates, market share, political issues, weather conditions, etc. can also be incorporated into the ____ ___.

Answer 11

data warehouse.

Question 12

___ ___ techniques can be used on a data warehouse to identify patterns and relationships among the data elements.

Answer 12

Data mining

Question 13

An ___ ___ is knowledge management that provides suggested courses of action in response to user input.

Answer 13

expert systems

Question 14

Knowledge management systems endeavor to create a ___ ___ through use of shared information.

Answer 14

competitive advantage

Question 15

“___ ___” is a term used to describe the ability to move from aggregated data to the detailed transactions underlying it.

Answer 15

Drill down

Question 16

The majority of data found in a data warehouse is comprised of the organization’s ___ ___ ___ data.

Answer 16

historical operational transaction

Question 17

Data warehouses are often included in ___ systems.

Answer 17

ERP

Question 18

___ ___ is the process of sorting through data maintained in a data warehouse in an effort to identify relationships between data fields or events.

Answer 18

Data mining

Question 19

The ability to recognize___ and ___ ___ is critical to successful data mining.

Answer 19

sequence and association patterns

Question 20

One event that leads to another is called a ____.

Answer 20

sequence

Question 21

One event is correlated with another event is called a ___.

Answer 21

association

Question 22

___ ____ ___ (___) provide generic support to clerical level employees and include many of the typical programs found on personal computers (word processing, spreadsheets, end-user databases, etc.).

Answer 22

Office automation systems (OASs)

Question 23

___ ____ ___ (___) support the day-to-day activities of the business (purchasing of goods and services, manufacturing activities, sales to customers, cash collections, payroll, etc.).

Answer 23

Transaction processing systems (TPSs)

Question 24

The term “___” is a narrow term used to describe the technique of implementing databases in multi-user, multiple location environments.

Answer 24

partitioned

Question 25

___ ____ ___ (___) provide information to mid- and upper-level management to assist them in managing non-routine problems and in long-range planning.

Answer 25

Decision support systems (DSSs)

Question 26

A specialized version of a data warehouse that contains data that is pre-configured to meet the needs of specific departments is known as a ___ ___.

Answer 26

data mart