CN109408564A - A kind of comprehensive inquiry and analysis system and method - Google Patents

A kind of comprehensive inquiry and analysis system and method Download PDF

Info

Publication number
CN109408564A
CN109408564A CN201810973648.5A CN201810973648A CN109408564A CN 109408564 A CN109408564 A CN 109408564A CN 201810973648 A CN201810973648 A CN 201810973648A CN 109408564 A CN109408564 A CN 109408564A
Authority
CN
China
Prior art keywords
field
inquiry
query
display
interface
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
CN201810973648.5A
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.)
Individual
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to CN201810973648.5A priority Critical patent/CN109408564A/en
Publication of CN109408564A publication Critical patent/CN109408564A/en
Pending legal-status Critical Current

Links

Abstract

The invention discloses a kind of comprehensive inquiry and analysis system and method, system mainly includes computer storage, PC display screen, database, comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field administration interface and query result display interface.Method and step is main are as follows: 1) comprehensive inquiry and analysis system is arranged.2) it starts to query: 2.1) extracting second stage query argument.2.2) judge whether second stage query argument has expansion condition, if so, step 2.3 is transferred to, if it is not, going to step 2.5.2.3) the execution method I for determining inquiry, obtains second stage query result.2.5) stage first time query result is updated.3.6) extension output intent option is judged whether there is.If so, step 3.7 is gone to, if it is not, going to step 4.2.7) it determines execution method II, obtains phase III query result.2) query result is exported.The present invention realizes the transformation independently inquired by depended software manufacturer to user, and search efficiency greatly improved.

Description

A kind of comprehensive inquiry and analysis system and method
Technical field
The present invention relates to computer field, specifically a kind of comprehensive inquiry and analysis system and method.
Background technique
By the automation and informatization of many years, every profession and trade possesses a large amount of automated system and information system, produces Mass data is given birth to.The prior art is very low to the inquiry of these data and analysis efficiency, and data user rate is very low, mainly deposits In following problem:
1. query function is simple, some master datas can only be inquired, customized development can only be passed through to the inquiry of complex data Program realizes that the period is too long, and user cannot independently inquire, and relies on system Construction manufacturer serious, effect limited so as to cause function Rate is low.
2. lacking analysis ability, the period is too long, and user cannot to be realized by customized development program to the analysis of data It is autonomous to carry out analysis, serious, inefficiency limited so as to cause function is relied on system Construction manufacturer.
3. lacking aggregation of data application power: data are dispersed in each automation and information system, lack close each other Connection, data are inconsistent, cause comprehensive analytical capacity low.
4. data query and analysis flexibility are poor, for different inquiries and analysis demand, need custom-made to develop, ring Answer the period long, system maintenance is with high costs.
5. poor expandability: increase inquiry or analytic function carry out customized development, original function may be influenced, cause be System is difficult to debug and unstable.
Summary of the invention
Present invention aim to address problems of the prior art.
To realize the present invention purpose and the technical solution adopted is that such, a kind of comprehensive inquiry and analysis system, mainly Including computer storage, PC display screen, database, comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion Field administration interface and query result display interface.
Computer storage storing data library, comprehensive inquiry visualization interface, statistics plug-in management interface, theme expand Open up the data of field administration interface and query result display interface.
The PC display screen shows comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field management Interface and query result display interface.
The comprehensive inquiry visualization interface mainly include inquiry theme selectionbar, data source capability column, inquiry button I, Save button I, button I, basic query condition selecting module, expanding query condition selecting module and output intent option selection mould are opened Block.
The inquiry theme selectionbar selection inquiry theme.
The inquiry button I opens comprehensive inquiry.
The save button I saves the inquiry setting of comprehensive inquiry.
The button I that opens opens the comprehensive inquiry for saving as name inquiry.
The data source capability column selects data source to be checked.
The data source is the database file saved in the database.Database has several database files.Often A database file corresponds to unique data source name.
The basic query condition selecting module mainly includes field name selectionbar I, operator selectionbar I and looks into substantially Inquiry condition display field.
The field name selectionbar I includes two column selection columns.
The operator selectionbar I includes three column selection columns.
The basic query condition display field shows the basic query condition selected.
The expanding query condition selecting module mainly includes field name selectionbar II, operator selectionbar II and extension Querying condition display field.
The field name selectionbar II includes two column selection columns.
The operator selectionbar II includes three column selection columns.
The expanding query condition display field shows the expanding query condition selected.
The output intent option selecting module mainly includes that list of fields selectionbar, processing result selectionbar, grouping condition are set Set module and sort criteria setup module.
The list of fields selectionbar selects output field.
The processing result selectionbar selection is further processed mode to output field.
The grouping condition of the grouping condition setting module setting output result.
The sort criteria of the sort criteria setup module setting output result.
The statistics plug-in management interface mainly includes plugin name display field, new buttons, delete button, save button With number of pages display module.
The plugin name display field mainly includes plugin name column, executive module column, executes method column, returns to Value Types Column and plug-in unit description bar.
The plugin name column shows plugin name.
The executive module column shows the executive module of plug-in unit.
Execution method column shows the execution method of plug-in unit.
The return value type column shows the return Value Types of plug-in unit.
The plug-in unit description bar shows the explanation of plug-in unit.
The topic expansion field administration interface shows the field name of setting in the comprehensive inquiry visualization interface Field name column in.
The topic expansion field administration interface mainly includes that theme display module, new buttons, delete button, preservation are pressed Button and field display field.
The field name is the build-in attribute of business object, includes mainly coding, title, manufacturer and puts into operation day Phase.Only one value of each attribute of each business object, is chosen by drop-down list.
The expanding query field be the operation attribute of business object, i.e. business object in the process of running over time And continually changing operation characteristic parameter, it mainly include power, voltage, frequency, temperature, flow, pressure, water level, concentration, volume And speed.
The theme display module shows all themes.The theme saves basic query condition.
The new buttons new theme.
The delete button deletes theme.
The save button saves theme.
The field display field mainly includes extended field source column and extended field column.
Extended field source column shows the corresponding database file name of extended field.
The extended field column shows extended field.
The number of pages display module mainly include current page number display field, page sum display field, page up select button, Lower one page select button and refresh button.
The current page number display field shows the number of pages of current page.
The page sum display field shows the total page number of query result.
The page up select button links page up query result.
Lower one page select button links lower one page query result.
The refresh button refreshes current page.
The query result display interface shows query result.
The query result display interface mainly includes inquiry output field title display field, original value display field, occurs Time showing column and number of pages display module.
The inquiry output field title display field shows the title of query argument.The present embodiment inquires output field title The entitled telemetering of the query argument that display field is shown.
The original value display field shows the corresponding initial data of query argument.
The time of origin display field shows the record time of the initial data.
A method of using comprehensive inquiry and analysis system, mainly comprise the steps that
1) database is established.
2) comprehensive inquiry and analysis system are configured, are mainly comprised the steps that
2.1) Subject Manager is needed according to production, all kinds of production management data or all kinds of production management tables of data are spelled It is connected into view, the one or more single tables in logic of construction.
2.2) class and method are registered as plug-in unit by plug-in management, describe path, class name and the method for class and method Name, and utilize the calling of principle of reflection progress class and method.
2.3) the dimension of equipment operating data is maintained in a table by topic expansion field management, by dimension title It reads and is added in the drop-down list of comprehensive inquiry expansion condition and output intent option, thus using operation data as querying condition Or output intent option.
2.4) theme counts plug-in parameter management, that is, is directed to a certain theme, and statistics plug-in unit is added to the plug-in unit in upper right side In name list, then it represents that quote the statistics plug-in unit in the comprehensive inquiry expansion condition and output intent option of the theme.Lower right The parameter transmitted to the plug-in unit of plug-in parameter interface definition.
3) it starts to query, mainly comprises the steps that
3.1) first stage inquiry is carried out, primary screening is carried out to theme view, and extract second-order from the selection result The parameter of section inquiry.
3.2) judge whether second stage query argument has expansion condition, if so, step 3.3 is transferred to, if it is not, then jumping To step 3.6.
3.3) it is directed to each expanding query condition, determines the execution method I of inquiry.
3.4) method for query execution I is called, second stage query argument is passed into execution method I, carries out second stage Inquiry, obtains second stage query result.First stage query result and second stage query result are spliced.
3.5) it is based on splicing result, is transferred to step 3.1, updates stage first time query result.
3.6) extension output intent option is judged whether there is.If so, step 3.7 is gone to, if it is not, then jumping directly to step 4.
3.7) it is directed to each extension output intent option, determines execution method II.
3.8) execution method II is called, updated first stage query argument is passed into execution method II, carries out the The inquiry of three stages calculates, and obtains phase III query result.First and third stage query result is spliced.
4) final query result is exported, and is shown in final query result display interface.
The solution have the advantages that unquestionable.The present invention is realized independently to be inquired by depended software manufacturer to user Transformation, greatly improved search efficiency, shorten the response time to demand, greatly improve query depth and range.This hair The bright visible customization for realizing statistical indicator, reduces dependence of the business personnel to software vendor, improves crew's data application effect Rate and level.
Detailed description of the invention
Fig. 1 is basic query information drawing I;
Fig. 2 is basic query information drawing II;
Fig. 3 is expanding query condition and querying condition post-processing option figure;
Fig. 4 is comprehensive inquiry output intent option figure;
Fig. 5 is statistics plug-in management;
Fig. 6 is the theme extended field management;
Fig. 7, which is the theme, counts plug-in parameter management;
Fig. 8 is the program chart of comprehensive inquiry.
Specific embodiment
Below with reference to embodiment, the invention will be further described, but should not be construed the above-mentioned subject area of the present invention only It is limited to following embodiments.Without departing from the idea case in the present invention described above, according to ordinary skill knowledge and used With means, various replacements and change are made, should all include within the scope of the present invention.
Embodiment 1:
Referring to Fig. 1 to Fig. 7, a kind of comprehensive inquiry and analysis system mainly include computer storage, PC display screen, number Boundary is shown according to library, comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field administration interface and query result Face.
Computer storage storing data library, comprehensive inquiry visualization interface, statistics plug-in management interface, theme expand Open up all data of field administration interface and query result display interface.
The PC display screen shows comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field management Interface and query result display interface.
The comprehensive inquiry visualization interface mainly include inquiry theme selectionbar, data source capability column, inquiry button I, Save button I, button I, basic query condition selecting module, expanding query condition selecting module and output intent option selection mould are opened Block.
The inquiry theme selectionbar selection inquiry theme.
The inquiry button I opens comprehensive inquiry.
The save button I saves the inquiry setting of comprehensive inquiry.
The opening button I opens comprehensive inquiry, which is saved as name inquiry.
The data source capability column selects data source to be checked.
The data source is the database file saved in the database.Database has several database files.Often A database file corresponds to unique data source name.
The basic query condition selecting module mainly includes field name selectionbar I, operator selectionbar I and looks into substantially Inquiry condition display field.
The field name selectionbar I includes two column selection columns.
The operator selectionbar I includes three column selection columns.
The basic query condition display field shows the basic query condition selected.
The expanding query condition selecting module mainly includes field name selectionbar II, operator selectionbar II and extension Querying condition display field.
The field name selectionbar II includes two column selection columns.
The operator selectionbar II includes three column selection columns.
The expanding query condition display field shows the expanding query condition selected.
The output intent option selecting module mainly includes that list of fields selectionbar, processing result selectionbar, grouping condition are set Set module and sort criteria setup module.
The list of fields selectionbar selects output field.
The drop-down list on the left side is output field, often chooses a field, can press newly-increased button and be added to lower section In output intent option list, output after can also handling output intent option is as a result, processing includes maximum, minimum, average, integral The processing such as it is ranked up, is grouped to query result Deng, it is possible to use the button on the right or list.Click a certain item output word by right key Section and after selecting modification, querying condition can be shown in again in the list box of top, to be adjusted to it, then clicked Update button updates corresponding content in compound condition expression formula.It clicks a certain item querying condition by right key and selects to delete Afterwards.This querying condition can be deleted.
The processing result selectionbar selection is further processed mode to output field.
Being further processed mode mainly includes summing, averaging, take maximin etc..Be further processed mode according to Actual conditions are set and are added.
The grouping condition of the grouping condition setting module setting output result.
The sort criteria of the sort criteria setup module setting output result.
The statistics plug-in management interface mainly includes plugin name display field, new buttons, delete button, save button With number of pages display module.
The plugin name display field mainly includes plugin name column, executive module column, executes method column, returns to Value Types Column and plug-in unit description bar.
The plugin name column shows plugin name.
The executive module column shows the executive module of plug-in unit.
Execution method column shows the execution method of plug-in unit.
The return value type column shows the return Value Types of plug-in unit.
The plug-in unit description bar shows the explanation of plug-in unit.
The topic expansion field administration interface shows the field name of setting in the comprehensive inquiry visualization interface Field name column in.
The topic expansion field administration interface mainly includes that theme display module, new buttons, delete button, preservation are pressed Button and field display field.
The field name is the build-in attribute of business object, includes mainly coding, title, manufacturer and puts into operation day Phase.Only one value of each attribute of each business object, is chosen by drop-down list.Check box beside the bracket on the left side is such as Fruit stamps " √ ", i.e., selected check box, then the querying condition left side will appear bracket, and the right is also similar, by beating querying condition Bracket, can be generated the logical combination of each querying condition, to support complicated querying condition." " following drop-down list rule Determined the processing to basic query condition (field), such as maximum, minimum, average, i.e., after handling elementary field again into The judgement of row condition, further enhances query capability." operator " refers to comparison operator, such as larger than, be less than, be more than or equal to, It is less than or equal to, includes, for patrols the processing result for inquiring field or its processing result and " value " or " value " on the right " newly-increased " button can be clicked and be added in following text box, also may be selected before newly-increased after every a line condition setting by collecting operation Bracket or logical operator (and/or), in this way by repeatedly newly-increased, compound query conditional expression can be formed.In querying condition In expression formula, after clicking a certain item querying condition by right key and clicking modification, querying condition can be shown in the list box of top again In, to be adjusted to it, Update button is then clicked, corresponding content is updated in compound condition expression formula.Right button After clicking a certain item querying condition and selecting deletion.This querying condition can be deleted.
The expanding query field be the operation attribute of business object, i.e. business object in the process of running over time And continually changing operation characteristic parameter, it mainly include power, voltage, frequency, temperature, flow, pressure, water level, concentration, volume And speed.Each business object has one or more values, and time point one value is chosen by drop-down list." " below Drop-down list define the processing to expanding query condition (field), such as maximum, minimum, average, integral belongs to extension Property carries out condition judgement after being handled again, further enhances query capability." operator " refers to comparison operator, such as big In, be less than, be more than or equal to, be less than or equal to, include, for " value " or " value " of field or its processing result and the right will to be inquired Processing result carry out logical operation and can click " newly-increased " button after the setting of every a line condition and be added to following text box In, increase newly before also may be selected logical operator (and/or), in this way by repeatedly increase newly, compound query conditional expression can be formed. In querying condition expression formula, after clicking a certain item querying condition by right key and selecting modification, querying condition can be shown in again In the list box of side, to be adjusted to it, Update button is then clicked, is updated in compound condition expression formula corresponding Content.After clicking a certain item querying condition by right key and selecting deletion.This querying condition can be deleted.
The operation attribute of business object or statistics plug-in unit are established as extended field, specified extended field will appear in In expanding query condition options list.
The theme display module shows all themes.The theme saves basic query condition.
The new buttons new theme.
The delete button deletes theme.
The save button saves theme.
The field display field mainly includes extended field source column and extended field column.
Extended field source column shows the corresponding database file name of extended field.
The extended field column shows extended field.
The number of pages display module mainly include current page number display field, page sum display field, page up select button, Lower one page select button and refresh button.
The current page number display field shows the number of pages of current page.
The page sum display field shows the total page number of query result.
The page up select button links page up query result.
Lower one page select button links lower one page query result.
The refresh button refreshes current page.
The query result display interface shows query result.
The query result display interface mainly includes inquiry output field title display field, original value display field, occurs Time showing column and number of pages display module.
The inquiry output field title display field shows the title of query argument.
The original value display field shows the corresponding initial data of query argument.
The time of origin display field shows the record time of the initial data.
As shown in Figure 1, having check box before field name and logical operator.As shown in figure 5, having before plugin name multiple Select frame.As shown in fig. 6, having check box before extended field source.As shown in fig. 7, having before plugin name and plug-in parameter multiple Select frame.The plugin name of the present embodiment mainly includes rate of load condensate, load factor and power factor.Plugin name can be named independently, Mainly determined by plug-in unit used.
Embodiment 2:
As shown in figure 8, it is a kind of using comprehensive inquiry and the method for analysis system, it mainly comprises the steps that
1) database is established.
2) comprehensive inquiry and analysis system are configured, are mainly comprised the steps that
2.1) Subject Manager is needed according to production, all kinds of production management data (table) are spliced into view, construct one Or multiple single tables in logic.
2.2) class and method are registered as plug-in unit by plug-in management, describe its path, class name and method name, using anti- Principle is penetrated to be called.
2.3) the dimension of equipment operating data is maintained in a table by topic expansion field management, by dimension title It reads and is added in the drop-down list of comprehensive inquiry expansion condition and output intent option, thus using operation data as querying condition Or output intent option.
2.4) theme counts plug-in parameter management, that is, is directed to a certain theme, and statistics plug-in unit is added to the plug-in unit in upper right side In name list, then it represents that quote the statistics plug-in unit in the comprehensive inquiry expansion condition and output intent option of the theme.Lower right The parameter transmitted to the plug-in unit of plug-in parameter interface definition.
3) it starts to query, mainly comprises the steps that
3.1) first stage inquiry is carried out, primary screening is carried out to theme view, and extract second-order from the selection result The parameter of section inquiry.
3.2) judge whether second stage query argument has expansion condition, if so, step 3.3 is transferred to, if it is not, then jumping To step 3.6.
3.3) it is directed to each expanding query condition, determines the execution method I of inquiry.
3.4) method for query execution I is called, second stage query argument is passed into execution method I, carries out second stage Inquiry, obtains second stage query result.First stage query result and second stage query result are spliced.
3.5) it is based on splicing result, is transferred to step 3.1, updates stage first time query result.
3.6) extension output intent option is judged whether there is.If so, step 3.7 is gone to, if it is not, then jumping directly to step 4.
3.7) it is directed to each extension output intent option, determines execution method II.
3.8) execution method II is called, updated first stage query argument is passed into execution method II, carries out the The inquiry of three stages calculates, and obtains phase III query result.First and third stage query result is spliced.
4) final query result is exported, and is shown in final query result display interface.

Claims (5)

1. a kind of comprehensive inquiry and analysis system, it is characterised in that: mainly include computer storage, the PC display screen, number Boundary is shown according to library, comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field administration interface and query result Face.
Computer storage storing data library, comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion word Segment management interface and query result display interface;
The PC display screen shows comprehensive inquiry visualization interface, statistics plug-in management interface, topic expansion field administration interface With query result display interface;
The comprehensive inquiry visualization interface mainly includes inquiry theme selectionbar, data source capability column, inquiry button I, saves Button I, button I, basic query condition selecting module, expanding query condition selecting module and output intent option selecting module are opened;
The inquiry theme selectionbar selection inquiry theme;
The inquiry button I opens comprehensive inquiry;
The save button I saves the inquiry setting of comprehensive inquiry;
The button I that opens opens the comprehensive inquiry for saving as name inquiry;
The data source capability column selects data source to be checked;
The basic query condition selecting module mainly includes field name selectionbar I, operator selectionbar I and basic query item Part display field;
The field name selectionbar I includes two column selection columns;
The operator selectionbar I includes three column selection columns;
The basic query condition display field shows the basic query condition selected;
The expanding query condition selecting module mainly includes field name selectionbar II, operator selectionbar II and expanding query Condition display field;
The field name selectionbar II includes two column selection columns;
The operator selectionbar II includes three column selection columns;
The expanding query condition display field shows the expanding query condition selected;
The output intent option selecting module mainly includes list of fields selectionbar, processing result selectionbar, grouping condition setting mould Block and sort criteria setup module;
The list of fields selectionbar selects output field;
The processing result selectionbar selection is further processed mode to output field;
The grouping condition of the grouping condition setting module setting output result;
The sort criteria of the sort criteria setup module setting output result;
The statistics plug-in management interface mainly includes plugin name display field, new buttons, delete button, save button and page Number display module;
The plugin name display field mainly include plugin name column, executive module column, execute method column, return value type column and Plug-in unit description bar;
The plugin name column shows plugin name;
The executive module column shows the executive module of plug-in unit;
Execution method column shows the execution method of plug-in unit;
The return value type column shows the return Value Types of plug-in unit;
The plug-in unit description bar shows the explanation of plug-in unit;
The field name of setting is shown the word in the comprehensive inquiry visualization interface by the topic expansion field administration interface In name section column;
The topic expansion field administration interface mainly include theme display module, new buttons, delete button, save button and Field display field;
The theme display module shows all themes;
The new buttons new theme;
The delete button deletes theme;
The save button saves theme;
The field display field mainly includes extended field source column and extended field column;
Extended field source column shows the corresponding database file name of extended field;
The extended field column shows extended field;
The query result display interface shows query result;
The query result display interface mainly includes inquiry output field title display field, original value display field, time of origin Display field and number of pages display module;
The inquiry output field title display field shows the title of query argument;
The original value display field shows the corresponding initial data of query argument;
The time of origin display field shows the record time of the initial data.
2. a kind of comprehensive inquiry according to claim 1 and analysis system, it is characterised in that: the number of pages display module master It to include current page number display field, page sum display field, page up select button, lower one page select button and refresh button;
The current page number display field shows the number of pages of current page;
The page sum display field shows the total page number of query result;
The page up select button links page up query result;
Lower one page select button links lower one page query result;
The refresh button refreshes current page.
3. a kind of comprehensive inquiry according to claim 1 or 2 and analysis system and method, it is characterised in that: the data Source is the database file saved in the database;Database has several database files;Each database file is corresponding Unique data source name.
4. a kind of comprehensive inquiry according to claim 1 or 2 and analysis system and method, it is characterised in that: the field The build-in attribute of entitled business object mainly includes coding, title, manufacturer and date of putting into operation;Each business object Only one value of each attribute, is chosen by drop-down list;
The expanding query field be business object operation attribute, i.e., business object in the process of running over time without The operation characteristic parameter of disconnected variation mainly includes power, voltage, frequency, temperature, flow, pressure, water level, concentration, volume and speed Degree.
5. a kind of using comprehensive inquiry described in Claims 1-4 4 and the method for analysis system, which is characterized in that mainly include Following steps:
1) database is established;
2) comprehensive inquiry and analysis system are configured, are mainly comprised the steps that
2.1) Subject Manager needs according to production, all kinds of production management data or all kinds of production management tables of data is spliced into View, the one or more single tables in logic of construction.
2.2) class and method are registered as plug-in unit by plug-in management, describe its path, class name and method name, former using reflection Reason is called.
2.3) the dimension of equipment operating data is maintained in a table, dimension title is read by topic expansion field management And be added in the drop-down list of comprehensive inquiry expansion condition and output intent option, thus using operation data as querying condition or defeated Option out.
2.4) theme counts plug-in parameter management, that is, is directed to a certain theme, and statistics plug-in unit is added to the plugin name in upper right side In list, then it represents that quote the statistics plug-in unit in the comprehensive inquiry expansion condition and output intent option of the theme, lower right is inserted Part parameter interface defines the parameter transmitted to the plug-in unit;
3) it starts to query, mainly comprises the steps that
3.1) first stage inquiry is carried out, primary screening is carried out to theme view, and extracts second stage from the selection result and looks into The parameter of inquiry.
3.2) judge whether second stage query argument has expansion condition, if so, step 3.3 is transferred to, if it is not, then jumping to step Rapid 3.6.
3.3) it is directed to each expanding query condition, determines the execution method I of inquiry.
3.4) method for query execution I is called, second stage query argument is passed into execution method I, carries out second stage inquiry, Obtain second stage query result.First stage query result and second stage query result are spliced.
3.5) it is based on splicing result, is transferred to step 3.1, updates stage first time query result.
3.6) extension output intent option is judged whether there is.If so, step 3.7 is gone to, if it is not, then jumping directly to step 4.
3.7) it is directed to each extension output intent option, determines execution method II.
3.8) execution method II is called, updated first stage query argument is passed into execution method II, carries out third rank Section inquiry calculates, and obtains phase III query result.First and third stage query result is spliced.
4) final query result is exported, and is shown in final query result display interface.
CN201810973648.5A 2018-08-24 2018-08-24 A kind of comprehensive inquiry and analysis system and method Pending CN109408564A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810973648.5A CN109408564A (en) 2018-08-24 2018-08-24 A kind of comprehensive inquiry and analysis system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810973648.5A CN109408564A (en) 2018-08-24 2018-08-24 A kind of comprehensive inquiry and analysis system and method

Publications (1)

Publication Number Publication Date
CN109408564A true CN109408564A (en) 2019-03-01

Family

ID=65464458

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810973648.5A Pending CN109408564A (en) 2018-08-24 2018-08-24 A kind of comprehensive inquiry and analysis system and method

Country Status (1)

Country Link
CN (1) CN109408564A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113220714A (en) * 2021-05-29 2021-08-06 五八到家有限公司 Configurable data query platform and method, electronic equipment and readable medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2004029755A2 (en) * 2002-09-27 2004-04-08 Enviance, Inc. Automated report building system
CN1556482A (en) * 2003-12-31 2004-12-22 中兴通讯股份有限公司 Data processing method for realizing data base multitable inguiry
CN104572856A (en) * 2014-12-17 2015-04-29 武汉科技大学 Converged storage method of service source data
CN106815271A (en) * 2015-12-02 2017-06-09 北京国双科技有限公司 Querying condition generation method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2004029755A2 (en) * 2002-09-27 2004-04-08 Enviance, Inc. Automated report building system
CN1556482A (en) * 2003-12-31 2004-12-22 中兴通讯股份有限公司 Data processing method for realizing data base multitable inguiry
CN104572856A (en) * 2014-12-17 2015-04-29 武汉科技大学 Converged storage method of service source data
CN106815271A (en) * 2015-12-02 2017-06-09 北京国双科技有限公司 Querying condition generation method and device

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
(美)BRIAN CASWELL: "《Snort 2.0入侵检》", 31 January 2004, 北京:国防工业出版社 *
孟娟: ""海洋数据平台数据可视化查询与展示子系统设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *
杨宏业: ""J2EE平台下通用查询系统的设计与实现"", 《中国优秀硕士学位论文 信息科技辑》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113220714A (en) * 2021-05-29 2021-08-06 五八到家有限公司 Configurable data query platform and method, electronic equipment and readable medium

Similar Documents

Publication Publication Date Title
US11768875B2 (en) Monitoring system control interface for asset tree determination
US7475080B2 (en) Adaptive data warehouse meta model method
JP5570608B2 (en) Excel-based analysis report creation system and method
US20180032570A1 (en) Search point management
US11461350B1 (en) Control interface for dynamic elements of asset monitoring and reporting system
EP2463790B1 (en) Manipulation of elements and their attributes in graphical user interfaces
US20160224594A1 (en) Schema Definition Tool
US11132373B1 (en) Decoupled update cycle and disparate search frequency dispatch for dynamic elements of an asset monitoring and reporting system
US20090193039A1 (en) Data driven system for data analysis and data mining
CN105308592A (en) Value based windows on relations in continuous data streams
CN102279851A (en) Intelligent navigation method, device and system
CN103020158A (en) Report form creation method, device and system
CN202339542U (en) Software product test system
CN109002334B (en) Operation and maintenance platform and data processing method thereof
CN108765052A (en) Electric business recommendation/method for pushing and device, storage medium and computing device
US20010037228A1 (en) System and method for using metadata to flexibly analyze data
CN110442620A (en) A kind of big data is explored and cognitive approach, device, equipment and computer storage medium
CN111126852A (en) BI application system based on big data modeling
US8239371B2 (en) Fast search views over business objects
CN102779186A (en) Whole process modeling method of unstructured data management
EP3721354A1 (en) Systems and methods for querying databases using interactive search paths
CN109408564A (en) A kind of comprehensive inquiry and analysis system and method
CN113722564A (en) Visualization method and device for energy and material supply chain based on space map convolution
CN109359123A (en) A kind of inquiry of operation data and analysis system and method
US20130218893A1 (en) Executing in-database data mining processes

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