CN106599300B - Distributed system database structure comparison method and device - Google Patents
Distributed system database structure comparison method and device Download PDFInfo
- Publication number
- CN106599300B CN106599300B CN201611239539.8A CN201611239539A CN106599300B CN 106599300 B CN106599300 B CN 106599300B CN 201611239539 A CN201611239539 A CN 201611239539A CN 106599300 B CN106599300 B CN 106599300B
- Authority
- CN
- China
- Prior art keywords
- distributed system
- partition
- system database
- index
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a distributed system database structure comparison method and device. Firstly, two databases are compared, and data tables with the same table name and data tables with different table names in the two databases are determined. And for the data with the same table name, further comparing the table field information, the index information and the partition information of the two data tables, and determining whether the structures of the two databases are the same according to the comparison result. Compared with the prior art, the method and the system can automatically compare the database structures of a plurality of sets of parallel systems of the bank based on the table field information, the index information and the partition information, and improve the working efficiency of developers.
Description
Technical Field
The present application relates to the field of column finance, and more particularly, to a method and apparatus for database structure comparison in a distributed system.
Background
In a bank system, a disaster recovery center is an important component of bank information construction, and the core idea is that a plurality of parallel systems or one system is constructed to be connected with a plurality of databases, so that a fault access point can be quickly switched when an unexpected occurrence occurs, and the transaction operation is not influenced. In addition, in order to reduce the operation risk of the bank system, each set of system in the production environment generally needs to configure a set of the same system in the test environment, and when a developer modifies a system code or parameter, the developer can deploy a new version of the system to the production environment after the system passes the test in the test environment.
The same functional system must maintain the consistency of the database structure, whether between sets of parallel systems or between the production environment and the test environment. At present, usually, developers log in two sets of comparison databases respectively, and manually compare structural differences which may exist, so that the comparison work efficiency is low.
Disclosure of Invention
In view of this, the present application provides a method and an apparatus for comparing database structures of distributed systems, so as to automatically compare database structures of multiple sets of systems, thereby improving the working efficiency of developers.
In order to achieve the above object, the following solutions are proposed:
a distributed system database structure comparison method comprises the following steps:
determining data tables with the same table name and data tables with different table names in a first distributed system database and a second distributed system database;
for data tables with the same table name, comparing table field information of a first data table and a second data table, and outputting a first comparison result based on the difference of the table field information, wherein the first data table and the second data table are the data tables with the same table name;
comparing the index information of the first data table and the second data table, and outputting a second comparison result based on the difference of the index information;
comparing the partition information of the first data table and the second data table, and outputting a third comparison result based on the difference of the index partition information;
and outputting a database structure comparison result based on the data tables with different table names, the first comparison result, the second comparison result and the third comparison result.
Preferably, the determining the data tables with the same table name and the data tables with different table names in the first distributed system database and the second distributed system database includes:
acquiring a first table name list of the first distributed system database and a second table name list of the second distributed system database;
and comparing the first table name list with the second table name list, and determining the data tables with the same table names and the data tables with different table names.
Preferably, the comparing table field information of the first data table and the second data table includes:
acquiring a first table field information list of the first distributed system database and a second table field information list of the second distributed system database;
the table field information includes: a table field name, a table field type, a table field length, and a table field significand;
comparing the first table field information list and the second table field information list.
Preferably, the comparing the index information of the first data table and the second data table includes:
acquiring a first index information list of the first distributed system database and an index information list of the second distributed system database;
wherein the index information includes: the index table comprises a total index name, a total index column position, uniqueness, partition index types, partition index numbers, partition index column names, partition index column positions and partition index names;
comparing the first index information list and the second index information list.
Preferably, the comparing the partition information of the first data table and the second data table includes:
acquiring a first partition information list of the first distributed system database and a second partition information list of the second distributed system database;
wherein the partition information includes: partition type, partition number, partition column information and partition names;
comparing the first partition information list and the second partition information list.
A distributed system database structure comparison apparatus, comprising:
the table name comparison unit is used for determining data tables with the same table name and data tables with different table names in the first distributed system database and the second distributed system database;
the table field information comparison unit is used for comparing the table field information of a first data table and a second data table for the data tables with the same table name, and outputting a first comparison result based on the difference of the table field information, wherein the first data table and the second data table are the data tables with the same table name;
a table index information comparison unit configured to compare index information of the first data table and the second data table, and output a second comparison result based on a difference of the index information;
the partition information comparison unit is used for comparing the partition information of the first data table and the second data table and outputting a third comparison result based on the difference of the index partition information;
and the result output unit is used for outputting a database structure comparison result based on the data tables with different table names, the first comparison result, the second comparison result and the third comparison result.
Preferably, the table name comparing unit includes:
the table name list acquisition module is used for acquiring a first table name list of the first distributed system database and a second table name list of the second distributed system database;
and the first comparison module is used for comparing the first table name list with the second table name list and determining the data tables with the same table names and the data tables with different table names.
Preferably, the table field information comparing unit includes:
a table field list obtaining module, configured to obtain a first table field information list of the first distributed system database and a second table field information list of the second distributed system database;
the table field information includes: a table field name, a table field type, a table field length, and a table field significand;
a second comparison module for comparing the first table field information list and the second table field information list.
Preferably, the index information comparing unit includes:
an index information list obtaining module, configured to obtain a first index information list of the first distributed system database and an index information list of the second distributed system database;
wherein the index information includes: the index table comprises a total index name, a total index column position, uniqueness, partition index types, partition index numbers, partition index column names, partition index column positions and partition index names;
and the third comparison module is used for comparing the first index information list with the second index information list.
Preferably, the partition information comparing unit includes:
a partition information list obtaining module, configured to obtain a first partition information list of the first distributed system database and a second partition information list of the second distributed system database;
wherein the partition information includes: partition type, partition number, partition column information and partition names;
and the fourth comparison module is used for comparing the first partition information list with the second partition information list.
By the technical scheme, the application discloses a distributed system database structure comparison method and device. Firstly, two databases are compared, and data tables with the same table name and data tables with different table names in the two databases are determined. And for the data with the same table name, further comparing the table field information, the index information and the partition information of the two data tables, and determining whether the structures of the two databases are the same according to the comparison result. Compared with the prior art, the method and the system can automatically compare the database structures of a plurality of sets of parallel systems of the bank based on the table field information, the index information and the partition information, and improve the working efficiency of developers.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of a distributed system database structure comparison method according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a distributed system database structure comparison apparatus according to another embodiment of the present invention;
fig. 3 shows a schematic structural diagram of a distributed system database structure comparison apparatus according to another embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a schematic flow chart of a distributed system database structure comparison method disclosed in an embodiment of the present invention is shown.
S101: and determining data tables with the same table name and data tables with different table names in the first distributed system database and the second distributed system database.
Data in the database is stored in the form of tables, which are roughly divided into two categories. One is a user table for recording user data; the other type is a system table, which is used to describe the user table. The invention compares the structures of the first distributed system database and the second distributed system database based on the system table.
Referring to table 1, the names of a system table and its contents are shown.
Step S101 specifically includes: a first table name list (user _ tables) of a first distributed system database and a second table name list (user _ tables) of a second distributed system database are obtained.
And comparing the first table name list with the second table name list, determining data tables with the same table name and data tables with different table names in the first distributed system database and the second distributed system database, and inputting the data tables with different table names into the database structure comparison result.
S102: and comparing the table field information of the first data table and the second data table for the data tables with the same table name, and outputting a first comparison result based on the difference of the table field information.
And acquiring a first table field information list (user _ tab _ columns) of the first distributed system database and a second table field information list (user _ tab _ columns) of the second distributed system database by taking the data tables with the same table name as a unit (the first data table and the second data table).
And comparing the first table field information list with the second table field information list, and outputting a table field comparison result of the first data table and the second data table.
S103: and comparing the index information of the first data table and the second data table, and outputting a second comparison result based on the difference of the index information.
Acquiring an index information list of a first distributed system database and a second index information list (user _ indexes, user _ ind _ columns, user _ part _ indexes and user _ part _ key _ columns) of a second distributed system database.
And comparing the second index information list with the second index information list, and outputting the index information comparison results of the first data table and the second data table.
S104: and comparing the partition information of the first data table and the second data table, and outputting a third comparison result based on the difference of the index partition information.
A first partition information list of a first distributed system database and a second partition information list (user _ part _ tables, user _ tab _ partitions, and user _ part _ key _ columns) of the first distributed system database are obtained.
And comparing the first partition information list with the second partition information list, and outputting the partition information comparison results of the first data table and the second data table.
The first data table and the second data table are data tables with the same table name;
s105: and outputting a database structure comparison result based on the data tables with different table names, the first comparison result, the second comparison result and the third comparison result.
The embodiment shows that the invention designs a database structure comparison method based on a system table aiming at the problem that the database structure is possibly inconsistent as the database structure of the distributed system is continuously updated along with the application version. The comparison can be completed only by inputting the database instance name, the user name and the password to be compared, and the defect of manual comparison is overcome. The comparison tool covers all commonly used database structure information, and the comparison reports are connected in series by taking the table as a unit, so that the problem positioning of developers is facilitated.
Referring to fig. 2, a schematic structural diagram of a distributed system database structure comparison apparatus disclosed in another embodiment of the present invention is shown.
As can be seen from fig. 2, the apparatus includes: table name comparison means 1, table field information comparison means 2, table index information comparison means 3, partition information comparison means 4, and result output means 5.
The table name comparison unit 1 is configured to compare the first distributed system database with the second distributed system database to determine data tables with the same table name and data tables with different table names in the first distributed system database and the second distributed system database.
Further, for data tables having the same table name, the table field information comparing unit 2 compares table field information of a first data table and a second data table, which are data tables having the same table name, and outputs a first comparison result based on a difference of the table field information.
The table index information comparing unit 3 is configured to compare the index information of the first data table and the second data table, and output a second comparison result based on a difference of the index information.
The partition information comparison unit 4 is configured to compare the partition information of the first data table and the second data table, and output a third comparison result based on the difference of the index partition information.
Further, the result output unit 5 is configured to output a database structure comparison result based on the data table with the different table names, the first comparison result, the second comparison result, and the third comparison result.
Referring to fig. 3, a schematic structural diagram of a distributed system database structure comparison apparatus disclosed in another embodiment of the present invention is shown.
As can be seen from fig. 3, unlike the previous embodiment of the apparatus, in the present embodiment, the apparatus includes: table name comparison means 1, table field information comparison means 2, table index information comparison means 3, partition information comparison means 4, and result output means 5.
The specific table name comparison unit 1 includes:
a table name list obtaining module 11, configured to obtain a first table name list of the first distributed system database and a second table name list of the second distributed system database.
A first comparing module 12, configured to compare the first table name list and the second table name list, and determine data tables with the same table name and data tables with different table names.
The table field information comparing unit 2 includes:
a table field list obtaining module 21, configured to obtain a first table field information list of the first distributed system database and a second table field information list of the second distributed system database.
The table field information includes: table field name, table field type, table field length, and table field significand.
A second comparing module 22, configured to compare the first table field information list and the second table field information list.
The index information comparing unit 3 includes:
an index information list obtaining module 31, configured to obtain a first index information list of the first distributed system database and an index information list of the second distributed system database.
Wherein the index information includes: the index table comprises a total index name, a total index column position, uniqueness, partition index types, partition index numbers, partition index column names, partition index column positions and partition index names.
A third comparing module 32, configured to compare the first index information list and the second index information list.
The partition information comparing unit 4 includes:
a partition information list obtaining module 41, configured to obtain a first partition information list of the first distributed system database and a second partition information list of the second distributed system database.
Wherein the partition information includes: partition type, partition number, partition column information and partition names;
a fourth comparing module 42, configured to compare the first partition information list and the second partition information list.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A distributed system database structure comparison method is characterized by comprising the following steps:
determining data tables with the same table name and different table names in a first distributed system database and a second distributed system database which are respectively positioned in different parallel systems or in a production environment and a test environment; the parallel systems or environments corresponding to the first distributed system database and the second distributed system database are different;
for data tables with the same table name, comparing specific contents of table field information of a first data table in the first distributed system database with specific contents of table field information of a second data table in the second distributed system database, and outputting a first comparison result based on the difference of the specific contents of the table field information, wherein the first data table and the second data table are the data tables with the same table name;
comparing the specific contents of the index information of the first data table and the second data table, and outputting a second comparison result based on the difference of the specific contents of the index information;
comparing the specific contents of the partition information of the first data table and the second data table, and outputting a third comparison result based on the difference of the specific contents of the index partition information;
and outputting a database structure comparison result based on the data tables with different table names, the first comparison result, the second comparison result and the third comparison result.
2. The method of claim 1, wherein determining the data tables with the same table name and the data tables with different table names in the first distributed system database and the second distributed system database of the production environment and the test environment respectively comprises:
acquiring a first table name list of the first distributed system database and a second table name list of the second distributed system database which are respectively located in different parallel systems or in a production environment and a test environment;
and comparing the first table name list with the second table name list, and determining the data tables with the same table names and the data tables with different table names.
3. The method of claim 1, wherein comparing the specific content of the table field information of the first data table in the first distributed system database and the second data table in the second distributed system database comprises:
acquiring a first table field information list of the first distributed system database and a second table field information list of the second distributed system database;
the table field information includes: a table field name, a table field type, a table field length, and a table field significand;
comparing the first table field information list and the second table field information list.
4. The method according to claim 1, wherein the comparing the specific content of the index information of the first data table and the second data table comprises:
acquiring a first index information list of the first distributed system database and a second index information list of the second distributed system database;
wherein the index information includes: the index table comprises a total index name, a total index column position, uniqueness, partition index types, partition index numbers, partition index column names, partition index column positions and partition index names;
comparing the first index information list and the second index information list.
5. The method according to claim 1, wherein the comparing the specific content of the partition information of the first data table and the second data table comprises:
acquiring a first partition information list of the first distributed system database and a second partition information list of the second distributed system database;
wherein the partition information includes: partition type, partition number, partition column information and partition names;
comparing the first partition information list and the second partition information list.
6. A distributed system database structure comparison apparatus, comprising:
the table name comparison unit is used for determining data tables with the same table name and different table names in a first distributed system database and a second distributed system database which are respectively positioned in different parallel systems or in a production environment and a test environment; the parallel systems or environments corresponding to the first distributed system database and the second distributed system database are different;
the table field information comparison unit is used for comparing specific contents of table field information of a first data table in the first distributed system database and a second data table in the second distributed system database for data tables with the same table name, and outputting a first comparison result based on the difference of the specific contents of the table field information, wherein the first data table and the second data table are data tables with the same table name;
a table index information comparison unit configured to compare specific contents of the index information of the first data table and the second data table, and output a second comparison result based on a difference between the specific contents of the index information;
the partition information comparison unit is used for comparing the specific contents of the partition information of the first data table and the second data table and outputting a third comparison result based on the difference of the specific contents of the index partition information;
and the result output unit is used for outputting a database structure comparison result based on the data tables with different table names, the first comparison result, the second comparison result and the third comparison result.
7. The apparatus of claim 6, wherein the table name comparing unit comprises:
the table name list acquisition module is used for acquiring a first table name list of the first distributed system database and a second table name list of the second distributed system database which are respectively positioned in different parallel systems or in a production environment and a test environment;
and the first comparison module is used for comparing the first table name list with the second table name list and determining the data tables with the same table names and the data tables with different table names.
8. The apparatus of claim 6, wherein the table field information comparing unit comprises:
a table field list obtaining module, configured to obtain a first table field information list of the first distributed system database and a second table field information list of the second distributed system database;
the table field information includes: a table field name, a table field type, a table field length, and a table field significand;
a second comparison module for comparing the first table field information list and the second table field information list.
9. The apparatus of claim 6, wherein the index information comparing unit comprises:
an index information list obtaining module, configured to obtain a first index information list of the first distributed system database and a second index information list of the second distributed system database;
wherein the index information includes: the index table comprises a total index name, a total index column position, uniqueness, partition index types, partition index numbers, partition index column names, partition index column positions and partition index names;
and the third comparison module is used for comparing the first index information list with the second index information list.
10. The apparatus of claim 6, wherein the partition information comparing unit comprises:
a partition information list obtaining module, configured to obtain a first partition information list of the first distributed system database and a second partition information list of the second distributed system database;
wherein the partition information includes: partition type, partition number, partition column information and partition names;
and the fourth comparison module is used for comparing the first partition information list with the second partition information list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611239539.8A CN106599300B (en) | 2016-12-28 | 2016-12-28 | Distributed system database structure comparison method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611239539.8A CN106599300B (en) | 2016-12-28 | 2016-12-28 | Distributed system database structure comparison method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106599300A CN106599300A (en) | 2017-04-26 |
| CN106599300B true CN106599300B (en) | 2020-06-30 |
Family
ID=58604831
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611239539.8A Active CN106599300B (en) | 2016-12-28 | 2016-12-28 | Distributed system database structure comparison method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106599300B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107688618B (en) * | 2017-08-08 | 2019-03-12 | 平安科技（深圳）有限公司 | Data comparison method, apparatus, computer equipment and storage medium |
| CN107679104B (en) * | 2017-09-12 | 2020-11-24 | 杭州美创科技有限公司 | Large-flow parallel high-speed data comparison method |
| CN110069571A (en) * | 2019-03-18 | 2019-07-30 | 平安普惠企业管理有限公司 | A kind of automated data control methods and device, electronic equipment |
| CN115757174A (en) * | 2022-11-29 | 2023-03-07 | 广发银行股份有限公司 | Database difference detection method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096671A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Method and equipment for generating business and operation support system (BOSS) database upgrading script |
| WO2015109326A1 (en) * | 2014-01-20 | 2015-07-23 | Prevoty, Inc. | Sol query constraint solving |
| CN105989194A (en) * | 2015-03-20 | 2016-10-05 | 国际商业机器公司 | Method and system of table data comparison |
-
2016
- 2016-12-28 CN CN201611239539.8A patent/CN106599300B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102096671A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Method and equipment for generating business and operation support system (BOSS) database upgrading script |
| WO2015109326A1 (en) * | 2014-01-20 | 2015-07-23 | Prevoty, Inc. | Sol query constraint solving |
| CN105989194A (en) * | 2015-03-20 | 2016-10-05 | 国际商业机器公司 | Method and system of table data comparison |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106599300A (en) | 2017-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106599300B (en) | Distributed system database structure comparison method and device | |
| US10860632B2 (en) | Information query method and device | |
| CN110472068B (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge graph | |
| JP4758150B2 (en) | Processing external metadata | |
| CN101194258B (en) | System and method for data sensitive filtering of patient demographic record queries | |
| US20170308571A1 (en) | Techniques for utilizing a natural language interface to perform data analysis and retrieval | |
| US9514177B2 (en) | Method, apparatus and computer program for detecting deviations in data repositories | |
| EP3674918B1 (en) | Column lineage and metadata propagation | |
| EP2862101B1 (en) | Method and a consistency checker for finding data inconsistencies in a data repository | |
| CN109902090A (en) | Field name acquisition methods and device | |
| WO2020215689A1 (en) | Query method and apparatus for column-oriented files | |
| CN112307124A (en) | Database synchronization verification method, device, equipment and storage medium | |
| CN105138643A (en) | Patent retrieval system and retrieval method thereof | |
| US20150324480A1 (en) | Lock-free parallel dictionary encoding | |
| CN107368569B (en) | Data difference comparison method and device, storage medium and processor | |
| US10353927B2 (en) | Categorizing columns in a data table | |
| CN110737432A (en) | script aided design method and device based on root list | |
| CN107085603B (en) | Data processing method and device | |
| CN106933908B (en) | Shortest path identification method and device | |
| CN105573984B (en) | The recognition methods of socio-economic indicator and device | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| JP2010272006A (en) | Relation extraction apparatus, relation extraction method and program | |
| US10534761B2 (en) | Significant cleanse change information | |
| CN110837365A (en) | Script aided design method and device based on root table | |
| JP6901533B2 (en) | Computer system and business support method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |