Service processing method and device and server

Abstract

The invention provides a service processing method and device and a server. The service processing method includes the steps of receiving a service access request; determining a range of to-be-accessed data of the service access request according to the service access request; comparing the range of the to-be-accessed data with a range of data saved by a production database; if the range of the to-be-accessed data is included in the range of the data saved by the production database, distributing the service access request to the production database. By means of the service processing method and device and the server, different service access requests can access different databases, and the fluency of service access is improved; by defining the range of the data saved in the production database, the amount of the data in the production database can be effectively controlled, the efficient data access of the production database is ensured, and the efficiency of executing services is improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a business processing method, device and server. Background technique [0002] With the gradual development of the business system, a large amount of data has been accumulated after years of operation, among which historical data occupies a relatively large scale, and many of these historical data are infrequently accessed data. When querying and / or modifying operations, due to the existence of a large amount of historical data, the performance of data operations such as querying of the entire system will be degraded, which seriously affects the running speed of the existing business system. [0003] In the existing related technologies, there are basically two technical solutions for historical data processing: one is to migrate useless (or infrequently used) historical data to another database to reduce the amount of data in the production database; the ot...

AI Technical Summary

Problems solved by technology

[0004] However, for the first solution, the production database only contains recently frequently accessed data, and the historical data is separated into another database. The access and operation of the historical data by the business system need to be connected to the historical database. For those who need to access all data operation, you need to connect two databases for data operations, and the processing is relatively complicated

[0005] For the second scheme, there is only one production database, and all data is stored in the production database. Since the actual data volume has not been reduced, the data is only partitioned by partitioning technology, but this scheme does not really reduce the production database. The amount of data, for data operations with invalid partitions, the performance of data operations cannot be improved, and the management and operation and maintenance of the overall database are more complicated

Images