Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.

The  DSS is (Decision  Support System) used for the   decision making  purposes, not for day-2 day issues.by the top level/ sr/middle level managments people in a  established company.

but the OLTP  SYSTEMS handles the day-day transactions, data entries, billing etc issues .  

The  DSS  WILL  be handled by only a   few  users , especially  

top poeple in the   corporate ladder hence The number of users who  are making  use of DSS are  less.

 but in OLTP(ONLINE   TRANSACTION PROCESSING) the number  of the   users are  high, since no such kind of decision making is entailed.

regds

DAs.