recategorized
2,732 views

1 Answer

0 votes
0 votes

Answer must be OLAP

OLTP (On-line Transaction Processing) 

  •  characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE).
  • The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.
  • In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF). 


OLAP (On-line Analytical Processing)

  • characterized by relatively low volume of transactions.
  • Queries are often very complex and involve aggregations.
  • For OLAP systems a response time is an effectiveness measure.
  • OLAP applications are widely used by Data Mining techniques.
  • In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).

It is a helpful link..

http://datawarehouse4u.info/OLTP-vs-OLAP.html

Answer:

Related questions

3 votes
3 votes
1 answer
1
go_editor asked Aug 8, 2016
3,873 views
____ allows selection of the relevant information necessary for the data warehouse:The Top-Down ViewData Warehouse ViewDatasource ViewBusiness Query View
1 votes
1 votes
1 answer
3
makhdoom ghaya asked Sep 9, 2016
1,353 views
A data mart may containSummarised dataDe-normalized dataAggregate departmental dataAll of the above
1 votes
1 votes
1 answer
4
makhdoom ghaya asked Jul 23, 2016
2,377 views
Fact-less fact table in a data warehouse containsOnly measuresOnly dimensionsKeys and measuresOnly surrogate keys