What's the difference between OLTP and OLAP?

OLTP and  OLAP look similar but refer to different kinds of database systems. Both of them are online processing systems. When we talk about databases, most people think of OLTP. We can suppose that OLTP systems provide source data to the OLAP systems that help us to analyze the data.

What's  OLTP?

OLTP stands for Online Transactional Processing and the main focus of  OLTP is to excel in looking up filtered information and manage current Update, Insertion, and Deletion while a transaction.OLTP workloads consist of short transaction that runs in a small period concurrently. So OLTP database effectiveness can be measured by the number of transactions per second.

Common tasks for  OLTP:

  • What is the userID of the current user?
  • What is the current location of the user?
  • Delete billing information of a specific user or group.
  • Update user information.

Common OLTP systems :

  • Mysql
  • Oracle Database
  • Postgresql
  • Microsoft SQL
  • IBM DB2

What's  OLAP?

OLAP stands for Online Analytical Processing system. In contrast OLTP systems, OLAP database is designed to store historical data to process large datasets to answer questions about data. The main focus of OLAP to help us extract useful information from different multi-dimensional data.

Common tasks for  OLAP:

  • What's the user life-time value of an application?
  • What's the average age of users on a web platform?
  • User activities over time.
  • All data warehouse tasks.

Common OLAP systems :

  • Amazon Redshift
  • IBM Netezza
  • HP Vertica
  • KDB+


Tagged In:

I'm a IT Infrastructure and Operations Architect with extensive experience and administration skills and works for Turk Telekom. I provide hardware and software support for the IT Infrastructure and Operations tasks.

205 Total Posts
Follow Me


  1. sleeping pills and viagra pueden usar viagra los jovenes viagra adag

  2. viagra von steuer absetzen losartan potassium viagra does viagra make you go deaf

  3. viagra uso femenino koliko je stetna viagra importazione illegale viagra

  4. buy viagra onoine viagra from canada paypal viagra online plus 2 free viagra

  5. gostaria de saber sobre viagra purevigra.com nadelen van viagra

  6. viagra generic trial pack viagra levitra online cheapest viagra with mastercard

  7. viagra in dubai price https://buybuyviamen.com/ viagra elevation sickness

  8. viagra real experiences https://purevigra.com info viagra 50mg

  9. viagra purchase without prescription online viagra overnight viagra sydney

  10. koronare herzkrankheit und viagra https://buybuyviamen.com nhs to sell viagra

  11. viagra on high streets viagra mas rapido leki jak viagra

  12. viagra lowyat viagra patient education procoralan et viagra

  13. viagra mit 70 jahren thuoc viagra ban o dau viagra or nitric oxide

  14. viagra man walmart without prescription pharmacist https://paradiseviagira.com viagra generic cost

  15. viagra for sale usa https://paradiseviagira.com viagra gold bestellen

  16. sildenafil 100mg tablets canada viagra tablets online india where can you buy viagra for women

  17. order viagra united states how can i get sildenafil viagra mastercard online pharmacy

  18. real viagra uk generic sildenafil uk buy viagra over the counter usa

  19. how to order viagra online viagra 100 buy viagra china

  20. mdprice.com viagra tom tokio hotel overdose de viagra viagra kvinna

  21. cheapest viagra in united states sildenafil women where can i buy sildenafil 100mg

  22. pfizer brevet viagra viagra pentru femei pret el viagra en jovenes

  23. obamacare and viagra viagra lack of sensation viagra prawdziwa

  24. brand name viagra viagra who accept mastercard cialis viagra levitra canada

  25. sildenafil purchase india female viagra real sildenafil india buy

  26. viagra for sale in uk cheap average cost of viagra in canada average cost for viagra

  27. female viagra mexico order sildenafil 20 mg generic sildenafil 20 mg

  28. essay writing reviews college essay document research paper 5th grade

  29. compare and contrast college essay college essay organization write me a research paper on compost

  30. writing a farewell speech essays about college education interactive presentation

  31. buy powerpoint presentation creative college essays literary research papers

  32. college essays online essay writing tip professional college essays

  33. research paper charts need help with my homework solve my math problem

  34. health article review assignment application essay for college

  35. my writing experience essay help with college math writing a thesis proposal

  36. winning college essays pay for homework to get done essay writing service toronto

  37. college essay new york times academic essays write my paper for cheap

  38. viagra sale buy viagra insurance youtube viagra prices

  39. essay writing beginners my assignment help australia need help with homework questions

  40. buy essays already written essay skeleton education cover letter

  41. writing an essay for college homework essay hook college essay list

  42. to buy cialis generic cialis 40mg generic viagra cialis paypal

  43. order online cialis with dapoxetine overnight cialis with dapoxetine cialis daily dose

  44. buy cialis with paypal cialis with dapoxetine from canada cialis on paypal

  45. viagra soft tabs 100mg buy viagra online viagra in kuwait

  46. viagra online nz viagra plus viagra without prescription australia

  47. generic cialis cost take cialis the correct way is it legal to buy cialis online?

  48. alternatives to viagra men order viagra with pay pal viagra tablet

  49. cialis and dapoxetine tabs in usa really really cheap cialis cialis free trial phone #

  50. cialis paypale cialis 20 mg sell how long does cialis last

  51. women viagra for sale 365 pills viagra viagra for sale

  52. viagra online united kingdom viagra india cost of generic viagra

  53. buy cialis free shipping best way to take cialis buy daily cialis from canada

  54. geneneric cialis aus canadian meds cialis buy real cialis on line us with american express florida

  55. viagra online over nigth shiping various kinds of viagra viagra online without prescription

  56. online super viagra australia viagra without rx buying viagra in canada

  57. big cheap alternates of viagra paypal viagra no prescription what does viagra cost in uk

  58. buy cheap viagra online viagra site web asking your doctor, young, viagra

  59. brand viagra offers how to buy viagra online viagra price comparison uk

  60. buy viagra 100mg where to buy viagra seattle buy viagra

  61. cialis generico en tijuana what is the shelf life of viagra viagra online safely effof Sex

  62. real brand viagra for sale sublingual viagra 150 mg yasmin order online effof Sex

  63. erection pills online canadian pharmacy pharma

  64. cialis 20 mg how it works generic viagra with paypal price of viagra 100mg tablet effof Sex

  65. online drugstore drug store news ce indian pharmacy

  66. us online pharmacy pharmacy cheap best drugstore shampoo

  67. drug store on line pharmacy online pharmacy without scripts

  68. canada drug pharmacy canada drugs drug rx

  69. pharmacy rx world best drugstore highlighter canadian pharmacies

  70. canada rx pharmacy canadian online pharmacies canadian pharmacy generic viagra

  71. buy viagra without presciption generic viagra overnight delivery viagra, depoxtine viagra/overnight shipping purchase generic viagra online viagra pt. priligy viagra viagra store in las vegas where i can get viagra in sydney viagra priority mail delivery 3 5 business days buy viagra online without prescription viagra with paypal payment gold viagra x1 buy viagra 100 mg online levitra and viagra perth australia

  72. buy viagra in canada legally buy brand viagra in canada genetic viagra viagra erectile dysfunction pills can i order viagra online without prescription viagra for sale with a prescription in las vegas nv viagra/ dapoxetine viagra australia buy online generic viagra mastercard buy viagra online ireland viagra professional 100mg viagra for sale viagra on line purchase viagra price where can i get viagra across the counter in the uk

  73. buy proscar how much does viagra cost secure tabs online viagra 100mg effof Sex

  74. does viagra go stale cheapest viagra online prescription viagra viagra with dapoxetine viagra in dubai dapoxetine viagra purchase low dose viagra pink viagra ordering viagra online is it legal viagra samples online generic viagra viagra australai walgreens over the counter viagra walgreens over the counter viagra viagra no prescription canada

  75. drugs market viagra super viagra plus lowest price viagra buy viagra 100mg online buy dapoxetine viagra usa on line viagra generic viagra online to usa viagra online 100mg buy viagra super active viagra 100 mg price viagra uk next day top online generic viagra 100mg viagra buying viagra without perscription viagra with dapoxetine online

  76. 30 day free trial cialis buy cialis buy cialis blog usa http://21cialismen.com/ - cialisorigina ’

  77. cheap viagra express shipping buy viagra on line viagra paypal payment canada http://acialaarx.com/ - viagra online highpoint ’

  78. kamagra visa debit cialis 10mg online levitra prescription singapore effof Sex

  79. cialis online safe cialis professional is generic cialis from india safe http://cialijomen.com/ - generic cialis with dapoxetine 80mg ’

  80. cialis for sale brand 36 hour cialis health plus cialis http://mycialedst.com/ - buy cialis online free shipping ’

  81. generic viagra online canadian pharmacy viagra generic date generic viagra with dapoxetine 160mg x 16 tabs http://llviabest.com/ - overnight delivery of viagra ’

  82. viagra online sales australia buy viagra without prescrip generis viagra http://genericrxxx.com/ - buy viagra online without a prescription with overnight delivery ’

  83. best prices generic viagra 100mg guaranteed natural viagra viagra austrlia http://genqpviag.com/ - viagra sale in uk ’

  84. how to buy cialis online from canada cialis use in dogs cialis comparison http://phrcialiled.com/ - price generic cialis ’

  85. viagra jersey city is it safe to buy viagra from canada viagra online singapore https://canadianpharmacy-usx.com/organic.htm - viagra covered on line by insurance ’

  86. buy cialis pils on uk cialis male enhancement buy cialis at walmart http://cialmenshoprx.com/ - buying cialis ’

  87. viagra without a prescripsion buy prescription only viagra trusted store viagra generic http://xz-pharmacyonline.com/en/career-opportunities.html - viagra, depoxtine ’

  88. cialis los angeles cialis for daily use cialis australia http://sjcialis.com/ - cialis no prescription ’

Leave a Reply