(In the daily production environment, we are more exposed to OLTP system (i.e. online transaction process). These systems are characterized by real-time requirements, or at least have certain requirements for response time; The business logic is generally complex, which may require a variety of operations such as the electronic mall we are often in contact with.
In addition to these systems, there is another system called OLAP (online analysis process), which is generally used for system decision-making. It is usually associated with the concepts of data warehouse, data analysis and data mining. It is characterized by large amount of data, low requirements for real-time response or no attention to these requirements, mainly focusing on query and statistical operations.)