What is the difference between a W/H and an OLTP application?

Answers were Sorted based on User's Feedback



What is the difference between a W/H and an OLTP application?..

Answer / manasi r

Warehouse is used for high level data analysis purpose.It
is used for predictions, timeseries analysis, financial
analysis , what -if simulations etc. Basically it is used
for better decision making.

OLTP is NOT used for analysis purpose.
It is used for transaction and data processing.
Its basically used for storing day-to-day transactions that
take place in an organisation.
The main focus of OLTP is easy and fast inputing of data,
while the main focus in data warehouse is easy retrieval of
data.
OLTP doesnt store historical data.(this is the reason why
it cant be used for analysis)
DW stores historical data.

Is This Answer Correct ?    17 Yes 0 No

What is the difference between a W/H and an OLTP application?..

Answer / bindu

W/H maintains subjectoriented,timevariant,histrorical data.
where as OLTP apllications maintains current data, and it
gets updates regularly. ex:ATM machine,Railway reservations
etc.

Is This Answer Correct ?    5 Yes 0 No

What is the difference between a W/H and an OLTP application?..

Answer / harshad

Workload
Data warehouses are designed to accommodate ad hoc queries.
You might not
know the workload of your data warehouse in advance, so a
data warehouse
should be optimized to perform well for a wide variety of
possible query
operations.
OLTP systems support only predefined operations. Your
applications might be
specifically tuned or designed to support only these
operations.
■ Data modifications
A data warehouse is updated on a regular basis by the ETL
process (run nightly or
weekly) using bulk data modification techniques. The end
users of a data
warehouse do not directly update the data warehouse.
In OLTP systems, end users routinely issue individual data
modification
statements to the database. The OLTP database is always up
to date, and reflects
the current state of each business transaction.
■ Schema design
Data warehouses often use denormalized or partially
denormalized schemas (such
as a star schema) to optimize query performance.
OLTP systems often use fully normalized schemas to optimize
update/insert/delete performance, and to guarantee data
consistency.
■ Typical operations
A typical data warehouse query scans thousands or millions
of rows. For example,
"Find the total sales for all customers last month."
A typical OLTP operation accesses only a handful of
records. For example,
"Retrieve the current order for this customer."
■ Historical data
Data warehouses usually store many months or years of data.
This is to support
historical analysis.
OLTP systems usually store data from only a few weeks or
months. The OLTP
system stores only historical data as needed to
successfully meet the requirements
of the current transaction.

Is This Answer Correct ?    2 Yes 0 No

What is the difference between a W/H and an OLTP application?..

Answer / shrihari

data warehouse is often use denormalized schema to optimize
query perfomance.

OLTP sytem often use fully normalized schema to optimize
update, insert, delete perfomance.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between a W/H and an OLTP application?..

Answer / guest

Ware house: Query reporting & analysis tool.

OLTP: For analysis purpose.

Is This Answer Correct ?    2 Yes 10 No

Post New Answer

More Data Warehouse General Interview Questions

How can you implement many relations in star schema model?

0 Answers  


I have two universes created by two difference database can we join them in designer & report level? How

0 Answers  


difference between For each and for all

2 Answers  


How to pivot row data using informatica?

0 Answers  


What is the difference between static cache and dynamic cache?

0 Answers  






Where the data cube technology is used?

0 Answers  


Explain the importance of data warehouse?

0 Answers  


In document how to create metrics?

0 Answers  


What is the main difference between inmon and kimball philosophies of data warehousing?

0 Answers  


where exactly in dataware house a confirmed dimension can be created

4 Answers   Deloitte,


Tell me what is full load & incremental or refresh load?

0 Answers  


What are the advantages of query studio compared to report studio?

0 Answers  


Categories