200 字
1 分钟
Databases Week11 Lecture
Analytical Schemas
Table of content
- Review Week10 Tutorial.
- OLTP Transactional Schemas.
- OLAP Analytical Schemas.
Online Transaction Processing (OLTP)
Vs Online Analytical Processing (OLAP)
OLTP vs OLAP
| - OLTP (Online Transactional Processing Schemas). - High volume of transactions. - Normalized data. - Many tables. |
- OLAP (Online Analytical Processing Schemas). - High volume of data. - Denormalized data. - Fewer tables. |
Online Analytical Processing Schemas
- ROLAP
- MOLAP
- HOLAP
ROLAP
- Relational online analytical processing.
- used for handling large amount of data.
- Can be stored efficiently.
- Performance of ROLAP can be slow.
---
config:
theme: 'forest'
---
erDiagram
FACT ||--o{ GEO : "cinema"
FACT ||--o{ FILM : "film"
FACT ||--o{ CUSTOMERS : "creditcard"
FILM ||--o{ COUNTRY : "country"
FACT {
string Full_Name
string Cinema
string Film
int Tickets
date Showing_Date
time Showing_Time
string CreditCard_Number
}
GEO {
string Cinema
string Region
string Country
}
FILM {
string Film
string Certificate
string Country
}
COUNTRY {
string Country
int Population
string ISOCountry
}
CUSTOMERS {
string First_Name
string Last_Name
string Full_Name
string CreditCard_Number
date Date_Of_Birth
}
MOLAP
- Multidimensional online analytical processing.
- Data is arranged in the form of data cubes.
- Designed to be faster than ROLAP.
- Used for complex calculations.
- Limited size and less flexibility.
- Excel pivot tables as an example.
HOLAP
- Hybrid Online Analytical Processing.
- Uses ROLAP for large, complex, uncommon analytics.
- Uses MOLAP for small, fast common analytics and complex mathematical calculations
Databases Week11 Lecture
https://mizuki.anka2.top/posts/l5-db-week11-lecture/ 部分信息可能已经过时