Method and equipment for processing database operation request

Abstract

The invention discloses a method and equipment for processing a database operation request. The method comprises the following steps of: receiving the database operation request; analyzing the operation request to obtain a first data table name in the operation request; analyzing the operation request according to table division information to obtain a table division field correlated with the first data table name in the operation request and a field valve corresponding to the table division field, wherein the table division information comprises the data table name of a data table to be divided and the table division field correlated with the data table name; modifying the first data table name in the operation request into a second data table name according to the table division information and the field value corresponding to the obtained table division field; and transmitting the modified operation request to a database server.

Description

technical field [0001] The invention relates to database technology, in particular to a method and device for processing database operation requests. Background technique [0002] In the computer age, there have been database systems specially used for storing and managing data, and database systems have become increasingly popular in network applications. Generally speaking, a database system includes one or more databases dedicated to storing data of an application. In a relational database, data is generally distributed in multiple data tables, and each data table contains data of a certain aspect. For example, in a common network application database, there is a data table that stores the basic information of the user, and another data table that stores the user's login information. [0003] With the development of the times and the advancement of technology, the amount of data generated by human society every day is quite astonishing. Massive data has caused the data ...

AI Technical Summary

Problems solved by technology

The biggest disadvantage of this solution is that the application writer needs to control the correspondence between the data and the specific subtable. The application writer must have a good understanding of the implementation of the underlying subtable of the database. While writing the specific business logic, they must also Distracted from processing the relationship between logical tables and physical sub-tables, development efficiency is seriously affected

Secondly, the sub-table strategy of this scheme is too rigid and not flexible enough

If you want to adjust the number of sub-tables or modify the corresponding relationship between sub-table field values ​​and sub-table serial numbers, the application writer must also make corresponding modifications to the code so that the application can run correctly on the new sub-table architecture. Application system maintenance High cost

Images