WO2019024472A1 - 数据操作方法、装置及计算机可读存储介质 - Google Patents

数据操作方法、装置及计算机可读存储介质 Download PDF

Info

Publication number
WO2019024472A1
WO2019024472A1 PCT/CN2018/074614 CN2018074614W WO2019024472A1 WO 2019024472 A1 WO2019024472 A1 WO 2019024472A1 CN 2018074614 W CN2018074614 W CN 2018074614W WO 2019024472 A1 WO2019024472 A1 WO 2019024472A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
information
request
type
verification
Prior art date
Application number
PCT/CN2018/074614
Other languages
English (en)
French (fr)
Inventor
邵雷锋
谷峰
王红艳
杨东
Original Assignee
平安科技(深圳)有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2019024472A1 publication Critical patent/WO2019024472A1/zh

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/20Software design
    • G06F8/22Procedural
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/62Protecting access to data via a platform, e.g. using keys or access control rules

Definitions

  • the present application relates to the field of computer technologies, and in particular, to a data operation method, apparatus, and computer readable storage medium.
  • the database system is the most convenient and efficient way to store data and retrieve information.
  • database data manipulation services such as HBase based (Hadoop).
  • Database distributed open source database
  • a service-specific script program is used to implement the data manipulation service corresponding to the data operation request.
  • the main purpose of the present application is to provide a data operation method, apparatus, and computer readable storage medium, which are intended to solve the problem that the server performs a one-to-one script program customization process on the received data operation request, which causes the data operation service process to be complicated and complicated.
  • Technical problem is to provide a data operation method, apparatus, and computer readable storage medium, which are intended to solve the problem that the server performs a one-to-one script program customization process on the received data operation request, which causes the data operation service process to be complicated and complicated.
  • the present application provides a data operation method, and the data operation method includes the following steps:
  • the present application further provides a data query device, where the data query device includes:
  • a first acquiring module configured to acquire operation information corresponding to the operation request when receiving an operation request sent by the client
  • a verification module configured to perform verification operations on the obtained operation information
  • a second acquiring module configured to acquire an operation type corresponding to the operation information when the operation information is verified, and obtain a script program corresponding to the operation type in a preset database, where the operation information and the The type of operation is a many-to-one relationship;
  • a running module configured to run the script program based on the parameter information in the operation information, to perform a corresponding operation on the data to be processed corresponding to the operation request.
  • the present application further provides a data operating device, the data operating device comprising: a memory, a processor, and a data operating program stored on the memory and operable on the processor, The step of implementing the data manipulation method of any of the above described ones when the data manipulation program is executed by the processor.
  • the present application further provides a computer readable storage medium having a data operation program stored thereon, the data operation program being executed by a processor to implement any of the above The steps of the data manipulation method.
  • the application obtains the operation information corresponding to the operation request when receiving the operation request sent by the client, and then performs the verification operation on the obtained operation information, and then acquires the operation information when the operation information is verified.
  • the operation type corresponding to the operation information, and the script program corresponding to the operation type is obtained in the preset database, and then the script program is executed based on the parameter information in the operation information to request the corresponding pending data for the operation request.
  • Perform the corresponding operations so that the server can provide data operation services with simple configuration, no need to customize and develop different script programs for different operation requests, simplify the process of providing data operation services by the server, and ensure the security and reliability. Under the premise of data operation service, the server processing efficiency is improved.
  • FIG. 1 is a schematic structural diagram of a terminal to which a data operation device belongs in a hardware operating environment according to an embodiment of the present application;
  • FIG. 2 is a schematic flowchart diagram of a first embodiment of a data operation method according to the present application.
  • FIG. 1 is a schematic structural diagram of a terminal to which a data operation device belongs in a hardware operating environment according to an embodiment of the present application.
  • the terminal in this embodiment of the present application may be a PC.
  • the terminal may include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002.
  • the communication bus 1002 is used to implement connection communication between these components.
  • the user interface 1003 can include a display, an input unit such as a keyboard, and the optional user interface 1003 can also include a standard wired interface, a wireless interface.
  • the network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface).
  • the memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage.
  • the memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.
  • the terminal may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more.
  • sensors such as light sensors, motion sensors, and other sensors.
  • the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display according to the brightness of the ambient light, and the proximity sensor may turn off the display and/or when the mobile terminal moves to the ear. Backlighting.
  • the gravity acceleration sensor can detect the magnitude of acceleration in each direction (usually three axes), and can detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of the mobile terminal (such as horizontal and vertical screen switching, Related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. No longer.
  • terminal structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or a combination of certain components, or different component arrangements.
  • an operating system may be included in the memory 1005 as a computer storage medium.
  • a network communication module may be included in the memory 1005 as a computer storage medium.
  • a user interface module may be included in the memory 1005 as a computer storage medium.
  • a data operation program may be included in the memory 1005 as a computer storage medium.
  • the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server;
  • the user interface 1003 is mainly used to connect the client (user end), and perform data communication with the client; and the processor
  • the data operation method provided in the embodiment of the present application is executed by using the data operation program stored in the memory 1005.
  • FIG. 2 is a schematic flowchart of the first embodiment of the data operation method of the present application.
  • the data operation method includes:
  • Step S1000 when receiving an operation request sent by the client, acquiring operation information corresponding to the operation request;
  • the caller goes through a client to a database such as HBase (Hadoop).
  • a database such as HBase (Hadoop).
  • the server corresponding to the database, the distributed open source database sends an operation request instruction, and when the server receives the operation request instruction sent by the client, generates an operation editing interface corresponding to the operation request instruction, and sends the operation editing interface.
  • the caller can edit the operation information based on the operation editing interface; when the operation information is edited, the caller determines that the operation information is edited by selecting the confirmation button of the operation editing interface, and triggers the operation request, and the client receives the operation request.
  • the operation request is sent to the server based on the operation request triggered by the confirmation key; wherein the operation request may be divided into a data operation request such as an insertion request, a deletion request, and a modification request, and specifically, the insertion request is to insert data in the target location.
  • a data operation request such as an insertion request, a deletion request, and a modification request, and specifically, the insertion request is to insert data in the target location.
  • the delete request is the request to delete the data (ie, the data to be deleted) in the target location, such as the target in the database Data 56 is deleted between 55, 56, and 57;
  • the modification request is The request to modify the original data to the target data in the target modification position, wherein the original data is the data before the modification, and the target data is the modified data, for example, in the 55, 56, 57 position of the target table of the database, 56 is modified to 60.
  • the server receives the operation request sent by the client, the operation information corresponding to the operation request is obtained.
  • An operation request may include a plurality of operation information.
  • the insertion request may include a plurality of operation information, that is, the insertion request includes not only operation information for inserting data at a target location, but also Including operation information for inserting data at other target locations, the same operation request may correspond to a plurality of different operation information; in addition, the same operation request is not limited to a separate insertion request, modification request, and deletion request, the operation
  • the operation information corresponding to the request is specifically edited by the caller in the operation editing interface of the client.
  • the operation information corresponding to an operation request may include operation information of the modified data at a certain target location, and may also include the insertion data at other target locations.
  • the operation information includes some basic operation information such as the identifier of the caller, the content of the call, and the parameter information, and the corresponding script program may be acquired according to the content of the call, and the parameter information in the operation information is corresponding according to different operation requests. Different content, such as serving
  • the parameter information in the operation information corresponding to the insertion request includes basic insertion information such as the data to be inserted, the target location of the data to be inserted, and/or the identification information of the data to be processed.
  • the parameter information in the operation information corresponding to the deletion request includes: basic deletion information such as a target location of the deleted data and/or identification information of the to-be-processed data; when the server receives When the modification request is sent by the client, the parameter information in the operation information corresponding to the modification request includes basic modification information such as the target data and the target location and/or the identification information of the data to be processed.
  • Step S2000 performing a verification operation on the obtained operation information
  • the verification operation includes verification of the operation authority of the operation information and verification of the data format information corresponding to the operation information, wherein the verification of the operation authority of the operation information includes: verifying whether the caller has the target location The data to be processed performs the operation request corresponding to the operation, and the caller that verifies that the operation information corresponds to the operation request, whether the data to be processed has the processing authority, because some data in the server is locked, and the caller without the relevant operation authority is The operation request cannot be performed on the locked data, so it is necessary to verify whether the operation information corresponds to the permission of the caller of the operation request to process the data.
  • the data to be processed is the source data, that is, the data corresponding to the operation request stored in the server, and the different operation requests respectively correspond to different to-be-processed data, and the operation authority and the data format information can be separately verified by the source data.
  • the operation information is obtained, the operation information is parsed to obtain the identification information of the data to be processed, and the server can obtain the data to be processed through the identification information; in particular, when the insertion operation is requested, the operation information is verified to be corresponding.
  • the caller of the operation request has processing authority on the target data (inserted data)
  • the server instead of verifying whether the caller of the operation request corresponding to the operation request has processing authority for processing the data, because the pending data corresponding to the insertion request is the inserted data.
  • the adjacent data of the target location; and the verification of the data format information corresponding to the operation information is whether the data format information corresponding to the verification operation information meets the requirements corresponding to the execution of the operation, for example, when the insertion request is received, the operation information is corresponding to Data format information Card, if the data is inserted at the target position for the character or integer format requirements, the operation of the authentication data format information corresponding to the information, i.e. to verify that the data format information meets one of two conditions. This format requirements.
  • the server verifies the received operation information
  • the data format information corresponding to the operation information is obtained, and the data format information corresponding to the operation information is verified based on the to-be-processed data, and when the data format information is verified, the data is obtained.
  • Authorization information wherein the authorization information includes an operation authority of the caller, and the operation authority of the caller is obtained by parsing the authorization information, and the operation authority in the authorization information corresponding to the operation information is verified based on the to-be-processed data.
  • step S3000 when the operation information is verified, the operation type corresponding to the operation information is acquired, and the script program corresponding to the operation type is obtained in a preset database, where the operation information and the operation type are Many-to-one relationship;
  • the operation information is classified according to the operation type, and the same type of operation information invokes the same script program, and different types of operation information correspond to different script programs, and different types are respectively stored in the database corresponding to the server.
  • the script program can obtain the operation type corresponding to the operation request according to the calling content in the operation information when the verification of the operation information corresponding to the operation information is passed, and then the script program corresponding to the operation type can be obtained according to the operation type; For the same operation request including different operation information, the operation type corresponding to the different operation information is respectively obtained, and the same script program is called for the operation information of the same operation type, and the operation type corresponding to the operation information is called for different types of operation information.
  • the script program cannot find the script program corresponding to the operation type in the server, the program error instruction is fed back to the client, and if the script program corresponding to the operation type can be found, the script program is acquired, and then the script program is run. which is Implement the operation corresponding to the request operation.
  • Step S4000 Run the script program based on the parameter information in the operation information to perform a corresponding operation on the data to be processed corresponding to the operation request.
  • the script program corresponding to the operation information when the script program corresponding to the operation information is acquired, according to the parameter information in the operation information, an execution statement corresponding to the execution of the specific operation request is written in the corresponding script program, that is, the parameter information corresponds to Executing a statement, such as a script program corresponding to the insert operation, writing an execution statement corresponding to the execution of the insert operation in the script program; and modifying the script program corresponding to the operation, writing the execution corresponding to the modification operation in the script program.
  • the script corresponding to the deletion operation writes an execution statement corresponding to the execution of the deletion operation in the script program; when the script program runs successfully, the operation corresponding to the operation request can be implemented.
  • the script corresponding to the insert operation and the parameter information in the insert operation information are acquired, and the execution statement corresponding to the parameter information is written in the script program, such as the insertion target in the insert operation information.
  • the operation of the same type and different operation parameter information may correspond to the same or a plurality of different script programs, which are determined according to the setting of the script program of the parameter information in the server; if the service receives different When the target location simultaneously executes the same type of operation request corresponding to different parameter information, it is determined whether the parameter information corresponds to the same script program. If the same script program is corresponding, the script program is run multiple times according to the specific parameter information to implement parameter information. Corresponding operation; if there is a different script program corresponding to the same type of parameter information, the script program corresponding to the parameter information is separately obtained, and then the script program is run to implement the operation corresponding to the parameter information.
  • the above step specifically takes the modification request as an example.
  • the server receives the modification application instruction sent by the caller, the server generates a modification operation editing interface corresponding to the modification application instruction, and sends the modification operation editing interface to the client, and the caller is based on the client.
  • the operation editing interface of the end edits the modification operation information of the current operation.
  • the caller determines to complete the editing of the operation information by selecting the confirmation key of the operation editing interface, and triggers the operation request, and the server obtains the modification operation corresponding to the modification request when receiving the modification request sent by the client.
  • the operation authority corresponding to the modification operation information needs to be verified.
  • the authorization information corresponding to the modification operation information is obtained, and the authorization information corresponding to the modification operation information can be obtained by parsing the authorization information.
  • the modification operation information is parsed, and the target data (ie, the modified data) and the identification information of the to-be-processed data are obtained, and the to-be-processed data corresponding to the identification information of the to-be-processed data (ie, the data to be modified) is obtained;
  • Modify data to operate permissions Verification that is, verifying whether the caller has the right to modify the data at the target location, and whether the caller has the right to modify the original data to the target data.
  • the operation authority for the operation information is verified, the modification is performed.
  • the script corresponding to the modification operation is obtained according to the content of the call in the modification operation information, and the script program is written in the script program.
  • Modifying the modification execution statement corresponding to the parameter information in the operation information that is, writing the modification execution statement corresponding to the target position and the target data in the modification operation information, and running the script program based on the parameter information to implement the modification operation, that is, the target
  • the original data of the location is modified into the target data.
  • the script program is completed, the result of the modification operation is judged. If it is determined that the original data in the target location has been modified to the target data, the server is determined. Successfully performed this modification.
  • the data operation method in this embodiment obtains the operation information corresponding to the operation request when receiving the operation request sent by the client, and then performs the verification operation on the obtained operation information, and then the operation information in the operation information.
  • the verification is passed, the operation type corresponding to the operation information is obtained, and the script program corresponding to the operation type is obtained in the preset database, and then the script program is executed based on the parameter information in the operation information, to
  • the data to be processed corresponding to the operation request performs the corresponding operation, so that the server can provide the data operation service only by simple configuration, and does not need to customize and develop different script programs for different operation requests, thereby simplifying the process of providing the data operation service by the server. And improve the processing efficiency of the server while ensuring the provision of safe and reliable data operation services.
  • step S2000 includes:
  • Step S2100 Obtain authorization information corresponding to the operation information and data to be processed
  • the server when the server obtains the operation information corresponding to the operation request, the server can obtain the identification information of the data to be processed by parsing the operation information, and the data to be processed can be obtained through the identification information, and the operation information is corresponding to the data to be processed.
  • the authorization information is verified, and the authorization information is obtained according to the caller identifier in the operation information; wherein different operation requests correspond to different pending data, and when the insertion request is received, the pending data corresponding to the insertion request Then, the adjacent data of the data destination is inserted; when the modification request is received, the data to be processed corresponding to the modification request includes the original data (data before modification) and the adjacent data of the data; when the deletion request is received The data to be processed corresponding to the deletion request includes the data to be deleted and the adjacent data of the data to be deleted; and by analyzing the authorization information corresponding to the operation information, the operation of the caller corresponding to the operation request of the operation information can be obtained. Permission to verify the operation permission based on the pending data.
  • Step S2200 Verify the operation information based on the authorization information and the to-be-processed data.
  • the data format information corresponding to the operation information needs to be verified, and the data format information corresponding to the operation information is verified based on the data to be processed, that is, Whether the data format information corresponding to the operation information meets the format information requirement of the data to be processed; when the format information of the operation information is verified, the authorization information corresponding to the operation information is obtained, and the operation information can be obtained by parsing the obtained authorization information.
  • the operation authority of the caller of the operation request Corresponding to the operation authority of the caller of the operation request, and then performing the verification operation on the authorization information corresponding to the operation information, that is, the operation operation of the operation information corresponding to the operation request based on the data to be processed is verified, and when When the verification of the operation authority is passed, the operation information is verified.
  • the server when the data is inserted in the target table, when the server obtains the operation information corresponding to the insertion request, the data format information corresponding to the insertion operation information is obtained, and the adjacent data format information of the target location in the data to be processed is used.
  • the data format information corresponding to the insertion operation information is verified, that is, whether the format of the data to be inserted meets the data format information requirement of the target table, and if the format of the data to be inserted conforms to the data format information requirement of the target table, the insertion operation is performed.
  • the format verification of the information is passed; when the verification of the data format verification information is passed, the authorization information corresponding to the insertion operation information is obtained according to the caller identifier in the operation information, where the authorization information includes the operation of the caller of the insertion operation.
  • Permission by parsing the authorization information corresponding to the insertion operation information, the operation authority corresponding to the insertion operation information can be obtained; and the operation authority is verified based on the data to be processed, if the caller of the insertion operation has the insertion to be inserted Permission of data, at the same time If the permission to insert data is inserted in the table, the verification of the insert operation authority of the caller is passed, and when the call operation authority verification of the caller passes, the verification of the obtained insert operation information is passed. .
  • the data operation method provided in this embodiment obtains the authorization information corresponding to the operation information and the data to be processed, and then verifies the operation information based on the authorization information and the to-be-processed data, thereby realizing verification of the operation information. It removes the caller with no relevant operation authority and excludes the non-standard operation information whose data format does not meet the conditions, ensuring that the server can provide more secure and reliable data operation services, and at the same time, improve the processing efficiency of the server.
  • step S2200 includes:
  • Step S2210 Parsing the obtained authorization information to obtain an operation authority corresponding to the operation information
  • the server authorizes the caller separately before the caller applies to perform an operation permission, and the different callers are divided into different security levels by the authorization, so that different callers are in different operations.
  • the server has different permissions. Therefore, the server needs to verify the operation authority of the caller before performing the operation corresponding to the operation request sent by the caller. If the obtained authorization information is parsed, the operation authority corresponding to the operation information can be obtained.
  • the authorization information includes the operation authority of the caller of the operation request, and therefore, the operation authority can be directly obtained by parsing the operation information.
  • the operation authority is expressed as the authority of the caller corresponding to the operation request, and the operation authority is verified to verify whether the caller corresponding to the operation request has the authority to perform the operation, and if the operation information corresponds to the operation
  • the caller of the request has no permission to perform the operation, and the operation of the caller's operation request is not executed by the server.
  • Step S2220 Verify the operation authority based on the to-be-processed data, where the operation information is verified when the operation authority verification is passed.
  • the corresponding authorization information may be obtained according to the caller identifier in the operation information, and the operation authority of the caller corresponding to the operation request may be obtained by parsing the authorization information, and the operation authority may be based on the data to be processed.
  • the data to be processed is requested to perform the corresponding operation; for example, when the modification request sent by the client is received, the modification operation information corresponding to the modification request is obtained, and the data to be processed can be obtained by parsing the modification operation information, wherein the data to be processed is The original data and the adjacent data of the data are included, the original data is the data before the modification, the target data is the modified data, the authorization information corresponding to the modification operation request is obtained, and the authorization information is parsed to obtain the caller's Operation authority; in the operation to be modified When the information is verified, the operation authority of the caller is verified based on the data to be modified, that is, whether the caller has the right to modify the original data to the target data, and whether the caller has the modification in the target table. The permission of the
  • the data operation method of the present embodiment is to verify the operation authority corresponding to the operation information by parsing the obtained authorization information, and then verify the operation authority based on the to-be-processed data, wherein the operation authority is When the verification is passed, the operation information is verified, and the verification of the operation authority of the caller is performed, and the caller without the corresponding operation authority is screened out to ensure that the server can provide a safe and reliable data operation service, and also improves the processing efficiency of the server. .
  • step S2210 includes:
  • Step S2211 Obtain data format information corresponding to the operation information.
  • the data format information corresponding to the operation information needs to be verified.
  • the data format may be different for different operation requests and different target location data. If the server receives the insert request, if the format of the data to be inserted does not match the data format required by the target insertion location, the server cannot perform the insert operation; therefore, the server performs the operation corresponding to the operation request sent by the caller. Before, the data format information corresponding to the operation information needs to be verified; if the server receives the modification request, it first determines whether the format of the target data (modified data) of the modified operation information is consistent with the original data format in the to-be-processed data.
  • the data format information of the operation information is verified. If the data format is inconsistent, it is determined whether the target data format meets the data format requirement of the target location. If the target data format in the data to be processed does not meet the data format required by the target location, then Server cannot be executed Modify operation.
  • Step S2212 verifying the data format information based on the to-be-processed data
  • the identification information of the data to be processed is obtained by parsing the operation information, and the data to be processed can be obtained by using the identification information, and the data format information corresponding to the operation information can be verified based on the data to be processed, specifically, Determining whether the data format information is consistent with the data format of the data to be processed, wherein the data format information is consistent with the data format of the data to be processed, and the data format information is verified; or, in the data to be processed
  • the data format information may be verified by determining whether the data format information satisfies the data format requirement of the data to be processed, where the data format information is consistent with the data format of the data to be processed.
  • the server receives the deletion request, it does not need to verify the data format information of the deletion operation information corresponding to the deletion request, and only needs to verify the operation authority of the deletion operation information; for example, the modification operation is performed.
  • the modification operation information corresponding to the modification request is parsed, and the identification information of the data to be processed is obtained, and the data to be processed is obtained by using the identification information, wherein the to-be-processed data includes the modified original data (data before modification) and the The data adjacent to the data is verified by the data format information of the modified operation information, that is, the format information of the target data obtained by parsing the operation information is verified, and if the format information of the target data is consistent with the format information of the source data, Then, it is determined that the data format information of the modified operation information is verified.
  • the format information of the target data is different from the format information of the source data, the format information of the target data needs to be determined, and whether the format of the target data conforms to the target is determined. Modify the requirements of the location data format when determining the When the format of the data meets the requirements of the target mark position to modify the data format, it is determined that a modification to the data format information of the operation information is verified.
  • Step S2213 When the data format information is verified, the obtained authorization information is parsed.
  • the authorization information corresponding to the operation information is obtained, and the authorization information is parsed, and the operation authority corresponding to the operation information can be obtained by parsing the authorization information. Then, the operation authority is verified, and when the operation authority is verified, the verification of the operation information is passed.
  • the data operation method in this embodiment is obtained by acquiring data format information corresponding to the operation information, and then verifying the data format information based on the to-be-processed data, and then parsing and obtaining when the data format information is verified and passed.
  • the authorization information realizes the verification of the data format information corresponding to the operation information, eliminates the irregular operation information whose data format does not meet the conditions, ensures that the server can provide a more secure and reliable data operation service, and at the same time, improves the Server processing efficiency.
  • step S2000 includes:
  • step S2300 when the operation information verification fails, the verification failure information corresponding to the operation information is acquired;
  • the verification failure information corresponding to the operation information needs to be obtained, and the verification failure information is fed back to the client; and the verification of the operation information includes the operation authority respectively. Verification and verification of the data format information corresponding to the operation information; when verifying the operation authority corresponding to the operation information, based on the data to be processed, if the caller corresponding to the operation request does not have permission to request the server to perform the operation, or the caller If there is no permission to perform the corresponding operation on the data to be processed, it means that the verification of the operation authority corresponding to the operation information fails, and the reason for the failure of the verification is obtained, that is, the caller has no permission to perform the operation or The caller has no right to perform corresponding operations on the data to be processed, and the verification failure information (the reason for the verification failure) is fed back to the client; when the data format information corresponding to the operation information is verified, the data to be processed is based on the data to be processed.
  • the verification of the data format information corresponding to the operation information fails, and the reason for the failure of the verification is obtained.
  • the reason is that the data format information corresponding to the operation information does not meet the requirement, and the verification fails.
  • the information (the reason for the verification failure) is fed back to the client; the above verification of the operation authority of the operation information and the verification of the data format information, when any verification condition verification fails, indicates that the verification of the operation information fails.
  • Step S2400 feeding back the verification failure information to the client.
  • the verification failure information when the verification failure information is obtained, the verification failure information needs to be fed back to the corresponding client.
  • the verification failure information specifically includes verification failure information of the operation authority and data format information.
  • the verification failure information wherein the verification failure information for the operation authority includes the authority that the caller corresponding to the operation request does not request the corresponding server to perform the operation, and the caller corresponding to the operation request does not perform the corresponding operation on the to-be-processed data.
  • the verification failure information of the data format information includes that the data format information corresponding to the operation information does not meet the data format information requirement of the target operation location; when the verification of the authorization information fails, the corresponding failure information is fed back to the client. .
  • the data operation method in this embodiment obtains the verification failure information corresponding to the operation information when the operation information verification fails, and then feeds back the verification failure information to the client, thereby implementing the pair operation information.
  • the feedback of the verification failure information enables the corresponding caller of the client to clearly know the reason for the verification failure, and when the caller sends the relevant operation request to the server again, the verification failure can be avoided. Errors that improve the efficiency of the service when the server provides data manipulation services.
  • the data operation method includes:
  • step S5000 when the running of the script program is completed, acquiring data after the processing of the to-be-processed data is completed;
  • the operation corresponding to the operation request may be implemented by running a script program corresponding to the operation information, for example, by executing a script program corresponding to the insertion operation information, an operation of inserting data at a target location may be implemented;
  • the running of the program is completed, the data after the processing of the data to be processed is completed, that is, when the execution of the operation corresponding to the operation request is completed, the data result after the execution of the operation is obtained, for example, when the insert operation is performed, the operation corresponding to the insert operation is performed.
  • a script program that, when the script program finishes running, acquires data of a target location after inserting data, such as inserting data 56 between data 55 and 57 of the target table, wherein 56 is data to be inserted, before inserting data 56,
  • the table data sequence is 55, 57.
  • the script program corresponding to the insert request is completed, the data order of the table is 55, 56, 57, and the data result 55, 56, 57 after the insert 56 is the data to be processed. The completed data.
  • Step S6000 determining, according to the data after the processing is completed, whether the operation corresponding to the operation request is successfully performed
  • the operation corresponding to the operation request may not be realized. For example, during the running of the script program, data is lost, or the data command is executed incorrectly, or the system is faulty. When the execution of the script program is completed, the operation corresponding to the operation request cannot be implemented. Therefore, when the script program is finished running, by obtaining the data after the processing of the data to be processed, it can be determined whether the operation corresponding to the operation request is successfully executed. If the data 56 is inserted between the 55 and 57 of the target table as described above, it can be judged whether the insertion operation is successfully executed by judging whether the data of the position in the target table after the insertion request has been executed has become 55, 56, 57.
  • step S7000 when the operation corresponding to the operation request is successfully executed, the processing success information is fed back to the client.
  • the data after the processing of the data to be processed is obtained, and whether the operation corresponding to the operation request is successfully executed is determined.
  • the feedback processing is successful.
  • the information is sent to the client.
  • the operation corresponding to the operation request fails, the information that fails to be processed is fed back to the client.
  • the data operation method in this embodiment is configured to acquire data after the processing of the to-be-processed data is completed, and then determine whether the operation request is successfully executed based on the processed data. Corresponding operation, and then, when the operation corresponding to the operation request is successfully executed, the processing success information is fed back to the client, and the operation efficiency of the script program and the processing efficiency of the server are improved by determining whether the operation request is successfully executed. , reducing the threshold for technical applications.
  • step S1000 includes:
  • Step S1100 Upon receiving an operation request instruction sent by the client, generate an operation editing interface corresponding to the operation request instruction, and send the operation editing interface to the client;
  • the server when receiving the operation request instruction sent by the client, the server generates an operation editing interface corresponding to the operation request instruction, and sends the operation editing interface to the corresponding client, and the caller can perform the operation based on the operation.
  • the editing interface edits corresponding operation information, and the operation editing interface corresponding to different operation requests is different. If it is an insertion request, the insertion operation editing interface includes the data to be inserted and the target position and/or data to be processed in which the data to be inserted is inserted.
  • the deletion operation editing interface includes: deleting the target location of the data and/or the identification information of the data to be processed; if the request is to be modified, the editing operation editing interface includes: the target Information such as data and target location and/or identification information of the data to be processed.
  • Step S1200 Acquire operation information corresponding to the operation request when receiving an operation request triggered by the client based on the operation editing interface.
  • the caller edits the operation information based on the operation editing interface.
  • the caller determines to complete the editing of the operation information by selecting the confirmation key of the operation editing interface, and triggers the operation request, and the client will The operation request is sent to the corresponding server.
  • the server receives the operation request, the operation information corresponding to the operation request is obtained, where the operation information is the operation information edited by the caller based on the operation editing interface, such as the operation corresponding to the insertion request.
  • the operation information of the editing interface is information such as the target location to be inserted and the target location of the data to be inserted and/or the identification information of the data to be processed;
  • the operation information of the operation editing interface corresponding to the modification request is the target data and the target location and/or Or information such as identification information of the data to be processed;
  • the operation information of the operation editing interface corresponding to the deletion request is information such as the target location of the deleted data and/or the identification information of the data to be processed.
  • an operation editing interface corresponding to the insertion request instruction is generated, and the insertion operation editing interface is sent to the client.
  • the caller edits the interface based on the insert operation, edits the basic insertion information such as the data to be inserted (ie, the data to be inserted) and the target position of the data to be inserted, and the operation information includes the basic insertion information described above, and can be selected by
  • the confirmation key of the operation editing interface determines that the operation information is edited and the operation request is triggered.
  • the client When the client receives the insertion request triggered by the confirmation key, the client sends the insertion request to the server, and when the server receives the transmission sent by the client, When the request is inserted, the operation information corresponding to the insertion request is obtained; the operations of deleting and modifying are similar to the steps of the insertion operation, and details are not described herein again.
  • the data operation method provided in this embodiment generates an operation editing interface corresponding to the operation request instruction, and sends the operation editing interface to the client, and then receives the operation request instruction sent by the client.
  • the client is based on the operation request triggered by the operation editing interface
  • the operation information corresponding to the operation request is obtained, and the connection between the client and the server based on the operation editing interface of the client is implemented, so that the server can accurately receive the connection.
  • the caller provides a data operation service corresponding to the operation request better and more accurately based on the operation request sent by the client operation editing interface.
  • the present application further provides a data operation device, where the data operation device includes:
  • a first acquiring module configured to acquire operation information corresponding to the operation request when receiving an operation request sent by the client
  • a verification module configured to perform verification operations on the obtained operation information
  • a second acquiring module configured to acquire an operation type corresponding to the operation information when the operation information is verified, and obtain a script program corresponding to the operation type in a preset database, where the operation information and the The type of operation is a many-to-one relationship;
  • a running module configured to run the script program based on the parameter information in the operation information, to perform a corresponding operation on the data to be processed corresponding to the operation request.
  • the verification module includes:
  • Obtaining a sub-module configured to acquire authorization information corresponding to the operation information and data to be processed
  • a verification submodule configured to verify the operation information based on the authorization information and the to-be-processed data.
  • a parsing unit configured to parse the obtained authorization information to obtain an operation authority corresponding to the operation information
  • a verification unit configured to verify the operation authority based on the to-be-processed data, wherein the operation information is verified to pass when the operation authority is verified to pass.
  • parsing unit includes:
  • a verification subunit configured to verify the data format information based on the to-be-processed data
  • a parsing subunit configured to parse the obtained authorization information when the data format information is verified to pass.
  • the present application further provides a computer readable storage medium having a data operation program stored thereon, and the data operation method is implemented by the processor to implement the data operation method. A step of.
  • the technical solution of the present application which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM as described above). , a disk, an optical disk, including a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in the various embodiments of the present application.
  • a terminal device which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.

Abstract

一种数据操作方法,装置和计算机可读存储介质,所述方法包括:在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息(S1000);对获取到的所述操作信息进行验证操作(S2000);在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序(S3000);基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作(S4000)。所述方法使得服务器只需做简单的配置即可提供数据操作服务,无需针对不同的操作请求定制开发不同的脚本程序,简化了服务器提供数据操作服务的流程,并且在确保提供安全可靠的数据操作服务的前提下,提高了服务器处理效率。

Description

数据操作方法、装置及计算机可读存储介质
本申请要求于2017年07月31日提交中国专利局、申请号为201710645107.5、发明名称为“数据操作方法、装置及计算机可读存储介质”的中国专利申请的优先权,其全部内容通过引用结合在申请中。
技术领域
本申请涉及计算机技术领域,尤其涉及一种数据操作方法、装置及计算机可读存储介质。
背景技术
在如今数字信息化的时代,随着大数据技术的普及与渗透,人们主要通过数据库来对数据进行规范化存储、管理和共享等操作,数据库系统是目前存储数据、检索信息最为方便高效的手段。而目前主要基于数据库的数据操作服务,如基于HBase(Hadoop Database,分布式的开源数据库)的数据操作服务,主要通过API接口对接收到的数据操作请求进行一对一的脚本程序定制化开发,即在每次执行数据操作服务时都需要调用该数据操作服务特定的脚本程序,以此来实现该数据操作请求对应的数据操作服务。
但是,上述方式在开发过程中便会造成数据操作服务过程繁琐复杂,效率低下的问题。
发明内容
本申请的主要目的在于提供一种数据操作方法、装置及计算机可读存储介质,旨在解决服务器对接收到的数据操作请求进行一对一的脚本程序定制化开发而造成数据操作服务过程繁琐复杂的技术问题。
为实现上述目的,本申请提供一种数据操作方法,所述数据操作方法包括以下步骤:
在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
对获取到的所述操作信息进行验证操作;
在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系,;
基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
此外,为实现上述目的,本申请还提供一种数据查询装置,所述数据查询装置包括:
第一获取模块,用于在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
验证模块,用于对获取到的所述操作信息进行验证操作;
第二获取模块,用于在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系;
运行模块,用于基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
此外,为实现上述目的,本申请还提供一种数据操作装置,所述数据操作装置包括:存储器、处理器及存储在所述存储器上并可在所述处理器上运行的数据操作程序,所述数据操作程序被所述处理器执行时实现上述任一项所述的数据操作方法的步骤。
此外,为实现上述目的,本申请还提供一种计算机可读存储介质,所述计算机可读存储介质上存储有数据操作程序,所述数据操作程序被处理器执行时实现上述任一项所述的数据操作方法的步骤。
本申请通过在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息,接着对获取到的所述操作信息进行验证操作,之后在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,而后基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作,使得服务器只需做简单的配置即可提供数据操作服务,无需针对不同的操作请求定制开发不同的脚本程序,简化了服务器提供数据操作服务的流程,并且在确保提供安全可靠的数据操作服务的前提下,提高了服务器处理效率。
附图说明
图1是本申请实施例方案涉及的硬件运行环境中的数据操作装置所属终端的结构示意图;
图2为本申请数据操作方法第一实施例的流程示意图。
本申请目的的实现、功能特点及优点将结合实施例,参照附图做进一步说明。
具体实施方式
应当理解,此处所描述的具体实施例仅仅用以解释本申请,并不用于限定本申请。
如图1所示,图1是本申请实施例方案涉及的硬件运行环境中的数据操作装置所属终端的结构示意图。
本申请实施例终端可以是PC。如图1所示,该终端可以包括:处理器1001,例如CPU,网络接口1004,用户接口1003,存储器1005,通信总线1002。其中,通信总线1002用于实现这些组件之间的连接通信。用户接口1003可以包括显示屏(Display)、输入单元比如键盘(Keyboard),可选用户接口1003还可以包括标准的有线接口、无线接口。网络接口1004可选的可以包括标准的有线接口、无线接口(如WI-FI接口)。存储器1005可以是高速RAM存储器,也可以是稳定的存储器(non-volatile memory),例如磁盘存储器。存储器1005可选的还可以是独立于前述处理器1001的存储装置。
可选地,终端还可以包括摄像头、RF(Radio Frequency,射频)电路,传感器、音频电路、WiFi模块等等。其中,传感器比如光传感器、运动传感器以及其他传感器。具体地,光传感器可包括环境光传感器及接近传感器,其中,环境光传感器可根据环境光线的明暗来调节显示屏的亮度,接近传感器可在移动终端移动到耳边时,关闭显示屏和/或背光。作为运动传感器的一种,重力加速度传感器可检测各个方向上(一般为三轴)加速度的大小,静止时可检测出重力的大小及方向,可用于识别移动终端姿态的应用(比如横竖屏切换、相关游戏、磁力计姿态校准)、振动识别相关功能(比如计步器、敲击)等;当然,移动终端还可配置陀螺仪、气压计、湿度计、温度计、红外线传感器等其他传感器,在此不再赘述。
本领域技术人员可以理解,图1中示出的终端结构并不构成对终端的限定,可以包括比图示更多或更少的部件,或者组合某些部件,或者不同的部件布置。
如图1所示,作为一种计算机存储介质的存储器1005中可以包括操作系统、网络通信模块、用户接口模块以及数据操作程序。
在图1所示的终端中,网络接口1004主要用于连接后台服务器,与后台服务器进行数据通信;用户接口1003主要用于连接客户端(用户端),与客户端进行数据通信;而处理器1001可以用于调用存储器1005中存储的数据操作程序,并执行本申请实施例提供的数据操作方法。
本申请进一步提供一种数据操作方法,参照图2,图2是本申请数据操作方法第一实施例的流程示意图。
在本实施例中,该数据操作方法包括:
步骤S1000,在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
在本实施例中,调用方通过客户端向数据库如HBase(Hadoop Database,分布式的开源数据库)所对应的服务器发送操作申请指令,在服务器接收到由客户端发送的操作申请指令时,则生成一个该操作申请指令对应的操作编辑界面,并发送该操作编辑界面至客户端,调用方可基于该操作编辑界面编辑操作信息;在操作信息编辑完成时,调用方通过选择操作编辑界面的确认键确定对操作信息编辑完成,同时触发操作请求,客户端在接收到基于该确认键触发的操作请求时,将该操作请求发送至服务器;其中,操作请求可分为插入请求、删除请求及修改请求等数据操作请求,具体地,插入请求为在目标位置中插入数据(即待插入数据)的请求,如在数据库的目标表的55与57,之间插入数据56;删除请求则为在目标位置中删除数据(即待删除数据)的请求,如在数据库的目标表的55、56、57之间删除数据56;修改请求则为在目标修改位置中将原数据修改为目标数据的请求,其中原数据为修改前的数据,目标数据则为修改后的数据,如在数据库的目标表的55、56、57位置,将56修改为60;在服务器接收到客户端发送的操作请求时,则获取该操作请求对应的操作信息。
一个操作请求可包括多个操作信息,如服务器在接收到一个插入请求时,则该插入请求可包括多个操作信息,即该插入请求不止包括在一个目标位置插入数据的操作信息,同时还可以包括在其他目标位置插入数据的操作信息,同一个操作请求可对应多个不同的操作信息;除此之外,同一个操作请求不仅仅局限于单独的插入请求、修改请求及删除请求,该操作请求对应的操作信息具体由调用方在客户端的操作编辑界面编辑,如一个操作请求对应的操作信息可以同时包括在某一目标位置的修改数据的操作信息,也可包括在其他目标位置的插入数据的操作信息;具体地,操作信息则包括调用方的标识、调用内容及参数信息等一些基本操作信息,根据调用内容可以获取对应的脚本程序,操作信息中的参数信息则根据不同的操作请求对应不同的内容,如当服务器接收到客户端发送的插入请求时,则该插入请求对应的操作信息中的参数信息包括:待插入数据、该待插入数据插入的目标位置和/或待处理数据的标识信息等基本插入信息;当服务器接收到客户端发送的删除请求时,则该删除请求对应的操作信息中的参数信息包括:删除数据的目标位置和/或待处理数据的标识信息等基本删除信息;当服务器接收到客户端发送的修改请求时,则该修改请求对应的操作信息中的参数信息包括:目标数据及目标位置和/或待处理数据的标识信息等基本修改信息。
步骤S2000,对获取到的所述操作信息进行验证操作;
在本实施例中,在数据库所对应的服务器获取到操作请求对应的操作信息时,需要对该操作信息进行验证操作。具体地,验证操作包括对操作信息的操作权限的验证以及对操作信息对应的数据格式信息的验证,其中,对操作信息的操作权限的验证则包括:验证该调用方是否具有在目标位置对该待处理数据执行操作请求对应操作的权限,以及验证该操作信息对应操作请求的调用方对待处理数据是否具有处理的权限,因为在服务器中有些数据是被锁定的,没有相关操作权限的调用方是无法对该被锁定的数据进行操作请求,因此需要验证该操作信息对应操作请求的调用方对待处理数据是否具有处理的权限。其中,待处理数据为源数据即服务器中存储的该操作请求对应的数据,不同的操作请求分别对应不同的待处理数据,通过该源数据可以分别对操作权限和数据格式信息进行验证,在服务器获取到操作信息时,对该操作信息进行解析可以得到待处理数据的标识信息,服务器通过该标识信息则可以获取到待处理数据;特别地,当为插入操作请求时,则验证该操作信息对应操作请求的调用方对目标数据(插入的数据)是否具有处理权限,而不是验证该操作信息对应操作请求的调用方对待处理数据是否具有处理的权限,因为插入请求对应的待处理数据为插入数据目标位置的相邻数据;而对操作信息对应的数据格式信息的验证为,验证操作信息对应的数据格式信息是否符合执行该操作对应的要求,如在接收到插入请求时,对操作信息对应的数据格式信息进行验证,若在目标位置插入数据的格式要求为字符型或整型,则对操作信息对应的数据格式信息的验证,即为验证该数据格式信息是否符合这两个格式要求条件之一。
当服务器对接收到的操作信息进行验证时,获取该操作信息对应的数据格式信息,基于待处理数据,对该操作信息对应的数据格式信息进行验证,当对该数据格式信息验证通过时,获取授权信息,其中该授权信息包括调用方的操作权限,通过对该授权信息进行解析可以得到调用方的操作权限,基于待处理数据对该操作信息对应的授权信息中的操作权限进行验证。
步骤S3000,在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系;
在本实施例中,操作信息按操作类型分类,同一类型的操作信息则调用同一脚本程序,不同类型的操作信息则对应不同的脚本程序,在服务器对应的数据库中会存储有各个不同类型分别对应的脚本程序,在操作信息对应的操作信息的验证通过时,根据操作信息中的调用内容可以得到此次操作请求对应的操作类型,而后根据该操作类型可以获取该操作类型对应的脚本程序;如对于包括不同的操作信息的同一操作请求,则分别获取不同操作信息对应的操作类型,对于同一操作类型的操作信息调用同一脚本程序,对于不同类型的操作信息则调用该操作信息的操作类型对应的脚本程序,若在服务器中不能查找到该操作类型对应的脚本程序,则反馈程序错误指令至客户端,若可以查找到该操作类型对应的脚本程序,则获取该脚本程序,而后运行该脚本程序即可实现该操作请求对应的操作。
步骤S4000,基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
在本实施例中,当获取到操作信息对应的脚本程序时,根据该操作信息中的参数信息,在对应的脚本程序中写有执行具体的操作请求对应的执行语句,即该参数信息对应的执行语句,如插入操作对应的脚本程序,则在该脚本程序中写有对应执行该插入操作的执行语句;修改操作对应的脚本程序,则在该脚本程序中写有对应执行该修改操作的执行语句;删除操作对应的脚本程序,则在该脚本程序中写有对应执行该删除操作的执行语句;当该脚本程序运行成功时,即可实现该操作请求对应的操作。例如,在执行插入操作时,获取插入操作对应的脚本程序以及此次插入操作信息中的参数信息,在该脚本程序中写有该参数信息对应的执行语句,如该插入操作信息中的插入目标位置及待插入数据对应的插入执行语句,基于该参数信息运行该脚本程序,在该脚本程序运行的过程中运行该插入执行语句,以实现数据的插入操作,当该脚本程序运行成功时,则可实现在目标位置插入待插入数据的操作。除此之外,对于同一类型而不同操作参数信息的操作,可能对应同一个或多个不同的脚本程序,具体根据服务器中参数信息的脚本程序的设定来判断;若在服务接收到对于不同目标位置同时执行不同的参数信息对应的同类型操作请求时,确定该参数信息是否对应同一个脚本程序,若对应同一个脚本程序,则根据具体的参数信息多次运行该脚本程序以实现参数信息对应的操作;若存在同类型的参数信息对应不同的脚本程序,则单独获取该参数信息对应的脚本程序,而后运行该脚本程序以实现该参数信息对应的操作。
上述步骤具体以修改请求为例,在服务器接收到调用方发送的修改申请指令时,生成该修改申请指令对应的修改操作编辑界面,并发送该修改操作编辑界面至客户端,调用方基于该客户端的操作编辑界面编辑此次的修改操作信息, 在操作信息编辑完成时,调用方通过选择操作编辑界面的确认键确定对操作信息编辑完成,同时触发操作请求,服务器在接收到客户端发送的修改请求时,获取此次修改请求对应的修改操作信息;接着获取该修改操作信息对应的数据格式信息,对该修改操作信息进行验证,若待修改数据中的目标数据格式符合目标位置数据的格式要求,则对数据格式信息的验证通过;除此之外,还需要对该修改操作信息对应的操作权限进行验证,在对数据格式信息验证通过时,获取该修改操作信息对应的授权信息,解析该授权信息可以得到该修改操作信息对应的操作权限,同时解析该修改操作信息,可以得到目标数据(即修改后的数据)与待处理数据的标识信息,获取该待处理数据的标识信息对应的待处理数据(即待修改数据);基于该待修改数据对操作权限进行验证,即验证此次调用方是否具有在目标位置修改数据的权限,以及调用方是否具有将原数据修改为目标数据的权限,在对该操作信息的操作权限验证通过时,则对此次修改操作信息的验证通过;而后,在对此次修改操作信息的验证通过时,根据此次修改操作信息中的调用内容获取此次修改操作对应的脚本程序,在该脚本程序中则写有此次修改操作信息中的参数信息对应的修改执行语句,即写有此次修改操作信息中目标位置及目标数据对应的修改执行语句,基于该参数信息运行该脚本程序,实现此次修改操作,即将目标位置的原数据修改为目标数据,最后,在该脚本程序运行完成时,对此次修改操作执行后的结果进行判断,若确定在目标位置中的原数据已被修改为目标数据,则确定服务器成功执行此次修改操作。
本实施例提出的数据操作方法,通过在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息,接着对获取到的所述操作信息进行验证操作,之后在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,而后基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作,使得服务器只需做简单的配置即可提供数据操作服务,无需针对不同的操作请求定制开发不同的脚本程序,简化了服务器提供数据操作服务的流程,并且在确保提供安全可靠的数据操作服务的前提下,提高了服务器处理效率。
基于第一实施例,提出本申请数据操作方法的第二实施例,在本实施例中,步骤S2000包括:
步骤S2100,获取所述操作信息对应的授权信息以及待处理数据;
在本实施例中,服务器在获取到操作请求对应的操作信息时,解析该操作信息可以得到待处理数据的标识信息,通过该标识信息可以得到待处理数据,基于待处理数据,对操作信息对应的授权信息进行验证操作,授权信息可根据操作信息中的调用方标识获取得到;其中,不同的操作请求对应不同的待处理数据,当接收到插入请求时,则该插入请求对应的待处理数据则为插入数据目标位置的相邻数据;当接收到修改请求时,则该修改请求对应的待处理数据则包括原数据(修改前的数据)以及该数据相邻数据;当接收到删除请求时,则该删除请求对应的待处理数据则包括待删除的数据以及该待删除的数据的相邻数据;通过解析该操作信息对应的授权信息,可以得到该操作信息对应操作请求的调用方的操作权限,基于待处理数据对该操作权限进行验证。
步骤S2200,基于所述授权信息及所述待处理数据,验证所述操作信息。
在本实施例中,在对授权信息解析得到的操作权限进行验证之前,还需要对该操作信息对应的数据格式信息进行验证,基于待处理数据对该操作信息对应的数据格式信息进行验证,即该操作信息对应的数据格式信息是否符合待处理数据的格式信息要求;在对操作信息的格式信息验证通过时,获取该操作信息对应的授权信息,通过解析获取到的授权信息可以得到该操作信息对应操作请求的调用方的操作权限,而后对操作信息对应的授权信息进行验证操作,即基于待处理数据对解析得到的该操作信息对应操作请求的调用方的操作权限进行验证操作,当对该操作权限的验证通过时,则操作信息验证通过。
例如,以在目标表中插入数据为例,当服务器获取到插入请求对应的操作信息时,获取该插入操作信息对应的数据格式信息,基于待处理数据中目标位置的相邻数据格式信息,对该插入操作信息对应的数据格式信息进行验证,即验证该待插入数据的格式是否符合目标表的数据格式信息要求,若该待插入数据的格式符合目标表数据格式信息要求,则对该插入操作信息的格式验证通过;在该数据格式验证信息验证通过时,根据操作信息中的调用方标识,获取此次插入操作信息对应的授权信息,其中,该授权信息包括此次插入操作调用方的操作权限,通过解析此次插入操作信息对应的授权信息,可以得到此次插入操作信息对应的操作权限;基于待处理数据对该操作权限进行验证,若此次插入操作的调用方具有插入该待插入数据的权限,同时具有在此次目标表中插入该待插入数据的权限,则对此次调用方的插入操作权限的验证通过,在此次调用方的插入操作权限验证通过时,则此次对获取到的插入操作信息的验证通过。
本实施例提出的数据操作方法,通过获取所述操作信息对应的授权信息以及待处理数据,接着基于所述授权信息及所述待处理数据,验证所述操作信息,实现了对操作信息的验证,筛除了无相关操作权限的调用方,并且排除了数据格式不符合条件的不规范的操作信息,确保服务器能够提供更安全可靠的数据操作服务,同时,也提高了服务器处理效率。
基于第二实施例,提出本申请数据操作方法的第三实施例,在本实施例中,步骤S2200包括:
步骤S2210,解析获取到的所述授权信息,以获得所述操作信息对应的操作权限;
在本实施例中,服务器会在调用方申请执行某项操作权限之前,分别对调用方进行授权,通过授权使得不同的调用方被划分在不同的安全级别,使得不同的调用方在不同的操作上有不同的权限,因此服务器在执行调用方发送的操作请求对应的操作之前,需要对该调用方的操作权限进行验证;解析获取到的授权信息,可以得到该操作信息对应的操作权限,其中,该授权信息包括操作请求的调用方的操作权限,因此,可通过解析该操作信息直接得到该操作权限。该操作权限即表示为该操作信息对应操作请求的调用方的权限,对该操作权限进行验证可以验证该操作信息对应操作请求的调用方是否具有相关执行该操作的权限,若该操作信息对应操作请求的调用方无相关执行该操作的权限,则该调用方的操作请求的操作不会被服务器执行。
步骤S2220,基于所述待处理数据,验证所述操作权限,其中,在对所述操作权限验证通过时,所述操作信息验证通过。
在本实施例中,根据操作信息中的调用方标识可以获取到对应的授权信息,通过解析授权信息可以得到操作信息对应操作请求的调用方的操作权限,基于待处理数据,可以对该操作权限进行验证;具体地,基于待处理数据,分别验证该操作信息对应操作请求的调用方对该待处理数据是否具有操作权限,以及验证该操作信息对应操作请求的调用方是否具有在目标位置对该待处理数据请求执行对应操作的权限;例如,在接收到客户端发送的修改请求时,获取该修改请求对应的修改操作信息,解析该修改操作信息可以得到待处理数据,其中该待处理数据则包括原数据以及该数据相邻数据,原数据为修改前的数据,目标数据为修改后的数据,获取该修改操作请求对应的授权信息,并对该授权信息进行解析则可以得到该调用方的操作权限;在对该待修改操作信息进行验证时,基于该待修改数据,对该调用方的操作权限进行验证,即需要验证该调用方是否具有将原数据修改为目标数据的权限,以及该调用方是否具有在目标表中修改数据的权限,若验证得到该调用方具有将将原数据修改为目标数据的权限,同时也具有在目标表中修改数据的权限,则对该调用方的操作权限验证通过。
本实施例提出的数据操作方法,通过解析获取到的所述授权信息,以获得所述操作信息对应的操作权限,而后基于待处理数据,验证所述操作权限,其中,在对所述操作权限验证通过时,所述操作信息验证通过,实现了通过对调用方操作权限的验证,筛除了无对应操作权限的调用方,确保服务器能够提供安全可靠的数据操作服务,同时也提高了服务器处理效率。
基于第三实施例,提出本申请数据操作方法的第四实施例,在本实施例中,步骤S2210包括:
步骤S2211,获取所述操作信息对应的数据格式信息;
在本实施例中,除了需要对操作信息的操作权限进行验证以外,还需要对该操作信息对应的数据格式信息进行验证,具体地,对于不同的操作请求以及不同的目标位置数据格式可能是不同的,如服务器在接收到插入请求时,若待插入数据的格式与目标插入位置要求的数据格式不符合,则服务器也无法执行插入操作;因此,服务器在执行调用方发送的操作请求对应的操作之前,需要对该操作信息对应的数据格式信息进行验证;如服务器在接收到修改请求时,首先判断该修改操作信息的目标数据(修改后的数据)格式是否与待处理数据中原数据格式一致,若一致则对该操作信息的数据格式信息验证通过,若不一致则判断该目标数据格式是否符合目标位置的数据格式要求,若待处理数据中目标数据格式与目标位置要求的数据格式不符合,则服务器无法执行修改操作。
步骤S2212,基于所述待处理数据,验证所述数据格式信息;
在本实施例中,通过解析操作信息得到待处理数据的标识信息,通过该标识信息可以得到待处理数据,基于待处理数据,可以对操作信息对应的数据格式信息进行验证,具体地,可通过确定数据格式信息与待处理数据的数据格式是否一致的方式对数据格式信息的验证,其中,数据格式信息与待处理数据的数据格式一致时,数据格式信息验证通过;或者,在待处理数据的数据格式要求包括多个数据格式时,可通过确定该数据格式信息是否满足待处理数据的数据格式要求的方式对数据格式信息的验证,其中,数据格式信息与待处理数据的数据格式一致时。例如,若服务器在接收到删除请求时,则无需对该删除请求对应的删除操作信息进行数据格式信息的验证,只需对该删除操作信息的操作权限进行验证即可;以修改操作为例,对该修改请求对应修改操作信息进行解析,可以得到待处理数据的标识信息,通过该标识信息可以得到待处理数据,其中,该待处理数据则包括修改的原数据(修改前的数据)以及该数据相邻的数据,对该修改操作信息的数据格式信息进行验证,即为对该操作信息解析得到的目标数据的格式信息进行验证,若该目标数据的格式信息与源数据的格式信息一致,则确定对该修改操作信息的数据格式信息验证通过,若该目标数据的格式信息与源数据的格式信息不一致,则需要对该目标数据的格式信息进行判断,判断该目标数据的格式是否符合目标修改位置数据格式的要求,当确定该目标数据的格式符合目标修改位置数据格式的要求时,则确定对该修改操作信息的数据格式信息验证通过。
步骤S2213,在所述数据格式信息验证通过时,解析获取到的所述授权信息。
在本实施例中,当对操作信息对应的数据格式信息验证通过时,获取该操作信息对应的授权信息,并对该授权信息进行解析,通过解析该授权信息可以得到该操作信息对应的操作权限;而后对该操作权限进行验证,当该操作权限验证通过时,即对操作信息的验证通过。
本实施例提出的数据操作方法,通过获取所述操作信息对应的数据格式信息,接着基于所述待处理数据,验证所述数据格式信息,而后在所述数据格式信息验证通过时,解析获取到的所述授权信息,实现了对操作信息对应的数据格式信息的验证,排除了数据格式不符合条件的不规范的操作信息,确保服务器能够提供更安全可靠的数据操作服务,同时,也提高了服务器处理效率。
基于第一实施例,提出本申请数据操作方法的第五实施例,在本实施例中,步骤S2000包括:
步骤S2300,在所述操作信息验证未通过时,获取所述操作信息对应的验证失败信息;
在本实施例中,当对操作信息的验证未通过时,则需要获取该操作信息对应的验证失败信息,并将该验证失败信息反馈至客户端;对于操作信息的验证分别包括对操作权限的验证以及对操作信息对应数据格式信息的验证;在对该操作信息对应的操作权限进行验证时,基于待处理数据,若操作请求所对应的调用方无权限请求服务器执行该操作,或该调用方无对该待处理数据请求执行对应操作的权限,则表示对该操作信息对应的操作权限的验证失败,获取此次验证失败的原因,该原因即为该调用方无请求执行该操作的权限或该调用方无对该待处理数据进行对应操作的权限,将此次验证失败信息(验证失败的原因)反馈至客户端;在对该操作信息对应的数据格式信息进行验证时,基于待处理数据,若该操作信息对应的数据格式信息与目标操作位置的数据格式信息要求不符合,则表示对该操作信息对应的数据格式信息的验证失败,获取此次验证失败的原因,该原因即为该操作信息对应的数据格式信息不符合要求,将此次验证失败信息(验证失败的原因)反馈至客户端;上述对操作信息的操作权限的验证与对数据格式信息的验证,任一个验证条件验证失败时,均表示此次对该操作信息的验证失败。
步骤S2400,反馈所述验证失败信息至所述客户端。
在本实施例中,在获取到验证失败信息时,需要反馈该验证失败信息至对应的客户端,具体地,所述验证失败信息则具体包括,对操作权限的验证失败信息以及对数据格式信息的验证失败信息,其中,对操作权限的验证失败信息则包括操作请求对应的调用方无请求对应服务器执行该操作的权限,以及该操作请求对应的调用方无对该待处理数据进行对应操作的权限;对数据格式信息的验证失败信息则包括该操作信息对应的数据格式信息与目标操作位置的数据格式信息要求不符合;在对授权信息的验证失败时,反馈对应的上述失败信息至客户端。
本实施例提出的数据操作方法,通过在所述操作信息验证未通过时,获取所述操作信息对应的验证失败信息,接着反馈所述验证失败信息至所述客户端,实现了在对操作信息的验证失败时,对该验证失败信息的反馈,使得客户端对应的调用方能够清楚的知道验证失败的原因,在该调用方再次发送相关操作请求至服务器时,则可以避免这些造成验证失败的错误,提高服务器提供数据操作服务时的服务效率。
基于第一实施例,提出本申请数据操作方法的第六实施例,在本实施例中,在步骤S4000之后,该数据操作方法包括:
步骤S5000,在所述脚本程序运行完成时,获取对所述待处理数据处理完成后的数据;
在本实施例中,通过运行所述操作信息对应的脚本程序可以实现所述操作请求对应的操作,如运行插入操作信息对应的脚本程序即可实现在目标位置插入数据的操作;当所述脚本程序运行完成时,还需要获取对待处理数据处理完成后的数据,即对该操作请求对应的操作执行完成时,获取该操作执行后的数据结果,如在执行插入操作时,运行该插入操作对应的脚本程序,在该脚本程序运行完成时,获取插入数据后目标位置的数据,如在目标表的数据55与57之间插入数据56,其中56为待插入数据,在插入数据56之前,该表数据顺序为55、57,在该插入请求对应的脚本程序运行完成时,该表数据顺序则为55、56、57,该插入56后的数据结果55、56、57即为对待处理数据处理完成后的数据。
步骤S6000,基于所述处理完成后的数据,判断是否成功执行所述操作请求对应的操作;
在本实施例中,脚本程序在运行完成时,可能不一定能够实现操作请求对应的操作,譬如在脚本程序的运行过程中,数据的丢失,或数据命令的执行错误,或系统故障均有可能造成在脚本程序运行完成时,无法实现该操作请求对应的操作,因此,在脚本程序运行完成时,通过获取对待处理数据处理完成之后的数据,可以判断此次操作请求对应的操作是否被成功执行;如上述在目标表的55、57之间插入数据56,通过判断执行插入请求后的目标表该位置的数据是否已经变为55、56、57,则可以判断此次插入操作是否被成功执行,若在脚本程序运行完成时,获取对该插入操作执行后的结果,该插入请求对应的目标表该位置的数据为55、57或55、57、56,则可以确定该次插入操作执行失败。
步骤S7000,在成功执行所述操作请求对应的操作时,反馈处理成功信息至所述客户端。
在本实施例中,通过获取对待处理数据处理完成后的数据,对该次操作请求对应的操作是否被成功执行进行判断,当确定此次操作请求对应的操作被成功执行时,则反馈处理成功的信息至客户端,同样,在对该操作请求对应的操作执行失败时,反馈处理失败的信息至客户端。
本实施例提出的数据操作方法,通过在所述脚本程序运行完成时,获取对所述待处理数据处理完成后的数据,接着基于所述处理完成后的数据,判断是否成功执行所述操作请求对应的操作,而后在成功执行所述操作请求对应的操作时,反馈处理成功信息至所述客户端,通过对操作请求是否被成功执行的判断,提高了脚本程序的运行效率与服务器的处理效率,降低了技术应用门槛。
基于第一实施例,提出本申请数据操作方法的第七实施例,在本实施例中,步骤S1000包括:
步骤S1100,在接收到客户端发送的操作申请指令时,生成所述操作申请指令对应的操作编辑界面,并发送所述操作编辑界面至所述客户端;
在本实施例中,服务器在接收到客户端发送的操作申请指令时,则生成该操作申请指令对应的操作编辑界面,并将该操作编辑界面发送至对应的客户端,调用方可基于该操作编辑界面编辑对应的操作信息,不同操作请求对应的操作编辑界面不一样,若为插入请求时,则该插入操作编辑界面包括待插入数据及该待插入数据插入的目标位置和/或待处理数据的标识信息等信息;若为删除请求时,则删除操作编辑界面包括:删除数据的目标位置和/或待处理数据的标识信息等信息;若为修改请求时,则修改操作编辑界面包括:目标数据及目标位置和/或待处理数据的标识信息等信息。
步骤S1200,在接收到所述客户端基于所述操作编辑界面触发的操作请求时,获取所述操作请求对应的操作信息。
在本实施例中,调用方基于该操作编辑界面编辑操作信息,在操作信息编辑完成时,调用方通过选择操作编辑界面的确认键确定对操作信息编辑完成,同时触发操作请求,客户端将该操作请求发送至对应的服务器,当服务器接收到该操作请求时,获取该操作请求对应的操作信息,其中,该操作信息即为调用方基于操作编辑界面编辑的操作信息,如插入请求对应的操作编辑界面的操作信息即为待插入数据及该待插入数据插入的目标位置和/或待处理数据的标识信息等信息;修改请求对应的操作编辑界面的操作信息即为目标数据及目标位置和/或待处理数据的标识信息等信息;删除请求对应的操作编辑界面的操作信息即为删除数据的目标位置和/或待处理数据的标识信息等信息。
具体地,以插入操作为例,当数据库所对应的服务器接收到由客户端发送的插入申请指令时,则生成一个该插入申请指令对应的操作编辑界面,并发送该插入操作编辑界面至客户端,调用方基于该插入操作编辑界面,编辑所要插入的数据(即待插入数据)及该待插入数据插入的目标位置等基本插入信息,该操作信息即包括上述的基本插入信息,并可通过选择操作编辑界面的确认键确定对操作信息编辑完成,同时触发操作请求,客户端在接收到基于该确认键触发的插入请求时,将该插入请求发送至服务器,当服务器接收到由客户端发送的插入请求时,则获取该插入请求对应的操作信息;删除及修改等操作与该插入操作的步骤类似,在此不再赘述。
本实施例提出的数据操作方法,通过在接收到客户端发送的操作申请指令时,生成所述操作申请指令对应的操作编辑界面,并发送所述操作编辑界面至所述客户端,接着在接收到所述客户端基于所述操作编辑界面触发的操作请求时,获取所述操作请求对应的操作信息,实现了调用方基于客户端的操作编辑界面与服务器之间的联系,使得服务器能够准确接收到调用方基于客户端操作编辑界面发送的操作请求,更好地并且更准确地提供操作请求对应的数据操作服务。
此外,为实现上述目的,本申请还提供一种数据操作装置,数据操作装置包括:
第一获取模块,用于在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
验证模块,用于对获取到的所述操作信息进行验证操作;
第二获取模块,用于在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系;
运行模块,用于基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
进一步的,验证模块包括:
获取子模块,用于获取所述操作信息对应的授权信息以及待处理数据;
验证子模块,用于基于所述授权信息及所述待处理数据,验证所述操作信息。
进一步的,验证子模块包括:
解析单元,用于解析获取到的所述授权信息,以获得所述操作信息对应的操作权限;
验证单元,用于基于所述待处理数据,验证所述操作权限,其中,在对所述操作权限验证通过时,所述操作信息验证通过。
进一步的,解析单元包括:
获取子单元,用于获取所述操作信息对应的数据格式信息;
验证子单元,用于基于所述待处理数据,验证所述数据格式信息;
解析子单元,用于在所述数据格式信息验证通过时,解析获取到的所述授权信息。
此外,为实现上述目的,本申请还提供一种计算机可读存储介质,所述计算机可读存储介质上存储有数据操作程序,所述数据操作程序被所述处理器执行时实现上述数据操作方法的步骤。
其中,数据操作程序被执行时所实现的方法可参照本申请数据操作方法的各个实施例,此处不再赘述。
需要说明的是,在本文中,术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、方法、物品或者系统不仅包括那些要素,而且还包括没有明确列出的其他要素,或者是还包括为这种过程、方法、物品或者系统所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括该要素的过程、方法、物品或者系统中还存在另外的相同要素。
上述本申请实施例序号仅仅为了描述,不代表实施例的优劣。
通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件,但很多情况下前者是更佳的实施方式。基于这样的理解,本申请的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品存储在如上所述的一个存储介质(如ROM/RAM、磁碟、光盘)中,包括若干指令用以使得一台终端设备(可以是手机,计算机,服务器,空调器,或者网络设备等)执行本申请各个实施例所述的方法。
以上仅为本申请的优选实施例,并非因此限制本申请的专利范围,凡是利用本申请说明书及附图内容所作的等效结构或等效流程变换,或直接或间接运用在其他相关的技术领域,均同理包括在本申请的专利保护范围内。

Claims (20)

  1. 一种数据操作方法,其特征在于,所述数据操作方法包括:
    在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
    对获取到的所述操作信息进行验证操作;
    在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系;
    基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
  2. 如权利要求1所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  3. 如权利要求1所述的数据操作方法,其特征在于,所述对获取到的所述操作信息进行验证操作的步骤包括:
    获取所述操作信息对应的授权信息以及待处理数据;
    基于所述授权信息及所述待处理数据,验证所述操作信息。
  4. 如权利要求3所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  5. 如权利要求3所述的数据操作方法,其特征在于,所述基于所述授权信息及所述待处理数据,验证所述操作信息的步骤包括:
    解析获取到的所述授权信息,以获得所述操作信息对应的操作权限;
    基于所述待处理数据,验证所述操作权限,其中,在对所述操作权限验证通过时,所述操作信息验证通过。
  6. 如权利要求5所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  7. 如权利要求5所述的数据操作方法,其特征在于,所述解析获取到的所述授权信息的步骤包括:
    获取所述操作信息对应的数据格式信息;
    基于所述待处理数据,验证所述数据格式信息;
    在所述数据格式信息验证通过时,解析获取到的所述授权信息。
  8. 如权利要求7所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  9. 如权利要求1所述的数据操作方法,其特征在于,所述对获取到的所述操作信息进行验证操作的步骤包括:
    在所述操作信息验证未通过时,获取所述操作信息对应的验证失败信息;
    反馈所述验证失败信息至所述客户端。
  10. 如权利要求9所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  11. 如权利要求1所述的数据操作方法,其特征在于,所述基于所述操作信息中的参数信息运行所述脚本程序的步骤之后,所述数据操作方法还包括:
    在所述脚本程序运行完成时,获取对所述待处理数据处理完成后的数据;
    基于所述处理完成后的数据,判断是否成功执行所述操作请求对应的操作;
    在成功执行所述操作请求对应的操作时,反馈处理成功信息至所述客户端。
  12. 如权利要求11所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  13. 如权利要求1所述的数据操作方法,其特征在于,所述在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息的步骤包括:
    在接收到客户端发送的操作申请指令时,生成所述操作申请指令对应的操作编辑界面,并发送所述操作编辑界面至所述客户端;
    在接收到所述客户端基于所述操作编辑界面触发的操作请求时,获取所述操作请求对应的操作信息。
  14. 如权利要求13所述的数据操作方法,其特征在于,所述操作请求包括插入请求、删除请求及修改请求,所述操作类型包括插入类型、删除类型及修改类型。
  15. 一种数据操作装置,其特征在于,所述数据操作装置包括:
    第一获取模块,用于在接收到客户端发送的操作请求时,获取所述操作请求对应的操作信息;
    验证模块,用于对获取到的所述操作信息进行验证操作;
    第二获取模块,用于在所述操作信息验证通过时,获取所述操作信息对应的操作类型,并在预设数据库中获取所述操作类型对应的脚本程序,其中,所述操作信息与所述操作类型是多对一的关系;
    运行模块,用于基于所述操作信息中的参数信息运行所述脚本程序,以对所述操作请求对应的待处理数据执行对应的操作。
  16. 如权利要求15所述的数据操作装置,其特征在于,所述验证模块包括:
    获取子模块,用于获取所述操作信息对应的授权信息以及待处理数据;
    验证子模块,用于基于所述授权信息及所述待处理数据,验证所述操作信息。
  17. 如权利要求16所述的数据操作装置,其特征在于,所述验证子模块包括:
    解析单元,用于解析获取到的所述授权信息,以获得所述操作信息对应的操作权限;
    验证单元,用于基于所述待处理数据,验证所述操作权限,其中,在对所述操作权限验证通过时,所述操作信息验证通过。
  18. 如权利要求17所述的数据操作装置,其特征在于,所述解析单元包括:
    获取子单元,用于获取所述操作信息对应的数据格式信息;
    验证子单元,用于基于所述待处理数据,验证所述数据格式信息;
    解析子单元,用于在所述数据格式信息验证通过时,解析获取到的所述授权信息。
  19. 一种数据操作装置,其特征在于,所述数据操作装置包括:存储器、处理器及存储在所述存储器上并可在所述处理器上运行的数据操作程序,所述数据操作程序被所述处理器执行时实现如权利要求1所述的数据操作方法的步骤。
  20. 一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有数据操作程序,所述防止数据操作程序被处理器执行时实现如权利要求1所述的数据操作方法的步骤。
PCT/CN2018/074614 2017-07-31 2018-01-30 数据操作方法、装置及计算机可读存储介质 WO2019024472A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710645107.5A CN107656722B (zh) 2017-07-31 2017-07-31 数据操作方法、装置及计算机可读存储介质
CN201710645107.5 2017-07-31

Publications (1)

Publication Number Publication Date
WO2019024472A1 true WO2019024472A1 (zh) 2019-02-07

Family

ID=61128324

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/074614 WO2019024472A1 (zh) 2017-07-31 2018-01-30 数据操作方法、装置及计算机可读存储介质

Country Status (2)

Country Link
CN (1) CN107656722B (zh)
WO (1) WO2019024472A1 (zh)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109063180A (zh) * 2018-08-23 2018-12-21 郑州云海信息技术有限公司 一种数据处理方法、装置、设备及计算机可读存储介质
CN111367500A (zh) * 2018-12-26 2020-07-03 顺丰科技有限公司 数据的处理方法和装置
CN110443062A (zh) * 2019-06-17 2019-11-12 平安科技(深圳)有限公司 多租户数据库的操作方法、装置和计算机设备
CN111782670A (zh) * 2020-06-29 2020-10-16 中国工商银行股份有限公司 数据资源操作自动处理的方法及装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104516908A (zh) * 2013-09-29 2015-04-15 华为技术有限公司 一种数据库访问方法和装置
CN105893445A (zh) * 2015-12-15 2016-08-24 乐视网信息技术(北京)股份有限公司 数据处理的方法、服务器和终端设备
CN105930138A (zh) * 2015-12-25 2016-09-07 中国银联股份有限公司 一种消息处理方法及装置
CN106202373A (zh) * 2016-07-08 2016-12-07 青岛海信传媒网络技术有限公司 多终端数据处理方法及数据服务器

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090070743A1 (en) * 2007-09-10 2009-03-12 Unisys Corporation System and method for analyzing software applications
CN104216907B (zh) * 2013-06-02 2018-12-18 上海诺基亚贝尔股份有限公司 一种用于提供数据库访问控制的方法、装置与系统
CN104267932B (zh) * 2014-08-12 2017-11-07 广州华多网络科技有限公司 数据库操作方法、装置及服务器
CN106934272B (zh) * 2017-02-09 2021-09-07 北京奇虎科技有限公司 一种应用信息的校验方法和装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104516908A (zh) * 2013-09-29 2015-04-15 华为技术有限公司 一种数据库访问方法和装置
CN105893445A (zh) * 2015-12-15 2016-08-24 乐视网信息技术(北京)股份有限公司 数据处理的方法、服务器和终端设备
CN105930138A (zh) * 2015-12-25 2016-09-07 中国银联股份有限公司 一种消息处理方法及装置
CN106202373A (zh) * 2016-07-08 2016-12-07 青岛海信传媒网络技术有限公司 多终端数据处理方法及数据服务器

Also Published As

Publication number Publication date
CN107656722A (zh) 2018-02-02
CN107656722B (zh) 2019-03-12

Similar Documents

Publication Publication Date Title
WO2019024472A1 (zh) 数据操作方法、装置及计算机可读存储介质
WO2019119771A1 (zh) 语音交互方法、装置及计算机可读存储介质
WO2013131444A1 (zh) 分享内容的方法、终端、服务器及系统、计算机存储介质
WO2017190450A1 (zh) 进程关闭方法及装置
WO2017028601A1 (zh) 智能终端的语音控制方法、装置及电视机系统
WO2018205545A1 (zh) 数据生成方法、装置、终端及计算机可读存储介质
WO2018227880A1 (zh) 数据比对方法、装置、设备及可读存储介质
WO2017201913A1 (zh) 一种精准语音控制方法及装置
WO2017041538A1 (zh) 终端用户界面的受控显示方法及装置
WO2014000635A1 (zh) 阅读器提供服务的方法、阅读器、终端及计算机存储介质
WO2017063366A1 (zh) 应用启动方法和系统
WO2017000729A1 (zh) 音视频播放控制方法和装置
WO2019051902A1 (zh) 终端控制方法、空调器及计算机可读存储介质
WO2019161597A1 (zh) 基于即时通讯的信息发送方法、装置、设备和存储介质
WO2017036209A1 (zh) 基于智能电视的音频数据播放方法、智能电视及系统
WO2015058570A1 (zh) 自动识别网络运营商以实现数据配置的方法及装置
WO2018053963A1 (zh) 智能电视的系统升级方法及装置
WO2015144052A1 (en) Method and apparatus for collecting statistics on network information
WO2019062109A1 (zh) 磁盘阵列的挂载方法、Android设备和存储介质
WO2019085301A1 (zh) 座机未接来电的反馈方法、装置、设备及可读存储介质
WO2017059686A1 (zh) 桌面显示方法及装置
WO2019080401A1 (zh) 脚本语句转换方法、装置及计算机可读存储介质
WO2019227564A1 (zh) 通讯信息的展示方法、用户设备、存储介质及装置
WO2018205534A1 (zh) 体感遥控器控制方法、智能终端及计算机可读存储介质
WO2016206223A1 (zh) 截图的方法及系统

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18840878

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 18840878

Country of ref document: EP

Kind code of ref document: A1

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 04.08.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 18840878

Country of ref document: EP

Kind code of ref document: A1