Operational Vs. Decision Support System

1.0kviews

written 7.3 years ago by

Characteristic	Operational Support System	Decision Support System
Data Currency	Current operations Real-time data	Historic data,Snapshot,of company data Timecomponent(week/month/year)
Granularity	Atomic detailed data	Summarized data
Summarization level	Low: some aggregate yields	High: many aggregation levels
Data model	Highly normalized mostly relationl DBMS	Nonnormalized Complex structures Some relational, but mostly multidimensional DBMS
Transaction type	Mostly updates	Mostly query
Transaction volumes	High update volumes	Periodic loads and summary calculations
Transaction speed	Updates are critical	Retrievals are critical
Query activity	Low to medium	High
Query scope	Narrow range	Broad range
Query complexity	Simple to medium	Very complex

ADD COMMENT EDIT