Shulou(Shulou.com)05/31 Report--

Editor to share with you what OLTP is, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

I. definition

Online transaction processing (OLTP, Online transaction processing) refers to the processing of general real-time job data by means of online transactions through information systems, computer networks and databases, which is different from the mass operation of earlier traditional database systems. OLTP is usually used in automated data processing, such as order entry, financial services. And other repetitive daily trading activities. Also known as transaction-oriented processing system, its basic feature is that the customer's original data can be immediately transmitted to the computing center for processing, and the processing results can be given in a very short time.

Second, characteristics

1. Support a large number of concurrent users to add and modify data on a regular basis.

2. Reflect the state of the unit that changes at any time, but do not keep its historical record.

3. Contains a large amount of data, including a large amount of data used to validate transactions.

4. It has complex structure.

5. It can be optimized to respond to transaction activities.

6. Provide the technical infrastructure to support the daily operation of the unit.

7. Individual transactions can be completed quickly and only need to access relatively little data. The OLTP system is designed to handle hundreds of transactions entered at the same time.

8. High real-time requirements. The amount of data is not very large.

Transactions are generally deterministic, so OLTP accesses deterministic data. (for example, both deposits and withdrawals have a specific amount.)

Concurrency requires high and strict requirements for the integrity and security of transactions. (for example, it is possible that you and your family withdraw money from the same account in different banks at the same time.)

Matters needing attention

The transaction system database should be designed to support:

1. Good data placement.

For OLTP systems, input / output bottlenecks are of particular concern because there are so many users who modify the data in the whole database. Identify possible access patterns for data and put frequently accessed data together. In this process, filegroups and RAID (redundant Array of Independent disks) systems can be supplemented.

two。 Shorten transactions to minimize long-term locks and improve concurrency.

Avoid user interaction during a transaction. Whenever possible, the entire transaction is processed by executing a single stored procedure. The order of references to tables within a transaction may affect concurrency. Place references to frequently accessed tables at the end of the transaction to minimize the duration of the control lock.

3. Online backup.

OLTP systems are usually characterized by continuous operation (24 hours a day, 7 days a week). In order to achieve this, downtime should be kept to an absolute minimum. Although Microsoft SQL Server 2000 can back up a database when it is in use, the backup process should be scheduled when it is not active to minimize the impact on users.

4. The database is highly standardized.

Reduce redundant information as much as possible to increase the speed of updates, thereby improving concurrency. Reducing data can also increase the speed of backups because you only need to back up less data.

5. Little or no historical or aggregated data.

Data that is rarely referenced can be archived to a separate database or removed from frequently updated tables and placed in tables that contain only historical data. This will keep the table as small as possible, reducing backup time and improving query performance.

6. Use indexes carefully.

Each time a row is added or modified, the index must be updated. To avoid too many indexes on frequently updated tables, the index range should be kept narrow. Use the Index Optimization Wizard to design the index.

IV. The difference between OLAP and OLTP

OLTPOLAP user operators, low-level managers, decision-makers, senior managers functions daily operation processing, analysis and decision-making DB design is application-oriented, current, latest detail, two-dimensional discrete history, aggregation, multi-dimensional integration Unified access, read / write dozens of records, read millions of records, read millions of records, simple transactions, complex query users, thousands of DB sizes, 100MB-GB100GB-TB time requirements, real-time requirements, not strict time requirements, major application databases, data warehouses, above is all the content of the article "what is OLTP?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.