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;
15 Cards in this Set
- Front
- Back
What is a database?
|
an organized collection of data used for the purpose of modeling some type of organization or organizational process
|
|
What are two types of databases?
|
operational databases & analytical databases
|
|
What is meant by an operational database?
|
operational databases are collect, modify, and maintain data on a daily basis - ie a retail operation, or a bank operation
|
|
What is meant by an analytical database?
|
Analytic databases store static data - they track historical and time dependent data - the info gleaned from an analytic database reflects a point-in-time snapshot of the data
|
|
What type of database model preceded the relational database?
|
the hierarchical and the network
|
|
How is a the hierarchical model diagrammed
|
usu as an inverted tree, a single table is the root and other tables act as branches flowing from the root
|
|
what is the relationship between tables in the hierarchical model called
|
parent/child
|
|
what are advantages to the hierarchical model
|
data access is quick because there are explicit links between the tables; secondly, referential integrity is built in
|
|
what are problems to the hierarchical model?
|
a child record cannot be inserted without a parent table; complex, many-to-many data cannot be modeled without redundancy
|
|
How is the structure of a network database modeled
|
nodes & set structures
|
|
What is a node?
|
a node, in the network database model, is a collection of records
|
|
what is a set structure?
|
in the network database model, establishes and represents a relationship - one node is an owner, the other node is a member
|
|
what did the network database model do - in relation to hierarchical models
|
data could be traversed from any side of a relationship in the network data model, there could also be many to many relationships
|
|
Origins of the relational database model?
|
conceived in 1969 by Dr.Edgar F.Codd, IBM research scientist, looking into ways to better handle large amts of data -
|
|
What does the name relational database stem from?
|
Set Theory
|