CN109376177A - A kind of data mining analysis method - Google Patents
A kind of data mining analysis method Download PDFInfo
- Publication number
- CN109376177A CN109376177A CN201811155013.0A CN201811155013A CN109376177A CN 109376177 A CN109376177 A CN 109376177A CN 201811155013 A CN201811155013 A CN 201811155013A CN 109376177 A CN109376177 A CN 109376177A
- Authority
- CN
- China
- Prior art keywords
- query
- node
- data
- electric power
- information system
- 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
- 238000007418 data mining Methods 0.000 title claims abstract description 14
- 238000004458 analytical method Methods 0.000 title claims abstract description 8
- 241001074085 Scophthalmus aquosus Species 0.000 claims abstract description 15
- 238000013480 data collection Methods 0.000 claims abstract description 13
- 238000005553 drilling Methods 0.000 claims abstract description 7
- 238000012360 testing method Methods 0.000 claims abstract description 7
- 238000012546 transfer Methods 0.000 claims description 3
- 241001269238 Data Species 0.000 abstract description 2
- 238000000034 method Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data mining analysis methods, to solve the technical issues of inquiry of electric power service information system detailed data cannot achieve inter-library customization inquiry in the prior art, comprising the following steps: S1: creation logical data base；S2: creating tree-shaped class node, and fills in nodal basis information；S3: SQL query statement is write, and carries out compiler test；S4: it according to query demand, determines query argument, configures drilling parameters；S5: judged whether to need to be arranged lower brill data set, when boring node data collection under determining to need to be arranged, continuation step S6 according to query demand；S6: configuration is lower to bore node data collection；S7: exporting and shows query result.Compared with prior art, by drilling through and lower brill, the present invention realizes the inter-library customization inquiry of different electric power service information system detailed datas, improves search efficiency.
Description
Technical field
The present invention relates to electric power service information system data inquiring technology fields more particularly to one kind can be to power business
The data mining analysis method of data of information system progress customizable inquiry.
Background technique
Currently, various businesses information system is stood in great numbers in Utilities Electric Co.'s system, and various businesses with the development of electrical network business
Information system all independently possesses respective database, and the interface disunity of the database of each operating information system cannot achieve
Seriously there is the phenomenon that " information island " between each operating information system in the shared perforation of data；Therefore, business personnel is inquiring
When the detailed data of different business systems, different operating information systems can only be respectively enterd and repeatedly inquired, cannot achieve
Inter-library inquiry also cannot achieve the customization inquiry for customer demand, cause many and diverse search efficiency of query process low.Cause
This, needs to improve such status.
Summary of the invention
It cannot achieve inter-library customization inquiry to solve electric power service information system detailed data inquiry in the prior art
Technical problem, the present invention provide a kind of data mining analysis method, to realize inter-library and customize inquiry, improve search efficiency.
In order to solve the above technical problems, data mining analysis method provided by the invention, comprising the following steps:
S1: creation logical data base passes through according to the incidence relation between each electric power service information system database table
The database of each electric power service information system is associated by the main external key of each electric power service information system database table,
It is stored in logical data base；
S2: receiving user query demand, creates tree-shaped class node according to query demand, and fill in nodal basis information；
S3: according to query demand, corresponding SQL query statement is write, and test is compiled by logical data base；
S4: according to user query demand, query argument is determined；
Query argument is inquired the parameters such as the data on which date, how to be shown etc.；
S5: configuring drilling parameters according to query argument, and the database for the electric power service information system for needing to connect is connected
The SQL query statement that information passes through with compiler test in step S3 is associated configuration, the configuration information as data mining；
S6: judged whether to need to be arranged lower brill node data collection according to query demand；Node is bored in the case where determining to need to be arranged
When data set, continue step S7；When boring node data collection under determining not needing to be arranged, continue step S8；
Lower brill node data collection, i.e. the data detail of next node.
S7: configuration is lower to bore node data collection, and carries out lower brill node associated configuration, will be upper by way of Transfer Parameters
One node valid data are transferred in lower brill querying node parameter, realize data mining function；
The valid data of a upper node, i.e., the query argument about next node detailed data provided in a upper node.
S8: exporting and shows query result.
Beneficial effect of the present invention includes:
Compared with the mode that user in the prior art can only be inquired one by one from each electric power service information system, this hair
The method of bright offer realizes inter-library inquiry, improves by the way that the database table of each electric power service information system to be associated
Search efficiency；And by drilling through and lower brill, the inter-library customization for realizing different electric power service information system detailed datas are looked into
It askes.
Other features and advantage will illustrate in the following description, also, partly become from specification
It obtains it is clear that being understood and implementing the application.The purpose of the application and other advantages can be by written explanations
Structure specifically noted by book, claims is achieved and obtained.
Specific embodiment
Data mining analysis method provided by the invention, comprising the following steps:
S1: creation logical data base passes through according to the incidence relation between each electric power service information system database table
The database of each electric power service information system is associated by the main external key of each electric power service information system database table,
It is stored in logical data base；
S2: receiving user query demand, creates tree-shaped class node according to query demand, and fill in nodal basis information；
S3: according to query demand, corresponding SQL query statement is write, and test is compiled by logical data base；
S4: according to user query demand, query argument is determined；
Query argument is inquired the parameters such as the data on which date, how to be shown etc.；
S5: configuring drilling parameters according to query argument, and the database for the electric power service information system for needing to connect is connected
The SQL query statement that information passes through with compiler test in step S3 is associated configuration, the configuration information as data mining；
S6: judged whether to need to be arranged lower brill node data collection according to query demand；Node is bored in the case where determining to need to be arranged
When data set, continue step S7；When boring node data collection under determining not needing to be arranged, continue step S8；
Lower brill node data collection, i.e. the data detail of next node.
S7: configuration is lower to bore node data collection, and carries out lower brill node associated configuration, will be upper by way of Transfer Parameters
One node valid data are transferred in lower brill querying node parameter, realize data mining function；
The valid data of a upper node, i.e., the querying condition about next node detailed data provided in a upper node.
S8: exporting and shows query result.
In conclusion scheme provided in an embodiment of the present invention, can only believe with user in the prior art from each power business
The mode that breath system is inquired one by one is compared, real by the way that the database table of each electric power service information system to be associated
Show inter-library inquiry, improves search efficiency；And by drilling through and lower brill, different electric power service information system detail numbers are realized
According to inter-library customization inquiry.
Obviously, various changes and modifications can be made to the invention without departing from essence of the invention by those skilled in the art
Mind and range.In this way, if these modifications and changes of the present invention belongs to the range of the claims in the present invention and its equivalent technologies
Within, then the present invention is also intended to include these modifications and variations.
Claims (1)
1. a kind of data mining analysis method, which comprises the following steps:
S1: creation logical data base, according to the incidence relation between each electric power service information system database table, by each
The database of each electric power service information system is associated by the main external key of electric power service information system database table, is saved
In logical data base；
S2: receiving user query demand, creates tree-shaped class node according to query demand, and fill in nodal basis information；
S3: according to query demand, corresponding SQL query statement is write, and test is compiled by logical data base；
S4: according to user query demand, query argument is determined；
S5: configuring drilling parameters according to query argument, by the database linkage information for the electric power service information system for needing to connect
It is associated configuration with compiler test passes through in step S3 SQL query statement, the configuration information as data mining；
S6: judged whether to need to be arranged lower brill node data collection according to query demand；Node data is bored in the case where determining to need to be arranged
When collection, continue step S7；When boring node data collection under determining not needing to be arranged, continue step S8；
S7: configuration is lower to bore node data collection, and carries out lower brill node associated configuration, by way of Transfer Parameters, by a upper section
Point valid data are transferred in lower brill querying node parameter, realize data mining function；
S8: exporting and shows query result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811155013.0A CN109376177B (en) | 2018-09-30 | 2018-09-30 | Data drilling analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811155013.0A CN109376177B (en) | 2018-09-30 | 2018-09-30 | Data drilling analysis method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109376177A true CN109376177A (en) | 2019-02-22 |
| CN109376177B CN109376177B (en) | 2021-11-02 |
Family
ID=65402763
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811155013.0A Active CN109376177B (en) | 2018-09-30 | 2018-09-30 | Data drilling analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109376177B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6711565B1 (en) * | 2001-06-18 | 2004-03-23 | Siebel Systems, Inc. | Method, apparatus, and system for previewing search results |
| US20090222476A1 (en) * | 2008-02-29 | 2009-09-03 | Williamson Eric J | Pyramid reporting tool |
| CN101556605A (en) * | 2009-05-13 | 2009-10-14 | 用友软件股份有限公司 | Free penetrating method of report data based on two-dimensional query model and system thereof |
| CN102902776A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Time dimension member generation device and time dimension member generation method for online analytic processing system |
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105824637A (en) * | 2016-03-17 | 2016-08-03 | 中国银行股份有限公司 | Customized query method and system |
| CN106570635A (en) * | 2016-11-04 | 2017-04-19 | 广东电网有限责任公司电力科学研究院 | Multi-dimensional analysis method for voltage qualified rate |
| CN106709017A (en) * | 2016-12-27 | 2017-05-24 | 山东麦港数据系统有限公司 | Big data-based aid decision making method |
| US20180075117A1 (en) * | 2015-03-17 | 2018-03-15 | Matthew E. Wong | System and method of providing a platform for enabling drill-down analysis of tabular data |
-
2018
- 2018-09-30 CN CN201811155013.0A patent/CN109376177B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6711565B1 (en) * | 2001-06-18 | 2004-03-23 | Siebel Systems, Inc. | Method, apparatus, and system for previewing search results |
| US20090222476A1 (en) * | 2008-02-29 | 2009-09-03 | Williamson Eric J | Pyramid reporting tool |
| CN101556605A (en) * | 2009-05-13 | 2009-10-14 | 用友软件股份有限公司 | Free penetrating method of report data based on two-dimensional query model and system thereof |
| CN102902776A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Time dimension member generation device and time dimension member generation method for online analytic processing system |
| US20180075117A1 (en) * | 2015-03-17 | 2018-03-15 | Matthew E. Wong | System and method of providing a platform for enabling drill-down analysis of tabular data |
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105824637A (en) * | 2016-03-17 | 2016-08-03 | 中国银行股份有限公司 | Customized query method and system |
| CN106570635A (en) * | 2016-11-04 | 2017-04-19 | 广东电网有限责任公司电力科学研究院 | Multi-dimensional analysis method for voltage qualified rate |
| CN106709017A (en) * | 2016-12-27 | 2017-05-24 | 山东麦港数据系统有限公司 | Big data-based aid decision making method |
Non-Patent Citations (4)
| Title |
|---|
| FREELIVER54: "[转]配置子报表和钻取报表", 《HTTPS://BLOG.CSDN.NET/FREELIVER54/ARTICLE/DETAILS/4611005》 * |
| 佚名: "报表中如何进行数据钻取", 《HTTPS://JINGYAN.BAIDU.COM/ARTICLE/2A138328A9D186074A134FCF.HTML》 * |
| 王志敬 等: "异种数据源的钻取方法研究", 《软件导刊》 * |
| 禾文汇: "基于BI的专利数据整合分析研究及实现", 《中国优秀博硕士学位论文全文数据库(硕士)》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109376177B (en) | 2021-11-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103020158B (en) | A kind of report form creation, device and system | |
| CN106445484B (en) | The method and system of data tracking are realized by Software Development Kit | |
| CN102799962B (en) | A kind of layout type business process system and its implementation | |
| CN101504672B (en) | Method and system for dynamically configuring physical data table | |
| CN102968307B (en) | A kind of web based on java develops middleware | |
| CN107463409A (en) | A kind of interface conversion method, interface convertor, storage medium and electric terminal | |
| CN102012945B (en) | User-oriented database management system | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| CN109739915B (en) | Cross-domain shared data model construction method | |
| WO2008047386A2 (en) | An electricity network management system | |
| CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
| CN108446313A (en) | A kind of conversion method of data format and device | |
| CN108170752A (en) | metadata management method and system based on template | |
| CN101626576B (en) | Method for generating parameter configuration template and method for configuring parameters by utilizing template | |
| US7552145B1 (en) | Method and system of restating telecommunications data by a batch-driven integrated rules module | |
| CN109063362A (en) | Avionics software interface controls document design management system | |
| CN107844519A (en) | Electronic installation, data base querying scenario generation method and storage medium | |
| CN109618250A (en) | A kind of fiber optic network node administration method and system | |
| CN105933767A (en) | Middleware device, middleware realization method and television set | |
| CN103019690A (en) | Visible component module development method based on JET technology | |
| CN109376177A (en) | A kind of data mining analysis method | |
| CN105867935A (en) | Application management method and device | |
| CN109739863A (en) | Electric energy meter data managing method | |
| CN111782820B (en) | Knowledge graph creation method and device, readable storage medium and electronic equipment | |
| CN104731804B (en) | A kind of method and device for establishing general polling frame |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |