What is the Difference between OLTP and OLAP

Question:What is the Difference between OLTP and OLAP?

Answer: <br><b>Answered by swetha on 2005-03-30 12:00:33:</b> OLTP&nbsp;<br />&nbsp;<br />Current data&nbsp;<br />Short database transactions&nbsp;<br />Online update/insert/delete&nbsp;<br />Normalization is promoted&nbsp;<br />High volume transactions&nbsp;<br />Transaction recovery is necessary&nbsp;<br />&nbsp;<br />&nbsp;<br />OLAP&nbsp;<br />Current and historical data&nbsp;<br />Long database transactions&nbsp;<br />Batch update/insert/delete&nbsp;<br />Denormalization is promoted&nbsp;<br />Low volume transactions&nbsp;<br />Transaction recovery is not necessary&nbsp;<br />&nbsp;<br />

Tags:Interview Questions, Data Warehouse, Basics,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Real Estate Management System Software

Real Estate Management Software is an advanced end-to-end Real Estate Office Management System that enables Real Estate Agencies to manage more effectively, search prorty details, keep property owner data etc. Web-based tracking and accounting solution ideal for commercial, residential housing....