Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is the Difference between DSS & OLTP?

asked marvit September 20, 2014 07:59 AM  

What is the Difference between DSS & OLTP?


1 Answers

answered By vishnoiprem   0  
Online transaction processing(OLTP) database applications are optimal for managing changing data. These applications typically have many users who are performing transactions at the same time that change real-time data, in other words OLTP is a live database (accomodates inserts, deletes, updates etc) 
Decision-support System (DSS) database applications are optimal for data queries that do not change data. For example, a company can periodically summarize its sales data by date, sales region, or product, and store this information in a separate database to be used for analysis by senior management. To make business decisions, users must be able to determine trends in sales quickly by querying the data based on various criteria. However, they do not have to change this data. The tables in a decision-support database are heavily indexed, and the raw data is frequently preprocessed and organized to support the various types of queries to be used. Because the users are not changing data, concurrency and atomicity issues are not a concern; the data is changed only by periodic, bulk updates made during off-hour, low-traffic times in the database.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!