Term
|
Definition
| process of collecting, processing, communicating and interpretting information in order to support an organisations tactic and strategic decision making |
|
|
Term
| Enterprise data warehouse |
|
Definition
| global collection of data for company wide analyses that span several business units, departments, and user groups |
|
|
Term
| Departmental data warehouse or datamart |
|
Definition
| subset of company data that is relevant for decision support in a particulat business unit, department or research group |
|
|
Term
|
Definition
- a subject-oriented,integrated,time-variant, and non-volatile collection of data in support of managements decision making process
|
|
|
Term
|
Definition
| organised around the major subjects of an enterprise(e.g. customers, products, and sales) rather than the major application areas(e.g. customer invoicing, stock control, and order processing |
|
|
Term
|
Definition
- integrates application-oriented data from different source systems which must be made consistent
- centralised & cross-function
- 80% of warehouse efforts
|
|
|
Term
|
Definition
| same attribute has values denoted in different ways |
|
|
Term
|
Definition
| same entity has different identifiers |
|
|
Term
|
Definition
| management team assesses the evolution of its industry and the capabilites and behavior of its current and potential competitors to assist in maintaining or developing a competitive advantage |
|
|
Term
|
Definition
- all data in the data warehouse is associated with time
- provides series of historical snapshots
|
|
|
Term
|
Definition
- new data is always added as a supplemenet to the data warehouse
|
|
|
Term
|
Definition
large scope
designed to support decision making of particuler user group
|
|
|
Term
|
Definition
data that describe transactions or events from a business
|
|
|
Term
|
Definition
| determine the dimensions along which analyses will occur |
|
|
Term
|
Definition
| is a way of reperesenting the data inside a datawarehouse/datamart |
|
|
Term
|
Definition
| dimensional hierarchy is represented explicitly by normalising the dimension tables |
|
|
Term
|
Definition
| multiple fact tables share dimension tables |
|
|
Term
|
Definition
- meaning of one fact table row
- determines the max level of detail of the warehouse
|
|
|
Term
|
Definition
- extracting data from source system(operational,legacy,external)
- full copy or changed data capture
|
|
|
Term
|
Definition
- can be done on source or target system
- substeps: format ->cleanse-> aggregate and merge ->enrich
|
|
|
Term
|
Definition
- load data into target system
- fill fact and dimsenion table
|
|
|
Term
|
Definition
| same attribute in different measurement |
|
|
Term
|
Definition
| pulls data from source systems as need to answer queries |
|
|
Term
|
Definition
- online analytical processing
- interactive analysis of large chunks of multidemensional data from a data warehouse or data mart
- using advanced grapgical repersentation
|
|
|
Term
|
Definition
| aggregate data along one or more dimesnisons |
|
|
Term
|
Definition
| disaggregate data along one or more dimensions |
|
|
Term
|
Definition
| analyse data from different angles |
|
|
Term
|
Definition
| allow interactively rearrance and maniupulate aggregated data using a two dimensional tables |
|
|
Term
|
Definition
- knowledge discovery in data
- indentifying valied,novel,potentially usefull, and understandable patterns in data
|
|
|
Term
|
Definition
| discovery of new patterins in a collection of structured data |
|
|
Term
|
Definition
| identify new patterns in a collection of unstructered data |
|
|
