Operational Vs. Decision Support System
1 Answer
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
Please log in to add an answer.

Continue reading...

The best way to discover useful content is by searching it.