CN103488692A - Data query system and data query method - Google Patents
Data query system and data query method Download PDFInfo
- Publication number
- CN103488692A CN103488692A CN201310392532.XA CN201310392532A CN103488692A CN 103488692 A CN103488692 A CN 103488692A CN 201310392532 A CN201310392532 A CN 201310392532A CN 103488692 A CN103488692 A CN 103488692A
- Authority
- CN
- China
- Prior art keywords
- data
- data field
- subordinate
- querying condition
- 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.)
- Granted
Links
Images
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 the data query technique field, in particular to a kind of data query system and a kind of data enquire method.
Background technology
In general the technical scheme of existing multistage linking is that a plurality of data fields are designed to respectively to different forms, the corresponding data field of each form, the user need to select data to inquire about the form corresponding from data field as querying condition the form corresponding from main data area, and then will do from data field main data area and inquire about the form that direct relation is arranged with this data field.
This scheme has following three shortcomings:
1. can't realize multistage acquiescence interlock
Because a plurality of data fields are respectively in different forms, so can open the corresponding form from data field when the main data area interlock is inquired about from data field, inquire while thering is the data field of directly linking relation with it and must the user manually complete if want interlock from data field, can't accomplish like this to give tacit consent to a plurality of data fields of continuous interlock.
2. can not realize the branch that links
The interlock of this scheme in general can only occur the principal and subordinate data field both, can not accomplish a plurality of demands from data field of main data area interlock, yet such demand is necessary being really, for example a main data area will link plural from data field usually, wherein one or more from data field as detailed data, another or a plurality of data field as the data field of showing chart, existing technical scheme can not meet such demand.
3. user's experience and system effectiveness are poor
This scheme is all the corresponding data field of a form, must reopen a form in the time of will linking from data field from main data area so, the form that at every turn reopens needs to reopen tab or needs to reopen node, inconvenience all when the user is to the browsing and contrast of data like this.Open in addition a form more and just mean many instance objects, on the internal memory of system and efficiency, all larger taking can be arranged.
Summary of the invention
The present invention just is being based on the problems referred to above, has proposed a kind of data query technique, can in same form, just complete data linkage, and realize multistage acquiescence interlock, and divided data district data query, not needing whole table inquiry, also can be inquired about for a plurality of data fields.
In view of this, the present invention proposes a kind of data query system, comprising: the incidence relation setting unit, for a plurality of data fields being arranged to a form, according to the setting to described statement form, determine the incidence relation between each data field in described a plurality of data field; Whether judging unit, exist default querying condition for judgement and at least one subordinate data field of main data area direct correlation or indirect association; The data field determining unit, for the query statement according to receiving, determine described main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, and, in the situation that described judging unit is judged existence, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition; Query unit, for the default querying condition data query at least one subordinate data field of described and described main data area direct correlation according to described main data area, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
In technique scheme, preferably, also comprise: the condition selected cell, for the condition selection instruction according to receiving, determine the first object querying condition in described default querying condition, and/or according to the condition selection instruction received, determine the second target query condition in described default querying condition, wherein, described data field determining unit is also for determining the first object data field according to described first object querying condition at least one subordinate data field of described and described main data area direct correlation, and/or according to described the second target query condition definite second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition, described query unit also for according to described first object querying condition at described first object data field data query, and/or according to described the second target query condition data query in described the second target data district.
In technique scheme, preferably, also comprise: the condition setting unit, for the condition setting instruction according to receiving, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
In above-mentioned arbitrary technical scheme, preferably, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
In above-mentioned arbitrary technical scheme, preferably, also comprise: represent unit, for according to presetting, representing the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
The application has also proposed a kind of data enquire method, comprising: step 202, a plurality of data fields are arranged in a form, and according to the setting to described statement form, determine the incidence relation between each data field in described a plurality of data field; Step 204, according to the query statement received, determine main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, according to the data query at least one subordinate data field of described and described main data area direct correlation of the default querying condition in described main data area; Step 206, whether there is default querying condition at least one subordinate data field of judgement and the direct correlation of described main data area or indirect association, if exist, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
In technique scheme, preferably, described step 204 also comprises: according to the condition selection instruction received, determine the first object querying condition in described default querying condition, and determine the first object data field at least one subordinate data field of described and described main data area direct correlation according to described first object querying condition, according to described first object querying condition data query in described first object data field; And/or described step 206 also comprises: according to the condition selection instruction received, determine the second target query condition in described default querying condition, and determine the second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition according to described the second target query condition, according to described the second target query condition data query in described the second target data district.
In technique scheme, preferably, described step 202 also comprises: according to the condition setting instruction received, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
In above-mentioned arbitrary technical scheme, preferably, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
In above-mentioned arbitrary technical scheme, preferably, also comprise: according to presetting, represent the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
By above technical scheme, can in same form, just complete data linkage, and realize multistage acquiescence interlock, and divided data district data query, not needing whole table inquiry, also can be inquired about for a plurality of data fields.
The accompanying drawing explanation
Fig. 1 shows the schematic block diagram according to the data query system of the embodiment of the present invention;
Fig. 2 shows the schematic flow diagram according to the data enquire method of the embodiment of the present invention;
Fig. 3 shows the concrete schematic flow diagram according to the data enquire method of the embodiment of the present invention;
Fig. 4 shows the schematic diagram according to the multistage linking of the embodiment of the present invention.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, in the situation that do not conflict, the application's embodiment and the feature in embodiment can combine mutually.
A lot of details have been set forth in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not subject to the restriction of following public specific embodiment.
Data field: the zone of the display data in the form product and to should the zone data set jointly form.
Interlock: interlock occurs in two data intervals, one of them as another number of main data area as from data field.Parameter main data area passed over from data field is filtered the data from data field as querying condition.
Multistage linking: multistage linking usually occurs in two or more data fields, all functions that multistage linking comprises interlock.Also there is the master slave relation of data field in multistage linking, but the master slave relation of multistage linking is relative, when a data zone during as main data area so with this data field exist the data field of direct interaction relation all will become from data field, to become again when data have been filtered in ，Dang Cong data field, data field main data area filter again with this data field have direct relation from data field.
Interlock rule (being equivalent to default querying condition): the interlock rule is the filtration relation in two data intervals and the foundation of transmitting query argument.
Fig. 1 shows the schematic block diagram according to the data query system of the embodiment of the present invention.
As shown in Figure 1, according to the data query system 100 of the embodiment of the present invention, comprise: incidence relation setting unit 102, for a plurality of data fields are arranged to a form, according to the setting to described statement form, determine the incidence relation between each data field in described a plurality of data field; Whether judging unit 104, exist default querying condition for judgement and at least one subordinate data field of main data area direct correlation or indirect association; Data field determining unit 106, for the query statement according to receiving, determine described main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, and, in the situation that described judging unit 104 is judged existence, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition; Query unit 108, for the default querying condition data query at least one subordinate data field of described and described main data area direct correlation according to described main data area, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
In this technical scheme, by a plurality of data fields being arranged in a form, just can determine the interaction relation (being incidence relation) between each data field by this statement form arranged, make a main data area can be associated a plurality of from data field the subordinate data field of main data area direct correlation (with), and each also can be used as the further associated next stage in main data area from data field from data field, by that analogy, can complete the setting of incidence relation between each data field in form, make interlock to carry out for a plurality of data fields.And exist between the data field of incidence relation, can be linked according to the default querying condition in each data field, such as main data area A with have incidence relation from data field B with from data field D, further and from data field C there is incidence relation from data field B, so when initiating combined operation, can be according in main data area A, for the querying condition from data field B, carrying out data query from the B of data field, and according in main data area A, for the querying condition from data field D, carrying out data query from the D of data field, then according to from the B of data field, for the querying condition from data field C, carrying out data query from the C of data field, thereby realized the interlock of a data field to a plurality of data fields, and complete the acquiescence interlock of a plurality of data fields according to the default querying condition in each data field in a form.
Because the data field of being linked all exists in same form, facilitate the user to the checking and contrasting of data, and during interlock also without for different data fields, opening its form, reduced the establishment that repeats of REPORT-OBJECT, also saved the battle achievement of internal memory, system effectiveness has also obtained corresponding raising.
In technique scheme, preferably, also comprise: condition selected cell 110, for the condition selection instruction according to receiving, determine the first object querying condition in described default querying condition, and/or according to the condition selection instruction received, determine the second target query condition in described default querying condition, wherein, described data field determining unit is also for determining the first object data field according to described first object querying condition at least one subordinate data field of described and described main data area direct correlation, and/or according to described the second target query condition definite second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition, described query unit also for according to described first object querying condition at described first object data field data query, and/or according to described the second target query condition data query in described the second target data district.
In this technical scheme, when a data field and a plurality of data field exist direct correlation to concern, there is so the querying condition for the data field of each direct correlation in its default querying condition comprised, such as main data area A and from data field B with from data field D direct correlation, wherein exist for the default querying condition from data field B with for the default querying condition of data field D, user's initial conditions selection instruction as required determines the data field of required inquiry, only make while carrying out combined operation the required data field for the user carry out data query, such as the user has only selected for the default querying condition from data field B, while carrying out combined operation so, only carry out main data area A and from the interlock of data field B, make combined operation have more specific aim, more meet the user required, and without the unwanted data of inquiring user, improved search efficiency.
In technique scheme, preferably, also comprise: condition setting unit 112, for the condition setting instruction according to receiving, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
In above-mentioned arbitrary technical scheme, preferably, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
In this technical scheme, the user can arrange default querying condition as required, change content wherein, such as main data area A is B for comprising subordinate data field to be checked the default querying condition from data field B, the field querying condition is that the field 1 in main data area A equates with the field 1 from the B of data field, and the field from the B of data field 2 is greater than 100, the user can arrange this default querying condition as required so, such as the restriction of deleting " field 2 from the B of data field is greater than 100 ", perhaps will " field 1 in main data area A equates with the field 1 from the B of data field " be revised as " field 2 in main data area A equates with the field 2 from the B of data field ", thereby when making main data area A and from data field B, interlock occurring, it is required that the data that inquire more can meet the user.
In above-mentioned arbitrary technical scheme, preferably, also comprise: represent unit 114, for according to presetting, representing the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
In this technical scheme, the data that inquiry obtains can be presented in a form according to preset algorithm, and preset algorithm can be consistent with the method for product of form, makes the data that represent more meet the product of this form, is convenient to the user and inquired about and contrast.
Fig. 2 shows the schematic flow diagram according to the data enquire method of the embodiment of the present invention.
As shown in Figure 2, according to the data enquire method of the embodiment of the present invention, comprise: step 202, a plurality of data fields are arranged in a form, according to the setting to described statement form, determine the incidence relation between each data field in described a plurality of data field; Step 204, according to the query statement received, determine main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, according to the data query at least one subordinate data field of described and described main data area direct correlation of the default querying condition in described main data area; Step 206, whether there is default querying condition at least one subordinate data field of judgement and the direct correlation of described main data area or indirect association, if exist, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
In this technical scheme, by a plurality of data fields being arranged in a form, just can determine the interaction relation (being incidence relation) between each data field by this statement form arranged, make a main data area can be associated a plurality of from data field the subordinate data field of main data area direct correlation (with), and each also can be used as the further associated next stage in main data area from data field from data field, by that analogy, can complete the setting of incidence relation between each data field in form, make interlock to carry out for a plurality of data fields.And exist between the data field of incidence relation, can be linked according to the default querying condition in each data field, such as main data area A with have incidence relation from data field B with from data field D, further and from data field C there is incidence relation from data field B, so when initiating combined operation, can be according in main data area A, for the querying condition from data field B, carrying out data query from the B of data field, and according in main data area A, for the querying condition from data field D, carrying out data query from the D of data field, then according to from the B of data field, for the querying condition from data field C, carrying out data query from the C of data field, thereby realized the interlock of a data field to a plurality of data fields, and complete the acquiescence interlock of a plurality of data fields according to the default querying condition in each data field in a form.
Because the data field of being linked all exists in same form, facilitate the user to the checking and contrasting of data, and during interlock also without for different data fields, opening its form, reduced the establishment that repeats of REPORT-OBJECT, also saved the battle achievement of internal memory, system effectiveness has also obtained corresponding raising.
In technique scheme, preferably, described step 204 also comprises: according to the condition selection instruction received, determine the first object querying condition in described default querying condition, and determine the first object data field at least one subordinate data field of described and described main data area direct correlation according to described first object querying condition, according to described first object querying condition data query in described first object data field; And/or described step 206 also comprises: according to the condition selection instruction received, determine the second target query condition in described default querying condition, and determine the second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition according to described the second target query condition, according to described the second target query condition data query in described the second target data district.
In this technical scheme, when a data field and a plurality of data field exist direct correlation to concern, there is so the querying condition for the data field of each direct correlation in its default querying condition comprised, such as main data area A and from data field B with from data field D direct correlation, wherein exist for the default querying condition from data field B with for the default querying condition of data field D, user's initial conditions selection instruction as required determines the data field of required inquiry, only make while carrying out combined operation the required data field for the user carry out data query, such as the user has only selected for the default querying condition from data field B, while carrying out combined operation so, only carry out main data area A and from the interlock of data field B, make combined operation have more specific aim, more meet the user required, and without the unwanted data of inquiring user, improved search efficiency.
In technique scheme, preferably, described step 202 also comprises: according to the condition setting instruction received, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
In above-mentioned arbitrary technical scheme, preferably, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
In this technical scheme, the user can arrange default querying condition as required, change content wherein, such as main data area A is B for comprising subordinate data field to be checked the default querying condition from data field B, the field querying condition is that the field 1 in main data area A equates with the field 1 from the B of data field, and the field from the B of data field 2 is greater than 100, the user can arrange this default querying condition as required so, such as the restriction of deleting " field 2 from the B of data field is greater than 100 ", perhaps will " field 1 in main data area A equates with the field 1 from the B of data field " be revised as " field 2 in main data area A equates with the field 2 from the B of data field ", thereby when making main data area A and from data field B, interlock occurring, it is required that the data that inquire more can meet the user.
In above-mentioned arbitrary technical scheme, preferably, also comprise: according to presetting, represent the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
In this technical scheme, the data that inquiry obtains can be presented in a form according to preset algorithm, and preset algorithm can be consistent with the method for product of form, makes the data that represent more meet the product of this form, is convenient to the user and inquired about and contrast.
Fig. 3 shows the concrete schematic flow diagram according to the data enquire method of the embodiment of the present invention.
As shown in Figure 3, according to the data enquire method of the embodiment of the present invention, specifically comprise:
Fig. 4 shows the schematic diagram according to the multistage linking of the embodiment of the present invention.
As shown in Figure 4, data field A and data field B are two combined data districts, and data field C is a detailed data district, and data field D is a chart data district.Based on this interlock rule relation, briefly introduce lower many data fields interlock according to the embodiment of the present application.
Multistage linking to be realized in four data fields in upper figure in same form, need following several steps:
The interlock rule is set, and at first using combined data district A as main data area, the interlock rule arranged on the A data field so comprises A, B, tri-zones of D.The field 1 that the rule of A to B (being that main data area A is for the default querying condition from data field B) can be set to A equates with the field 1 in B, and the value of the field in B 2 is greater than 100, and this is exactly the interlock rule of A to B.Field 1 in the interlock of A to D rule A with the field 1 in D, equate and A in field 3 with the field 3 in D, equate, this is the interlock rule of A to D.Next the interlock rule of B to C is set, and the field 1 that B to C only need arrange in B equates to get final product with the field 1 in C.
Certain data in the A of selection data field, family, system reads rule (being data field A is stored in the A of data field for the default querying condition of its next stage data field) can arranging from the rule of data field A, then rule is carried out to packet transaction, relevant to data field B is one group, relevant to data field D is another group, then analyzes in order.So show respectively that the querying condition of B and D, the condition of B are the first character segment value that first field in B equals user's selected data in A, second field of B is greater than 100.First field that the condition of D is D equates with user's selected data in A, and the 3rd field in D equates with user-selected data.
After all interlock conditions of above-mentioned steps all are parsed, start to carry out the inquiry peek according to condition separately by regional actuator from database.In this process or do a judgement, after completing, this site polling judges whether to support the acquiescence interlock, if otherwise interlock is finished in this zone, if it is need the interlock rule of obtaining this zone to arrange, judgement changes zone and whether has the interlock rule, if exist the interlock rule to continue so second step.Obviously in this example, the D zone has not had the interlock rule to arrange, and the D zone also just is through with so, but but there is interlock setting in the B zone, second step will be repeated in the B zone so, when interlock is regional to C, the C zone has not had interlock setting yet, and the C zone also is through with.
After end that above-mentioned interlock is inquired about and acquiescence links, so whole linkage process is also with regard to remaining having represented, and the thing represented is consistent with the form model, so just do not repeated here.
After the user finishes once interlock, can also continue interlock.Such as the user selects the B zone for main data area now, data have therefrom been selected, can find out so the C that only has that interaction relation is arranged with B, at this moment only need to according to second step just the C zone data from data base querying out and represent, interlock also just is through with.
More than be described with reference to the accompanying drawings technical scheme of the present invention, consider in correlation technique, multistage linking can't be realized multistage acquiescence interlock, can not realize the branch that links, a corresponding data field of form, must reopen a form while linking from data field from main data area, user's experience and system effectiveness are poor.By the application's technical scheme, can in same form, just complete data linkage, and realize multistage acquiescence interlock, and divided data district data query, not needing whole table inquiry, also can be inquired about for a plurality of data fields.
In the present invention, term " first ", " second " be only for describing purpose, and can not be interpreted as indication or hint relative importance.Term " a plurality of " refers to two or more, unless clear and definite restriction separately arranged.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a data query system, is characterized in that, comprising:
The incidence relation setting unit, for a plurality of data fields being arranged to a form, according to the setting to described statement form, determine the incidence relation between each data field in described a plurality of data field;
Whether judging unit, exist default querying condition for judgement and at least one subordinate data field of main data area direct correlation or indirect association;
The data field determining unit, for the query statement according to receiving, determine described main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, and, in the situation that described judging unit is judged existence, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition;
Query unit, for the default querying condition data query at least one subordinate data field of described and described main data area direct correlation according to described main data area, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
2. data query system according to claim 1, is characterized in that, also comprises:
The condition selected cell for the condition selection instruction according to receiving, is determined the first object querying condition in described default querying condition, and/or, according to the condition selection instruction received, determines the second target query condition in described default querying condition,
Wherein, described data field determining unit is also for determining the first object data field according to described first object querying condition at least one subordinate data field of described and described main data area direct correlation, and/or according to described the second target query condition definite second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition, described query unit also for according to described first object querying condition at described first object data field data query, and/or according to described the second target query condition data query in described the second target data district.
3. data query system according to claim 1, is characterized in that, also comprises:
The condition setting unit, for the condition setting instruction according to receiving, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
4. according to the described data query system of any one in claims 1 to 3, it is characterized in that, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
5. according to the described data query system of any one in claims 1 to 3, it is characterized in that, also comprise:
Represent unit, for according to presetting, representing the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
6. a data enquire method, is characterized in that, comprising:
Step 202, be arranged at a plurality of data fields in a form, according to the setting to described statement form, determines the incidence relation between each data field in described a plurality of data field;
Step 204, according to the query statement received, determine main data area in described a plurality of data fields, and at least one subordinate data field of definite and the direct correlation of described main data area, according to the data query at least one subordinate data field of described and described main data area direct correlation of the default querying condition in described main data area;
Step 206, whether there is default querying condition at least one subordinate data field of judgement and the direct correlation of described main data area or indirect association, if exist, determine at least one the subordinate data field with the subordinate's data field direct correlation that has default querying condition, and according to the default querying condition in the subordinate data field of the default querying condition of described existence, data query at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition.
7. data enquire method according to claim 6, it is characterized in that, described step 204 also comprises: according to the condition selection instruction received, determine the first object querying condition in described default querying condition, and determine the first object data field at least one subordinate data field of described and described main data area direct correlation according to described first object querying condition, according to described first object querying condition data query in described first object data field; And/or
Described step 206 also comprises: according to the condition selection instruction received, determine the second target query condition in described default querying condition, and determine the second target data district at least one subordinate data field of described subordinate's data field direct correlation with there being default querying condition according to described the second target query condition, according to described the second target query condition data query in described the second target data district.
8. data enquire method according to claim 6, is characterized in that, described step 202 also comprises: according to the condition setting instruction received, for each data field at least one data field in described a plurality of data fields arranges respectively default querying condition.
9. according to the described data enquire method of any one in claim 6 to 8, it is characterized in that, described default querying condition comprises following at least one or its combination: subordinate data field to be checked, field querying condition, Related fields relation.
10. according to the described data enquire method of any one in claim 6 to 8, it is characterized in that, also comprise: according to presetting, represent the data that algorithm will inquire at least one subordinate data field of described and described main data area direct correlation, data with inquiring in described at least one subordinate data field with there being subordinate's data field direct correlation of presetting querying condition are represented in a form.
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 true CN103488692A (en) | 2014-01-01 |
| CN103488692B 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) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810273A (en) * | 2014-02-12 | 2014-05-21 | 中国联合网络通信集团有限公司 | Data screening method and device based on cloud computing |
| CN104834756A (en) * | 2015-06-01 | 2015-08-12 | 国家电网公司 | Query method and device for information in engineering management |
| CN105589864A (en) * | 2014-10-22 | 2016-05-18 | 中兴通讯股份有限公司 | Data inquiry method and apparatus |
| CN107818098A (en) * | 2016-09-12 | 2018-03-20 | 阿里巴巴集团控股有限公司 | A kind of processing method of report data, device and electronic equipment |
| CN110008449A (en) * | 2018-01-04 | 2019-07-12 | 北大医疗信息技术有限公司 | Form controls interlock method, device, computer equipment and readable storage medium storing program for executing |
| CN112689157A (en) * | 2020-12-23 | 2021-04-20 | 南京石三心网络科技有限公司 | Method for processing cloud computing resources and wireless communication device |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0507744A2 (en) * | 1991-03-06 | 1992-10-07 | Ezio Lefons | Data query system for databases |
| CN101339568A (en) * | 2008-08-21 | 2009-01-07 | 金蝶软件（中国）有限公司 | Method and device for constructing data tree |
| US7640264B1 (en) * | 2005-09-23 | 2009-12-29 | Emc Corporation | System and methods for querying a report database |
| CN101673293A (en) * | 2009-10-15 | 2010-03-17 | 金蝶软件（中国）有限公司 | Method and system of joint check of report forms |
| CN101751436A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Method and system for generating reports |
| CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件（中国）有限公司 | Data management system and data relation query method and device thereof |
| CN103092631A (en) * | 2007-04-06 | 2013-05-08 | 西安万年科技实业有限公司 | Database application system development platform and development method |
| CN103092997A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Linkage query system and linkage query method used for statement analysis |
-
2013
- 2013-09-02 CN CN201310392532.XA patent/CN103488692B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0507744A2 (en) * | 1991-03-06 | 1992-10-07 | Ezio Lefons | Data query system for databases |
| US7640264B1 (en) * | 2005-09-23 | 2009-12-29 | Emc Corporation | System and methods for querying a report database |
| CN103092631A (en) * | 2007-04-06 | 2013-05-08 | 西安万年科技实业有限公司 | Database application system development platform and development method |
| CN101339568A (en) * | 2008-08-21 | 2009-01-07 | 金蝶软件（中国）有限公司 | Method and device for constructing data tree |
| CN101751436A (en) * | 2008-12-19 | 2010-06-23 | 中国移动通信集团山东有限公司 | Method and system for generating reports |
| CN101673293A (en) * | 2009-10-15 | 2010-03-17 | 金蝶软件（中国）有限公司 | 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 |
| CN103092997A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Linkage query system and linkage query method used for statement analysis |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810273A (en) * | 2014-02-12 | 2014-05-21 | 中国联合网络通信集团有限公司 | Data screening method and device based on cloud computing |
| 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 |
| CN104834756A (en) * | 2015-06-01 | 2015-08-12 | 国家电网公司 | Query method and device for information in engineering management |
| 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 |
| CN110008449A (en) * | 2018-01-04 | 2019-07-12 | 北大医疗信息技术有限公司 | Form controls interlock method, device, computer equipment and readable storage medium storing program for executing |
| CN110008449B (en) * | 2018-01-04 | 2023-07-07 | 北大医疗信息技术有限公司 | Form control linkage method, form control linkage device, computer equipment and readable storage medium |
| CN112689157A (en) * | 2020-12-23 | 2021-04-20 | 南京石三心网络科技有限公司 | Method for processing cloud computing resources and wireless communication device |
| CN112689157B (en) * | 2020-12-23 | 2022-07-19 | 广东粤科芮银信息科技有限公司 | Method for processing cloud computing resources and wireless communication device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103488692B (en) | 2017-02-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103488692A (en) | Data query system and data query method | |
| US20180067987A1 (en) | Database capable of integrated query processing and data processing method thereof | |
| CN103377252A (en) | Method and device for data filtration in Internet of Things | |
| CN104050286B (en) | Method and device for providing search result integration | |
| WO2016095365A1 (en) | Authorization processing method and apparatus | |
| WO2016127093A1 (en) | Wire diagram tagging system | |
| KR101201626B1 (en) | Apparatus for genome sequence alignment usting the partial combination sequence and method thereof | |
| CN106777295A (en) | Method and system is recommended in a kind of position search based on semantic matches | |
| CN105868087A (en) | A display method and device for multi-index data in a monitoring system | |
| CN105069694A (en) | Underground pipeline data synchronization method and underground pipeline data synchronization device | |
| CN106202254A (en) | A kind of querying method and data query system | |
| CN101399738B (en) | Method for providing download recommendation service, structured peer-to-peer network and node therein | |
| CN109558750A (en) | A kind of data processing system and method based on multi-party computations | |
| US20150186406A1 (en) | System and method for facilitating interpersonal connections | |
| CN108776660A (en) | A method of the batch based on ArcGIS matches road attribute | |
| KR101129808B1 (en) | Server for providing social Network Service and method for recommending personal connections thereof | |
| CN105262785A (en) | Song pre-ordering method, equipment and system | |
| CN104463460B (en) | Processing method and processing device for the waiting information that network data is launched | |
| CN101674205A (en) | Method and device for generating network communication protocol test sequence based on finite-state machine | |
| CN112699183A (en) | Data processing method, system, readable storage medium and computer equipment | |
| CN105045848B (en) | A kind of data base management system for supporting Boolean expression to inquire | |
| CN103310015A (en) | Method, device and system for searching through mobile terminal | |
| KR101515304B1 (en) | Reduce-side join query processing method for hadoop-based reduce-side join processing system | |
| CN105701147B (en) | Configurable data shifts managing device | |
| CN105761100A (en) | Advertising method according to orientation priority |
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 |