0
2.1kviews
Clearly state the differences between OLTP and OLAP
1 Answer
| written 8.9 years ago by |
| 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 … |