Ch. 3 Databases & Datawarehouses

Question 1

the science of fact-based decision making.

Answer 1

analytics

Question 2

the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information

Answer 2

(OLTP) online transaction processing

Question 3

databases that support OLTP

Answer 3

operational databases

Question 4

the manipulation of information to support decision making

Answer 4

(OLAP) online analytical processing

Question 5

a collection of information that you organize and access according to the logical structure of that information

Answer 5

database

Question 6

uses a series of logically related two-dimensional tables or files to store information in the form of a database

Answer 6

relational database

Question 7

describes the two-dimensional table or file in the relational model

Answer 7

relation

Question 8

contains the logical structure for the information in a database

Answer 8

data dictionary

Question 9

a field (or group of fields in some cases) that uniquely describe each record

Answer 9

primary key

Question 10

a primary key of one file that appears in another file

Answer 10

foreign key

Question 11

rules that help ensure the quality of the information

Answer 11

integrity constraints

Question 12

helps you specify the logical organization for a database and access and use the information within a database

Answer 12

(DBMS) Database Management System

Question 13

accepts logical requests from the various other dbms subsystems, converts them into their physical equivalent and actually accesses he database and data dictionary as they exist on a storage device

Answer 13

DBMS engine

Question 14

helps you create and maintain the data dictionary and define the structure of the files in a database

Answer 14

data definition subsystem

Question 15

helps you add, change, and delete information in the database and query it for valuable information

Answer 15

data manipulation subsystems

Question 16

allows you to see the contents of the database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information

Answer 16

views

Question 17

help you quickly define formats of reports and what info you want to see in a report

Answer 17

report generators

Question 18

help you graphically design the answer to a question

Answer 18

(QBE) query by example tools

Question 19

a standardized fourth generation query language found in most DBMSs

Answer 19

(SQL) structured query language

Question 20

contains facilities to help you develop transaction-intensive applications

Answer 20

application generation subsystem

Question 21

helps you manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management

Answer 21

data administration subsystem

Question 22

a copy of info stored on computer

Answer 22

backup

Question 23

the process of reinstalling the backup info in the event the info was lost

Answer 23

recovery

Question 24

a logical collection of information-gathered from many different operational databases -used to create business intelligence that supports business analysis activities and decision-making tasks

Answer 24

data warehouse

Question 25

the software tools you use to query info in a data warehouse

Answer 25

data mining tools

Question 26

slice and dice techniques that allow you to view multidimensional info from different perspectives

Answer 26

(MDA) multidimensional analysis tools

Question 27

displays key performance info gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker

Answer 27

digital dashbaord

Question 28

the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity

Answer 28

(KPIs) key performance indicators

Question 29

a subset of a data warehouse in which only a focused portion of the data warehouse information is kept

Answer 29

data mart

Question 30

the function in an organization that plans for, oversees the development of, and monitors the information resource

Answer 30

data administration

Question 31

the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).

Answer 31

database administration