~ NurShuhana ~

CHAPTER 8  - Accessing Organizational Information - Data Warehouse What is DATA WAREHOUSE ?  DATA WAREHOUSE FUNDAMENTALS     - a logical collection of information - gathered from many different operational databases - that supports business analysis activities and decision-making tasks ~ The primary purpose of data warehouse is to  combined  information  throughout  an organization into a single repository for decision making purposes - data warehouse support only analytical processing DATA WAREHOUSE MODEL ~  Extraction, transformation, and loading (ETL)  - a process that extracts information from internal and external databases,  transform  the information using a common set of enterprise definitions and loads the information into a data warehouse ~  Data warehouse  - then send subsets of the information to data mart ~  Data mart  - contains a subset of data warehouse information ...

CHAPTER 7 - Storing Organizational Information What Is INFORMATION ? ~ Information is everywhere in an organization ~ Information is stored in databases  Database - maintains information about various types of objects (inventory), events (transaction), people (employees), and places (warehouses) ~ Database models include :  Hierarchical database model - information is organized into a tree-like structure (using parent/child relationship) 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 form of logically related two-dimensional tables ~ Entity - a person, place, thing, transaction, or event about which information is stored The rows in each table contain the entities ~ Attributes (fields, columns) - characteristics or properties of an entity class The column s in each table contain the attribute...