Mgs 351 Chapter 3 Databases And Data Warehouses

Front 1

What is the order of the data hierarchy?

Back 1

Database

Tables/Files/Relation

Records/Rows/ Tuples

Fields/Columns/attributes

Bytes

Bits

Front 2

What is another name for records?

Back 2

Rows

Front 3

What is another name for fields?

Back 3

Columns

Front 4

What are the six different issues with traditional file environment?

Back 4

Data redundancy

Data insconsistency

Data isolation

Data integrity

Security

Data Dependency

Front 5

The ______ ____ takes a data centric view where you have a centralized system that has a list and everything connects to that list.

Back 5

database approach

Front 6

The database approach has minimal data _____, high data___________, an ______ of data, involves the ___ of data.

Back 6

redundancy

Consistency

integration

sharing of

Front 7

The database approach allows for uniform ___, ___ and ______

Back 7

security

privacy

integrity

Front 8

The database approach is data independence, which means ...

Back 8

can't move things but you can add them

Front 9

What is data definition language?

Back 9

specifies content and structure of database and defines each data element

Front 10

What is data manipulation language?

Back 10

Manipulates data in a database

Front 11

What does data definition language define?

Back 11

The data definition language defines tables and structure, but not the data

Front 12

What does the data manipulation language do?

Back 12

manipulates data in a database. It deals directly with data (adding date, deleting data)

Front 13

What is the data dictionary?

Back 13

Stores definitions of data elements, and data characteristics

Front 14

What is a specific database that keeps track of a database?

Back 14

Data dictionary

Front 15

In the 1960's databases were made up of...

Back 15

traditional files

Front 16

In the 1970s databases were _______________ and _______

Back 16

heirarchial

Network

Front 17

In the 1980's the structure of the database was _______

Back 17

Relational

Front 18

In 1990 the structure of the database was both _______ _______ and _____ _________

Back 18

object oriented and object relational

Front 19

What is a relational database?

Back 19

Represents data as two-dimensional tables called relations

Front 20

A relational database relates data across tables based on _____ _______ _________

Back 20

common data elements

Front 21

Relational databases involve _____ and _____ keys that...

Back 21

primary and foreign keys that links together across tables

Front 22

______ _________ organizes data in a tree-like structure

Back 22

hierarchical database

Front 23

What type of relationships are supported by heirarchical databases?

Back 23

supports one to many relationships

Front 24

When is hierarchical database prevalent

Back 24

in large legacy systems

Front 25

When is hierarchical databases insufficient?

Back 25

When comparing lowelr levels

Front 26

Network databases depict data...

Back 26

logically as many to many relationships

Front 27

What are two main issues with the network databases?

Back 27

Lack support for ad-hoc and english language like queries

The design dictates how you can query the data and get it out

Front 28

What are the two different categories involved in database design?

Back 28

Conceptual/ logical design

Physical design

Front 29

What is the conceptual/logical design involved in the database design?

Back 29

abstract model of database from business perspective

Front 30

What is the physical design of the database?

Back 30

Shows how the database is arranged on storage devices

Front 31

What does the ER diagram attempt to do...

Back 31

to find how the data is really defined

Front 32

The ______ _______ tries to attach terminology across systems

Back 32

ER Diagram

Front 33

What is business intelligence?

Back 33

Knowledge about your customers, competitors, partners, competitive environment and internal operations

Front 34

Online transaction processing does what?

Back 34

runs your business day in and day out

Front 35

_____ _____ __________ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information

Back 35

Online transaction processing

Front 36

What are the three different parts of online transaction processing?

Back 36

Gathering input information

Processing info

Updating existing information

Front 37

What are operational databases?

Back 37

databases that support online transaction processing

Front 38

What is online analytical processing?

Back 38

The manipulation of information to support decision making

Front 39

What is the function of OLAP?

Back 39

Slices and dices data

Front 40

What are data marts?

Back 40

subset of data warehouse

Front 41

What is data mining?

Back 41

Finding hidden patterns and trends in data

Front 42

A data warehouse is a ____ ______ of information gathered from many different ___ _____ used to create _______ ______ that supports _____ ________ ________ and _________ _______ _____________

Back 42

logical collection

operational databases

business intelligence

business analysis activities

decision making tasks

Front 43

______ _______ pulls data in from many places and summarizes it

Back 43

data warehouse

Front 44

What is a data mart?

Back 44

A subset of a data warehouse in which only a focused portion of the data warehouse information is kept