CN102521414A - Data drilling device and data drilling method - Google Patents
Data drilling device and data drilling method Download PDFInfo
- Publication number
- CN102521414A CN102521414A CN2011104482118A CN201110448211A CN102521414A CN 102521414 A CN102521414 A CN 102521414A CN 2011104482118 A CN2011104482118 A CN 2011104482118A CN 201110448211 A CN201110448211 A CN 201110448211A CN 102521414 A CN102521414 A CN 102521414A
- Authority
- CN
- China
- Prior art keywords
- user
- field
- parameter
- selected field
- page address
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data drilling device and a data drilling method. The data drilling device comprises a data setting unit, a parameter processing unit and an inquiry processing unit. The data setting unit is used for grouping fields in a report, selecting a main field in each group, setting a page address and a fixed parameter for each field; the parameter processing unit is used for obtaining the value of the main field in the field group with a field selected by a user as a dynamic parameter corresponding to the field selected by the user after the user selects the value of any field in the report and sends a drilling request; and the inquiry processing unit is used for generating inquiring conditions according to the fixed parameter and the dynamic parameter corresponding to the field selected by the user, and inquiring the report with the page address corresponding to the field selected by the user, thereby completing drilling. By adopting the technical scheme, different field data can be drilled, the association with the fields in other reports can be realized through the main field in the field group, and the report drilling can be simplified.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of data mining device and a kind of data mining method.
Background technology
Drilling through is one of featured function in the form, drills through function through use, can let chain in form of user click fetch and directly open other relevant forms.In the intelligence system like present on line data analysis, so result is arranged: 30 years old to 40 years old the highest product category of customer group's buying rate.The user also need know more detailed result now, has mainly bought which product like them.Utilize technical term, need know this conclusion is according to which data to obtain.Just can realize this moment through what the use form drilled through.But in the time of this result of user click, system will open an independent form, shows the details of supporting this result.It is thus clear that form drills through in Business Intelligence system and also is absolutely necessary.
In MIS, behind form of operation, possibly carry out other form based on this form: so that obtain more how detailed, perhaps more general horizontal comparable out of Memory, this action is called and drills through.
Drilling through function is one of important function in the ERP form, comprises drilling through between the same form different levels (Level): go up and bore (Drill up) and bore (Drill down) down, also have penetrating between the different forms to drill through (Drill through).
Drill through permission and come browsing data to be different from original form rank.It allows in form, fast and simply data to be analyzed.Such as, when the user sees the annual sales amount in certain city, hope further to see that the sales volume or other cities identical with this city size grade in each month in this city compare.Whether perhaps, when the user notices certain product very high profit is arranged, hoping to have a look, the whole classification of this product all is like this.Moreover wherein the profit of certain subsidiary company is particularly outstanding when the user checks the profit of each subsidiary company, and the user hopes to check all relevant informations (like responsible official, address, crew size, sales volume etc.) of this subsidiary company.Such a situation, you just need obtain a form relevant with current form, and such behavior drills through exactly.
General parameterized method realizes joint investigation in form in the industry cycle, data analysis, the Application for Data Mining technology, needs each form to design in advance in other words and can support those key words as interface parameters.There is following problem in this realization:
1, parameter must be confirmed when Report Form Design, can not change, and is difficult to change and expansion;
2, the number of parameter is fixed when report form template designs, and report form showing different parameters quantity does not change;
3, the parameter name is fixed, and parameter can not self-verification;
4, drill through function and relate to a large amount of extra exploitations;
5, it is dangerous to support to drill through form;
6, drilling operation uses temporary table in a large number, differs greatly but the temporary table data of intermediate treatment and target drill through data.
7, the maximum URL length restriction of browser causes drilling through the information transmission and is restricted.
Therefore; The technical scheme that needs a kind of new realization report data to drill through; Assurance can be provided with parameter neatly, and carries out form according to different parameters and drill through, and can guarantee to drill through the accuracy of data; Can not receive the influence of middle table, and can be owing to the maximum URL length of browser has influenced the transmission that drills through data message.
Summary of the invention
Technical matters to be solved by this invention is, the technical scheme that provides a kind of new realization report data to drill through, and assurance can be provided with parameter neatly; And carry out form according to different parameters and drill through; And can guarantee to drill through the accuracy of data, utilize reconstruct querying conditions such as condition, grouping, row information, can extract data again with this condition; So can not receive the influence of middle table, and can be owing to the maximum URL length of browser has influenced the transmission that drills through data message.
In view of this, the present invention provides a kind of data mining device, and comprising: data are provided with the unit, the field in the form is divided into groups, and in each divides into groups, select main fields, for each field is provided with page address, preset parameter; Parameter processing unit, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field; The query processing unit, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.In this technical scheme, can make drilling through of different field data, can be next related with other form fields through its main fields that belongs to the field grouping, and do not need all fields of other forms of direct correlation of each field, realized the simplification that form is drilled through.
In technique scheme; Preferably; Said query processing unit generates SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about, wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.In this technical scheme, can obtain dynamic parameter neatly, guaranteed that the condition that drills through can be flexible and changeable, satisfy user's requirement.
In technique scheme, preferably, said data are provided with the unit and also are the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field; Said query processing unit combines the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.In this technical scheme; Because the title of different field maybe be inequality; Can't find related form field through the field title and drill through, the metadata through different field then can accurately find related form field, has overcome above-mentioned defective.
In technique scheme, preferably, said parameter processing unit also with corresponding preset parameter and the dynamic parameter of said user-selected field, stitchs together with said user-selected field corresponding page address; Said query processing unit parses said user-selected field corresponding page address, preset parameter and dynamic parameter from spliced data, drill through to be used for realization.In technique scheme, send to the backstage after can page address, preset parameter and dynamic parameter being spliced, and accomplish parsing, and use the data that parse to realize drilling through on the backstage.
In technique scheme, preferably, it is that said each field setting drills through information that said data are provided with the unit; Said parameter processing unit is the information that drills through that said user provides said user-selected field correspondence.In technique scheme, through drilling through information, can be when the user carry out drilling operation, how the prompting user operates.
The present invention also provides a kind of data mining method, comprising: step 202, and the field in the form is divided into groups, and in each divides into groups, select main fields; Step 204 is for each field is provided with page address, preset parameter; Step 206, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field; Step 208, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.In this technical scheme, can make drilling through of different field data, can be next related with other form fields through its main fields that belongs to the field grouping, and do not need all fields of other forms of direct correlation of each field, realized the simplification that form is drilled through.
In technique scheme; Preferably; Said step 208 comprises: generate SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about, wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.In this technical scheme, can obtain dynamic parameter neatly, guaranteed that the condition that drills through can be flexible and changeable, satisfy user's requirement.
In technique scheme, preferably, before said step 208, also comprise: be the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field; Said step 208 specifically comprises: combine the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.In this technical scheme; Because the title of different field maybe be inequality; Can't find related form field through the field title and drill through, the metadata through different field then can accurately find related form field, has overcome above-mentioned defective.
In technique scheme, preferably, said step 206 also comprises: with corresponding preset parameter and the dynamic parameter of said user-selected field, stitch together with said user-selected field corresponding page address; Said step 208 also comprises: from spliced data, parse said user-selected field corresponding page address, preset parameter and dynamic parameter, drill through to be used for realization.In technique scheme, send to the backstage after can page address, preset parameter and dynamic parameter being spliced, and accomplish parsing, and use the data that parse to realize drilling through on the backstage.
In technique scheme, preferably, said step 204 also comprises: for said each field setting drills through information; Said step 206 also comprises: the information that drills through that said user-selected field correspondence is provided for said user.In technique scheme, through drilling through information, can be when the user carry out drilling operation, how the prompting user operates.
Through above technical scheme, can realize a kind of data mining device and a kind of data mining method, originality is: 1, Dynamic Packet+dynamically row drills through and uses grouping main fields and column main fields Dynamic matching to confirm the parameter technology when transmitting; 2, the field of form is according to concept grouping, and each grouping is provided with a main fields; 3, utilize Query Information and drill through row and grouping information reconstruct querying condition, rather than based on the intermediate result of temporary table.Utilize form of the present invention can promote user experience, the inquiry that is realized is all based on contextual semanteme, and easy to understand improves report form showing power; From developer's angle; The present invention more automatically drills through associated data for the joint investigation data provide through abstract method and process, promotes development efficiency; Reduce simultaneously development difficulty and workload to a large extent, reduced the cost that Application and Development is promoted.Especially, utilize the good effect of the present invention in the Web form, improved and drill through URL linking secure property.Well solved simultaneously the problem of URL length restriction.
Description of drawings
Fig. 1 is the block diagram of data mining device according to an embodiment of the invention;
Fig. 2 is the process flow diagram of data mining method according to an embodiment of the invention;
Fig. 3 is the work synoptic diagram of data mining method according to an embodiment of the invention;
Fig. 4 is the work synoptic diagram of data mining method according to an embodiment of the invention;
Fig. 5 to Fig. 9 is the work sectional drawing of data mining method according to an embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with accompanying drawing and embodiment.
Set forth a lot of details in the following description so that make much of the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following disclosed specific embodiment.
Fig. 1 is the block diagram of data mining device according to an embodiment of the invention.
As shown in Figure 1, the present invention provides a kind of data mining device 100, comprising: data are provided with unit 102, the field in the form is divided into groups, and in each divides into groups, select main fields, for each field is provided with page address, preset parameter; Parameter processing unit 104, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field; Query processing unit 106, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.In this technical scheme, can make drilling through of different field data, can be next related with other form fields through its main fields that belongs to the field grouping, and do not need all fields of other forms of direct correlation of each field, realized the simplification that form is drilled through.
In technique scheme; Said query processing unit 106 generates SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about; Wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.In this technical scheme, can obtain dynamic parameter neatly, guaranteed that the condition that drills through can be flexible and changeable, satisfy user's requirement.
In technique scheme, said data are provided with unit 102 and also are the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field; Said query processing unit 106 combines the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.In this technical scheme; Because the title of different field maybe be inequality; Can't find related form field through the field title and drill through, the metadata through different field then can accurately find related form field, has overcome above-mentioned defective.
In technique scheme, said parameter processing unit 104 also with corresponding preset parameter and the dynamic parameter of said user-selected field, stitchs together with said user-selected field corresponding page address; Said query processing unit 106 parses said user-selected field corresponding page address, preset parameter and dynamic parameter from spliced data, drill through to be used for realization.In technique scheme, send to the backstage after can page address, preset parameter and dynamic parameter being spliced, and accomplish parsing, and use the data that parse to realize drilling through on the backstage.
In technique scheme, said data are provided with unit 102 and drill through information for said each field setting; Said parameter processing unit 104 provides the information that drills through of said user-selected field correspondence for said user.In technique scheme, through drilling through information, can be when the user carry out drilling operation, how the prompting user operates.
Fig. 2 is the process flow diagram of data mining method according to an embodiment of the invention.
As shown in Figure 2, the present invention also provides a kind of data mining method, comprising: step 202, and the field in the form is divided into groups, and in each divides into groups, select main fields; Step 204 is for each field is provided with page address, preset parameter; Step 206, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field; Step 208, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.In this technical scheme, can make drilling through of different field data, can be next related with other form fields through its main fields that belongs to the field grouping, and do not need all fields of other forms of direct correlation of each field, realized the simplification that form is drilled through.
In technique scheme; Said step 208 comprises: generate SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about; Wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.In this technical scheme, can obtain dynamic parameter neatly, guaranteed that the condition that drills through can be flexible and changeable, satisfy user's requirement.
In technique scheme, before said step 208, also comprise: be the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field; Said step 208 specifically comprises: combine the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.In this technical scheme; Because the title of different field maybe be inequality; Can't find related form field through the field title and drill through, the metadata through different field then can accurately find related form field, has overcome above-mentioned defective.
In technique scheme, said step 206 also comprises: with corresponding preset parameter and the dynamic parameter of said user-selected field, stitch together with said user-selected field corresponding page address; Said step 208 also comprises: from spliced data, parse said user-selected field corresponding page address, preset parameter and dynamic parameter, drill through to be used for realization.In technique scheme, send to the backstage after can page address, preset parameter and dynamic parameter being spliced, and accomplish parsing, and use the data that parse to realize drilling through on the backstage.
In technique scheme, said step 204 also comprises: for said each field setting drills through information; Said step 206 also comprises: the information that drills through that said user-selected field correspondence is provided for said user.In technique scheme, through drilling through information, can be when the user carry out drilling operation, how the prompting user operates.
In following examples; Detailed description is according to data mining method of the present invention, and main points are: on the basis based on metadata, bring data into as drilling through automatically through drilling through the parameter+Dynamic Packet+information of dynamically going; Thereby reduce form greatly and drill through number of parameters; Improve the dirigibility that form bores, the verification of parameter legitimacy is provided simultaneously, improve the robustness of Web form; Reduce parameter and resolved and the verification difficulty, reduced the development amount.The data mining method of present embodiment not only is applicable to the data mining based on the MIS of Web structure, also good utilization can be arranged for the data mining based on C/S, and better effects if.
At first the noun of using in the technical scheme of the present invention is made an explanation:
Field is in groups: be meant that a plurality of form attribute fields of describing a things or object to time in the form are divided into a set, this aggregation process is exactly in groups.For example on a commercial order commodity code is arranged, information such as title, specification, and these fields are described commodity simultaneously, at this time we put together " commodity code, title, specification " becomes a combination.
Main fields in groups: be meant topmost field in becoming group field, generally be used for object of unique sign or things, like the commodity code in " commodity code, title, specification ".
Row grouping information: be meant at the meeting in group summary table and gather the grouping field information that calculating accordings to.
Joint investigation row grouping information: be meant that current line grouping information correspondence becomes main fields title in the group field in the grouping summary sheet.
Joint investigation row information: be meant the corresponding value that becomes the corresponding current line of main fields in the group field of in grouping summary sheet current line grouping information.
In the present embodiment, the whole thinking that design data drills through method is following:
For dirigibility and the extendability that improves joint investigation; Present embodiment need provide the parameter that complete metadata support drills through crucial dictionary, in conjunction with this dictionary provide one be enclosed within the independent operating outside the operation system mechanism organize, control, check and drill through parameter and drill through data.
In order to realize and address the above problem that needs are realized following steps in the present embodiment:
1) metadata is set:
A) be arranged to group field and main fields thereof, and, be used to discern the practical business implication data major key of joint investigation for becoming group field and main fields thereof that metadata is set;
B) setting drills through information, comprises URL, drills through parameter.
2) assembling drills through condition according to grouping boss name section:
A) when generating the source form, the metadata current group information and step 1) setting is combined into the complete URL of drilling through, and comprises grouping information, purpose form URL and parameter.
3) the grouping main fields is resolved and verification, is treated to the Where conditional statement of SQL standard:
A) handle the information of joint investigation here, initial conditions is the information that comprises grouping field in the capable condition of current joint investigation, the value of the main fields that current line shows, output result be can be directly as the WhereSQL of Where condition.
4) extract and represent and drill through data:
Promptly extract and demonstrating data from the target form.
5) aid of a configure metadata is set:
Be completing steps 1) required aid.
According to above mentality of designing, as shown in Figure 3, set forth the performing step that form drills through method below:
1) the form field is sorted out in groups:
A, according to business demand, extract involved attribute in the form;
B, the described entity character of the attribute of putting in order out according to a are sorted out, and make one group to one type field;
C, select critical field according to the field of b arrangement and put out the conceptual dependency field in order, and the main fields of selected this group;
D, polymerization calculated field independent separately (the polymerization field generally is the numeric type field, also comprises fields such as maximizing, minimum value, average) in groups finally obtain dividing into groups and field metadata 304.
For example:
Client's merchandise sales statistical report form has following field: date, encoder client, customer name, commodity code, trade name, commercial specification, quantity, unit price, the amount of money.
Encoder client, customer name are described client's character attribute jointly, and pretending is one group:
Similarly, commodity code, trade name, commercial specification is as one group;
Date separately in groups;
The aggretion type field as: quantity, unit price, the amount of money separately in groups, and with the final generator data of foregoing.
2) according to business demand, it is prefabricated according to becoming the group field main fields to carry out joint investigation needs to be connected the object of looking into, and prefabricated content comprises joint investigation URL, preset parameter, running parameter, joint investigation prompting or the like (foregoing is being joint investigation URL302 shown in Fig. 3);
3) in the source during report generation, according to 1), 2) step is main fields and the prefabricated content assembling of joint investigation, forms the joint investigation condition;
4) when the user sends that connecting makes a thorough investigation of asks, when promptly clicking the joint investigation condition that step 3) forms, information and row grouping information are spliced among the URL at once preset parameter, dynamic parameter.
5) drill through the condition assembling:
A) separately joint investigation URL, preset parameter, dynamic parameter;
B) generate WhereSQL statement 306 to preset parameter, running parameter according to standard;
The main fields of c) sort out can form as the branch set condition and row major word segment value of row:
WhereSQL=" and [main fields title]=' major word segment value ' ";
6) drill through representing and extracting of data:
Be the target form, utilize the WhereSQL condition of step 5),, utilize the column metadata 308 of purpose table table to represent the business datum 310 that drills through gained as the condition that drills through.
According to Fig. 4, the performing step of data mining method in computer system of present embodiment is following:
1), unifies standard to service concept in the application software system, and referent is named according to the form demand;
2) according to 1) the title setting confirmed of step is grouped into group field, and main fields is set, and is predisposed to metadata;
3) behind the generation form, generate current line and the current group information of joint investigation URL;
4) when joint investigation takes place, 3) URL that generates carries out verification, and translation becomes the Where condition according to metadata;
5) utilize the data of Where condition query target form to reach the purpose that drills through.
Wherein, step 4) specifically comprises:
Browser sends the request of drilling through; The parameter group arrangement drills through parameter and sends back to browser according to drilling through request assembling, and browser is opened new page, and will assemble drill through parameter as request of data; Send to the service of new form backstage; The backstage service is resolved the components request parameter interpretation to parameter, and the parameter resolution component generates the WhereSQL statement according to parameter, sends to data and inquires about.
An applicating example according to data mining method of the present invention is following:
1, grouping field and its main fields are set, as shown in Figure 5, a plurality of fields are set to one group (in right side " object properties in groups ") in " stock ", and " IDInventory " is set to main fields;
2, the mode that gathers grouping is set, as shown in Figure 6, such as the situation of the sale outbound of analyzing enterprise, we divide into groups according to " warehouse+client+stock ".
3, after configuration was accomplished, the user can inquire about on form as shown in Figure 7, for different clients, can laterally contrast, and similar client is analyzed overview on year-on-year basis; For the price situation, can drill through downwards, understand details.
4, see same warehouse (branch) like us, hope to understand its client's lateral comparison, as shown in Figure 8, be that the client in the same warehouse compares.
5, see that like us the amount of money of stock 3005 is very big, hope to understand details wherein that it is as shown in Figure 9 finally to drill through the result.
Say from customer experience that 6, demonstrated fully the effect of " bore and gained ", easy to understand can " bore " everywhere.
7, because these joint investigation target forms and parameter all are based on the joint investigation metadata, so need not write any joint investigation code.
Through above technical scheme, can realize a kind of data mining device and a kind of data mining method, uniqueness wherein of the present invention is: 1, the target form of joint investigation can dynamically generate according to business object; 2, the parameter of joint investigation is based on that the current line of branch set condition and the joint investigation of inquiry dynamically forms; 3, Dynamic Packet+dynamically row drills through and uses grouping main fields and column boss section Dynamic matching to confirm the parameter technology when transmitting; 4, grouping main fields, column main fields notion; Utilize form of the present invention can greatly promote the ability that drills through of form; More automatically drill through associated data, promote development efficiency, reduced development difficulty and workload simultaneously to a large extent; Reduce the cost that Application and Development is promoted, can also improve report form showing power.Especially, the good effect of utilizing the present invention in the Web form, to go has well solved the problem of URL length restriction.Utilize the good effect of the present invention in the Web form, improved and drill through URL linking secure property, well solved the problem of URL length restriction simultaneously.For most of users, the browser that they use is the IE browser, and the maximum URL length restriction of IE is 2083 bytes, and actual operable maximum length is 2048 bytes.That is to say, in Web uses, transmit parameter and all row information through the mode of URL fully, the situation of URL overlength can occur.Utilize in groups main fields to do parameter, reduced the quantity of transmitting parameter in a large number.Utilize present technique when the same IE of use makees browser, can let the user carry out complicated more, finer minute group polling and carry out joint investigation.
The above is merely the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data mining device is characterized in that, comprising:
Data are provided with the unit, the field in the form is divided into groups, and in each divides into groups, select main fields, for each field is provided with page address, preset parameter;
Parameter processing unit, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field;
The query processing unit, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.
2. data mining device according to claim 1; It is characterized in that; Said query processing unit generates SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about, wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.
3. data mining device according to claim 1 is characterized in that, said data are provided with the unit and also are the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field;
Said query processing unit combines the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.
4. data mining device according to claim 1 is characterized in that, said parameter processing unit also with corresponding preset parameter and the dynamic parameter of said user-selected field, stitchs together with said user-selected field corresponding page address;
Said query processing unit parses said user-selected field corresponding page address, preset parameter and dynamic parameter from spliced data, drill through to be used for realization.
5. according to each described data mining device in the claim 1 to 4, it is characterized in that it is that said each field setting drills through information that said data are provided with the unit;
Said parameter processing unit is the information that drills through that said user provides said user-selected field correspondence.
6. a data mining method is characterized in that, comprising:
Step 202 is divided into groups to the field in the form, and in each divides into groups, selects main fields;
Step 204 is for each field is provided with page address, preset parameter;
Step 206, when the user selected in the said form value in any field to send to drill through request, the value of the main fields during the field of obtaining said user-selected field place is divided into groups was as the corresponding dynamic parameter of said user-selected field;
Step 208, the preset parameter and dynamic parameter composition querying condition corresponding according to said user-selected field, and the form of obtaining said user-selected field corresponding page address inquires about, and drills through with completion.
7. data mining method according to claim 6; It is characterized in that; Said step 208 comprises: generate SQL statement according to said user-selected field corresponding page address, preset parameter and dynamic parameter; So that the form of said user-selected field corresponding page address is inquired about, wherein, generate the Where condition in the said SQL statement according to corresponding preset parameter and the dynamic parameter of said user-selected field.
8. data mining method according to claim 6 is characterized in that, before said step 208, also comprises:
Be the main fields in said each grouping, said each grouping and page address, preset parameter and the dynamic parameter generator data of said each field;
Said step 208 specifically comprises: combine the corresponding preset parameter of said user-selected field and dynamic parameter and metadata separately; Generate querying condition; In conjunction with said user-selected field corresponding page address and metadata thereof, obtain form to be looked into and inquire about, drill through with completion.
9. data mining method according to claim 6 is characterized in that, said step 206 also comprises:
With corresponding preset parameter and the dynamic parameter of said user-selected field, stitch together with said user-selected field corresponding page address;
Said step 208 also comprises: from spliced data, parse said user-selected field corresponding page address, preset parameter and dynamic parameter, drill through to be used for realization.
10. according to each described data mining method in the claim 6 to 9, it is characterized in that said step 204 also comprises: for said each field setting drills through information;
Said step 206 also comprises: the information that drills through that said user-selected field correspondence is provided for said user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110448211.8A CN102521414B (en) | 2011-12-28 | 2011-12-28 | Data mining device and data mining method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110448211.8A CN102521414B (en) | 2011-12-28 | 2011-12-28 | Data mining device and data mining method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102521414A true CN102521414A (en) | 2012-06-27 |
| CN102521414B CN102521414B (en) | 2016-05-18 |
Family
ID=46292327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110448211.8A Active CN102521414B (en) | 2011-12-28 | 2011-12-28 | Data mining device and data mining method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521414B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150400A (en) * | 2013-03-27 | 2013-06-12 | 领航动力信息系统有限公司 | MapReduce-framework-based data screening method |
| CN103678401A (en) * | 2012-09-21 | 2014-03-26 | 金蝶软件（中国）有限公司 | Metadata based report group summarizing method and device |
| CN105760406A (en) * | 2014-12-19 | 2016-07-13 | 中国科学院深圳先进技术研究院 | Method for extracting characteristic data in data mining technique |
| CN107145492A (en) * | 2016-03-01 | 2017-09-08 | 中兴通讯股份有限公司 | Resource trephination and device |
| CN109033339A (en) * | 2018-07-23 | 2018-12-18 | 深圳智慧园区信息技术有限公司 | A kind of method, device and equipment for recommending policy for user |
| CN110019356A (en) * | 2017-09-28 | 2019-07-16 | 北京国双科技有限公司 | Data query method and device |
| CN113268491A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Universal method for realizing data up-rolling and down-drilling |
| CN113779044A (en) * | 2021-11-08 | 2021-12-10 | 南京网眼信息技术有限公司 | Data drilling method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101271447A (en) * | 2007-11-23 | 2008-09-24 | 金蝶软件（中国）有限公司 | Method and system for completing report forms analysis |
| CN101446964A (en) * | 2008-12-31 | 2009-06-03 | 中国建设银行股份有限公司 | Method of data mining and computer device |
| CN101556605A (en) * | 2009-05-13 | 2009-10-14 | 用友软件股份有限公司 | Free penetrating method of report data based on two-dimensional query model and system thereof |
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
| US20100153333A1 (en) * | 2008-12-17 | 2010-06-17 | Rasmussen Glenn D | Method of and System for Managing Drill-Through Source Metadata |
| US20100153417A1 (en) * | 2008-12-17 | 2010-06-17 | Rasmussen Glenn D | Method of and System for Managing Drill-Through Targets |
| CN102171648A (en) * | 2008-10-07 | 2011-08-31 | 渣普控股有限公司 | Synchronization of relational databases with OLAP cubes |
-
2011
- 2011-12-28 CN CN201110448211.8A patent/CN102521414B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101271447A (en) * | 2007-11-23 | 2008-09-24 | 金蝶软件（中国）有限公司 | Method and system for completing report forms analysis |
| CN102171648A (en) * | 2008-10-07 | 2011-08-31 | 渣普控股有限公司 | Synchronization of relational databases with OLAP cubes |
| US20100153333A1 (en) * | 2008-12-17 | 2010-06-17 | Rasmussen Glenn D | Method of and System for Managing Drill-Through Source Metadata |
| US20100153417A1 (en) * | 2008-12-17 | 2010-06-17 | Rasmussen Glenn D | Method of and System for Managing Drill-Through Targets |
| CN101446964A (en) * | 2008-12-31 | 2009-06-03 | 中国建设银行股份有限公司 | Method of data mining and computer device |
| CN101556605A (en) * | 2009-05-13 | 2009-10-14 | 用友软件股份有限公司 | Free penetrating method of report data based on two-dimensional query model and system thereof |
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678401A (en) * | 2012-09-21 | 2014-03-26 | 金蝶软件（中国）有限公司 | Metadata based report group summarizing method and device |
| CN103150400A (en) * | 2013-03-27 | 2013-06-12 | 领航动力信息系统有限公司 | MapReduce-framework-based data screening method |
| CN103150400B (en) * | 2013-03-27 | 2017-06-06 | 领航动力信息系统有限公司 | A kind of data screening method based on MapReduce frameworks |
| CN105760406A (en) * | 2014-12-19 | 2016-07-13 | 中国科学院深圳先进技术研究院 | Method for extracting characteristic data in data mining technique |
| CN105760406B (en) * | 2014-12-19 | 2019-01-22 | 中国科学院深圳先进技术研究院 | Method for extracting characteristic in data mining technology |
| CN107145492A (en) * | 2016-03-01 | 2017-09-08 | 中兴通讯股份有限公司 | Resource trephination and device |
| CN110019356A (en) * | 2017-09-28 | 2019-07-16 | 北京国双科技有限公司 | Data query method and device |
| CN110019356B (en) * | 2017-09-28 | 2021-06-01 | 北京国双科技有限公司 | Data query method and device |
| CN109033339A (en) * | 2018-07-23 | 2018-12-18 | 深圳智慧园区信息技术有限公司 | A kind of method, device and equipment for recommending policy for user |
| CN113268491A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Universal method for realizing data up-rolling and down-drilling |
| CN113779044A (en) * | 2021-11-08 | 2021-12-10 | 南京网眼信息技术有限公司 | Data drilling method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102521414B (en) | 2016-05-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102521414A (en) | Data drilling device and data drilling method | |
| US7761478B2 (en) | Semantic business model management | |
| US7216340B1 (en) | Analysis data validation tool for use in enterprise architecture modeling with result based model updating | |
| US9721207B2 (en) | Generating written content from knowledge management systems | |
| US7424702B1 (en) | Data integration techniques for use in enterprise architecture modeling | |
| EP2243091B1 (en) | Method and system for storing and retrieving characters, words and phrases | |
| Bhargava et al. | Decision support systems and web technologies: a status report | |
| EP1890260A1 (en) | Object oriented system and method for optimizing the execution of marketing segmentations | |
| US20110173529A1 (en) | Template processing engine for business systems | |
| CN102880694A (en) | Browser client and method for loading classified channels in new tab | |
| CN103605528A (en) | Service development method and device | |
| CN110502520A (en) | A kind of method of data loading, system, equipment and computer readable storage medium | |
| US7966601B2 (en) | Generating web service without coding logic with a programming language | |
| Lytvyn et al. | Intelligent system structure for Web resources processing and analysis | |
| US20110078569A1 (en) | Value help user interface system and method | |
| CN101464871A (en) | Report query collocation system and method | |
| CN111382256A (en) | Information recommendation method and device | |
| CN105354344A (en) | SEO (search engine optimization) system and method | |
| CN108701153B (en) | Method, system and computer readable storage medium for responding to natural language query | |
| CN106055629A (en) | Single well information management system | |
| CN107301211B (en) | Online data processing method | |
| US20080046416A1 (en) | Dynamic program support links | |
| Chang et al. | An evaluation of implementing Koha in a Chinese language environment | |
| CN104978379A (en) | Method and device for building application program information station | |
| US10628860B2 (en) | System and method for creation of visual job advertisements |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |