CN111581236A - Data query method and device - Google Patents

Data query method and device Download PDF

Info

Publication number
CN111581236A
CN111581236A CN202010256459.3A CN202010256459A CN111581236A CN 111581236 A CN111581236 A CN 111581236A CN 202010256459 A CN202010256459 A CN 202010256459A CN 111581236 A CN111581236 A CN 111581236A
Authority
CN
China
Prior art keywords
interval
query
determining
data
parameters
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
CN202010256459.3A
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.)
Postal Savings Bank of China Ltd
Original Assignee
Postal Savings Bank of China 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 Postal Savings Bank of China Ltd filed Critical Postal Savings Bank of China Ltd
Priority to CN202010256459.3A priority Critical patent/CN111581236A/en
Publication of CN111581236A publication Critical patent/CN111581236A/en
Pending legal-status Critical Current

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/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • 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/2228Indexing structures

Landscapes

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

Abstract

The application relates to a data query method and a data query device, wherein the method comprises the following steps: when receiving a query request, converting the initial query parameters into interval query parameters; determining the interval of the query result according to the interval query parameter; and determining a query result according to the initial query parameters in the determined interval. The scheme of the application is based on a database index technology, the data columns with excessive data different values are subjected to interval division, and the interval is locked and then screened during query, so that the data query speed can be obviously improved; the execution steps of the scheme can be packaged into technical components, transparent use is provided for application, and normal development work is not influenced.

Description

Data query method and device
Technical Field
The application relates to the technical field of database indexing, in particular to a data query method and device.
Background
An index is a structure that orders values of one or more columns in a database table, and can also be understood as: the auxiliary data structure of the record ID meeting the limitation condition can be found as soon as possible by the information searcher. One of the main purposes of the index is to speed up the retrieval of data in the table, and to use the index to quickly access specific information in the database table.
However, indexing a table comes at a corresponding cost: firstly, the index created in the database also occupies the storage space of the database, and secondly, when the data in the table is modified, such as adding, deleting or modifying operation, the index also needs to be dynamically maintained, so that the maintenance of the database takes much time.
From a data search implementation perspective, an index is also another type of file/record that contains various records that may indicate related data records. Each index has a corresponding search code, and any subset of the character segments can form a search code. Thus, the index is equivalent to a collection of all data directory entries that provides the various efficient support required for locating all data directory entries for a given search code value.
In the related art, in the current database indexing process, if different values of each row of data are too much, such as bank customer balance data, the speed of query cannot be increased by establishing the index, but the storage space of the index is increased, table scanning is caused during query, and the query performance is very low. In a bank marketing system, searching according to balance is a common scene; however, no mature technical scheme exists at present, and the query performance can be improved under the scenes.
Disclosure of Invention
To overcome, at least to some extent, the problems in the related art, the present application provides a data query method and apparatus.
According to a first aspect of embodiments of the present application, there is provided a data query method, including:
when receiving a query request, converting the initial query parameters into interval query parameters;
determining the interval of the query result according to the interval query parameter;
and determining a query result according to the initial query parameters in the determined interval.
Further, the method further comprises:
dividing a data column in a data table into a plurality of intervals according to preset interval parameters;
and establishing indexes for the divided intervals.
Further, the data columns in the data table are floating point data columns;
the dividing the data columns in the data table into a plurality of intervals according to preset interval parameters comprises:
determining an integer column corresponding to the floating point data column according to a preset interval parameter;
the obtained integer column is added to the data table.
Further, the determining the integer columns corresponding to the floating point data columns includes:
determining a mapping relation from floating point data to an integer according to a preset interval parameter;
and mapping each floating point data of the floating point data column into a corresponding integer according to the mapping relation.
Further, the converting the initial query parameter into the interval query parameter includes:
acquiring initial query parameters from the query request;
and mapping the initial query parameters to corresponding interval query parameters according to the mapping relation.
Further, the determining the interval where the query result is located according to the interval query parameter includes:
determining an interval upper limit and an interval lower limit according to the interval query parameters;
and determining the interval between the upper limit and the lower limit of the interval as the interval of the query result.
Further, the initial query parameter is floating point data;
the determining a query result according to the initial query parameter includes:
and screening the floating point data in the determined interval, and determining a screening result as a query result.
According to a second aspect of embodiments of the present application, there is provided a data query apparatus including:
the conversion module is used for converting the initial query parameters into interval query parameters when receiving the query request;
the interval determining module is used for determining the interval of the query result according to the interval query parameters;
and the result determining module is used for determining a query result according to the initial query parameters in the determined interval.
According to a third aspect of embodiments of the present application, there is provided a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: when receiving a query request, converting the initial query parameters into interval query parameters; determining the interval of the query result according to the interval query parameter; and determining a query result according to the initial query parameters in the determined interval.
According to a fourth aspect of embodiments of the present application, there is provided a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of: when receiving a query request, converting the initial query parameters into interval query parameters; determining the interval of the query result according to the interval query parameter; and determining a query result according to the initial query parameters in the determined interval.
The technical scheme provided by the embodiment of the application has the following beneficial effects:
the scheme of the application is based on a database index technology, the data columns with excessive data different values are subjected to interval division, and the interval is locked and then screened during query, so that the data query speed can be obviously improved; the execution steps of the scheme can be packaged into technical components, transparent use is provided for application, and normal development work is not influenced.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
FIG. 1 is a flow chart illustrating a method of data querying in accordance with an exemplary embodiment.
FIG. 2 is a data flow diagram illustrating a method of data query in accordance with an exemplary embodiment.
Fig. 3 is a schematic diagram of a test result of a data test performed by applying the data query method of the present application.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of methods and apparatus consistent with certain aspects of the present application, as detailed in the appended claims.
FIG. 1 is a flow chart illustrating a method of data querying in accordance with an exemplary embodiment. The method can be applied to a database indexing technology, and specifically comprises the following steps:
step S1: when receiving a query request, converting the initial query parameters into interval query parameters;
step S2: determining the interval of the query result according to the interval query parameter;
step S3: and determining a query result according to the initial query parameters in the determined interval.
The scheme of the application is based on a database index technology, the data columns with excessive data different values are subjected to interval division, and the interval is locked and then screened during query, so that the data query speed can be obviously improved; the execution steps of the scheme can be packaged into technical components, transparent use is provided for application, and normal development work is not influenced.
In some embodiments, the method further comprises:
dividing a data column in a data table into a plurality of intervals according to preset interval parameters;
and establishing indexes for the divided intervals.
According to the scheme of the application, before the specific query step is carried out, the data in the data table needs to be preprocessed. For example, if the interval parameter is 5 ten thousand, a plurality of intervals such as 0-50000, 50000-100000, 100000-150000, etc. need to be divided; then, indexes are established for the intervals, such as the interval 0-50000 corresponding to an integer 001, the interval 50000-100000 corresponding to an integer 002, the interval 100000-150000 corresponding to an integer 003, and the like.
In some embodiments, the data columns in the data table are floating point data columns;
the dividing the data columns in the data table into a plurality of intervals according to preset interval parameters comprises:
determining an integer column corresponding to the floating point data column according to a preset interval parameter;
the obtained integer column is added to the data table.
Floating point data is a column of data in the data table (column F) and the preprocessing process requires the addition of a column of data in the data table (column Z). For example, a floating point datum (column F datum) is 1234.656, and the interval parameter is 5 ten thousand; according to the interval parameter, the integer column (column Z) data corresponding to the floating point data is determined to be 001, and then 001 is written into the corresponding position of the column Z in the data table.
In some embodiments, the determining the integer columns corresponding to the floating point data columns includes:
determining a mapping relation from floating point data to an integer according to a preset interval parameter;
and mapping each floating point data of the floating point data column into a corresponding integer according to the mapping relation.
The mapping relationship is that the interval 0-50000 corresponds to an integer 001, the interval 50000-100000 corresponds to an integer 002, the interval 100000-150000 corresponds to an integer 003, and the like.
The following describes the scheme of the present application in an expanded manner with reference to a specific application scenario.
As shown in fig. 2, the solution of the present application is based on a database indexing technique, and for floating point data of a balance class of a client, the floating point data is first divided into an interval according to 5 ten thousand (which can be customized by parameters) to obtain an integer, and then an index is established on the integer, so that an index is established on a limited data set, and balance class data screening is performed in each interval, which can greatly reduce table scanning, and can significantly improve query performance.
Referring to FIG. 2, SQL is queried by the column F values, the query statement is:
"Select from Table
where column F-1234.656 "
Referring to fig. 2, parameters are automatically combined, and the combined query statement is:
"Select from Table
where column Z between interval upper limit and interval lower limit
And column F-1234.656 "
In some embodiments, the converting the initial query parameters into interval query parameters includes:
acquiring initial query parameters from the query request;
and mapping the initial query parameters to corresponding interval query parameters according to the mapping relation.
In some embodiments, the determining, according to the interval query parameter, an interval in which the query result is located includes:
determining an interval upper limit and an interval lower limit according to the interval query parameters;
and determining the interval between the upper limit and the lower limit of the interval as the interval of the query result.
In some embodiments, the initial query parameter is floating point data;
the determining a query result according to the initial query parameter includes:
and screening the floating point data in the determined interval, and determining a screening result as a query result.
Referring to fig. 3, the scheme is tested on Sybase ASE and Sybase IQ, and the test is divided into two groups, and the second group uses the technical scheme of the application. The two sets of test comparison data are as follows:
Figure BDA0002437514950000061
through experimental data, the scheme of the application can shorten the query time under the same system environment, and has equivalent ASE lifting ratio reaching 495 times and 16 times lifting effect on IQ.
The scheme of the application is mainly based on a database indexing technology, indexes generally adopt a B + tree structure, indexes are established for different value-limited columns in a database, and the data types such as integers, character types and the like can obviously improve the data query speed.
The scheme of the application can be applied to the use scene of bank balance data, floating point numbers are converted into integers, and indexes are built for the integers, so that the query performance is improved. The scheme of the application also encapsulates the conversion storage function of the data column and the Sql conversion function of the query parameters into technical components (namely an automatic data conversion component and an automatic query SQL conversion component), provides transparent use for application, and does not influence normal development work.
The present application further provides the following embodiments:
a data query apparatus, comprising:
the conversion module is used for converting the initial query parameters into interval query parameters when receiving the query request;
the interval determining module is used for determining the interval of the query result according to the interval query parameters;
and the result determining module is used for determining a query result according to the initial query parameters in the determined interval.
With regard to the apparatus in the above embodiment, the specific steps in which the respective modules perform operations have been described in detail in the embodiment related to the method, and are not described in detail herein.
The present application further provides the following embodiments:
a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: when receiving a query request, converting the initial query parameters into interval query parameters; determining the interval of the query result according to the interval query parameter; and determining a query result according to the initial query parameters in the determined interval.
The present application further provides the following embodiments:
a computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of: when receiving a query request, converting the initial query parameters into interval query parameters; determining the interval of the query result according to the interval query parameter; and determining a query result according to the initial query parameters in the determined interval.
It is understood that the same or similar parts in the above embodiments may be mutually referred to, and the same or similar parts in other embodiments may be referred to for the content which is not described in detail in some embodiments.
It should be noted that, in the description of the present application, the terms "first", "second", etc. are used for descriptive purposes only and are not to be construed as indicating or implying relative importance. Further, in the description of the present application, the meaning of "a plurality" means at least two unless otherwise specified.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and the scope of the preferred embodiments of the present application includes other implementations in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.
It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc.
In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.

Claims (10)

1. A method for querying data, comprising:
when receiving a query request, converting the initial query parameters into interval query parameters;
determining the interval of the query result according to the interval query parameter;
and determining a query result according to the initial query parameters in the determined interval.
2. The method of claim 1, further comprising:
dividing a data column in a data table into a plurality of intervals according to preset interval parameters;
and establishing indexes for the divided intervals.
3. The method of claim 2, wherein the data columns in the data table are floating point data columns;
the dividing the data columns in the data table into a plurality of intervals according to preset interval parameters comprises:
determining an integer column corresponding to the floating point data column according to a preset interval parameter;
the obtained integer column is added to the data table.
4. The method of claim 3, wherein determining the integer columns corresponding to the floating point data columns comprises:
determining a mapping relation from floating point data to an integer according to a preset interval parameter;
and mapping each floating point data of the floating point data column into a corresponding integer according to the mapping relation.
5. The method of claim 4, wherein converting the initial query parameters into interval query parameters comprises:
acquiring initial query parameters from the query request;
and mapping the initial query parameters to corresponding interval query parameters according to the mapping relation.
6. The method according to any one of claims 1 to 5, wherein the determining the interval in which the query result is located according to the interval query parameter includes:
determining an interval upper limit and an interval lower limit according to the interval query parameters;
and determining the interval between the upper limit and the lower limit of the interval as the interval of the query result.
7. The method of any of claims 1-5, wherein the initial query parameters are floating point data;
the determining a query result according to the initial query parameter includes:
and screening the floating point data in the determined interval, and determining a screening result as a query result.
8. A data query apparatus, comprising:
the conversion module is used for converting the initial query parameters into interval query parameters when receiving the query request;
the interval determining module is used for determining the interval of the query result according to the interval query parameters;
and the result determining module is used for determining a query result according to the initial query parameters in the determined interval.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
CN202010256459.3A 2020-04-02 2020-04-02 Data query method and device Pending CN111581236A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010256459.3A CN111581236A (en) 2020-04-02 2020-04-02 Data query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010256459.3A CN111581236A (en) 2020-04-02 2020-04-02 Data query method and device

Publications (1)

Publication Number Publication Date
CN111581236A true CN111581236A (en) 2020-08-25

Family

ID=72126147

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010256459.3A Pending CN111581236A (en) 2020-04-02 2020-04-02 Data query method and device

Country Status (1)

Country Link
CN (1) CN111581236A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112699534A (en) * 2020-12-11 2021-04-23 北京首钢股份有限公司 Method and device for producing cold-rolled products
CN113282619A (en) * 2021-04-13 2021-08-20 国网山东省电力公司物资公司 Data rapid query method and system
CN116521713A (en) * 2023-06-30 2023-08-01 北京奥星贝斯科技有限公司 Data query method, device, equipment and storage medium

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103020204A (en) * 2012-12-05 2013-04-03 北京普泽天玑数据技术有限公司 Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table
CN104750681A (en) * 2013-12-25 2015-07-01 中国移动通信集团辽宁有限公司 Method and device for processing mass data
US20150356140A1 (en) * 2014-06-09 2015-12-10 International Business Machines Corporation Adapting a relational query to accommodate hierarchical data
US20170032024A1 (en) * 2015-07-28 2017-02-02 Alibaba Group Holding Limited Information query
CN106383860A (en) * 2016-08-31 2017-02-08 无锡雅座在线科技发展有限公司 Data query method and apparatus
CN107766574A (en) * 2017-11-13 2018-03-06 天津开心生活科技有限公司 Data query method and device, date storage method and device
CN109284351A (en) * 2018-08-14 2019-01-29 青海大学 A kind of data query method based on HBase database
CN110175157A (en) * 2019-04-24 2019-08-27 平安科技(深圳)有限公司 A kind of querying method and inquiry unit of column storage file
CN110765238A (en) * 2019-10-12 2020-02-07 北京字节跳动网络技术有限公司 Data encryption query method and device

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103020204A (en) * 2012-12-05 2013-04-03 北京普泽天玑数据技术有限公司 Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table
CN104750681A (en) * 2013-12-25 2015-07-01 中国移动通信集团辽宁有限公司 Method and device for processing mass data
US20150356140A1 (en) * 2014-06-09 2015-12-10 International Business Machines Corporation Adapting a relational query to accommodate hierarchical data
US20170032024A1 (en) * 2015-07-28 2017-02-02 Alibaba Group Holding Limited Information query
CN106407250A (en) * 2015-07-28 2017-02-15 阿里巴巴集团控股有限公司 Information query method, device and system, server and client side
CN106383860A (en) * 2016-08-31 2017-02-08 无锡雅座在线科技发展有限公司 Data query method and apparatus
CN107766574A (en) * 2017-11-13 2018-03-06 天津开心生活科技有限公司 Data query method and device, date storage method and device
CN109284351A (en) * 2018-08-14 2019-01-29 青海大学 A kind of data query method based on HBase database
CN110175157A (en) * 2019-04-24 2019-08-27 平安科技(深圳)有限公司 A kind of querying method and inquiry unit of column storage file
CN110765238A (en) * 2019-10-12 2020-02-07 北京字节跳动网络技术有限公司 Data encryption query method and device

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112699534A (en) * 2020-12-11 2021-04-23 北京首钢股份有限公司 Method and device for producing cold-rolled products
CN113282619A (en) * 2021-04-13 2021-08-20 国网山东省电力公司物资公司 Data rapid query method and system
CN116521713A (en) * 2023-06-30 2023-08-01 北京奥星贝斯科技有限公司 Data query method, device, equipment and storage medium
CN116521713B (en) * 2023-06-30 2023-09-12 北京奥星贝斯科技有限公司 Data query method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
CN110019218B (en) Data storage and query method and equipment
CN111581236A (en) Data query method and device
CN107807982B (en) Consistency checking method and device for heterogeneous database
US7523288B2 (en) Dynamic fragment mapping
US6029163A (en) Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer
US6681218B1 (en) System for managing RDBM fragmentations
US6405187B1 (en) Utilizing encoded vector indexes for statistics in database processing
CN112685446B (en) Complex SQL query method, device, processor and storage medium through elastic search database
CN116450656B (en) Data processing method, device, equipment and storage medium
CN110168532A (en) Data-updating method and storage device
CN112214472A (en) Meteorological grid point data storage and query method, device and storage medium
CN113918605A (en) Data query method, device, equipment and computer storage medium
CN114328612A (en) Data processing method and device of query optimizer and electronic equipment
CN116150093B (en) Method for realizing object storage enumeration of objects and electronic equipment
CN109299106B (en) Data query method and device
CN110019192B (en) Database retrieval method and device
CN110968555B (en) Dimension data processing method and device
US6275822B1 (en) Maintaining very large indexes supporting efficient relational querying
CN113434511B (en) Clustering index method based on Hilbert curve
CN111382120B (en) Small file management method, system and computer equipment
CN113934726A (en) Random smooth sub-table method, terminal and storage medium
CN108521527B (en) Ticket difference detection method, system, computer storage medium and computer equipment
CN115543993A (en) Data processing method and device, electronic equipment and storage medium
CN110019971B (en) Index creation method, device and database system
CN116303627B (en) Query method and device for semiconductor test data, electronic equipment and storage medium

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