OLTP and OLAP is two different types of database. both have different function but they works on data. Actually these are designed to simplify works. First OLTP has been introduced then OLAP comes in industry. lets see first on OLTP
OLTP stands for Online Transactional Process. It works on current data like insert, delete, update and manipulate. Every organization uses OLTP to stores customers, employee and product information. When we talk about shopping mall product puchase report, billing report, customer report also stored in OLTP database. OLTP is major part of any organization. As i told earlier, it works only on current data and has facility to makes some changes on data.
