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;
27 Cards in this Set
- Front
- Back
hierarchial database model |
information is organized into a tree like structure in such a way that it cannot have too many relationships |
|
network database model |
a flexible way of representing objects and their relationships |
|
relational database model |
stores information in the form of logically related two-dimensional tables |
|
entitiy |
a person, place, thing, transaction, or event about which informion is stored |
|
attributes |
characteristics or properties of an entity |
|
primary key |
a field that uniquely identifies a given entity in a table |
|
foriegn key |
a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables |
|
physical view |
deals with the physical storage of information on a storage device |
|
logical view |
focuses on how users logically access information |
|
scalability |
refers to how well a system can adapt to increased demands |
|
performace |
measures how quickly a system performs a certain process |
|
redundancy |
the duplication of information or storing the same information in multiple places |
|
information integreity |
measures the quality of information |
|
integrity constraint |
rules that help ensure the quality of information |
|
password |
provides authentication of the user |
|
access level |
determines who has access to the different types of information |
|
access control |
determines types of user access, such as read-only access |
|
data base management system |
software through which users and application programs interact with database |
|
data-driven websites |
an interaction website kept constantly updated and relevant t the needs of its customers through the use of a database |
|
integration |
allows separate systems to communicate directly with each other |
|
forward integration |
takes information entered into a given system and sends it automatically to all downstream systems and processes |
|
backward integration |
takes information entered into a given system and sends it automatically to all upstream system processes |
|
data warehouse |
a logical collection of information gathered from many different operation databases that supports business analysis activities and decision making task |
|
Extraction, transformation and loading (ETL) |
a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse |
|
Data mart |
contains a subset of data warehouse information |
|
data mining |
the process of analyzing data to extract information not offered by the raw data alone |
|
information cleansing or scrubbing |
a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information |