Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sdfs
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the working process for application.cfm?
Explain the structure of cold fusion?
What is perform recovery?
What are cluster analysis in data warehousing?
What is the advantages data mining over traditional approaches?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is the difference between view materialized view and view?
Explain what is the difference between view filter and report filter?
How can we load the time dimension?
Explain the difference between filter and conditin?
What are aggregate tables and aggregate fact tables?
How to know the time taken for particular report execution?
What are vaious etl tools in the market?
What is the difference between star and snowflake schemas?
How to get the first 100 rows from the flat file into the target?
