What is the difference between OLTP and OLAP?

Today's data processing can be broadly divided into two broad categories: online transaction processing OLTP (on-line transaction processing), online analytical processing OLAP (On-line Analytical Processing). OLTP is the main application of the traditional relational database, mainly basic and daily transaction processing, such as bank transaction. OLAP is the main application of Data Warehouse system, support complex analysis operation, focus on decision support, and provide intuitive and understandable query results.
Oltp:
Also known as transaction-oriented processing systems, the basic feature is that customer raw data can be transmitted immediately to the computing center for processing, and the processing results are given in a very short time.
The biggest advantage of this is that you can instantly process the input data and respond in a timely manner. Also known as real-time systems (real time system). An important performance index of the online transaction processing system is the performance of the system, which is embodied in the real-time response time (Response times), that is, after the user sends the data to the terminal, the time required for the computer to reply to the request. OLTP is done by the database engine.
The OLTP database is designed to allow transactional applications to write only the data that they need in order to process a single transaction as quickly as possible.
Olap:
Shorthand for OLAP, with the development and application of database technology, the data stored in database has been transited from the 1980s trillion (M) byte and Gigabit (G) byte to the present gigabit (T) byte and Gigabit (P) Byte, meanwhile, the user's query demand is becoming more and more complex. It is not only the query or manipulation of one or several records in a relational table, but also the data analysis and information synthesis of thousands records in multiple tables, and the relational database system can not fully meet this requirement. In foreign countries, many software manufacturers have taken the development of their front-end products to make up for the lack of support of relational database management system, trying to unify dispersed public application logic and respond to the complex query requirements of non data processing professionals in a short time.
On-Line Analytical Processing (OLAP) system is the main application of Data Warehouse system, specially designed to support complex analysis operations, focusing on decision support for decision-makers and senior managers, and can quickly and flexibly carry out complex query processing of large amount of data according to the requirements of analysts. And in an intuitive and understandable form of the query results provided to decision makers, so that they accurately grasp the business (company), understand the needs of the object, formulate the correct plan.