click below
click below
Normal Size Small Size show me how
IS1106
Week 3
| Term | Definition |
|---|---|
| Database | Self describing collection of logically related data that is organised to meet the information needs of multiple users |
| Advantages of Databases | Data is integrated and stored centrally Analysis Capability Data is programme independent |
| Metadata stored in data dictionary | Describes each piece of data in a business and describes in detail the characteristics of the data |
| DBMS | Database Management System |
| Structure of Relational DSMS | Represents data as two dimensional tables Each table contains data on entities and their attributes |
| Types of Databases | Operational databases Data warehouse databases Data marts Personal Databases Distributed Databases External Databases |
| Operational databases | Store detailed data needed to support the operations of the entire organization |
| Data Warehouse Databases | Store data from current and previous years that has been extracted from various operational and management databases of the organization |
| Data Marts | Subset of the data included in the data warehouse which focus on specific aspects of the company |
| Personal Databases | Developed by end-users at their workstations |
| Distributed Databases | Databases of local workshops and departments at regional offices etc. |
| External Databases | Privately generated and owned online databases or data banks that specialize in a particular area of interest. |
| Golden Rule | Centralise where possible; Distribute where necessary |