Data processing method and device based on partition database, equipment and storage medium

Abstract

The invention provides a data processing method and device based on a partition database, equipment and a storage medium, and relates to the technical field of databases. The method comprises the following steps: receiving a user login request sent by a client, and performing security verification on the identity of a user based on the user login request and a local database to obtain an identity verification result; determining a user area identifier corresponding to the user from a local database based on the identity verification result; sending the user area identifier to the client, so as to generate a service request at the client based on the user area identifier; receiving a service request sent by a client, and determining a target region database from database clusters located in different geographic regions according to the service request; and processing target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client. According to the embodiment of the invention, the processing efficiency of data processing in the database is greatly improved.

Description

Technical Field

[0001] The present invention relates to the field of database technology, and in particular to a data processing method, device, equipment and storage medium based on a partitioned database. Background Art

[0002] In related technologies, a distributed database architecture is generally used to store data on multiple servers according to certain rules (such as hash sharding and range sharding). Although this method alleviates the pressure of massive data processing and high concurrent access to a certain extent, this general distributed solution does not fully consider the regional characteristics of sellers' data, resulting in high network latency in cross-regional data access.

[0003] In the related art, there are at least the following disadvantages when processing data in the database: 1. Since data is stored in a centralized manner, when a single database server processes massive amounts of data, I / O operations and computing resources become bottlenecks, resulting in a decrease in data processing speed.

[0004] 2. In high-concurrency scenarios, a large number of requests access a single database server at the same time, causing server overload, increased response delays, and even service unavailability. Summary of the invention

[0005] The present invention provides a data processing method, device, equipment and storage medium based on a partitioned database, which is used to solve the defect of low efficiency in data processing in the database in the prior art, and realizes that by determining a target regional database from database clusters located in different geographical areas, the target data in the target regional database is processed based on the user's business request to obtain a business processing result, thereby greatly improving the processing efficiency of data processing in the database.

[0006] The present invention provides a data processing method based on a partitioned database, which is applied to a server and includes the following steps: Receive a user login request sent by a client, and perform security verification on the user's identity based on the user login request and a local database to obtain an identity verification result; Based on the identity authentication result, determining a user zone identifier corresponding to the user from the local database; Sending the user zone identifier to the client, so that the client generates a service request based on the user zone identifier; receiving the service request sent by the client, and determining a target regional database from database clusters located in different geographical areas according to the service request; The target data in the target area database is processed based on the service request, a service processing result corresponding to the service request is generated, and the service processing result is returned to the client.

[0007] Preferably, according to the data processing method based on partitioned database provided by the present invention, the user login request at least includes: a user login identification and a user login password; The local database at least includes: a preset user identifier and a preset user password corresponding to the preset user identifier; The security verification of the user's identity based on the user login request and the local database to obtain the identity verification result includes: Matching the user login identifier of the user with the preset user identifier to obtain a user identifier matching result; When the user identification matching result indicates that the user login identification is the same as the preset user identification, the user login password is matched with the preset user password to obtain the identity authentication result.

[0008] Preferably, according to the data processing method based on the partition database provided by the present invention, the local database at least includes: user area identifiers corresponding one-to-one to the preset user identifiers; The determining, from the local database, a user zone identifier corresponding to the user based on the identity authentication result includes: If the identity authentication result indicates that the user login password is the same as the preset user password, generating a user login success identifier; Based on the user login success identifier and the user login identifier, the user area identifier corresponding to the user login identifier is determined from the local database.

[0009] Preferably, according to the data processing method based on the partition database provided by the present invention, the service request at least includes a user area identifier; Determining the target regional database from database clusters located in different geographical areas according to the business request includes: Sending the service request to a service gateway so that the service gateway determines a target regional server from a server cluster according to the user regional identifier; wherein the server cluster includes at least two or more regional servers, each of the regional servers corresponds to each user regional identifier set one by one, and the user regional identifier set includes a single user regional identifier or one of more than two user regional identifiers; Based on the one-to-one mapping relationship between the regional server and the regional database, and the determined target regional server, the corresponding target regional database is determined from the database clusters located in different geographical areas; wherein the database cluster includes at least two or more regional databases, and the database cluster is distributed according to the territorial information of the user.

[0010] Preferably, according to the data processing method based on partitioned database provided by the present invention, the service request at least includes a service data processing instruction; The processing of the target data in the target area database based on the service request to generate a service processing result corresponding to the service request includes: According to the business data processing instruction, the target data in the target area database is processed to obtain the business processing result.

[0011] Preferably, according to the data processing method based on the partitioned database provided by the present invention, the business data processing instructions at least include adding business data, deleting business data, updating business data, and querying business data.

[0012] In a second aspect, the present invention further provides a data processing device based on a partitioned database, which is applied to a server side, and the device includes the following modules: The security verification module is used to receive a user login request sent by a client, and perform security verification on the user's identity based on the user login request and a local database to obtain an identity verification result; A user zone identification determination module, configured to determine a user zone identification corresponding to the user from the local database based on the identity authentication result; A service request generating module, configured to send the user zone identifier to the client, so as to generate a service request based on the user zone identifier at the client; A target area database determination module is used to receive the service request sent by the client and determine a target area database from database clusters located in different geographical areas according to the service request; A business processing result generating module is used to process the target data in the target area database based on the business request, generate a business processing result corresponding to the business request, and return the business processing result to the client.

[0013] In a third aspect, the present invention further provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the data processing method based on the partitioned database as described above is implemented.

[0014] In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements any of the above-described data processing methods based on a partitioned database.

[0015] In a fifth aspect, the present invention further provides a computer program product, comprising a computer program, which, when executed by a processor, implements any of the above-mentioned data processing methods based on a partitioned database.

[0016] The data processing method, device, equipment and storage medium based on partitioned database provided by the present invention, by receiving a user login request sent by a client, and based on the user login request and the local database, performing security verification on the identity of the user to obtain an identity verification result; based on the identity verification result, determining the user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so that the client generates a service request based on the user area identifier; receiving the service request sent by the client, and determining a target area database from database clusters located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client. It is used to solve the defect of low efficiency of data processing in the database in the prior art, and realizes that by determining the target area database from database clusters located in different geographical areas, processing the target data in the target area database based on the user's service request, obtaining a service processing result, and greatly improving the processing efficiency of data processing in the database. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0018] Figure 1 This is one of the flow charts of the data processing method based on the partition database provided by the present invention.

[0019] Figure 2 It is a schematic diagram of determining a user area identifier provided by the present invention.

[0020] Figure 3 It is a schematic diagram of determining the target area database provided by the present invention.

[0021] Figure 4It is a structural schematic diagram of a data processing device based on a partitioned database provided by the present invention.

[0022] Figure 5 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0023] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be clearly and completely described below in conjunction with the drawings of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0024] First, several nouns involved in the present invention are analyzed: Server: A device in a computer network that provides various services and resources to other computers or devices. Servers usually have the characteristics of high performance, high reliability and high availability to meet the needs of a large number of users accessing at the same time.

[0025] Database: It is a warehouse that organizes, stores and manages data according to the data structure. It is a collection of large amounts of data that is stored in a computer for a long time, organized, shareable and uniformly managed. The database not only contains data, but also supports functions such as data storage, query, update and management.

[0026] In the related art, there are at least the following technical problems: 1) Inefficient processing of massive data: With the rapid growth of sales and purchase information of sellers, the traditional single database architecture is unable to efficiently process massive data, resulting in slow response to operations such as data query and update, affecting business operation efficiency.

[0027] 2) High concurrent access performance bottleneck: During peak sales periods or promotional activities, a large number of users access the system at the same time. A single database server can easily become a performance bottleneck, causing system congestion and a decline in user experience.

[0028] 3) Regional data access delay: Since sellers are distributed across the country, the traditional centralized database architecture has high network delay when processing cross-regional data access, affecting data real-time and system response speed.

[0029] 4) Uneven resource allocation and high costs: The data volume and access volume of sellers across the country are unevenly distributed. A single database architecture makes it difficult to flexibly adjust resource allocation according to actual needs, resulting in waste or shortage of resources, while increasing hardware and maintenance costs.

[0030] Combine the following Figure 1-Figure 5 The present invention describes a data processing method, device, equipment and storage medium based on a partitioned database, which is used to solve the defect of low efficiency in data processing in the database in the prior art, and realizes that by determining a target regional database from database clusters located in different geographical areas, the target data in the target regional database is processed based on the user's business request to obtain a business processing result, thereby greatly improving the processing efficiency of data processing in the database.

[0031] Figure 1 This is one of the flow charts of a data processing method based on a partitioned database provided by the present invention, such as Figure 1 As shown, the method may include but is not limited to steps S100 to S500: S100, receiving a user login request sent by a client, and performing security verification on the user's identity based on the user login request and a local database to obtain an identity verification result; S200, determining a user area identifier corresponding to the user from the local database based on the identity authentication result; S300, sending the user zone identifier to the client, so that the client generates a service request based on the user zone identifier; S400, receiving the service request sent by the client, and determining a target regional database from database clusters located in different geographical areas according to the service request; S500: Process the target data in the target area database based on the service request, generate a service processing result corresponding to the service request, and return the service processing result to the client.

[0032] In step S100 of some embodiments, a user login request sent by a client is received, and based on the user login request and a local database, a security verification is performed on the user's identity to obtain an identity verification result.

[0033] It can be understood that the server receives the user login request generated by the client.

[0034] It should be further explained that the user login request at least includes: a user login identification and a user login password.

[0035] The local database at least includes: a preset user identifier and a preset user password corresponding to the preset user identifier.

[0036] The user login identifier may be a user account, data used to uniquely identify user information, such as A1, and the user login password is a login password that matches the user login identifier, such as 123.

[0037] The server matches the user's login ID with the preset user ID to obtain a user ID matching result.

[0038] The user ID matching results are divided into matching results where the user login ID is the same as the preset user login ID and matching results where the user login ID is different from the preset user login ID.

[0039] When the user identification matching result indicates that the user login identification is the same as the preset user identification, the user login password is matched with the preset user password to obtain the identity authentication result. Through identity authentication, the security of the database can be improved to avoid malicious tampering.

[0040] If the user ID matching result indicates that the user login ID is different from the preset user login ID, the user login password matching verification is no longer performed, and a user login ID error message is directly returned, which can save system resources.

[0041] In step S200 of some embodiments, based on the identity authentication result, a user zone identifier corresponding to the user is determined from the local database.

[0042] It can be understood that after executing step S100, the specific execution step may be to generate a user login success mark when the identity authentication result indicates that the user login password is the same as the preset user password; Based on the user login success identifier and the user login identifier, the user area identifier corresponding to the user login identifier is determined from the local database.

[0043] It should be noted that the local database at least includes: user area identifiers corresponding one-to-one to the preset user identifiers.

[0044] It is further understandable that after the user passes the security verification, a login success identifier is generated, and the user area identifier corresponding to the user login identifier is determined from the local database based on the login success identifier and the user login identifier.

[0045] like Figure 2 As shown, the user login identifier is the same as the preset user identifier, and the preset user identifier is associated with the user area identifier and stored in the local database, so the user area identifier can be determined according to the user login identifier.

[0046] In step S300 of some embodiments, the user zone identifier is sent to the client, so that the client generates a service request based on the user zone identifier.

[0047] It is understandable that after the server completes step S200, the server may specifically execute the step of sending the obtained user zone identifier to the client, so that the client generates a service request according to the user zone identifier.

[0048] More specifically, the user region identifier, domain name and business requirements are combined into a business request.

[0049] Business requirements, such as querying data B in database 3.

[0050] A domain name is a string used to identify one or more IP addresses. The domain name is converted into a corresponding IP address through the domain name resolution system, making it easier for users to access the website. A domain name consists of multiple parts, usually including a top-level domain name, a second-level domain name, etc. For example, in www.example.com, .com is the top-level domain name, example is the second-level domain name, and www is the third-level domain name (or host name).

[0051] In step S400 of some embodiments, the service request sent by the client is received, and a target regional database is determined from database clusters located in different geographical areas according to the service request.

[0052] First of all, it should be noted that the service request at least includes a user area identifier.

[0053] It is understandable that after executing step S300, the specific execution step may be sending the service request to a service gateway, so that the service gateway determines a target regional server from a server cluster according to the user regional identifier.

[0054] Based on the one-to-one mapping relationship between the regional server and the regional database and the determined target regional server, the corresponding target regional database is determined from the database clusters located in different geographical areas.

[0055] It should be further explained that the server cluster includes at least two regional servers, each of the regional servers corresponds to each user regional identifier set one by one, and the user regional identifier set includes a single user regional identifier or more than two user regional identifiers.

[0056] The database cluster includes at least two regional databases, and the database cluster is distributed according to the location information of the user.

[0057] like Figure 3 As shown, the server cluster may include but is not limited to regional server 0, regional server 1, regional server 2, regional server 3, regional server 4, and regional server 5.

[0058] The database cluster may include but is not limited to regional database 0, regional database 1, regional database 2, regional database 3, regional database 4, and regional database 5.

[0059] Regional database 0 is located in Henan Province, regional database 1 is located in Shandong Province, regional database 2 is located in Sichuan Province, regional database 3 is located in Beijing, regional database 4 is located in Guangdong Province, and regional database 5 is located in Jiangsu Province.

[0060] User area identifiers are, for example, db0, db1, db2, db3, db4, db5, and db6.

[0061] Each area server corresponds to each user area identifier set one by one, and the user area identifier set includes a single user area identifier or more than two user area identifiers.

[0062] The regional server 0 corresponds to the user regional identifier db0 and the regional server 0 also corresponds to the regional database 0.

[0063] The area server 6 corresponds to the user area identifier db6 and the user area identifier db7 , and the area server 6 only corresponds to the area data 6 .

[0064] One regional server may correspond to a single user regional identifier or more than two user regional identifiers, thus saving system resources and facilitating searching.

[0065] Based on the one-to-one mapping relationship between the regional server and the regional database and the determined target regional server, the corresponding target regional database is determined from the database clusters located in different geographical areas.

[0066] For example, if the target regional database is regional database 0, according to the mapping relationship between regional database 0 and regional server 0, and the determined target regional server, the corresponding target regional database can be quickly determined from the database clusters located in different geographical areas. This achieves accurate distribution of user requests and optimization of database access, greatly improving the system request processing capability and database access efficiency.

[0067] In step S500 of some embodiments, the target data in the target area database is processed based on the service request, a service processing result corresponding to the service request is generated, and the service processing result is returned to the client.

[0068] It should be noted that the service request at least includes a service data processing instruction.

[0069] Furthermore, the business data processing instructions at least include adding business data, deleting business data, updating business data, and querying business data.

[0070] It is understandable that after executing step S400, the specific execution steps may be to process the target data in the target area database according to the business data processing instruction, obtain the business processing result, and return the business processing result to the client.

[0071] In some embodiments of the present invention, scenario 1: Assume that user 0 needs to query his personal information. The user area identifier corresponding to the user is db0, which belongs to the db0 partition. After the user enters the login information through the front-end interface and successfully logs in, the front-end caches the db0 partition identifier. Subsequently, the user initiates a request to query personal information. The front-end concatenates the db0 partition identifier to the domain name and sends the request to the business gateway. The business gateway receives the request and distributes the request to server A according to the db0 partition identifier. Server A connects to the db0 database and queries the personal information of user 0, and finally returns the query result to the front-end.

[0072] Scenario 2: Assume that user 1 needs to update his shopping information. The user's user area identifier is db1, which belongs to the db1 partition. After the user enters the login information through the front-end interface and successfully logs in, the front-end caches the db1 partition identifier. Subsequently, the user initiates a request to update the shopping information. The front-end concatenates the db1 partition identifier to the domain name and sends the request to the business gateway. The business gateway receives the request and distributes it to server B according to the db1 partition identifier. Server B connects to the db1 database and updates user 1's shopping information, and finally returns the update result to the front-end.

[0073] Through the embodiment provided by the present invention, user partitioning and database partitioning technology are realized, which greatly reduces the system request pressure and improves the database access efficiency. At the same time, the method also has the following advantages: Scalability: As the number of users increases, new partitions and servers can be easily added to achieve horizontal expansion of the system.

[0074] Load balancing: The request distribution mechanism of the business gateway achieves load balancing of requests, avoiding overload of a single server or database.

[0075] Data security: The databases in each partition are independent of each other, which improves data security.

[0076] In some embodiments of the present invention, the present invention also discloses a data processing system based on a partitioned database applied to a data processing method based on a partitioned database, and through the data processing system based on the partitioned database, local access and efficient processing of sales information of sellers are achieved, which significantly improves the response speed and data processing capacity of the system and effectively solves the performance bottleneck problem caused by massive data and high concurrent access.

[0077] Secondly, the regional coding and database mapping mechanism recorded in the embodiment of the present invention ensures that user requests can be accurately routed to the server storing the corresponding data, thereby avoiding network delays and bandwidth consumption caused by cross-regional data transmission.

[0078] In summary, the embodiments of the present invention significantly improve the performance and user experience of the sales agent's purchase, sales and inventory information management system, and provide an effective solution for data processing in scenarios of massive data and high concurrent access.

[0079] The data processing method, device, equipment and storage medium based on partitioned database provided by the present invention, by receiving a user login request sent by a client, and based on the user login request and the local database, performing security verification on the identity of the user to obtain an identity verification result; based on the identity verification result, determining the user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so that the client generates a service request based on the user area identifier; receiving the service request sent by the client, and determining a target area database from database clusters located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client. It is used to solve the defect of low efficiency of data processing in the database in the prior art, and realizes that by determining the target area database from database clusters located in different geographical areas, processing the target data in the target area database based on the user's service request, obtaining a service processing result, and greatly improving the processing efficiency of data processing in the database.

[0080] The data processing device based on a partitioned database provided by the present invention is described below. The data processing device based on a partitioned database described below and the data processing method based on a partitioned database described above can be referred to each other.

[0081] like Figure 4 FIG. 1 is a schematic diagram of a data processing device based on a partitioned database provided by the present invention. The data processing device based on a partitioned database includes the following modules: The present invention provides a data processing device based on a partitioned database, which is applied to a server side. The device includes the following modules: The security verification module 410 is used to receive a user login request sent by a client, and perform security verification on the user's identity based on the user login request and a local database to obtain an identity verification result; A user region identification determination module 420, configured to determine a user region identification corresponding to the user from the local database based on the identity authentication result; A service request generating module 430, configured to send the user zone identifier to the client, so that the client generates a service request based on the user zone identifier; A target area database determination module 440 is used to receive the service request sent by the client, and determine a target area database from database clusters located in different geographical areas according to the service request; The business processing result generating module 450 is used to process the target data in the target area database based on the business request, generate a business processing result corresponding to the business request, and return the business processing result to the client.

[0082] According to the data processing device based on the partition database provided by the present invention, the user login request at least includes: a user login identification and a user login password; The local database at least includes: a preset user identifier and a preset user password corresponding to the preset user identifier; The security verification module 410 is further configured to match the user login identifier of the user with the preset user identifier to obtain a user identifier matching result; When the user identification matching result indicates that the user login identification is the same as the preset user identification, the user login password is matched with the preset user password to obtain the identity authentication result.

[0083] According to the data processing device based on the partition database provided by the present invention, the local database at least includes: user area identifiers corresponding one-to-one to the preset user identifiers; The user area identification module 420 is further configured to generate a user login success identification when the identity authentication result indicates that the user login password is the same as the preset user password; Based on the user login success identifier and the user login identifier, the user area identifier corresponding to the user login identifier is determined from the local database.

[0084] According to the data processing device based on the partition database provided by the present invention, the service request at least includes a user area identifier; The target area database determination module 440 is further configured to send the service request to a service gateway, so that the service gateway determines a target area server from a server cluster according to the user area identifier; wherein the server cluster includes at least two or more area servers, each of the area servers corresponds to each user area identifier set one by one, and the user area identifier set includes a single user area identifier or one of more than two user area identifiers; Based on the one-to-one mapping relationship between the regional server and the regional database, and the determined target regional server, the corresponding target regional database is determined from the database clusters located in different geographical areas; wherein the database cluster includes at least two or more regional databases, and the database cluster is distributed according to the territorial information of the user.

[0085] According to the data processing device based on the partitioned database provided by the present invention, the service request at least includes a service data processing instruction; The business processing result generating module 450 is further configured to process the target data in the target area database according to the business data processing instruction to obtain the business processing result.

[0086] According to the data processing device based on the partitioned database provided by the present invention, the business data processing instructions at least include adding business data, deleting business data, updating business data, and querying business data.

[0087] The data processing method, device, equipment and storage medium based on partitioned database provided by the present invention, by receiving a user login request sent by a client, and based on the user login request and the local database, performing security verification on the identity of the user to obtain an identity verification result; based on the identity verification result, determining the user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so that the client generates a service request based on the user area identifier; receiving the service request sent by the client, and determining a target area database from database clusters located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client. It is used to solve the defect of low efficiency of data processing in the database in the prior art, and realizes that by determining the target area database from database clusters located in different geographical areas, processing the target data in the target area database based on the user's service request, obtaining a service processing result, and greatly improving the processing efficiency of data processing in the database.

[0088] Figure 5 An example of a physical structure diagram of an electronic device is shown in FIG. Figure 5 As shown, the electronic device may include: a processor 510, a communication interface 520, a memory 530 and a communication bus 540, wherein the processor 510, the communication interface 520 and the memory 530 communicate with each other through the communication bus 540. The processor 510 may call the logic instructions in the memory 530 to execute a data processing method based on a partitioned database, the method comprising: receiving a user login request sent by a client, and performing security verification on the identity of the user based on the user login request and the local database to obtain an identity verification result; based on the identity verification result, determining a user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so that the client generates a service request based on the user area identifier; receiving the service request sent by the client, and determining a target area database from a database cluster located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client.

[0089] In addition, the logic instructions in the above-mentioned memory 530 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0090] On the other hand, the present invention also provides a computer program product, which includes a computer program, which can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the data processing method based on the partitioned database provided by the above methods, the method including: receiving a user login request sent by a client, and based on the user login request and the local database, performing security verification on the user's identity to obtain an identity authentication result; based on the identity authentication result, determining a user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so that the client generates a service request based on the user area identifier; receiving the service request sent by the client, and determining a target area database from a database cluster located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client.

[0091] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the data processing method based on a partitioned database provided by the above-mentioned methods, the method comprising: receiving a user login request sent by a client, and based on the user login request and a local database, performing security verification on the identity of the user to obtain an identity authentication result; based on the identity authentication result, determining a user area identifier corresponding to the user from the local database; sending the user area identifier to the client, so as to generate a service request based on the user area identifier at the client; receiving the service request sent by the client, and determining a target area database from database clusters located in different geographical areas according to the service request; processing the target data in the target area database based on the service request, generating a service processing result corresponding to the service request, and returning the service processing result to the client.

[0092] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Those of ordinary skill in the art may understand and implement it without creative effort.

[0093] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0094] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data processing method based on a partitioned database, characterized in that: Applied to the server side, the method includes: Receive a user login request sent by a client, and perform security verification on the user's identity based on the user login request and a local database to obtain an identity verification result; Based on the identity authentication result, determining a user zone identifier corresponding to the user from the local database; Sending the user zone identifier to the client, so that the client generates a service request based on the user zone identifier; receiving the service request sent by the client, and determining a target regional database from database clusters located in different geographical areas according to the service request; The target data in the target area database is processed based on the service request, a service processing result corresponding to the service request is generated, and the service processing result is returned to the client.

2. The data processing method based on partitioned database according to claim 1 is characterized in that: The user login request at least includes: a user login identification and a user login password; The local database at least includes: a preset user identifier and a preset user password corresponding to the preset user identifier; The security verification of the user's identity based on the user login request and the local database to obtain the identity verification result includes: Matching the user login identifier of the user with the preset user identifier to obtain a user identifier matching result; When the user identification matching result indicates that the user login identification is the same as the preset user identification, the user login password is matched with the preset user password to obtain the identity authentication result.

3. The data processing method based on partitioned database according to claim 2 is characterized in that: The local database at least includes: user area identifiers corresponding one to one with the preset user identifiers; The determining, from the local database, a user zone identifier corresponding to the user based on the identity authentication result includes: If the identity authentication result indicates that the user login password is the same as the preset user password, generating a user login success identifier; Based on the user login success identifier and the user login identifier, the user area identifier corresponding to the user login identifier is determined from the local database.

4. The data processing method based on a partitioned database according to any one of claims 1 to 3, characterized in that: The service request at least includes a user area identifier; Determining the target regional database from database clusters located in different geographical areas according to the business request includes: Sending the service request to a service gateway so that the service gateway determines a target regional server from a server cluster according to the user regional identifier; wherein the server cluster includes at least two or more regional servers, each of the regional servers corresponds to each user regional identifier set one by one, and the user regional identifier set includes a single user regional identifier or one of more than two user regional identifiers; Based on the one-to-one mapping relationship between the regional server and the regional database, and the determined target regional server, the corresponding target regional database is determined from the database clusters located in different geographical areas; wherein the database cluster includes at least two or more regional databases, and the database cluster is distributed according to the territorial information of the user.

5. The data processing method based on a partitioned database according to any one of claims 1 to 3, characterized in that: The service request at least includes a service data processing instruction; The processing of the target data in the target area database based on the service request to generate a service processing result corresponding to the service request includes: According to the business data processing instruction, the target data in the target area database is processed to obtain the business processing result.

6. The data processing method based on partitioned database according to claim 5 is characterized in that: The business data processing instructions at least include adding business data, deleting business data, updating business data, and querying business data.

7. A data processing device based on a partitioned database, characterized in that: Applied to the server side, the device comprises: The security verification module is used to receive a user login request sent by a client, and based on the user login request and a local database, perform security verification on the user's identity to obtain an identity verification result; A user zone identification determination module, configured to determine a user zone identification corresponding to the user from the local database based on the identity authentication result; A service request generating module, configured to send the user zone identifier to the client, so as to generate a service request based on the user zone identifier at the client; A target area database determination module is used to receive the service request sent by the client and determine a target area database from database clusters located in different geographical areas according to the service request; A business processing result generating module is used to process the target data in the target area database based on the business request, generate a business processing result corresponding to the business request, and return the business processing result to the client.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the data processing method based on the partitioned database as described in any one of claims 1 to 6 is implemented.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the data processing method based on a partitioned database as claimed in any one of claims 1 to 6 is implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the data processing method based on a partitioned database as claimed in any one of claims 1 to 6 is implemented.

Images