DATA LOGICALLY ORGANIZED:
1. CHARACTER- a single alphabetic, numeric, or other symbol
2. FIELD- a grouping of characters
3. RECORD- related fields of data
4. FILE- groups of related records(table)
5. DATABASE- integrated collection of logically related data elements
DATA WAREHOUSE- stores data that have been extracted from variouse operational, external, and other db's of org.
DATA MART- hold subsets of data from the warehouse that focus on specific aspects of a company
DATA MINING- the data in dw's are analyzed to reveal hidden patterns and trends in historical business activity.
DB RULES
*data warehouses and operational databases are separated
*data warehouses data are integerated
*datea warehouse contains historical data over the long term
*data warehouse data are a snapshot
*dw is characterized by RO transactions to very large data sets vs. numerous update transactions to a few data entities at time in OP db's
DB STRUCTURES
-relational structure is not common
-knowL hierarchical, network, and relational structures
*know the forms of accessing files and db's
DB DEVELOPMENT
1. DATA PLANNING
2. REQUIRES SPECIFICATIONS
3. CONCEPTUAL DESIGN
4. LOGICAL DESIGN
5. PHYSICAL DESIGN
