0
21kviews
Operational Vs. Decision Support System
1 Answer
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 |