Chapter 6 It

Front 1

Information granularity

Back 1

refer to the extent of detail within the information.

Front 2

What are the information levels?

Back 2

Individual, Departmental, Enterprise

Front 3

Individual level

Back 3

Individual knowledge, goals, and strategies

Front 4

Department level

Back 4

Departmental goals, revenues, expenses, processes, and strategies

Front 5

Enterprise level

Back 5

enterprise revenues, expenses, processes, and strategies

Front 6

Real-time information

Back 6

immediate, up-to-date information

Front 7

Real-time system

Back 7

provides real-time information in response to query requests.

Front 8

Characteristics of high-quality information include:

Back 8

Accuracy
Completeness
Consistency
Uniqueness
Timeliness

Front 9

Database

Back 9

maintains information about various types of objects, events, people,and places

Front 10

hierarchical database model

Back 10

information is organized into a tree like structure that allows repeating information using parent/child relationships in such a way that it cannot have to many relationships.

Front 11

network database model

Back 11

is a flexible way of representing objects and their relationship.

Front 12

Relational database model

Back 12

stores information in the form of logically related two-dimensional tabels

Front 13

Entity

Back 13

a person, place, thing, transaction, or event about which information is stored.
-The rows in each table contain the entities

Front 14

Attribute (field, column)

Back 14

characteristics or properties of an entity class

Front 15

What do primary keys and foreign keys identify?

Back 15

the various entities(tables) in the database

Front 16

Primary key

Back 16

a field (or group of fields) that uniquely identifies a given entity in a table

Front 17

Foreign key

Back 17

a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables

Front 18

Relational database advantages

Back 18

increased flexibility
increased scalability and performance
reduced information redundancy
increased information integrity (quality)
increased information security

Front 19

Physical view

Back 19

deals with the physical storage of information on a storage device
-have only one physical view

Front 20

Logical view

Back 20

focuses on how users logically access information.
-have multiple logical views

Front 21

What is one of the primary problems with redundant information?

Back 21

inconsistency

Front 22

Integrity constraint

Back 22

rules that help ensure the quality of information

Front 23

Relational integrity constraints

Back 23

are rules that enforce basic fundamental information constraints
ex) no creating an order for a customer that does not exists

Front 24

Business-critical integrity constraint

Back 24

enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints.

Front 25

Password

Back 25

provides authentication of the user.

Front 26

Access level

Back 26

determines who has access to the different types of information

Front 27

Access control

Back 27

determines types of user access, such as read-only access.

Front 28

Database Management Systems

Back 28

(DBMS) software through which users and application programs interact with database

Front 29

Data Driven websites

Back 29

an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database

Front 30

integration

Back 30

allows separate systems to communicate directly with each other

Front 31

Forward integration

Back 31

takes information entered into a given system and sends it automatically to all downstream systems and processes.

Front 32

Backward integration

Back 32

takes information entered into a given system and sends it automatically to all upstream systems and processes.

Front 33

Data warehouse

Back 33

a logical collection of information-gathered from many different operational databases - that supports business analysis activities and decision-making tasks
-The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes.

Front 34

Extraction, transformation, and loading

Back 34

(ETL) a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.

Front 35

Data Mart

Back 35

contains a subset of data warehouse information.

Front 36

Data-driven websites

Back 36

an interactive website kept constantly updated and relevant to the need of its customers through the use of a database.

Front 37

Multidimensional analysis

Back 37

-databases contain information in series of two-dimensional tables
-In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows.
-Dimension: a particular attribute of information.

Front 38

Cube

Back 38

a common term for the representation of multidimensional information.

Front 39

information cleansing or scrubbing

Back 39

a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Front 40

Data mining

Back 40

the process of analyzing data to extract information not offered by the raw data alone
-to perform data mining users need data-mining tools
-data-mining tools helps users uncover business intelligence.