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;
44 Cards in this Set
- Front
- Back
What is the order of the data hierarchy? |
Database Tables/Files/Relation Records/Rows/ Tuples Fields/Columns/attributes Bytes Bits |
|
What is another name for records? |
Rows |
|
What is another name for fields? |
Columns |
|
What are the six different issues with traditional file environment? |
Data redundancy Data insconsistency Data isolation Data integrity Security Data Dependency |
|
The ______ ____ takes a data centric view where you have a centralized system that has a list and everything connects to that list. |
database approach |
|
The database approach has minimal data _____, high data___________, an ______ of data, involves the ___ of data. |
redundancy Consistency integration sharing of |
|
The database approach allows for uniform ___, ___ and ______ |
security privacy integrity |
|
The database approach is data independence, which means ... |
can't move things but you can add them |
|
What is data definition language? |
specifies content and structure of database and defines each data element |
|
What is data manipulation language? |
Manipulates data in a database |
|
What does data definition language define? |
The data definition language defines tables and structure, but not the data |
|
What does the data manipulation language do? |
manipulates data in a database. It deals directly with data (adding date, deleting data) |
|
What is the data dictionary? |
Stores definitions of data elements, and data characteristics |
|
What is a specific database that keeps track of a database? |
Data dictionary |
|
In the 1960's databases were made up of... |
traditional files |
|
In the 1970s databases were _______________ and _______ |
heirarchial Network |
|
In the 1980's the structure of the database was _______ |
Relational |
|
In 1990 the structure of the database was both _______ _______ and _____ _________ |
object oriented and object relational |
|
What is a relational database? |
Represents data as two-dimensional tables called relations |
|
A relational database relates data across tables based on _____ _______ _________ |
common data elements |
|
Relational databases involve _____ and _____ keys that... |
primary and foreign keys that links together across tables |
|
______ _________ organizes data in a tree-like structure |
hierarchical database |
|
What type of relationships are supported by heirarchical databases? |
supports one to many relationships |
|
When is hierarchical database prevalent |
in large legacy systems |
|
When is hierarchical databases insufficient? |
When comparing lowelr levels |
|
Network databases depict data... |
logically as many to many relationships |
|
What are two main issues with the network databases? |
Lack support for ad-hoc and english language like queries The design dictates how you can query the data and get it out |
|
What are the two different categories involved in database design? |
Conceptual/ logical design Physical design |
|
What is the conceptual/logical design involved in the database design? |
abstract model of database from business perspective |
|
What is the physical design of the database? |
Shows how the database is arranged on storage devices |
|
What does the ER diagram attempt to do... |
to find how the data is really defined |
|
The ______ _______ tries to attach terminology across systems |
ER Diagram |
|
What is business intelligence? |
Knowledge about your customers, competitors, partners, competitive environment and internal operations |
|
Online transaction processing does what? |
runs your business day in and day out |
|
_____ _____ __________ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information |
Online transaction processing |
|
What are the three different parts of online transaction processing? |
Gathering input information Processing info Updating existing information |
|
What are operational databases? |
databases that support online transaction processing |
|
What is online analytical processing? |
The manipulation of information to support decision making |
|
What is the function of OLAP? |
Slices and dices data |
|
What are data marts? |
subset of data warehouse |
|
What is data mining? |
Finding hidden patterns and trends in data |
|
A data warehouse is a ____ ______ of information gathered from many different ___ _____ used to create _______ ______ that supports _____ ________ ________ and _________ _______ _____________ |
logical collection operational databases business intelligence business analysis activities decision making tasks |
|
______ _______ pulls data in from many places and summarizes it |
data warehouse |
|
What is a data mart? |
A subset of a data warehouse in which only a focused portion of the data warehouse information is kept |