CN103488692B - Data query system and data query method - Google Patents
Data query system and data query method Download PDFInfo
- Publication number
- CN103488692B CN103488692B CN201310392532.XA CN201310392532A CN103488692B CN 103488692 B CN103488692 B CN 103488692B CN 201310392532 A CN201310392532 A CN 201310392532A CN 103488692 B CN103488692 B CN 103488692B
- Authority
- CN
- China
- Prior art keywords
- data
- data field
- condition
- subordinate
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24535—Query rewriting; Transformation of sub-queries or views
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data query system and a data query method, wherein the data query system comprises an incidence relation setting unit, a judging unit, a data area determining unit and a query unit; the incidence relation setting unit is used for placing multiple data areas into one report, and determining the incidence relation among the data areas according to the setting on the report format; the judging unit is used for judging whether a preset query condition exists in the directly related data areas; the data area determining unit is used for determining directly related data areas; the query unit is used for querying the data in the directly related data areas according to the preset query condition in the data areas. By the technical scheme disclosed by the invention, the data linkage can be finished in one report, multi-level defaulted linkage can be realized, data can be queried by data area without querying the whole report, and the querying can also be performed aiming at multiple data areas.
Description
Technical field
The present invention relates to data query technique field, look in particular to a kind of data query system and a kind of data
Inquiry method.
Background technology
In general the technical scheme of existing multistage linking is that multiple data fields are respectively designed to different forms, each
Form corresponds to a data field, and user needs to select a data to look into as querying condition from the corresponding form in main data area
Ask from the corresponding form in data field, then will do main data area inquiry from data field and there is the report of direct relation this data field again
Table.
This scheme has three below shortcoming:
1. multistage acquiescence linkage cannot be realized
Because multiple data fields are respectively in different forms, can beat when main data area linkage inquiry is from data field
Open the corresponding form from data field, if want to link to inquire from data field, with it, there is the data field of the relation of being attached directly to
Shi Bixu user manually completes, and so cannot accomplish to give tacit consent to continuous multiple data fields of linking.
2. do not enable the branch that links
In general the linkage of this scheme can only occur both principal and subordinate data fields it is impossible to accomplish a main data area linkage
Multiple demands from data field, but such demand really necessary being, such as one main data area generally will link
Plural from data field, wherein one or more are from data field as detailed data, another or the conduct of multiple data fields
Show the data field of chart, existing technical scheme can not meet such demand.
3. Consumer's Experience and system effectiveness are poor
This scheme is all that a form corresponds to a data field, then must when will link from data field from main data area
A form need be reopened, or the form reopening every time needs reopening tab to need to reopen node, so
User is inconvenient when browsing and contrasting to data.In addition open a form more and mean that many instance objects, be
All can there is larger occupancy on the internal memory of system and efficiency.
Content of the invention
The present invention is based on the problems referred to above it is proposed that a kind of data query technique, can be just complete in same form
Become data linkage, and realize multistage acquiescence linkage, and divided data area inquiry data, it is not necessary to the inquiry of whole table, can also be for
Multiple data fields are inquired about.
In view of this, the present invention proposes a kind of data query system, including:Incidence relation arranging unit, for will be many
Individual data field is arranged in a form, according to the setting to described statement form, determines every number in the plurality of data field
According to the incidence relation between area;Judging unit, for judge with main data area direct correlation or indirect association at least one under
Whether there is preset query condition in DBMS area;Data field determining unit, for according to the query statement receiving, described
Determine described main data area in multiple data fields, and determine at least one the lower DBMS with the direct correlation of described main data area
Area, and in the presence of described judging unit judges, determine direct with the subordinate data field that there is preset query condition
At least one subordinate data field of association;Query unit, for according to the preset query condition in described main data area described
Inquire about data with least one subordinate data field of described main data area direct correlation, and there is default inquiry according to described
Preset query condition in the subordinate data field of condition, in subordinate's data field direct correlation that is described and there is preset query condition
At least one subordinate data field in inquire about data.
It is preferable that also including in technique scheme:Condition select unit, for selecting according to the condition receiving
Instruction, determines first object querying condition in described preset query condition, and/or according to the condition selection instruction receiving,
Determine the second target query condition in described preset query condition, wherein, described data field determining unit is additionally operable to according to institute
State first object querying condition and determine first in described at least one subordinate data field with the direct correlation of described main data area
Target data area, and/or according to described second target query condition in subordinate data field that is described and there is preset query condition
The second target data area is determined, described query unit is additionally operable to according to described at least one subordinate data field of direct correlation
One target query condition inquires about data in described first object data field, and/or is existed according to described second target query condition
Data is inquired about in described second target data area.
It is preferable that also including in technique scheme:Condition setting unit, for according to the condition setting receiving
Instruction, is that each data field at least one of the plurality of data field data field is respectively provided with preset query condition.
It is preferable that described preset query condition includes following at least one or a combination thereof in any of the above-described technical scheme:
Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
It is preferable that also including in any of the above-described technical scheme:Represent unit, for will be according to the default algorithm that represents
The data inquiring in described at least one subordinate data field with the direct correlation of described main data area, and described pre- with presence
If the data inquiring at least one subordinate data field of subordinate's data field direct correlation of querying condition, in a form
Represented.
The application also proposed a kind of data query method, including:Step 202, multiple data fields are arranged at a report
In table, according to the setting to described statement form, determine the incidence relation between each data field in the plurality of data field;Step
Rapid 204, according to the query statement receiving, determine main data area in the plurality of data field, and determine and described master data
At least one subordinate data field of area's direct correlation, according to the preset query condition in described main data area in described and described master
Data is inquired about at least one subordinate data field of data field direct correlation;Step 206, judges directly to close with described main data area
Whether there is preset query condition, if existing it is determined that pre- with existing at least one subordinate data field of connection or indirect association
If at least one subordinate data field of subordinate's data field direct correlation of querying condition, and there is preset query condition according to described
Subordinate data field in preset query condition, described with subordinate's data field direct correlation that is there is preset query condition extremely
Data is inquired about in a few subordinate data field.
It is preferable that described step 204 also includes in technique scheme:According to the condition selection instruction receiving,
First object querying condition is determined in described preset query condition, and according to described first object querying condition described and described
Determine first object data field at least one subordinate data field of main data area direct correlation, inquired about according to described first object
Condition inquires about data in described first object data field;And/or described step 206 also includes:According to the condition choosing receiving
Select instruction, described preset query condition determines the second target query condition, and existed according to described second target query condition
Described with there is preset query condition at least one subordinate data field of subordinate's data field direct correlation in determine the second target
Data field, inquires about data according to described second target query condition in described second target data area.
It is preferable that described step 202 also includes in technique scheme:According to the condition setting instruction receiving, it is
Each data field at least one of the plurality of data field data field is respectively provided with preset query condition.
It is preferable that described preset query condition includes following at least one or a combination thereof in any of the above-described technical scheme:
Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
It is preferable that also including in any of the above-described technical scheme:Will be in described and described main number according to the default algorithm that represents
According to the data inquiring at least one subordinate data field of area's direct correlation, and described with exist under preset query condition
The data inquiring at least one subordinate data field of DBMS area direct correlation, is represented in a form.
By above technical scheme, just can complete data linkage in same form, and realize multistage acquiescence connection
Dynamic, and data is inquired about in divided data area it is not necessary to whole table is inquired about, and can also be for multiple data fields and is inquired about.
Brief description
Fig. 1 shows the schematic block diagram of data query system according to embodiments of the present invention;
Fig. 2 shows the schematic flow diagram of data query method according to embodiments of the present invention;
Fig. 3 shows the concrete schematic flow diagram of data query method according to embodiments of the present invention;
Fig. 4 shows the schematic diagram of multistage linking according to embodiments of the present invention.
Specific embodiment
In order to be more clearly understood that the above objects, features and advantages of the present invention, below in conjunction with the accompanying drawings and specifically real
Mode of applying is further described in detail to the present invention.It should be noted that in the case of not conflicting, the enforcement of the application
Feature in example and embodiment can be mutually combined.
Elaborate a lot of details in the following description in order to fully understand the present invention, but, the present invention also may be used
To be implemented different from other modes described here using other, therefore, protection scope of the present invention is not described below
Specific embodiment restriction.
Data field:The region of the display data in form product and to should the data set in region collectively constitute.
Linkage:Linkage occurs in two data intervals, one of as main data area another as from data field.From
The parameter that data field passes over main data area filters the data from data field as querying condition.
Multistage linking:Multistage linking usually occurs in two or more data fields, and multistage linking comprises linkage
Institute is functional.Multistage linking there is also the master slave relation of data field, but the master slave relation of multistage linking is relative, when a number
All will become from data field as the data field that so there is direct interaction relation during main data area with this data field according to region, when
It is changed into main data area from data field when having filtered data from data field again and carry out filtering have direct relation with this data field again
From data field.
Linkage is regular (being equivalent to preset query condition):Linkage rule is the filtration relation of two data intervals and transmission is looked into
Ask the foundation of parameter.
Fig. 1 shows the schematic block diagram of data query system according to embodiments of the present invention.
As shown in figure 1, data query system 100 according to embodiments of the present invention includes:Incidence relation arranging unit 102,
For multiple data fields are arranged in a form, according to the setting to described statement form, determine the plurality of data field
In incidence relation between each data field;Judging unit 104, for judging and main data area direct correlation or indirect association
Whether there is preset query condition at least one subordinate data field;Data field determining unit 106, for according to looking into of receiving
Ask instruction, determine described main data area in the plurality of data field, and determine with the direct correlation of described main data area at least
One subordinate data field, and in the presence of described judging unit 104 judges, determine and there is preset query condition
At least one subordinate data field of subordinate's data field direct correlation;Query unit 108, for according to pre- in described main data area
If querying condition inquires about data in described at least one subordinate data field with the direct correlation of described main data area, and according to
Preset query condition in the described subordinate data field that there is preset query condition, described with exist under preset query condition
Data is inquired about at least one subordinate data field of DBMS area direct correlation.
In this technical scheme, by multiple data fields being arranged in a form it is possible to pass through this statement form
Be configured to determine the interaction relation (i.e. incidence relation) between each data field so that main data area can associate many
Individual from data field (i.e. the subordinate data field with main data area direct correlation), and each can also be used as master data from data field
Area associates next stage further from data field, by that analogy, can complete in form setting of incidence relation between each data field
Put and can carry out for multiple data fields so that linking.And between the data field that there is incidence relation, can be according to each
Preset query condition in data field is linked, and such as main data area A associates pass with from data field B with from data field D presence
, there is incidence relation further and from data field C from data field B in system, then when initiating combined operation, can be according to master data
It is directed in area A from the querying condition of data field B carrying out data query from the B of data field, and be directed to according in main data area A
Carrying out data query from the querying condition of data field D from the D of data field, be then directed to from data field C according to from the B of data field
Querying condition carrying out data query from the C of data field, it is achieved thereby that the linkage to multiple data fields of data field, and
And the acquiescence linkage of multiple data fields is completed in a form according to the preset query condition in each data field.
Data field due to being linked all exists in same form, facilitates user's checking and contrasting to data, and
And open its form without for different data fields when linking, decrease REPORT-OBJECT repeats establishment, also saves internal memory
Battle achievement, system effectiveness is also correspondingly improved.
It is preferable that also including in technique scheme:Condition select unit 110, for according to the condition choosing receiving
Select instruction, described preset query condition determines first object querying condition, and/or select to refer to according to the condition receiving
Order, determines the second target query condition, wherein, described data field determining unit is additionally operable to basis in described preset query condition
Described first object querying condition determines the in described at least one subordinate data field with the direct correlation of described main data area
One target data area, and/or according to described second target query condition in lower DBMS that is described and there is preset query condition
The second target data area is determined, described query unit is additionally operable to according to described at least one subordinate data field of area's direct correlation
First object querying condition inquires about data in described first object data field, and/or according to described second target query condition
Data is inquired about in described second target data area.
In this technical scheme, when there is direct correlation relation with multiple data fields in a data field, then it comprises
Preset query condition in there is the querying condition of data field for each direct correlation, such as main data area A with from data
Area B and from data field D direct correlation, wherein exists for from the preset query condition of data field B and default for data field D
Querying condition, user input condition selection instruction can determine the data field of required inquiry so that carrying out linkage behaviour as needed
Carry out data query only for the data field needed for user, such as user only have selected to be directed to and looks into from the default of data field B when making
Inquiry condition, then when carrying out combined operation, then only carry out main data area A and the linkage from data field B so that combined operation has more
Targetedly, more meet needed for user, and the unwanted data of user need not be inquired about, improve search efficiency.
It is preferable that also including in technique scheme:Condition setting unit 112, for setting according to the condition receiving
Put instruction, be that each data field at least one of the plurality of data field data field is respectively provided with preset query condition.
It is preferable that described preset query condition includes following at least one or a combination thereof in any of the above-described technical scheme:
Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
In this technical scheme, user can be arranged as required to preset query condition, changes content therein, such as main
Data field A is directed to and comprises subordinate data field to be checked from the preset query condition of data field B for B, and Field Inquiry condition is
Field 1 in main data area A is equal with the field 1 from the B of data field, and the field 2 from the B of data field is greater than 100, then
User can be arranged as required to this preset query condition, such as deletes the limit of " field 2 from the B of data field is greater than 100 "
Fixed, or " field 1 in main data area A is equal with the field 1 from the B of data field " is revised as " field in main data area A
2 is equal with the field 2 from the B of data field " so that main data area A and from data field B occur linkage when, the number inquiring
According to more meeting needed for user.
It is preferable that also including in any of the above-described technical scheme:Represent unit 114, will for the default algorithm that represents of basis
The data inquiring in described at least one subordinate data field with the direct correlation of described main data area, and in described and presence
The data inquiring at least one subordinate data field of subordinate's data field direct correlation of preset query condition, in a form
In represented.
In this technical scheme, inquiring about the data obtaining can be presented in a form according to preset algorithm, and presets
Algorithm can consistent with the method for product of form so that the data representing more meets the product of this form, be easy to user and enter
Row inquiry and contrast.
Fig. 2 shows the schematic flow diagram of data query method according to embodiments of the present invention.
As shown in Fig. 2 data query method according to embodiments of the present invention includes:Step 202, multiple data fields are arranged
In a form, according to the setting to described statement form, determine the pass between each data field in the plurality of data field
Connection relation;Step 204, according to the query statement receiving, determines main data area in the plurality of data field, and determines and institute
State at least one subordinate data field of main data area direct correlation, according to the preset query condition in described main data area described
With inquiry data at least one subordinate data field of described main data area direct correlation;Step 206, judges and described master data
In at least one subordinate data field of area's direct correlation or indirect association whether there is preset query condition, if exist it is determined that
With at least one the subordinate data field of the subordinate's data field direct correlation that there is preset query condition, and according to described exist default
Preset query condition in the subordinate data field of querying condition, direct in subordinate data field that is described and there is preset query condition
Data is inquired about at least one subordinate data field of association.
In this technical scheme, by multiple data fields being arranged in a form it is possible to pass through this statement form
Be configured to determine the interaction relation (i.e. incidence relation) between each data field so that main data area can associate many
Individual from data field (i.e. the subordinate data field with main data area direct correlation), and each can also be used as master data from data field
Area associates next stage further from data field, by that analogy, can complete in form setting of incidence relation between each data field
Put and can carry out for multiple data fields so that linking.And between the data field that there is incidence relation, can be according to each
Preset query condition in data field is linked, and such as main data area A associates pass with from data field B with from data field D presence
, there is incidence relation further and from data field C from data field B in system, then when initiating combined operation, can be according to master data
It is directed in area A from the querying condition of data field B carrying out data query from the B of data field, and be directed to according in main data area A
Carrying out data query from the querying condition of data field D from the D of data field, be then directed to from data field C according to from the B of data field
Querying condition carrying out data query from the C of data field, it is achieved thereby that the linkage to multiple data fields of data field, and
And the acquiescence linkage of multiple data fields is completed in a form according to the preset query condition in each data field.
Data field due to being linked all exists in same form, facilitates user's checking and contrasting to data, and
And open its form without for different data fields when linking, decrease REPORT-OBJECT repeats establishment, also saves internal memory
Battle achievement, system effectiveness is also correspondingly improved.
It is preferable that described step 204 also includes in technique scheme:According to the condition selection instruction receiving,
First object querying condition is determined in described preset query condition, and according to described first object querying condition described and described
Determine first object data field at least one subordinate data field of main data area direct correlation, inquired about according to described first object
Condition inquires about data in described first object data field;And/or described step 206 also includes:According to the condition choosing receiving
Select instruction, described preset query condition determines the second target query condition, and existed according to described second target query condition
Described with there is preset query condition at least one subordinate data field of subordinate's data field direct correlation in determine the second target
Data field, inquires about data according to described second target query condition in described second target data area.
In this technical scheme, when there is direct correlation relation with multiple data fields in a data field, then it comprises
Preset query condition in there is the querying condition of data field for each direct correlation, such as main data area A with from data
Area B and from data field D direct correlation, wherein exists for from the preset query condition of data field B and default for data field D
Querying condition, user input condition selection instruction can determine the data field of required inquiry so that carrying out linkage behaviour as needed
Carry out data query only for the data field needed for user, such as user only have selected to be directed to and looks into from the default of data field B when making
Inquiry condition, then when carrying out combined operation, then only carry out main data area A and the linkage from data field B so that combined operation has more
Targetedly, more meet needed for user, and the unwanted data of user need not be inquired about, improve search efficiency.
It is preferable that described step 202 also includes in technique scheme:According to the condition setting instruction receiving, it is
Each data field at least one of the plurality of data field data field is respectively provided with preset query condition.
It is preferable that described preset query condition includes following at least one or a combination thereof in any of the above-described technical scheme:
Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
In this technical scheme, user can be arranged as required to preset query condition, changes content therein, such as main
Data field A is directed to and comprises subordinate data field to be checked from the preset query condition of data field B for B, and Field Inquiry condition is
Field 1 in main data area A is equal with the field 1 from the B of data field, and the field 2 from the B of data field is greater than 100, then
User can be arranged as required to this preset query condition, such as deletes the limit of " field 2 from the B of data field is greater than 100 "
Fixed, or " field 1 in main data area A is equal with the field 1 from the B of data field " is revised as " field in main data area A
2 is equal with the field 2 from the B of data field " so that main data area A and from data field B occur linkage when, the number inquiring
According to more meeting needed for user.
It is preferable that also including in any of the above-described technical scheme:Will be in described and described main number according to the default algorithm that represents
According to the data inquiring at least one subordinate data field of area's direct correlation, and described with exist under preset query condition
The data inquiring at least one subordinate data field of DBMS area direct correlation, is represented in a form.
In this technical scheme, inquiring about the data obtaining can be presented in a form according to preset algorithm, and presets
Algorithm can consistent with the method for product of form so that the data representing more meets the product of this form, be easy to user and enter
Row inquiry and contrast.
Fig. 3 shows the concrete schematic flow diagram of data query method according to embodiments of the present invention.
As shown in figure 3, data query method according to embodiments of the present invention specifically includes:
Step 302, carries out interaction relation (default inquiry relation) setting.Set in statement form and center each data field
Between interaction relation, interaction relation is saved in data section model as object, and interaction relation comprises main data area to from data
Certain field in the sensing in area, main data area to from data field certain field sensing, by the word of two data fields
Section relation sets up interaction relation.Interaction relation if there are multiple fields, then between these relations can by and and/or patrol
Collect pre- operator to connect.If also the 3rd data field needs to arrange interaction relation, then can appoint in the first two data field
Meaning selects a data field as main data area the 3rd conduct from data field, carries out the setting of interaction relation.Multiple data fields
Just constitute the chain of a linkage rule;
Step 304, after user is provided with linkage rule in reporting tableau format model, (i.e. preset query condition can be with
Data mode is present in data field, and such as data field A is directed to the querying condition of data field B, can be in the form of a data
It is present in the A of data field), then user is choosing when linkage as main data area in a certain data field it is necessary to parsing linkage is advised
Then and produce linkage condition.First have to read the object of the setting of linkage rule from main data area during parsing linkage rule,
Find out from this rule objects again from data field (target data area), pass through major key from data field object or other are uniquely marked
Note or pointer obtain, and finally select corresponding field in linkage rule from a data of the selected main data area of user
Concrete data is spliced into the condition part in required query statement from data field again;
Step 306, the linkage being spliced in step 304 condition is assembled into querying condition object, as parameter transmission
To back-end data area executor, data field executor is responsible for for all conditions being assembled into complete query statement and looks into from data base
Ask data;
Step 308, Query Result is assembled into the data set of data field, and the data field being supplied in form represents;
Step 310, after completing the linkage of two data intervals, if that mentions in above-mentioned steps goes back from data field
If linkage rule, then it is regular to continue this linkage of parsing, and repeatedly step 304 to step 308.The process reference of parsing
Step 304, simply this operation of a data selected by user is completed by system default, and acquiescence selects the first data as linkage
Condition.Certainly acquiescence linkage rule can designate whether to come into force with statement form setting, if come into force, the step for carry out such as
So linkage process that really do not come into force leaves it at that;
Step 312, after all data field execution having direct or indirect linkage rule relation with main data area are completed,
All data sets are flushed on interface by report model, are finally presented to user.The algorithm of report form showing is according to form product
Exhibiting method is consistent.
Fig. 4 shows the schematic diagram of multistage linking according to embodiments of the present invention.
As shown in figure 4, data field A data area B is Liang Ge cohersive and integrated data area, data field C is a detailed data area, number
It is a chart data area according to area D.Based on this linkage rule relation, briefly to introduce down the majority according to the embodiment of the present application
According to area's linkage.
Four data fields of upper in figure are realized multistage linking in same form, needs several steps as follows:
Setting linkage rule, first using cohersive and integrated data area A as main data area, then the linkage of setting on A data field
Rule comprises tri- regions of A, B, D.The rule (i.e. main data area A is directed to the preset query condition from data field B) of A to B is permissible
The field 1 being set in A is equal with the field 1 in B, and the value of the field 2 in B is greater than 100, and this is exactly the connection of A to B
Dynamic rule.Field 1 in the regular A of linkage of A to D is equal with the field 1 in D and A in field 3 and D in field 3 phase
Deng, this be A to D linkage rule.Next the linkage rule of setting B to C, B to C only need to be arranged in field 1 and C in B
Field 1 is equal.
When user-selected number is according to certain data in area A, system can read rule (i.e. from the rule setting of data field A
The preset query condition that data field A is directed to its next stage data field is stored in the A of data field), then rule is carried out at packet
Reason, is related as one group with data field B, related to data field D for another group, then analyze in order.Thus draw B respectively
With the querying condition of D, the condition of B is the first character segment value that first character section in B is equal to the selected data in A of user, B
Second field be more than 100.The condition of D is the first character section of the first character section in D and the selected data in A of user
Equal, the 3rd field of the 3rd field data selected in A with user in D is equal.
After all linkage conditions of above-mentioned steps are all parsed, start according to respective condition pass through region executor from
Execution inquiry peek in data base.During this or make a judgement, judge whether to support silent after the completion of this site polling
Recognize linkage, if otherwise terminate to link in this region, if it is need to obtain the linkage rule setting in this region, judge this region
Whether there is linkage rule, so continue second step if there is linkage rule.Obviously in this example, D region has not had
Linkage rule setting, then D region also just finishes, but but there is linkage setting in B region, then and B region will repeat second
Individual step, when linkage is to C region, also without linkage setting, then C region also finishes in C region.
After above-mentioned linkage inquiry and acquiescence linkage terminate, then whole linkage process is also just only remaining to be presented, and represents
Thing is consistent with report model, so not just being repeated here.
After user finishes once linkage, can also continue to link.It is main data area that such as user selects B region now,
Therefrom have selected a data, then it can be seen that there is the only C of interaction relation with B, at this moment only need to C according to second step
The data in region out and represents from data base querying, and linkage also just finishes.
Technical scheme is described in detail above in association with accompanying drawing it is contemplated that in correlation technique, multistage linking cannot
Realize multistage acquiescence linkage it is impossible to realize linkage branch, a form corresponds to a data field, links from number from main data area
Have to reopen a form during according to area, Consumer's Experience and system effectiveness are poor.By the technical scheme of the application, can
Just complete data linkage in same form, and realize multistage acquiescence linkage, and divided data area inquiry data it is not necessary to
Whole table inquiry, can also be for multiple data fields and is inquired about.
In the present invention, term " first ", " second " are only used for describing purpose, and it is not intended that instruction or hint are relative
Importance.Term " multiple " refers to two or more, limits unless otherwise clear and definite.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (10)
1. a kind of data query system is it is characterised in that include:
Incidence relation arranging unit, for multiple data fields are arranged in a form, sets according to described statement form
Put, determine the incidence relation between each data field in the plurality of data field;
Judging unit, for judge with least one subordinate data field of main data area direct correlation or indirect association in whether deposit
In preset query condition;
Data field determining unit, for according to the query statement receiving, determining described master data in the plurality of data field
Area, and determine at least one the subordinate data field with the direct correlation of described main data area, and judge to deposit in described judging unit
In case, determine at least one the subordinate data field with the subordinate's data field direct correlation that there is preset query condition;
Query unit, for according to the preset query condition in described main data area described with the direct correlation of described main data area
At least one subordinate data field in inquire about data, and according to pre- in the described subordinate data field that there is preset query condition
If querying condition, in described at least one subordinate data field with subordinate's data field direct correlation that is there is preset query condition
Inquiry data.
2. data query system according to claim 1 is it is characterised in that also include:
Condition select unit, for according to the condition selection instruction receiving, determining the first mesh in described preset query condition
Mark querying condition, and/or according to the condition selection instruction receiving, described preset query condition determines the second target query
Condition,
Wherein, described data field determining unit is additionally operable to according to described first object querying condition in described and described main data area
First object data field is determined at least one subordinate data field of direct correlation, and/or according to described second target query bar
Part determines second in described at least one subordinate data field with subordinate's data field direct correlation that is there is preset query condition
Target data area, described query unit is additionally operable to be looked in described first object data field according to described first object querying condition
Ask data, and/or data is inquired about in described second target data area according to described second target query condition.
3. data query system according to claim 1 is it is characterised in that also include:
Condition setting unit, for according to the condition setting instruction receiving, being at least one of the plurality of data field number
It is respectively provided with preset query condition according to each data field in area.
4. data query system according to any one of claim 1 to 3 is it is characterised in that described preset query condition
Including following at least one or a combination thereof:Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
5. data query system according to any one of claim 1 to 3 is it is characterised in that also include:
Represent unit, for the default algorithm that represents of basis by described and at least one subordinate direct correlation of described main data area
The data inquiring in data field, and described with exist preset query condition subordinate's data field direct correlation at least one
The data inquiring in subordinate data field, is represented in a form.
6. a kind of data query method is it is characterised in that include:
Step 202, multiple data fields are arranged in a form, according to the setting to described statement form, determine described many
Incidence relation between each data field in individual data field;
Step 204, according to the query statement receiving, in the plurality of data field determine main data area, and determine with described
At least one subordinate data field of main data area direct correlation, according to the preset query condition in described main data area described with
Data is inquired about at least one subordinate data field of described main data area direct correlation;
Whether step 206, deposit in judgement and at least one subordinate data field of the direct correlation of described main data area or indirect association
In preset query condition, if exist it is determined that with the subordinate's data field direct correlation that there is preset query condition at least one
Subordinate data field, and according to the preset query condition in the described subordinate data field that there is preset query condition, described with deposit
Data is inquired about at least one subordinate data field of subordinate's data field direct correlation of preset query condition.
7. data query method according to claim 6 is it is characterised in that described step 204 also includes:According to receiving
Condition selection instruction, determine first object querying condition in described preset query condition, and looked into according to described first object
Inquiry condition determines first object data field, root in described at least one subordinate data field with the direct correlation of described main data area
Inquire about data according to described first object querying condition in described first object data field;And/or
Described step 206 also includes:According to the condition selection instruction receiving, described preset query condition determines the second mesh
Mark querying condition, and direct in subordinate data field that is described and there is preset query condition according to described second target query condition
The second target data area is determined, according to described second target query condition described the at least one subordinate data field of association
Data is inquired about in two target data areas.
8. data query method according to claim 6 is it is characterised in that described step 202 also includes:According to receiving
Condition setting instruction, be that each data field at least one of the plurality of data field data field is respectively provided with default looking into
Inquiry condition.
9. the data query method according to any one of claim 6 to 8 is it is characterised in that described preset query condition
Including following at least one or a combination thereof:Subordinate data field to be checked, Field Inquiry condition, field corresponding relation.
10. the data query method according to any one of claim 6 to 8 is it is characterised in that also include:According to default
Represent the data that algorithm will inquire in described at least one subordinate data field with the direct correlation of described main data area, and
Described with there is the data inquiring at least one subordinate data field of subordinate's data field direct correlation of preset query condition,
A form is represented.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310392532.XA CN103488692B (en) | 2013-09-02 | 2013-09-02 | Data query system and data query method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310392532.XA CN103488692B (en) | 2013-09-02 | 2013-09-02 | Data query system and data query method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN103488692A CN103488692A (en) | 2014-01-01 |
CN103488692B true CN103488692B (en) | 2017-02-08 |
Family
ID=49828918
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310392532.XA Active CN103488692B (en) | 2013-09-02 | 2013-09-02 | Data query system and data query method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103488692B (en) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103810273B (en) * | 2014-02-12 | 2018-03-27 | 中国联合网络通信集团有限公司 | A kind of data screening method and device based on cloud computing |
CN105589864A (en) * | 2014-10-22 | 2016-05-18 | 中兴通讯股份有限公司 | Data inquiry method and apparatus |
CN104834756B (en) * | 2015-06-01 | 2018-07-13 | 国家电网公司 | The querying method and device of information in engineering management |
CN107818098A (en) * | 2016-09-12 | 2018-03-20 | 阿里巴巴集团控股有限公司 | A kind of processing method of report data, device and electronic equipment |
CN110008449B (en) * | 2018-01-04 | 2023-07-07 | 北大医疗信息技术有限公司 | Form control linkage method, form control linkage device, computer equipment and readable storage medium |
CN112689157B (en) * | 2020-12-23 | 2022-07-19 | 广东粤科芮银信息科技有限公司 | Method for processing cloud computing resources and wireless communication device |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
IT1244938B (en) * | 1991-03-06 | 1994-09-13 | Ezio Lefons | DATA INTERROGATION SYSTEM IN THE DATABASES AND DATABASES. |
US7640264B1 (en) * | 2005-09-23 | 2009-12-29 | Emc Corporation | System and methods for querying a report database |
CN103092631B (en) * | 2007-04-06 | 2019-02-19 | 西安万年科技实业有限公司 | A kind of data base application system development platform and development approach |
CN101339568B (en) * | 2008-08-21 | 2012-01-25 | 金蝶软件(中国)有限公司 | Method and device for constructing data tree |
CN101751436A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Method and system for generating reports |
CN101673293B (en) * | 2009-10-15 | 2014-01-01 | 金蝶软件(中国)有限公司 | Method and system of joint check of report forms |
CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件(中国)有限公司 | Data management system and data relation query method and device thereof |
CN103092997B (en) * | 2013-02-21 | 2016-03-30 | 用友网络科技股份有限公司 | For interlock inquiry system and the interlock querying method of statement analysis |
-
2013
- 2013-09-02 CN CN201310392532.XA patent/CN103488692B/en active Active
Also Published As
Publication number | Publication date |
---|---|
CN103488692A (en) | 2014-01-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103488692B (en) | Data query system and data query method | |
CN109377066A (en) | A kind of live Schedule monitoring system and method based on threedimensional model | |
JP7014643B2 (en) | Information gathering system | |
CN104460644A (en) | Vehicle fault solution method and device | |
CN105426234B (en) | Database deadlocks detection method and device | |
CN107066500B (en) | Power grid mass data quality verification method based on PMS model | |
CN103606037A (en) | Query and configuration method of business data and device thereof | |
JP2019153051A5 (en) | ||
CN104750496A (en) | Automatic checking method for change influence degree of model | |
CN111142749A (en) | Insurance product issuing method, system and terminal equipment | |
CN103810094B (en) | Execution method, device and the testing tool of a kind of test cases | |
CN101674205B (en) | Method and device for generating network communication protocol test sequence based on finite-state machine | |
CN102955738A (en) | Driving and driven hybrid testing method for simulation system | |
CN104412215B (en) | equipment management device | |
CN110532179A (en) | The method and device of test verifying is carried out in a kind of CBTC test analysis | |
CN117893008A (en) | Risk assessment method and device for coal mine clusters | |
KR101598076B1 (en) | Method of data process for patent evaluation and apparatus of providing data for patent evaluation | |
CN109923484A (en) | Technological design supports device, technological design to support methods and procedures | |
CN107067225A (en) | A kind of approaches to IM and system | |
CN114841519B (en) | Electric power work ticket construction method and device | |
JP5076290B2 (en) | Operation management rule diversion device, operation management rule diversion method, and program | |
CN105701147B (en) | Configurable data shifts managing device | |
CN107656733A (en) | The visible processing method and system of a kind of business object | |
CN101438243A (en) | Multiple stream real time data simulation adapted for a KStore data structure | |
CN109165378A (en) | Sophisticated functions Report Customization method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
COR | Change of bibliographic data | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |