Mis Midterm (6)

Front 1

Bit

Back 1

Smallest unit of data; binary digit (0,1)

Front 2

Byte

Back 2

Group of bits that represents a single character

Front 3

Field

Back 3

group of words or a complete number

Front 4

Record

Back 4

group of related fields

Front 5

File

Back 5

group of records of same type

Front 6

Database

Back 6

group of related files

Front 7

Entity

Back 7

person, place, thing, event about which information is maintained

Front 8

Attribute

Back 8

description of a particular entity

Front 9

Key Field

Back 9

identifier field used to retrieve, update, or sort a record; a key field is a unique identifier

Front 10

Problems with the Traditional File Environment

Back 10

1. Data Redundancy
2. Program-data dependence
3. Lack of Flexibility
4. Poor Security
5. Lack of data sharing & availability

Front 11

DBMS

Back 11

Database Management System

Front 12

Relational DBMS

Back 12

- represents data as two-dimensional tables called relations
- relates data across tables based on common data elements

Front 13

Select

Back 13

creates subset of rows that meet specific criteria

Front 14

Join

Back 14

combines relational tables to provide users with information

Front 15

Project

Back 15

enables users to create new tables containing only relevant information

Front 16

OODBMS

Back 16

Object-Oriented Database Management System

Front 17

Object-Oriented Database Management System

Back 17

- stores data & procedures as objects that can be retrieved & shared automatically

Front 18

Capabilities of DBMS

Back 18

1. Data Definition Language
2. Data Dictionary
3. Querying & Reporting

Front 19

Conceptual Design

Back 19

abstract model of database from a business perspective

Front 20

Physical Design

Back 20

detailed description of business information needs

Front 21

Entity-relationship Diagram

Back 21

Methodology for documenting databases illustrating relationships between database entries

Front 22

Normalization

Back 22

process of creating small stable data structures from complex groups of data

Front 23

Distributed Databases

Back 23

database stored in more than one physical location

Front 24

Data Warehouse

Back 24

-stores current & historical data form many core operational transaction systems
-consolidates & standardizes info
-query, analysis & reporting tools

Front 25

Data marts

Back 25

- subset of data warehouse
- summarized, highly focused portion of data

Front 26

Business Intelligence

Back 26

Tools for consolidating, analyzing & providing access to vast amounts of data to help users make better business decisions

Front 27

OLAP

Back 27

Online Analytical Processing

Front 28

Online Analytical Processing

Back 28

- supports multidimensional data analysis

Front 29

Data Mining

Back 29

Tools for analyzing large pools of data

Front 30

Text Mining

Back 30

extracts key elements from large, unstructured data sets

Front 31

Web Mining

Back 31

discovery & analysis of useful patterns & info from WWW

Front 32

Databases & the Web

Back 32

Companies use Web to make internal databases available to customers or partners

Front 33

Data Quality Audit

Back 33

structured survey of the accuracy & completeness of data in an information system

Front 34

Data Cleansing

Back 34

consists of activities for detecting & correcting data in an information system