CN108280152A - A kind of data capture method and its device - Google Patents

A kind of data capture method and its device Download PDF

Info

Publication number
CN108280152A
CN108280152A CN201810012456.8A CN201810012456A CN108280152A CN 108280152 A CN108280152 A CN 108280152A CN 201810012456 A CN201810012456 A CN 201810012456A CN 108280152 A CN108280152 A CN 108280152A
Authority
CN
China
Prior art keywords
data
regulation engine
excel tables
rule
object table
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
CN201810012456.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.)
Beijing Mininglamp Software System Co ltd
Original Assignee
Beijing Mininglamp Software System 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 Mininglamp Software System Co ltd filed Critical Beijing Mininglamp Software System Co ltd
Priority to CN201810012456.8A priority Critical patent/CN108280152A/en
Publication of CN108280152A publication Critical patent/CN108280152A/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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • 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/2457Query processing with adaptation to user needs

Abstract

The invention discloses a kind of data capture method and its devices.This method, including:Obtain initial data;By the initial data, it is arranged in Excel tables, the first row of the Excel tables includes object table field name, the secondary series of the Excel tables includes the configuration item of the object table field name, the third of the Excel tables is arranged for the initial data to be arranged, and the object table field name is arranged with the corresponding initial data in same a line;According to the regulation engine being arranged in Excel tables, target data is obtained.Realize the target data for being obtained by initial data and being suitable for data platform and carrying out data analysis.

Description

A kind of data capture method and its device
Technical field
The present invention relates to data processing technique, espespecially a kind of data capture method and its device.
Background technology
With the development of science and technology and the circulation of information, people's data to be treated are also in being incremented by geometry multiple.
In general, the prior art is that data are drawn into big data platform from relevant database by data extraction tool It is upper to carry out subsequent data analysis.For example, first, Internet bar is extracted from relevant database by data extraction tool Internet data, the Internet data include at least:Net user's name, phone, starts the surf time at ID card information, terminates online The Internet data is then carried out data analysis to obtain objective result, for example, when which being obtained by the time by data platform Between section the most information of number of netizens.
However, those skilled in the art have found during stating the prior art in realization, taken out from each relevant database The data taken cause not being suitable for data platform progress data analysis due to the difference of data format.
Invention content
In order to solve the above technical problem, the present invention provides a kind of data capture method and its device, can solve from The data that each relevant database extracts are not suitable for the technical issues of data platform carries out data analysis.
In order to reach the object of the invention, the present invention provides a kind of data capture methods, including:
Obtain initial data;
By the initial data, it is arranged in Excel tables, the first row of the Excel tables includes target literary name section Name, the secondary series of the Excel tables includes the configuration item of the object table field name, and the third row of the Excel tables are used In the initial data is arranged, the object table field name is arranged with the corresponding initial data in same a line;
According to the regulation engine being arranged in Excel tables, target data is obtained.
Further, the regulation engine, includes at least:First regulation engine;
It is described that target data is obtained according to the regulation engine being arranged in Excel tables, including:
According to first regulation engine and parameter, the target data is obtained, the parameter includes at least:It is described original Data or constant.
Further, the regulation engine further includes:First regulation engine and Second Rule engine;
It is described that target data is obtained according to the regulation engine being arranged in Excel tables, including:
According to first regulation engine and parameter, the first regulation engine is obtained as a result, according to the Second Rule engine With first regulation engine as a result, obtaining the target data, the parameter includes at least:The initial data, Huo Zhechang Amount.
Further, the regulation engine fills in specification, including:Equal to number the left side fill in the object table field name And underscore, fill in number behind underscore, rule name is filled on described the right being equal to number, after the rule name Face uses bracket, fills in parameter of regularity in the bracket, and the parameter of regularity includes the object table field name and/or often Amount, when this is equal to the mesh that the left side in the entitled last regulation engine of the object table field that number left side is filled in is filled in When marking literary name section name, this subsequent number of underscore for being equal to number left side carries out adding 1, and the number includes being greater than or equal to 1 Integer.
Further, the Excel tables further include:Gauge outfit in the Excel tables the first row is set,
The gauge outfit includes at least object table field name, configuration item field name.
The present invention provides a kind of data acquisition facilities, including:
Acquisition module, for obtaining initial data;
Setup module, for by the initial data, being arranged in Excel tables, the first row packet of the Excel tables Object table field name is included, the secondary series of the Excel tables includes the configuration item of the object table field name, the Excel tables The third of lattice is arranged for the initial data to be arranged, and the object table field name is arranged with the corresponding initial data same Row;
Processing module, for according to the regulation engine being arranged in Excel tables, obtaining target data.
Further, the regulation engine, includes at least:First regulation engine;
The processing module, for according to first regulation engine and parameter, obtaining the target data, the parameter It includes at least:The initial data or constant.
Further, the regulation engine further includes:First regulation engine and Second Rule engine;
The processing module, for according to first regulation engine and parameter, obtain the first regulation engine as a result, according to As a result, obtaining the target data, the parameter includes at least for the Second Rule engine and first regulation engine:It is described Initial data or constant.
Further, the regulation engine fills in specification, including:Equal to number the left side fill in the object table field name And underscore, fill in number behind underscore, rule name is filled on described the right being equal to number, after the rule name Face uses bracket, fills in parameter of regularity in the bracket, and the parameter of regularity includes the object table field name and/or often Amount, when this is equal to the mesh that the left side in the entitled last regulation engine of the object table field that number left side is filled in is filled in When marking literary name section name, this subsequent number of underscore for being equal to number left side carries out adding 1, and the number includes being greater than or equal to 1 Integer.
Further, the Excel tables further include:Gauge outfit in the Excel tables the first row is set,
The gauge outfit includes at least object table field name, configuration item field name.
Compared with prior art, data capture method and its device provided by the invention, wherein this method, including:It obtains Initial data;By the initial data, it is arranged in Excel tables, the first row of the Excel tables includes target literary name section Name, the secondary series of the Excel tables includes the configuration item of the object table field name, and the third row of the Excel tables are used In the initial data is arranged, the object table field name is arranged with the corresponding initial data in same a line;According to setting Regulation engine in Excel tables obtains target data.It realizes to obtain by initial data and is suitable for data platform progress The target data of data analysis.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification It obtains it is clear that understand through the implementation of the invention.The purpose of the present invention and other advantages can be by specification, rights Specifically noted structure is realized and is obtained in claim and attached drawing.
Description of the drawings
Attached drawing is used for providing further understanding technical solution of the present invention, and a part for constitution instruction, with this The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is the flow diagram of one embodiment of data capture method of the present invention;
Fig. 2 is the structural schematic diagram of one embodiment of data acquisition facility of the present invention.
Specific implementation mode
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application Feature mutually can arbitrarily combine.
Step shown in the flowchart of the accompanying drawings can be in the computer system of such as a group of computer-executable instructions It executes.Also, although logical order is shown in flow charts, and it in some cases, can be with suitable different from herein Sequence executes shown or described step.
Fig. 1 is the flow diagram of one embodiment of data capture method of the present invention;As shown in Figure 1, the execution of the present embodiment Main body is data acquisition facility, data capture method provided by the invention, including:
Step 101 obtains initial data.
Specifically, the initial data can be obtained from the database for be ready for data analysis.
Step 102, by the initial data, be arranged in Excel tables.
Specifically, the first row of the Excel tables includes object table field name, the secondary series packet of the Excel tables The configuration item of the object table field name is included, the third of the Excel tables is arranged for the initial data, the target to be arranged Literary name section name is arranged with the corresponding initial data in same a line;It should be noted that first row can be in the present embodiment The combination of arbitrary one or more columns per page in Excel tables, meanwhile, secondary series can also be arbitrary one or more columns per page in Excel tables Combination, third row can be arbitrary one or more columns per page in Excel tables combination.For example, first row may include Excel tables Two row in lattice, a row include the English name of target literary name section, and another row include the Chinese name of target literary name section;
For example, configuration item may include following any one or combinations thereof:Remarks des, if primary attribute, it is distributed File system HDFS subscripts, data type, time format, if long character string, index type, radix, if multivalue, joint rule Then, search-type, major key type, major key original name in relationship, suffix row subscript test default value.Each configuration item can be arranged In a row, that is to say, that secondary series can also be the multiple row in Excel tables.
Step 103, according to the regulation engine being arranged in Excel tables, obtain target data.
For according to the regulation engine being arranged in Excel tables, obtaining target data and including at least following two realizations Mode:
The first realization method, the regulation engine, include at least:First regulation engine;
First regulation engine includes obtaining the rule of the first regulation engine result, the parameter is at least according to parameter Including:The initial data or constant.That is, the first regulation engine suitable for data platform the result is that carry out data The target data of analysis.
Second of realization method, the regulation engine may include:First regulation engine and Second Rule engine;
First regulation engine includes obtaining the rule of the first regulation engine result, the parameter is at least according to parameter Including:The initial data or constant.The Second Rule engine includes according to first regulation engine as a result, obtaining The rule of Second Rule engine results.That is, Second Rule engine results are to be suitable for data platform to carry out data analysis Target data.
In the present embodiment, by obtaining initial data;The initial data is set in Excel tables, it is described The first row of Excel tables includes object table field name, and the secondary series of the Excel tables includes the object table field name Configuration item, the thirds of the Excel tables are arranged for being arranged the initial data, the object table field name with it is corresponding described Initial data is arranged in same a line;According to the regulation engine being arranged in Excel tables, target data is obtained.It realizes and passes through Initial data, which obtains, is suitable for the target data that data platform carries out data analysis.
Further, on the basis of the above embodiments, the regulation engine fills in specification, including:Equal to number a left side While fill in the object table field name and underscore, number is filled in behind underscore, described the right being equal to number is filled in Rule name uses bracket behind the rule name, parameter of regularity is filled in the bracket, the parameter of regularity includes institute Object table field name and/or constant are stated, is drawn when this is equal to the entitled last rule of the object table field that number left side is filled in When the object table field name that the left side in holding up is filled in, this subsequent number of underscore for being equal to number left side carries out adding 1, institute It includes the integer more than or equal to 1 to state number.
Further, on the basis of the above embodiments, the Excel tables further include:It is arranged in the Excel tables The gauge outfit of lattice the first row.
The gauge outfit includes at least object table field name, configuration item field name.
The present invention also provides an embodiments.Assuming that online (wbsw) original table of throwing the net, the field of original table have net Number (wbid), online personnel identity card number (swrysfzh), online personnel's name (swryxm), online time started (swkssj), the fields such as online end time (swjssj) need the mesh that an entity people (person) is extracted from original table Table is marked, the field extracted in object table has name (xm), identification card number (sfzh), gender (xb).
Step 1: the first row in Excel tables fills in gauge outfit, as shown in Table 1:
Table one
Step 2: A row fill in name, identification card number, gender in Excel tables, that B row are filled in is xm, sfzh, xb, It is arranged from C to R row and fills in configuration item, as shown in Table 2:
Table two
Step 3: the first row in Excel tables fills in Internet bar's online (wbsw), what is mapped with target literary name section Row, fills in the English name of original table, fills in initial data swryxm, swrysfzh respectively, as shown in Table 3:
Table three
Step 4: in the rule for issuing configuration object table of original table, the field of target has identification card number, needs to identity Card number increase a filtering rule sfzh_1=id_card_convert (sfzh), the rule realization by identification card number rule from 15 are converted to 18, the rejection of data for the identification card number for being unsatisfactory for condition by 18.It can extracting property from identification card number Not, it needs to increase a rule xb_1=id_card_2_sex_convert (sfzh_1) to gender.As shown in Table 4:
Table four
Sfzh_1=id_card_convert (sfzh)
Xb_1=id_card_2_sex_convert (sfzh_1)
By the content in one excel table of synthesis described above, rule system as follows has been obtained:
Fig. 2 is the structural schematic diagram of one embodiment of data acquisition facility of the present invention;As shown in Fig. 2, number provided by the invention According to acquisition device, including:Acquisition module 21, setup module 22 and processing module 23;Wherein,
Acquisition module 21, for obtaining initial data;
Setup module 22, for by the initial data, being arranged in Excel tables, the first of the Excel tables Row include object table field name, and the secondary series of the Excel tables includes the configuration item of the object table field name, described The third of Excel tables is arranged for the initial data to be arranged, and the object table field name is set with the corresponding initial data It sets in same a line;
Processing module 23, for according to the regulation engine being arranged in Excel tables, obtaining target data.
In the present embodiment, by obtaining initial data;The initial data is set in Excel tables, it is described The first row of Excel tables includes object table field name, and the secondary series of the Excel tables includes the object table field name Configuration item, the thirds of the Excel tables are arranged for being arranged the initial data, the object table field name with it is corresponding described Initial data is arranged in same a line;According to the regulation engine being arranged in Excel tables, target data is obtained.It realizes and passes through Initial data, which obtains, is suitable for the target data that data platform carries out data analysis.
On the basis of the above embodiments, the regulation engine, includes at least:First regulation engine;
The processing module 23, for according to first regulation engine and parameter, obtaining the target data, the ginseng Number includes at least:The initial data or constant.
Further, on the basis of the above embodiments, the regulation engine further includes:First regulation engine and second Regulation engine;
The processing module 23, for according to first regulation engine and parameter, obtaining the first regulation engine as a result, root According to the Second Rule engine and first regulation engine as a result, obtaining the target data, the parameter includes at least:Institute State initial data or constant.
Preferably, the regulation engine fills in specification, including:Equal to number the left side fill in the object table field name with And underscore, fill in number behind underscore, rule name is filled on described the right being equal to number, behind the rule name Using bracket, parameter of regularity is filled in the bracket, the parameter of regularity includes the object table field name and/or constant, When this is equal to the target that the left side in the entitled last regulation engine of the object table field that number left side is filled in is filled in When literary name section name, this subsequent number of underscore for being equal to number left side carries out adding 1, and the number includes being greater than or equal to 1 Integer.
Further, on the basis of the above embodiments, the Excel tables further include:It is arranged in the Excel tables The gauge outfit of lattice the first row,
The gauge outfit includes at least object table field name, configuration item field name.
Although disclosed herein embodiment it is as above, the content only for ease of understanding the present invention and use Embodiment is not limited to the present invention.Technical staff in any fields of the present invention is taken off not departing from the present invention Under the premise of the spirit and scope of dew, any modification and variation, but the present invention can be carried out in the form and details of implementation Scope of patent protection, still should be subject to the scope of the claims as defined in the appended claims.

Claims (10)

1. a kind of data capture method, which is characterized in that including:
Obtain initial data;
By the initial data, it is arranged in Excel tables, the first row of the Excel tables includes object table field name, institute The secondary series for stating Excel tables includes the configuration item of the object table field name, and the third of the Excel tables is arranged for being arranged The initial data, the object table field name are arranged with the corresponding initial data in same a line;
According to the regulation engine being arranged in Excel tables, target data is obtained.
2. data capture method according to claim 1, which is characterized in that the regulation engine includes at least:First rule Then engine;
It is described that target data is obtained according to the regulation engine being arranged in Excel tables, including:
According to first regulation engine and parameter, the target data is obtained, the parameter includes at least:The original number According to or constant.
3. data capture method according to claim 1, which is characterized in that the regulation engine further includes:First rule Engine and Second Rule engine;
It is described that target data is obtained according to the regulation engine being arranged in Excel tables, including:
According to first regulation engine and parameter, the first regulation engine is obtained as a result, according to the Second Rule engine and institute The first regulation engine is stated as a result, obtaining the target data, the parameter includes at least:The initial data or constant.
4. according to claim 1-3 any one of them data capture methods, which is characterized in that the regulation engine fills in rule Model, including:Equal to number the left side fill in the object table field name and underscore, fill in number behind the underscore Word, described the right being equal to number fill in rule name, bracket are used behind the rule name, rule is filled in the bracket Parameter, the parameter of regularity includes the object table field name and/or constant, when this is equal to the target that number left side is filled in When the object table field name that the left side in the entitled last regulation engine of literary name section is filled in, this is equal to lower stroke of number left side The subsequent number of line carries out adding 1, and the number includes the integer more than or equal to 1.
5. data capture method according to claim 4, which is characterized in that the Excel tables further include:Setting is in institute The gauge outfit of Excel table the first rows is stated,
The gauge outfit includes at least object table field name, configuration item field name.
6. a kind of data acquisition facility, which is characterized in that including:
Acquisition module, for obtaining initial data;
Setup module, for by the initial data, being arranged in Excel tables, the first row of the Excel tables includes mesh Literary name section name is marked, the secondary series of the Excel tables includes the configuration item of the object table field name, the Excel tables Third is arranged for the initial data to be arranged, and the object table field name is arranged with the corresponding initial data in same a line;
Processing module, for according to the regulation engine being arranged in Excel tables, obtaining target data.
7. data acquisition facility according to claim 6, which is characterized in that the regulation engine includes at least:First rule Then engine;
The processing module, for according to first regulation engine and parameter, obtaining the target data, the parameter is at least Including:The initial data or constant.
8. data acquisition facility according to claim 6, which is characterized in that the regulation engine further includes:First rule Engine and Second Rule engine;
The processing module, for according to first regulation engine and parameter, obtaining the first regulation engine as a result, according to described As a result, obtaining the target data, the parameter includes at least for Second Rule engine and first regulation engine:It is described original Data or constant.
9. according to claim 6-8 any one of them data acquisition facilities, which is characterized in that the regulation engine fills in rule Model, including:Equal to number the left side fill in the object table field name and underscore, number is filled in behind underscore, institute State equal to number the right fill in rule name, bracket is used behind the rule name, parameter of regularity is filled in the bracket, The parameter of regularity includes the object table field name and/or constant, when this is equal to the target literary name that number left side is filled in When the object table field name that the left side in Duan Mingwei last time regulation engines is filled in, after this is equal to the underscore on number left side The number in face carries out adding 1, and the number includes the integer more than or equal to 1.
10. data acquisition facility according to claim 9, which is characterized in that the Excel tables further include:Setting exists The gauge outfit of the Excel tables the first row,
The gauge outfit includes at least object table field name, configuration item field name.
CN201810012456.8A 2018-01-05 2018-01-05 A kind of data capture method and its device Pending CN108280152A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810012456.8A CN108280152A (en) 2018-01-05 2018-01-05 A kind of data capture method and its device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810012456.8A CN108280152A (en) 2018-01-05 2018-01-05 A kind of data capture method and its device

Publications (1)

Publication Number Publication Date
CN108280152A true CN108280152A (en) 2018-07-13

Family

ID=62801619

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810012456.8A Pending CN108280152A (en) 2018-01-05 2018-01-05 A kind of data capture method and its device

Country Status (1)

Country Link
CN (1) CN108280152A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110276060A (en) * 2019-06-24 2019-09-24 北京明略软件系统有限公司 The method and device of data processing
CN111488340A (en) * 2019-01-29 2020-08-04 菜鸟智能物流控股有限公司 Data processing method and device and electronic equipment

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101763348A (en) * 2008-12-26 2010-06-30 英业达股份有限公司 Dynamic table type data acquisition system and method
CN102054025A (en) * 2010-12-01 2011-05-11 北京中交通信科技有限公司 Traffic information resource integration processing method and system
CN103257959A (en) * 2012-02-15 2013-08-21 深圳市金蝶友商电子商务服务有限公司 Method and device for generating spreadsheet report

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101763348A (en) * 2008-12-26 2010-06-30 英业达股份有限公司 Dynamic table type data acquisition system and method
CN102054025A (en) * 2010-12-01 2011-05-11 北京中交通信科技有限公司 Traffic information resource integration processing method and system
CN103257959A (en) * 2012-02-15 2013-08-21 深圳市金蝶友商电子商务服务有限公司 Method and device for generating spreadsheet report

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111488340A (en) * 2019-01-29 2020-08-04 菜鸟智能物流控股有限公司 Data processing method and device and electronic equipment
CN111488340B (en) * 2019-01-29 2023-09-12 菜鸟智能物流控股有限公司 Data processing method and device and electronic equipment
CN110276060A (en) * 2019-06-24 2019-09-24 北京明略软件系统有限公司 The method and device of data processing
CN110276060B (en) * 2019-06-24 2022-12-09 北京明略软件系统有限公司 Data processing method and device

Similar Documents

Publication Publication Date Title
WO2019200781A1 (en) Receipt recognition method and device, and storage medium
CN107729392A (en) Text structure method, apparatus, system and non-volatile memory medium
CN107247949A (en) Face identification method, device and electronic equipment based on deep learning
AU2019322953A1 (en) Method, system, storage medium and electric device of medical automatic question answering
CN108986912A (en) Chinese medicine stomach trouble tongue based on deep learning is as information intelligent processing method
CN104484845B (en) Disease autoanalysis platform based on medical information ontology database
CN104268192B (en) A kind of webpage information extracting method, device and terminal
CN107424145A (en) The dividing method of nuclear magnetic resonance image based on three-dimensional full convolutional neural networks
CN106909572A (en) A kind of construction method and device of question and answer knowledge base
CN108280152A (en) A kind of data capture method and its device
CN108763874A (en) A kind of chromosome classification method and device based on generation confrontation network
CN106777996A (en) A kind of physical examination data search system based on Solr
CN105808757A (en) Chinese herbal medicine plant picture retrieval method based on multi-feature fusion BOW model
CN109711252A (en) A kind of face identification method of more ethnic groups
CN107622042A (en) A kind of document generation method, device, storage medium and electronic equipment
CN104035980B (en) A kind of search method and system of structure-oriented pharmaceutical information
CN109284700A (en) The method of multiple Face datections, storage medium, equipment and system in image
CN109815478A (en) Medicine entity recognition method and system based on convolutional neural networks
CN109215798A (en) A kind of construction of knowledge base method towards Chinese medicine ancient Chinese prose
Gao et al. Psycho-geometric analysis of commonly used Chinese characters.
CN106844313A (en) A kind of method and apparatus that Word file is converted into html file
CN102982011B (en) A kind of method and apparatus for recognizing out-of-sequence text
Gavhale et al. Identification of medicinal plant using Machine learning approach
CN104504104B (en) Picture material processing method, device and search engine for search engine
CN106095754B (en) A kind of medical terminology dictionary part-of-speech tagging method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20180713

WD01 Invention patent application deemed withdrawn after publication