Databases Chptr 1 Rob/coronel 8

Front 1

data

Back 1

raw facts

Front 2

information

Back 2

result of processing raw data to reveal meaning

Front 3

knowledge

Back 3

data are the foundation of information
bedrock of knowledge

Front 4

knowledge

Back 4

body of information and facts about a subject

Front 5

information

Back 5

reveals meaning of data

Front 6

accurate, relevant and timely

Back 6

key to good decision making

Front 7

good decision making

Back 7

key to org survival in global environment

Front 8

data management

Back 8

discipline focus on generation, storage and retrieval of data

Front 9

end user data

Back 9

raw facts of interest to end user

Front 10

metadata

Back 10

data about data

Front 11

database

Back 11

collection of self describing data

Front 12

DBMS
database management system

Back 12

collection of programs that manage database structure and controls access to data stored in database

Front 13

DBMS

Back 13

intermediary between user and database

Front 14

DBMS

Back 14

enables data in database to be shared

Front 15

DBMS

Back 15

improved
data sharing
data security
data integration
minimize inconsistancy
improved data access
improved decision making
increased user productivity

Front 16

single user data base

Back 16

supports one user at a time

Front 17

desk top database

Back 17

single user database running on a pc

Front 18

multiuser database

Back 18

supports multiple users- usually less that 50

Front 19

workgroup database

Back 19

entire organization- more than 50
known as an enterprise database

Front 20

enterprise database

Back 20

for entire organization

Front 21

centralized database

Back 21

supports data located at a single site

Front 22

distributed database

Back 22

supports data distributed across several different sites

Front 23

operational database

Back 23

database to support orginazations day to day operations
also called-
transactional or production database

Front 24

datawarehouse

Back 24

stores data used to generate information required to make decisions

Front 25

unstructured data

Back 25

data in raw state

Front 26

structured data

Back 26

result of formatting unstructured data for storage and use

Front 27

semistructured data

Back 27

data with some processing

Front 28

XML
extensible markup language

Back 28

to represent and manipulate data in textual format

Front 29

XML database

Back 29

supports storage and management of semistructured XML data

Front 30

database design

Back 30

activitioes that focus on design and structure of storing and managing end user data

Front 31

dataprocessing specialist

Back 31

DP
creates computer file structure

Front 32

data processing manager

Back 32

DP
supervises dP dept.

Front 33

structural dependence

Back 33

access to file dependent on structure

Front 34

structural independence

Back 34

possible to make changes in the structure file without affecting application programs ability to access data

Front 35

data independence

Back 35

make changes in data storage without affecting access

Front 36

logical data format

Back 36

how humans view data

Front 37

physical data format

Back 37

how computer must work with data

Front 38

islands of information

Back 38

scattered data locations

Front 39

data redundancy

Back 39

same data stored unnecessarily in different places

Front 40

data anomalies

Back 40

abnormailities due to things such as data redundancy

Front 41

data inconsistancy

Back 41

conflicting versions of same data

Front 42

data anomaly

Back 42

developes when required changes in redundant data are not made successfully

Front 43

database system

Back 43

organization of components that define, regulate collection, store and manage database environment

Front 44

database system

Back 44

5 components
hardware
software
people
procedures
data

Front 45

data dictionary

Back 45

definitions of the data elements and their relationships

Front 46

DBMS

Back 46

creates and manages complex structures required for data storage

Front 47

performance tuning

Back 47

activities that make database perform more efficiently

Front 48

dats transformation and presentation

Back 48

transformed entered data to conform o required data structure

Front 49

security management

Back 49

security system enforces user security and data privacy

Front 50

multiple access control

Back 50

ensures multiple users can access database concurrently

Front 51

backup and recovery management

Back 51

ensure data integrity and safety

Front 52

query language

Back 52

lets user specify what must be done without having to specify how

Front 53

structured query language

Back 53

de facto query language

Front 54

database communications interfaces

Back 54

generates answers to queries
automatically publishes
connects to third party system

Front 55

database system disadvantages

Back 55

increased costs
management complexity
maintaining currency
vendor dependence
frequent upgrade replacement cycle

Front 56

data,

Back 56

usually stored in database