Difference Between OLTP And OLAP Databases
What Is OLTP (Online Transaction Processing)? Online transaction processing system (OLTP) is designed to support transaction-oriented applications related to 3-tier architecture. OLTP stores day-to-day business transactions and is well-suited for querying specific records for example email address of a customer. OLTP is carried in a client server system and many organizations use database management system … Read more