CN111737355A - MongoDB metadata management-based heterogeneous data source synchronization method and system - Google Patents
MongoDB metadata management-based heterogeneous data source synchronization method and system Download PDFInfo
- Publication number
- CN111737355A CN111737355A CN202010616235.9A CN202010616235A CN111737355A CN 111737355 A CN111737355 A CN 111737355A CN 202010616235 A CN202010616235 A CN 202010616235A CN 111737355 A CN111737355 A CN 111737355A
- Authority
- CN
- China
- Prior art keywords
- data
- metadata
- mongodb
- information
- kudu
- 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
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- 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/219—Managing data history or versioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/546—Message passing systems or structures, e.g. queues
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/54—Indexing scheme relating to G06F9/54
- G06F2209/548—Queue
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for synchronizing heterogeneous data sources based on MongoDB metadata management, which comprises the following steps: s1, scanning a MySQL source data end to-be-synchronized table structure, and initializing metadata information of a source end data table; s2, constructing a universal database metadata model in the MongoDB database based on the scanning result; s3, monitoring a binlog operation log of the MySQL database, analyzing the operation log, distinguishing data operation behaviors, and performing subsequent processing; s4, acquiring data change information to be consumed in the distributed message queue; s5, according to the data change information, obtaining the latest version information of the metadata related to MongoDB: and S6, converting DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data, and updating the Kudu data. The invention realizes the real-time data synchronization between the relational database MySQL and the distributed columnar database Kudu, supports the data operation change of DML and DDL, and can maintain the metadata structure information of different historical versions.
Description
Technical Field
The invention relates to the technical field of information, in particular to a method and a system for heterogeneous data source synchronization based on MongoDB metadata management.
Background
Currently, each production database of financial business systems is MySQL, and in order to deal with large-scale data analysis and query work, business data needs to be synchronized to a column type storage database Kudu which has stronger query performance and supports horizontal expansion, high availability and distribution. However, the current mature data synchronization schemes are based on data synchronization between traditional relational databases, such as the Canal framework of MySQL database and the OGG component of Oracle database. Data synchronization between two heterogeneous databases, namely a traditional relational database and a Hadoop platform distributed database, only supports incremental data synchronization, can be performed when metadata of a source end and metadata of a target end are completely consistent, does not support synchronization of DDL data operation change, does not support synchronization of updating and deleting DML data operation, has high synchronization limiting conditions, and cannot cover all data change operations of a service system database.
Based on the above reasons, it is necessary to design a method capable of implementing real-time data synchronization between MySQL and Kudu.
Disclosure of Invention
Aiming at the defects in the prior art, the invention aims to provide a method and a system for synchronizing heterogeneous data sources based on MongoDB metadata management, which can realize real-time data synchronization between a relational database MySQL and a distributed columnar database Kudu and manage and maintain metadata structure information of different historical versions.
In order to achieve the purpose, the invention provides the following technical scheme:
the method for synchronizing the heterogeneous data sources based on MongoDB metadata management is characterized by comprising the following steps of:
s1, starting a metadata change monitoring service, and initializing metadata information of a source end data table by scanning a MySQL source data end to-be-synchronized table structure;
s2, based on the scanning result of the step S1, the service of 'metadata change monitoring' constructs a universal database metadata model in the MongoDB database;
s3, monitoring a binlog operation log of the MySQL database through a 'change data capture' service, analyzing the operation log, distinguishing data operation behaviors into data change operations and data structure change operations, and carrying out corresponding processing according to different data operation behaviors;
s4, acquiring data change information to be consumed in the distributed message queue through the data processing unit;
s5, according to the data change information acquired at step S4, the "data processing unit" acquires the metadata latest version information thereof related to the MongoDB:
s6, the data processing unit converts DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data, and executes Kudu data updating.
As a preferable scheme: in step S3, for a data change operation, writing the changed data into the distributed message queue in a montodb storage metadata structure; and for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
As a preferable scheme: if the metadata information does not exist in the step of S5, a Kudu metadata structure is created according to the latest MongoDB version; if the metadata information exists in Kudu, the data processing unit compares the metadata version information between MongoDB and Kudu, and if the Kudu metadata version is smaller than the latest version reserved by MongoDB, the data processing unit updates Kudu metadata structure information so as to keep the Kudu metadata structure information consistent with the latest version of the MongoDB.
A system for heterogeneous data source synchronization based on MongoDB metadata management is characterized by comprising:
a MySQL database;
a Kudu database;
a MongoDB database;
the metadata change monitoring module is used for initializing the metadata information of the source end data table by scanning the structure of the table to be synchronized of the MySQL source data end and constructing a universal database metadata model in the MongoDB database based on the scanning result;
the variable data capturing module is used for monitoring a binlog operation log of the MySQL database, analyzing the operation log, distinguishing a data operation behavior into a data change operation (DML) and a data structure change operation (DDL), and performing corresponding processing according to different data operation behaviors;
the distributed message queue is used for writing data change information;
and the data processing module is used for acquiring the data change information to be consumed in the distributed message queue and acquiring the latest version information of the metadata related to the MongoDB according to the acquired data change information.
As a preferable scheme: aiming at data change operation, a changed data capturing module writes changed data into a distributed message queue according to MongoDB storage metadata structure serialization; and for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
As a preferable scheme: when the data processing module acquires the latest version information of the MongoDB metadata, if the metadata information does not exist, a Kudu metadata structure is created according to the latest version of the MongoDB, if the metadata information exists in Kudu, the data processing unit compares the metadata version information between the MongoDB and the Kudu, and if the Kudu metadata version is smaller than the latest version reserved by the MongoDB, the data processing unit updates the Kudu metadata structure information to keep consistent with the latest version of the metadata in the MongoDB; and the data processing module is also used for converting DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data and executing Kudu data updating.
Compared with the prior art, the invention has the advantages that: the method provided by the invention mainly solves the problem of real-time data synchronization between the relational database MySQL and the distributed columnar database Kudu, supports data operation change of DML and DDL, and can manage and maintain metadata structure information of different historical versions.
Drawings
FIG. 1 is a block flow diagram of a method according to a first embodiment;
fig. 2 is a schematic diagram of a system according to a second embodiment.
Detailed Description
The first embodiment is as follows:
referring to fig. 1, a method for heterogeneous data source synchronization based on MongoDB metadata management includes the following steps:
and S1, starting the metadata change monitoring service, and initializing the metadata information of the source end data table by scanning the MySQL source data end to-be-synchronized table structure.
S2, based on the scanning result of step S1, the "Metadata change monitoring" service constructs a universal database Metadata model (Metadata) in the MongoDB database.
And S3, monitoring the binlog operation log of the MySQL database through the change data capture service. After the operation log is analyzed, the data operation behavior is divided into a data change operation (DML) and a data structure change operation (DDL).
a. And aiming at data change operation, writing the changed data into a distributed message queue according to MongoDB storage metadata structure serialization.
b. And for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
And S4, acquiring the data change information to be consumed in the distributed message queue through the data processing unit.
S5, according to the data change information acquired at step S4, the "data processing unit" acquires the metadata latest version information thereof related to the MongoDB:
if the metadata information does not exist, a Kudu metadata structure is created according to the MongoDB latest version;
and II, if the metadata information exists in Kudu, the data processing unit compares the metadata version information between MongoDB and Kudu. If the Kudu metadata version is less than the latest version maintained by MongoDB, the data processing unit will update the Kudu metadata structure information to keep consistent with the latest version of metadata in MongoDB.
S6, the data processing unit converts DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data, and executes Kudu data updating.
Example two:
referring to fig. 2, a system for heterogeneous data source synchronization based on MongoDB metadata management includes:
a MySQL database;
a Kudu database;
a MongoDB database;
and the metadata change monitoring module is used for initializing the metadata information of the source end data table by scanning the structure of the table to be synchronized at the MySQL source data end and constructing a universal database metadata model in the MongoDB database based on the scanning result.
The change data capturing module is used for monitoring a binlog operation log of the MySQL database, and distinguishing a data operation behavior into a data change operation (DML) and a data structure change operation (DDL) after analyzing the operation log; aiming at data change operation, writing changed data into a distributed message queue according to MongoDB storage metadata structure serialization; and for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
The distributed message queue is used for writing data change information;
the data processing module is used for acquiring data change information to be consumed in the distributed message queue and acquiring metadata latest version information related to the MongoDB according to the acquired data change information, if the metadata information does not exist, a Kudu metadata structure is created according to the MongoDB latest version, if the Kudu metadata information exists, the data processing unit compares the metadata version information between the MongoDB and the Kudu, and if the Kudu metadata version is smaller than the latest version reserved by the MongoDB, the data processing unit updates the Kudu metadata structure information to keep consistent with the metadata latest version in the MongoDB; and the data processing module is also used for converting DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data and executing Kudu data updating.
The above description is only a preferred embodiment of the present invention, and the protection scope of the present invention is not limited to the above embodiments, and all technical solutions belonging to the idea of the present invention belong to the protection scope of the present invention. It should be noted that modifications and embellishments within the scope of the invention may occur to those skilled in the art without departing from the principle of the invention, and are considered to be within the scope of the invention.
Claims (6)
1. The method for synchronizing the heterogeneous data sources based on MongoDB metadata management is characterized by comprising the following steps of:
s1, starting a metadata change monitoring service, and initializing metadata information of a source end data table by scanning a MySQL source data end to-be-synchronized table structure;
s2, based on the scanning result of the step S1, the service of 'metadata change monitoring' constructs a universal database metadata model in the MongoDB database;
s3, monitoring a binlog operation log of the MySQL database through a 'change data capture' service, analyzing the operation log, distinguishing data operation behaviors into data change operations and data structure change operations, and carrying out corresponding processing according to different data operation behaviors;
s4, acquiring data change information to be consumed in the distributed message queue through the data processing unit;
s5, according to the data change information acquired at step S4, the "data processing unit" acquires the metadata latest version information thereof related to the MongoDB:
s6, the data processing unit converts DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data, and executes Kudu data updating.
2. The method of MongoDB metadata management based heterogeneous data source synchronization as claimed in claim 1, wherein: in step S3, for a data change operation, writing the changed data into the distributed message queue in a montodb storage metadata structure; and for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
3. The method of MongoDB metadata management based heterogeneous data source synchronization as claimed in claim 1, wherein: if the metadata information does not exist in the step of S5, a Kudu metadata structure is created according to the latest MongoDB version; if the metadata information exists in Kudu, the data processing unit compares the metadata version information between MongoDB and Kudu, and if the Kudu metadata version is smaller than the latest version reserved by MongoDB, the data processing unit updates Kudu metadata structure information so as to keep the Kudu metadata structure information consistent with the latest version of the MongoDB.
4. A system for heterogeneous data source synchronization based on MongoDB metadata management is characterized by comprising:
a MySQL database;
a Kudu database;
a MongoDB database;
the metadata change monitoring module is used for initializing the metadata information of the source end data table by scanning the structure of the table to be synchronized of the MySQL source data end and constructing a universal database metadata model in the MongoDB database based on the scanning result;
the variable data capturing module is used for monitoring a binlog operation log of the MySQL database, analyzing the operation log, distinguishing a data operation behavior into a data change operation (DML) and a data structure change operation (DDL), and performing corresponding processing according to different data operation behaviors;
the distributed message queue is used for writing data change information;
and the data processing module is used for acquiring the data change information to be consumed in the distributed message queue and acquiring the latest version information of the metadata related to the MongoDB according to the acquired data change information.
5. The system for heterogeneous data source synchronization based on MongoDB metadata management as claimed in claim 4, wherein: aiming at data change operation, a changed data capturing module writes changed data into a distributed message queue according to MongoDB storage metadata structure serialization; and for the metadata change operation, only the general metadata change operation is reserved, and the metadata change operation information is updated to the latest version of the MongoDB metadata model.
6. The system for heterogeneous data source synchronization based on MongoDB metadata management as claimed in claim 4, wherein: when the data processing module acquires the latest version information of the MongoDB metadata, if the metadata information does not exist, a Kudu metadata structure is created according to the latest version of the MongoDB, if the metadata information exists in Kudu, the data processing unit compares the metadata version information between the MongoDB and the Kudu, and if the Kudu metadata version is smaller than the latest version reserved by the MongoDB, the data processing unit updates the Kudu metadata structure information to keep consistent with the latest version of the metadata in the MongoDB; and the data processing module is also used for converting DML change data constructing Kudu in real time according to the MongoDB metadata information and the message queue data and executing Kudu data updating.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010616235.9A CN111737355B (en) | 2020-06-29 | 2020-06-29 | Heterogeneous data source synchronization method and system based on MongoDB metadata management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010616235.9A CN111737355B (en) | 2020-06-29 | 2020-06-29 | Heterogeneous data source synchronization method and system based on MongoDB metadata management |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111737355A true CN111737355A (en) | 2020-10-02 |
| CN111737355B CN111737355B (en) | 2023-06-23 |
Family
ID=72653889
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010616235.9A Active CN111737355B (en) | 2020-06-29 | 2020-06-29 | Heterogeneous data source synchronization method and system based on MongoDB metadata management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111737355B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112559475A (en) * | 2020-12-11 | 2021-03-26 | 上海哔哩哔哩科技有限公司 | Data real-time capturing and transmitting method and system |
| CN113051347A (en) * | 2021-03-25 | 2021-06-29 | 未鲲(上海)科技服务有限公司 | Method, system, equipment and storage medium for data synchronization between heterogeneous databases |
| CN113342578A (en) * | 2021-06-28 | 2021-09-03 | 上海万向区块链股份公司 | Method and system for realizing MySQL data free recovery |
| CN113961538A (en) * | 2021-09-23 | 2022-01-21 | 畅移(上海)信息科技有限公司 | Method and system for supporting automatic data synchronization of multi-source heterogeneous database |
| CN114048193A (en) * | 2022-01-12 | 2022-02-15 | 树根互联股份有限公司 | Data management and control method, device and computer readable storage medium |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701181A (en) * | 2016-01-06 | 2016-06-22 | 中电科华云信息技术有限公司 | Dynamic heterogeneous metadata acquisition method and system |
| US20160306867A1 (en) * | 2015-04-16 | 2016-10-20 | Alibaba Group Holding Limited | System, method, and apparatus for synchronization among heterogeneous data sources |
| CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
| US10459647B1 (en) * | 2017-03-02 | 2019-10-29 | Amazon Technologies, Inc. | Multiple storage class representation in versioned storage |
-
2020
- 2020-06-29 CN CN202010616235.9A patent/CN111737355B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160306867A1 (en) * | 2015-04-16 | 2016-10-20 | Alibaba Group Holding Limited | System, method, and apparatus for synchronization among heterogeneous data sources |
| CN105701181A (en) * | 2016-01-06 | 2016-06-22 | 中电科华云信息技术有限公司 | Dynamic heterogeneous metadata acquisition method and system |
| CN107783975A (en) * | 2016-08-24 | 2018-03-09 | 北京京东尚科信息技术有限公司 | The method and apparatus of distributed data base synchronization process |
| US10459647B1 (en) * | 2017-03-02 | 2019-10-29 | Amazon Technologies, Inc. | Multiple storage class representation in versioned storage |
Non-Patent Citations (1)
| Title |
|---|
| 王玉标;饶锡如;何盼;: "异构环境下数据库增量同步更新机制", 计算机工程与设计, no. 03 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112559475A (en) * | 2020-12-11 | 2021-03-26 | 上海哔哩哔哩科技有限公司 | Data real-time capturing and transmitting method and system |
| CN113051347A (en) * | 2021-03-25 | 2021-06-29 | 未鲲(上海)科技服务有限公司 | Method, system, equipment and storage medium for data synchronization between heterogeneous databases |
| CN113051347B (en) * | 2021-03-25 | 2024-03-29 | 未鲲(上海)科技服务有限公司 | Method, system, equipment and storage medium for synchronizing data between heterogeneous databases |
| CN113342578A (en) * | 2021-06-28 | 2021-09-03 | 上海万向区块链股份公司 | Method and system for realizing MySQL data free recovery |
| CN113961538A (en) * | 2021-09-23 | 2022-01-21 | 畅移(上海)信息科技有限公司 | Method and system for supporting automatic data synchronization of multi-source heterogeneous database |
| CN114048193A (en) * | 2022-01-12 | 2022-02-15 | 树根互联股份有限公司 | Data management and control method, device and computer readable storage medium |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111737355B (en) | 2023-06-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111737355B (en) | Heterogeneous data source synchronization method and system based on MongoDB metadata management | |
| EP3602341B1 (en) | Data replication system | |
| CN107273506B (en) | Method for multi-table combined query of database | |
| CN102129478B (en) | Database synchronization method and system thereof | |
| CN112445863B (en) | Data real-time synchronization method and system | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CN105183860B (en) | Method of data synchronization and system | |
| CN109558452B (en) | Synchronization method for query table building operation | |
| CN110222237A (en) | The conversion method and its system of database table and XML message | |
| CN102291416A (en) | Two-way synchronizing method and system of client-side and server-side | |
| CN104699723A (en) | Data exchange adapter and system and method for synchronizing data among heterogeneous systems | |
| CN111563130A (en) | Data credible data management method and system based on block chain technology | |
| CN106156047A (en) | A kind of SNAPSHOT INFO processing method and processing device | |
| EP3872703A2 (en) | Method and device for classifying face image, electronic device and storage medium | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| CN110704442A (en) | Real-time acquisition method and device for big data | |
| CN107291938A (en) | Order Query System and method | |
| CN107577809A (en) | Offline small documents processing method and processing device | |
| CN111259082A (en) | Method for realizing full data synchronization in big data environment | |
| CN109739883A (en) | Promote the method, apparatus and electronic equipment of data query performance | |
| CN110515955B (en) | Data storage and query method and system, electronic equipment and storage medium | |
| CN113032368A (en) | Data migration method and device, storage medium and platform | |
| CN105843724A (en) | Monitoring state index compression analysis method of IT (Information Technology) system | |
| CN110765173A (en) | Data management method and system under big data environment | |
| CN104424309A (en) | Unstructured data processing method based on technological media cloud computing |
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 |