CN109902100A - Report form inquiring method, device and storage medium - Google Patents
Report form inquiring method, device and storage medium Download PDFInfo
- Publication number
- CN109902100A CN109902100A CN201910100167.8A CN201910100167A CN109902100A CN 109902100 A CN109902100 A CN 109902100A CN 201910100167 A CN201910100167 A CN 201910100167A CN 109902100 A CN109902100 A CN 109902100A
- Authority
- CN
- China
- Prior art keywords
- data
- label
- tables
- query
- report
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 230000007115 recruitment Effects 0.000 description 12
- 238000002372 labelling Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000004364 calculation method Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000007781 pre-processing Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000011835 investigation Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000005055 memory storage Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Abstract
The invention belongs to big data technical fields, disclose a kind of report form inquiring method, comprising: mark label to tables of data, the label includes dimensional labels and index label;Obtain report query request;The inquiry request is pre-processed, query statement is generated;Judging whether there is then terminates querying flow if it does not exist with the matched label of the query statement;If it exists, then it carries out in next step;It is inquired according to inquiry request pair tables of data corresponding with the matched label of the query statement, obtains query result.The invention also discloses a kind of electronic device and storage mediums.The present invention establishes the association between each tables of data, realizes in the case where user does not know about data store organisation, carry out accurately Query Location to data target, improve search efficiency by marking label to tables of data.Also, the inquiry of the data between full database or multiple databases, even inter-trade data query may be implemented in the present invention.
Description
Technical field
The present invention relates to big data technical field more particularly to a kind of report form inquiring methods, device and storage medium.
Background technique
With the development of computer technology, people use computer to carry out data process&analysis more and more, for enterprise
Industry decision provides data supporting, makes enterprise informatization evolution.Report is the important support of IT application in enterprises, is sent out for IT application in enterprises
Wave important function.Report is to carry out Dynamically Announce data with formats such as table, charts, and main purpose is that data are utilized systematization
Arrangement, become portion indispensable in enterprise application system according to different demands in order to which the mode of understanding shows
Point.Due to scientific and technical fast development, mass data can be all generated daily, these data are stored by report, pass through inquiry and report
Table finds the data of needs.Currently, general indicator data need in same table, user it should be understood that table association structure, no
The user for being familiar with data store organisation is difficult to make report, and worth of data usually requires data mining engineer and making
Worth of data is stored in same table before report, so, generally the data in same table are associated, and
In the case where mass data, being associated with for the data between table and table is not taken into account that when making report substantially, when inquiring report, number
Basic unit and form of thinking according to processing are as unit of table, prevent non-same library data from being associated with well, data cannot
By dereferenced relationship, it is difficult the data in full library or more libraries investigation traversal mixed in together.
Summary of the invention
The present invention provides a kind of report form inquiring method, device and storage medium, when solving to inquire report in the prior art,
Non- same library data cannot be associated with well, it is difficult to the problem of traversing the data in full library or more libraries investigation mixed in together.
To achieve the goals above, it is an aspect of the invention to provide a kind of report form inquiring methods, comprising: to tables of data
Label is marked, the label includes dimensional labels and index label;Obtain report query request;The inquiry request is carried out pre-
Processing generates query statement;Judging whether there is then terminates inquiry stream if it does not exist with the matched label of the query statement
Journey;If it exists, then it carries out in next step;It is carried out according to inquiry request pair tables of data corresponding with the matched label of the query statement
Inquiry obtains query result.
Preferably, the step of marking label to tables of data includes: to count the data of multiple tables of data, and according to tables of data
Data determine the theme of the tables of data;Classified according to the theme of the tables of data to tables of data;According to classification results pair
The tables of data marks label.
Preferably, when user inputs text request inquiry report, carrying out pretreated step to the inquiry request includes:
Input text is segmented to obtain multiple phrases, the multiple phrase forms the query statement.
Preferably, when user inputs voice request inquiry report, carrying out pretreated step to the inquiry request includes:
Text is converted by input voice, the text is segmented to obtain multiple phrases, the multiple phrase forms the inquiry
Sentence.
Preferably, the step of judging whether there is label matched with the query statement includes: to distinguish multiple phrases
Match with the mark label of tables of data, calculate the similarity of the phrase Yu the label, if obtained similarity numerical value is super
Preset similarity threshold is crossed, then the phrase and the tag match, if obtained similarity numerical value is no more than described similar
Threshold value is spent, then the phrase and the label mismatch;At least one phrase matching in label and multiple phrases if it exists, then
In the presence of with the matched label of the query statement, conversely, then be not present and the matched label of the query statement.
Preferably, before the step of generating query statement, further includes: obtain user information, according to the user information and
The inquiry request generates query statement.
Preferably, after the step of obtaining query result, further includes: handle the query result, and by pre-
If file format output.
Preferably, the tables of data is stored in one or more databases.
To achieve the goals above, another aspect of the present invention is to provide a kind of electronic device, which includes:
Processor;
Memory, includes report query program in the memory, and the report query program is executed by the processor
The step of Shi Shixian report form inquiring method as described above.
To achieve the goals above, another aspect of the invention is to provide a kind of computer readable storage medium, described
Include report query program in computer readable storage medium, when the report query program is executed by processor, realizes as above
The step of described report form inquiring method.
Compared with the existing technology, the present invention has the following advantages and beneficial effects:
The present invention establishes the association between each tables of data, realization is not known about in user by marking label to tables of data
In the case where data store organisation, accurately Query Location is carried out to data target, improves search efficiency.Also, the present invention can
To realize the inquiry of the data between full database or multiple databases, even inter-trade data query.
Detailed description of the invention
Fig. 1 is the flow diagram of report form inquiring method of the present invention;
Fig. 2 is the module diagram of report query program in the present invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
Embodiment of the present invention described below with reference to the accompanying drawings.Those skilled in the art may recognize that
It arrives, it without departing from the spirit and scope of the present invention, can be with a variety of different modes or combinations thereof to described
Embodiment is modified.Therefore, attached drawing and description are regarded as illustrative in nature, and are only used to explain the present invention, rather than are used
In limitation scope of protection of the claims.In addition, in the present specification, attached drawing is drawn not in scale, and identical attached drawing mark
Note indicates identical part.
Fig. 1 is the flow diagram of report form inquiring method of the present invention, as shown in Figure 1, report query of the present invention
Method the following steps are included:
Step S1, label is marked to tables of data, the label includes dimensional labels and index label;
Step S2, report query request is obtained;
Step S3, the inquiry request is pre-processed, generates query statement;
Step S4, judging whether there is then terminates querying flow if it does not exist with the matched label of the query statement;
If it exists, then it carries out in next step;
Step S5, it is inquired, is obtained according to inquiry request pair tables of data corresponding with the matched label of the query statement
Take query result.
The present invention is by marking label for tables of data so that label is corresponding with tables of data, by matching inquiry request and
Label obtains label corresponding with inquiry request, according to the corresponding relationship of label and tables of data, asks to obtain with the inquiry
Corresponding tables of data is sought, query result is accurately positioned in the tables of data.The present invention establishes each data by marking label
Association between table allows user in the case where not knowing about data store organisation by the report query to required finger
Mark, and it is possible to realize the inquiry of the data between full database or multiple databases, even inter-trade data query.
In step sl, label is marked to tables of data, wherein tables of data is the one or more stored in existing database
Tables of data, by tables of data storing data, multiple tables of data be can store in one or more databases.The dimensional labels
Indicate some factors, including time dimension, department's framework dimension, region dimension etc. of influence index numerical value, the index label
Indicate target indicator that user requires to look up, including on-job number, rainfall, recruitment success rate, sales volume, order numbers etc..Example
Such as, for the occurrences in human life data of a certain enterprises, A tables of data is produced and generated, label is marked to A tables of data, wherein the dimension of mark
Scale label include time dimension and department's framework dimension, and index label includes on-job number, then when inquiring report, pass through input 10
Month, Chan Xian department on-job number, can by Query Location in A tables of data, and obtain in A tables of data with above-mentioned inquiry request
Corresponding query result is to get to the on-job number of Chan Xian department in October.For the weather data in the whole country, mark
Dimensional labels include time dimension and region dimension, index label includes temperature, rainfall etc., when inquiring report, by defeated
Entering Beijing temperature on October 10, available label corresponding with the inquiry request, the time is October 10, and region is Beijing,
Index is temperature, and the inquiry request is corresponded to B data table according to label, corresponding query result in B data table is obtained, obtains
October 10 Pekinese's temperature.
Preferably, the step of marking label to tables of data includes: to count the data of multiple tables of data, and according to tables of data
Data determine the theme of the tables of data;Classified according to the theme of the tables of data to tables of data;According to classification results pair
The tables of data marks label.The tables of data of different classes of theme marks different labels.The theme of tables of data may include using
Householder's topic, commodity theme, warehouse theme, worker's theme etc. carry out classification annotation label to tables of data, in order to inquire same master
The related data of topic, for example, the tables of data of commodity theme includes merchandise classification, commodity consumption crowd, procurement of commodities situation, commodity
The data such as sales situation, commodity storage condition, warehouse theme include the administrative situation etc. in the storage condition of commodity, warehouse in warehouse
Data.
In the present invention, at interval of setting time, label for labelling is carried out to the tables of data increased newly in database, to timely update
Database.
Report query request is that user envisions the information obtained by report query, and user query request is inputted by user
Text or voice are realized.When user inputs text request inquiry report, carrying out pretreated step to the inquiry request includes:
Input text is segmented to obtain multiple phrases, the multiple phrase forms the query statement.User inputs voice request
When inquiring report, carrying out pretreated step to the inquiry request includes: to convert text for input voice, to the text
It is segmented to obtain multiple phrases, the multiple phrase forms the query statement.
In one embodiment of the present of invention, the report query request includes one or more dimensions, alternatively, one or more
A index, the label by the dimension or index respectively with the tables of data match, so that positioning is to corresponding one or more
A tables of data gets accurate query result.
Further, the step of judging whether there is label matched with the query statement include:
Multiple phrases are matched with the mark label of tables of data respectively, it is similar to the label to calculate the phrase
Degree, if obtained similarity numerical value is more than preset similarity threshold, the phrase and the tag match, if obtained phase
It is no more than preset similarity threshold like degree value, then the phrase and the label mismatch;
At least one phrase matching in label and multiple phrases if it exists, then exist and the matched mark of the query statement
Label, otherwise (any one of label and multiple phrases phrase matching is not present), then there is no match with the query statement
Label.
It should be noted that the similarity for calculating phrase and label can be cosine similarity calculation method in the present invention
It is calculated or the calculation method of Tanimoto coefficient obtains.
Before the step of generating query statement, the report form inquiring method further include: user information is obtained, according to the use
Family information and the inquiry request generate query statement.Wherein, the user information includes user name, user's geographical location information
With subscriber identity information etc..For example, if only inputting weather on October 10, cannot be used when user query index is weather
The accurate result of inquiry is wanted at family, and the current location information including user is north in the user information obtained by GPS positioning
Capital area generates query statement according to the user information of acquisition and the input information of user, determines that user query are October 10
Number Beijing weather, then can be precisely located to the tables of data of Beijing weather.
Preferably, after the step of obtaining query result, the report form inquiring method further include: at query result
Reason, is exported by preset file format.Wherein, preset file format can be the forms such as table or chart, by default
File format can show the incidence relation between multiple queries index.It include the chart generated in preset file format
The width etc. of each unit lattice in font form, line weight or table, can be the format of system default generation, or preset
A variety of file formats, when output, are manually selected.Since the present invention is inquired by dimension index, as long as the finger of identical dimensional
It marks, or can be grouped with index different dimensions, polymerize calculating, so as to realize in inter-library even inter-trade database
Data query, the also association between available disparate databases data.For example, inquiry index is recruitment success rate and rainfall feelings
Condition, query result show the month more than rainfall that recruitment success rate is low instead, can export the relationship of recruitment success rate and rainfall
Table, consequently facilitating providing the condition etc. of traffic convenience when adjustment recruitment time or month recruitment more than the rainfall.
In one embodiment of the present of invention, the query result exported according to preset file format is stored in result data
Library is concentrated, and each tables of data concentrated for the result database marks label, when obtaining inquiry request again, in advance in institute
It states result database concentration to be inquired, if result database, which is concentrated, is not present matched label, then in other databases
It is inquired, if result database is concentrated, there are matched labels, query result are positioned to corresponding tables of data, thus directly
Corresponding data form or chart (for example, sales volume trend etc. of some commodity of some) is obtained in season, improves search efficiency.
In one embodiment of the present of invention, the report form inquiring method further include: to one or more numbers in database
According to table, Permission Levels are set, after obtaining report query request, matching user right and tables of data permission, with user right phase
It is judged whether there is in the tables of data matched and the matched label of query statement, acquisition query result, consequently facilitating according to tables of data
Authority acquiring and the matched query result of user right, for example, being that different workers or management level setting are different in enterprises
User right, to inquire the tables of data of different rights grade, so that management level will be seen that enterprises situation, and worker can
It can be only capable of inquiry tables of data corresponding with its position.For employee's wages, by setting Permission Levels, only related personnel or pipe
Reason layer can just inquire corresponding tables of data, and other employees then have no right to inquire the tables of data about employee's wages.
Report form inquiring method of the present invention is applied to electronic device, and the electronic device can be television set, intelligent hand
The terminal devices such as machine, tablet computer, computer.
The electronic device includes: processor;Memory, for storing report query program, processor executes the report
Table polling routine, the step of realizing report form inquiring method below:
Label is marked to tables of data, the label includes dimensional labels and index label;
Obtain report query request;
The inquiry request is pre-processed, query statement is generated;
Judging whether there is then terminates querying flow if it does not exist with the matched label of the query statement;If it exists,
It then carries out in next step;
It is inquired according to inquiry request pair tables of data corresponding with the matched label of the query statement, obtains inquiry knot
Fruit.
The electronic device further includes network interface and communication bus etc..Wherein, network interface may include having for standard
Line interface, wireless interface, communication bus is for realizing the connection communication between various components.
Memory includes the readable storage medium storing program for executing of at least one type, can be that flash memory, hard disk, CD etc. are non-volatile to be deposited
Storage media is also possible to plug-in type hard disk etc., and is not limited to this, can be in a manner of non-transitory store instruction or software with
And any associated data file and to processor provide instruction or software program so that the processor be able to carry out instruction or
Any device of software program.In the present invention, the software program of memory storage includes report query program, and can be to processing
Device provides the report query program, so that processor can execute the report query program, realizes the step of report form inquiring method
Suddenly.
Processor can be central processing unit, microprocessor or other data processing chips etc., can be in run memory
Storage program, for example, report query program in the present invention.
The electronic device can also include display, and display is referred to as display screen or display unit.Some
Display can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display and Organic Light Emitting Diode in embodiment
(Organic Light-Emitting Diode, OLED) touches device etc..Display is used to show and handle in an electronic
Information and for showing the information such as visual working interface, including report query result, output file.
The electronic device can also include user interface, and user interface may include input unit (such as keyboard), language
Sound output device (such as sound equipment, earphone) etc..
The electronic device includes labeling module, marks label to tables of data, wherein tables of data is to deposit in existing database
One or more tables of data of storage, by tables of data storing data, multiple tables of data be can store in one or more databases
In.The dimensional labels indicate some factors of influence index numerical value, including time dimension, department's framework dimension, region dimension
Deng, the target indicator that the index tag representation user requires to look up, including on-job number, rainfall, recruitment success rate, sale
Volume, order numbers etc..For example, producing and generating A tables of data for the occurrences in human life data of a certain enterprises, A tables of data is marked and is marked
Label, wherein the dimensional labels of mark include time dimension and department's framework dimension, and index label includes on-job number, then inquire
, can be by Query Location in A tables of data by inputting the on-job number in October, Chan Xian department when report, and obtain A data
Query result corresponding with above-mentioned inquiry request is in table to get to the on-job number of Chan Xian department in October.For national model
Interior weather data is enclosed, the dimensional labels of mark include time dimension and region dimension, and index label includes temperature, rainfall
Deng when inquiring report, by inputting Beijing temperature on October 10, available label corresponding with the inquiry request, the time is
October 10, region are Beijing, and index is temperature, and the inquiry request is corresponded to B data table according to label, obtains B data table
In corresponding query result, obtain Pekinese's temperature on October 10.
Preferably, the labeling module includes: statistic unit, counts the data of multiple tables of data, and according to tables of data
Data determine the theme of the tables of data;Taxon classifies to tables of data according to the theme of the tables of data;Label list
Member marks label to the tables of data according to classification results.The tables of data of different classes of theme marks different labels.Tables of data
Theme may include user's theme, commodity theme, warehouse theme, worker's theme etc., classification annotation label is carried out to tables of data,
In order to inquire the related data of same subject, for example, the tables of data of commodity theme include merchandise classification, commodity consumption crowd,
The data such as procurement of commodities situation, merchandise sales situation, commodity storage condition, warehouse theme include the storage feelings of commodity in warehouse
The data such as condition, the administrative situation in warehouse.
In the present invention, the electronic device further includes update module, at interval of setting time, to the number increased newly in database
Label for labelling is carried out according to table, with the database that timely updates.
Report query request is that user envisions the information obtained by report query, and user query request is inputted by user
Text or voice are realized.The electronic device includes participle unit, when user inputs text request inquiry report, to input text
It is segmented to obtain multiple phrases, the multiple phrase forms the query statement.The electronic device further includes voice conversion
Unit, user input voice request inquiry report when, will input voice be converted into text, by participle unit to the text into
Row participle obtains multiple phrases, and the multiple phrase forms the query statement.
In one embodiment of the present of invention, the report query request includes one or more dimensions, and one or more refers to
Mark, the label by the dimension or index respectively with the tables of data match, to position to corresponding one or more
Tables of data gets accurate query result.
Further, the electronic device includes judgment module, is judged whether there is and the matched mark of the query statement
Label, the judgment module includes: similarity calculated, and multiple phrases are matched with the mark label of tables of data respectively, is counted
The similarity of the phrase Yu the label is calculated, if obtained similarity numerical value is more than preset similarity threshold, institute's predicate
Group and the tag match, if obtained similarity numerical value is no more than the similarity threshold, the phrase and the label
It mismatches;Tag match unit, at least one phrase matching in label and multiple phrases, then exist and the inquiry if it exists
The label of statement matching, otherwise (be not present any one of label and multiple phrases phrase matching), then be not present with it is described
The matched label of query statement.
It should be noted that the similarity for calculating phrase and label can be cosine similarity calculation method in the present invention
It is calculated or the calculation method of Tanimoto coefficient obtains.
The electronic device also performs the steps of acquisition user information before the step of generating query statement, according to
The user information and the inquiry request generate query statement.Wherein, the user information includes user name, user's geography position
Confidence breath and subscriber identity information etc..For example, when user query index is weather, it, cannot if only inputting weather on October 10
The accurate result that user wants inquiry is obtained, and in the user information obtained by GPS positioning includes the present bit confidence of user
Breath is Beijing area, generates query statement according to the user information of acquisition and the input information of user, determines that user query are
Beijing weather on October 10 can then be precisely located to the tables of data of Beijing weather.
Preferably, the electronic device further includes result treatment module, after obtaining query result, to query result into
Row processing, is exported by preset file format.Wherein, preset file format can be the forms such as table or chart, pass through
Preset file format can show the incidence relation between multiple queries index.Since the present invention is inquired by dimension index,
As long as the index of identical dimensional, or can be grouped with index different dimensions, polymerize calculating, so as to realize it is inter-library even
It is the data query in inter-trade database, the also association between available disparate databases data.For example, inquiry index is
Recruitment success rate and rain fall, query result obtain the month more than rainfall, recruitment success rate it is low instead, can export recruitment at
The related table of power and rainfall, consequently facilitating providing traffic convenience when adjustment recruitment time or month recruitment more than the rainfall
Condition etc..
In one embodiment of the present of invention, the electronic device further includes memory module, will be according to preset file format
The query result of output is stored in result database concentration, and each tables of data concentrated for the result database marks mark
Label when obtaining inquiry request again, are inquired in result database concentration, in advance if result database concentration is not present
Matched label is then inquired in other databases again, if result database is concentrated there are matched label, inquiry is tied
Fruit positions to corresponding tables of data, to directly acquire corresponding data form or chart (for example, some some commodity in season
Sales volume trend etc.), improve search efficiency.
In one embodiment of the present of invention, the electronic device further includes priority assignation module, to one in database
Or Permission Levels are arranged in multiple tables of data, after obtaining report query request, matching user right and tables of data permission, with user
It is judged whether there is in the tables of data that permission matches and the matched label of query statement, acquisition query result, consequently facilitating root
According to tables of data authority acquiring and the matched query result of user right, for example, being different workers or management level in enterprises
Different user rights is set, to inquire the tables of data of different rights grade, so that management level will be seen that enterprises situation,
And worker may be only capable of inquiry tables of data corresponding with its position.It is only related by setting Permission Levels for employee's wages
Personnel or management level can just inquire corresponding tables of data, and other employees then have no right to inquire the tables of data about employee's wages.
In other embodiments, report query program can also be divided into one or more module, and one or more
A module is stored in memory, and is executed by processor, to complete the present invention.The so-called module of the present invention is to have referred to
At the series of computation machine program instruction section of specific function.Fig. 2 is the module diagram of report query program in the present invention, is such as schemed
Shown in 2, the report query program can be divided into: labeling module 1 obtains module 2, preprocessing module 3, judgment module 4
With enquiry module 5.The functions or operations step that above-mentioned module is realized is similar as above, and and will not be described here in detail, illustratively,
Such as wherein:
Labeling module 1 marks label to tables of data, and the label includes dimensional labels and index label;
Module 2 is obtained, report query request is obtained;
Preprocessing module 3 pre-processes the inquiry request, generates query statement;
Judgment module 4, judging whether there is then terminates inquiry stream if it does not exist with the matched label of the query statement
Journey;If it exists, then it carries out in next step;
Enquiry module 5 is inquired according to inquiry request pair tables of data corresponding with the matched label of the query statement,
Obtain query result.
In one embodiment of the present of invention, computer readable storage medium, which can be, any includes or storage program or instruction
Tangible medium, program therein can be performed, and pass through the corresponding function of the relevant hardware realization of the program instruction of storage.Example
Such as, computer readable storage medium can be computer disk, hard disk, random access memory, read-only memory etc..The present invention
It is not limited to this, can be in a manner of non-transitory store instruction or software and any associated data files or data structure simultaneously
And processor is provided to so that processor executes any device of program therein or instruction.The computer-readable storage medium
Include that report query program realizes following report form inquiring method when the report query program is executed by processor in matter:
Label is marked to tables of data, the label includes dimensional labels and index label;
Obtain report query request;
The inquiry request is pre-processed, query statement is generated;
Judging whether there is then terminates querying flow if it does not exist with the matched label of the query statement;If it exists,
It then carries out in next step;
It is inquired according to inquiry request pair tables of data corresponding with the matched label of the query statement, obtains inquiry knot
Fruit.
The specific embodiment of the computer readable storage medium of the present invention and above-mentioned report form inquiring method, electronic device
Specific embodiment is roughly the same, and details are not described herein.
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, device, article or the method that include a series of elements not only include those elements, and
And further include other elements that are not explicitly listed, or further include for this process, device, article or method institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to do
There is also other identical elements in the process, device of element, article or method.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.Pass through above embodiment party
The description of formula, it is required general that those skilled in the art can be understood that above-described embodiment method can add by software
The mode of hardware platform is realized, naturally it is also possible to which by hardware, but in many cases, the former is more preferably embodiment.It is based on
Such understanding, substantially the part that contributes to existing technology can be with software product in other words for technical solution of the present invention
Form embody, which is stored in a storage medium (such as ROM/RAM, magnetic disk, light as described above
Disk) in, including some instructions use is so that a terminal device (can be mobile phone, computer, server or the network equipment
Deng) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of report form inquiring method is applied to electronic device characterized by comprising
Label is marked to tables of data, the label includes dimensional labels and index label;
Obtain report query request;
The inquiry request is pre-processed, query statement is generated;
Judging whether there is then terminates querying flow if it does not exist with the matched label of the query statement;If it exists, then into
Row is in next step;
It is inquired according to inquiry request pair tables of data corresponding with the matched label of the query statement, obtains query result.
2. report form inquiring method according to claim 1, which is characterized in that include: to the step of tables of data mark label
The data of multiple tables of data are counted, and determine the theme of the tables of data according to the data of tables of data;
Classified according to the theme of the tables of data to tables of data;
Label is marked to the tables of data according to classification results.
3. report form inquiring method according to claim 1, which is characterized in that when user inputs text request inquiry report,
Carrying out pretreated step to the inquiry request includes: to be segmented to obtain multiple phrases, the multiple word to input text
Group forms the query statement.
4. report form inquiring method according to claim 1, which is characterized in that when user inputs voice request inquiry report,
Carrying out pretreated step to the inquiry request includes: to convert text for input voice, segment to the text
To multiple phrases, the multiple phrase forms the query statement.
5. report form inquiring method according to claim 3 or 4, which is characterized in that judge whether there is and the inquiry language
Sentence matched label the step of include:
Multiple phrases are matched with the mark label of tables of data respectively, calculate the similarity of the phrase Yu the label, if
Obtained similarity numerical value is more than preset similarity threshold, then the phrase and the tag match, if obtained similarity
Numerical value is no more than the similarity threshold, then the phrase and the label mismatch;
At least one phrase matching in label and multiple phrases if it exists, then exist with the matched label of the query statement,
Conversely, being then not present and the matched label of the query statement.
6. report form inquiring method according to claim 1, which is characterized in that before the step of generating query statement, also wrap
It includes: obtaining user information, query statement is generated according to the user information and the inquiry request.
7. report form inquiring method according to claim 1, which is characterized in that after the step of obtaining query result, also wrap
It includes: the query result is handled, and exported by preset file format.
8. report form inquiring method according to claim 1, which is characterized in that the tables of data is stored in one or more numbers
According in library.
9. a kind of electronic device, which is characterized in that the electronic device includes:
Processor;
Memory includes report query program in the memory, reality when the report query program is executed by the processor
Now such as the step of report form inquiring method described in any item of the claim 1 to 8.
10. a kind of computer readable storage medium, which is characterized in that include report query in the computer readable storage medium
Program when the report query program is executed by processor, realizes such as report query described in any item of the claim 1 to 8
The step of method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910100167.8A CN109902100A (en) | 2019-01-31 | 2019-01-31 | Report form inquiring method, device and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910100167.8A CN109902100A (en) | 2019-01-31 | 2019-01-31 | Report form inquiring method, device and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109902100A true CN109902100A (en) | 2019-06-18 |
Family
ID=66944659
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910100167.8A Pending CN109902100A (en) | 2019-01-31 | 2019-01-31 | Report form inquiring method, device and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109902100A (en) |
Cited By (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110377560A (en) * | 2019-07-18 | 2019-10-25 | 中科鼎富(北京)科技发展有限公司 | A kind of structural method and device of biographic information |
CN110489414A (en) * | 2019-07-23 | 2019-11-22 | 中国平安人寿保险股份有限公司 | Report method for pushing and equipment |
CN110555200A (en) * | 2019-09-05 | 2019-12-10 | 北京思维造物信息科技股份有限公司 | report publishing method, device and equipment |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN111311329A (en) * | 2020-02-20 | 2020-06-19 | 口碑(上海)信息技术有限公司 | Label data acquisition method, device, equipment and readable storage medium |
CN111367945A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Report query method, device, equipment and computer readable storage medium |
CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN111782653A (en) * | 2020-06-30 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
CN112100183A (en) * | 2020-09-28 | 2020-12-18 | 中国银行股份有限公司 | Report query system, device and method based on label management |
CN112508532A (en) * | 2020-12-16 | 2021-03-16 | 深圳市中博科创信息技术有限公司 | Traffic statistical method for second batch service management system |
CN112527917A (en) * | 2020-12-04 | 2021-03-19 | 广州橙行智动汽车科技有限公司 | Data processing method and device |
CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
CN112860696A (en) * | 2021-02-07 | 2021-05-28 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
CN113590856A (en) * | 2021-08-09 | 2021-11-02 | 平安银行股份有限公司 | Label query method and device, electronic equipment and readable storage medium |
CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
CN116108024A (en) * | 2023-04-14 | 2023-05-12 | 深圳市安信达存储技术有限公司 | Data storage method and data storage system |
CN117708884A (en) * | 2024-02-04 | 2024-03-15 | 珠海金智维信息科技有限公司 | Data authority database middleware based on field tagging |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2008130018A1 (en) * | 2007-04-13 | 2008-10-30 | Massachusetts Institute Of Technology | Speech data retrieval apparatus, speech data retrieval method, speech data retrieval program and computer usable medium having computer readable speech data retrieval program embodied therein |
CN106933897A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | Data query method and apparatus |
JP2017207853A (en) * | 2016-05-17 | 2017-11-24 | 日本電信電話株式会社 | Table cell retrieval device, method and program |
CN108153776A (en) * | 2016-12-05 | 2018-06-12 | 北京国双科技有限公司 | Data query method and device |
CN108536761A (en) * | 2018-03-21 | 2018-09-14 | 平安科技(深圳)有限公司 | Report data querying method and server |
CN108829800A (en) * | 2018-05-29 | 2018-11-16 | 努比亚技术有限公司 | A kind of search data processing method, equipment and computer readable storage medium |
CN108932257A (en) * | 2017-05-25 | 2018-12-04 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
-
2019
- 2019-01-31 CN CN201910100167.8A patent/CN109902100A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2008130018A1 (en) * | 2007-04-13 | 2008-10-30 | Massachusetts Institute Of Technology | Speech data retrieval apparatus, speech data retrieval method, speech data retrieval program and computer usable medium having computer readable speech data retrieval program embodied therein |
CN106933897A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | Data query method and apparatus |
JP2017207853A (en) * | 2016-05-17 | 2017-11-24 | 日本電信電話株式会社 | Table cell retrieval device, method and program |
CN108153776A (en) * | 2016-12-05 | 2018-06-12 | 北京国双科技有限公司 | Data query method and device |
CN108932257A (en) * | 2017-05-25 | 2018-12-04 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
CN108536761A (en) * | 2018-03-21 | 2018-09-14 | 平安科技(深圳)有限公司 | Report data querying method and server |
CN108829800A (en) * | 2018-05-29 | 2018-11-16 | 努比亚技术有限公司 | A kind of search data processing method, equipment and computer readable storage medium |
Cited By (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110377560B (en) * | 2019-07-18 | 2021-11-26 | 鼎富智能科技有限公司 | Method and device for structuring resume information |
CN110377560A (en) * | 2019-07-18 | 2019-10-25 | 中科鼎富(北京)科技发展有限公司 | A kind of structural method and device of biographic information |
CN110489414A (en) * | 2019-07-23 | 2019-11-22 | 中国平安人寿保险股份有限公司 | Report method for pushing and equipment |
CN110555200A (en) * | 2019-09-05 | 2019-12-10 | 北京思维造物信息科技股份有限公司 | report publishing method, device and equipment |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN111311329A (en) * | 2020-02-20 | 2020-06-19 | 口碑(上海)信息技术有限公司 | Label data acquisition method, device, equipment and readable storage medium |
CN111311329B (en) * | 2020-02-20 | 2023-07-25 | 口碑(上海)信息技术有限公司 | Tag data acquisition method, device, equipment and readable storage medium |
CN111367945A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Report query method, device, equipment and computer readable storage medium |
CN111708992B (en) * | 2020-05-06 | 2023-07-14 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN111782653A (en) * | 2020-06-30 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
CN112100183B (en) * | 2020-09-28 | 2023-09-19 | 中国银行股份有限公司 | Report query system, device and method based on label management |
CN112100183A (en) * | 2020-09-28 | 2020-12-18 | 中国银行股份有限公司 | Report query system, device and method based on label management |
CN112527917A (en) * | 2020-12-04 | 2021-03-19 | 广州橙行智动汽车科技有限公司 | Data processing method and device |
CN112508532A (en) * | 2020-12-16 | 2021-03-16 | 深圳市中博科创信息技术有限公司 | Traffic statistical method for second batch service management system |
CN112559914A (en) * | 2020-12-21 | 2021-03-26 | 北京搜房科技发展有限公司 | Index data display method and device |
CN112860696A (en) * | 2021-02-07 | 2021-05-28 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
CN112860696B (en) * | 2021-02-07 | 2024-04-12 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
CN113590856B (en) * | 2021-08-09 | 2023-05-23 | 平安银行股份有限公司 | Label query method and device, electronic equipment and readable storage medium |
CN113590856A (en) * | 2021-08-09 | 2021-11-02 | 平安银行股份有限公司 | Label query method and device, electronic equipment and readable storage medium |
CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
CN113722324B (en) * | 2021-08-30 | 2023-08-18 | 深圳平安智慧医健科技有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
CN116108024A (en) * | 2023-04-14 | 2023-05-12 | 深圳市安信达存储技术有限公司 | Data storage method and data storage system |
CN117708884A (en) * | 2024-02-04 | 2024-03-15 | 珠海金智维信息科技有限公司 | Data authority database middleware based on field tagging |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109902100A (en) | Report form inquiring method, device and storage medium | |
CN104123346B (en) | A kind of structured data search method | |
US8086592B2 (en) | Apparatus and method for associating unstructured text with structured data | |
US8335981B2 (en) | Metadata creation | |
CN109388612A (en) | A kind of method, equipment, system and the medium of data summarization document structure tree | |
US20120072464A1 (en) | Systems and methods for master data management using record and field based rules | |
EP2249299A1 (en) | Contextualizing business intelligence reports based on context driven information | |
CN103548019A (en) | Method and system for providing statistical from a data warehouse | |
US20070239742A1 (en) | Determining data elements in heterogeneous schema definitions for possible mapping | |
US8654125B2 (en) | System and method of chart data layout | |
CN106033466A (en) | Database query method and device | |
CN109388637A (en) | Data warehouse information processing method, device, system, medium | |
CN109558441A (en) | Financial index automatic monitoring method, device, computer equipment and storage medium | |
CN113342976B (en) | Method, device, storage medium and equipment for automatically acquiring and processing data | |
US10055452B2 (en) | Most likely classification code | |
CN112000773A (en) | Data association relation mining method based on search engine technology and application | |
CN107870915A (en) | Instruction to search result | |
CN110675238A (en) | Client label configuration method, system, readable storage medium and electronic equipment | |
CN112000790A (en) | Legal text accurate retrieval method, terminal system and readable storage medium | |
CN115712684B (en) | Storage method and system for dynamic information of articles in Internet of things | |
CN115239214B (en) | Enterprise evaluation processing method and device and electronic equipment | |
US8504552B2 (en) | Query based paging through a collection of values | |
CN113434678B (en) | Item type-based item reminding method, device, equipment and storage medium | |
US20160103863A1 (en) | Method of managing relational data in a single matrix representation | |
US20220156228A1 (en) | Data Tagging And Synchronisation System |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |