CN105447098A - Information inquiring method and apparatus - Google Patents
Information inquiring method and apparatus Download PDFInfo
- Publication number
- CN105447098A CN105447098A CN201510765199.1A CN201510765199A CN105447098A CN 105447098 A CN105447098 A CN 105447098A CN 201510765199 A CN201510765199 A CN 201510765199A CN 105447098 A CN105447098 A CN 105447098A
- Authority
- CN
- China
- Prior art keywords
- condition
- dimension
- group
- logical relation
- same
- 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
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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present application provides an information inquiring method and apparatus. According to the method, it is required to predefine a dimension tree, wherein the dimension tree has a plurality of hierarchical nodes, a hierarchical node corresponds to a dimension type, a hierarchical node has a plurality of leaf nodes, and a leaf node corresponds to a dimension condition of a dimension type to which the leaf node belongs. The method comprises: selecting a dimension condition from a dimension tree and adding the dimension condition to at least one condition group, wherein one condition group has at least one dimension condition; determining a logical relationship among dimension conditions of condition groups, and determining that a logical relationship among the condition groups is or, to obtain a condition clause; and inquiring a background database for content meeting the condition clause. In addition, according to the present application, the dimension condition in the dimension tree may be dragged to a set area, and the selected dimension condition is displayed in row and column, thereby enabling a user to have a clear knowledge of a relationship among selected dimension conditions and have a better understanding of the selected dimension conditions by using the display manner of row and column.
Description
Technical field
The present invention relates to technical field of data processing, be specifically related to a kind of information query method and device.
Background technology
Along with the development of computer and network technologies, all trades and professions are information-based all gradually, and large data age is stepped in the whole world, from database (as information table etc.), how to find out the major issue that the information wanted becomes everybody concern.
There is the information inquiry mode that a kind of various dimensions condition is inquired about side by side at present, wherein dimension (condition dimension) is used to a generic attribute of reflection business, and the set of this generic attribute forms a dimension, dimension as sex, transaction stroke count etc.; And dimension condition is the conditional expression of a dimension, as sex=" man ", transaction stroke count >15 etc.; The information inquiry mode that various dimensions condition is inquired about side by side, mainly select multiple dimension condition Query Database, Fig. 1 is the schematic diagram of multiple dimension condition, can refer to, selected multiple dimension condition can be mated the content meeting each dimension condition by electronic equipment in background data base, thus obtain Query Result.
The present inventor finds in research process, and the dimension that various dimensions condition is inquired about side by side is generally fixing, can not change, and each dimension can only choose a dimension condition, can not accomplish more complicated, more fine-grained information inquiry.
Summary of the invention
In view of this, the embodiment of the present invention provides a kind of information query method and device, to realize the self-defined of dimension, and realizes choosing of multiple dimension condition of same dimension, make choosing of various dimensions condition more flexible, meet complexity, fine-grained information inquiry demand.
For achieving the above object, the embodiment of the present invention provides following technical scheme:
A kind of information query method, the dimension type of each hierarchy node of pre-defined dimension tree, and define the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence; Described method comprises:
From described dimension tree, choose dimension condition add at least one condition group, a condition group has at least one dimension condition;
Logical relation between each dimension condition determining each condition group, and determine logical relation between each condition group for or, obtain if-clause;
The content conformed to described if-clause is inquired about in background data base.
Wherein, the logical relation between the described each dimension condition determining each condition group comprises:
According to the logical relation that user defines when choosing dimension condition, the logical relation between each dimension condition determining each condition group;
Or, according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group.
Wherein, described dimension condition of choosing from described dimension tree adds at least one condition group and comprises:
Selected dimension condition in described dimension tree is dragged to setting regions, and described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
The condition group that condition group region dimension condition be dragged to is corresponding, is defined as the condition group that dimension condition adds.
Wherein, described method also comprises:
The dimension condition of identical conditions group is arranged on same a line; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition;
Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
Wherein, described method also comprises:
The dimension condition of identical conditions group is arranged on same row; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition;
Different condition groups is arranged on different row; Wherein, the logical relation that the condition group of different lines is set for or.
The embodiment of the present invention also provides a kind of information query device, comprising:
Dimension tree definition module, for the dimension type of each hierarchy node that pre-defined dimension is set, and defines the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence;
Dimension condition chooses module, and add at least one condition group for choosing dimension condition from described dimension tree, a condition group has at least one dimension condition;
If-clause determination module, for determine each condition group each dimension condition between logical relation, and determine logical relation between each condition group for or, obtain if-clause;
Enquiry module, for inquiring about the content conformed to described if-clause in background data base.
Wherein, described if-clause determination module comprises:
Logic determining unit in condition group, for the logical relation defined when choosing dimension condition according to user, the logical relation between each dimension condition determining each condition group; Or, according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group;
Logic determining unit between condition group, for determine logical relation between each condition group for or,
Clause's determining unit, for the logical relation between each dimension condition determining each condition group, and arrange logical relation between each condition group for or after, resolve by each dimension condition of each condition group, the condition tree structure formed with each condition group, obtains if-clause.
Wherein, described dimension condition is chosen module and is comprised:
Pull unit, for selected dimension condition in described dimension tree is dragged to setting regions, described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
Condition group determining unit, the condition group that the condition group region for dimension condition being dragged to is corresponding, is defined as the condition group that dimension condition adds.
Wherein, described device also comprises:
First arrangement module, for being arranged on same a line by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
Wherein, described device also comprises:
Second arrangement module, for being arranged on same row by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different lines be or.
Based on technique scheme, in the information query method that the embodiment of the present invention provides, the dimension condition that the if-clause forming querying condition comprises can be chosen from user-defined dimension tree, and the dimension type of dimension tree and dimension condition all can by User Defineds, therefore the self-defined of the self-defined and dimension condition of inquiry dimension is achieved, the different dimensions condition of same dimension can be chosen in identical conditions group or different condition group simultaneously, and multiple condition group can be inquired about side by side, the various dimensions condition that querying condition is comprised can be chosen more flexibly, realize more complicated, more fine-grained information inquiry.The information query method that the embodiment of the present invention provides, can realize the self-defined of dimension, and realizes choosing of multiple dimension condition of same dimension, makes choosing of various dimensions condition more flexible, meets complexity, fine-grained information inquiry demand.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to the accompanying drawing provided.
Fig. 1 is the schematic diagram of multiple dimension condition;
The structural representation of the dimension tree that Fig. 2 provides for the embodiment of the present invention;
The process flow diagram of the information query method that Fig. 3 provides for the embodiment of the present invention;
What Fig. 4 provided for the embodiment of the present invention chooses the schematic diagram that dimension condition adds condition group;
The arrangement method process flow diagram of dimension condition in the condition group that Fig. 5 provides for the embodiment of the present invention;
The concrete arrangement schematic diagram of dimension condition in the condition group that Fig. 6 provides for the embodiment of the present invention;
Another arrangement method process flow diagram of dimension condition in the condition group that Fig. 7 provides for the embodiment of the present invention;
Another process flow diagram of the information query method that Fig. 8 provides for the embodiment of the present invention;
The schematic diagram of the application examples of the information query method that Fig. 9 provides for the embodiment of the present invention;
The structured flowchart of the information query device that Figure 10 provides for the embodiment of the present invention;
The structured flowchart of the if-clause determination module that Figure 11 provides for the embodiment of the present invention;
Figure 12 chooses the structured flowchart of module for dimension condition that the embodiment of the present invention provides;
Another structured flowchart of the information query device that Figure 13 provides for the embodiment of the present invention;
A structured flowchart again of the information query device that Figure 14 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
The information query method that the embodiment of the present invention provides needs the multiple dimensions expressed by pre-defined dimension tree, and multiple dimension condition that each dimension is corresponding, Fig. 2 shows the structural representation of dimension tree, as shown in Figure 2, dimension tree has root node, root node is arranged with multiple hierarchy node, a corresponding dimension type of hierarchy node, dimension type is dimension 1 as shown in Figure 2, dimension 2, dimension M etc., dimension type can be sex, age etc., a hierarchy node is arranged with multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence (affiliated dimension type is corresponding to the hierarchy node at leaf node place), dimension condition is dimension 1 condition 1 as shown in Figure 2, dimension 1 condition 2 etc., the contents such as the man under the dimension type of dimension condition such as sex,
The level of dimension tree can according to practical situations expansion or reduction, and the level as dimension tree can be 4 layers, 5 layers or more;
In embodiments of the present invention, the dimension type that the hierarchy node of dimension tree is corresponding can by User Defined, and the dimension condition that each leaf node under hierarchy node is corresponding also can by User Defined;
Optionally, when the dimension condition that each leaf node of definition is corresponding, user only can define the particular content of dimension condition, if the particular content defining the dimension condition of the leaf node of this dimension type of age is man or female;
Further, when defining dimension condition corresponding to each leaf node, user, except the particular content of definition dimension condition, goes back definable dimension condition when being called, the logical relation used; As when arranging the particular content of dimension condition, arranging the invoked logical relation of dimension condition is further "AND" or "or";
Obviously, the logical relation that the dimension condition that leaf node is corresponding uses, also in information inquiry process, when this dimension condition is called, can be arranged by user;
Can find out, the information query method that the embodiment of the present invention provides before execution, need pre-define the dimension type of each hierarchy node of dimension tree, and define the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence;
Based on this, Fig. 3 shows the process flow diagram of the information query method that the embodiment of the present invention provides, and the method can be applicable to the electronic equipment that computing machine etc. has data-handling capacity, and with reference to Fig. 3, the method can comprise:
Step S100, choose dimension condition and add at least one condition group from dimension tree, a condition group has at least one dimension condition;
The embodiment of the present invention can, in the interface display setting regions of electronic equipment, be dragged in setting regions, to realize choosing dimension condition by the dimension condition in dimension being set; As shown in Figure 4, setting regions can be divided at least one condition group region, a corresponding condition group in condition group region, and condition group can think the set of circumstances be made up of multiple dimension condition; Setting regions can be boxed area, also can be the region of other shapes;
After dimension condition is dragged to setting regions, the condition group region that the position that identifiable design dimension condition pulls is corresponding in setting regions, thus the condition group that condition group region dimension condition be dragged to is corresponding, be defined as the condition group that dimension condition adds;
In embodiments of the present invention, condition group is at least one, namely only can have a condition group, also can have multiple condition group, dimension condition is selected get condition group after, a condition group can have at least one dimension condition (one or more);
Optionally, except shown employing pulls the mode of the dimension condition in dimension tree to condition group region above, the embodiment of the present invention does not get rid of other mode dimension condition being added condition group, as the condition group etc. that user should be added by the dimension condition chosen in the mode determination dimension trees such as menu.
Step S110, determine each condition group each dimension condition between logical relation, and determine logical relation between each condition group for or, obtain if-clause;
After dimension condition adds condition group, the dimension condition in condition group will be used for formation condition clause, so that carry out the inquiry of information in a database subsequently through if-clause; The embodiment of the present invention need determine the logical relation in condition group between each dimension condition, and the logical relation in condition group between each dimension condition by User Defined, also can be determined according to setting rule; Logical relation in condition group between each dimension condition is mainly "AND" or "or";
Optionally, logical relation between each dimension condition determining each condition group, and arrange logical relation between each condition group for or after, the embodiment of the present invention can obtain each dimension condition by each condition group, the condition tree structure formed with each condition group, by resolving the if-clause that this condition tree structure can obtain for being inquired about;
Obviously, logical relation between each dimension condition determining each condition group, and arrange logical relation between each condition group for or after, the embodiment of the present invention also can logical relation between each dimension condition of Direct Analysis each condition group, and between each condition group or logical relation, analyzes if-clause.
Step S120, the content that inquiry conforms to described if-clause in background data base.
After obtaining if-clause, the embodiment of the present invention can inquire about the content conformed to if-clause in a database, obtains Query Result;
The embodiment of the present invention can realize the inquiry arranged side by side of many condition group, obtains the Query Result arranged side by side of many condition group.
The information query method that the embodiment of the present invention provides, need pre-define the dimension type of each hierarchy node of dimension tree, and define the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence; When carrying out information inquiry, the embodiment of the present invention can be chosen dimension condition and add at least one condition group from described dimension tree, and a condition group has at least one dimension condition; Logical relation between each dimension condition determining each condition group, and determine logical relation between each condition group for or, obtain if-clause; The content conformed to described if-clause is inquired about in background data base.
Can find out, in the information query method that the embodiment of the present invention provides, the dimension condition that the if-clause forming querying condition comprises can be chosen from user-defined dimension tree, and the dimension type of dimension tree and dimension condition all can by User Defineds, therefore the self-defined of the self-defined and dimension condition of inquiry dimension is achieved, the different dimensions condition of same dimension can be chosen in identical conditions group or different condition group simultaneously, and multiple condition group can be inquired about side by side, the various dimensions condition that querying condition is comprised can be chosen more flexibly, realize more complicated, more fine-grained information inquiry.The information query method that the embodiment of the present invention provides, can realize the self-defined of dimension, and realizes choosing of multiple dimension condition of same dimension, makes choosing of various dimensions condition more flexible, meets complexity, fine-grained information inquiry demand.
Optionally, the logical relation that logical relation between each dimension condition of each condition group can define when choosing dimension condition according to user is determined, or, can according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group; The practical operation situation of concrete mode visual user and determining.
Optionally, the logical relation no matter embodiment of the present invention adopts user to define when choosing dimension condition, or user is when the dimension condition that definition leaf node is corresponding, the logical relation of the dimension condition defined, logical relation between each dimension condition determining each condition group, or adopt other modes to define logical relation between each dimension condition of each condition group, the embodiment of the present invention all the mode of row, column can define and represents by the dimension condition selected in condition group;
Accordingly, Fig. 5 shows the arrangement method process flow diagram of dimension condition in the condition group that the embodiment of the present invention provides, and with reference to Fig. 5, the method can comprise:
Step S200, the dimension condition of identical conditions group is arranged on same a line; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition; ;
Step S210, different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
Fig. 6 shows the concrete arrangement schematic diagram of dimension condition in condition group, with reference to Fig. 6, after dimension condition during dimension is set by user is as required dragged to setting regions, at least one condition group will be formed, the relation between each condition group is constructed with the form of condition tree between each condition group, and the relation in condition group between each dimension condition; The mode of row, column can be defined and represent by the dimension condition selected by condition tree; Wherein, with a line independent dimension condition between presentation logic "AND" relation, this with son row same in a line dimension condition between presentation logic "or" relation, and the dimension condition presentation logic "or" relation between different rows;
Independently dimension condition is that the dimension condition set that there is relation in condition group as a whole with the dimension condition of other entirety (only may have a dimension condition in set, also multiple dimension condition may be had), if " dimension 1 condition 1 " in Fig. 6 is an independently dimension condition, and " dimension 2 condition 2or dimension 2 condition 5 " integrally there is relation, therefore " dimension 2 condition 2or dimension 2 condition 5 " looks as a whole, " dimension 2 condition 2or dimension 2 condition 5 " is overall as an independently dimension condition, optionally, the concrete dimension condition independently comprised in dimension condition can be specified when user chooses dimension condition from dimension tree,
As shown in Figure 6, " dimension 1 condition 1 " and " dimension 8 condition 2 " in same a line, the relation between them is logical "and"; " dimension 2 condition 2 " and " dimension 2 condition 5 ", at the same son row of same a line, their entirety is as an independently dimension condition, and the relation therefore between them is logical "or"; Arrange by row between condition group, intergroup relation is all logical "or"; What wherein " dimension 7 condition self-defining value " represented that user selects is hierarchy node " dimension 7 ", then inputs self-defined dimension condition value and logical relation symbol;
Can find out, the if-clause that Fig. 6 expresses is (dimension 1 condition 1and (dimension 2 condition 2or dimension 2 condition 5) and (dimension 8 condition 2or dimension 2 condition 5) and dimension 7 condition self-defining value) or (dimension 4 condition 3and dimension 5 condition 1and (dimension 6 condition 1or dimension 7 condition 1or dimension 6 condition 3)) or (dimension 3 condition 1), wherein and presentation logic "AND", or presentation logic "or"; The embodiment of the present invention can parse if-clause thus pass to backstage from condition tree, realizes the inquiry of information.
Optionally, the relation between the dimension condition that the embodiment of the present invention also can arrange same a line is logical "or", make regulatory components by row arrangement, and intergroup relation is logical "or"; And the relation between the dimension condition of same row is logical "and";
Concrete, Fig. 7 shows another arrangement method process flow diagram of dimension condition in the condition group that the embodiment of the present invention provides, and with reference to Fig. 7, the method can comprise:
Step S300, the dimension condition of identical conditions group is arranged on same row; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition;
Step S310, different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different lines be or.
Preferably, Fig. 8 shows another process flow diagram of the information query method that the embodiment of the present invention provides, the dimension type of each hierarchy node that the method is set based on pre-defined dimension, and defines the situation of the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence;
With reference to Fig. 8, the method can comprise:
Step S400, dimension is set in selected dimension condition be dragged to setting regions, described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
The condition group that step S410, condition group region dimension condition be dragged to are corresponding, be defined as the condition group that dimension condition adds, a condition group has at least one dimension condition;
Step S420, the dimension condition of identical conditions group is arranged on same a line, and the logical relation independently between dimension condition that same a line is set for, described same a line same son row in multiple dimension condition between logical relation be or, multiple dimension condition in the same son row of described same a line are considered as an independently dimension condition, and different condition groups is arranged on different row, and the logical relation that the condition group of different rows is set for or, to construct condition tree;
Step S430, resolve described condition tree, obtain the if-clause corresponding to querying condition;
Step S440, the content that inquiry conforms to described if-clause in background data base.
Optionally, Fig. 9 shows the application examples of the information query method that the embodiment of the present invention provides, and as shown in Figure 9, under the scene of inquiry certain month client credit card consumption information, Fig. 9 lists some dimensions and conditional value; The left side of Fig. 9 is a dimension tree, listed dimension has age, sex, credit card trade stroke count and consumption type, and its interior joint " age <=22 " is a dimension condition; It is the one query pulling rear generation on the right side of Fig. 9, dimension condition is divided into two groups, according to rule, the if-clause of expression is: (age <=22and (sex=male or credit card trade stroke count >8) and consumption type=food and drink class consumption) or (age >30and3< credit card trade stroke count <=8and (consumption type=jewelry consumption or consumption type=food and drink class consumption or consumption type=general merchandise class consumption)).
The information query method that the embodiment of the present invention provides, can realize the self-defined of dimension, and realizes choosing of multiple dimension condition of same dimension, makes choosing of various dimensions condition more flexible, meets complicated inquiry scene or the information inquiry demand of form.
Be introduced the information query device that the embodiment of the present invention provides below, information query device described below can corresponding reference mutual to above-described information query method.
The structured flowchart of the information query device that Figure 10 provides for the embodiment of the present invention, this device can be applicable to the electronic equipment that computing machine etc. has data-handling capacity, and with reference to Figure 10, this device can comprise:
Dimension tree definition module 100, for the dimension type of each hierarchy node that pre-defined dimension is set, and defines the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence;
Dimension condition chooses module 200, and add at least one condition group for choosing dimension condition from described dimension tree, a condition group has at least one dimension condition;
If-clause determination module 300, for determine each condition group each dimension condition between logical relation, and determine logical relation between each condition group for or, obtain if-clause;
Enquiry module 400, for inquiring about the content conformed to described if-clause in background data base.
Optionally, Figure 11 shows a kind of alternate configurations of the if-clause determination module 300 that the embodiment of the present invention provides, and with reference to Figure 11, if-clause determination module 300 can comprise:
Logic determining unit 310 in condition group, for the logical relation defined when choosing dimension condition according to user, the logical relation between each dimension condition determining each condition group; Or, according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group;
Logic determining unit 320 between condition group, for determine logical relation between each condition group for or,
Clause's determining unit 330, for the logical relation between each dimension condition determining each condition group, and arrange logical relation between each condition group for or after, resolve by each dimension condition of each condition group, the condition tree structure formed with each condition group, obtains if-clause.
Optionally, the dimension condition that Figure 12 shows the embodiment of the present invention to be provided chooses a kind of alternate configurations of module 200, and with reference to Figure 12, this dimension condition is chosen module 200 and can be comprised:
Pull unit 210, for selected dimension condition in described dimension tree is dragged to setting regions, described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
Condition group determining unit 220, the condition group that the condition group region for dimension condition being dragged to is corresponding, is defined as the condition group that dimension condition adds.
Optionally, Figure 13 shows another structured flowchart of the information query device that the embodiment of the present invention provides, and shown in Figure 10 and Figure 13, this device can also comprise:
First arrangement module 500, for being arranged on same a line by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
Optionally, Figure 14 shows a structured flowchart again of the information query device that the embodiment of the present invention provides, and shown in Figure 10 and Figure 14, this device can also comprise:
Second arrangement module 600, for being arranged on same row by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different lines be or.
The information query device that the embodiment of the present invention provides, can realize the self-defined of dimension, and realizes choosing of multiple dimension condition of same dimension, makes choosing of various dimensions condition more flexible, meets complicated inquiry scene or the information inquiry demand of form.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar portion mutually see.For device disclosed in embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part illustrates see method part.
Professional can also recognize further, in conjunction with unit and the algorithm steps of each example of embodiment disclosed herein description, can realize with electronic hardware, computer software or the combination of the two, in order to the interchangeability of hardware and software is clearly described, generally describe composition and the step of each example in the above description according to function.These functions perform with hardware or software mode actually, depend on application-specific and the design constraint of technical scheme.Professional and technical personnel can use distinct methods to realize described function to each specifically should being used for, but this realization should not thought and exceeds scope of the present invention.
The software module that the method described in conjunction with embodiment disclosed herein or the step of algorithm can directly use hardware, processor to perform, or the combination of the two is implemented.Software module can be placed in the storage medium of other form any known in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technical field.
To the above-mentioned explanation of the disclosed embodiments, professional and technical personnel in the field are realized or uses the present invention.To be apparent for those skilled in the art to the multiple amendment of these embodiments, General Principle as defined herein can without departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention can not be restricted to these embodiments shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (10)
1. an information query method, is characterized in that, the dimension type of each hierarchy node of pre-defined dimension tree, and defines the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence; Described method comprises:
From described dimension tree, choose dimension condition add at least one condition group, a condition group has at least one dimension condition;
Logical relation between each dimension condition determining each condition group, and determine logical relation between each condition group for or, obtain if-clause;
The content conformed to described if-clause is inquired about in background data base.
2. information query method according to claim 1, is characterized in that, the logical relation between the described each dimension condition determining each condition group comprises:
According to the logical relation that user defines when choosing dimension condition, the logical relation between each dimension condition determining each condition group;
Or, according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group.
3. information query method according to claim 1 and 2, is characterized in that, described dimension condition of choosing from described dimension tree adds at least one condition group and comprises:
Selected dimension condition in described dimension tree is dragged to setting regions, and described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
The condition group that condition group region dimension condition be dragged to is corresponding, is defined as the condition group that dimension condition adds.
4. information query method according to claim 1, is characterized in that, described method also comprises:
The dimension condition of identical conditions group is arranged on same a line; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition;
Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
5. the information query method according to right 1, is characterized in that, described method also comprises:
The dimension condition of identical conditions group is arranged on same row; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition;
Different condition groups is arranged on different row; Wherein, the logical relation that the condition group of different lines is set for or.
6. an information query device, is characterized in that, comprising:
Dimension tree definition module, for the dimension type of each hierarchy node that pre-defined dimension is set, and defines the dimension condition of the leaf node of each hierarchy node; Wherein, described dimension tree has multiple hierarchy node, a corresponding dimension type of hierarchy node, and a hierarchy node has multiple leaf node, a dimension condition under dimension type belonging to a leaf node correspondence;
Dimension condition chooses module, and add at least one condition group for choosing dimension condition from described dimension tree, a condition group has at least one dimension condition;
If-clause determination module, for determine each condition group each dimension condition between logical relation, and determine logical relation between each condition group for or, obtain if-clause;
Enquiry module, for inquiring about the content conformed to described if-clause in background data base.
7. information query device according to claim 6, is characterized in that, described if-clause determination module comprises:
Logic determining unit in condition group, for the logical relation defined when choosing dimension condition according to user, the logical relation between each dimension condition determining each condition group; Or, according to user when defining dimension condition corresponding to leaf node, the logical relation of the dimension condition defined, the logical relation between each dimension condition determining each condition group;
Logic determining unit between condition group, for determine logical relation between each condition group for or,
Clause's determining unit, for the logical relation between each dimension condition determining each condition group, and arrange logical relation between each condition group for or after, resolve by each dimension condition of each condition group, the condition tree structure formed with each condition group, obtains if-clause.
8. the information query device according to claim 6 or 7, is characterized in that, described dimension condition is chosen module and comprised:
Pull unit, for selected dimension condition in described dimension tree is dragged to setting regions, described setting regions is divided at least one condition group region, a corresponding condition group in condition group region;
Condition group determining unit, the condition group that the condition group region for dimension condition being dragged to is corresponding, is defined as the condition group that dimension condition adds.
9. information query device according to claim 7, is characterized in that, described device also comprises:
First arrangement module, for being arranged on same a line by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition with a line be with the multiple dimension condition in the same son row of, described same a line between logical relation be or, the multiple dimension condition during the same son of described same a line arranges are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different rows be or.
10. information query device according to claim 7, is characterized in that, described device also comprises:
Second arrangement module, for being arranged on same row by the dimension condition of identical conditions group; Wherein, the logical relation independently between dimension condition of same row be with, the logical relation between the multiple dimension condition in the same sub-line of described same row be or, the multiple dimension condition in the same sub-line of described same row are considered as an independently dimension condition; Different condition groups is arranged on different row; Wherein, the logical relation of the condition group of different lines be or.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510765199.1A CN105447098B (en) | 2015-11-10 | 2015-11-10 | A kind of information query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510765199.1A CN105447098B (en) | 2015-11-10 | 2015-11-10 | A kind of information query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105447098A true CN105447098A (en) | 2016-03-30 |
| CN105447098B CN105447098B (en) | 2018-12-14 |
Family
ID=55557276
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510765199.1A Active CN105447098B (en) | 2015-11-10 | 2015-11-10 | A kind of information query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105447098B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107729396A (en) * | 2017-09-20 | 2018-02-23 | 上海精数信息科技有限公司 | Data Dynamic Query method and device |
| CN111026469A (en) * | 2018-10-09 | 2020-04-17 | 阿里巴巴集团控股有限公司 | Condition processing method and device and electronic equipment |
| CN111198984A (en) * | 2018-11-16 | 2020-05-26 | 阿里巴巴集团控股有限公司 | User group screening method and device and electronic equipment |
| CN113254812A (en) * | 2021-06-17 | 2021-08-13 | 浙江口碑网络技术有限公司 | Object set generation method and device |
| CN116150436A (en) * | 2023-04-14 | 2023-05-23 | 北京锐服信科技有限公司 | Data display method and system based on node tree |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783495B (en) * | 2019-01-11 | 2021-02-23 | 华青融天(北京)软件股份有限公司 | Multi-dimensional data processing method and device and computer equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1858743A (en) * | 2006-03-10 | 2006-11-08 | 华为技术有限公司 | Information searching method and device in relation ship data bank |
| US20120005242A1 (en) * | 2010-07-01 | 2012-01-05 | Business Objects Software Limited | Dimension-based relation graphing of documents |
| CN102682118A (en) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | Multidimensional data model access method and device |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
-
2015
- 2015-11-10 CN CN201510765199.1A patent/CN105447098B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1858743A (en) * | 2006-03-10 | 2006-11-08 | 华为技术有限公司 | Information searching method and device in relation ship data bank |
| US20120005242A1 (en) * | 2010-07-01 | 2012-01-05 | Business Objects Software Limited | Dimension-based relation graphing of documents |
| CN102682118A (en) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | Multidimensional data model access method and device |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107729396A (en) * | 2017-09-20 | 2018-02-23 | 上海精数信息科技有限公司 | Data Dynamic Query method and device |
| CN107729396B (en) * | 2017-09-20 | 2020-01-31 | 上海精数信息科技有限公司 | Data dynamic query method and device |
| CN111026469A (en) * | 2018-10-09 | 2020-04-17 | 阿里巴巴集团控股有限公司 | Condition processing method and device and electronic equipment |
| CN111026469B (en) * | 2018-10-09 | 2023-04-11 | 阿里巴巴集团控股有限公司 | Condition processing method and device and electronic equipment |
| CN111198984A (en) * | 2018-11-16 | 2020-05-26 | 阿里巴巴集团控股有限公司 | User group screening method and device and electronic equipment |
| CN113254812A (en) * | 2021-06-17 | 2021-08-13 | 浙江口碑网络技术有限公司 | Object set generation method and device |
| CN113254812B (en) * | 2021-06-17 | 2021-09-28 | 浙江口碑网络技术有限公司 | Object set generation method and device |
| CN116150436A (en) * | 2023-04-14 | 2023-05-23 | 北京锐服信科技有限公司 | Data display method and system based on node tree |
| CN116150436B (en) * | 2023-04-14 | 2023-08-08 | 北京锐服信科技有限公司 | Data display method and system based on node tree |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105447098B (en) | 2018-12-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105447098A (en) | Information inquiring method and apparatus | |
| EP3188043B1 (en) | Indirect filtering in blended data operations | |
| US11048714B2 (en) | Data analysis platform for visualizing data according to relationships | |
| US10140737B2 (en) | Dimension reducing visual representation method | |
| US9613086B1 (en) | Graphical user interface for generating and displaying data visualizations that use relationships | |
| US9779150B1 (en) | Systems and methods for filtering data used in data visualizations that use relationships | |
| US9058695B2 (en) | Method of graphically representing a tree structure | |
| CN101504746B (en) | Information processing apparatus, information processing method | |
| US9710527B1 (en) | Systems and methods of arranging displayed elements in data visualizations and use relationships | |
| US10140325B2 (en) | Data source identification mapping in blended data operations | |
| US20070266308A1 (en) | Presenting data to a user in a three-dimensional table | |
| Cerdas et al. | Improved visualization in LCA through the application of cluster heat maps | |
| EP3188042A1 (en) | System and method for performing blended data operations | |
| Dumas et al. | Financevis. net-a visual survey of financial data visualizations | |
| US20150213154A1 (en) | Transitioning cad model data into variant configurations | |
| US20140172826A1 (en) | Social network analyzer | |
| CN106055535A (en) | Method and device for generating charts | |
| CN110738733A (en) | Three-dimensional terrain model generation method, storage medium, processor and electronic device | |
| CN114491113B (en) | Method, apparatus, medium, and device for dynamically adjusting scene effect according to hierarchy | |
| Densham et al. | Supporting visual interactive locational analysis using multiple abstracted topological structures | |
| CN104408184A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN104462440A (en) | Data cube based two-dimensional visual data display method and device | |
| CN104462450A (en) | Data cube based two-dimensional visual data display method and device | |
| CN117853824B (en) | Big data-based 3D sand table projection analysis method | |
| CN104408186A (en) | Two-dimensional visual data display method and device based on data cubes |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |