Data processing method, data processing device, server, and storage medium

CN116127497BActive Publication Date: 2026-09-11GUANGDONG LEHUA HOME FURNISHING CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202211489829.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-11-25
Publication Date
2026-09-11
Estimated Expiration
2042-11-25

AI Technical Summary

Technical Problem

然而,这样的数据处理方式不但浪费存储资源,每次有新应用平台接入时还需重新进行存储资源的申请、分配和调度,降低服务器的数据处理效率

Benefits of technology

[0034]This invention proposes a data processing method applied to a server connected to more than one application platform. The method extracts the platform identifier code of each application platform from its data processing requests. Using this platform identifier code, a data identifier code is obtained from the target database to distinguish the application platform's data from other platforms. Based on this data identifier code, the method processes the data required by the application platform and returns the corresponding processing results to the application platform. This achieves data isolation between different platforms in the target database based on the data identifier code. The server does not need to allocate separate data storage space for different application platforms; data management for different application platforms can be achieved through the combined use of the platform identifier code and the data identifier code. Different application platforms can share a single storage space. This also reduces the server's data management process by minimizing the application, allocation, and scheduling of storage resources, thereby reducing storage resource waste and improving server data processing efficiency when managing data from multiple application platforms.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116127497B_ABST
    Figure CN116127497B_ABST
Patent Text Reader

Abstract

The application discloses a data processing method, a data processing device, a server and a storage medium. The server is connected with more than one application platform. The method comprises the following steps: receiving a data processing request of the application platform, extracting a platform identification code of the application platform in the data processing request; determining a data identification code corresponding to the platform identification code, processing target data in a target database according to the data identification code to obtain a data processing result; wherein the data identification code is identification information of data in the target database for distinguishing different application platforms; and sending the data processing result to the application platform. The application aims to reduce the waste of storage resources when the server manages more than one application platform and improve the data processing efficiency of the server.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to data processing methods, data processing devices, servers, and storage media. Background Technology

[0002] Currently, when it is necessary to manage and control data processing on different application platforms, a public server is generally set up. The server connects to different application platforms and processes data according to the data processing requirements of different application platforms.

[0003] Because different application platforms have different data access permissions, servers typically allocate independent data storage spaces for each platform during data isolation. These storage spaces store all the data permitted for use by the corresponding application platform. When an application platform has a data processing request, it calls upon that platform's corresponding storage space for processing. However, this data processing method not only wastes storage resources, but also requires re-application, allocation, and scheduling of storage resources each time a new application platform connects, reducing the server's data processing efficiency. Summary of the Invention

[0004] The main objective of this invention is to provide a data processing method, a data processing device, a server, and a storage medium, which aims to reduce the waste of storage resources and improve the data processing efficiency of the server when managing data for more than one application platform.

[0005] To achieve the above objectives, the present invention provides a data processing method applied to a server, the server being connected to more than one application platform, the data processing method comprising the following steps:

[0006] Receive a data processing request from the application platform and extract the platform identifier code of the application platform from the data processing request;

[0007] The data identifier code corresponding to the platform identifier code is determined, and the target data in the target database is processed according to the data identifier code to obtain the data processing result; wherein, the data identifier code is the identification information in the target database used to distinguish data from different application platforms;

[0008] The data processing results are sent to the application platform.

[0009] Optionally, the step of processing the target data in the target database according to the data identifier code to obtain the data processing result includes:

[0010] Obtain the initial SQL statement corresponding to the data processing request, and add the data identifier code to the initial SQL statement to obtain the target SQL statement;

[0011] The target SQL statement is sent to the data storage device where the target database is located; the data storage device executes the target SQL statement, and during the execution of the target SQL statement, the target data corresponding to the data identifier code in the target database is processed according to the data processing request;

[0012] Receive the data processing result returned by the data storage device.

[0013] Optionally, the step of obtaining the initial SQL statement corresponding to the data processing request of the application platform, and adding the data identifier code to the initial SQL statement to obtain the target SQL statement includes:

[0014] The initial SQL statement corresponding to the data processing request of the application platform is obtained based on the Mybatis-Plus interceptor;

[0015] When the Mybatis-Plus interceptor determines that the data processing object corresponding to the initial SQL statement includes the application platform's private data, the data identifier is added to the initial SQL statement to obtain the target SQL statement.

[0016] Optionally, the target data includes private data of the application platform and target public data from public data of different application platforms. The private data is data whose data structure includes the data identifier code, the public data is data whose data structure does not include the data identifier code, and the target public data is data in the public data that has an association relationship with the private data.

[0017] Optionally, before the step of receiving the data processing request from the application platform and extracting the platform identifier code from the data processing request, the method further includes:

[0018] When an access request is received from the application platform, the platform identifier code and the data identifier code are generated.

[0019] Establish a correspondence between the platform identifier code and the data identifier code; different application platforms have different correspondences.

[0020] Identify the private data of the application platform in the target database and add the data identifier code to the data structure of the private data. Add different data identifier codes to the private data corresponding to different application platforms.

[0021] The platform identifier code is sent to the application platform so that the application platform adds the platform identifier code to the data processing request it sends.

[0022] Optionally, after determining the private data of the application platform in the target database and adding the data identifier code to the data structure of the private data, the method further includes:

[0023] Identify the public data of different application platforms in the target database;

[0024] Identify the target public data related to the private data within the public data;

[0025] Establish the association between the target public data and the private data.

[0026] Optionally, the step of generating the data identifier code includes:

[0027] The platform identifier code is encoded according to a preset algorithm to obtain the data identifier code.

[0028] Furthermore, to achieve the above objectives, this application also proposes a data processing apparatus, the data processing apparatus comprising:

[0029] The request analysis module is used to receive data processing requests from the application platform and extract the platform identifier code from the data processing requests.

[0030] The execution module determines the data identifier code corresponding to the platform identifier code, processes the target data in the target database according to the data identifier code, and obtains the data processing result; wherein, the data identifier code is the identification information in the target database used to distinguish data from different application platforms;

[0031] The feedback module is used to send the data processing results to the application platform.

[0032] In addition, to achieve the above objectives, this application also proposes a server comprising: a memory, a processor, and a data processing program stored in the memory and executable on the processor, wherein the data processing program, when executed by the processor, implements the steps of the data processing method as described in any of the preceding claims.

[0033] In addition, to achieve the above objectives, this application also proposes a storage medium storing a data processing program, which, when executed by a processor, implements the steps of the data processing method as described in any of the preceding claims.

[0034] This invention proposes a data processing method applied to a server connected to more than one application platform. The method extracts the platform identifier code of each application platform from its data processing requests. Using this platform identifier code, a data identifier code is obtained from the target database to distinguish the application platform's data from other platforms. Based on this data identifier code, the method processes the data required by the application platform and returns the corresponding processing results to the application platform. This achieves data isolation between different platforms in the target database based on the data identifier code. The server does not need to allocate separate data storage space for different application platforms; data management for different application platforms can be achieved through the combined use of the platform identifier code and the data identifier code. Different application platforms can share a single storage space. This also reduces the server's data management process by minimizing the application, allocation, and scheduling of storage resources, thereby reducing storage resource waste and improving server data processing efficiency when managing data from multiple application platforms. Attached Figure Description

[0035] Figure 1 This is a schematic diagram of the connection of related devices in the data processing process of an embodiment of the server of the present invention;

[0036] Figure 2 This is a flowchart illustrating an embodiment of the data processing method of the present invention;

[0037] Figure 3 This is a flowchart illustrating another embodiment of the data processing method of the present invention;

[0038] Figure 4 This is a flowchart illustrating another embodiment of the data processing method of the present invention;

[0039] Figure 5 This is a schematic diagram of the functional modules of an embodiment of the data processing device of the present invention.

[0040] The realization of the objective, functional features and advantages of the present invention will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0041] It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

[0042] This invention provides a server 1. In this embodiment, server 1 is a cloud server. In other embodiments, server 1 may also be a server 1 connected to other application platforms 2 via wired communication.

[0043] In this embodiment, refer to Figure 1Server 1 is connected to more than one application platform 2, and application platform 2 includes application server 1 and the corresponding application managed by application server. In this embodiment, the server is connected to different application platforms 2 via network communication.

[0044] Terminals with applications installed can receive data processing instructions based on human-computer interaction. Server 1 will generate data processing requests according to the preset communication protocol between the application and server 1 and send them to server 1. Server 1 can process the data required by the user according to the received data processing requests.

[0045] Furthermore, refer to Figure 1 In this embodiment, server 1 can also be connected to data storage device 3, where a target database can be built to store data required by server 1 for different application platforms 2. In other embodiments, server 1 may also have built-in storage space for storing the target database.

[0046] In this embodiment of the invention, server 1 includes a processor (e.g., CPU), memory, timers, etc. The components in server 1 are connected via a communication bus. The memory can be high-speed RAM or stable, non-volatile memory, such as disk storage. Alternatively, the memory can be a storage device independent of the aforementioned processor.

[0047] Those skilled in the art will understand that the aforementioned device structure does not constitute a limitation on the device, and may include more or fewer of the aforementioned components, or a combination of certain components, or different arrangements of components.

[0048] The memory, as a storage medium, may include a data processing program. In server 1, the processor can be used to invoke the data processing program stored in the memory and execute the relevant steps of the data processing method in the following embodiments.

[0049] This invention also provides a data processing method applied to the aforementioned server.

[0050] Reference Figure 2 This application proposes an embodiment of a data processing method. In this embodiment, the data processing method includes:

[0051] Step S10: Receive the data processing request from the application platform and extract the platform identifier code of the application platform from the data processing request;

[0052] Specifically, a data processing request is generated by the application server in the application platform based on the data processing instructions received by the application and according to a preset communication protocol. The preset communication protocol is the data transmission protocol agreed upon between the application platform and the server when the application platform accesses the server.

[0053] The data objects processed by data processing requests include, but are not limited to, user data, equipment distribution network data, and equipment control data. Data processing requests may include data query requests, data modification requests, or data deletion requests. The data processing operation corresponding to the data processing request may be a pre-set fixed operation or a data operation determined according to the data processing instruction.

[0054] The platform identifier is a unique identifier used to distinguish a given application platform from other application platforms. Different application platforms correspond to different platform identifiers.

[0055] Specifically, the platform identifier can be stored in a preset data location within the data processing request. The platform identifier can be obtained by extracting data from this preset data location. In this embodiment, the preset data location is the protocol header. In other embodiments, the preset data location can also be the end of the data frame corresponding to the data processing request.

[0056] Step S20: Determine the data identifier code corresponding to the platform identifier code, and process the target data in the target database according to the data identifier code to obtain the data processing result; wherein, the data identifier code is the identifier information in the target database used to distinguish data from different application platforms;

[0057] In one implementation of this embodiment, the platform identifier code can be encoded using a preset algorithm to obtain the data identifier code. In another implementation of this embodiment, a mapping relationship (e.g., a mapping table) between the platform identifier code and the data identifier code can be pre-established, and the matching identifier code in the mapping relationship can be retrieved using the platform identifier code as the data identifier code.

[0058] The target database uses different data identifiers to identify data permitted by different application platforms. Specifically, the data structure of the data permitted by each application platform may store the corresponding data identifier. In this embodiment, the target database includes public data and private data, with different application platforms corresponding to different private data. Public data is data that all application platforms have access to, while private data is data that the corresponding application platform has access to, but other application platforms do not. In this embodiment, the data structure of public data does not store any data identifiers, while the data structure of private data stores the data identifiers of the corresponding application platforms. In other embodiments, the data structure of public data may store the data identifiers of all application platforms permitted to use the data, while the data structure of private data may store the data identifiers of the corresponding application platforms.

[0059] Specifically, target data can be extracted from the target database based on the data identifier code, and the target data can be processed according to the data processing operation corresponding to the data processing request to obtain the data processing result. For example, if the data processing request is a data query request, the target data retrieved from the target database based on the data identifier code can be used as the data processing result. Similarly, if the data processing request is a data deletion request, the target data retrieved from the target database based on the data identifier code can be used as the data processing result, and the execution result corresponding to the deletion operation of the target data can be used as the data processing result.

[0060] Step S30: Send the data processing result to the application platform.

[0061] This invention proposes a data processing method applied to a server connected to more than one application platform. The method extracts the platform identifier code of the application platform from its data processing requests. Using the platform identifier code, it obtains a data identifier code in the target database used to distinguish the application platform's data from other platforms. Based on the data identifier code, it processes the data required by the application platform and returns the corresponding processing results to the application platform. This achieves data isolation between different platforms in the target database based on the data identifier code. The server does not need to allocate separate data storage space for different application platforms; it can manage data from different application platforms by using the platform identifier code and the data identifier code together. Different application platforms can share a single storage space. This also reduces the server's data management process by requiring the application, allocation, and scheduling of storage resources, thereby reducing storage resource waste and improving the server's data processing efficiency when managing data from more than one application platform.

[0062] Furthermore, based on the above embodiments, another embodiment of the data processing method of this application is proposed. In this embodiment, reference is made to... Figure 3The step of processing the target data in the target database according to the data identifier code to obtain the data processing result includes:

[0063] Step S21: Obtain the initial SQL statement corresponding to the data processing request, and add the data identifier code to the initial SQL statement to obtain the target SQL statement;

[0064] SQL statements are a language for manipulating target databases.

[0065] The initial SQL statement is specifically generated based on the target data processing operation corresponding to the data processing request.

[0066] The initial SQL statement is concatenated with the data identifier to form the target SQL statement.

[0067] Step S22: Send the target SQL statement to the data storage device where the target database is located; the data storage device executes the target SQL statement, and during the execution of the target SQL statement, processes the target data corresponding to the data identifier code in the target database according to the data processing request;

[0068] The server can generate a corresponding data request based on the target SQL statement. After receiving the data request sent by the server, the data storage device can parse the target SQL statement from it. The data storage device executes the target SQL statement to process the data corresponding to the data identifier in the target database according to the data processing request. The processed data can be returned to the server.

[0069] The target data corresponding to the data identifier code may include data carrying the data identifier code and / or data associated with the data carrying the data identifier code.

[0070] Step S23: Receive the data returned by the data storage device as the data processing result.

[0071] Specifically, when the data processing request is a data query request, the data returned by the data storage device includes the target data. When the data processing request is a data deletion request, the data returned by the data storage device may include the execution result of the data operation corresponding to the target data (e.g., whether the execution was successful).

[0072] In this embodiment, by means of the above method, it can be ensured that when data is distributed and stored on data storage devices outside the server, the data storage devices can accurately process the data of the corresponding application platform according to the data processing requirements by sending the target SQL statement, thereby reducing the waste of storage resources, improving the data processing efficiency of the server, and improving the accuracy of the server in managing the application platform data.

[0073] Furthermore, in this embodiment, step S21 includes:

[0074] The initial SQL statement corresponding to the data processing request of the application platform is obtained based on the Mybatis-Plus interceptor;

[0075] When the Mybatis-Plus interceptor determines that the data processing object corresponding to the initial SQL statement includes the application platform's private data, the data identifier is added to the initial SQL statement to obtain the target SQL statement.

[0076] The server's system framework consists of a business layer and a lower layer. The business layer is specifically used for the interaction between the server and the application platform, while the lower layer is mainly used for data access according to the needs of the business layer. Mybatis-Plus interceptors are located in the lower layer.

[0077] In this embodiment, the Mybatis-Plus interceptor is used to assemble the target SQL statements required for application platform data processing at the system bottom layer. Data identification codes are added for data isolation only when processor private data is needed, instead of assembling directly at the business layer, which can effectively improve the server's data processing efficiency.

[0078] Furthermore, in this embodiment, the target data includes private data of the application platform and target public data in public data of different application platforms. The private data is data that includes the data identifier code in the data structure, the public data is data that does not include the data identifier code in the data structure, and the target public data is data in the public data that has an association relationship with the private data.

[0079] Public data refers to data that is permitted to be used by all application platforms. Specifically, relationships can be established between private data of an application platform and corresponding target public data based on field associations.

[0080] Based on this, it is possible to determine whether public data is the target public data by identifying whether it contains characteristic fields corresponding to private data.

[0081] In this embodiment, public data does not need to be assigned a data identifier, which helps to further save data storage resources. The public data involved in data processing is determined based on the relationship between private data and target public data. This allows for the analysis and processing of global data in the target database based on the data identifier. The processing of all data structures can be linked to the data identifier, ensuring that all the data required for data processing can be obtained based on the data identifier. This reduces data storage resources while further improving data processing efficiency.

[0082] Furthermore, based on any of the above embodiments, another embodiment of the data processing method of this application is proposed.

[0083] In this embodiment, refer to Figure 4 Before step S10, the procedure further includes:

[0084] Step S01: When an access request from the application platform is received, the platform identifier code and the data identifier code are generated.

[0085] Specifically, a platform identifier code can be generated based on the application identifier of the application in the application platform, or it can be generated based on the brand identifier of the brand to which the application platform belongs.

[0086] In this embodiment, the data identifier code is generated based on the platform identifier code. Specifically, the platform identifier code is encoded according to a preset algorithm to obtain the data identifier code, thereby improving the accuracy of the association between the data identifier code and the platform identifier code.

[0087] In other embodiments, one of the multiple preset identifier codes may be selected as the data identifier code; or, the data identifier code may be generated based on the time of receiving the access request from the application platform.

[0088] Step S02: Establish the correspondence between the platform identifier code and the data identifier code;

[0089] Different application platforms have different correspondences. Different application platforms have different platform identifiers and corresponding data identifiers.

[0090] Specifically, the platform identifier code and the data identifier code are associated and stored in a preset mapping table. In step S20, the data identifier code can be obtained by querying the preset mapping table using the platform identifier code.

[0091] Step S03: Determine the private data of the application platform in the target database and add the data identifier code to the data structure of the private data. Different data identifier codes are added to the private data corresponding to different application platforms.

[0092] Different application platforms have different private data in the target database, so different data identifier codes are added to the corresponding private data.

[0093] For example, if the private data of the first application platform in the target database is called the first data, and the private data of the second application platform in the target database is called the second data, and the data identifier code corresponding to the platform identifier code of the first application platform is called the first identifier code, and the data identifier code corresponding to the platform identifier code of the second application platform is called the second identifier code, then the first identifier code is added to the data structure of the first data, and the second identifier code is added to the data structure of the second data.

[0094] Step S04: Send the platform identifier code to the application platform so that the application platform adds the platform identifier code to the data processing request it sends.

[0095] In this embodiment, when the application platform accesses the server using the above method, there is no need to apply for, allocate, or schedule storage resources. It only needs to isolate the private data in the target database based on the data identifier code and return the platform identifier code to the application platform. This enables precise management of the application platform's data based on the combination of the platform identifier code and the data identifier code. It will not affect the data of other platforms or leak the data of any application platform. This reduces the waste of storage resources when the server manages data from more than one application platform and improves the server's data processing efficiency and data security.

[0096] Furthermore, in this embodiment, after the step of determining the private data of the application platform in the target database and adding the data identifier code to the data structure of the private data, the method further includes: determining the public data of different application platforms in the target database; determining the target public data related to the private data in the public data; and establishing the association between the target public data and the private data.

[0097] Specifically, relevant data in the public data can be identified as target public data based on the type of private data, the purpose of the private data, and the business logic of the private data.

[0098] Specifically, an association relationship between the target public data and the private data is established based on the fields in the target public data and the private data.

[0099] In this embodiment, the above method eliminates the need to set data identifiers for public data, which helps to further save data storage resources. The public data involved in data processing is determined based on the relationship between private data and target public data. This allows for the analysis and processing of global data in the target database based on data identifiers. The processing of all data structures can be linked to the data identifiers, ensuring that all the data required for data processing can be obtained based on the data identifiers. This reduces data storage resources while further improving data processing efficiency.

[0100] The present invention also proposes a data processing apparatus, referring to... Figure 5 The data processing device includes:

[0101] Request analysis module 100 is used to receive data processing requests from the application platform and extract the platform identifier code from the data processing requests;

[0102] The execution module 200 determines the data identifier code corresponding to the platform identifier code, processes the target data in the target database according to the data identifier code, and obtains the data processing result; wherein, the data identifier code is the identification information in the target database used to distinguish data from different application platforms;

[0103] Feedback module 300 is used to send the data processing results to the application platform.

[0104] Since the data processing device in this embodiment adopts all the technical solutions of all the above embodiments, it has at least all the beneficial effects brought about by the technical solutions of the above embodiments, and will not be described in detail here.

[0105] Furthermore, embodiments of the present invention also propose a storage medium storing a data processing program, wherein when the data processing program is executed by a processor, it implements the relevant steps of any of the above-described data processing methods.

[0106] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or system. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or system that includes that element.

[0107] The sequence numbers of the above embodiments of the present invention are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.

[0108] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) as described above, and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, or network device, etc.) to execute the methods described in the various embodiments of the present invention.

[0109] The above are merely preferred embodiments of the present invention and do not limit the scope of the patent. Any equivalent structural or procedural transformations made based on the description and drawings of the present invention, or direct or indirect applications in other related technical fields, are similarly included within the scope of patent protection of the present invention.

Claims

1. A data processing method applied to a server, characterized in that, The server is connected to more than one application platform, and the data processing method includes the following steps: Receive a data processing request from the application platform and extract the platform identifier code of the application platform from the data processing request; The data identifier corresponding to the platform identifier is determined, and the target data in the target database is processed according to the data identifier to obtain the data processing result; wherein, the data identifier is the identification information used in the target database to distinguish data from different application platforms, the target database includes public data and private data corresponding to different application platforms, and the public data is data that all application platforms have access to; The data processing result is sent to the application platform; The target data includes private data of the application platform and target public data in public data of different application platforms. The private data is data whose data structure includes the data identifier code, and the public data is data whose data structure does not include the data identifier code. The target public data is data in the public data that has a relationship with the private data. The relationship is based on the association between the target public data and the fields in the private data. Before the relationship is established, the relevant data in the public data is determined as the target public data according to the type of the private data, the purpose of the private data, and the business logic of the private data. The server's system framework includes a business layer and a lower layer. The business layer is used for interaction between the server and the application platform, while the lower layer is used for data access according to the needs of the business layer. (Mybatis) The Plus interceptor is located at the underlying layer. The step of processing target data in the target database according to the data identifier code and obtaining the data processing result includes: Based on Mybatis The Plus interceptor obtains the initial SQL statement corresponding to the data processing request of the application platform. Based on Mybatis When the Plus interceptor determines that the data processing object corresponding to the initial SQL statement includes the private data of the application platform, it adds the data identifier code to the initial SQL statement to obtain the target SQL statement. The target SQL statement is sent to the data storage device where the target database is located; the data storage device executes the target SQL statement, and during the execution of the target SQL statement, the target data corresponding to the data identifier code in the target database is processed according to the data processing request; Receive the data processing result returned by the data storage device.

2. The data processing method as described in claim 1, characterized in that, Before the step of receiving the data processing request from the application platform and extracting the platform identifier code of the application platform from the data processing request, the method further includes: When an access request is received from the application platform, the platform identifier code and the data identifier code are generated. Establish a correspondence between the platform identifier code and the data identifier code; different application platforms have different correspondences. Identify the private data of the application platform in the target database and add the data identifier code to the data structure of the private data. Add different data identifier codes to the private data corresponding to different application platforms. The platform identifier code is sent to the application platform so that the application platform adds the platform identifier code to the data processing request it sends.

3. The data processing method as described in claim 2, characterized in that, After the step of determining the private data of the application platform in the target database and adding the data identifier code to the data structure of the private data, the method further includes: Identify the public data of different application platforms in the target database; Based on the type of the private data, the purpose of the private data, and the business logic of the private data, determine the target public data related to the private data in the public data; Establish the association between the target public data and the private data.

4. The data processing method as described in claim 2, characterized in that, The step of generating the data identifier code includes: The platform identifier code is encoded according to a preset algorithm to obtain the data identifier code.

5. A data processing apparatus, applied to a server, characterized in that, The server is connected to more than one application platform, and the data processing device includes: The request analysis module is used to receive data processing requests from the application platform and extract the platform identifier code from the data processing requests. The execution module determines the data identifier code corresponding to the platform identifier code, processes the target data in the target database according to the data identifier code, and obtains the data processing result; wherein, the data identifier code is the identification information used in the target database to distinguish data from different application platforms, the target database includes public data and private data corresponding to different application platforms, and the public data is data that all application platforms have access to; The feedback module is used to send the data processing results to the application platform; The target data includes private data of the application platform and target public data in public data of different application platforms. The private data is data whose data structure includes the data identifier code, and the public data is data whose data structure does not include the data identifier code. The target public data is data in the public data that has a relationship with the private data. The relationship is based on the association between the target public data and the fields in the private data. Before the relationship is established, the relevant data in the public data is determined as the target public data according to the type of the private data, the purpose of the private data, and the business logic of the private data. The server's system framework includes a business layer and a lower layer. The business layer is used for interaction between the server and the application platform, while the lower layer is used for data access according to the needs of the business layer. (Mybatis) The Plus interceptor is located at the underlying layer, and the execution module is also used for: Based on Mybatis The Plus interceptor obtains the initial SQL statement corresponding to the data processing request of the application platform. Based on Mybatis When the Plus interceptor determines that the data processing object corresponding to the initial SQL statement includes the private data of the application platform, it adds the data identifier code to the initial SQL statement to obtain the target SQL statement. The target SQL statement is sent to the data storage device where the target database is located; the data storage device executes the target SQL statement, and during the execution of the target SQL statement, the target data corresponding to the data identifier code in the target database is processed according to the data processing request; Receive the data processing result returned by the data storage device.

6. A server, characterized in that, The server includes: a memory, a processor, and a data processing program stored in the memory and executable on the processor, wherein the data processing program, when executed by the processor, implements the steps of the data processing method as described in any one of claims 1 to 4.

7. A storage medium, characterized in that, The storage medium stores a data processing program, which, when executed by a processor, implements the steps of the data processing method as described in any one of claims 1 to 4.

Citation Information

Patent Citations

  • Information processing method and device and storage medium

    CN111984712A

  • Multi-tenant database management and control method and system and storage medium

    CN113535723A