CN116756175A - Mongodb data updating method based on sql language - Google Patents

Mongodb data updating method based on sql language Download PDF

Info

Publication number
CN116756175A
CN116756175A CN202310824497.8A CN202310824497A CN116756175A CN 116756175 A CN116756175 A CN 116756175A CN 202310824497 A CN202310824497 A CN 202310824497A CN 116756175 A CN116756175 A CN 116756175A
Authority
CN
China
Prior art keywords
statement
sql
name
meta
field
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310824497.8A
Other languages
Chinese (zh)
Inventor
刘婷峰
姚志勇
李越峰
张萌
付学勇
高秀秀
王占名
张明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Aipex Technology Co ltd
Original Assignee
Shanghai Aipex 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 Shanghai Aipex Technology Co ltd filed Critical Shanghai Aipex Technology Co ltd
Priority to CN202310824497.8A priority Critical patent/CN116756175A/en
Publication of CN116756175A publication Critical patent/CN116756175A/en
Pending legal-status Critical Current

Links

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/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • 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/23Updating
    • G06F16/235Update request formulation
    • 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/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • G06F16/2445Data retrieval commands; View definitions
    • 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/24Querying
    • G06F16/245Query processing
    • G06F16/2452Query translation
    • G06F16/24526Internal representations for queries
    • 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/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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to the technical field of databases, and provides a mongasdb data updating method based on sql language, which comprises the following steps: obtaining a meta table, a meta field table and a main data table, wherein the meta table comprises a plurality of meta table records, and any meta table record comprises a table name and at least one table name attribute; the meta field table comprises a plurality of meta field records, and any meta field record comprises a field name and at least one field name attribute; the master data table comprises a plurality of master data records, and any master data record comprises a master data value and at least one master data value attribute; when the execution of the sql statement is identified, the parsing syntax tree extracts the sql operation word, the table name, the field name and the main data value in the sql statement; replacing the sql statement with a corresponding mong odb statement according to the sql operation word, the table name, the field name and the main data value; and executing the mongasdb statement. Through the technical scheme, the problem that the Mongodb database in the related technology is inconvenient to operate is solved.

Description

Mongodb data updating method based on sql language
Technical Field
The invention relates to the technical field of databases, in particular to a mongasdb data updating method based on mysql language.
Background
The Mysql database is one of the most popular relational database management systems and is also one of the best-used relational database management system application software, but Mysql cannot handle the problem of large-scale data update and cannot be deployed in a large-scale distributed disaster recovery. The Mongodb database is a database based on distributed file storage and is intended to provide an extensible high-performance data storage solution for WEB applications. The Mysql database is used as mainstream application software, the sql language is widely learned and applied, but cannot be directly applied to the mondab database, and the special operation of the mondab database needs to be mastered, so that the requirement on researchers is high.
Disclosure of Invention
The invention provides a monodb data updating method based on sql language, which solves the problem of inconvenient operation of a monodb database in the related technology.
The technical scheme of the invention is as follows: comprising the following steps:
obtaining a meta table, a meta field table and a main data table, wherein the meta table comprises a plurality of meta table records, and any meta table record comprises a table name and at least one table name attribute; the meta field table comprises a plurality of meta field records, and any meta field record comprises a field name and at least one field name attribute; the master data table comprises a plurality of master data records, and any master data record comprises a master data value and at least one master data value attribute;
when the execution of the sql statement is identified, analyzing a grammar tree to extract an operation word, a table name, a field name and a main data value in the sql statement;
replacing the sql statement with a corresponding mong odb statement according to the sql operation word;
and executing the mongasdb statement.
Further, any meta-table record further comprises a first number corresponding to a table name, any meta-field record further comprises a second number corresponding to a field name, and any main data record further comprises a third number corresponding to a main data value;
after replacing the sql statement with the corresponding mongab statement, further comprising: and replacing the table name with a corresponding first number, replacing the field name with a corresponding second number, and replacing the main data value with a third number.
Further, the sql statement is a select statement, the sql operand in the select statement is a select, and the corresponding mongdb statement is: db. Getcollection ("first number"). Find ({ "data. Second number": "third number" }).
Further, the sql statement is a delete statement, the sql operation word in the delete statement is delete, and the corresponding mongdb statement is: db. Getcollection ("first number"). Remove ({ "data. Second number": "third number" }).
Further, the sql statement is an insert statement, an sql operation word in the insert statement is an insert, a table name, a first field name, a second field name, a first main data value and a second main data value in the sql statement are obtained by parsing a syntax tree, and then the corresponding mongdb statement is: db. getcollection ("first number"). Insert ({ "data. Second number corresponding to first field name": "third number corresponding to first main data value", "data. Second number corresponding to second field name": "third number corresponding to second main data value" }).
Further, the sql statement is an update statement, an sql operation word in the update statement is an update, a table name, a first field name, a second field name, a first main data value and a second main data value in the sql statement are obtained by parsing a grammar tree, and the corresponding mongdb statement is: db. getcollection ("first number"). Updatman ({ data. Second number corresponding to first field name: "third number corresponding to first main data value" }, { $set: { "data. Second number corresponding to second field name": "third number corresponding to second main data value" }).
Further, the meta table, the meta field table and the main data table are input in advance through a graphical interface and stored in the mongolidb.
Further, upon recognition of the execution of the sql statement, user permission verification is performed.
The working principle and the beneficial effects of the invention are as follows:
according to the invention, the meta table, the meta field table and the main data table are stored in the MongoDB database as intermediate bridges, the conversion from the sql language to the Mongodb language is completed according to the operation words, the table names are established through the meta table, the meta field table and the main data table, the constraint relation between the field names and the main data values is used for the operation of the subsequent Mongodb database, so that the operation of the sql statement on the Mongodb database is realized, and convenience is brought to development work.
Drawings
The invention will be described in further detail with reference to the drawings and the detailed description.
Fig. 1 is a flowchart of the mongolib data updating method based on sql language.
Detailed Description
The technical solutions of the embodiments of the present invention will be clearly and completely described below in conjunction with the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Example 1
The embodiment provides a mongasdb data updating method based on sql language, which comprises the following steps:
s100: obtaining a meta table, a meta field table and a main data table, wherein the meta table comprises a plurality of meta table records, and any meta table record comprises a table name and at least one table name attribute; the meta field table comprises a plurality of meta field records, and any meta field record comprises a field name and at least one field name attribute; the master data table comprises a plurality of master data records, and any master data record comprises a master data value and at least one master data value attribute;
the table name attribute in this embodiment includes: numbering, english name, chinese name, object similarity, object attribute, sorting number, api name, whether full text search, sorting type, creation time, deletion state, enterprise ID, creator ID, department ID, modification time, modification department ID, modification user ID, whether hidden, editable, and sharing.
The field name attribute includes: object ID, name, display tag, type, whether read-only, real-time updatable, editable, minimum length, maximum length, minimum value, maximum value, precision, difficult conditions, whether empty, searchable, data references, field type, sort rank, whether necessary, association field ID, default sort field, format, association company ID, association department ID, api name, index, address type, address display hierarchy, association operation type, sort name, delete status, enterprise ID.
The main data value attribute includes: ID, code, name, hierarchy, parent node.
S200: when the execution of the sql statement is identified, analyzing a grammar tree to extract an operation word, a table name, a field name and a main data value in the sql statement;
in this embodiment, take the select statement in the sql statement as an example: select from Person where sex = 'mate', extract Person table name, sex is field name, and mate is main data value;
s300: replacing the sql statement with a corresponding mong odb statement according to the sql operation word, the table name, the field name and the main data value;
the replacement logic in this embodiment is implemented by code, which when recognizing that the sql statement is a select statement, replaces the statement with: db. Getcollection ("table name"). Find ({ "data. Field name": "main data value" }); when the sql statement is identified as a delete statement, the statement is replaced with: db. Getcollection ("table name"). Remove ({ "data. Field name": "main data value" }); when the sql statement is identified as an insert statement, extracting a table name, a first field, a second field, a first main data value and a second main data value in the sql statement through analyzing a grammar tree, and replacing the statement with the following one: db. Getcollection ("table name"). Insert ({ "data. First field name": "first main data value", "data. Second field name": "second main data value" }); when the sql statement is identified as an update statement, extracting a table name, a first field, a second field, a first main data value and a second main data value in the sql statement through analyzing a grammar tree, and replacing the statement with the following one: db. getcollection ("table name"). Updatman ({ data. First field name: "main data value" }, { $set: { "data. Second field name": "second main data value" }).
S400: and executing the mongasdb statement.
According to the invention, the meta table, the meta field table and the main data table are stored in the MongoDB database as intermediate bridges, the sql statement is replaced by the mongadb statement according to the operation words of the sql statement, the constraint relation among the table names, the field names and the main data values is established through the meta table, the meta field table and the main data table, and the constraint relation is used for the operation of the subsequent mongadb database, so that the operation of the sql statement on the mongadb database is realized, and convenience is brought to development work.
Further, any meta-table record further includes a first number corresponding to a table name, any meta-field record further includes a second number corresponding to a field name, and any primary data record further includes a third number corresponding to a primary data value.
The embodiment establishes the relation between the table name and the first number, the field name and the second number, and the main data value and the third number, and uses the first number, the second number and the third number in the mongdb, so that when the table name, the field name and the main data value change, the number is unchanged, and therefore, the user can not influence the operation of the mongdb database by modifying the table name, the field name and the main data value; for example, the table name in the meta table is Person, the first number is 1001, the field name in the meta field table is sex, the second number is 10011, the main data value in the meta data table is males, and the corresponding third number is 9001; if the user wants to modify Person to Person01, which is also numbered 1001, mondab recognizes Person01 from reference numeral 1001.
After replacing the sql operation word with the corresponding mong odb statement, the method further comprises: and searching a meta-table, replacing the table name with a corresponding first number, replacing the field name with a corresponding second number, and replacing the main data value with a third number.
For example: (1) for select statement in sql statement: select from Person where sex = 'rule' extracting the sql operation word from the parse syntax tree as select, the table name as Person, the field name as sex, and the main data value as 'rule'; replacing the select operation word with find statement in mongfordb, replacing the table name with corresponding first number 1001, replacing the field name with corresponding second number 10011, replacing the main data value with corresponding third number 9001 to obtain corresponding table name
monglodb statement: db. Getcollection ("1001"). Find ({ "data.10011": "9001" });
(2) For delete statement in sql statement: delete from Person where sex = 'Male'
Extracting an sql operation word from the grammar tree by parsing, wherein the sql operation word is delete, the table name is Person, the field name is sex, and the main data value is 'main'; replacing the delete operation word with a remove sentence in the mondab, replacing the table name with a corresponding first number 1001, replacing the field name with a corresponding second number 10011, replacing the main data value with a corresponding third number 9001, and obtaining a corresponding mondab sentence: db. Getcollection ("1001"). Remove ({ "data.10011": "9001" }),
(3) For insert statements in sql statements: insert into Person values ('xiaoming', 'rule')
Extracting an sql operation word from the parse grammar tree as an insert, wherein the table name is Person, the first field name is name, the second field name is sex, the first main data value is "xiaoming", and the second main data value is "rule'; the insert operation word is replaced by an insert sentence in mondab, the table name is replaced by a corresponding first number 1001, the first field name is replaced by a corresponding second number 10010, the second field name is replaced by a corresponding second number 10011, and because the third number corresponding to the first main data value is "null", the first main data value is not replaced, the second main data value is replaced by a corresponding third number 9001, and a corresponding mondab sentence is obtained:
db.getCollection("1001").insert({"data.10010":"xiaoming","data.10011": "9001"});
(4) For Update statement in sql statement: update Person set sex = 'mate' where name= 'xiaoming';
extracting an sql operation word from the parse grammar tree to obtain an update, wherein the table name is Person, the first field name is name, the second field name is sex, the first main data value is "xiaoming", and the second main data value is "rule'; the update operation word is replaced by an update management statement in the mondab, the table name is replaced by a corresponding first number 1001, the first field name is replaced by a corresponding second number 10010, the second field name is replaced by a corresponding second number 10011, and the first main data value is not replaced because the corresponding third number of the first main data value is null, and the second main data value is replaced by a corresponding third number 9001, so that the corresponding mondab statement is obtained:
db.getCollection("1001").updateMany({data.10010:"xiaoming"},{$set:{"data.10011": "9001"}})
further, the meta table, the meta field table and the main data table are input in advance through a graphical interface and stored in the mongolidb.
In this embodiment, the meta table, the meta field table, and the meta data table all need to input the required table name and field name information in advance, where the input mode is auxiliary input of a graphical interface, and the information stored in the meta table includes: a first number, a table name and a table name attribute; the information stored in the meta field table includes: a second number, a field name and a field name attribute. For example: the sql statement is: select from Person where sex = 'mole'; a first number 1001, a table name Person and other attributes need to be input in the meta-table in advance; the second number 10011, the field name sex and other attributes need to be input in advance in the metadata field table, and the third number 9001, the main data name males and other attributes need to be input in advance in the metadata table.
Further, upon recognition of the execution of the sql statement, user permission verification is performed.
In this embodiment, different rights are released for different users, and rights verification is performed on the users before database operation is performed, so as to determine whether the current user has rights to operate the corresponding object, thereby improving security of database operation.
Further, when the sql statement executes the inserting and updating operation, data verification is performed to verify whether the data meets the constraint defined by the field name, and if not, the meta field is judged to be illegal.
In this embodiment, the data to be executed is verified, and whether the data to be executed meets the requirements, for example, whether the data to be executed is between a minimum value and a maximum value is judged, if the verification is not passed, an error code is thrown out to have prompt information; if the verification is passed, judging whether the document name of the data to be executed exists, and if the document name exists, directly executing the operation; if the document name does not exist, prompting abnormality, and prompting element list does not exist.
Furthermore, the metadata table is built-in information of the system, common values of common fields are built-in, and the information quantity can be increased through input when additional requirements exist.
In this embodiment, a common value is provided for a common field, and is stored in the metadata table, so that the value can be replaced in the mongolidb statement conveniently, and the conversion process from the sql statement to the mongolidb statement is completed. If the value is not in the metadata table, the information quantity of the metadata table can be increased by inputting the value and the index number.
The foregoing description of the preferred embodiments of the invention is not intended to be limiting, but rather is intended to cover all modifications, equivalents, alternatives, and improvements that fall within the spirit and scope of the invention.

Claims (8)

1. A method for updating mondab data based on sql language, comprising:
obtaining a meta table, a meta field table and a main data table, wherein the meta table comprises a plurality of meta table records, and any meta table record comprises a table name and at least one table name attribute; the meta field table comprises a plurality of meta field records, and any meta field record comprises a field name and at least one field name attribute; the master data table comprises a plurality of master data records, and any master data record comprises a master data value and at least one master data value attribute;
when the execution of the sql statement is identified, the parsing syntax tree extracts the sql operation word, the table name, the field name and the main data value in the sql statement;
replacing the sql statement with a corresponding mong odb statement according to the sql operation word, the table name, the field name and the main data value;
and executing the mongasdb statement.
2. The method for updating mong odb data based on sql language according to claim 1,
any one of the meta-table records further comprises a first number corresponding to a table name, any one of the meta-field records further comprises a second number corresponding to a field name, and any one of the main data records further comprises a third number corresponding to a main data value;
after replacing the sql statement with the corresponding mongab statement, further comprising: and replacing the table name with a corresponding first number, replacing the field name with a corresponding second number, and replacing the main data value with a third number.
3. The method for updating mondab data based on sql language according to claim 2, wherein the sql statement is a select statement, the sql operation word in the select statement is a select, and the corresponding mondab statement is: db. Getcollection ("first number"). Find ({ "data. Second number": "third number" }).
4. The method for updating mongdb data based on sql language according to claim 2, wherein the sql statement is a delete statement, the sql operation word in the delete statement is delete, and the corresponding mongdb statement is: db. Getcollection ("first number"). Remove ({ "data. Second number": "third number" }).
5. The method for updating monodb data based on sql language according to claim 2, wherein the sql statement is an insert statement, an sql operation word in the insert statement is an insert, a table name, a first field name, a second field name, a first main data value and a second main data value in the sql statement are obtained by parsing a syntax tree, and the corresponding monodb statement is: db. getcollection ("first number"). Insert ({ "data. Second number corresponding to first field name": "third number corresponding to first main data value", "data. Second number corresponding to second field name": "third number corresponding to second main data value" }).
6. The method for updating mondab data based on sql language according to claim 2, wherein the sql statement is an update statement, an sql operation word in the update statement is an update, a table name, a first field name, a second field name, a first main data value and a second main data value in the sql statement are obtained by parsing a syntax tree, and the corresponding mondab statement is: db. getcollection ("first number"). Updatman ({ data. Second number corresponding to first field name: "third number corresponding to first main data value" }, { $set: { "data. Second number corresponding to second field name": "third number corresponding to second main data value" }).
7. The method for updating mondab data based on sql language according to claim 1 or 2,
the meta table, the meta field table and the main data table are input in advance through a graphical interface and stored in the mongolib.
8. The method for updating mondab data based on sql language according to claim 1, further comprising: and when the execution of the sql statement is identified, user permission verification is performed.
CN202310824497.8A 2023-07-06 2023-07-06 Mongodb data updating method based on sql language Pending CN116756175A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310824497.8A CN116756175A (en) 2023-07-06 2023-07-06 Mongodb data updating method based on sql language

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310824497.8A CN116756175A (en) 2023-07-06 2023-07-06 Mongodb data updating method based on sql language

Publications (1)

Publication Number Publication Date
CN116756175A true CN116756175A (en) 2023-09-15

Family

ID=87957053

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310824497.8A Pending CN116756175A (en) 2023-07-06 2023-07-06 Mongodb data updating method based on sql language

Country Status (1)

Country Link
CN (1) CN116756175A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291907A (en) * 2017-06-20 2017-10-24 深圳中兴网信科技有限公司 A kind of multilingual storage of business datum and querying method and device
CN115576984A (en) * 2022-09-13 2023-01-06 粤港澳国际供应链(广州)有限公司 Method for generating SQL (structured query language) statement and cross-database query by Chinese natural language
CN115757462A (en) * 2022-11-15 2023-03-07 中国科学院软件研究所 Object-oriented database dynamic interface generation method and operation method
CN115840589A (en) * 2022-11-21 2023-03-24 焦点科技股份有限公司 Publishing method supporting heterogeneous distributed database

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107291907A (en) * 2017-06-20 2017-10-24 深圳中兴网信科技有限公司 A kind of multilingual storage of business datum and querying method and device
CN115576984A (en) * 2022-09-13 2023-01-06 粤港澳国际供应链(广州)有限公司 Method for generating SQL (structured query language) statement and cross-database query by Chinese natural language
CN115757462A (en) * 2022-11-15 2023-03-07 中国科学院软件研究所 Object-oriented database dynamic interface generation method and operation method
CN115840589A (en) * 2022-11-21 2023-03-24 焦点科技股份有限公司 Publishing method supporting heterogeneous distributed database

Similar Documents

Publication Publication Date Title
CN109840256B (en) Query realization method based on business entity
CN104657439B (en) Structured query statement generation system and method for precise retrieval of natural language
CN111291161A (en) Legal case knowledge graph query method, device, equipment and storage medium
CN104657440B (en) Structured query statement generation system and method
US9519636B2 (en) Deduction of analytic context based on text and semantic layer
CN109033410B (en) SQL (structured query language) analysis method based on regular and character string cutting
US20150227506A1 (en) Comparison of character strings
US20080140696A1 (en) System and method for analyzing data sources to generate metadata
US9064004B2 (en) Extensible surface for consuming information extraction services
CN109670022A (en) A kind of java application interface use pattern recommended method based on semantic similarity
JP2001167087A (en) Device and method for retrieving structured document, program recording medium for structured document retrieval and index preparing method for structured document retrieval
CN115576984A (en) Method for generating SQL (structured query language) statement and cross-database query by Chinese natural language
CN112231321B (en) Oracle secondary index and index real-time synchronization method
JP4247135B2 (en) Structured document storage method, structured document storage device, structured document search method
JP7168411B2 (en) Information processing system and information processing method
CN113609838A (en) Document information extraction and mapping method and system
CN114091426A (en) Method and device for processing field data in data warehouse
CN113779062A (en) SQL statement generation method and device, storage medium and electronic equipment
CN113032371A (en) Database grammar analysis method and device and computer equipment
CN111460000A (en) Backtracking data query method and system based on relational database
CN116756175A (en) Mongodb data updating method based on sql language
CN114003231B (en) SQL syntax parse tree optimization method and system
WO2011051970A2 (en) Method and system for obtaining semantically valid chunks for natural language applications
Faiz et al. OD2WD: From Open Data to Wikidata through Patterns.
JP4635585B2 (en) Question answering system, question answering method, and question answering program

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