Term
|
Definition
| A database is an organized collection of logically related data |
|
|
Term
|
Definition
stored meaningful objects or events.
Structured: numbers, texts, and dates
Unstructured: images, video, documents |
|
|
Term
|
Definition
| Information is data processed to increase knowledge |
|
|
Term
|
Definition
| Metadata is data about the data. It describes characteristics about the data |
|
|
Term
| 5 Disadvantages of a File Processing System |
|
Definition
1. Program data dependence- all programs contains metadata for each file they use
2. Duplication of data - different systems have seperate copies of the same data
3. Limited data sharing - no centralized control
4. Lengthy development - must design own file formats
5. Excessive Programming maintenance - 80% IS budget |
|
|
Term
| In depth look at a program w/ data dependency |
|
Definition
each application programmer must...
Maintain his own data, include code for the metadata, Have his own processing routines.
There is a lack of coordination
As well as non standard file formats |
|
|
Term
| In depth look at duplication of data |
|
Definition
Duplication is...
a waste of space
data changes in one file could cause inconsistencies
which causes compromises in data integrity |
|
|
Term
| The solution: The database approach |
|
Definition
central repository of shared data
data is managed by a controlling agent
stored in standard form
Requires a DBMS |
|
|
Term
| What is a Database Management System>? |
|
Definition
| a system that is used to create, maintain, and provide controlled access to user databases |
|
|
Term
| 10 Advantages to Database Approach/DBMS |
|
Definition
1. Program data independence
2. Planned redundancy
3. Improved consistency
4. Improved sharing
5. Increased application development productivity
6. Enforcement of standards
7. Improved data quality
8. Improved accessibility and responsiveness
9. Reduced Maintenance
10. Improved decision support |
|
|
Term
| 5 Costs and Risks of the Database Approach |
|
Definition
1. New specialized personnel
2. installation and management cost/complexities
3. Conversion costs
4. Need for explicit backup and recovery
5. organization conflict |
|
|
Term
| 4 Elements of a database approach |
|
Definition
Data models - graphical systems capturing nature of data
Entities - noun form describing a person, place, thing, etc
Relationships - between entities, 1:m or M: N
Relational databases - tech involving tables representing entities and primary/foreign keys |
|
|
Term
| Components of the Database environment |
|
Definition
CASE Tools
Repository
DBMS
Database
Application programs
User Interface
Database Admins
System devels
End users |
|
|
Term
The 5 Ranges of database applications
4.5 are enterprising applications |
|
Definition
1. Personal database
2. Two tier client/server databases
3. Multi tier client/server databases
4. ERP Systems, which integrates all functions of the enterprise
5. Data warehousing, which is composed of various operational databases |
|
|
Term
| what is an enterprise data model? |
|
Definition
| it is an overall picture of organizational data at a high level of abstraction that specifies the scope and content of the system. It is also the first step |
|
|
Term
| 6 steps of the SDLC, which is the slower method of building a database |
|
Definition
Planning - prilim understanding, lots of enterprise modeling
Analysis - find requirements and structure
L Design - elicit specifications and structure
P Design - develop tech and organization specifics
Implementation - programming, testing, training install...
Maintenance - monitor, repare and enhance |
|
|
Term
|
Definition
1. Identify problem
2. Develop prototype
3. Implement prototype
4. Revise
5. convert to operation |
|
|
