CN105095384A - Method and device for data carrying-over - Google Patents
Method and device for data carrying-over Download PDFInfo
- Publication number
- CN105095384A CN105095384A CN201510376695.8A CN201510376695A CN105095384A CN 105095384 A CN105095384 A CN 105095384A CN 201510376695 A CN201510376695 A CN 201510376695A CN 105095384 A CN105095384 A CN 105095384A
- Authority
- CN
- China
- Prior art keywords
- data
- source
- carried
- carrying
- carried down
- 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.)
- Granted
Links
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for data carrying-over, which increase correctness of the data carrying-over. The method for the data carrying-over provided by the invention comprises that whether data exists in an intermediate sheet is judged, and data in a source sheet corresponding to a data primary key in the intermediate sheet is taken as data to be carried over if the data exists in the intermediate sheet; if the data does not exists in the intermediate sheet, a primary key of data selected in advance from the source sheet is stored in the intermediate sheet, and the pre-selected data is taken as the data to be carried over; the data to be carried-over is fragmented, and a plurality of threads in a thread pool are then started; the multiple threads acquire the data corresponding to the data primary key from the source sheet in a mutually unrepeated manner respectively according to the data primary key in the intermediate sheet, and then the acquired data is carried over to a target sheet; and after the acquired data is carried over by the multiple threads to the target sheet, whether the data to be carried over is consistent before and after the carrying-over is judged, and then a judgment result is output.
Description
Technical field
The present invention relates to field of computer technology, particularly a kind of data method and apparatus of carrying down.
Background technology
Along with the development of computer application system, the data volume in database is also in sustainable growth, so the data scheme of carrying down becomes the important means reducing database pressure.Data are carried down and are mainly referred to the part or all of data batchmove in a database in another database.
Some current file system provide the scheme that data are carried down, the data such as utilizing Hadoop+sqoop can realize between Hadoop distributed file system (hdfs) and relevant database are transmitted, thus can data batchmove between implementation relation type database by hfds.Specifically, first, utilize sqoop data to be carried in hfds from relevant database (such as SQLServer database), and then oppositely carry over data in hdfs among another relevant database (such as another one SQLServer database).
The data utilizing current file system to provide are carried down scheme, can reach very large data throughout, i.e. the data volume of each batch of transfer is very large, and system can horizontal extension, also can integration across database transfer.But its shortcoming is mainly difficult to the correctness of carrying down ensureing each data.
Summary of the invention
In view of this, the invention provides the method and apparatus that a kind of data are carried down, contribute to the correctness that raising data are carried down.Other objects of the present invention and effect can draw from embodiment.
For achieving the above object, according to an aspect of the present invention, a kind of method that data are carried down is provided.
The method that data of the present invention are carried down comprises: judge whether there are data in middle table, if so, using data corresponding in the table of source for the data major key in middle table as data to be carried down; Otherwise the major key of the data chosen in advance in being shown in source is saved in middle table, and using the described data chosen in advance as data to be carried down; By data fragmentation described to be carried down, then open the multiple threads in thread pool; Described multiple thread does not repeatedly obtain data corresponding to this data major key according to the data major key in middle table mutually separately from the table of source, then carries down to object table by the data of acquisition; Carry down at described multiple thread after object table by the data of acquisition, then whether data to be carried down described in judgement unanimously export judged result before and after carrying down.
Alternatively, before and after carrying down, whether consistent step comprises data to be carried down described in described judgement: calculate the data to be carried down in the table of source respectively and carry down to the scale-of-two proof test value of the data in object table, thus obtaining source hash table and target hash table respectively; Whether consistent with target hash table according to the hash table of described source, whether data to be carried down described in determining are consistent before and after carrying down.
Alternatively, described source table and object table are the tables of data in SQLServer database; Data to be carried down in the table of described calculating source comprise with the step of carrying down to the scale-of-two proof test value of the data in object table: use binary_checksum function obtain the data to be carried down in the table of source and carry down to the scale-of-two proof test value of the data in object table.
Whether alternatively, consistent with target hash table according to the hash table of described source, before and after carrying down, whether consistent step comprises data to be carried down described in determining: with target hash table for reference, adopts JAVA statement removeall to operate source hash table; After described operation completes, if judge, without remaining data in the hash table of source, described in then determining, data to be carried down are at self-consistentency of carrying down, otherwise are inconsistent.
Alternatively, after the step of described output judged result, also comprise: if described judged result is consistent, then delete the data in middle table and the data in the table of source; If described judged result is inconsistent, then export information.
According to a further aspect in the invention, the device that a kind of data are carried down is provided.
The device that data of the present invention are carried down comprises: judge module, for judging whether there are data in middle table; Module preserved by major key, and for when middle table does not exist data, the major key of the data chosen in advance in being shown in source is saved in middle table; Data major key in middle table corresponding data in the table of source, for when middle table exists data, are carried out burst by burst module, and when middle table does not exist data, the data fragmentation chosen in advance during source is shown; Thread pool module, for the multiple threads in management thread pond, wherein said multiple thread does not repeatedly obtain data corresponding to this data major key according to the major key of the data in middle table mutually separately from the table of source, then carries down to object table by the data of acquisition; Correction verification module, for carrying down at described multiple thread after object table by the data of acquisition, then whether data to be carried down described in judgement unanimously export judged result before and after carrying down.
Alternatively, described correction verification module also for: calculate the data to be carried down in the table of source respectively and carry down to the scale-of-two proof test value of the data in object table, thus obtaining source hash table and target hash table respectively; Whether consistent with target hash table according to the hash table of described source, whether data to be carried down described in determining are consistent before and after carrying down.
Alternatively, described source table and object table are the tables of data in SQLServer database; Described correction verification module is also for using binary_checksum function obtain the data to be carried down in the table of source and carry down to the scale-of-two proof test value of the data in object table.
Alternatively, described correction verification module also for: with target hash table for reference, adopt JAVA statement removeall to operate source hash table; After described operation completes, if judge, without remaining data in the hash table of source, described in then determining, data to be carried down are at self-consistentency of carrying down, otherwise are inconsistent.
Alternatively, also comprise removing module and reminding module, wherein: removing module is used for when described comparative result is consistent, delete the data in middle table and the data in the table of source; Reminding module is used for when described comparative result is inconsistent, exports information.
According to technical scheme of the present invention, have employed multi-thread mechanism, contribute to ensureing that data are carried down efficiency; Whether unanimously verify before and after on this basis data being carried down, ensure to carry down the correctness of front and back data; Adopt middle table to preserve data major key in addition, contribute to not losing process and not re-treatment when ensureing data processing.
Accompanying drawing explanation
Accompanying drawing is used for understanding the present invention better, does not form inappropriate limitation of the present invention.Wherein:
Fig. 1 is the schematic diagram of the key step of the method for carrying down according to the data of embodiment of the present invention;
Fig. 2 is the schematic diagram of the element of the device of carrying down according to the data of embodiment of the present invention.
Embodiment
Below in conjunction with accompanying drawing, exemplary embodiment of the present invention is explained, comprising the various details of embodiment of the present invention to help understanding, they should be thought it is only exemplary.Therefore, those of ordinary skill in the art will be appreciated that, can make various change and amendment, and can not deviate from scope and spirit of the present invention to embodiment described herein.Equally, for clarity and conciseness, the description to known function and structure is eliminated in following description.
In embodiments of the present invention, by data from source table dump to object table, these data can according to configuration choose source table in all or part of.Preserved the major key of the data that will carry down by middle table, then again these data are carried down to object table from source table data query by the data major key in middle table.Specifically can by the flow performing shown in Fig. 1, Fig. 1 is the schematic diagram of the key step of the method for carrying down according to the data of embodiment of the present invention.This flow process can adopt the program assembly of exploitation separately.
Step S11: loading configuration file information.Such as source table and the object table source database information at place and target data library information, the username and password logging in source database and target database needs and which data etc. of will carrying down respectively are configured with in configuration file.
Step S12: judge whether there are data in middle table.These data may be because carried down and verify unsuccessfully last time, power-off and run into various abnormal conditions cause in data are carried down.If there are data, first residual data is carried down at this, therefore directly entered step S14, otherwise entered step S13.
Step S13: middle table put into by the major key of the data that will carry down in being shown in source.The major key of data is unique identifications of data.
Step S14: by data fragmentation, then opens multiple thread.Now first can calculate the data total amount that will carry down, then determine the size of every sheet.Here multiple threads can adopt thread pool unified management, and the data slice of each thread process is not repeated mutually.
Step S15: each thread is carried down to data.In this step, each thread takes out the major key of oneself data to be processed from middle table, inquires about data corresponding to this major key, then carry down these data to object table from the table of source.After having carried down, mark can be added to indicate that the data that this major key is corresponding have been carried down in middle table.After all threads to complete the data that oneself will be carried down and carry down, enter step S16.
Step S16: judge whether data to be carried down are consistent before and after carrying down.Whether this step unanimously verifies the data of front and back of carrying down.Have the data before carrying down in the table of source, comprise the data after carrying down in object table, whether the data before the carrying down of more identical major key are identical with the data after carrying down, and can determine whether data to be carried down are consistent in front and back of carrying down.If consistent, then illustrate and carry down correctly, enter step S17, otherwise enter step S18.
Step S17: delete the data in middle table and source table.So far, data flow process of carrying down completes.
Step S18: export information.Such personnel just can learn to carry down and occur extremely, to process in time.
In above step, the data that being different from existing file system provides are carried down scheme, have employed multi-thread mechanism in above-mentioned flow process, contribute to ensureing that data are carried down efficiency; Whether unanimously verify before and after on this basis data being carried down, ensure to carry down the correctness of front and back data; Adopt middle table to preserve data major key in addition, contribute to not losing process and not re-treatment when ensureing data processing.
In embodiments of the present invention, when carrying out the judgement in step S16, first can calculate the data to be carried down in the table of source respectively and carrying down to the scale-of-two proof test value of the data in object table, thus obtaining source hash table and target hash table respectively; Then determine whether data to be carried down are consistent before and after carrying down according to whether source hash table and target hash table be consistent.As source database and target database adopt SQLServer database, then binary_checksum function can be used to the data to be carried down obtained in the table of source and carry down to the scale-of-two proof test value of the data in object table.Determining wait carrying down data when whether front and back of carrying down are consistent, a fast mode adopts JAVA program, wherein mainly with target hash table for reference, JAVA statement removeall is adopted to operate source hash table, so just data consistent with target hash table in the hash table of source are deleted, after having operated, if judge in the hash table of source with or without remaining data, if without, illustrate that data to be carried down are at self-consistentency of carrying down, otherwise be then inconsistent.
Fig. 2 is the schematic diagram of the element of the device of carrying down according to the data of embodiment of the present invention.As shown in Figure 2, the device 20 that the data of embodiment of the present invention are carried down mainly comprises judge module 21, major key preserves module 22, burst module 23, thread pool module 24 and correction verification module 25.
Judge module 21 is for judging whether there are data in middle table; Major key preserves module 22 for when middle table does not exist data, and the major key of the data chosen in advance in being shown in source is saved in middle table; Data major key in middle table corresponding data in the table of source, for when middle table exists data, are carried out burst by burst module 23, and when middle table does not exist data, the data fragmentation chosen in advance during source is shown; Thread pool module 24 is for the multiple threads in management thread pond, and wherein said multiple thread does not repeatedly obtain data corresponding to this data major key according to the major key of the data in middle table mutually separately from the table of source, then carries down to object table by the data of acquisition; Correction verification module 25 is for carrying down at described multiple thread after object table by the data of acquisition, and then whether data to be carried down described in judgement unanimously export judged result before and after carrying down.
According to embodiment of the present invention, have employed multi-thread mechanism, contribute to ensureing that data are carried down efficiency; Whether unanimously verify before and after on this basis data being carried down, ensure to carry down the correctness of front and back data; Adopt middle table to preserve data major key in addition, contribute to not losing process and not re-treatment when ensureing data processing.
Above-mentioned embodiment, does not form limiting the scope of the invention.It is to be understood that depend on designing requirement and other factors, various amendment, combination, sub-portfolio can be there is and substitute in those skilled in the art.Any amendment done within the spirit and principles in the present invention, equivalent replacement and improvement etc., all should be included within scope.
Claims (10)
1. a data method of carrying down, is characterized in that, comprising:
Judge whether there are data in middle table, if so, using data corresponding in the table of source for the data major key in middle table as data to be carried down; Otherwise the major key of the data chosen in advance in being shown in source is saved in middle table, and using the described data chosen in advance as data to be carried down;
By data fragmentation described to be carried down, then open the multiple threads in thread pool;
Described multiple thread does not repeatedly obtain data corresponding to this data major key according to the data major key in middle table mutually separately from the table of source, then carries down to object table by the data of acquisition;
Carry down at described multiple thread after object table by the data of acquisition, then whether data to be carried down described in judgement unanimously export judged result before and after carrying down.
2. method according to claim 1, is characterized in that, before and after carrying down, whether consistent step comprises data to be carried down described in described judgement:
Calculate the data to be carried down in the table of source respectively and carry down to the scale-of-two proof test value of the data in object table, thus obtaining source hash table and target hash table respectively;
Whether consistent with target hash table according to the hash table of described source, whether data to be carried down described in determining are consistent before and after carrying down.
3. method according to claim 2, is characterized in that,
Described source table and object table are the tables of data in SQLServer database;
Data to be carried down in the table of described calculating source comprise with the step of carrying down to the scale-of-two proof test value of the data in object table: use binary_checksum function obtain the data to be carried down in the table of source and carry down to the scale-of-two proof test value of the data in object table.
4. whether method according to claim 2, is characterized in that, consistent with target hash table according to the hash table of described source, and before and after carrying down, whether consistent step comprises data to be carried down described in determining:
With target hash table for reference, JAVA statement removeall is adopted to operate source hash table;
After described operation completes, if judge, without remaining data in the hash table of source, described in then determining, data to be carried down are at self-consistentency of carrying down, otherwise are inconsistent.
5. method according to any one of claim 1 to 4, is characterized in that, after the step of described output judged result, also comprises: if described judged result is consistent, then delete the data in middle table and the data in the table of source; If described judged result is inconsistent, then export information.
6. a data device of carrying down, is characterized in that, comprising:
Judge module, for judging whether there are data in middle table;
Module preserved by major key, and for when middle table does not exist data, the major key of the data chosen in advance in being shown in source is saved in middle table;
Data major key in middle table corresponding data in the table of source, for when middle table exists data, are carried out burst by burst module, and when middle table does not exist data, the data fragmentation chosen in advance during source is shown;
Thread pool module, for the multiple threads in management thread pond, wherein said multiple thread does not repeatedly obtain data corresponding to this data major key according to the major key of the data in middle table mutually separately from the table of source, then carries down to object table by the data of acquisition;
Correction verification module, for carrying down at described multiple thread after object table by the data of acquisition, then whether data to be carried down described in judgement unanimously export judged result before and after carrying down.
7. device according to claim 6, is characterized in that, described correction verification module also for:
Calculate the data to be carried down in the table of source respectively and carry down to the scale-of-two proof test value of the data in object table, thus obtaining source hash table and target hash table respectively;
Whether consistent with target hash table according to the hash table of described source, whether data to be carried down described in determining are consistent before and after carrying down.
8. device according to claim 7, is characterized in that,
Described source table and object table are the tables of data in SQLServer database;
Described correction verification module is also for using binary_checksum function obtain the data to be carried down in the table of source and carry down to the scale-of-two proof test value of the data in object table.
9. device according to claim 7, is characterized in that, described correction verification module also for:
With target hash table for reference, JAVA statement removeall is adopted to operate source hash table;
After described operation completes, if judge, without remaining data in the hash table of source, described in then determining, data to be carried down are at self-consistentency of carrying down, otherwise are inconsistent.
10. the device according to any one of claim 6 to 9, is characterized in that, also comprises removing module and reminding module, wherein:
Removing module is used for when described comparative result is consistent, deletes the data in middle table and the data in the table of source;
Reminding module is used for when described comparative result is inconsistent, exports information.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510376695.8A CN105095384B (en) | 2015-07-01 | 2015-07-01 | The method and apparatus that data are carried down |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510376695.8A CN105095384B (en) | 2015-07-01 | 2015-07-01 | The method and apparatus that data are carried down |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105095384A true CN105095384A (en) | 2015-11-25 |
CN105095384B CN105095384B (en) | 2018-09-14 |
Family
ID=54575821
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510376695.8A Active CN105095384B (en) | 2015-07-01 | 2015-07-01 | The method and apparatus that data are carried down |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105095384B (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105930389A (en) * | 2016-04-14 | 2016-09-07 | 北京京东尚科信息技术有限公司 | Method and system for transferring data |
CN106469226A (en) * | 2016-09-30 | 2017-03-01 | 安徽马钢自动化信息技术有限公司 | Data communication method based on data base's middle table |
CN107315752A (en) * | 2016-04-27 | 2017-11-03 | 北京京东尚科信息技术有限公司 | Data are carried down method and system |
CN107391508A (en) * | 2016-05-16 | 2017-11-24 | 顺丰科技有限公司 | Data load method and system |
CN107861799A (en) * | 2016-12-28 | 2018-03-30 | 平安科技(深圳)有限公司 | task processing method and device based on multi-thread environment |
CN108470045A (en) * | 2018-03-06 | 2018-08-31 | 平安科技(深圳)有限公司 | The method and storage medium that electronic device, data chain type are filed |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1032175A2 (en) * | 1999-01-07 | 2000-08-30 | Sun Microsystems, Inc. | System and method for transferring partitioned data sets over multiple threads |
CN1758631A (en) * | 2004-10-08 | 2006-04-12 | 乐金电子(中国)研究开发中心有限公司 | Integral method of transmit table information of disperse data packet transmit system |
CN102084360A (en) * | 2008-04-06 | 2011-06-01 | 弗森-艾奥公司 | Apparatus, system, and method for validating that a correct data segment is read from a data storage device |
US20140195636A1 (en) * | 2013-01-04 | 2014-07-10 | International Business Machines Corporation | Cloud Based Data Migration and Replication |
CN104639298A (en) * | 2013-11-08 | 2015-05-20 | 腾讯科技(深圳)有限公司 | Data transmission method, device and system |
CN104731888A (en) * | 2015-03-12 | 2015-06-24 | 北京奇虎科技有限公司 | Data migration method, device and system |
-
2015
- 2015-07-01 CN CN201510376695.8A patent/CN105095384B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1032175A2 (en) * | 1999-01-07 | 2000-08-30 | Sun Microsystems, Inc. | System and method for transferring partitioned data sets over multiple threads |
CN1758631A (en) * | 2004-10-08 | 2006-04-12 | 乐金电子(中国)研究开发中心有限公司 | Integral method of transmit table information of disperse data packet transmit system |
CN102084360A (en) * | 2008-04-06 | 2011-06-01 | 弗森-艾奥公司 | Apparatus, system, and method for validating that a correct data segment is read from a data storage device |
US20140195636A1 (en) * | 2013-01-04 | 2014-07-10 | International Business Machines Corporation | Cloud Based Data Migration and Replication |
CN104639298A (en) * | 2013-11-08 | 2015-05-20 | 腾讯科技(深圳)有限公司 | Data transmission method, device and system |
CN104731888A (en) * | 2015-03-12 | 2015-06-24 | 北京奇虎科技有限公司 | Data migration method, device and system |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105930389A (en) * | 2016-04-14 | 2016-09-07 | 北京京东尚科信息技术有限公司 | Method and system for transferring data |
CN107315752A (en) * | 2016-04-27 | 2017-11-03 | 北京京东尚科信息技术有限公司 | Data are carried down method and system |
CN107315752B (en) * | 2016-04-27 | 2020-07-31 | 北京京东尚科信息技术有限公司 | Data transfer method and system |
CN107391508A (en) * | 2016-05-16 | 2017-11-24 | 顺丰科技有限公司 | Data load method and system |
CN107391508B (en) * | 2016-05-16 | 2020-07-17 | 顺丰科技有限公司 | Data loading method and system |
CN106469226A (en) * | 2016-09-30 | 2017-03-01 | 安徽马钢自动化信息技术有限公司 | Data communication method based on data base's middle table |
CN107861799A (en) * | 2016-12-28 | 2018-03-30 | 平安科技(深圳)有限公司 | task processing method and device based on multi-thread environment |
CN107861799B (en) * | 2016-12-28 | 2020-12-25 | 平安科技(深圳)有限公司 | Task processing method and device based on multi-thread environment |
CN108470045A (en) * | 2018-03-06 | 2018-08-31 | 平安科技(深圳)有限公司 | The method and storage medium that electronic device, data chain type are filed |
CN108470045B (en) * | 2018-03-06 | 2020-02-18 | 平安科技(深圳)有限公司 | Electronic device, data chain archiving method and storage medium |
US11106649B2 (en) | 2018-03-06 | 2021-08-31 | Ping An Technology (Shenzhen) Co., Ltd. | Electronic apparatus, data chain archiving method, system and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN105095384B (en) | 2018-09-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105095384A (en) | Method and device for data carrying-over | |
CN110147411B (en) | Data synchronization method, device, computer equipment and storage medium | |
CN105243067B (en) | A kind of method and device for realizing real-time incremental synchrodata | |
EP3049983B1 (en) | Adaptive and recursive filtering for sample submission | |
US10360203B2 (en) | Systems and methods for generating and implementing database audit functionality across multiple platforms | |
CN111858146B (en) | Method, apparatus and computer program product for recovering data | |
EP2897401B1 (en) | Method and device for guaranteeing consistency of planning data | |
CN114564446B (en) | File storage method, device, system and storage medium | |
US9544177B2 (en) | System and method for contact merge management | |
CN105069128A (en) | Data synchronization method and apparatus | |
CN110855812B (en) | Positioning method, device and equipment based on IP address | |
CN110460668B (en) | File uploading method and device, computer equipment and storage medium | |
CN104079623A (en) | Method and system for controlling multilevel cloud storage synchrony | |
CN109299116B (en) | Data synchronization method, device, equipment and readable storage medium | |
US20130024420A1 (en) | Data synchronization | |
EP3208751A1 (en) | Method and unit for building semantic rule for a semantic data | |
GB2505186A (en) | Using machine learning to categorise software items | |
CN102054036B (en) | File synchronizing method and device | |
CN111385613B (en) | Television system repairing method, storage medium and application server | |
CN103559204A (en) | Database operation request processing method, unit and system | |
CN107766386B (en) | Solr data migration method and device | |
US20190116238A1 (en) | Cache management using a probabilistic data structure | |
CN105630850B (en) | Method and system for verifying data of distributed database in real time | |
US20170139969A1 (en) | Method for filtering and analyzing big data, electronic device, and non-transitory computer-readable storage medium | |
CN103970792A (en) | Index-based file comparison method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |