Difference between revisions of "OLAP"
Jump to navigation
Jump to search
(Created page with "=== Two Types of Database Activity === # OLTP (Online Transaction Processing) #* short transactions #* simple queries #* touch small portions of data #* frequent update # OLAP...") |
|||
| Line 10: | Line 10: | ||
#* touch large portions of the data | #* touch large portions of the data | ||
#* infrequent updates | #* infrequent updates | ||
| + | |||
| + | === Terminologies === | ||
| + | * Data Warehousing | ||
| + | Bring data from operational(OLTP) sources into a single "warehouse" for (OLAP) analysis | ||
| + | * Decision Support System (DSS) | ||
| + | Infrastructure for data analysis, e.g., data warehouse tuned for OLAP | ||
| + | |||
| + | === Star Schema === | ||
| + | * Fact table | ||
| + | Updated frequently, often append-only, very large <br /> | ||
| + | e.g. sales transactions, course enrollments, page view | ||
| + | * Dimension tables | ||
| + | Updated infrequently, not as large <br /> | ||
| + | e.g. stores, items, customers, students, courses, webpages, users, advertisers | ||
Revision as of 03:36, 13 November 2013
Two Types of Database Activity
- OLTP (Online Transaction Processing)
- short transactions
- simple queries
- touch small portions of data
- frequent update
- OLAP (Online Analytical Processing)
- long transactions
- complex queries
- touch large portions of the data
- infrequent updates
Terminologies
- Data Warehousing
Bring data from operational(OLTP) sources into a single "warehouse" for (OLAP) analysis
- Decision Support System (DSS)
Infrastructure for data analysis, e.g., data warehouse tuned for OLAP
Star Schema
- Fact table
Updated frequently, often append-only, very large
e.g. sales transactions, course enrollments, page view
- Dimension tables
Updated infrequently, not as large
e.g. stores, items, customers, students, courses, webpages, users, advertisers