Uncc Mis Test 2

Front 1

field

Back 1

group of words or a complete number

Front 2

record

Back 2

group of related fields

Front 3

file

Back 3

group of records of the same type

Front 4

database

Back 4

group of related files// collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data

Front 5

entity

Back 5

a person, place,t hing, or event on which we store data

Front 6

attribute

Back 6

each characteristic or quality describing an entity

Front 7

data redundancy

Back 7

the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location

Front 8

data inconsistency

Back 8

where the same attribute may have different values

Front 9

program-data dependence

Back 9

refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data

Front 10

DBMS

Back 10

database management system - software that permits an organization to centralize data, manage them efficiently, and provide access to the stored data by applications programs

Front 11

logical view

Back 11

presents data as they would be perceived by end users or business specialists

Front 12

physical view

Back 12

shows how data are actually organized and structured on physical storage media

Front 13

relational dbms

Back 13

most popular type of dbms - represent data as two dimensional tables (called relations). tables may be referred to as files

Front 14

tuples

Back 14

rows/records in a relational dbms

Front 15

key field

Back 15

uniquely identifies each record so that the record can be retrieved, updated, or sorted in a relational dbms

Front 16

primary key

Back 16

one key field that is the unique identifier for all the information in any row of the table and cannot be duplicated. dbms.

Front 17

foreign key

Back 17

essentially a look up field to look up data about the supplier of a specific part

Front 18

object-oriented dbms

Back 18

stores the data and procedures that act on those data as objects that can be automatically retrieved and shared. best suited for videos and other multimedia

Front 19

object-relational dbms

Back 19

provide capabilities of both object0oriented, and relational dbms

Front 20

data definition

Back 20

capability to specify the structure of the content of the database. used to create database tables

Front 21

data dictionary

Back 21

automated or manual file that stores definitions of data elements and their characteristics

Front 22

data manipulation language

Back 22

used to add, change, delete, and retrieve the data in the database

Front 23

structured query language - sql

Back 23

most prominent data manipulation language

Front 24

normalization

Back 24

the process of creating small, stable, yet flexible and adaptive data structures from complex groups of data

Front 25

referential integrity

Back 25

ensure that relationships between coupled tables remain consistent

Front 26

entity-relationship diagram

Back 26

illustrates relationships between entities

Front 27

data warehouse

Back 27

database that stores current and historical data of potential interest to decision makers throughout the company

Front 28

data mart

Back 28

smaller, decentralized data warehouses; subset of a data warehouse in which a summarized or highly focused portion of the organizations data is placed in a separate database for a specific population of users

Front 29

OLAP - online analytical processing

Back 29

supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions.

Front 30

data mining

Back 30

discover-driven; provides insight into corporate data that cannot be obtained with OLAP by finding hidden patterns and relationships in large databases, and inferring rules from them to predict future behavior

Front 31

associations

Back 31

occurrences linked to a single event

Front 32

sequences

Back 32

events are linked over time

Front 33

classification

Back 33

recognizes patterns that describe the group to which an item belongs by examining existing items that have been classified and by inferring a set of rules

Front 34

clustering

Back 34

similar to classification, but no established groups yet

Front 35

forecasting

Back 35

uses a series of existing values to forecast what others will do

Front 36

predictive analysis

Back 36

use data mining techniques, historical data, and assumptions about future conditions to predict outcomes of events such as the probability a customer will respond to an offer or purchase a specific product

Front 37

text mining

Back 37

tools are able to extract key elements from large unstructured data sets, discover patterns and relationships, and summarize the info

Front 38

web mining

Back 38

the discover and analysis of useful patterns and information from the world wide web

Front 39

web content mining

Back 39

process of extracting knowledge from the content of web pages - text, image, audio, video

Front 40

web usage mining

Back 40

examines user interaction data recorded by a web server whenever requests for a web site's resources are received

Front 41

DATABASE SERVER

Back 41

in a client/server environment, the dbms resides on this dedicated computer

Front 42

CGI script

Back 42

a compact program using the common gateway interface specification for processing data on a web server

Front 43

information policy

Back 43

specifies the organizations rules for sharing disseminationg, acquiring, standardizing, inventoy info