CN108133008B - Method, device, equipment and storage medium for processing service data in database - Google Patents
Method, device, equipment and storage medium for processing service data in database Download PDFInfo
- Publication number
- CN108133008B CN108133008B CN201711405962.5A CN201711405962A CN108133008B CN 108133008 B CN108133008 B CN 108133008B CN 201711405962 A CN201711405962 A CN 201711405962A CN 108133008 B CN108133008 B CN 108133008B
- Authority
- CN
- China
- Prior art keywords
- audit
- service data
- request
- auditing
- database
- Prior art date
- Legal status (The legal status 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 status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Databases & Information Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method and a device for processing service data in a database, computer equipment and a storage medium. The method for processing the service data in the database comprises the following steps: receiving a service data processing request; generating an auditing request according to the service data processing request; sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request; receiving an auditing result broadcasted by an auditing node; inquiring an audit result corresponding to the audit request in a database; the verification node writes the broadcast verification result into the database after receiving the broadcast verification result; and when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request. By implementing the method, the auditing time is greatly reduced on the premise of realizing the safety similar to that of offline auditing, and the efficiency of processing the service data is further improved.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a method and an apparatus for processing service data in a database, a computer device, and a computer-readable storage medium.
Background
At present, the traditional offline paper office relies on paper documents to record business data, and the paper documents are limited by paper, so that the convenience is poor, manual classification and retrieval of the paper documents are needed manually, a large amount of manpower, material resources and financial resources are consumed, and the paper documents are limited by the storage environment of the paper documents, so that the paper documents are troublesome to access. Under the condition that the number of the staffs is large, in order to ensure that the staffs can work more efficiently, the working efficiency of the staffs can be greatly improved through online electronic office work of a business system.
However, since a lot of service data are recorded in the database of the service system, in order to ensure the security of the service data, an offline auditing manner is still adopted, and offline auditing usually consumes a lot of time, so that the efficiency is very low.
Disclosure of Invention
Based on this, it is necessary to provide a method, an apparatus, a computer device, and a computer-readable storage medium for processing business data in a database, aiming at the problem that offline auditing usually takes a lot of time, resulting in low efficiency.
A method for processing business data in a database, the method comprising:
receiving a service data processing request;
generating an auditing request according to the service data processing request;
sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request;
receiving an auditing result broadcasted by the auditing node;
inquiring an audit result corresponding to the audit request in a database; the verification result in the database is written into the database after the verification node receives the broadcast verification result;
and when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request.
In one embodiment, the processing the service data in the database according to the service data processing request includes:
extracting configuration information from the service data processing request;
retrieving service data according to the configuration information;
removing invalid service data from the retrieved service data to obtain valid service data;
and processing the effective service data according to the service data processing request.
In one embodiment, the configuration information includes a business keyword and a corresponding keyword type;
the retrieving of the service data according to the configuration information includes:
and respectively retrieving the service data according to each service keyword and the corresponding keyword type.
In one embodiment, when the service data processing request is a service data modification request, the processing the valid service data according to the service data processing request includes:
writing the effective service data into a data cache region;
modifying the effective service data according to the service data processing request to obtain modified service data;
and covering the modified service data with corresponding service data in the database.
In one embodiment, the querying a database for an audit result corresponding to the audit request includes:
searching the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database;
and inquiring an auditing result corresponding to the auditing request from the longest block chain.
In one embodiment, the sending the audit request to an audit node includes:
broadcasting the audit request to send the audit request to a verification node and a designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for indicating the verification node to write the audit result of the appointed audit node into the database.
In one embodiment, the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the node identifiers forms an audit chain; and the audit chain is used for indicating the plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the plurality of node identifications.
An apparatus for processing business data in a database, the apparatus comprising:
the receiving module is used for receiving a service data processing request;
the request generating module is used for generating an auditing request according to the service data processing request;
the sending module is used for sending the auditing request to an auditing node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request;
the receiving module is further configured to receive an audit result broadcasted by the audit node;
the query module is used for querying the audit result corresponding to the audit request in a database; the verification result in the database is written into the database after the verification node receives the broadcast verification result;
and the data processing module is used for processing the service data in the database according to the service data processing request when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed.
A computer-readable storage medium, storing a computer program which, when executed by a processor, causes the processor to perform the steps of the method as claimed in any one of the above.
A computer device comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the method of any one of the above.
According to the method and the device for processing the service data in the database, the computer equipment and the computer readable storage medium, after the service data processing request is received, the auditing request is generated according to the service data processing request, and is sent to the auditing node so as to receive the auditing result broadcasted by the auditing node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
Drawings
FIG. 1 is a diagram of an exemplary implementation of a method for processing business data in a database;
FIG. 2 is a flowchart illustrating a method for processing business data in a database according to an embodiment;
FIG. 3 is a flow chart illustrating a method for processing business data in a database according to another embodiment;
FIG. 4 is a block diagram of an exemplary embodiment of a device for processing business data in a database;
FIG. 5 is a schematic structural diagram of a device for processing business data in a database in another embodiment;
FIG. 6 is a schematic diagram showing a structure of a device for processing business data in a database according to still another embodiment;
FIG. 7 is a diagram showing an internal configuration of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
Fig. 1 is an application environment diagram of a method for processing service data in a database in an embodiment. Referring to fig. 1, the method for processing the service data in the database is applied to a system for processing the service data in the database. The processing system of the service data in the database comprises a terminal 110, a service server 120, a database server 130, an auditing node 140 and a verifying node 150. The database server 130 runs a database thereon. The terminal 110 and the service server 120 are connected through a network. The service server 120, the database server 130, the auditing node 140 and the verifying node 150 may be connected to each other via a network or via cables. The terminal 110 may specifically be a desktop terminal or a mobile terminal, and the mobile terminal may specifically be at least one of a mobile phone, a tablet computer, a notebook computer, and the like. The service server 120, the auditing node 140, and the verifying node 150 may be implemented as separate servers or as a server cluster of multiple servers.
Specifically, the service server 120 receives a service data processing request sent by the terminal 110, generates an audit request according to the service data, and sends the audit request to the audit node 140. After the audit node 140 audits the audit request and broadcasts the corresponding audit result, the service server 120 receives the audit result broadcast by the audit node 140. The service server 120 further queries an audit result corresponding to the audit request in the database server 130, wherein the audit result in the database server 130 is written after the verification node 150 receives the broadcasted audit result. When the inquired auditing result is matched with the received auditing result and the auditing result indicates that the auditing is passed, the service server 120 processes the service data in the database server 130 according to the service data processing request.
As shown in fig. 2, in one embodiment, a method for processing business data in a database is provided. The embodiment is mainly illustrated by applying the method to the service server 120 in fig. 1. Referring to fig. 2, the method for processing the service data in the database specifically includes the following steps:
s202, receiving a service data processing request.
Wherein, the service data processing request is information requesting to process the service data. The service data processing request may specifically be information requesting to derive the service data, or may be a request requesting to modify the service data. The service data may be at least one of service starting time, service establishment creating time, service allocation status, service month, main extension mechanism and whether to be unified, or may be commission proportion, intermediary agency mechanism and intermediary basic data.
In one embodiment, the service server establishes a connection with the terminal, and receives a service data processing request sent by the terminal after determining that the user identity corresponding to the terminal is valid.
And S204, generating an auditing request according to the service data processing request.
The auditing request is information requesting auditing of the business data processing request. The audit request may include data corresponding to the service data processing request, may also include summary information generated according to the service data processing request, and may also not include data related to the service data processing request.
In one embodiment, the service server analyzes the service data processing request to obtain summary information of the service data and an operation identifier for processing the service data, and writes the summary information into the audit request after generating the summary information according to the obtained summary information and the operation identifier; summary information is information of summary information, for example, service data corresponding to a service data processing request includes service establishment creation time, service assignment status, service month, and the like, and the corresponding summary information may be "service data of october.
S206, sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request.
And the auditing node is a node for auditing according to the auditing request. The auditing node audits the auditing request, specifically, whether the auditing request and the corresponding service data processing request are matched with the auditing passing condition is judged, or the auditing request and the corresponding service data processing request are sent to the display device so as to receive the auditing result sent by the input device. The broadcasting of the corresponding audit result may specifically be that the audit result is broadcast in an intranet where the audit node is located, and a computer device in the intranet and connected to a communication line with the audit node may receive the broadcast audit result. Broadcast is a transmission mode in which when data is transmitted in a computer network, the destination address is all devices in the network.
In one embodiment, the service server sends an audit request to the audit node. And the auditing node instructs the service server to send a service data processing request according to the auditing request, and audits the received service data processing request.
In one embodiment, the service server sends an audit request to the audit node. And the auditing node analyzes the auditing request to obtain the summary information corresponding to the service data processing request, and broadcasts the auditing result in the intranet after the summary information is audited to obtain the auditing result.
And S208, receiving the auditing result broadcasted by the auditing node.
The receiving of the audit result broadcasted by the audit node may specifically be directly receiving the audit result broadcasted, may also be relayed by the computer device receiving the audit result broadcasted, and may also be directly sent to the service server by the audit node.
In one embodiment, after the audit node broadcasts the audit result in the intranet, the switch that receives the broadcast audit result transmits the audit result to the service server connected to the switch.
S210, inquiring an audit result corresponding to the audit request in a database; and the verification result in the database is written into the database after the verification node receives the broadcast verification result.
And the verification node is a node for verifying the auditing result. The verification node may be specifically configured to verify whether the audit result is safe, and may also be configured to verify whether the audit request is safe. A database is a repository that organizes, stores, and manages data according to a data structure. The database may be specifically configured to store business data, and may also be configured to process audit history, including audit requests and audit results. The verification node writes the broadcast verification result into the database after receiving the broadcast verification result, specifically, the verification node encrypts the verification result and writes the verification result into the database after verifying that the received verification result passes.
In one embodiment, after receiving the audit result broadcasted in the intranet, the verification node performs verification according to the audit request stored in the database, and if the verification is passed, writes the audit result into the database. And after receiving the audit result, the business server inquires the audit result corresponding to the audit request from the database within the preset time, and if the audit result corresponding to the audit request is not inquired within the preset time and/or is inquired outside the preset time, the business server judges that the audit result is unsafe.
S212, when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request.
The queried audit result is matched with the received audit result, specifically, the queried audit result is consistent with the received audit result, or the received audit result is consistent with the queried audit result after being converted into a format.
In one embodiment, if the audit result queried by the service server does not match the received audit result, an alarm instruction is generated to activate the firewall.
In an embodiment, when the audit result queried by the service server matches the received audit result, it is determined whether the audit result indicates pass. And if the verification result does not indicate passing, feeding back information of non-passing verification to the terminal.
In this embodiment, after receiving the service data processing request, an audit request is generated according to the service data processing request, and the audit request is sent to the audit node to receive an audit result broadcasted by the audit node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
In one embodiment, step S212 includes: extracting configuration information from the service data processing request; retrieving service data according to the configuration information; removing invalid service data from the retrieved service data to obtain valid service data; and processing effective service data according to the service data processing request.
Wherein the configuration information is information of settings required for retrieving the service data. The configuration information may specifically be specific service data, for example, the configuration information includes a standing service start time, and when the standing service start time is october-fiftieth day, service data corresponding to a service of the october-fiftieth day is retrieved according to the configuration information. The invalid service data may be repeated service data.
In one embodiment, the service server extracts configuration information from the service data processing request, retrieves corresponding service data from the database according to specific service data in the configuration information, removes redundant data from the service data to obtain effective service data, and processes the effective service data according to the service data processing request.
In one embodiment, after retrieving the valid service data according to the configuration information, the service server packages the valid service data to obtain a data packet corresponding to the valid service data, and then sends the data packet to the terminal.
In this embodiment, the service data is retrieved through the configuration information extracted from the service data processing request, and then the invalid service data is removed from the retrieved service data, so that valid data can be obtained, and the situation that the retrieved invalid service data is too much is avoided.
In one embodiment, the configuration information includes a business keyword and a corresponding keyword type; retrieving service data according to the configuration information, comprising: and respectively retrieving the service data according to each service keyword and the corresponding keyword type.
Wherein, the service key words are words of single service data. The keyword type is a type of the service data.
In one embodiment, after the service server searches the service data according to each service keyword and the corresponding keyword type, the service server compares the searched service data and deletes repeated service data to obtain effective service data.
In one embodiment, the service server processes the service data according to the service data processing request, and feeds back a processing result to the terminal. And the terminal acquires the service keywords and the corresponding keyword types again, regenerates the service data processing request according to the service keywords and the corresponding keyword types, and sends the regenerated service data processing request to the service server. And after receiving the service data processing request retransmitted by the terminal, the service server generates an audit request according to the retransmitted service data processing request so as to send the generated audit request to an audit node.
In the embodiment, the business data can be retrieved by respectively retrieving the business data according to each business keyword and the corresponding keyword type, so that the incomplete retrieved business data is avoided.
In one embodiment, when the service data processing request is a service data modification request, processing valid service data according to the service data processing request includes: writing the effective service data into a data cache region; modifying the effective service data according to the service data processing request to obtain modified service data; and covering the modified service data with corresponding service data in the database.
The data cache area is an area for caching data in the internal memory. And managing the cached data in the data cache region according to an LRU (Least recently used) algorithm, so as to retrieve unmodified service data from the data cache region after the modified service data covers corresponding service data in the database.
In one embodiment, the service server writes the valid service data into the data cache region, and eliminates unmodified service data from the data cache region after modifying the valid service data according to the service data modification request to obtain modified service data.
In one embodiment, the service server extracts the broker commission proportion from the service data processing request and modifies the broker commission proportion in the database based on the extracted broker commission proportion.
In this embodiment, by writing the valid service data into the data cache region, the unmodified service data can be retrieved after the service data in the database is modified and overwritten.
In one embodiment, querying a database for an audit result corresponding to the audit request includes: searching the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database; and inquiring the auditing result corresponding to the auditing request from the longest block chain.
The block chain is a chain data structure formed by combining data blocks in a sequential connection mode according to a time sequence, and is a distributed account book which is guaranteed in a cryptology mode and cannot be tampered and forged. The block chain may be specifically configured to store the audit request and the audit result. The longest blockchain is the most blockchain.
In one embodiment, the service server selects the longest block chain from the multiple databases, queries a block matched with the audit request in the selected block chain, and compares the received audit result according to the audit result in the block after querying the block.
In this embodiment, whether the received audit result is safe can be verified by searching the longest block chain in the block chain in which the audit result corresponding to the audit request is recorded in the database, and querying the audit result corresponding to the audit request in the longest block chain.
In one embodiment, sending an audit request to an audit node includes: broadcasting an audit request to send the audit request to a verification node and a designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for instructing the verification node to write the audit result of the designated audit node into the database.
The audit request is sent to a designated audit node, and specifically, the audit request carries a node identifier, so that the audit node matched with the node identifier can read the audit request. The verification node writes the verification result of the designated verification node into the database, specifically, the verification result may be written into a block of a block chain in the database.
In one embodiment, the service server broadcasts an audit request. And after receiving the audit request, the verification node generates a block according to the audit request and adds the generated block to the tail of the block chain in the corresponding database. And after receiving the audit request, the audit node extracts the node identifier in the audit request, if the node identifier is matched with the extracted node identifier, the audit node audits the received audit request to obtain an audit result, and broadcasts the audit result. After receiving the broadcast audit result, the verification node queries whether a block in the block chain in the database records an audit request matched with the audit result, if so, the verification node generates a block according to the audit result and adds the block to the tail of the block chain in the database.
In this embodiment, by broadcasting the audit request, the verification node can verify the audit request, so as to enhance the security of the audit process.
In one embodiment, the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the node identifiers forms an audit chain; and the audit chain is used for indicating a plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the node identifications.
Wherein, the audit chain is a plurality of node identifiers arranged in sequence. The audit chain is specifically used for instructing a plurality of designated audit nodes to process audit requests in sequence according to the sequence.
In one embodiment, after adding the audit chain to the service data processing request, the terminal sends the service data processing request to the service server. And the service server extracts the audit chain in the service data processing request, adds the audit chain in the audit request and broadcasts the audit request for adding the audit chain. And when the auditing node receives the broadcasted auditing request and matches with the auditing chain extracted from the auditing request, auditing the auditing request. And after the audit is finished, the corresponding node identification mark in the audit chain is audited, and a new audit request is generated for broadcasting.
In this embodiment, by sequentially processing the audit according to the sequence of the plurality of node identifiers in the audit chain, the audit effect can be enhanced, so that the audit effect is improved when the audit security is satisfied.
Fig. 3 is a flowchart illustrating a method for processing service data in a database according to an embodiment. The method for processing the service data in the database specifically comprises the following steps:
s302, the service server receives the service data processing request.
And S304, the service server generates an auditing request according to the service data processing request.
S306, the service server broadcasts the generated auditing request.
After the verification node receives the broadcasted audit request, the verification node performs step S308.
S308, the verification node writes the received audit request into a block of the block chain in the database.
After the auditing node receives the broadcasted auditing request, the auditing node executes step S310.
And S310, the auditing node audits the auditing request to obtain an auditing result.
And S312, the auditing node broadcasts the auditing result obtained by auditing.
After the verification node receives the broadcasted verification result, the verification node performs step S314.
And S314, the verification node verifies the verification result according to the verification request in the database.
And S316, after the verification node passes the verification result, writing the verification result into the block of the block chain in the database.
After the service server receives the broadcast verification result, the service server executes step S318.
And S318, the business server searches the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database.
S320, the business server inquires the auditing result corresponding to the auditing request from the longest block chain.
And S322, when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing result passes, the business server extracts the configuration information from the business data processing request.
S324, the service server retrieves the service data according to the configuration information.
S326, the service server removes invalid service data from the retrieved service data to obtain valid service data.
When the service data processing request is a service data export request, the service server performs step S328.
S328, the service server packs the valid service data into a data packet.
And S330, the service server sends the data packet to the terminal.
When the service data processing request is a service data modification request, the service server performs step S332.
S332, the service server writes the effective service data into the data cache region.
And S334, the service server modifies the effective service data according to the service data processing request to obtain modified service data.
And S336, the service server covers the modified service data with the corresponding service data in the database.
According to the method for processing the service data in the database, after the service data processing request is received, an audit request is generated according to the service data processing request, and the audit request is sent to the audit node so as to receive the audit result broadcasted by the audit node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
It should be understood that, although the steps in the flowchart of fig. 3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in fig. 3 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
As shown in fig. 4, in one embodiment, there is provided a processing apparatus 400 for business data in a database, the apparatus comprising: a receiving module 402, a request generating module 404, a sending module 406, a querying module 408 and a data processing module 410.
A receiving module 402, configured to receive a service data processing request.
A request generating module 404, configured to generate an audit request according to the service data processing request;
a sending module 406, configured to send the audit request to the audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request;
a receiving module 402, configured to receive an audit result broadcasted by an audit node;
the query module 408 is configured to query the database for an audit result corresponding to the audit request; the verification node writes the broadcast verification result into the database after receiving the broadcast verification result;
and the data processing module 410 is configured to, when the queried audit result matches the received audit result and the audit result indicates that the audit is passed, process the service data in the database according to the service data processing request.
After receiving the service data processing request, the processing device 400 for service data in the database generates an audit request according to the service data processing request, and sends the audit request to the audit node to receive the audit result broadcasted by the audit node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
As shown in fig. 5, in one embodiment, the data processing module 410 includes: an information extraction module 410a, configured to extract configuration information from the service data processing request; a data retrieving module 410b, configured to retrieve the service data according to the configuration information; the data removal module is used for removing invalid service data from the retrieved service data to obtain effective service data; and the valid data processing module 410c is configured to process valid service data according to the service data processing request.
In one embodiment, the configuration information includes a business keyword and a corresponding keyword type; the data retrieving module 410b is further configured to retrieve the service data according to each service keyword and the corresponding keyword type.
As shown in fig. 6, in an embodiment, when the service data processing request is a service data modification request, the data processing module 410 further includes: a data writing module 410d, configured to write valid service data into a data cache region; a data modification module 410e, configured to modify the valid service data according to the service data processing request, to obtain modified service data; and a data overwriting module 410f, configured to overwrite the modified service data with corresponding service data in the database.
In an embodiment, the query module 408 is further configured to search for the longest blockchain in the blockchains of the audit results corresponding to the audit request, which are recorded in the database; and inquiring the auditing result corresponding to the auditing request from the longest block chain.
In an embodiment, the sending module 406 is further configured to broadcast an audit request, so as to send the audit request to the verification node and the designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for instructing the verification node to write the audit result of the designated audit node into the database.
In one embodiment, the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the node identifiers forms an audit chain; and the audit chain is used for indicating a plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the node identifications.
In one embodiment, a computer device is provided, which may be a service server or a mobile terminal. When the computer device is a service server, its internal structure diagram may be as shown in fig. 7. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of processing business data in a database. Those skilled in the art will appreciate that the architecture shown in fig. 7 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, the processing device for the service data in the database provided by the present application may be implemented in the form of a computer program, and the computer program may be run on a computer device as shown in fig. 7. The memory of the computer device may store various program modules constituting the processing means of the business data in the database, such as the receiving module 402, the request generating module 404, the sending module 406, the querying module 408 and the data processing module 410 shown in fig. 4. The computer program formed by the program modules enables the processor to execute the steps of the method for processing the business data in the database of the embodiments of the application described in the specification.
A computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps of the method of: receiving a service data processing request; generating an auditing request according to the service data processing request; sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request; receiving an auditing result broadcasted by an auditing node; inquiring an audit result corresponding to the audit request in a database; the verification node writes the broadcast verification result into the database after receiving the broadcast verification result; and when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request.
After receiving the service data processing request, the computer device generates an audit request according to the service data processing request, and sends the audit request to the audit node so as to receive the audit result broadcasted by the audit node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
In one embodiment, the processor performs the step of processing the business data in the database according to the business data processing request, including: extracting configuration information from the service data processing request; retrieving service data according to the configuration information; removing invalid service data from the retrieved service data to obtain valid service data; and processing effective service data according to the service data processing request.
In one embodiment, the configuration information includes a business keyword and a corresponding keyword type; the processor performs the step of retrieving the service data according to the configuration information, including: and respectively retrieving the service data according to each service keyword and the corresponding keyword type.
In one embodiment, when the service data processing request is a service data modification request, the processor performs a step of processing valid service data according to the service data processing request, including: writing the effective service data into a data cache region; modifying the effective service data according to the service data processing request to obtain modified service data; and covering the modified service data with corresponding service data in the database.
In one embodiment, the processor executes the step of querying the database for the audit result corresponding to the audit request, including: searching the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database; and inquiring the auditing result corresponding to the auditing request from the longest block chain.
In one embodiment, the processor performs the step of sending an audit request to an audit node, comprising: broadcasting an audit request to send the audit request to a verification node and a designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for instructing the verification node to write the audit result of the designated audit node into the database.
In one embodiment, the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the node identifiers forms an audit chain; and the audit chain is used for indicating a plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the node identifications.
A computer-readable storage medium, storing a computer program which, when executed by a processor, causes the processor to perform the steps of the method of: receiving a service data processing request; generating an auditing request according to the service data processing request; sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request; receiving an auditing result broadcasted by an auditing node; inquiring an audit result corresponding to the audit request in a database; the verification node writes the broadcast verification result into the database after receiving the broadcast verification result; and when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request.
After receiving the service data processing request, the computer-readable storage medium generates an audit request according to the service data processing request, and sends the audit request to the audit node so as to receive the audit result broadcasted by the audit node. By auditing the service system, the auditing time is greatly reduced. And after receiving the audit result, inquiring the corresponding audit result of the audit request in the database, and processing the service data in the database according to the service data processing request when the inquired audit request is matched with the audit result and the audit result shows that the audit is passed. Since the audit result in the database is written in by the verification node after the verification node receives the broadcast audit result, the verification node verifies the audit result, so that the audit result written in the database can be ensured to be safe, and the received audit result can be ensured to be safe when the received audit result is matched with the audit result in the database. Therefore, on the premise of realizing safety similar to that of offline auditing, auditing time is greatly reduced, and the efficiency of processing service data is improved.
In one embodiment, the processor performs the step of processing the business data in the database according to the business data processing request, including: extracting configuration information from the service data processing request; retrieving service data according to the configuration information; removing invalid service data from the retrieved service data to obtain valid service data; and processing effective service data according to the service data processing request.
In one embodiment, the configuration information includes a business keyword and a corresponding keyword type; the processor performs the step of retrieving the service data according to the configuration information, including: and respectively retrieving the service data according to each service keyword and the corresponding keyword type.
In one embodiment, when the service data processing request is a service data modification request, the processor performs a step of processing valid service data according to the service data processing request, including: writing the effective service data into a data cache region; modifying the effective service data according to the service data processing request to obtain modified service data; and covering the modified service data with corresponding service data in the database.
In one embodiment, the processor executes the step of querying the database for the audit result corresponding to the audit request, including: searching the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database; and inquiring the auditing result corresponding to the auditing request from the longest block chain.
In one embodiment, the processor performs the step of sending an audit request to an audit node, comprising: broadcasting an audit request to send the audit request to a verification node and a designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for instructing the verification node to write the audit result of the designated audit node into the database.
In one embodiment, the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the node identifiers forms an audit chain; and the audit chain is used for indicating a plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the node identifications.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed. Any reference to memory, databases, or other media used in the embodiments provided herein may include non-volatile memory.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for processing business data in a database, the method comprising:
receiving a service data processing request;
generating an auditing request according to the service data processing request;
sending the audit request to an audit node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request;
receiving an auditing result broadcasted by the auditing node;
inquiring an audit result corresponding to the audit request in a database; the verification result in the database is written into the database after the verification node receives the broadcast verification result;
when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed, processing the service data in the database according to the service data processing request;
the querying, in the database, an audit result corresponding to the audit request includes:
searching the longest block chain in the block chains of the auditing results corresponding to the auditing request recorded in the database;
inquiring an auditing result corresponding to the auditing request from the longest block chain;
the processing the service data in the database according to the service data processing request comprises:
extracting configuration information from the service data processing request;
retrieving service data according to the configuration information;
removing invalid service data from the retrieved service data to obtain valid service data;
and processing the effective service data according to the service data processing request.
2. The method of claim 1, wherein the configuration information includes a service keyword and a corresponding keyword type;
the retrieving of the service data according to the configuration information includes:
and respectively retrieving the service data according to each service keyword and the corresponding keyword type.
3. The method according to claim 1, wherein when the service data processing request is a service data modification request, the processing the valid service data according to the service data processing request comprises:
writing the effective service data into a data cache region;
modifying the effective service data according to the service data processing request to obtain modified service data;
and covering the modified service data with corresponding service data in the database.
4. The method according to any one of claims 1 to 3, wherein the sending the audit request to an audit node comprises:
broadcasting the audit request to send the audit request to a verification node and a designated audit node; the audit request is used for indicating the appointed audit node to carry out audit according to the audit request; the audit request is also used for indicating the verification node to write the audit result of the appointed audit node into the database.
5. The method according to claim 4, wherein the audit request carries a plurality of node identifiers corresponding to a plurality of designated audit nodes, and the ordering of the plurality of node identifiers forms an audit chain; and the audit chain is used for indicating the plurality of appointed audit nodes to process the audit requests in sequence according to the sequence of the plurality of node identifications.
6. An apparatus for processing business data in a database, the apparatus comprising:
the receiving module is used for receiving a service data processing request;
the request generating module is used for generating an auditing request according to the service data processing request;
the sending module is used for sending the auditing request to an auditing node; the audit request is used for indicating the audit node to broadcast a corresponding audit result after the audit node audits the audit request;
the receiving module is further configured to receive an audit result broadcasted by the audit node;
the query module is used for querying the audit result corresponding to the audit request in a database; the verification result in the database is written into the database after the verification node receives the broadcast verification result;
the data processing module is used for processing the service data in the database according to the service data processing request when the inquired auditing result is matched with the received auditing result and the auditing result shows that the auditing is passed;
the query module is further configured to search for a longest block chain in the block chains in which the audit results corresponding to the audit request are recorded in the database; inquiring an auditing result corresponding to the auditing request from the longest block chain;
the data processing module further comprises:
the information extraction module is used for extracting configuration information from the service data processing request;
the data retrieval module is used for retrieving the service data according to the configuration information;
the data removal module is used for removing invalid service data from the retrieved service data to obtain effective service data;
and the effective data processing module is used for processing the effective service data according to the service data processing request.
7. The apparatus of claim 6, wherein the configuration information comprises a service keyword and a corresponding keyword type;
the data retrieval module is also used for respectively retrieving the service data according to each service keyword and the corresponding keyword type.
8. The apparatus of claim 6, wherein when the service data processing request is a service data modification request, the data processing module further comprises:
the data writing module is used for writing the effective service data into a data cache region;
the data modification module is used for modifying the effective service data according to the service data processing request to obtain modified service data;
and the data covering module is used for covering the modified service data with the corresponding service data in the database.
9. A computer-readable storage medium, storing a computer program which, when executed by a processor, causes the processor to carry out the steps of the method according to any one of claims 1 to 5.
10. A computer device comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711405962.5A CN108133008B (en) | 2017-12-22 | 2017-12-22 | Method, device, equipment and storage medium for processing service data in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711405962.5A CN108133008B (en) | 2017-12-22 | 2017-12-22 | Method, device, equipment and storage medium for processing service data in database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108133008A CN108133008A (en) | 2018-06-08 |
| CN108133008B true CN108133008B (en) | 2020-11-03 |
Family
ID=62391621
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711405962.5A Active CN108133008B (en) | 2017-12-22 | 2017-12-22 | Method, device, equipment and storage medium for processing service data in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108133008B (en) |
Families Citing this family (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109271559A (en) * | 2018-08-21 | 2019-01-25 | 平安科技（深圳）有限公司 | It modifies method, apparatus and electronic equipment to data in block chain |
| CN109409836A (en) * | 2018-10-23 | 2019-03-01 | 网易（杭州）网络有限公司 | Data application processing method and device, electronic equipment, storage medium |
| CN109814923B (en) * | 2018-12-28 | 2024-05-10 | 平安科技（深圳）有限公司 | Data processing method, device, computer equipment and storage medium |
| CN111385129A (en) * | 2018-12-29 | 2020-07-07 | 广州市百果园信息技术有限公司 | Globalization content auditing method and device, computer equipment and storage medium |
| CN109919569A (en) * | 2019-01-18 | 2019-06-21 | 深圳壹账通智能科技有限公司 | Checking method, device, storage medium and the electronic equipment of transregional piece of chain |
| CN109919573B (en) * | 2019-01-25 | 2024-05-10 | 平安科技（深圳）有限公司 | Data processing method and device and computer equipment |
| CN112348514A (en) * | 2019-03-19 | 2021-02-09 | 创新先进技术有限公司 | Block chain-based data checking system, method, computing device and storage medium |
| CN110147934A (en) * | 2019-04-17 | 2019-08-20 | 深圳壹账通智能科技有限公司 | Service request processing method, device, computer equipment and storage medium |
| CN110245186B (en) * | 2019-05-21 | 2023-04-07 | 深圳壹账通智能科技有限公司 | Service processing method based on block chain and related equipment |
| CN110213357B (en) * | 2019-05-22 | 2022-04-22 | 深圳壹账通智能科技有限公司 | Service data rollback method, device, computer equipment and storage medium |
| CN110347689A (en) * | 2019-07-12 | 2019-10-18 | 全链通有限公司 | Date storage method, equipment and computer readable storage medium |
| CN110705998A (en) * | 2019-09-02 | 2020-01-17 | 深圳壹账通智能科技有限公司 | Block chain based information auditing method and device, electronic equipment and storage medium |
| CN110601856B (en) * | 2019-09-24 | 2022-04-29 | 腾讯科技（深圳）有限公司 | Data interaction method and device based on block chain network |
| CN110795437B (en) * | 2019-11-04 | 2023-01-31 | 泰康保险集团股份有限公司 | Service processing method, system, device and computer readable storage medium |
| CN111460404A (en) * | 2020-03-04 | 2020-07-28 | 深圳壹账通智能科技有限公司 | Double-recording data processing method and device, computer equipment and storage medium |
| CN114726736B (en) * | 2020-12-18 | 2023-12-05 | 中国联合网络通信集团有限公司 | Data supervision method, first supervision node, supervised node and data supervision device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7426558B1 (en) * | 2000-05-11 | 2008-09-16 | Thomson Licensing | Method and system for controlling and auditing content/service systems |
| US9223624B2 (en) * | 2010-10-20 | 2015-12-29 | International Business Machines Corporation | Processing requests in a cloud computing environment |
| CN104796261A (en) * | 2015-04-16 | 2015-07-22 | 长安大学 | Secure access control system and method for network terminal nodes |
| CN107222482A (en) * | 2017-06-01 | 2017-09-29 | 黑龙江卓亚科技有限公司 | A kind of data management system and method based on compound block chain network |
-
2017
- 2017-12-22 CN CN201711405962.5A patent/CN108133008B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN108133008A (en) | 2018-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108133008B (en) | Method, device, equipment and storage medium for processing service data in database | |
| CN101849216B (en) | Method and apparatus for wireless digital content management | |
| CN110689349B (en) | Transaction hash value storage and searching method and device in blockchain | |
| CN103248684B (en) | Resource acquiring method and device in a kind of the Internet | |
| CN102725755B (en) | Method and system of file access | |
| CN105677904B (en) | Small documents storage method and device based on distributed file system | |
| CN109558378A (en) | File management method, device, equipment and storage medium | |
| CN112597337A (en) | Method, device, equipment and medium for viewing video monitoring content | |
| CN107194273A (en) | Can continuous-query data desensitization method and system | |
| CN112860642A (en) | Court trial data processing method, server and terminal | |
| US11138287B1 (en) | System for reducing size of transmitted content | |
| CN109271564A (en) | Declaration form querying method and equipment | |
| WO2022057525A1 (en) | Method and device for data retrieval, electronic device, and storage medium | |
| CN112000665A (en) | Data storage method of database | |
| JP2004145520A5 (en) | ||
| CN109213955B (en) | Data processing method and related equipment | |
| CN108881479B (en) | Integrated message queue and message management method | |
| CN110991358A (en) | Text comparison method and device based on block chain | |
| CN111563083B (en) | Report data query method, device and system | |
| CN114911869A (en) | Data and file storage system, method and device and electronic equipment | |
| CN114116710A (en) | Data processing method, device and equipment based on block chain and storage medium | |
| CN114443595A (en) | Method and device for processing file | |
| CN114201370A (en) | Webpage file monitoring method and system | |
| CN112347040A (en) | File management method, device, storage medium and terminal | |
| CN115129779A (en) | Database synchronization method, device and readable medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |