0

2.1kviews

Clearly state the differences between OLTP and OLAP

written 9.1 years ago by teamques10 ★ 70k

modified 4.0 years ago by phenjoisilab • 0

advanced database management systems

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

7views

written 9.1 years ago by teamques10 ★ 70k

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 & recovery	Frequently made	Hardly made
DB Design	Normalized tables	Few De-normalized tables using star or snowflake schema
Orientation	Transaction	Analysis
Type of Data	Current Data	Historical Data
Apps	Operational customer relationship Mgmt etc.	Decision, Business Mgmt etc.

ADD COMMENT SHARE EDIT