Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Difference between DSS & OLTP?

Answers were Sorted based on User's Feedback

Difference between DSS & OLTP?..

Answer / anup kumar dash

DSS(Decission support system) which helps to take decission
for the top executive people. it generally based on
historical data

OLTP(Online trasnaction processing)system is the the
system where day to day transaction are taking into
consideration. it based on current data.

Anup Kumar Dash

Is This Answer Correct ?    53 Yes 5 No

Difference between DSS & OLTP?..

Answer / anil panguluri

1- It is desined to support business transactional processing.
2- It is designed for running the business operations.
3- Volatile data.
4- Current data.
5- Normalised data.
6- Application oriented data.
7- 3-6 months of transaction history.
8- Desinged for clertical operation.

1- It is designed to support desition making process.
2- It is designed for analying business operations.
3- Non volatile database.
4- Detailed data.
5- denormalised data.
6- Subject oriented data.
7- 5-20 years of transaction data.
8- Desinged for manageral access.

Is This Answer Correct ?    33 Yes 3 No

Difference between DSS & OLTP?..

Answer / sonia kapoor

Information systems are classified into two major
categories, according to international developments: A. On-
line transactional processing systems (also called
operational systems)

B. Decision support systems (DSS)

&#913;. On-line transactional processing systems OLTPs are
systems which serve transactions with suppliers, partners
and customers, as well as internal business transactions.
They support operations throughout the value chain of the

Supply Chain Management (SCM)
Production support (e.g. MRP, Advanced Planning &
Customer interface management (e.g. sales, order management
and billing) (CRM)
Finance and Accounting (ERP)
Sales force automation
Web channel operations (eCRM)
Internal workflow support systems
&#914;. Decision support systems DSS provide management at all
levels of the Organisation, with information which supports
understanding of the current Business position and taking
informed decisions (fact based management). OLTP vs DSS
systems Even though OLTP (on-line transactional processing)
and DSS (decision support systems) functionalities may
overlap (e.g. an OLTP system may provide some operational
reporting functionality used for decision support), it is
clear that the purpose of the 2 categories differs, given
that they serve different functions and different User
groups in the Business. Therefore the development
philosophy of the two categories differs radically.
Specifically, differences are identified on the following
criteria (1 for OLTP, 2 for DSS): System functional

Clearly specified given that the system serves specific
functional needs – the predetermined transactions
the determination of a complete requirement set is a
challenge, given that there are dynamically changing
informational requirements.
Capture of current and historical information:
Current state information is captured (some historical data
may exist only to serve potential future transactions)
Recent and historical information is captured (current may
not be captured, given that data from the OLTP are
retrieved at regular intervals)
Data models used:
Complex, focused on business entities (in terms of
relational databases it is called normalized data structure
(e.g. 3NF))
Different approaches exist. The simplified denormalised
dimensional structure gains momentum, since it allows
easier understanding by business users and optimized
execution of complex queries.
Information level of detail:
Detailed data per transaction are kept
Detailed data are kept in a different structure and are
enriched by ‘dimensional’ information which allows
analytical processing. Moreover, aggregated data like KPIs
(key performance indicators), are calculated and stored in
persistent storage.
Volume of data:
The volume of data is relevant to the size of the Business
and the penetration of IT in it.
The data volume handled by a DSS, is multiple of that of
the OLTP systems on which it is based, given that it
maintains multiple historical snapshots

Is This Answer Correct ?    11 Yes 3 No

Difference between DSS & OLTP?..

Answer / chenna

DSS(Decission support system) which helps to take decission
for the top executive people andbusiness manegements. it
generally based on
historical data(datawarhouse).
OLTP IS Online trasnaction processing,
OLTP contain curent data.
and it also maintains day to day transactios.
OLTP is a operational data.

Is This Answer Correct ?    13 Yes 7 No

Difference between DSS & OLTP?..

Answer / igor grubisic

These are two different entities. While OLTP is a type of
data base organisation, DSS is a mathematical methodology.
OLTP contains transactional data and in contrast to it,
historycal data are contained in OLAP i.e. data
warehousing. In contrast to that, DSS can benefit from both
OLAP and OLTP. The main strength of DSS is a possibility to
use subjective reasoning of decision maker, in order to
make a decision. As a data foundation for DSS one can
utilize OLAP, OLTP or just its own logic and experience.

Is This Answer Correct ?    7 Yes 4 No

Difference between DSS & OLTP?..

Answer / 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

More Data Warehouse General Interview Questions

In document how to create metrics?

0 Answers  

What is an OLAP (On-line Analytical processing) system?

1 Answers  

What should I have in mind when building olap solution from scratch?

0 Answers  

can anybody mail me the FAQS for hyperion essbase amd planning

0 Answers   DataMonitor,

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

0 Answers  

What are components of reportnet?

0 Answers  

When should one use an MD-database (multi-dimensional database) and not a relational one?

2 Answers   IBM,

Fact table is in normalized or de-normalized form?

0 Answers  

What are the different types of datawarehosuing?

0 Answers  

Explain the data types present in bo n wht happens if we implement view in the designer n report?

0 Answers  

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

2 Answers   L&T,

How can we run the graph? How can we schedule the graph in unix?

0 Answers