Data processing method, device, server and system and computer storage medium
By using the SDK to generate and execute SQL in the business server to delete the data associated with the user's logout request, the problem of data isolation and security in the prior art is solved, and timely deletion and secure isolation of data after user logout is realized.
Patent Information
- Application Number
- CN202311478402.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-11-07
- Publication Date
- 2025-05-09
AI Technical Summary
In the prior art, when handling user cancellation, program vulnerabilities are prone to occur or business failures, resulting in data isolation and security not being guaranteed.
Receive user logout requests through the Software Development Toolkit (SDK) in the business server, generate a structured query language (SQL) and send it to the data server, and execute SQL to delete user data associated with the user ID.
It realizes timely deletion of data after user logout, ensures data isolation and security, and avoids program vulnerabilities and issues that are not considered by the business.
Smart Images

Figure CN119961278A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a data processing method, device, server, system and computer storage medium. Background Art
[0002] When a system user logs out, the business system generally needs to process the user, which mainly involves two aspects: limiting the logged-out user's access rights and protecting the logged-out user's data security.
[0003] However, when processing business data, related technologies are prone to program loopholes or business considerations, making data isolation and security not guaranteed. Summary of the invention
[0004] The embodiments of the present application provide a data processing method, device, server, system and computer storage medium, which can limit user access and protect data security.
[0005] In a first aspect, an embodiment of the present application provides a data processing method, which is applied to a business server, wherein the business server includes a software development kit SDK, and the method includes:
[0006] Receive a user logout request and generate a structured query language SQL through the SDK, wherein the user logout request includes a user identity ID;
[0007] The SQL is sent to a data server so that the data server executes the SQL and deletes the user data associated with the user ID.
[0008] In a second aspect, an embodiment of the present application provides a data processing device, which is applied to a business server, wherein the business server includes a software development kit SDK, and the device includes:
[0009] A first receiving module is used to receive a user logout request and generate a structured query language SQL through the SDK, wherein the user logout request includes a user identity ID;
[0010] The sending module is used to send the SQL to the data server so that the data server executes the SQL and deletes the user data associated with the user ID.
[0011] In a third aspect, an embodiment of the present application provides a business server, the business server includes a software development kit SDK, and the business server also includes:
[0012] A memory for storing executable program codes;
[0013] The processor is used to call and run the executable program code from the memory, so that the business server executes the method steps provided in the first aspect of the embodiment of the present application.
[0014] In a fourth aspect, an embodiment of the present application provides a data processing method, which is applied to a data server, and the method includes:
[0015] Receiving a structured query language SQL sent by a business server, wherein the SQL is an SQL generated by the business server through a software development kit SDK after receiving a user logout request, wherein the user logout request includes a user identity ID;
[0016] Execute the SQL to delete the user data associated with the user ID.
[0017] In a fifth aspect, an embodiment of the present application provides a data processing device, which is applied to a data server, and includes:
[0018] A second receiving module is used to receive a structured query language SQL sent by a business server, wherein the SQL is an SQL generated by the business server through a software development kit SDK after receiving a user logout request, wherein the user logout request includes a user identity ID;
[0019] The second execution module is used to execute the SQL to delete the user data associated with the user ID.
[0020] In a sixth aspect, an embodiment of the present application provides a data server, the data server comprising:
[0021] A memory for storing executable program codes;
[0022] The processor is used to call and run the executable program code from the memory, so that the data server executes the method steps provided in the fourth aspect of the embodiment of the present application.
[0023] In the seventh aspect, an embodiment of the present application provides a data processing system, including a business server and a data server, the business server being the business server provided in the third aspect of the embodiment of the present application, and the data server being the data server provided in the sixth aspect of the embodiment of the present application.
[0024] In an eighth aspect, an embodiment of the present application provides a computer storage medium, wherein the computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the method steps provided in the first and fourth aspects of the embodiments of the present application.
[0025] The beneficial effects brought about by the technical solutions provided by some embodiments of the present application include at least:
[0026] In the technical solution provided by the embodiment of the present application, the business server receives a user deregistration request containing a user identity ID, generates a structured query language SQL through the SDK, and sends the SQL to the data server. After receiving the structured query language SQL sent by the business server, the data server queries the user data associated with the user ID carried by the SQL, and deletes the user data associated with the user ID. After receiving the deregistration request, the encapsulated SDK can be used to directly generate SQL to delete the user data associated with the deregistration request, that is, all user data related to the user will be deleted along with the deregistration of the user account. After the user account is deregistered, the user data can no longer be accessed, thereby achieving data isolation and ensuring data security. In addition, by processing user deregistration data in the form of SDK, after different business parties receive the user deregistration event, the user data can be processed in a unified manner, so that the rules can be unified and specifications can be formed. BRIEF DESCRIPTION OF THE DRAWINGS
[0027] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For those skilled in the art, other drawings can be obtained based on these drawings without paying any creative work.
[0028] Figure 1 is an exemplary system architecture diagram of a data processing system provided in an embodiment of the present application;
[0029] Figure 2 It is a software structure diagram of a business server provided in an embodiment of the present application;
[0030] Figure 3 It is a flowchart of a data processing method provided in an embodiment of the present application;
[0031] Figure 4 It is a flowchart of another data processing method provided in an embodiment of the present application;
[0032] Figure 5 It is a flowchart of another data processing method provided in an embodiment of the present application;
[0033] Figure 6 A schematic diagram of a business service user cancellation compensation processing provided in an embodiment of the present application;
[0034] Figure 7 A schematic diagram of a database table model provided in an embodiment of the present application;
[0035] Figure 8is a structural schematic diagram of a data processing device provided in an embodiment of the present application;
[0036] Fig. 9 is a structural schematic diagram of another data processing device provided in an embodiment of the present application;
[0037] Fig.10 It is a structural diagram of a business server provided in an embodiment of the present application;
[0038] Fig.11 It is a structural diagram of a data server provided in an embodiment of the present application. DETAILED DESCRIPTION
[0039] In order to make the features and advantages of the present application more obvious and easy to understand, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present application.
[0040] When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Instead, they are only examples of devices and methods consistent with some aspects of the present application as detailed in the attached claims.
[0041] When a system user logs out, the business system generally needs to process the user, which mainly involves two aspects: limiting the logged-out user's access rights and protecting the logged-out user's data security.
[0042] However, when processing business data, related technologies are prone to program loopholes or business considerations, making data isolation and security not guaranteed.
[0043] Therefore, the embodiment of the present application provides a data processing method including a business server of a software development kit (SDK) receiving a user deregistration request, and generating a structured query language (SQL) through the SDK, wherein the user deregistration request includes a user identity ID; the SQL is sent to a data server, and the data server executes the SQL to delete the user data associated with the user ID. In this way, the user data associated with the deregistration request can be deleted, that is, the user data related to the user will be deleted along with the deregistration of the user account, and the user data can no longer be accessed after the user account is deregistered, thereby realizing data isolation and ensuring data security.
[0044] See also Figure 1 , Figure 1 This is an exemplary architecture diagram of a data processing system provided in an embodiment of the present application. Figure 1 As shown, the system architecture may include a business server 110, a data server 120, a user terminal 130 and a network 140. Among them:
[0045] like Figure 1 As shown, the system architecture may include a service server 110, a data server 120, and a user terminal 130. The service server 110 communicates with the data server 120 and the user terminal 130 via a network 140. The network 140 may include various types of wired communication links or wireless communication links, for example, the wired communication link includes an optical fiber, a twisted pair, or a coaxial cable, and the wireless communication link includes a Bluetooth communication link, a Wireless-Fidelity (Wi-Fi) communication link, or a microwave communication link.
[0046] The user can access the service server 110 through the user account logged in the user terminal 130. The service server 110 can provide various service services for the user. The user data generated when the user interacts with the service server 110 through the user terminal 130 can be stored in the data server 120.
[0047] The user terminal 130 can interact with the business server 110 through the network 140 to receive messages from the business server 110 or send messages to the business server 110. Or the user terminal 130 can interact with the business server 110 through the network 140, and then receive messages or data sent by other users to the business server 110. The user terminal 130 can be hardware or software. When the user terminal 130 is hardware, it can be various electronic devices, including but not limited to smart watches, smart phones, tablet computers, laptop portable computers and desktop computers. When the user terminal 130 is software, it can be installed in the electronic devices listed above, which can be implemented as multiple software or software modules (for example: used to provide distributed services), or it can be implemented as a single software or software module, which is not specifically limited here.
[0048] The business server 110 can interact with the data server 120 through the network 140. Specifically, the business server 110 can access the data stored in the data server 120 through the network 140. In some possible embodiments, the data server 120 can also be integrated with the business server 110, which is not limited in the embodiments of the present application. The subsequent embodiments of the present application are described by taking the business server 110 and the data server 120 as an example.
[0049] The above-mentioned business server 110 and data server 120 can be separate server devices, such as: rack-mounted, blade, tower, or cabinet-type server devices, or workstations, mainframe computers and other hardware devices with strong computing capabilities; it can also be a server cluster composed of multiple servers, and the servers in the service cluster can be composed in a symmetrical manner, wherein each server has equivalent functions and status in the business link, and each server can provide services to the outside independently, and the independent service can be understood as not requiring the assistance of other servers.
[0050] Exemplarily, a shopping software is installed in the user terminal 130. The user can register a user account through the shopping software installed in the user terminal 130. The business server 110 is a server corresponding to the shopping software, and can provide users with various business services, such as product search, product purchase, order submission, shopping settlement and other services. The user can interact with the business server 110 through the shopping software installed in the user terminal 130, and the user data generated during the interaction process can be saved in the data server 120. For example, the user's personal information, account number, password and other data generated when registering a user account, and the product information added to the shopping cart, and the historical order data.
[0051] It should be understood that Figure 1 The number of user terminals, service servers and data servers in the figure is only illustrative, and any number of terminals and servers may be used according to implementation requirements.
[0052] Figure 2 The following is an exemplary diagram showing a software structure diagram corresponding to a service server 110 provided in an embodiment of the present application. Figure 2 As shown, the business server 110 may include the following parts: user center, message center and subsystem.
[0053] The User Center is used for unified management of platform users, involving unified registration, login, logout, account information management, etc.
[0054] The message center is an implementation of decoupling the user center from the subsystem. It can be a separate system or a middleware. It can be used to receive user events published by the user center and notify the subsystem of related user events.
[0055] The subsystem is a business subsystem that can provide business services to users and generate business-related user data, which will be stored in the data server. The subsystem can also be used to check whether the user information in the user center is legal and normal.
[0056] In the embodiment of the present application, the subsystem may include a logout-related SDK, which is mainly used to monitor user events in the message center and process user logout data after monitoring the user logout event, without intruding on the overall business of the subsystem.
[0057] In a specific implementation, when the message center receives a user logout event published by the user center, the user logout event can be sent to the subsystem, or the subsystem can monitor the message center in real time. After the SDK in the subsystem monitors the user logout event, the SDK in the subsystem can query the list corresponding to the user ID in the data server, generate SQL based on the list and send it to the data server, delete the user data corresponding to the user ID in the list corresponding to the user ID in the data server, so that the user data can no longer be accessed, thereby ensuring the data security of the logged-out user.
[0058] Next, combine Figure 1 The data processing system architecture diagram shown and Figure 2 The software architecture diagram of the business server shown is used to introduce the data processing method provided in the embodiment of the present application. Figure 3 The following is a flow chart showing a data processing method provided by an embodiment of the present application. Figure 3 As shown, the data processing method may include the following steps:
[0059] S201: The service server receives a user logout request.
[0060] Specifically, the user logout request is sent by the user to the service server through the user terminal. The user logout request includes a user ID. The user ID can be used to uniquely identify a user, ensuring that the identities of different users can be accurately identified and distinguished. And through the user identification ID, specific data can be associated with the corresponding user, which facilitates data management and query.
[0061] Exemplarily, a user may input a user deregistration request through a shopping app installed on a user terminal. The user deregistration request includes the user account registered by the user in the shopping app, that is, the user ID. Then, the user terminal may send the user deregistration request to the service server through the network. Specifically, the user deregistration request may be sent to the user center. After receiving the user deregistration request, the user center may publish a user deregistration event to the message center.
[0062] S202: The business server generates structured query language SQL through the SDK.
[0063] Specifically, the developer can encapsulate the user logout logic into an SDK in advance. The business server can include the SDK. When the business server receives the user logout request, it can generate logout-related SQL through the SDK.
[0064] It can be known that SDK is generally a collection of development tools for software engineers to build application software for specific software packages, software frameworks, hardware platforms, operating systems, etc. SQL is a database query and programming language used to access data and query, update and manage relational database systems. It is also the extension of database script files. Specifically, the data server can store user data of all users registered in the APP corresponding to the business server. Each user data can carry its corresponding user ID. Exemplarily, user data can be stored in the data server in the form of a list. Taking the examination system as an example, the lists that can be stored in the data server are: t_user user table, t_user_exam_record examination record table, t_user_exam_record_detail examination record details table, t_exam test paper table, t_exam_question question table.
[0065] Specifically, the SDK may query the list corresponding to the user ID in the data server and generate SQL based on the list.
[0066] For example, the SDK can query the data server to obtain the list corresponding to the user ID, including the t_user_exam_record exam record table and the t_user_exam_record_detail exam record details table. Then, the SQL generated based on the query result is as follows:
[0067] update t_user_exam_record set userUid='user1234_DEL' where userUid='user1234';
[0068] update t_user_exam_record_detail set userUid='user1234_DEL'whereuserUid='user1234'.
[0069] S203: The business server sends the SQL to the data server.
[0070] Specifically, the business server may send the SQL to the data server through the network.
[0071] S204: The data server executes SQL to delete the user data associated with the user ID.
[0072] Specifically, after receiving the above SQL, the data server may execute the SQL to delete the user data associated with the user ID.
[0073] In a specific implementation, combining Figure 2 ,like Figure 4 As shown, the message center sends a user logout notification to the SDK. After receiving the user logout notification, the SDK can call the user center through the interface to detect whether to start the user logout process. If not, it generates the user logout SQL and sends the user logout SQL to the data server, so that the data server executes the user logout SQL and deletes the user data.
[0074] The embodiment of the present application provides a data processing method, including a business server of SDK receiving a user deregistration request including a user identity identification ID, generating SQL through SDK and sending SQL to a data server through the network, the data server receiving the structured query language SQL sent by the business server and querying the user data associated with the user ID carried by the above SQL and deleting the user data, after receiving the deregistration request, SQL can be directly generated through the encapsulated SDK to delete the user data associated with the deregistration request, that is, the user data related to the user will be deleted along with the deregistration of the user account, and the user data can no longer be accessed after the user account is deregistered, so as to achieve data isolation and ensure data security. In addition, by processing user deregistration data in the form of SDK, after different business parties receive the user deregistration event, the user data can be processed in a unified manner, so that the rules can be unified and specifications can be formed.
[0075] When canceling a user account, all business data related to the user needs to be considered. In order to avoid not considering the business related to the user when canceling the user account, resulting in the business data related to the user being retained after the user is logged out, so that the user's data security is not guaranteed. Therefore, the embodiment of the present application also proposes another data processing method, which can perform compensation processing after executing the above S204. Figure 5 As shown:
[0076] S301-S304: The same as S201-S204, and will not be repeated here.
[0077] S305: The business server obtains a cancellation compensation processing instruction.
[0078] Optionally, the service server receives a query instruction carrying the user ID sent by the user terminal.
[0079] For example, take a shopping software in a user terminal as an example. After the user terminal sends a user logout instruction to the service server, if the user wants to view the shopping cart, he clicks the shopping cart control in the shopping software. At this time, the user's operation of clicking the shopping cart control can be regarded as sending a query instruction carrying the user ID to the service server. The query instruction can be regarded as a logout compensation processing instruction.
[0080] Optionally, the business server includes a subsystem, and the subsystem calls the hook function to send a cancellation compensation processing instruction to the SDK. It can be known that there will be some interfaces inside the SDK, and the subsystem can customize the above hook function based on these interfaces, so that the subsystem can call the hook overview to send a cancellation compensation processing instruction to the SDK.
[0081] S306: The service server responds to the cancellation compensation processing instruction and determines whether the user ID has been cancelled.
[0082] Specifically, the service server responds to the query instruction carrying the user ID to determine whether the user ID has been deregistered. If so, the process ends; if not, the process proceeds to step S308.
[0083] Specifically, the SDK can call the user center through the interface to check whether the user ID has been deregistered. For example, the user center can check whether the user ID still exists. If it still exists, it can be determined that the user ID has not been deregistered. At this time, deregistration compensation processing is required.
[0084] S307: The business server generates structured query language SQL through the SDK.
[0085] S308: The business server sends the SQL to the data server.
[0086] Specifically, S308 is consistent with S203 and will not be described in detail here.
[0087] S309: The data server executes SQL to delete the user data associated with the user ID.
[0088] Specifically, S309 is consistent with S204 and will not be described in detail here.
[0089] In a specific implementation, combining Figure 2 ,like Figure 6 As shown, the subsystem can send a cancellation compensation processing instruction to the SDK. After receiving the compensation processing instruction, the SDK can call the user center through the interface to detect whether the user has been cancelled. If not, the user center is called through the interface to detect whether to start the user cancellation process. If not, the SQL for user cancellation is generated and sent to the data server, so that the data server executes the SQL for user cancellation and deletes the user data.
[0090] The data processing method provided in the embodiment of the present application receives a user deregistration request including a user identity identification ID through a business server including an SDK, generates SQL through the SDK and sends the SQL to a data server through the network, and the data server receives the structured query language SQL sent by the business server and then queries the user data associated with the user ID carried by the above SQL and deletes the user data. After receiving the deregistration request, SQL can be directly generated through the encapsulated SDK to delete the user data associated with the deregistration request, that is, the user data related to the user will be deleted along with the deregistration of the user account, and the user data can no longer be accessed after the user account is deregistered, thereby achieving data isolation and ensuring data security. In addition, by processing the user deregistration data in the form of SDK, after different business parties receive the user deregistration event, the user data can be processed in a unified manner, so that the rules can be unified and norms can be formed. In addition, the deregistration compensation processing instruction can be obtained and responded to to determine whether the user ID has been deregistered. If the user ID has been deregistered, no subsequent operations will be performed. If the user ID has not been cancelled, the above steps of generating structured query language SQL through SDK are executed again. This allows the user to check whether the user has been cancelled after the cancellation is completed. This can avoid program loopholes or business considerations that may result in user data not being cancelled after the user has been cancelled, thereby further ensuring the user's data security.
[0091] For example, taking the online examination system as an example, student A registered an account on the examination system, the account is user1234, and took several examinations, and there are corresponding examination records. Figure 7 As shown, Figure 7 Including t_user user table, t_user_exam_record examination record table, t_user_exam_record_detail examination record details table, t_exam examination paper table, and t_exam_question question table.
[0092] Student A initiates a request to cancel his account through the user terminal. After receiving the user cancellation request from user A, the SDK can parse the request to obtain the user ID: user1234. Based on the user ID: user1234 carried in the user cancellation request, SKD queries the table corresponding to the user ID in the data server, including the t_user_exam_record exam record table and the t_user_exam_record_detail exam record detail table. Then, the SQL generated based on the query result is as follows:
[0093] update t_user_exam_record set userUid='user1234_DEL' where userUid='user1234';
[0094] update t_user_exam_record_detail set userUid='user1234_DEL'whereuserUid='user1234'.
[0095] Then, the SDK can send the SQL to the data server. After receiving the SQL, the data server executes the SQL to update (that is, delete) the data corresponding to the set userUid of user1234 in the t_user_exam_record list, and to update (that is, delete) the data corresponding to the set userUid of user1234 in the t_user_exam_record_detail list. At this point, the deletion of the user data in the two lists is completed.
[0096] Figure 8 A structural diagram of a data processing device provided in an embodiment of the present application is exemplified.
[0097] like Figure 8 As shown, the data processing device 80 includes: a first receiving module 810 and a sending module 820. Among them:
[0098] The first receiving module 810 is used to receive a user logout request and generate a structured query language SQL through the SDK. The user logout request includes a user identity ID.
[0099] The sending module 820 is used to send the SQL to the data server, so that the data server executes the SQL and deletes the user data associated with the user ID.
[0100] In some possible embodiments, the data processing device 80 further includes:
[0101] An acquisition module is used to acquire a cancellation compensation processing instruction;
[0102] A determination module, configured to determine whether the user ID has been deregistered in response to the deregistration compensation processing instruction;
[0103] The first execution module is used to execute again the step of generating structured query language SQL through the SDK when the user ID is not cancelled.
[0104] In some possible embodiments, the acquisition module is specifically used to receive a query instruction carrying the user ID sent by a user terminal;
[0105] The judgment module is specifically used to judge whether the user ID has been cancelled in response to the query instruction carrying the user ID.
[0106] In some possible embodiments, the business server includes a subsystem;
[0107] The acquisition module is specifically used to send a cancellation compensation processing instruction to the SDK by calling the hook function through the above subsystem.
[0108] In some possible embodiments, the first receiving module 810 includes:
[0109] A receiving unit, used for receiving a user logout request;
[0110] A query unit, used to query a list corresponding to the user identity ID from a data server through the SDK;
[0111] A generating unit is used to generate SQL based on the list corresponding to the user ID.
[0112] Fig. 9 The structural diagram of another data processing device provided by the embodiment of the present application is exemplarily shown. Fig. 9 As shown, the data processing device 90 includes: a second receiving module 910 and a second execution module 920 .
[0113] in:
[0114] The second receiving module 910 is used to receive a structured query language SQL sent by a business server, where the SQL is generated by the business server through a software development kit SDK after receiving a user logout request, where the user logout request includes a user identity ID;
[0115] The execution module 920 is used to execute the SQL to delete the user data associated with the user ID.
[0116] Fig.10 It is a structural diagram of a business server provided in an embodiment of the present application.
[0117] For example, Fig.10 As shown, the business server 1000 includes: a memory 1010 and a processor 1020, wherein the memory 1010 stores an executable program code 1030, and the processor 1020 is used to call and execute the executable program code 1030 to perform:
[0118] Receive a user logout request and generate a structured query language SQL through the SDK, wherein the user logout request includes a user identity ID;
[0119] The SQL is sent to a data server so that the data server executes the SQL and deletes the user data associated with the user ID.
[0120] In some possible embodiments, after executing and sending the SQL to the data server, the processor 1020 is further configured to execute:
[0121] Get cancellation compensation processing instructions;
[0122] In response to the cancellation compensation processing instruction, determining whether the user ID has been cancelled;
[0123] In the case where the user ID is not cancelled, the step of generating the structured query language SQL through the SDK is performed again.
[0124] In some possible embodiments, when the processor 1020 executes the instruction to obtain the cancellation compensation processing instruction, it is specifically used to execute:
[0125] Receiving a query instruction carrying the user ID sent by a user terminal;
[0126] When the processor 1020 executes the instruction in response to the cancellation compensation processing instruction and determines whether the user ID has been cancelled, it is specifically configured to execute:
[0127] In response to the query instruction carrying the user ID, it is determined whether the user ID has been cancelled.
[0128] In some possible embodiments, the business server includes a subsystem;
[0129] When the processor 1020 executes the instruction to obtain the cancellation compensation processing, it is specifically used to execute:
[0130] The subsystem calls the hook function and sends a deregistration compensation processing instruction to the SDK.
[0131] In some possible embodiments, when the processor 1020 generates the structured query language SQL through the SDK, it is specifically used to execute:
[0132] Querying a list corresponding to the user identity ID from a data server through the SDK;
[0133] Generate SQL based on the list corresponding to the user ID.
[0134] Fig.11It is a structural diagram of a data server provided in an embodiment of the present application.
[0135] For example, Fig.11 As shown, the data server 1100 includes: a memory 1110 and a processor 1120, wherein the memory 1110 stores an executable program code 1130, and the processor 1120 is used to call and execute the executable program code 1130 to perform:
[0136] Receiving a structured query language SQL sent by a business server, wherein the SQL is an SQL generated by the business server through a software development kit SDK after receiving a user logout request, wherein the user logout request includes a user identity ID;
[0137] Execute the SQL to delete the user data associated with the user ID.
[0138] In this embodiment, the business server and the data server can be divided into functional modules according to the above method example. For example, each functional module can be corresponded, or two or more functions can be integrated into one processing module. The above integrated module can be implemented in the form of hardware. It should be noted that the division of modules in this embodiment is schematic and is only a logical function division. There may be other division methods in actual implementation.
[0139] In the case of dividing each functional module according to each function, the business server may include: a first receiving module and a sending module, etc., and the data server may include a second receiving module and a second execution module, etc. It should be noted that all relevant contents of each step involved in the above method embodiment can be referred to the functional description of the corresponding functional module, and will not be repeated here.
[0140] The business server and data server provided in this embodiment are used to execute the above-mentioned data processing method, and thus can achieve the same effect as the above-mentioned implementation method.
[0141] In the case of using an integrated unit, the business server and the data server may include a processing module and a storage module. The processing module may be used to control and manage the actions of the business server and the data server. The storage module may be used to support the business server and the data server to execute mutual program codes and data.
[0142] The processing module may be a processor or a controller, which may implement or execute various exemplary logic blocks, modules and circuits disclosed in the present application. The processor may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of digital signal processing (DSP) and a microprocessor, etc. The storage module may be a memory.
[0143] The embodiment of the present application also provides a computer-readable storage medium, in which instructions are stored. When the instructions are executed on a computer or a processor, the computer or the processor executes the above-mentioned Figure 3-Figure 7 One or more steps in the illustrated embodiment. If the various components of the above data processing device are implemented in the form of software functional units and sold or used as independent products, they can be stored in the above computer-readable storage medium.
[0144] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The above-mentioned computer program product includes one or more computer instructions. When the above-mentioned computer program instructions are loaded and executed on a computer, the above-mentioned process or function according to the embodiment of the present application is generated in whole or in part. The above-mentioned computer can be a general-purpose computer, a special-purpose computer, a computer network or other programmable devices. The above-mentioned computer instructions can be stored in a computer-readable storage medium or transmitted by the above-mentioned computer-readable storage medium. The above-mentioned computer instructions can be transmitted from a website site, a computer, a server or a data center to another website site, a computer, a server or a data center by wired (such as coaxial cable, optical fiber, digital subscriber line (Digital Subscriber Line, DSL)) or wireless (such as infrared, wireless, microwave, etc.) mode. The above-mentioned computer-readable storage medium can be any available medium that a computer can access or a data storage device such as a server, a data center, etc. that contains one or more available media integrated. The above-mentioned available media can be magnetic media (for example, floppy disks, hard disks, tapes), optical media (for example, digital versatile discs (DVD)), or semiconductor media (for example, solid state disks (SSD)), etc.
[0145] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the program can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. The aforementioned storage medium includes: various media that can store program codes, such as system memory (Read Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic disk or optical disk. In the absence of conflict, the technical features in this embodiment and the implementation scheme can be combined arbitrarily.
[0146] The embodiments described above are merely preferred embodiments of the present application and are not intended to limit the scope of the present application. Without departing from the design spirit of the present application, various modifications and improvements made to the technical solutions of the present application by ordinary technicians in this field should fall within the protection scope determined by the claims of the present application.
Claims
1. A data processing method, characterized in that: The method is applied to a business server, the business server includes a software development kit SDK, and the method includes: Receive a user logout request, and generate a structured query language SQL through the SDK, wherein the user logout request includes a user identity ID; The SQL is sent to a data server so that the data server executes the SQL and deletes the user data associated with the user ID.
2. The method according to claim 1, characterized in that After sending the SQL to the data server, the method further includes: Get cancellation compensation processing instructions; In response to the cancellation compensation processing instruction, determining whether the user ID has been cancelled; In the case where the user ID is not cancelled, the step of generating the structured query language SQL through the SDK is performed again.
3. The method according to claim 2, characterized in that The obtaining of the cancellation compensation processing instruction includes: Receiving a query instruction carrying the user ID sent by a user terminal; The step of determining, in response to the cancellation compensation processing instruction, whether the user ID has been cancelled includes: In response to the query instruction carrying the user ID, it is determined whether the user ID has been cancelled.
4. The method according to claim 2, characterized in that: The business server includes a subsystem; The obtaining of the cancellation compensation processing instruction includes: The subsystem calls the hook function and sends a deregistration compensation processing instruction to the SDK.
5. The method according to claim 1, characterized in that Generating structured query language SQL through the SDK includes: Querying a list corresponding to the user identity ID from a data server through the SDK; Generate SQL based on the list corresponding to the user ID.
6. A data processing method, characterized in that: The method is applied to a data server, and comprises: Receiving a structured query language SQL sent by a business server, wherein the SQL is an SQL generated by the business server through a software development kit SDK after receiving a user logout request, wherein the user logout request includes a user identity ID; Execute the SQL to delete the user data associated with the user ID.
7. A data processing device, characterized in that: The device is applied to a service server, the service server includes a software development kit SDK, and the device includes: A first receiving module is used to receive a user logout request and generate a structured query language SQL through the SDK, wherein the user logout request includes a user identity ID; The sending module is used to send the SQL to the data server so that the data server executes the SQL and deletes the user data associated with the user ID.
8. A data processing device, characterized in that: The device is applied to a data server, and comprises: A second receiving module is used to receive a structured query language SQL sent by a business server, wherein the SQL is an SQL generated by the business server through a software development kit SDK after receiving a user logout request, wherein the user logout request includes a user identity ID; The second execution module is used to execute the SQL to delete the user data associated with the user ID.
9. A business server, characterized in that: The service server includes a software development kit SDK, and the service server also includes: A memory for storing executable program codes; A processor, configured to call and run the executable program code from the memory, so that the service server executes the method according to any one of claims 1 to 5.
10. A data server, characterized in that: include: A memory for storing executable program codes; A processor, configured to call and run the executable program code from the memory, so that the data server executes the method according to claim 6.
11. A data processing system, characterized in that: It includes the business server described in claim 9 and the data server described in claim 10.
12. A computer storage medium storing a plurality of instructions, wherein the instructions are suitable for being loaded by a processor and executing the steps of the method according to any one of claims 1 to 5 or any one of claims 6.