Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
|
DBMS
|
Database Management System
|
|
|
DBMS - Advantages
|
Centralized Control
Data can be shared efficiently Data independence Easy implementation of new applications Direct user access Control redundancy User views into the data |
|
|
DBMS - Disasdvantages
|
Cost
Added Complexity Following Standard Formats Centralized risk |
|
|
Procedural Query Language
|
Used for hierarchy and network
Must know the KEY structure ahead of time |
|
|
Non-procedural query language
|
Use for relational model
Don't need to know structure ahead of time |
|
|
Standard Query Language
|
ANSI standard computer language for accessing and manipulating databases
|
|
|
Normalisation of relational data model
|
Finding the simplest structure for a given dataset
|
|
|
Boolean Operators
|
AND: "I want only documents that contain both words"
OR: "I want documents that contain either word" NOT: "I want documents w/ one word, but excluding ones that entail another word" |
