Shulou(Shulou.com)06/01 Report--

Today's data processing can be roughly divided into two categories: online transaction processing OLTP (on-line transaction processing) and online analytical processing OLAP (On-Line Analytical Processing). OLTP is the main application of traditional relational database, which mainly deals with basic and daily transactions, such as bank transactions. OLAP is the main application of data warehouse system, which supports complex analysis operations, focuses on decision support, and provides intuitive and easy-to-understand query results. OLTP: also known as transaction-oriented processing system, its basic feature is that the customer's original data can be immediately transmitted for processing, and the processing results can be given in a very short time. The biggest advantage of this is that the input data can be processed immediately and answered in a timely manner. Also known as real-time system (Real time System). One of the important performance indicators of the online transaction processing system is the system performance, which is embodied in Response Time, that is, the time it takes to the computer to reply to the request after the user sends the data on the terminal. The OLTP is done by the database engine. The OLTP database is designed to enable transactional applications to write only the data they need so that individual transactions can be processed as soon as possible. OLAP: abbreviated as OLAP. With the development and application of database technology, the amount of data stored in the database has changed from megabytes (M) and gigabytes (G) in the 1980s to megabytes (T) and gigabytes (P) now. At the same time, the query requirements of users are becoming more and more complex, which involves not only querying or manipulating one or more records in a relational table. Moreover, it is necessary to analyze and synthesize the data of thousands of records in multiple tables, and the relational database system can not all meet this requirement. In foreign countries, many software manufacturers have adopted the development of their front-end products to make up for the lack of support of relational database management systems, trying to unify the decentralized public application logic and respond to the complex query requirements of non-data processing professionals in a short time. Online analytical processing (OLAP) system is the most important application of data warehouse system, which is specially designed to support complex analysis operations, focusing on decision support for decision-makers and senior managers. It can quickly and flexibly process complex queries with large amounts of data according to the requirements of analysts, and provide query results to decision-makers in an intuitive and easy-to-understand form. So that they can accurately grasp the operating conditions of the enterprise (company), understand the needs of the object, and formulate the correct plan.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.