Mis 311 Business Driven Information Systems, Chapter 6 By Baltzan & Phillips

Front 1

Application generation component

Back 1

Includes tools for creating visually appealing and easy-to-use applications.

Front 2

Association detection

Back 2

Reveals the degree to which variables are related and the nature and frequency of these relationships in the information.

Front 3

Attribute

Back 3

Characteristics or properties of an entity class.

Front 4

Backward integration

Back 4

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

Front 5

Business intelligence

Back 5

Information that people use to support their decision-making efforts.

Front 6

Business-critical integrity constraint

Back 6

Enforces business rules vital to an organization's success and often requires more insight and knowledge than relational integrity constraints.

Front 7

Cluster analysis

Back 7

A technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.

Front 8

Cube

Back 8

The common term for the representation of multidimensional information.

Front 9

Data

Back 9

Raw facts that describe the characteristics of an event.

Front 10

Data administration component

Back 10

Provides tools for managing the overall database environment by providing facilities for backup, recovery, security, and performance.

Front 11

Database

Back 11

Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)

Front 12

Database management system (DBMS)

Back 12

Software through which users and application programs interact with a database.

Front 13

Data definition component

Back 13

Helps create and maintain the data dictionary and the structure of the database.

Front 14

Data dictionary

Back 14

A files that stores definitions of information types, identifies the primary and foreign keys, and maintains the relationships among the tables.

Front 15

Data manipulation component

Back 15

Allows users to create, read, update, and delete information in a database.

Front 16

Data mart

Back 16

Contains a subset of data warehouse information.

Front 17

Data mining

Back 17

The process of analyzing data to extract information not offered by the raw data alone.

Front 18

Data-mining tool

Back 18

Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

Front 19

Data warehouse

Back 19

A logical collection of information--gathered from many different operational databases--that supports business analysis activities and decision-making tasks.

Front 20

Entity

Back 20

In the relational database model is a person, place, thing, transaction, or event about which information is stored.

Front 21

Entity class

Back 21

In the relational database model is a collection of similar entities.

Front 22

Extraction, transformation, and loading (ETL)

Back 22

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 23

Forecast

Back 23

Predictions made on the basis of time-series information.

Front 24

Foreign key

Back 24

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

Front 25

Forward integration

Back 25

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

Front 26

Hierarchical database model

Back 26

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

Front 27

Information

Back 27

Data converted into a meaningful and useful context.

Front 28

Information cleansing or scrubbing

Back 28

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

Front 29

Information granularity

Back 29

Refers to the extent of detail within the information (fine and detailed or "course" and abstract information)

Front 30

Information integrity

Back 30

A measure of the quality of information.

Front 31

Integration

Back 31

Allows separate systems to communicate directly with each other.

Front 32

Integrity constraint

Back 32

The rules that help ensure the quality of information

Front 33

Logical view

Back 33

Focuses on how users logically access information to meet their particular business needs.

Front 34

Market basket analysis

Back 34

Analyzes such items as Web sites and checkout scanner information to detect customers' buying behavior and predict future behavior by identifying affinities among customers' choices of products and services.

Front 35

Network database model

Back 35

A flexible way of representing objects and their relationships.

Front 36

Performance

Back 36

Occurs when a Web site can know enough about a person's likes and dislikes that it can fashion offers that are more likely to appeal that person.

Front 37

Physical view

Back 37

The physical storage of information on a storage device such as a hard disk.

Front 38

Primary key

Back 38

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

Front 39

Query-by-example (QBE)

Back 39

Allows users to graphically design the answers to specific questions.

Front 40

Redundancy

Back 40

The duplication of information, or storing the same information in multiple places.

Front 41

Relational integrity constraint

Back 41

The rules that enforce basic and fundamental information-based systems.

Front 42

Relational database model

Back 42

A type of database that stores information in the form of logically related two-dimensional tables.

Front 43

Report generator

Back 43

Allows users to define formats for reports along with what information they want to see in the report.

Front 44

Scalability

Back 44

Refers to how well a system can adapt to increased demands.

Front 45

Structured query language (SQL)

Back 45

A standardized fourth-generation query language found in most DBMSs.

Front 46

Time-series information

Back 46

Time-stamped information collected at a particular frequency.

Front 47

View

Back 47

Allows users to see the contents of a database, make any required changes, perform simple sorting, and query the database to find the location of specific information.