and 3 others joined a min ago.
0
1.9kviews
Clearly state the differences between OLTP and OLAP
written 7.4 years ago by
teamques10
★ 65k
|
modified 2.3 years ago
by
sagarkolekar
★ 11k
|
ADD COMMENT
EDIT
1 Answer
0
7views
|
written 7.4 years ago by
teamques10
★ 65k
|
| Criteria | OLTP | OLAP |
|---|---|---|
| Users | Clerks, Employees | Managers & Executives |
| Data Source | Data related to day to day business activities | Data obtained by complex aggregated functions. |
| Queries | Standard, simple queries | Complex queries involving aggregation |
| Query Language | SQL | DMQL |
| Access Rights | Read Write | Read only |
| Space Requirements | Relatively small | Relatively large |
| Backup … |
and 3 others joined a min ago.
ADD COMMENT
EDIT
Please log in to add an answer.