CN109325055A - The screening of business association tables of data and checking method, device, electronic equipment - Google Patents

The screening of business association tables of data and checking method, device, electronic equipment Download PDF

Info

Publication number
CN109325055A
CN109325055A CN201810872892.2A CN201810872892A CN109325055A CN 109325055 A CN109325055 A CN 109325055A CN 201810872892 A CN201810872892 A CN 201810872892A CN 109325055 A CN109325055 A CN 109325055A
Authority
CN
China
Prior art keywords
field
tables
verification
data table
associated data
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
Application number
CN201810872892.2A
Other languages
Chinese (zh)
Inventor
王频
王一频
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Advanced New Technologies Co Ltd
Advantageous New Technologies Co Ltd
Original Assignee
Alibaba Group Holding Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201810872892.2A priority Critical patent/CN109325055A/en
Publication of CN109325055A publication Critical patent/CN109325055A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

This specification one or more embodiment provides a kind of screening of business association tables of data and checking method, device, electronic equipment, the screening technique may include: the value of the corresponding required parameter of determining business operation;Search the tables of data that is related to when implementing the business operation, the tables of data includes the field value that is written into through implementing the business operation;When the field value being written into there are at least two tables of data is identical as the value of the required parameter, determine that at least two tables of data is the associated data table of the business operation.

Description

The screening of business association tables of data and checking method, device, electronic equipment
Technical field
This specification one or more embodiment is related to database technical field more particularly to a kind of business association tables of data Screening and checking method, device, electronic equipment.
Background technique
Logarithm is generally required after having implemented a certain business operation for financial companies such as bank, Third-party payment platforms According to there are the tables of data of incidence relation to be checked in the data table related in library, to ensure the correct of business flowing water and financial management details Property.And after the tables of data for confirming to need to check, it can be by generating verification instruction to check the tables of data confirmed.
Summary of the invention
In view of this, this specification one or more embodiment provides screening and the verification side of a kind of business association tables of data Method, device, electronic equipment.
To achieve the above object, it is as follows to provide technical solution for this specification one or more embodiment:
According to this specification one or more embodiment in a first aspect, proposing a kind of screening of business association tables of data Method is applied to Screening Platform;The described method includes:
Determine the value of the corresponding required parameter of business operation;
Search the tables of data that is related to when implementing the business operation, the tables of data include implemented the business operation and The field value being written into;
When the field value being written into there are at least two tables of data is identical as the value of the required parameter, described in judgement At least two tables of data are the associated data table of the business operation.
According to the second aspect of this specification one or more embodiment, a kind of verification of business association tables of data is proposed Method is applied to verification platform;The described method includes:
The association messages that Screening Platform is sent are received, the association messages record has the letter of the associated data table of business operation Breath, the associated data table contain at least two tables of data, and at least two tables of data implemented the business operation and The field value being written into is identical as the value of required parameter of the business operation is corresponded to;
The associated data table is checked.
According to the third aspect of this specification one or more embodiment, a kind of screening of business association tables of data is proposed Device is applied to Screening Platform;Described device includes:
Determination unit determines the value of the corresponding required parameter of business operation;
Searching unit, searches the tables of data for implementing to be related to when the business operation, and the tables of data includes through described in implementation Business operation and the field value being written into;
Judging unit, when the field value being written into there are at least two tables of data is identical as the value of the required parameter When, determine that at least two tables of data is the associated data table of the business operation.
According to the fourth aspect of this specification one or more embodiment, a kind of verification of business association tables of data is proposed Device is applied to verification platform;Described device includes:
Receiving unit, receives the association messages that Screening Platform is sent, and the association messages record has the association of business operation The information of tables of data, the associated data table contains at least two tables of data, and at least two tables of data is through described in implementation Business operation and the field value that is written into is identical as the value of required parameter of the business operation is corresponded to;
Unit is checked, the associated data table is checked.
According to the 5th of this specification one or more embodiment the aspect, a kind of electronic equipment is proposed, comprising:
Processor;
Memory for storage processor executable instruction;
Wherein, the processor is by running the executable instruction to realize the business as described in above-mentioned any embodiment The screening technique of associated data table.
According to the 6th of this specification one or more embodiment the aspect, a kind of electronic equipment is proposed, comprising:
Processor;
Memory for storage processor executable instruction;
Wherein, the processor is by running the executable instruction to realize the business as described in above-mentioned any embodiment The checking method of associated data table.
Detailed description of the invention
Fig. 1 is a kind of configuration diagram of the check system for business association tables of data that an exemplary embodiment provides.
Fig. 2 is a kind of flow chart of the screening technique for business association tables of data that an exemplary embodiment provides.
Fig. 3 is a kind of flow chart of the checking method for business association tables of data that an exemplary embodiment provides.
Fig. 4 is a kind of flow chart of the generation method for association messages that an exemplary embodiment provides.
Fig. 5 is a kind of flow chart of the checking method for business association tables of data that an exemplary embodiment provides.
Fig. 6 is a kind of process that tables of data to be checked is checked based on user defined commands that an exemplary embodiment provides Figure.
Fig. 7 is a kind of process that tables of data to be checked is checked based on history verification mode that an exemplary embodiment provides Figure.
Fig. 8 is a kind of flow chart that tables of data to be checked is checked based on preset model that an exemplary embodiment provides.
Fig. 9 is a kind of structural schematic diagram for equipment that an exemplary embodiment provides.
Figure 10 is a kind of block diagram of the screening plant for business association tables of data that an exemplary embodiment provides.
Figure 11 is the structural schematic diagram for another equipment that an exemplary embodiment provides.
Figure 12 is a kind of block diagram of the screening plant for business association tables of data that an exemplary embodiment provides.
Specific embodiment
Example embodiments are described in detail here, and 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 consistent with this specification one or more embodiment.Phase Instead, they are only some aspects phases with the one or more embodiments of as detailed in the attached claim, this specification The example of consistent device and method.
It should be understood that the sequence that might not show and describe according to this specification in other embodiments executes The step of correlation method.In some other embodiments, step included by method can than described in this specification more It is more or less.In addition, single step described in this specification, may be broken down into other embodiments multiple steps into Row description;And multiple steps described in this specification, it may also be merged into single step progress in other embodiments Description.
Fig. 1 is a kind of configuration diagram of the check system for business association tables of data that an exemplary embodiment provides.Such as Shown in Fig. 1, which may include Screening Platform 11, network 12 and verification platform 13.
Screening Platform 11 and verification platform 13 can be the physical server comprising a unique host, or may be master The virtual server of machine cluster carrying.Wherein, it is flat to can be applied to screening for the screening scheme of the business association tables of data of this specification In platform 11, which can be the log link construction platform for the implemented business operation of application server.For example, The Screening Platform 11 can be Jia Weisi log link construction platform, by traceid, construct business operation in whole business system Call relation and data manipulation (for example, write-in tables of data) link detail in system link etc..Certainly, this specification is not to sieve The concrete type of platform 11 is selected to be limited.The verification scheme of the business association tables of data of this specification can be applied to verification platform In 13.In the process of running, Screening Platform 11, which can filter out, implements in the tables of data that is related to of business operation that there are incidence relations Tables of data, i.e. the associated data table of business operation.Further, the associated data table filtered out can be informed core by Screening Platform 11 To platform 13, and then verification platform 13 can be checked associated data table the correctness to ensure the business operation.
And for the network 12 that interacts between Screening Platform 11 and verification platform 13, it may include a plurality of types of having Line or wireless network.In one embodiment, which may include Public Switched Telephone Network (Public Switched Telephone Network, PSTN) and internet.
Fig. 2 is referred to, Fig. 2 is a kind of process of the screening technique for business association tables of data that an exemplary embodiment provides Figure.As shown in Fig. 2, this method is applied to Screening Platform, may comprise steps of:
Step 202, the value of the corresponding required parameter of business operation is determined.
In one embodiment, when implementing business operation, corresponding tables of data is written in each operation system, and is generated corresponding Log.For example, DB (Database, database) operation log, interface call log, required parameter log (or message call day Will) etc..Wherein, DB operation log be used for record implement business operation when be related to tables of data (for example, each operation system reading or The tables of data of write-in) and tables of data in include field value;Interface calls log to call when implementing business operation for recording Each interface;Required parameter log operates the value of corresponding required parameter and required parameter for record traffic.Cause This can first obtain the required parameter log of the business operation when determining the value of the corresponding required parameter of business operation, then The value of the required parameter is determined according to the required parameter log.
Step 204, the tables of data for implementing to be related to when the business operation is searched, the tables of data includes through implementing the industry Business operation and the field value that is written into.
In one embodiment, the tables of data being related to when can search according to DB operation log and implement the business operation, and The field value being written into the tables of data through implementing the business operation.
Step 206, when the field value being written into there are at least two tables of data is identical as the value of the required parameter, Determine that at least two tables of data is the associated data table of the business operation.
In one embodiment, when multiple tables of data include same field value, and the same field value is also required parameter When value, illustrate that multiple tables of data is in this business operation there are the tables of data of incidence relation, as the business operation Associated data table.For example, it is assumed that business operation is to be transferred accounts from account a to account b, and tables of data A is for recording the account produced Single flowing water, tables of data B is for recording the bill flowing water being transferred to;In other words, tables of data A is being associated with for transferred account service with tables of data B Tables of data.So, when mistake does not occur for transferred account service, the amount of money (value of required parameter) transferred accounts (is recorded with the amount of money is transferred to Be transferred to the field value of the amount of money), produce the amount of money (field value that record produces the amount of money) must be equal.For example, this business operation is It transfers accounts 1000 yuan from account a to account b, then the amount of money for producing account a should be equal to by being transferred to the amount of money of account b, i.e. account a turns 1000 yuan out, account b is transferred to 1000 yuan.As it can be seen that being joined by implementing each field value and request in the tables of data that business operation is related to Numerical relation between several values filters out the associated data table of business operation, and the effect of the screening to associated data table can be improved Rate.
In one embodiment, Screening Platform can be sent after finding out the associated data table of business operation to verification platform Association messages, so that the verification platform checks the associated data table;Wherein, the association messages are used to indicate The associated data table of the business operation out.It, can be further to associated data after finding out the associated data table of business operation Table is checked, to ensure the correctness of implemented business operation.
Further, can using field value field identical with the value of the required parameter in the associated data table as Associate field, and the associate field is recorded in the association messages, then send the association to the verification platform and disappear Breath, so that the verification platform confirms whether the associated data table is tables of data to be checked according to the associate field, and Confirming that the associated data table is to check when checking tables of data the tables of data to be checked.
In one embodiment, when that there are multiple field values in the associated data table is identical as the value of the required parameter Field when, can choose in the field for major key field or non-primary key index field as the associate field.It is based on The above-mentioned selection to associate field checks platform after receiving association messages, readable to take out the pass recorded in the association messages Join field (for example, can record mark or address of associate field etc. in association messages), and is confirmed according to the associate field and be associated with Whether tables of data is wait check tables of data (tables of data for needing to check after implementing this business operation).And according to associated characters Segment acknowledgement when checking tables of data, due to the associate field be affiliated tables of data major key or non-primary key index field, The efficiency that the associate field is searched in affiliated tables of data is higher (compared to other non-primary key of selection or non-index field as association The case where field), to help to promote the efficiency that verification platform confirms tables of data to be checked.
In another embodiment, when there are the value phases of multiple field values and the required parameter in the associated data table With field when, at least one field can be chosen in the field as the associate field.In one case, the word can be chosen A field in section is as associate field, then verification platform confirms when checking tables of data according to the associate field, by In associate field only one, confirmation operation can be completed quickly, thus promoted verification platform confirm tables of data to be checked Efficiency.In another case, multiple fields in the field can be chosen as associate field, then verification platform is in basis When associate field confirmation verification tables of data, since associate field is comprising multiple, verification platform can be according to multiple associate field Confirm whether associated data table is tables of data to be checked jointly, to improve the accuracy rate of confirmation.
Based on the screening scheme of above-mentioned business association tables of data, this specification also provides a kind of core of business association tables of data To scheme, to check the associated data table filtered out by above-mentioned screening scheme.Fig. 3 is referred to, Fig. 3 is one exemplary A kind of flow chart of the checking method for business association tables of data that embodiment provides.It is put down as shown in figure 3, this method is applied to verification Platform may comprise steps of:
Step 302, the association messages that Screening Platform is sent are received, the association messages record has the incidence number of business operation According to the information of table, the associated data table contains at least two tables of data, and at least two tables of data is through implementing the industry The field value that business is operated and is written into is identical as the value of required parameter of the business operation is corresponded to.
In one embodiment, the detailed process of Screening Platform screening associated data table and transmission association messages can refer to Embodiment shown in Fig. 2 is stated, details are not described herein.
Step 304, the associated data table is checked.
In the present embodiment, described by above-mentioned embodiment illustrated in fig. 2 it is found that the association messages record relevant field Associate field is field value field identical with the value of the required parameter in the associated data table.Based in association messages Relevant field is recorded, can confirm whether the associated data table is tables of data to be checked according to the associate field, and true Recognizing the associated data table is to check when checking tables of data the tables of data to be checked.
In one embodiment, when that there are multiple field values in the associated data table is identical as the value of the required parameter Field when, it is the field of major key or the index field of non-primary key that the associate field, which is in the field,.So check platform Confirm when checking tables of data according to associate field, due to the major key or non-primary key that the associate field is affiliated tables of data Index field, the efficiency for searching the associate field in affiliated tables of data are higher (compared to choosing other non-primary key or non-index The case where field is as associate field), to help to promote the efficiency that verification platform confirms tables of data to be checked.
In another embodiment, when there are the value phases of multiple field values and the required parameter in the associated data table With field when, the associate field include the field at least one field.In one case, when being wrapped in associate field When containing a field in the field, verification platform can complete confirmation operation quickly, confirm to promote verification platform The efficiency of tables of data to be checked.In another case, when in associate field including multiple fields in the field, verification is flat Platform can confirm jointly whether associated data table is tables of data to be checked according to multiple associate field, to improve the standard of confirmation True rate.
In one embodiment, verification platform, can be by user's (ratio of verification platform when checking associated data table Such as, the research staff of platform side is checked) customized verification field and verification condition.So, verification platform can be according to receiving From the customized verification field and customized verification condition of user, the first verification instruction is generated, then executes described first Verification instruction is to check the associated data table.With the SQL ((Structured for accessing and handling database Query Language, structured query language) for, verification platform can be according to customized verification field and customized verification item Part generates verification of data SQL (the i.e. first verification instruction), then can be to associated data by executing the verification of data SQL generated Table is checked.
In one embodiment, verification platform, can will be to historical context tables of data when checking associated data table Verification mode is as reference.For example, can first determine that the target to match in historical context tables of data with the associated data table is closed Join tables of data, and the second verification generated according to the verification field and verification condition that correspond to the target association tables of data and is instructed, Execute the second verification instruction again to check the associated data table.Wherein, " matching " can be regarded as type phase With or the field that is included meaning it is mutually same.For example, historical context tables of data can be chosen when determining target association tables of data In associated data table identical with the type of associated data table as target association tables of data.
In one embodiment, verification platform, can be by training obtained mould when checking associated data table in advance Type determines the verification field and verification condition for associated data table.For example, the associated data table is inputted default mould (preset model is by historical context tables of data and the verification field and verification item corresponding to the historical context tables of data for type Part is trained to obtain), and third verification is generated according to the verification field of preset model output and verification condition and is instructed, then The third verification instruction is executed to check the associated data table.
In order to make it easy to understand, the technical solution of this specification is described in detail below with reference to citing and attached drawing.
Fig. 4 is referred to, Fig. 4 is a kind of flow chart of the generation method for association messages that an exemplary embodiment provides.Such as Shown in Fig. 4, this method is applied to Screening Platform, may comprise steps of:
Step 402, acquisition request parameter log.
Step 404, the numerical value of read requests parameter.
Step 406, database manipulation log is obtained.
Step 408, the field value that tables of data is written into is read.
In the present embodiment, when implementing business operation, corresponding tables of data is written in each operation system, and is generated corresponding Log.For example, DB (Database, database) operation log be used for record implementation business operation when be related to tables of data (for example, Each operation system is read or the tables of data of write-in) and tables of data in include field value, required parameter log is for recording industry Business operates the value of corresponding required parameter and required parameter.It therefore, can be by required parameter log come acquisition request parameter Value, the field value that tables of data is written into is obtained by DB operation log.
It should be noted that between step 402-408 and specific sequencing is not present, between step 402-408 Sequencing can flexibly be set according to the actual situation, and this specification one or more embodiment is limited not to this.
Step 410, associate field is searched.
In the present embodiment, when multiple tables of data include same field value, and the same field value is also required parameter When value, illustrate that multiple tables of data is that there are the tables of data of incidence relation, the as pass of business operation in this business operation Join tables of data.Meanwhile the corresponding field of the same field value is associate field.When in associated data table there are multiple field values with When the identical field of the value of required parameter, it can choose in the field as the index field conduct of the field or non-primary key of major key Associate field can also choose in the field one or more fields as associate field.
For example, in one case, it is assumed that when implementing business operation, operation system A is written with A table, business system System B is written with B table.Data as shown in Table 1 are obtained by DB operation log:
The tables of data of write-in Field Field value
Tables of data A (A.a,A.b,A.c) (123,789,456)
Tables of data B (B.a,B.b,B.c) (897,123,456)
Table 1
Data as shown in Table 2 are obtained by required parameter log:
Required parameter Value
id1 123
id2 456
Table 2
It is by Tables 1 and 2 it is found that identical with the value of required parameter in the field value of write-in tables of data A and tables of data B Field value is 123,456.It can determine that tables of data A and tables of data B is associated data table at this time.As it can be seen that by implementing business operation Numerical relation in the tables of data being related between each field value and the value of required parameter filters out the incidence number of business operation According to table, the screening efficiency to associated data table can be improved.Further, it is assumed that field A.a is the major key of tables of data A, then can be with Field A.a and field B.b is chosen as associate field.
In another case, it is assumed that when implementing business operation, operation system A is written with C table, operation system B write-in D table.Data as shown in table 3 are obtained by DB operation log:
The tables of data of write-in Field Field value
Tables of data C (C.a,C.b,C.c) (123,789,456)
Tables of data D (D.a,D.b,D.c) (897,123,123)
Table 3
Data as shown in table 4 are obtained by required parameter log:
Required parameter Value
id3 123
id4 667
Table 4
It is by table 3 and table 4 it is found that identical with the value of required parameter in the field value of write-in tables of data C and tables of data D Field value is 123.It can determine that tables of data C and tables of data D is associated data table at this time.Further, it is assumed that field D.b is data The index field of table D can then choose field C.a and field D.b as associate field.
In still another case, it is assumed that when implementing business operation, operation system A is written with E table, operation system B write-in F table.Data as shown in table 5 are obtained by DB operation log:
The tables of data of write-in Field Field value
Tables of data E (E.a,E.b,E.c) (123,889,456)
Tables of data F (F.a,F.b,F.c) (123,889,456)
Table 5
Data as shown in table 6 are obtained by required parameter log:
Table 6
It is by table 5 and table 6 it is found that identical with the value of required parameter in the field value of write-in tables of data E and tables of data F Field value is 123,456,889.It can determine that tables of data E and tables of data F is associated data table at this time.It further, can be by field E.a and F.a, E.b and F.b, at least a pair of of field in E.c and F.c is to as associate field.
Step 412, association messages are generated.
In the present embodiment, the associated data table and associate field determined can be recorded in association messages.For example, Screening Platform can generate data correlation SQL according to the associated data table and associate field determined.
As seen from the above-described embodiment, it can indicate that the pass of this business operation by the association messages that step 412 ultimately generates Join the associate field of tables of data (be written into and there are the tables of data of incidence relation) and the associated data table.So, screening is flat The association messages of generation can be sent to verification platform by platform, to be checked by verification platform associated data table, to ensure this The correctness of secondary business operation.
Fig. 5 is referred to, Fig. 5 is a kind of process of the checking method for business association tables of data that an exemplary embodiment provides Figure.As shown in figure 5, this method is applied to verification platform, may comprise steps of:
Step 502, the association messages that Screening Platform is sent are received.
Step 504, judge whether the associated data table recorded in association messages is tables of data to be checked, if number to be checked According to table, then it is transferred to step 506, otherwise return step 502.
In the present embodiment, recorded in association messages relevant tables of data information (for example, the mark of associated data table or The data that associated data table includes) and associate field, then may further confirm that whether associated data table is tables of data to be checked.
In one embodiment, it is undertaken in the citing of above-mentioned table 1- table 4, associate field is major key or index field.So Verification platform confirm when checking tables of data according to associate field, due to the associate field be affiliated tables of data major key or The index field of non-primary key, the efficiency that the associate field is searched in affiliated tables of data are higher (compared to other non-primary key of selection Or non-index field as associate field the case where), confirm the effect of tables of data to be checked to help to promote verification platform Rate.
In one embodiment, it is undertaken in the citing of above-mentioned table 5- table 6, includes at least one associate field in association messages. In one case, when only including an associate field, due to only needing to read the field value of an associate field, verification is flat Platform can complete confirmation operation quickly, to promote the efficiency that verification platform confirms tables of data to be checked.In another feelings Under condition, when comprising multiple associate fields, verification platform can confirm jointly that associated data table is according to multiple associate field No is tables of data to be checked, to improve the accuracy rate of confirmation.
In one embodiment, after verification platform receives association messages, the user for checking platform side can manual confirmation association Whether tables of data is tables of data to be checked.
Step 506, tables of data to be checked is checked.
In the present embodiment, verification platform is being checked when checking tables of data, the field (i.e. verification field) of required verification Can be customized by the user of verification platform side with verification condition, it can also be obtained according to historical experience, can also be obtained by training in advance Model obtain.It is described in detail below with reference to Fig. 6-8.
Fig. 6 is referred to, Fig. 6 is that one kind that an exemplary embodiment provides checks number to be checked based on user defined commands According to the flow chart of table.As shown in fig. 6, the checking method may comprise steps of:
Step 602, user defined commands are received.
In the present embodiment, verification platform treat verification tables of data (have confirmed that the associated data recorded in association messages Table is wait check tables of data) when being checked, it can be passed through by the user (for example, research staff of verification platform side) of verification platform Issue the customized verification field of custom instruction and verification condition.For example, user can be by customized verification field and verification Condition is recorded in custom instruction, and issues the custom instruction to verification platform.
Step 604, the customized verification field and customized verification condition for including in custom instruction are read.
Step 606, the first verification is generated according to customized verification field and customized verification condition to instruct.
Step 608, the first verification instruction is executed to be checked to treat verification tables of data.
In the present embodiment, for example, verification platform can be raw according to customized verification field and customized verification condition At verification of data SQL (the i.e. first verification instruction), then verification tables of data can be treated by executing the verification of data SQL generated It is checked.
Fig. 7 is referred to, Fig. 7 is that one kind that an exemplary embodiment provides checks data to be checked based on history verification mode The flow chart of table.As shown in fig. 7, the checking method may comprise steps of:
Step 702, historical context tables of data is read.
In the present embodiment, verification platform can store historical context tables of data (having confirmed that as tables of data to be checked) and Verification field and verification condition corresponding to the historical context tables of data.So, a new tables of data to be checked is being received ( The associated data table recorded in confirmation association messages is wait check tables of data) when, it can will be directed to the verification of historical context tables of data Mode is as a reference to check currently tables of data to be checked.
Step 704, the target association tables of data to match in historical context tables of data with tables of data to be checked is searched.
In the present embodiment, " match " and can be regarded as that type is identical or the meaning of the field that is included is mutually same.For example, When determining target association tables of data, associated data identical with the type of associated data table in historical context tables of data can be chosen Table is as target association tables of data.
Step 706, it reads the target verification field for corresponding to target association tables of data and target checks condition.
Step 708, field is checked according to target and target verification condition generates the second verification and instructs.
Step 710, the second verification instruction is executed to be checked to treat verification tables of data.
In the present embodiment, for example, verification platform can check field according to target and target verification condition generates needle To the verification of data SQL (the i.e. second verification instruction) of currently tables of data to be checked, then by executing the verification of data SQL generated The tables of data to be checked can be checked.
Fig. 8 is referred to, Fig. 8 is that a kind of of exemplary embodiment offer checks tables of data to be checked based on preset model Flow chart.As shown in figure 8, the checking method may comprise steps of:
Step 802, tables of data to be checked is inputted into preset model.
In the present embodiment, preset model can be by historical context tables of data and the verification for corresponding to the historical context tables of data Field and verification condition are trained to obtain, i.e. the input of the preset model is that (i.e. confirmed is to need to tables of data to be checked The associated data table checked), it exports as verification field and verification condition.
Step 804, the output result of preset model is obtained.
Step 806, third verification instruction is generated according to output result.
Step 808, it executes third verification instruction and is checked with treating verification tables of data.
In the present embodiment, for example, verification platform can be according to the verification field and verification condition that preset model exports The verification of data SQL (i.e. third verification instruction) for currently tables of data to be checked is generated, then by executing the data generated Verification SQL can check the tables of data to be checked.
Fig. 9 is a kind of structural schematic diagram for equipment that an exemplary embodiment provides.Referring to FIG. 9, in hardware view, it should Equipment includes processor 902, internal bus 904, network interface 906, memory 908 and nonvolatile memory 910, is gone back certainly It may include hardware required for other business.Processor 902 reads corresponding computer journey from nonvolatile memory 910 Then sequence is run into memory 908, the screening plant of business association tables of data is formed on logic level.Certainly, in addition to software Except implementation, this specification one or more embodiment is not precluded other implementations, such as logical device or soft Mode of combination of hardware etc., that is to say, that the executing subject of following process flow is not limited to each logic unit, can also To be hardware or logical device.
Referring to FIG. 10, in Software Implementation, the screening plant of the business association tables of data may include:
Determination unit 1001 determines the value of the corresponding required parameter of business operation;
Searching unit 1002, searches the tables of data for implementing to be related to when the business operation, and the tables of data includes through implementing The business operation and the field value being written into;
Judging unit 1003, when the value phase of the field value being written into there are at least two tables of data and the required parameter Meanwhile determining that at least two tables of data is the associated data table of the business operation.
Optionally, the determination unit 1001 is specifically used for:
Obtain the required parameter log of the business operation;
The value of the required parameter is determined according to the required parameter log.
Optionally, further includes:
Transmission unit 1004 sends association messages to verification platform, so that the verification platform is to the associated data Table is checked;
Wherein, the association messages are used to indicate out the associated data table of the business operation.
Optionally, the transmission unit 1004 is specifically used for:
Using field value field identical with the value of the required parameter in the associated data table as associate field, and The associate field is recorded in the association messages;
The association messages are sent to the verification platform, so that the verification platform confirms according to the associate field Whether the associated data table is tables of data to be checked, and confirm the associated data table for when checking tables of data to institute Tables of data to be checked is stated to be checked.
Optionally, the transmission unit 1004 is further used for:
When field identical with the value of the required parameter there are multiple field values in the associated data table, choose It is the index field of the field of major key or non-primary key in the field as the associate field.
Optionally, the transmission unit 1004 is further used for:
When field identical with the value of the required parameter there are multiple field values in the associated data table, choose At least one field is as the associate field in the field.
Figure 11 is the structural schematic diagram for another equipment that an exemplary embodiment provides.Figure 11 is please referred to, in hardware layer Face, the equipment include processor 1102, internal bus 1104, network interface 1106, memory 1108 and nonvolatile memory 1110, it is also possible that hardware required for other business certainly.Processor 1102 is read from nonvolatile memory 1110 Then corresponding computer program is run into memory 1108, the verification dress of business association tables of data is formed on logic level It sets.Certainly, other than software realization mode, other implementations are not precluded in this specification one or more embodiment, than The mode of such as logical device or software and hardware combining, that is to say, that the executing subject of following process flow is not limited to respectively A logic unit is also possible to hardware or logical device.
Figure 12 is please referred to, in Software Implementation, the checking device of the business association tables of data may include:
Receiving unit 1201, receives the association messages that Screening Platform is sent, and the association messages record has business operation The information of associated data table, the associated data table contains at least two tables of data, and at least two tables of data is through implementing The business operation and the field value that is written into is identical as the value of required parameter of the business operation is corresponded to;
Unit 1202 is checked, the associated data table is checked.
Optionally, the association messages record relevant field, and the associate field is field in the associated data table It is worth field identical with the value of the required parameter;The verification unit 1202 is specifically used for:
Confirm whether the associated data table is tables of data to be checked according to the associate field, and is confirming the pass Connection tables of data is to check when checking tables of data the tables of data to be checked.
Optionally, when there are multiple field values fields identical with the value of the required parameter in the associated data table When, it is the field of major key or the index field of non-primary key that the associate field, which is in the field,.
Optionally, when there are multiple field values fields identical with the value of the required parameter in the associated data table When, the associate field includes at least one field in the field.
Optionally, the verification unit 1202 is specifically used for:
According to the customized verification field and customized verification condition from user received, the first verification is generated Instruction;
The first verification instruction is executed to check the associated data table.
Optionally, the verification unit 1202 is specifically used for:
Determine the target association tables of data to match in historical context tables of data with the associated data table;
The second verification is generated according to the verification field and verification condition that correspond to the target association tables of data to instruct;
The second verification instruction is executed to check the associated data table.
Optionally, the verification unit 1202 is specifically used for:
The associated data table is inputted into preset model, the preset model is by historical context tables of data and corresponds to described The verification field and verification condition of historical context tables of data are trained to obtain;
Third verification is generated according to the verification field of preset model output and verification condition to instruct;
The third verification instruction is executed to check the associated data table.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity, Or it is realized by the product with certain function.A kind of typically to realize that equipment is computer, the concrete form of computer can To be personal computer, laptop computer, cellular phone, camera phone, smart phone, personal digital assistant, media play In device, navigation equipment, E-mail receiver/send equipment, game console, tablet computer, wearable device or these equipment The combination of any several equipment.
In a typical configuration, computer includes one or more processors (CPU), input/output interface, network Interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/or The forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable medium Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data. The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM), Digital versatile disc (DVD) or other optical storage, magnetic cassettes, disk storage, quantum memory, based on graphene Storage medium or other magnetic storage devices or any other non-transmission medium, can be used for storing can be accessed by a computing device Information.As defined in this article, computer-readable medium does not include temporary computer readable media (transitory media), Such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including described want There is also other identical elements in the process, method of element, commodity or equipment.
It is above-mentioned that this specification specific embodiment is described.Other embodiments are in the scope of the appended claims It is interior.In some cases, the movement recorded in detail in the claims or step can be come according to the sequence being different from embodiment It executes and desired result still may be implemented.In addition, process depicted in the drawing not necessarily require show it is specific suitable Sequence or consecutive order are just able to achieve desired result.In some embodiments, multitasking and parallel processing be also can With or may be advantageous.
The term that this specification one or more embodiment uses be only merely for for the purpose of describing particular embodiments, and It is not intended to be limiting this specification one or more embodiment.In this specification one or more embodiment and the appended claims Used in the "an" of singular, " described " and "the" be also intended to including most forms, unless context understands earth's surface Show other meanings.It is also understood that term "and/or" used herein refers to and includes one or more associated list Any or all of project may combine.
It will be appreciated that though this specification one or more embodiment may using term first, second, third, etc. come Various information are described, but these information should not necessarily be limited by these terms.These terms are only used to same type of information area each other It separates.For example, the first information can also be referred to as in the case where not departing from this specification one or more scope of embodiments Two information, similarly, the second information can also be referred to as the first information.Depending on context, word as used in this is " such as Fruit " can be construed to " ... when " or " when ... " or " in response to determination ".
The foregoing is merely the preferred embodiments of this specification one or more embodiment, not to limit this theory Bright book one or more embodiment, all within the spirit and principle of this specification one or more embodiment, that is done is any Modification, equivalent replacement, improvement etc. should be included within the scope of the protection of this specification one or more embodiment.

Claims (28)

1. a kind of screening technique of business association tables of data is applied to Screening Platform;The described method includes:
Determine the value of the corresponding required parameter of business operation;
The tables of data for implementing to be related to when the business operation is searched, the tables of data includes to be write through implementing the business operation The field value entered;
When the field value being written into there are at least two tables of data is identical as the value of the required parameter, judgement is described at least Two tables of data are the associated data table of the business operation.
2. according to the method described in claim 1, the value of the corresponding required parameter of the determining business operation, comprising:
Obtain the required parameter log of the business operation;
The value of the required parameter is determined according to the required parameter log.
3. according to the method described in claim 1, further include:
Association messages are sent to verification platform, so that the verification platform checks the associated data table;
Wherein, the association messages are used to indicate out the associated data table of the business operation.
4. according to the method described in claim 3, described send association messages to verification platform, comprising:
Using field value field identical with the value of the required parameter in the associated data table as associate field, and by institute Associate field is stated to be recorded in the association messages;
The association messages are sent to the verification platform, so that the verification platform is according to associate field confirmation Whether associated data table is tables of data to be checked, and confirm the associated data table be when checking tables of data to it is described to Verification tables of data is checked.
5. according to the method described in claim 4, the taking field value in the associated data table and the required parameter It is worth identical field as associate field, comprising:
When field identical with the value of the required parameter there are multiple field values in the associated data table, the word is chosen The field of Duan Zhongwei major key or the index field of non-primary key are as the associate field.
6. according to the method described in claim 4, the taking field value in the associated data table and the required parameter It is worth identical field as associate field, comprising:
When field identical with the value of the required parameter there are multiple field values in the associated data table, the word is chosen At least one field is as the associate field in section.
7. a kind of checking method of business association tables of data is applied to verification platform;The described method includes:
The association messages that Screening Platform is sent are received, the association messages record has the information of the associated data table of business operation, The associated data table contains at least two tables of data, and at least two tables of data is write through implementing the business operation The field value entered is identical as the value of required parameter of the business operation is corresponded to;
The associated data table is checked.
8. the associate field is the pass according to the method described in claim 7, the association messages record relevant field Join field value field identical with the value of the required parameter in tables of data;It is described that the associated data table is checked, Include:
Confirm whether the associated data table is tables of data to be checked according to the associate field, and is confirming the incidence number It is to check when checking tables of data the tables of data to be checked according to table.
9. according to the method described in claim 8, when there are multiple field values and the required parameter in the associated data table Value identical field when, it is the field of major key or the index field of non-primary key that the associate field, which is in the field,.
10. according to the method described in claim 8, when there are multiple field values and the required parameter in the associated data table Value identical field when, the associate field includes at least one field in the field.
11. according to the method described in claim 7, described check the associated data table, comprising:
According to the customized verification field and customized verification condition from user received, generates the first verification and refer to It enables;
The first verification instruction is executed to check the associated data table.
12. according to the method described in claim 7, described check the associated data table, comprising:
Determine the target association tables of data to match in historical context tables of data with the associated data table;
The second verification is generated according to the verification field and verification condition that correspond to the target association tables of data to instruct;
The second verification instruction is executed to check the associated data table.
13. according to the method described in claim 7, described check the associated data table, comprising:
The associated data table is inputted into preset model, the preset model is by historical context tables of data and corresponds to the history The verification field and verification condition of associated data table are trained to obtain;
Third verification is generated according to the verification field of preset model output and verification condition to instruct;
The third verification instruction is executed to check the associated data table.
14. a kind of screening plant of business association tables of data is applied to Screening Platform;Described device includes:
Determination unit determines the value of the corresponding required parameter of business operation;
Searching unit, searches the tables of data for implementing to be related to when the business operation, and the tables of data includes through implementing the business The field value for operating and being written into;
Judging unit is sentenced when the field value being written into there are at least two tables of data is identical as the value of the required parameter Fixed at least two tables of data is the associated data table of the business operation.
15. device according to claim 14, the determination unit is specifically used for:
Obtain the required parameter log of the business operation;
The value of the required parameter is determined according to the required parameter log.
16. device according to claim 14, further includes:
Transmission unit sends association messages to verification platform, so that the verification platform carries out core to the associated data table It is right;
Wherein, the association messages are used to indicate out the associated data table of the business operation.
17. device according to claim 16, the transmission unit is specifically used for:
Using field value field identical with the value of the required parameter in the associated data table as associate field, and by institute Associate field is stated to be recorded in the association messages;
The association messages are sent to the verification platform, so that the verification platform is according to associate field confirmation Whether associated data table is tables of data to be checked, and confirm the associated data table be when checking tables of data to it is described to Verification tables of data is checked.
18. device according to claim 17, the transmission unit is further used for:
When field identical with the value of the required parameter there are multiple field values in the associated data table, the word is chosen The field of Duan Zhongwei major key or the index field of non-primary key are as the associate field.
19. device according to claim 17, the transmission unit is further used for:
When field identical with the value of the required parameter there are multiple field values in the associated data table, the word is chosen At least one field is as the associate field in section.
20. a kind of checking device of business association tables of data is applied to verification platform;Described device includes:
Receiving unit, receives the association messages that Screening Platform is sent, and the association messages record has the associated data of business operation The information of table, the associated data table contains at least two tables of data, and at least two tables of data is through implementing the business The field value for operating and being written into is identical as the value of required parameter of the business operation is corresponded to;
Unit is checked, the associated data table is checked.
21. device according to claim 20, the association messages record relevant field, and the associate field is described Field value field identical with the value of the required parameter in associated data table;The verification unit is specifically used for:
Confirm whether the associated data table is tables of data to be checked according to the associate field, and is confirming the incidence number It is to check when checking tables of data the tables of data to be checked according to table.
22. device according to claim 21, when there are multiple field values and the request to join in the associated data table When the identical field of several values, it is the field of major key or the index field of non-primary key that the associate field, which is in the field,.
23. device according to claim 21, when there are multiple field values and the request to join in the associated data table When the identical field of several values, the associate field includes at least one field in the field.
24. device according to claim 20, the verification unit is specifically used for:
According to the customized verification field and customized verification condition from user received, generates the first verification and refer to It enables;
The first verification instruction is executed to check the associated data table.
25. device according to claim 20, the verification unit is specifically used for:
Determine the target association tables of data to match in historical context tables of data with the associated data table;
The second verification is generated according to the verification field and verification condition that correspond to the target association tables of data to instruct;
The second verification instruction is executed to check the associated data table.
26. device according to claim 20, the verification unit is specifically used for:
The associated data table is inputted into preset model, the preset model is by historical context tables of data and corresponds to the history The verification field and verification condition of associated data table are trained to obtain;
Third verification is generated according to the verification field of preset model output and verification condition to instruct;
The third verification instruction is executed to check the associated data table.
27. a kind of electronic equipment, comprising:
Processor;
Memory for storage processor executable instruction;
Wherein, the processor is by running the executable instruction to realize such as side of any of claims 1-6 Method.
28. a kind of electronic equipment, comprising:
Processor;
Memory for storage processor executable instruction;
Wherein, the processor is by running the executable instruction to realize the side as described in any one of claim 7-13 Method.
CN201810872892.2A 2018-08-02 2018-08-02 The screening of business association tables of data and checking method, device, electronic equipment Pending CN109325055A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810872892.2A CN109325055A (en) 2018-08-02 2018-08-02 The screening of business association tables of data and checking method, device, electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810872892.2A CN109325055A (en) 2018-08-02 2018-08-02 The screening of business association tables of data and checking method, device, electronic equipment

Publications (1)

Publication Number Publication Date
CN109325055A true CN109325055A (en) 2019-02-12

Family

ID=65263598

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810872892.2A Pending CN109325055A (en) 2018-08-02 2018-08-02 The screening of business association tables of data and checking method, device, electronic equipment

Country Status (1)

Country Link
CN (1) CN109325055A (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110032564A (en) * 2019-03-07 2019-07-19 阿里巴巴集团控股有限公司 A kind of determination method and apparatus of tables of data incidence relation
CN111563076A (en) * 2020-05-09 2020-08-21 咪咕文化科技有限公司 Data auditing method, device, network equipment and storage medium
CN112395286A (en) * 2019-08-16 2021-02-23 中移(苏州)软件技术有限公司 Chained data table connection method, device, equipment and storage medium
CN112685191A (en) * 2019-10-18 2021-04-20 北京京东振世信息技术有限公司 Message processing method and device
CN113282623A (en) * 2021-05-20 2021-08-20 浙江网商银行股份有限公司 Data processing method and device
WO2023056934A1 (en) * 2021-10-09 2023-04-13 北京字跳网络技术有限公司 Data processing method and apparatus, and electronic device

Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102902763A (en) * 2012-09-21 2013-01-30 东软集团股份有限公司 Method and device for relating and retrieving information processing data and processing information tasks
CN103136276A (en) * 2011-12-02 2013-06-05 阿里巴巴集团控股有限公司 System, method and device of verification of data
CN105303437A (en) * 2015-10-15 2016-02-03 中国民生银行股份有限公司 Processing method and device for account checking
CN105631737A (en) * 2015-12-18 2016-06-01 金蝶软件(中国)有限公司 Account checking method and account checking system
CN106326219A (en) * 2015-06-16 2017-01-11 阿里巴巴集团控股有限公司 Business system data check method, apparatus and system
CN106447246A (en) * 2015-08-06 2017-02-22 阿里巴巴集团控股有限公司 Inventory data account checking method and inventory data account checking device
CN107153646A (en) * 2016-03-02 2017-09-12 阿里巴巴集团控股有限公司 A kind of data processing method and equipment
CN107169003A (en) * 2017-03-31 2017-09-15 北京奇艺世纪科技有限公司 A kind of data correlation method and device
CN107193842A (en) * 2016-03-15 2017-09-22 阿里巴巴集团控股有限公司 A kind of hardware and software platform system business localization method and device
CN107239467A (en) * 2016-03-29 2017-10-10 北京神州泰岳软件股份有限公司 Data processing method and device based on database
CN108038175A (en) * 2017-09-30 2018-05-15 用友金融信息技术股份有限公司 Multidimensional data dynamically associates querying method, device, computer equipment and medium
CN108280226A (en) * 2018-02-12 2018-07-13 中国银行股份有限公司 Data processing method and relevant device

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103136276A (en) * 2011-12-02 2013-06-05 阿里巴巴集团控股有限公司 System, method and device of verification of data
CN102902763A (en) * 2012-09-21 2013-01-30 东软集团股份有限公司 Method and device for relating and retrieving information processing data and processing information tasks
CN106326219A (en) * 2015-06-16 2017-01-11 阿里巴巴集团控股有限公司 Business system data check method, apparatus and system
CN106447246A (en) * 2015-08-06 2017-02-22 阿里巴巴集团控股有限公司 Inventory data account checking method and inventory data account checking device
CN105303437A (en) * 2015-10-15 2016-02-03 中国民生银行股份有限公司 Processing method and device for account checking
CN105631737A (en) * 2015-12-18 2016-06-01 金蝶软件(中国)有限公司 Account checking method and account checking system
CN107153646A (en) * 2016-03-02 2017-09-12 阿里巴巴集团控股有限公司 A kind of data processing method and equipment
CN107193842A (en) * 2016-03-15 2017-09-22 阿里巴巴集团控股有限公司 A kind of hardware and software platform system business localization method and device
CN107239467A (en) * 2016-03-29 2017-10-10 北京神州泰岳软件股份有限公司 Data processing method and device based on database
CN107169003A (en) * 2017-03-31 2017-09-15 北京奇艺世纪科技有限公司 A kind of data correlation method and device
CN108038175A (en) * 2017-09-30 2018-05-15 用友金融信息技术股份有限公司 Multidimensional data dynamically associates querying method, device, computer equipment and medium
CN108280226A (en) * 2018-02-12 2018-07-13 中国银行股份有限公司 Data processing method and relevant device

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110032564A (en) * 2019-03-07 2019-07-19 阿里巴巴集团控股有限公司 A kind of determination method and apparatus of tables of data incidence relation
CN110032564B (en) * 2019-03-07 2023-07-14 创新先进技术有限公司 Method and device for determining association relation of data table
CN112395286A (en) * 2019-08-16 2021-02-23 中移(苏州)软件技术有限公司 Chained data table connection method, device, equipment and storage medium
CN112395286B (en) * 2019-08-16 2022-12-13 中移(苏州)软件技术有限公司 Chained data table connection method, device, equipment and storage medium
CN112685191A (en) * 2019-10-18 2021-04-20 北京京东振世信息技术有限公司 Message processing method and device
CN112685191B (en) * 2019-10-18 2023-09-22 北京京东振世信息技术有限公司 Message processing method and device
CN111563076A (en) * 2020-05-09 2020-08-21 咪咕文化科技有限公司 Data auditing method, device, network equipment and storage medium
CN111563076B (en) * 2020-05-09 2023-06-30 咪咕文化科技有限公司 Data auditing method, device, network equipment and storage medium
CN113282623A (en) * 2021-05-20 2021-08-20 浙江网商银行股份有限公司 Data processing method and device
WO2023056934A1 (en) * 2021-10-09 2023-04-13 北京字跳网络技术有限公司 Data processing method and apparatus, and electronic device

Similar Documents

Publication Publication Date Title
CN109325055A (en) The screening of business association tables of data and checking method, device, electronic equipment
US10255108B2 (en) Parallel execution of blockchain transactions
CN102725753B (en) Method and apparatus for optimizing data access, method and apparatus for optimizing data storage
CN111898139B (en) Data reading and writing method and device and electronic equipment
CN107368259A (en) A kind of method and apparatus that business datum is write in the catenary system to block
CN109146638B (en) Method and device for identifying abnormal financial transaction group
CN107679082A (en) Question and answer searching method, device and electronic equipment
US20180300296A1 (en) Document similarity analysis
CN109472609A (en) A kind of air control method for determining reason and device
CN110750530B (en) Service system and data checking method thereof
CN105243124A (en) Resource combination processing method and apparatus
CN107526828A (en) Page info recommends method and apparatus
CN108694664A (en) Checking method and device, the electronic equipment of operation system
US20140324839A1 (en) Determining candidate scripts from a catalog of scripts
CN110263817B (en) Risk grade classification method and device based on user account
CN103226610A (en) Method and device for querying database table
CN112035676B (en) User operation behavior knowledge graph construction method and device
CN107729330A (en) The method and apparatus for obtaining data set
CN110516918B (en) Risk identification method and risk identification device
CN107133163A (en) A kind of method and apparatus for verifying description class API
CN106202049A (en) A kind of hot word determines method and device
US8417594B2 (en) Dimension-based financial reporting using multiple combinations of dimensions
CN110941952A (en) Method and device for perfecting audit analysis model
CN109582476A (en) Data processing method, apparatus and system
CN113094414B (en) Method and device for generating circulation map

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
TA01 Transfer of patent application right

Effective date of registration: 20200923

Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands

Applicant after: Advanced innovation technology Co.,Ltd.

Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands

Applicant before: Alibaba Group Holding Ltd.

Effective date of registration: 20200923

Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands

Applicant after: Innovative advanced technology Co.,Ltd.

Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands

Applicant before: Advanced innovation technology Co.,Ltd.

TA01 Transfer of patent application right
RJ01 Rejection of invention patent application after publication

Application publication date: 20190212

RJ01 Rejection of invention patent application after publication