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
The same tier?
What is crass reference table?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
How to design file watch jobs?
How to provide security in frame work manager for a query subject?
What are data validation strategies for data mart validation after loading process?
What is a functional dependency f said to be minimal?
Explain difference between e-r modeling and dimentional modeling?
if you use oracle sql*loader , how do you transform data with it during loading?
What is Analysis Services?
What needs to be done while starting the database?
What is VLDB?
What are algorithms provided by Microsoft in SQL Server?
In document how to create metrics?
What is aggregate fact table?
