Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11740 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is VLDB?
Explain a mapping, session, worklet, workflow, mapplet?
What are the tools available for etl?
How many project sources we can create in metadata?
How to create prompts in report net?
What is Analysis Services?
After the complete generation of a report who will test the report and who will analyze it?
Explain piconet?
Can any one explain the hierarchies level data warehousing.
What is the difference between olap and datawarehosue?
Code the tables statement for a single-level (most common) frequency?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Compare aggregates and data marts
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
