CN111382209A - Data unloading and operating method for distributed memory database - Google Patents

Data unloading and operating method for distributed memory database Download PDF

Info

Publication number
CN111382209A
CN111382209A CN202010256466.3A CN202010256466A CN111382209A CN 111382209 A CN111382209 A CN 111382209A CN 202010256466 A CN202010256466 A CN 202010256466A CN 111382209 A CN111382209 A CN 111382209A
Authority
CN
China
Prior art keywords
data
order
distributed
memory database
file system
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
Application number
CN202010256466.3A
Other languages
Chinese (zh)
Other versions
CN111382209B (en
Inventor
许安刚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Si Tech Information Technology Co Ltd
Original Assignee
Beijing Si Tech Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Si Tech Information Technology Co Ltd filed Critical Beijing Si Tech Information Technology Co Ltd
Priority to CN202010256466.3A priority Critical patent/CN111382209B/en
Publication of CN111382209A publication Critical patent/CN111382209A/en
Application granted granted Critical
Publication of CN111382209B publication Critical patent/CN111382209B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/18File system types
    • G06F16/182Distributed file systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/214Database migration support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/40Business processes related to the transportation industry
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE 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/00Energy 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 Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Primary Health Care (AREA)
  • Human Resources & Organizations (AREA)
  • Computing Systems (AREA)
  • General Health & Medical Sciences (AREA)
  • Economics (AREA)
  • Health & Medical Sciences (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data unloading and operating method of a distributed memory database, which comprises the following steps: creating an order in a distributed memory database, writing fields of the order into an order index table, and writing order data to be processed into an instance positive table; migrating the fields of the processed orders from the instance positive table to the instance year-month table, and simultaneously migrating the data of the processed orders to a distributed file system in real time; updating the data storage position identification of the order migrated to the distributed file system to an order index table; and the data migration, butt joint and conversion configuration is agreed between the distributed memory database and the distributed file system through a public configuration table. By the technical scheme, the consumption of distributed memory database resources is reduced, the efficient access to the archived order data is realized, and the order processing efficiency, performance and data life cycle management are improved.

Description

Data unloading and operating method for distributed memory database
Technical Field
The invention relates to the technical field of databases, in particular to a data unloading and operating method of a distributed memory database.
Background
Most of the traditional order data in the telecommunication industry is stored in a relational database (such as oracle) or distributed relational data (such as distributed mysql), and the application scenarios mainly cause the following problems:
the first problem is that: the capacity expansion of data storage resources and a host computer can lead to the continuous increase of storage media of a database, obvious reduction of the performance of the database, increase of data block fragments and increase of the cost of host computer resources along with the time;
the second problem is that: when the order processing performance is limited and the order quantity is very large, the performance of order creation and circulation can not be processed in real time and efficiently because the database becomes a bottleneck;
the third problem is that: order processing capacity and efficiency cannot be improved, a service scene and order transaction amount are limited, and service expansion is influenced.
With the rapid development of mobile internet, internet of things and 5G services, and the explosive growth of service scenes and service volumes, the performance requirements on the order system are higher and higher, so the order system has to have high concurrent continuous processing capability besides ensuring efficient circulation, and needs to store the detail of the order data of the customers for a long time.
Disclosure of Invention
Aiming at least one of the problems, the invention provides a data transferring and operating method of a distributed memory database, which comprises the steps of storing order creating and order transferring data in the distributed memory database, improving the performance of order creating and order processing through the distributed memory database, and transferring the transferred and processed order to a distributed file system in real time so as to reduce the consumption of distributed memory database resources; and meanwhile, an order index table is introduced to serially connect the data of the distributed memory database and the distributed file system, so that efficient access to the archived order data is realized, and the processing efficiency and performance of the order and the data life cycle management are improved.
In order to achieve the above object, the present invention provides a data unloading and operating method for a distributed memory database, which includes: the method comprises the steps that an order is established in a distributed memory database, meanwhile, fields of the order are written into an order index table, and data of the order to be processed are written into an instance positive table; migrating the fields of the processed orders from the instance positive table to an instance year-month table, and migrating the data of the processed orders to a distributed file system in real time; updating the data storage position identification of the order transferred to the distributed file system to the order index table; and the data migration, docking and conversion configuration is agreed between the distributed memory database and the distributed file system through a public configuration table.
In the above technical solution, preferably, the data unloading and operating method of the distributed memory database further includes: when the instance positive table and/or the instance year month table in the distributed memory database are/is operated, updating the fields of the operated instance positive table and/or the operated instance year month table to the order index table.
In the above technical solution, preferably, when the order data in the distributed file system is operated, the order data position in the distributed file system is searched for by the data storage position identifier of the corresponding order in the order index table, and the order data is operated.
In the above technical solution, preferably, the distributed memory database and the distributed file system both use 1 master memory database and 2 slave memory databases.
In the above technical solution, preferably, the order index table is provided with a field for distinguishing that a certain order data is stored in the distributed memory database or the distributed file system.
In the foregoing technical solution, preferably, the order index table is created according to order service data in the distributed memory database in a classified manner, the same type of data table in the order index table is stored in the distributed file system in a cluster, all Value values in the distributed file system are stored in a Json array manner and include corresponding field names, and the distributed memory database and the distributed file system are docked by using the common configuration table.
In the above technical solution, preferably, after the processed order data is migrated to the distributed file system in real time, the corresponding order data in the distributed memory database is deleted.
In the above technical solution, preferably, the example positive table and the example year-month table both use a relational database.
Compared with the prior art, the invention has the beneficial effects that: the data of order creation and order circulation are stored in the distributed memory database, the performance of order creation and order processing is improved through the distributed memory database, and the order which is circulated and processed is transferred to the distributed file system in real time, so that the consumption of distributed memory database resources is reduced; and meanwhile, an order index table is introduced to serially connect the data of the distributed memory database and the distributed file system, so that efficient access to the archived order data is realized, and the processing efficiency and performance of the order and the data life cycle management are improved.
Drawings
Fig. 1 is a schematic diagram of an order submission data flow of a data unloading and operation method of a distributed memory database according to an embodiment of the present invention;
fig. 2 is a schematic diagram of order data operation of a data unloading and operation method of a distributed memory database according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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 some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
The invention is described in further detail below with reference to the attached drawing figures:
as shown in fig. 1 and fig. 2, a data unloading and operating method for a distributed memory database according to the present invention includes: the method comprises the steps that an order is established in a Distributed Memory Database (DMDB), fields of the order are written into an order index table, and data of the order to be processed are written into an instance positive table; migrating the fields of the processed orders from the instance positive table to the instance year-month table, and migrating the data of the processed orders to a distributed file system (Hbase) in real time; updating the data storage position identification of the order migrated to the distributed file system to an order index table; and the data migration, butt joint and conversion configuration is agreed between the distributed memory database and the distributed file system through a public configuration table.
In the embodiment, the distributed memory database mainly stores data of unprocessed finished orders, index table data and basic configuration data of the orders; the order instance data are dispersed by adopting multiple nodes, so that IO of the order hot spot table is reduced, and meanwhile, the creation performance of the order and the concurrent processing capacity of order process circulation are greatly improved as the data are stored and processed in the memory database. The distributed file system mainly stores orders and files the data of the annual and monthly tables, and the life cycle of each annual and monthly table is set to be 3 years according to group specifications, so that the storage pressure (mainly the pressure of memory consumption) of the distributed memory database is reduced, and the hardware cost is also reduced.
Specifically, unprocessed order data and processed order data are respectively stored in the distributed memory database through the instance positive table and the instance annual month table, the data formats of all the instance positive table and the instance annual month table are storage formats of the relational database, the order index table is recorded at the same time, an order core field and a data storage identifier are recorded in the order index table, and the core field also comprises a Key value field of the distributed file system, so that the storage positions of the order data can be rapidly filtered and searched. The processed order data are stored in the distributed file system through an Hbase annual month table, the data are stored in a classification mode through an Hbase column cluster, the data are stored in a K/V mode, and V stores one piece of data of a single table in a json format.
In the above embodiment, preferably, after the processed order data is migrated to the distributed file system in real time, the corresponding order data in the distributed memory database is deleted.
In the above embodiment, preferably, the data unloading and operating method of the distributed in-memory database further includes: when the instance positive table and/or the instance year month table in the distributed memory database are/is operated, the fields of the operated instance positive table and/or the operated instance year month table are updated to the order index table.
Preferably, the order index table is provided with a DB _ FLAG field for distinguishing whether a certain order data is stored in the distributed memory database or the distributed file system. And after the data storage position is confirmed, if the data storage position is in the DMDB, accessing the DMDB operation data, and if the data storage position is in the Hbase, operating the data through an API (application program interface) of the Hbase.
In the above embodiment, preferably, when the order data in the distributed file system is operated, the order data position in the distributed file system is searched for by the data storage position identifier corresponding to the order in the order index table, and the order data is operated.
In the above embodiment, preferably, both the distributed memory database and the distributed file system adopt 1 host and 2 standby memory databases, so as to ensure high availability of the distributed memory file system.
In the above embodiment, preferably, the order index table is created according to order service data in the distributed memory database in a classified manner, the same type of data table in the order index table is stored in the distributed file system according to a column cluster, all Value values in the distributed file system are stored in a Json array manner and include corresponding field names, and the docking between the distributed memory database and the distributed file system is realized through the common configuration table.
In the above embodiment, the common configuration table is set to agree the docking conversion configuration of the DMDB data table and the Hbase data table, including the table names of the two sets of databases, the column cluster of the Hbase, the primary key, the migration identifier, and the like. The table is mainly used for data migration, and condition filtering and rule matching of public data access methods. The details are shown as follows:
Figure BDA0002437515900000051
the docking design of the distributed memory database and the distributed file system is shown in the following table:
Figure BDA0002437515900000061
Figure BDA0002437515900000071
Figure BDA0002437515900000081
Figure BDA0002437515900000091
according to the data unloading and operating method of the distributed memory database provided by the embodiment, the order data model is established according to three dimensions, the DMDB establishes a positive table and a yearly-monthly table, and the Hbase establishes a yearly-monthly table. And the order program writes and migrates data according to three dimensions and synchronously updates the index table. And a common interface method of the yearly calendar is provided, and the efficient and seamless butt joint of the DMDB and the Hbase data is realized.
Through the distributed memory database, the processing capacity of order creation and order circulation is greatly improved, and the hot spot table IO is controlled in a reasonable range. After the data are migrated to the Hbase in real time, the storage pressure of the processed order data is not increased by the distributed memory database, and the requirement on host resources is reduced. The order index table can efficiently and seamlessly operate the data of the distributed memory database and the distributed file system, the integrity and the efficiency of subsequent services are guaranteed, the capacity expansion requirement of the hardware resources of the host caused by service growth is reasonably controlled, and the resource cost of the host is reduced.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (8)

1. A data unloading and operating method of a distributed memory database is characterized by comprising the following steps:
the method comprises the steps that an order is established in a distributed memory database, meanwhile, fields of the order are written into an order index table, and data of the order to be processed are written into an instance positive table;
migrating the fields of the processed orders from the instance positive table to an instance year-month table, and migrating the data of the processed orders to a distributed file system in real time;
updating the data storage position identification of the order transferred to the distributed file system to the order index table;
and the data migration, docking and conversion configuration is agreed between the distributed memory database and the distributed file system through a public configuration table.
2. The method for data unloading and operation of a distributed in-memory database according to claim 1, further comprising:
when the instance positive table and/or the instance year month table in the distributed memory database are/is operated, updating the fields of the operated instance positive table and/or the operated instance year month table to the order index table.
3. The data unloading and operating method of the distributed memory database according to claim 2, wherein when the order data in the distributed file system is operated, the order data position in the distributed file system is searched for by the data storage position identifier of the corresponding order in the order index table, and the order data is operated.
4. The method for unloading and operating data of the distributed memory database according to claim 1, wherein the distributed memory database and the distributed file system both use memory databases of 1 host and 2 backup.
5. The method according to claim 1, wherein the order index table has fields for distinguishing whether an order data is stored in the distributed in-memory database or the distributed file system.
6. The data unloading and operating method of the distributed memory database according to claim 1, wherein the order index table is created according to order business data in the distributed memory database in a classified manner, the same type of data table in the order index table is stored in the distributed file system in a cluster, all Value values in the distributed file system are stored in a Json array manner and include corresponding field names, and the butt joint of the distributed memory database and the distributed file system is realized through the common configuration table.
7. The method for data unloading and operation of the distributed in-memory database according to claim 1, wherein after the processed order data is migrated to the distributed file system in real time, the corresponding order data in the distributed in-memory database is deleted.
8. The method for unloading and operating data of the distributed in-memory database as claimed in claim 1, wherein the instance positive table and the instance year-month table both use relational databases.
CN202010256466.3A 2020-04-02 2020-04-02 Data transfer and operation method of distributed memory database Active CN111382209B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010256466.3A CN111382209B (en) 2020-04-02 2020-04-02 Data transfer and operation method of distributed memory database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010256466.3A CN111382209B (en) 2020-04-02 2020-04-02 Data transfer and operation method of distributed memory database

Publications (2)

Publication Number Publication Date
CN111382209A true CN111382209A (en) 2020-07-07
CN111382209B CN111382209B (en) 2023-07-25

Family

ID=71218943

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010256466.3A Active CN111382209B (en) 2020-04-02 2020-04-02 Data transfer and operation method of distributed memory database

Country Status (1)

Country Link
CN (1) CN111382209B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114119326A (en) * 2021-10-27 2022-03-01 北京思特奇信息技术股份有限公司 Method for quickly tracking order track and extracting data

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110252000A1 (en) * 2010-04-08 2011-10-13 Microsoft Corporation In-memory database system
WO2013049241A1 (en) * 2011-09-30 2013-04-04 Oracle International Corporation High throughput global order promising system
CN103631907A (en) * 2013-11-26 2014-03-12 中国科学院信息工程研究所 Method and system for migrating relational data to HBbase
US20150262127A1 (en) * 2014-03-17 2015-09-17 Carsten Ziegler Generation and optimzation of in-memory database business rule logic
CN106709784A (en) * 2016-12-28 2017-05-24 广州虎鱼网络科技有限公司 Cross-border e-commerce platform having high concurrency extensible distributed type architecture
CN107123031A (en) * 2017-05-02 2017-09-01 深圳乐信软件技术有限公司 A kind of order processing method and device
CN109949129A (en) * 2019-03-12 2019-06-28 北京思特奇信息技术股份有限公司 A kind of order processing system and method for high concurrent
CN110275900A (en) * 2019-06-25 2019-09-24 浪潮软件股份有限公司 A method of order and early warning are monitored based on Redis caching technology
US20190311054A1 (en) * 2018-04-10 2019-10-10 Walmart Apollo, Llc High throughput order fullfillment database system
US20190332387A1 (en) * 2018-04-27 2019-10-31 Sap Se Method for Performing Compressed Column Operations

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110252000A1 (en) * 2010-04-08 2011-10-13 Microsoft Corporation In-memory database system
WO2013049241A1 (en) * 2011-09-30 2013-04-04 Oracle International Corporation High throughput global order promising system
CN103631907A (en) * 2013-11-26 2014-03-12 中国科学院信息工程研究所 Method and system for migrating relational data to HBbase
US20150262127A1 (en) * 2014-03-17 2015-09-17 Carsten Ziegler Generation and optimzation of in-memory database business rule logic
CN106709784A (en) * 2016-12-28 2017-05-24 广州虎鱼网络科技有限公司 Cross-border e-commerce platform having high concurrency extensible distributed type architecture
CN107123031A (en) * 2017-05-02 2017-09-01 深圳乐信软件技术有限公司 A kind of order processing method and device
US20190311054A1 (en) * 2018-04-10 2019-10-10 Walmart Apollo, Llc High throughput order fullfillment database system
US20190332387A1 (en) * 2018-04-27 2019-10-31 Sap Se Method for Performing Compressed Column Operations
CN109949129A (en) * 2019-03-12 2019-06-28 北京思特奇信息技术股份有限公司 A kind of order processing system and method for high concurrent
CN110275900A (en) * 2019-06-25 2019-09-24 浪潮软件股份有限公司 A method of order and early warning are monitored based on Redis caching technology

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
WENMING GUO; ZHIQIANG HU: "Memory Database Index Optimization", 《2010 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND SOFTWARE ENGINEERING》 *
徐建生: "基于综合交易平台的程序化交易系统的设计与实现", 《CNKI》 *
郝晓培;单杏花;梅巧玲: "基于用户行为的订单实时缓存技术的研究", 第十一届中国智能交通年会 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114119326A (en) * 2021-10-27 2022-03-01 北京思特奇信息技术股份有限公司 Method for quickly tracking order track and extracting data

Also Published As

Publication number Publication date
CN111382209B (en) 2023-07-25

Similar Documents

Publication Publication Date Title
WO2021238701A1 (en) Data migration method and device
US9996557B2 (en) Database storage system based on optical disk and method using the system
US7698319B2 (en) Database system management method, database system, database device, and backup program
US10628200B2 (en) Base state for thin-provisioned volumes
CN101916290B (en) Managing method of internal memory database and device
CN104462185A (en) Digital library cloud storage system based on mixed structure
CN103500089A (en) Small file storage system suitable for Mapreduce calculation model
CN110096509A (en) Realize that historical data draws the system and method for storage of linked list modeling processing under big data environment
CN100504800C (en) Method for snapshot of magnetic disc
CN104899117A (en) Memory database parallel logging method for nonvolatile memory
CN116521956A (en) Graph database query method and device, electronic equipment and storage medium
CN103473258A (en) Cloud storage file system
WO2022156369A1 (en) Storage block management information synchronous recording method and system, and terminal and storage medium
CN109542860B (en) Service data management method based on HDFS and terminal equipment
CN103365987A (en) Clustered database system and data processing method based on shared-disk framework
CN111382209B (en) Data transfer and operation method of distributed memory database
CN114860727A (en) Zipper watch updating method and device
US11789622B2 (en) Method, device and computer program product for storage management
CN114328018A (en) Snapshot creating method, computing device and storage medium
CN103226592A (en) Database-based file system and file storage method
CN115470235A (en) Data processing method, device and equipment
CN113297231A (en) Database processing method and device
EP3082050A1 (en) Mass data fusion storage method and system
CN108984422A (en) A method of memory is saved based on NTFS and FAT32 file system cluster management
CN114415977A (en) Method for accessing storage pool and distributed storage system

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