CN110347672A - Verification method and device, the electronic equipment and storage medium of tables of data related update - Google Patents
Verification method and device, the electronic equipment and storage medium of tables of data related update Download PDFInfo
- Publication number
- CN110347672A CN110347672A CN201910448154.XA CN201910448154A CN110347672A CN 110347672 A CN110347672 A CN 110347672A CN 201910448154 A CN201910448154 A CN 201910448154A CN 110347672 A CN110347672 A CN 110347672A
- Authority
- CN
- China
- Prior art keywords
- data
- primary data
- tables
- update
- business operation
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000012795 verification Methods 0.000 title claims abstract description 30
- 238000001514 detection method Methods 0.000 claims abstract description 30
- 238000010586 diagram Methods 0.000 claims description 24
- 230000004048 modification Effects 0.000 claims description 22
- 238000012986 modification Methods 0.000 claims description 22
- 238000004590 computer program Methods 0.000 claims description 7
- 241001269238 Data Species 0.000 claims description 2
- 230000006870 function Effects 0.000 claims 1
- 238000012360 testing method Methods 0.000 abstract description 7
- 238000004891 communication Methods 0.000 description 11
- 238000012545 processing Methods 0.000 description 8
- 238000005516 engineering process Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 230000005236 sound signal Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 2
- 230000000712 assembly Effects 0.000 description 2
- 238000000429 assembly Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005401 electroluminescence Methods 0.000 description 1
- 230000002045 lasting effect Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The present invention relates to contrast test technical fields, disclose the verification method and device, electronic equipment and storage medium of a kind of tables of data related update.The described method includes: obtaining the corresponding current data table of business operation in the database when detecting business operation and obtaining business operation corresponding first primary data in current data table；It obtains associated data table associated with current data table and obtains the second primary data to match with the first primary data in associated data table；The verifying scene for corresponding to current data table and associated data table is generated according to business operation；When the first primary data under verifying scene generates variation, whether the second primary data, which corresponds to verifying scene, is updated for detection；If so, determining that the update of associated data table is proved to be successful.By whether detecting the second primary data in the case where verifying scene as the variation of the first primary data is updated, to verify to the update of associated data table, verification efficiency and verifying accuracy rate are improved.
Description
Technical field
The present invention relates to Data cache technology field, in particular to a kind of the verification method and dress of tables of data related update
It sets, electronic equipment and storage medium.
Background technique
In project testing, to project carry out business operation can be related to the data in the tables of data to current database into
Row modification, still, a business not only influences current database, also will affect other databases, that is, current data
There are incidence relations between the tables of data in library and the tables of data of other databases, therefore, every time to current database tables of data
When data are modified, the corresponding data updated in associated data table associated with tables of data where the data are needed, also to keep away
Exempt from database and generates loss of data or data deviation.In practice, often by the way of manual verification, business operation is verified
Update is performed in accordance on associated data table to whether the modification that tables of data generates has.However, the mode efficiency of manual verification
Lowly, and the error rate of verifying is high, needs a kind of verification method of new tables of data related update.
Summary of the invention
In order to solve the problems, such as inefficiency existing for the verification method of traditional tables of data related update and error rate is high,
The present invention provides a kind of verification method of tables of data related update and devices, electronic equipment and storage medium.
First aspect of the embodiment of the present invention discloses a kind of verification method of tables of data related update, which comprises
When detecting business operation, the corresponding current data table of the business operation and acquisition are obtained in the database
The business operation corresponding first primary data in the current data table；
Obtain associated data table associated with the current data table and acquisition and institute in the associated data table
State the second primary data that the first primary data matches；
The verifying scene for corresponding to the current data table and the associated data table is generated according to the business operation；
Detection is under the verifying scene when the first primary data generation variation, if corresponds to the verifying scene
Update second primary data；
If so, determining that the update of the associated data table is proved to be successful.
Second aspect of the embodiment of the present invention discloses a kind of verifying device of tables of data related update, the tables of data association
The verifying device of update includes:
First acquisition unit, for it is corresponding current to obtain business operation in the database when detecting business operation
Tables of data and acquisition business operation corresponding first primary data in current data table；
Second acquisition unit, for obtaining associated data table associated with current data table and in associated data table
Obtain the second primary data to match with the first primary data；
Scene generation unit, for generating the verifying field for corresponding to current data table and associated data table according to business operation
Scape；
Authentication unit is updated, for detecting when the first primary data under verify scene generates and changes, if corresponding to testing
Demonstrate,prove the second primary data of scene update；
Determination unit is updated, the first primary data in the case where verifying scene is used for and corresponds to verifying the second initial number of scene update
According to when, determine that the update of associated data table is proved to be successful.
The third aspect of the embodiment of the present invention discloses a kind of electronic equipment, and the electronic equipment includes:
Processor；
Memory is stored with computer-readable instruction on the memory, and the computer-readable instruction is by the processing
When device executes, a kind of verification method of tables of data related update disclosed in first aspect of the embodiment of the present invention is realized.
Fourth aspect of the embodiment of the present invention discloses a kind of computer readable storage medium, stores computer program, institute
Stating computer program makes computer execute a kind of verifying of tables of data related update disclosed in first aspect of the embodiment of the present invention
Method.
The technical solution that the embodiment of the present invention provides can include the following benefits:
A kind of verification method of tables of data related update provided by the present invention includes the following steps: to grasp in the business that detects
When making, the corresponding current data table of business operation is obtained in the database and acquisition business operation is corresponding in current data table
The first primary data；It obtains associated data table associated with current data table and is obtained and first in associated data table
The second primary data that primary data matches；It is generated according to business operation and corresponds to testing for current data table and associated data table
Demonstrate,prove scene；When the first primary data under verifying scene generates variation, whether the second primary data corresponds to verifying scene for detection
It is updated；If so, determining that the update of associated data table is proved to be successful.
Under the method, by obtaining the corresponding verifying scene of business operation, and the second initial number is detected in the case where verifying scene
According to whether being updated with the variation of the first primary data, to be verified to the update of associated data table, improves and test
Demonstrate,prove efficiency and verifying accuracy rate.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited
Invention.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows and meets implementation of the invention
Example, and in specification together principle for explaining the present invention.
Fig. 1 is a kind of structural schematic diagram of the verifying device of tables of data related update disclosed by the embodiments of the present invention；
Fig. 2 is a kind of flow chart of the verification method of tables of data related update disclosed by the embodiments of the present invention；
Fig. 3 is the flow chart of the verification method of another tables of data related update disclosed by the embodiments of the present invention；
Fig. 4 is the structural schematic diagram of the verifying device of another tables of data related update disclosed by the embodiments of the present invention；
Fig. 5 is the structural schematic diagram of the verifying device of another tables of data related update disclosed by the embodiments of the present invention.
Specific embodiment
Here will the description is performed on the exemplary embodiment in detail, the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all embodiments consistented with the present invention.On the contrary, they be only with it is such as appended
The example of device and method being described in detail in claims, some aspects of the invention are consistent.
Implementation environment of the invention can be electronic equipment, such as tablet computer, desktop computer, terminal device.Electronics is set
Standby corresponding first primary data of involved business operation and the second primary data can be in the corresponding database of business operation
Any revisable data.
Fig. 1 is a kind of structural schematic diagram of the verifying device of tables of data related update disclosed by the embodiments of the present invention.Data
The verifying device 100 of table related update can be above-mentioned electronic equipment.As shown in Figure 1, the verifying device of tables of data related update
100 may include following one or more components: processing component 102, memory 104, power supply module 106, multimedia component
108, audio component 110, sensor module 114 and communication component 116.
The usual control data table related update of processing component 102 verifying device 100 integrated operation, such as with display,
Telephone call, data communication, camera operation and the associated operation of record operation etc..Processing component 102 may include one
Or multiple processors 118 execute instruction, to complete all or part of the steps of following methods.In addition, processing component 102 can
To include one or more modules, for convenient for the interaction between processing component 102 and other assemblies.For example, processing component 102
It may include multi-media module, for facilitate the interaction between multimedia component 108 and processing component 102.
Memory 104 is configured as storing various types of data to support the verifying device in tables of data related update
100 operation.The example of these data includes any application for operating on the verifying device 100 of tables of data related update
The instruction of program or method.Memory 104 can by any kind of volatibility or non-volatile memory device or they
Combination is realized, such as static random access memory (Static Random Access Memory, abbreviation SRAM), electric erasable
Programmable read only memory (Electrically Erasable Programmable Read-Only Memory, referred to as
EEPROM), Erasable Programmable Read Only Memory EPROM (Erasable Programmable Read Only Memory, abbreviation
EPROM), programmable read only memory (Programmable Red-Only Memory, abbreviation PROM), read-only memory
(Read-Only Memory, abbreviation ROM), magnetic memory, flash memory, disk or CD.It is also stored in memory 104
One or more modules are configured to be executed by the one or more processors 118 for the one or more module, to complete
All or part of step in method as follows.
Power supply module 106 provides electric power for the various assemblies of the verifying device 100 of tables of data related update.Power supply module
106 may include power-supply management system, one or more power supplys and other and the verifying device 100 for tables of data related update
Generate, manage, and distribute the associated component of electric power.
Multimedia component 108 includes that offer one between the verifying device 100 of tables of data related update and user is defeated
The screen of outgoing interface.In some embodiments, screen may include liquid crystal display (Liquid Crystal Display, letter
Claim LCD) and touch panel.If screen includes touch panel, screen may be implemented as touch screen, from the user to receive
Input signal.Touch panel includes one or more touch sensors to sense the gesture on touch, slide, and touch panel.Touching
The boundary of a touch or slide action can not only be sensed by touching sensor, but also be detected relevant lasting to touch or slide
Time and pressure.Screen can also include display of organic electroluminescence (Organic Light Emitting Display, letter
Claim OLED).
Audio component 110 is configured as output and/or input audio signal.For example, audio component 110 includes a Mike
Wind (Microphone, abbreviation MIC), when the verifying device 100 of tables of data related update is in operation mode, as call model,
When logging mode and speech recognition mode, microphone is configured as receiving external audio signal.The received audio signal can be with
It is further stored in memory 104 or is sent via communication component 116.In some embodiments, audio component 110 further includes
One loudspeaker is used for output audio signal.
Sensor module 114 includes one or more sensors, for mentioning for the verifying device 100 of tables of data related update
For the status assessment of various aspects.For example, sensor module 114 can detecte the verifying device 100 of tables of data related update
Open/close state, the relative positioning of component, sensor module 114 can be filled with the verifying of detection data table related update
Set the position change of verifying 100 1 components of device of 100 or tables of data related update and the verifying of tables of data related update
The temperature change of device 100.In some embodiments, which can also include Magnetic Sensor, pressure sensor
Or temperature sensor.
Communication component 116 is configured to facilitate wired between the verifying device 100 of tables of data related update and other equipment
Or the communication of wireless mode.The verifying device 100 of tables of data related update can access the wireless network based on communication standard, such as
WiFi (Wireless-Fidelity, Wireless Fidelity).In embodiments of the present invention, communication component 116 is received via broadcast channel
Broadcast singal or broadcast related information from external broadcasting management system.In embodiments of the present invention, communication component 116 also wraps
Near-field communication (Near Field Communication, abbreviation NFC) module is included, for promote short range communication.For example,
NFC module can be based on radio frequency identification (Radio Frequency Identification, abbreviation RFID) technology, infrared data association
Meeting (Infrared DataAssociation, abbreviation IrDA) technology, ultra wide band (Ultra Wideband, abbreviation UWB) technology,
Bluetooth technology and other technologies are realized.
In the exemplary embodiment, the verifying device 100 of tables of data related update can be dedicated by one or more application
Integrated circuit (Application Specific Integrated Circuit, abbreviation ASIC), digital signal processor, number
Word signal handling equipment, programmable logic device, field programmable gate array, controller, microcontroller, microprocessor or other
Electronic component is realized, for executing following methods.
Referring to Fig. 2, the process that Fig. 2 is a kind of verification method of tables of data related update disclosed by the embodiments of the present invention is shown
It is intended to.Wherein, the verification method of tables of data related update described in Fig. 2 is set suitable for tablet computer, desktop computer and terminal
It is standby to wait electronic equipments.The embodiment of the present invention describes the verification method of tables of data related update by taking electronic equipment as an example, should not constitute
Restriction to this method.The verification method of the tables of data related update as shown in Figure 2 may comprise steps of:
201, when detecting business operation, the corresponding current data table of business operation and acquisition are obtained in the database
Business operation corresponding first primary data in current data table.
In the embodiment of the present invention, business operation would generally have an impact the tables of data in database, and then to tables of data
In data modify.
As an alternative embodiment, it is corresponding to obtain business operation in the database when detecting business operation
Current data table and obtain business operation corresponding first primary data in current data table, can be in the following manner
It realizes: the data that business operation is directly affected in analytical database, for example, being user a in modification database in business operation
Age when, due to modification user age need to modify to the corresponding tables of data of subscriber data " user ", then would know that
The current data table that above-mentioned business operation corresponds in database is " user "；Since above-mentioned business operation can be to tables of data
Data " 20 " corresponding to user a are modified in the field " user_age " of " user ", then would know that above-mentioned business operation exists
Corresponding first primary data is " 20 " in current data table " user ".The corresponding current data of business operation is obtained by analysis
Table and acquisition business operation corresponding first primary data in current data table, obtain associated data convenient for subsequent step.
202, associated data table associated with current data table is obtained and in associated data table at the beginning of acquisition and first
The second primary data that beginning data match.
In the embodiment of the present invention, due between tables of data each in database there are incidence relation, so business operation in addition to
It needs to modify to the first primary data in current data table, it is also necessary to there are the passes of incidence relation with current data table
Corresponding modification is carried out with associated second primary data of the first primary data in connection tables of data, therefore, it is necessary to obtain and currently
The associated associated data table of tables of data and obtaining in associated data table matches second initial with the first primary data
Data.
As an alternative embodiment, obtaining the corresponding association identification of data in database in tables of data, and root
It is generated according to tables of data and the corresponding association identification of tables of data and is associated with influence diagram, between the tables of data for including to referred database
Incidence relation；Wherein, association identification is used to indicate the incidence relation of the data in tables of data and the data in other tables of data.Tool
Body, each field in tables of data is both provided with association identification, the field in the tables of data as described in step 201 " user "
Field " resume_age " in " user_age " and tables of data " resume " is associated data, so " user_age " is arranged
Have the association identification of (" user_age "=" resume_age "), get (" user_age "=" resume_age ") it
Afterwards, the association influence diagram that tables of data " resume " is directed toward by tables of data " user " is produced, wherein tables of data " user " and data
The incidence relation of table " resume " is (" user_age "=" resume_age "), is having modified tables of data to embody
In " user " when first primary data of " user_age ", " resume_age " is corresponding second initial in tables of data " resume "
Data also need to carry out corresponding modification.By pre-generating the association influence diagram of database, can clear in database each tables of data it
Between incidence relation.
It is used to indicate in database between each table data after the association influence diagram of incidence relation generating, it can basis
Association influence diagram directly acquires the second primary data associated with the first primary data.
As an alternative embodiment, searching associated data associated with current data table in association influence diagram
Table, and according to the corresponding association identification of the first primary data in current data table, at the beginning of determining with first in associated data table
The second primary data that beginning data match.Specifically, current data table " user " and field has been determined in above-mentioned steps
In " user_age " after the first primary data " 20 ", according to the association identification of field " user_age " in association influence diagram
(" user_age "=" resume_age ") would know that field in the first primary data " 20 " and tables of data " resume "
" resume_age " corresponding data " 20 " are associated, got field " resume_age " in tables of data " resume " at this time
Corresponding data " 20 " are the second primary data associated with the first primary data " 20 ".By searching for association influence diagram, i.e.,
It can promptly determine the second primary data to match with the first primary data.
203, the verifying scene for corresponding to current data table and associated data table is generated according to business operation.
In the embodiment of the present invention, different business operations can generate various forms of modifications, example to the data in tables of data
The modification as included by basic database manipulation, deletion and increase etc., when business operation is the first primary data of modification, the
Corresponding first primary data is modified by two primary datas；When business operation is to delete the first primary data, at the beginning of second
Beginning data also will be deleted accordingly, delete operation be verified according to the verifying scene of modification operation, due to the first initial number
It is worth the missing with the second initial value, the first initial value and second can not be got under the verifying scene of modification operation initially
Numerical value is verified, and authentication failed is caused.
As it can be seen that different business operations is suitable for different verifying scenes, corresponded to so needing to be generated according to business operation
In the current data table verifying scene different from associated data table.
204, detection is when the first primary data under verifying scene generates variation, if corresponds to verifying scene update second
Primary data.
In the embodiment of the present invention, current data table and associated data table will be corresponded to according to what is generated in step 203
Scene is verified, to the first primary data for getting in step 201 and step 202 and associated with the first primary data
Second primary data is updated verifying, if the second primary data is corresponded to update, turns to step 205.
As an alternative embodiment, if the corresponding business operation of verifying scene is modification operation, it is initial first
When data generate variation, whether the second primary data of detection corresponds to the first primary data after being revised as variation, repairs if having corresponded to
The first primary data after being changed to variation determines and corresponds to verifying the second primary data of scene update.Specifically, it is assumed that modifying
It operates under corresponding verifying scene, user a is stored in field " user_age " in tables of data " user " by business operation instruction
First primary data " 20 " is revised as " 19 ", then when the first primary data " 20 " is modified to " 19 ", with tables of data
In the field " resume_age " of field " user_age " the associated tables of data " resume " of " user " at the beginning of detection and first
Whether associated second primary data of beginning data, which corresponds to, is revised as " 19 ", repairs if so, determining that the second primary data has corresponded to
The first primary data after being changed to variation, so that whether the second primary data of detection corresponds to the first primary data and modify.
As another optional embodiment, if the corresponding business operation of verifying scene is delete operation, at the beginning of first
When beginning data are deleted in current data table, whether the second primary data of detection has deleted from associated data table, if from pass
Join tables of data to delete, determines and correspond to verifying the second primary data of scene update.Specifically, it is assumed that test delete operation is corresponding
It demonstrate,proves under scene, business operation indicates the first primary data that user a is stored in field " user_age " in tables of data " user "
" 20 " are deleted, then when the first primary data " 20 " are deleted, in field " user_age " phase with tables of data " user "
Detection the second initial number associated with the first primary data in the field " resume_age " of associated tables of data " resume "
According to whether correspond to it is deleted, if so, determine the second primary data correspond to first primary data be deleted, thus detect second
Whether primary data, which corresponds to the first primary data, is deleted.
As another optional embodiment, if the corresponding business operation of verifying scene is to increase operation, at the beginning of first
When beginning data are increased to current data table, whether the second primary data of detection increases to associated data table, if having been increased to pass
Join tables of data, determines and correspond to verifying the second primary data of scene update.Specifically, it is assumed that operate corresponding verifying field increasing
Under scape, not yet storing data, business operation instruction are initial by first in the field " user_age " of tables of data " user " by user a
Data " 20 " are stored in user a in the field " user_age " of tables of data " user ", then are deposited in the first primary data " 20 "
When storage is into the field " user_age " of tables of data " user ", associated with field " user_age " of tables of data " user "
Whether detection the second primary data associated with the first primary data in the field " resume_age " of tables of data " resume "
Accordingly increased, if so, determining that the second primary data has corresponded to increase is the first primary data, so that detection second is initial
Whether data, which correspond to the first primary data, is increased.
Still optionally further, business operation modify to the first primary data in current data table, delete or
When increase, the second primary data in associated data table is modified, deletes or is increased in addition to synchronizing corresponding to business operation
Except, it is also possible to according to the actual conditions of operation flow, different update modes is taken to be updated the second primary data.Example
Such as, user a the first primary data " 20 " for being stored in field " user_age " in tables of data " user " is repaired in business operation instruction
" 19 " are changed to, then when the first primary data " 20 " is modified to " 19 ", in the field " user_age " with tables of data " user "
Associated tables of data " resume " is used to store detection and first in the field " resume_birthday " of user's date of birth
Whether the date of birth that associated second primary data of primary data is stored, which corresponds to, is revised as the age going out indicated by " 19 "
Phase birthday, if so, determining that the second primary data has corresponded to is revised as the first primary data, to realize to different type number
It is updated according to synchronizing.
205, determine that the update of associated data table is proved to be successful.
In the embodiment of the present invention, detect that the second primary data corresponds to the first primary data and carried out more in step 204
When new, that is, complete the update to associated data table and verify.
As it can be seen that implement method described in Fig. 2, it is initial by first in the corresponding current data table of acquisition business operation
The second primary data in data and associated data table associated with current data table generates variation in the first primary data
When, whether the second primary data of detection, which corresponds to the first primary data, is updated, to realize the related update to tables of data
It is verified, authentication error when improving verification efficiency, and avoiding manual verification.
Referring to Fig. 3, Fig. 3 is the process of the verification method of another tables of data related update disclosed by the embodiments of the present invention
Schematic diagram.As shown in figure 3, the verification method of the tables of data related update may comprise steps of:
301, when detecting business operation, the corresponding current data table of business operation and acquisition are obtained in the database
Business operation corresponding first primary data in current data table.
In the embodiment of the present invention, business operation would generally have an impact the tables of data in database, and then to tables of data
In data modify.
302, associated data table associated with current data table is obtained and in associated data table at the beginning of acquisition and first
The second primary data that beginning data match.
In the embodiment of the present invention, due between tables of data each in database there are incidence relation, so business operation in addition to
It needs to modify to the first primary data in current data table, it is also necessary to there are the passes of incidence relation with current data table
Corresponding modification is carried out with associated second primary data of the first primary data in connection tables of data, therefore, it is necessary to obtain and currently
The associated associated data table of tables of data and obtaining in associated data table matches second initial with the first primary data
Data.
303, the verifying scene for corresponding to current data table and associated data table is generated according to business operation.
In the embodiment of the present invention, different business operations can generate various forms of modifications, institute to the data in tables of data
Corresponding verifying scene will be generated according to business operation.
304, detection is when the first primary data under verifying scene generates variation, if corresponds to verifying scene update second
Primary data.
In the embodiment of the present invention, current data table and associated data table will be corresponded to according to what is generated in step 303
Scene is verified, to the first primary data for getting in step 301 and step 302 and associated with the first primary data
Second primary data is updated verifying, if corresponding first primary data of the second primary data is updated, turns to step
305；If not corresponding first primary data of the second primary data is updated, step 306 is turned to.
305, determine that the update of associated data table is proved to be successful.
In the embodiment of the present invention, detect that the second primary data corresponds to the first primary data and carried out more in step 304
When new, that is, complete the update to associated data table and verify.
It finds in practical applications, partial database has higher requirement to the update efficiency of associated data, at the beginning of first
When beginning data generate variation, the second primary data associated with the first primary data needs to complete more in default update in duration
Newly, for example, commodity stocks table is associated with the presence of pay invoice table in the database in store on line, whenever in pay invoice table
When middle increase commodity, the increased commodity of institute require to be deleted in commodity stocks table in real time, to avoid the commodity having been sold out
It is repeated purchase.So in addition to being verified to whether the second primary data in associated data table updates, it is also necessary to according to industry
It is engaged in that the requirement for updating efficiency is detected and optimized to the update duration of the second primary data.
As an alternative embodiment, being obtained after the update of the determining associated data table of step 304 is proved to be successful
First time node of business operation when corresponding first primary data changes in current data table, and at the beginning of with first
Associated second primary data of beginning data completes the second timing node updated, by first time node and the second timing node
Difference be set as updating duration, judge to update duration whether be greater than it is default update duration, if so, by business operation and business operation
Corresponding service code is pushed to administrator, to remind administrator to optimize the update efficiency of service code.It is to be appreciated that above-mentioned
It calculates when updating the method for duration and can accurately reflect that corresponding first primary data of the second primary data is updated used
It is long, for that can flexibly set according to the actual situation pre- to tables of data involved in the higher business operation of efficiency requirements is updated
If updating duration, it is greater than the default business operation for updating duration if detecting and updating duration, it is determined that the update of the business operation
Efficiency is unable to satisfy actual use, and the business operation and the corresponding service code of business operation are pushed to administrator, thus
Administrator can optimize service code, be improved the update efficiency of business operation.
306, business operation and the corresponding service code of business operation are pushed to administrator, with remind administrator solve with
The problem of associated second primary data of first primary data can not be updated.
In the embodiment of the present invention, if step 304 has determined the update authentication failed of associated data table, illustrate business operation
Corresponding service code can not carry out corresponding update to the second primary data, need to existing for the service code there are mistake
Mistake is corrected.
As an alternative embodiment, detecting when the first primary data under verifying scene generates variation, not
After update authentication failed of verifying the second primary data of scene update to determine associated data table, by business operation and
The corresponding service code of the business operation is pushed to administrator, associated with the first primary data to remind administrator to solve
The problem of second primary data can not be updated.When being associated with the update authentication failed of tables of data under detecting verifying scene,
It may illustrate that the corresponding service code of business operation can not modify to the second primary data in associated data table, Huo Zheye
Associated data table mistake specified by being engaged in code, at this point, business operation and the corresponding service code of the business operation are pushed
To administrator, so that administrator would know that associated data table updates authentication failed, and then to the service code of the business operation into
Row modification, solves the problems, such as that associated data can not update, and realizes in the case where being monitored without manpower, sends out in real time
The problem of existing business operation, is simultaneously handled.
Still optionally further, after business operation and the corresponding service code of business operation are pushed to administrator, root
According to corresponding first primary data of business operation and business operation, to the second primary data associated with the first primary data
It is updated.Specifically, when detect do not correspond to the second primary data business that the first primary data is updated when, if only
The information of failure is updated to administrator's propelling data table and administrator is transferred to handle, and operation flow may be because of tables of data
It updates not in time and can not continue and cause traffic lost, so, by business operation and the corresponding business of business operation
Code is pushed to after administrator, the association identification of current data table according to involved in business operation, and is grasped according to business
Variation, is accordingly updated the second primary data in associated data table caused by first primary data of opposing, thus
Mistake caused by handling in time because of service code guarantees that operation flow is gone on smoothly.
As it can be seen that method described in implementing Fig. 3, can find in time and push the business generation for updating inefficiency to administrator
The service code that code can not perhaps update associated data table optimizes the update efficiency of service code by administrator or solves business
The mistake of code ensures that going on smoothly for operation flow.
Referring to Fig. 4, the structure that Fig. 4 is a kind of verifying device of tables of data related update disclosed by the embodiments of the present invention is shown
It is intended to.As shown in figure 4, the vertical field blacklist feature mining device may include: association generation unit 401, first is obtained
Unit 402, scene generation unit 404, updates authentication unit 405 and updates determination unit 406 second acquisition unit 403,
In,
It is associated with generation unit 401, for obtaining the corresponding association identification of data in database in tables of data；According to data
Table and the corresponding association identification of tables of data generate association influence diagram, and the association between the tables of data for including to referred database is closed
System；
First acquisition unit 402, for being obtained in the database when detecting business operation, business operation is corresponding to work as
Preceding tables of data and acquisition business operation corresponding first primary data in current data table；
Second acquisition unit 403, for obtaining associated data table associated with current data table and in associated data
The second primary data to match with the first primary data is obtained in table；
Scene generation unit 404 corresponds to testing for current data table and associated data table for generating according to business operation
Demonstrate,prove scene；
Authentication unit 405 is updated, for detecting when the first primary data under verifying scene generates variation, if correspond to
Verify the second primary data of scene update；
Determination unit 406 is updated, at the beginning of the first primary data corresponds to verifying scene update second in the case where verifying scene
When beginning data, determine that the update of associated data table is proved to be successful.
Wherein, it updates authentication unit 405 to be specifically used for when the corresponding business operation of verifying scene being modification operation, first
When primary data generates variation, whether the second primary data of detection corresponds to the first primary data after being revised as variation, if right
The first primary data after should being revised as variation determines and corresponds to verifying the second primary data of scene update；
It is specifically used for when the corresponding business operation of verifying scene being delete operation alternatively, updating authentication unit 405, first
Primary data in current data table be deleted when, detection the second primary data whether from associated data table delete, if from
Associated data table is deleted, and is determined and is corresponded to verifying the second primary data of scene update；
It is specifically used for when the corresponding business operation of verifying scene being to increase operation alternatively, updating authentication unit 405, first
When primary data is increased to current data table, whether the second primary data of detection increases to associated data table, if having been increased to
Associated data table determines and corresponds to verifying the second primary data of scene update.
In the embodiment of the present invention, association generation unit 401 generates the association influence diagram of tables of data included by database, is examining
When measuring business operation, the corresponding current data table of the acquisition business operation of first acquisition unit 402 and the first primary data, second
Acquiring unit 403 obtains associated data table associated with current data table according to association influence diagram and obtains with first initially
Associated second primary data of data, scene generation unit 404 then generate corresponding verifying scene according to business operation, thus
Whether update second primary data of the verifying of authentication unit 405, which corresponds to the first primary data, is updated, in the second primary data
In the case where being updated corresponding to the first primary data, updates determination unit 406 and determine that the update of associated data table is proved to be successful.
It is corresponded to as an alternative embodiment, association generation unit 401 obtains the data in database in tables of data
Association identification, and association influence diagram is generated according to tables of data and the corresponding association identification of tables of data, to referred database packet
The incidence relation between tables of data included；Wherein, association identification is used to indicate in the data in tables of data and other tables of data
The incidence relation of data.Specifically, each field in tables of data is both provided with association identification, it is assumed that in tables of data " user "
Field " resume_age " in field " user_age " and tables of data " resume " is associated data, so " user_age "
It is provided with the association identification of (" user_age "=" resume_age "), association generation unit 401 is getting (" user_age "
=" resume_age ") after, the association influence diagram that tables of data " resume " is directed toward by tables of data " user " is produced, wherein counting
It is (" user_age "=" resume_age ") according to the incidence relation of table " user " and tables of data " resume ", to embody
When having modified first primary data of " user_age " in tables of data " user ", " resume_age " is right in tables of data " resume "
The second primary data answered also needs to carry out corresponding modification.By pre-generating the association influence diagram of database, database can be cleared
In incidence relation between each tables of data.
As an alternative embodiment, first acquisition unit 402 obtains in the database when detecting business operation
It takes the corresponding current data table of business operation and obtains business operation corresponding first primary data in current data table, it can
To be accomplished by the following way: the data that business operation is directly affected in 402 analytical database of first acquisition unit, for example,
When business operation is to modify the age of user a in database, the age due to modifying user needs corresponding to subscriber data
Tables of data " user " is modified, then would know that the current data table that above-mentioned business operation corresponds in database is " user "；
Since above-mentioned business operation data " 20 " can be repaired corresponding to user a in the field " user_age " to tables of data " user "
Change, then would know that above-mentioned business operation corresponding first primary data in current data table " user " is " 20 ".Pass through analysis
It obtains the corresponding current data table of business operation and obtains business operation corresponding first primary data in current data table,
Associated data is obtained convenient for second acquisition unit 403.
As an alternative embodiment, second acquisition unit 403 is searched and current data table in association influence diagram
Associated associated data table, and according to the corresponding association identification of the first primary data in current data table, in associated data table
In determine the second primary data to match with the first primary data.Specifically, it has been determined currently in first acquisition unit 402
Tables of data " user " is with after the first primary data " 20 " in field " user_age ", and second acquisition unit 403 is according to association shadow
The association identification (" user_age "=" resume_age ") for ringing field " user_age " in figure, would know that the first primary data
" 20 " data " 20 " corresponding with field " resume_age " in tables of data " resume " are associated, got tables of data at this time
The corresponding data " 20 " of field " resume_age " are associated with the first primary data " 20 " second initial in " resume "
Data.By searching for association influence diagram, the second primary data to match with the first primary data can be promptly determined.
As an alternative embodiment, if the corresponding business operation of verifying scene is modification operation, it is initial first
When data generate variation, it is initial to update whether second primary data of the detection of authentication unit 405 corresponds to after being revised as variation first
Data determine if having corresponded to the first primary data after being revised as variation and correspond to verifying the second primary data of scene update.Tool
Body, it is assumed that in the case where modification operates corresponding verifying scene, user a is stored in word in tables of data " user " by business operation instruction
The first primary data " 20 " of section " user_age " is revised as " 19 ", then when the first primary data " 20 " is modified to " 19 ",
Authentication unit 405 is updated in the field of tables of data " resume " associated with field " user_age " of tables of data " user "
In " resume_age " detection with whether associated second primary data of the first primary data corresponding is revised as " 19 ", if so,
Then determine that the second primary data has corresponded to the first primary data after being revised as variation, so that whether the second primary data of detection is right
The first primary data is answered to modify.
As another optional embodiment, if the corresponding business operation of verifying scene is delete operation, at the beginning of first
When beginning data are deleted in current data table, update authentication unit 405 and whether detect the second primary data from associated data
Table is deleted, if deleting from associated data table, is determined and is corresponded to verifying the second primary data of scene update.Specifically, it is assumed that
Under the corresponding verifying scene of delete operation, user a is stored in field " user_ in tables of data " user " by business operation instruction
The first primary data " 20 " of age " is deleted, then when the first primary data " 20 " are deleted, updates authentication unit 405 and exist
Detection in the field " resume_age " of tables of data " resume " associated with field " user_age " of tables of data " user "
With that whether associated second primary data of the first primary data corresponds to is deleted, if so, determining that the second primary data is right
The first primary data is answered to be deleted, so that whether the second primary data of detection corresponds to the first primary data and deleted.
As another optional embodiment, if the corresponding business operation of verifying scene is to increase operation, at the beginning of first
When beginning data are increased to current data table, update authentication unit 405 and detect whether the second primary data increases to associated data
Table determines if having been increased to associated data table and corresponds to verifying the second primary data of scene update.Specifically, it is assumed that increasing
It operates under corresponding verifying scene, user a in the field " user_age " of tables of data " user " not yet grasp by storing data, business
Indicate for the first primary data " 20 " to be stored in user a in the field " user_age " of tables of data " user ", then first
When primary data " 20 " is stored in the field " user_age " of tables of data " user ", authentication unit 405 and data are being updated
Detection and first in the field " resume_age " of field " user_age " the associated tables of data " resume " of table " user "
Whether associated second primary data of primary data is accordingly increased, if so, determining that the second primary data has corresponded to increasing
The first primary data is added as, so that whether the second primary data of detection corresponds to the first primary data and increased.
Still optionally further, business operation modify to the first primary data in current data table, delete or
When increase, the second primary data in associated data table is modified, deletes or is increased in addition to synchronizing corresponding to business operation
Except, it is also possible to according to the actual conditions of operation flow, different update modes is taken to be updated the second primary data.Example
Such as, user a the first primary data " 20 " for being stored in field " user_age " in tables of data " user " is repaired in business operation instruction
Be changed to " 19 ", then when the first primary data " 20 " is modified to " 19 ", update authentication unit 404 with tables of data " user "
Field " user_age " associated tables of data " resume " is used to store the field " resume_ of user's date of birth
The date of birth that detection is stored with associated second primary data of the first primary data in birthday " whether corresponding modification
For the date of birth indicated by age " 19 ", if so, determining that the second primary data has corresponded to is revised as the first primary data, from
And it realizes and update is synchronized to different types of data.
As it can be seen that implementing the verifying device of tables of data related update described in Fig. 4, obtained by first acquisition unit 402
It the first primary data in the corresponding current data table of business operation and is obtained by second acquisition unit 403 and current data
The second primary data in the associated associated data table of table updates authentication unit 405 when the first primary data generates variation
It detects the second primary data and whether corresponds to the first primary data and be updated, the related update of tables of data is carried out to realize
Verifying, authentication error when improving verification efficiency, and avoiding manual verification.
Referring to Fig. 5, Fig. 5 is the structure of the verifying device of another tables of data related update disclosed by the embodiments of the present invention
Schematic diagram.The verifying device of tables of data related update shown in fig. 5 is the verifying device of tables of data related update as shown in Figure 4
It optimizes.Compared with the verifying device of tables of data related update shown in Fig. 4, tables of data association shown in fig. 5
The verifying device of update can also include: node acquiring unit 407, duration judging unit 408, the first push unit 409, second
Push unit 410 and data updating unit 411, wherein
Node acquiring unit 407 occurs for obtaining business operation corresponding first primary data in current data table
First time node when change, and the second primary data associated with the first primary data complete the second time updated
Node；
Duration judging unit 408 updates duration for the difference of first time node and the second timing node to be set as, sentences
It is disconnected to update whether duration is greater than default update duration；
First push unit 409, for judgement obtain updating duration be greater than it is default update duration when, by business operation and
The corresponding service code of business operation is pushed to administrator, to remind administrator to optimize the update efficiency of service code；
Second push unit 410, for detecting that the first primary data produces in the case where verifying scene in update authentication unit 405
When changing, do not correspond to after update authentication failed of verifying the second primary data of scene update to determine associated data table,
Business operation and the corresponding service code of business operation are pushed to administrator, to remind administrator to solve and the first primary data
The problem of associated second primary data can not be updated；
Data updating unit 411, in the second push unit 410 by business operation and business operation corresponding business generation
Code is pushed to after administrator, according to corresponding first primary data of business operation and business operation, to the first initial number
It is updated according to associated second primary data.
In the embodiment of the present invention, duration judging unit 408 sentences the update duration that node acquiring unit 407 is got
Disconnected, when judgement obtains updating duration greater than default update duration, the first push unit 409 reminds administrator to optimize service code
Update efficiency；When update authentication unit 405 detects that associated data table updates failed validation, the second push unit 410 is mentioned
The administrator that wakes up handles the problem of associated data table updates failure, then the associated data of 411 pairs of data updating unit update failures
The second primary data in table is updated.
As an alternative embodiment, determining that the update of associated data table is proved to be successful updating determination unit 406
Later, node acquiring unit 407 obtains business operation when corresponding first primary data changes in current data table
First time node, and the second primary data associated with the first primary data complete the second timing node updated, when
The difference of first time node and the second timing node is set as updating duration by long judging unit 408, judges whether update duration
Greater than default update duration, if so, business operation and the corresponding service code of business operation are pushed to by the first push unit 409
Administrator, to remind administrator to optimize the update efficiency of service code.It is to be appreciated that the method that above-mentioned calculating updates duration can
Accurately reflect that corresponding first primary data of the second primary data is updated duration used, for update efficiency requirements
Tables of data involved in higher business operation can flexibly set default update duration, if detecting more according to the actual situation
New duration is greater than the default business operation for updating duration, then duration judging unit 408 determine the update efficiency of the business operation without
Method meets actual use, and the business operation and the corresponding service code of business operation are pushed to management by the first push unit 409
Member, so that administrator can optimize service code, is improved the update efficiency of business operation.
As an alternative embodiment, detecting the first initial number in the case where verifying scene updating authentication unit 405
According to generate variation when, do not correspond to verifying the second primary data of scene update with determine associated data table update authentication failed it
Afterwards, business operation and the corresponding service code of the business operation are pushed to administrator by the second push unit 410, to remind pipe
Reason person solves the problems, such as that the second primary data associated with the first primary data can not be updated.Updating authentication unit
405 detect verifying scene under be associated with tables of data update authentication failed when, may illustrate the corresponding service code of business operation
Can not modify to the second primary data in associated data table or service code in specified associated data table it is wrong
Accidentally, at this point, business operation and the corresponding service code of the business operation are pushed to administrator by the second push unit 410, thus
Administrator would know that associated data table updates authentication failed, and then modify to the service code of the business operation, solve phase
The problem of associated data can not update realizes in the case where being monitored without manpower, finds in business operation in real time
There are the problem of and handled.
Still optionally further, business operation and the corresponding service code of business operation are pushed in the second push unit 410
After administrator, according to corresponding first primary data of business operation and business operation, data updating unit 411 is to
Associated second primary data of one primary data is updated.Specifically, when detect do not correspond to the first primary data into
When the second primary data business that row updates, if the second push unit 410 only updates the letter of failure to administrator's propelling data table
It ceases and administrator is transferred to handle, operation flow may update not in time because of tables of data and can not continue and cause
Traffic lost, so, after business operation and the corresponding service code of business operation are pushed to administrator, data update single
The association identification of first 411 current data tables according to involved in business operation, and according to business operation to the first primary data
Generated variation is accordingly updated the second primary data in associated data table, to handled in time because of business
Mistake caused by code guarantees that operation flow is gone on smoothly.
As it can be seen that implementing method described in Fig. 5, the first push unit 409 and the second push unit 410 can be in time to management
Member's push updates the service code of inefficiency or can not update the service code of associated data table, optimizes business by administrator
The update efficiency of code or the mistake for solving service code, data updating unit 411 is to the associated data table progress to update
It updates, it is ensured that operation flow is gone on smoothly.
The present invention also provides a kind of electronic equipment, which includes:
Processor；
Memory is stored with computer-readable instruction on the memory, when which is executed by processor,
Realize a kind of verification method of tables of data related update as previously shown.
The electronic equipment can be the verifying device 100 of tables of data related update shown in Fig. 1.
In one exemplary embodiment, the present invention also provides a kind of computer readable storage mediums, are stored thereon with calculating
Machine program when the computer program is executed by processor, realizes a kind of verification method of tables of data related update as previously shown.
It should be understood that the present invention is not limited to the precise structure already described above and shown in the accompanying drawings, and
And various modifications and change can executed without departing from the scope.The scope of the present invention is limited only by the attached claims.
Claims (10)
1. a kind of verification method of tables of data related update characterized by comprising
When detecting business operation, obtained described in the corresponding current data table of the business operation and acquisition in the database
Business operation corresponding first primary data in the current data table；
It obtains associated with current data table associated data table and is obtained in the associated data table and described the
The second primary data that one primary data matches；
The verifying scene for corresponding to the current data table and the associated data table is generated according to the business operation；
Detection is under the verifying scene when the first primary data generation variation, if corresponds to the verifying scene update
Second primary data；
If so, determining that the update of the associated data table is proved to be successful.
2. the method according to claim 1, wherein the method also includes:
Obtain the corresponding association identification of data in the database in tables of data；Wherein, the association identification is used to indicate institute
State the incidence relation of the data in the data and other tables of data in tables of data；
Association influence diagram is generated according to the tables of data and the corresponding association identification of the tables of data, to indicate the database
Including the tables of data between incidence relation.
3. according to the method described in claim 2, it is characterized in that, described obtain association associated with the current data table
Tables of data and the second primary data that acquisition matches with first primary data in the associated data table, comprising:
Associated data table associated with the current data table is searched in the association influence diagram；
According to the corresponding association identification of the first primary data described in the current data table, determined in the associated data table
The second primary data to match out with first primary data.
4. the method according to claim 1, wherein it is described detection under the verifying scene described first initially
When data generate variation, if correspond to the second primary data described in the verifying scene update, comprising:
If the corresponding business operation of the verifying scene is modification operation, when first primary data generates variation, detection
Whether second primary data corresponds to the first primary data after being revised as variation, if having corresponded to first after being revised as variation
Primary data determines and corresponds to the second primary data described in the verifying scene update；
If the corresponding business operation of the verifying scene is delete operation, in first primary data in the current data table
In when being deleted, detect whether second primary data has deleted from the associated data table, if from the associated data
Table is deleted, and is determined and is corresponded to the second primary data described in the verifying scene update；
If the corresponding business operation of the verifying scene is to increase operation, it is increased in first primary data described current
When tables of data, detect whether second primary data increases to the associated data table, if having been increased to the associated data
Table determines and corresponds to the second primary data described in the verifying scene update.
5. the method according to claim 1, wherein the determination associated data table update verifying at
After function, the method also includes:
First time when obtaining the business operation corresponding first primary data changing in the current data table
Node, and the second primary data associated with first primary data complete the second timing node updated；
The difference of the first time node and second timing node is set as to update duration, judges that the update duration is
It is no to be greater than default update duration；
If so, the business operation and the corresponding service code of the business operation are pushed to administrator, to remind the pipe
Reason person optimizes the update efficiency of the service code.
6. the method according to claim 1, wherein the method also includes:
When detecting that first primary data generates variation under the verifying scene, the verifying scene is not corresponded to more
After new second primary data is with the update authentication failed of the determination associated data table, by the business operation and described
The corresponding service code of business operation is pushed to administrator, related to first primary data to remind the administrator to solve
The problem of second primary data of connection can not be updated.
7. according to the method described in claim 6, it is characterized in that, described by the business operation and the business operation pair
The service code answered is pushed to after administrator, the method also includes:
According to the business operation and corresponding first primary data of the business operation, to the first primary data phase
Associated second primary data is updated.
8. a kind of verifying device of tables of data related update, which is characterized in that the verifying device packet of the tables of data related update
It includes:
First acquisition unit, it is corresponding current for when detecting business operation, obtaining the business operation in the database
Tables of data and acquisition business operation corresponding first primary data in the current data table；
Second acquisition unit, for obtaining associated data table associated with the current data table and in the associated data
The second primary data to match with first primary data is obtained in table；
Scene generation unit corresponds to the current data table and the associated data table for generating according to the business operation
Verifying scene；
Authentication unit is updated, when for detecting the first primary data generation variation under the verifying scene, if corresponding
The second primary data described in the verifying scene update；
Update determination unit, under the verifying scene first primary data correspond to and verify the described in scene update
When two primary datas, determine that the update of the associated data table is proved to be successful.
9. a kind of electronic equipment, including memory and processor, the memory are stored with computer program, which is characterized in that
The processor realizes tables of data related update according to any one of claims 1 to 7 when executing the computer program
The step of verification method.
10. a kind of computer readable storage medium, which is characterized in that it stores computer program, and the computer program makes
Computer perform claim requires the verification method of 1~7 described in any item tables of data related updates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910448154.XA CN110347672A (en) | 2019-05-27 | 2019-05-27 | Verification method and device, the electronic equipment and storage medium of tables of data related update |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910448154.XA CN110347672A (en) | 2019-05-27 | 2019-05-27 | Verification method and device, the electronic equipment and storage medium of tables of data related update |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110347672A true CN110347672A (en) | 2019-10-18 |
Family
ID=68174078
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910448154.XA Pending CN110347672A (en) | 2019-05-27 | 2019-05-27 | Verification method and device, the electronic equipment and storage medium of tables of data related update |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110347672A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908978A (en) * | 2019-11-06 | 2020-03-24 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
| CN111104464A (en) * | 2019-12-31 | 2020-05-05 | 成都校精灵科技有限公司 | Data synchronous modification method, data synchronous reading method, data synchronous modification system and readable storage medium |
| CN112115153A (en) * | 2020-09-21 | 2020-12-22 | 北京字跳网络技术有限公司 | Data processing method, device, equipment and storage medium |
| WO2022007855A1 (en) * | 2020-07-09 | 2022-01-13 | 北京字节跳动网络技术有限公司 | Method and device for updating reference document, electronic device, and storage medium |
| WO2022147908A1 (en) * | 2021-01-05 | 2022-07-14 | 平安科技（深圳）有限公司 | Table association-based lost data recovery method and apparatus, device, and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6675178B1 (en) * | 2000-11-09 | 2004-01-06 | Accenture Llp | Method and system for enhancing a commercial transaction conducted via a communications network |
| CN108287886A (en) * | 2018-01-16 | 2018-07-17 | 阿里巴巴集团控股有限公司 | The method and device of synchrodata modification information |
| CN108829727A (en) * | 2018-05-09 | 2018-11-16 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Date storage method, device, computer equipment and storage medium |
| CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技（深圳）有限公司 | Data monitoring method, device, computer equipment and storage medium |
-
2019
- 2019-05-27 CN CN201910448154.XA patent/CN110347672A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6675178B1 (en) * | 2000-11-09 | 2004-01-06 | Accenture Llp | Method and system for enhancing a commercial transaction conducted via a communications network |
| CN108287886A (en) * | 2018-01-16 | 2018-07-17 | 阿里巴巴集团控股有限公司 | The method and device of synchrodata modification information |
| CN108829727A (en) * | 2018-05-09 | 2018-11-16 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Date storage method, device, computer equipment and storage medium |
| CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技（深圳）有限公司 | Data monitoring method, device, computer equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 檀明;肖连军;龙夏;许强;: "一种基于业务验证规则的通用单表更新方法的实现", 工业控制计算机, no. 06, pages 84 - 85 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908978A (en) * | 2019-11-06 | 2020-03-24 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
| CN110908978B (en) * | 2019-11-06 | 2022-09-13 | 中盈优创资讯科技有限公司 | Database data structure verification method and device |
| CN111104464A (en) * | 2019-12-31 | 2020-05-05 | 成都校精灵科技有限公司 | Data synchronous modification method, data synchronous reading method, data synchronous modification system and readable storage medium |
| WO2022007855A1 (en) * | 2020-07-09 | 2022-01-13 | 北京字节跳动网络技术有限公司 | Method and device for updating reference document, electronic device, and storage medium |
| CN112115153A (en) * | 2020-09-21 | 2020-12-22 | 北京字跳网络技术有限公司 | Data processing method, device, equipment and storage medium |
| WO2022147908A1 (en) * | 2021-01-05 | 2022-07-14 | 平安科技（深圳）有限公司 | Table association-based lost data recovery method and apparatus, device, and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110347672A (en) | Verification method and device, the electronic equipment and storage medium of tables of data related update | |
| CN105224462B (en) | The recognition methods of control element and device | |
| CN104951336B (en) | application program installation method and device | |
| CN110334007A (en) | A kind of functional interface calls verification method and device, electronic equipment and storage medium | |
| CN110162442B (en) | System performance bottleneck positioning method and system | |
| CN105827683A (en) | Data synchronization method, server and electronic device | |
| CN103577658A (en) | Method and system for evaluating intelligent terminal hardware | |
| CN108491326B (en) | Test behavior a recombination process apparatus and storage medium | |
| CN107832035B (en) | Voice input method of intelligent terminal | |
| CN106790895A (en) | A kind of fault handling method and device | |
| CN111078672B (en) | Data comparison method and device for database | |
| CN110941942A (en) | Method, device and system for checking circuit schematic diagram | |
| CN104219378A (en) | Information processing method and device | |
| CN112148579A (en) | User interface testing method and device | |
| CN110119354A (en) | Method for testing software, device and electronic equipment based on Test cases technology | |
| CN104615546A (en) | File data management method and device | |
| CN109582524A (en) | A kind of test method, system and electronic equipment and storage medium | |
| CN105323748B (en) | Test error uploading method and device | |
| CN110489347A (en) | Method for edition management, device, equipment and readable storage medium storing program for executing based on GIT | |
| CN110235108A (en) | A kind of patch program check method, terminal device and computer readable storage medium | |
| CN106503182A (en) | Recording method, recording equipment and electronic equipment | |
| CN105404529A (en) | Popup method, device and system of operation system popup for reinstallation | |
| CN110716914A (en) | Database configuration method, system, computer readable storage medium and terminal equipment | |
| CN108256466A (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN104951337B (en) | File increment update method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 201, room 518000, building A, No. 1, front Bay Road, Qianhai Shenzhen Guangdong Shenzhen Hong Kong cooperation zone (Qianhai business secretary) Applicant after: Shenzhen one ledger Intelligent Technology Co., Ltd. Address before: 518000 Guangdong city of Shenzhen province Qianhai Shenzhen Hong Kong cooperation zone before Bay Road No. 1 building 201 room A Applicant before: Shenzhen one ledger Intelligent Technology Co., Ltd. |
|
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |