CN108628961A - Method for rapidly carrying out statistical analysis by utilizing backflow data - Google Patents
Method for rapidly carrying out statistical analysis by utilizing backflow data Download PDFInfo
- Publication number
- CN108628961A CN108628961A CN201810334807.7A CN201810334807A CN108628961A CN 108628961 A CN108628961 A CN 108628961A CN 201810334807 A CN201810334807 A CN 201810334807A CN 108628961 A CN108628961 A CN 108628961A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- demand
- analysis
- data base
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000007619 statistical method Methods 0.000 title claims abstract description 6
- 238000004458 analytical method Methods 0.000 claims abstract description 26
- 230000003993 interaction Effects 0.000 claims abstract description 4
- 230000002085 persistent effect Effects 0.000 claims abstract description 4
- 239000000344 soap Substances 0.000 claims abstract description 4
- 238000010992 reflux Methods 0.000 claims description 11
- 230000000717 retained effect Effects 0.000 claims description 5
- 238000010586 diagram Methods 0.000 claims description 4
- 238000009826 distribution Methods 0.000 claims description 3
- 238000012482 interaction analysis Methods 0.000 abstract 1
- 230000003442 weekly effect Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
the invention discloses a method for utilizing backflow data to carry out rapid statistical analysis, which comprises the following steps of (1) constructing a local database, adopting PHP development language for development, adopting a typical MVC layered architecture based on a B/S architecture, adopting an Oracle database, utilizing PDO to process a persistent layer and an operation database, using Echarts for a chart engine at the front end, operating a server in apache and adopting a browser with a version more than IE6.0 at a client side, and (2) carrying out interaction and statistical analysis, namely interacting the constructed local database and a Web Services system adopting XM L or SOAP specifications, acquiring data to be applied from a backflow database of a marketing system, retaining the data in the local database, and carrying out statistics and analysis.
Description
Technical field
The present invention relates to data statistic analysis fields, and in particular to a kind of side using reflux data express statistic analysis
Method.
Background technology
In order to preferably carry out client's demand statistics, analysis work, more accurately go understand client demand, monthly,
It is required for the data according to client feedback weekly to do the analysis of some data, count and summarize.But marketing system at present
Report capability cannot be satisfied the data statistic analysis requirement of districts and cities' marketing service.Marketing work personnel can only be by exporting number at present
According to, counted by hand, statistical efficiency is relatively low, and statistical accuracy exist it is uncertain, so as to cause responsible specialized management
Employee work amount is very big.Meanwhile it being had the following problems by carrying out statistical by hand：（1）Inquiry and a business of export
Report data averagely takes about 30 minutes, and 6 part-time staff are responsible for the statistical work of data needed for weekly, monthly magazine, monthly consume
10 working days of Shi Yuewei；（2）Data export function limitation based on marketing system, partial data single derived quantity are no more than 1
Ten thousand, partial data is caused to need repeatedly export；（3）Because more people inquire simultaneously guiding system data simultaneously, marketing system is occupied
Data may influence the normal operation of marketing system.
Therefore, in order to further increase working efficiency, the regulation and standardization, scientific of report form statistics is realized, in customer service
Hearty cord closes the program capability of specialty characteristics and employee, by building marketing service self-defined report module, in conjunction with marketing service day
Normal work requirements automatically generate the statistical report form needed for routine work, meet the data statistics requirement of marketing service routine work.
Invention content
In view of the above-mentioned deficiencies in the prior art, it is an object of the present invention to provide a kind of utilization reflux data express statistic analysis
Method.For this method by building local data base, being obtained in flowing back database from marketing system needs data to be applied to retain
In local data base, express statistic, the analysis of data are realized.
The purpose of the present invention is achieved through the following technical solutions.
A method of it is analyzed, is included the following steps using reflux data express statistic：
（1）Build local data base：It is developed using PHP development languages, is based on B/S frameworks, Development Framework is using typical case's MVC layerings
Framework；Using oracle database, handles persistent layer with PDO and operating database, the schema engine of front end use
Echarts, server run on apache, and client uses IE6.0 or more version browsers；
（2）Interaction, statistical analysis：By the local data base of structure and include the Web Services for using XML or SOAP specifications
System interacts, and being obtained in flowing back database from marketing system needs data to be applied to be retained in local data base, and carries out
Statistics and analysis.
Preferably, step（1）In, the local data base of structure is every can be daily updated automatically.
Preferably, step（1）In, the oracle database of use can generate the chart data including block diagram or pie chart,
And the details of wherein data can be exported.
Preferably, step（2）In, being obtained in flowing back database from marketing system needs data to be applied to be retained in local
Before database, local data base further includes stored historical data.
Preferably, step（2）In, the rule of the statistics includes traffic total amount general status, turn to do work order situation analysis,
The every ten thousand families demand situation of each branch office, demand processing promptness rate, demand handle a fix-rate, business subclass overview, consulting hot spot
With complaint hot spot comparison, all kinds of client's demand distributions, fault outage query demand, pre-arranged power failure query demand, power off time
Typing promptness rate and industry expand work order typing situation analysis.
Compared with prior art, the invention has the advantages that and advantageous effect：
（1）The method of the present invention realizes the express statistic of data, analysis, further increases working efficiency, realizes report form statistics
Regulation and standardization and scientific；
（2）The method of the present invention can store required data using oracle database, and it includes block diagram or cake that can generate
The chart data of figure can export the details of wherein data, using programming technique, realize data query, intellectual analysis work(
Energy.
Figure of description
Fig. 1 is a kind of database schema figure of method using reflux data express statistic analysis of the present invention.
Specific implementation mode
Technical scheme of the present invention is described in further detail below in conjunction with specific embodiment, but the protection of the present invention
Range and embodiment are without being limited thereto.
Embodiment 1
A method of it is analyzed, is included the following steps using reflux data express statistic：
（1）Build local data base：It is developed using PHP development languages, is based on B/S frameworks, Development Framework is using typical case's MVC layerings
Framework；Using oracle database, handles persistent layer with PDO and operating database, the schema engine of front end use
Echarts, server run on apache, and client uses IE6.0 or more version browsers；The frame of the local data base of structure
Composition is as shown in Figure 1；
（2）Interaction, statistical analysis：By the local data base of structure and include the Web Services for using XML or SOAP specifications
System interacts, according to《Southern Power Grid Company marketing management system data dictionary》It is obtained in flowing back database from marketing system
It needs data to be applied to be retained in local data base, and carries out statistics and analysis；
Wherein, the viewdata in the database account number that flows back is copied in local come and logarithm by the dblink of Oracle
According to readable writeable permission is executed, local data base updates daily；Meanwhile specific statistical rules includes：
A, traffic total amount general status（Data source：All customer service work orders in timing statistics section）.
B, turn to do work order situation analysis（Data source：The biography customer service work order down of timing statistics section and according to type of service
Classification）.
C, the every ten thousand families demand situation of each branch office（Data source：Lower biography work order/population（Unit ten thousand））.
D, demand handles promptness rate（Data source：Promptness rate=（Lower biography work order-not timely work order）/ pass work order down）.
E, demand handles a fix-rate（Data source：The primary number work order that solves is to pass work order in work order down specially to do number
For 0 work order）.
F, business subclass overview（Data source：Classified according to provincial company classifying rules according to business subclass）.
G, consulting hot spot is compared with hot spot is complained（Data source：It is carried out according to provincial company classifying rules according to business subclass
Classification）.
H, all kinds of client's demand distributions（Data source：Classified according to provincial company classifying rules according to business subclass）.
Fault outage query demand（Data source：Demand quantity is the fault outage work order in power failure processing, and fault outage event number is
The argument of fault outage event, warranty failure work order are to pass the work order that type of service in work order is warranty failure down）.
I, pre-arranged power failure query demand（Data source：Demand quantity is the pre-arranged power-off event work in power failure processing
Single, pre-arranged power-off event number is the argument of pre-arranged power-off event, and the time-out telegram in reply event number practical power failure end time is more than
The pre-arranged power-off event of plan telegram in reply time）.
J, power off time typing promptness rate（Number is plan power off time ratio wound in pre-arranged work order in time for data source typing
Build work order of the time less than 7 days）.
K, industry expands work order typing situation analysis（Data source：It is not empty that typing work order, which has been Projected completion time field,
Work order）.
By the above analysis method, the programming count of 29 parts of reports, including customer service report, power failure related statements and industry are realized
Expand data sheet；The report form statistics of service dispatch class of Dongguan power supply bureau establishment monthly magazine, weekly is set to take by 10 initially monthly
On working day, 3 working days are successfully reduced to, number statistical efficiency improves 70%；And programming count report can export excel tables
Lattice, report have a stronger expansion application space, and by the libraries echarts that Baidu provides automatically generate block diagram, pie chart or
Scatter plot shows these data on webpage.
Above example is the present invention preferably embodiment, be only that technical scheme of the present invention is made it is further details of
Description, rather than limit the scope of the invention, any change, replacement, modification etc. without departing from spirit of the invention
It will be within the scope of the present invention.
Claims (5)
1. a kind of method using reflux data express statistic analysis, which is characterized in that include the following steps：
（1）Build local data base：It is developed using PHP development languages, is based on B/S frameworks, Development Framework is using typical case's MVC layerings
Framework；Using oracle database, handles persistent layer with PDO and operating database, the schema engine of front end use
Echarts, server run on apache, and client uses IE6.0 or more version browsers；
（2）Interaction, statistical analysis：By the local data base of structure and include the Web Services for using XML or SOAP specifications
System interacts, and being obtained in flowing back database from marketing system needs data to be applied to be retained in local data base, and carries out
Statistics and analysis.
2. a kind of method using reflux data express statistic analysis according to claim 1, which is characterized in that step
（1）In, the local data base of structure is every can be daily updated automatically.
3. a kind of method using reflux data express statistic analysis according to claim 1, which is characterized in that step
（1）In, the oracle database of use can generate the chart data including block diagram or pie chart, and can export wherein data
Details.
4. a kind of method using reflux data express statistic analysis according to claim 1, which is characterized in that step
（2）In, before acquisition needs data to be applied to be retained in local data base in flowing back database from marketing system, local data base
It further include stored historical data.
5. a kind of method using reflux data express statistic analysis according to claim 1, which is characterized in that step
（2）In, the rule of the statistics includes traffic total amount general status, turns to do work order situation analysis, the every ten thousand families demand feelings of each branch office
Condition, demand processing promptness rate, demand handle a fix-rate, business subclass overview, consulting hot spot and are compared with complaint hot spot, is all kinds of
Client's demand distribution, fault outage query demand, pre-arranged power failure query demand, power off time typing promptness rate and industry expand work
Single typing situation analysis.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810334807.7A CN108628961A (en) | 2018-04-15 | 2018-04-15 | Method for rapidly carrying out statistical analysis by utilizing backflow data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810334807.7A CN108628961A (en) | 2018-04-15 | 2018-04-15 | Method for rapidly carrying out statistical analysis by utilizing backflow data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108628961A true CN108628961A (en) | 2018-10-09 |
Family
ID=63705129
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810334807.7A Pending CN108628961A (en) | 2018-04-15 | 2018-04-15 | Method for rapidly carrying out statistical analysis by utilizing backflow data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108628961A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110187936A (en) * | 2019-05-31 | 2019-08-30 | 口碑(上海)信息技术有限公司 | Data backflow platform, system and method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104574207A (en) * | 2014-12-31 | 2015-04-29 | 国家电网公司 | Regional power grid electric quantity analyzing and counting system |
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN106411578A (en) * | 2016-09-12 | 2017-02-15 | 国网山东省电力公司电力科学研究院 | Website monitoring system and method applicable to power industry |
-
2018
- 2018-04-15 CN CN201810334807.7A patent/CN108628961A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104574207A (en) * | 2014-12-31 | 2015-04-29 | 国家电网公司 | Regional power grid electric quantity analyzing and counting system |
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN106411578A (en) * | 2016-09-12 | 2017-02-15 | 国网山东省电力公司电力科学研究院 | Website monitoring system and method applicable to power industry |
Non-Patent Citations (1)
| Title |
|---|
| 宋林峰: "地税征管税收综合分析***的设计与实现", 《中国优秀硕士论文全文数据库 信息科技辑》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110187936A (en) * | 2019-05-31 | 2019-08-30 | 口碑(上海)信息技术有限公司 | Data backflow platform, system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104600840B (en) | A kind of intelligent scheduling anti-misoperation management system and method | |
| CN104615617B (en) | A kind of substation equipment dispatching and monitoring information processing system | |
| CN105868839A (en) | Emergency material reservation optimization system | |
| CN103578039B (en) | A kind of power networks risk prewarning analysis system | |
| CN109088785A (en) | A kind of IDC data center apparatus management system | |
| CN104751269A (en) | Engineering maintenance scheduling management system | |
| CN104134163A (en) | Power distribution network graph and model management system and power distribution network graph and model management method based on CIM/E and CIM/G | |
| CN104881737A (en) | Control figure billing system | |
| CN109685567A (en) | Electricity customer portrait new method based on convolutional neural network and fuzzy clustering | |
| CN105160481A (en) | Web application system for enterprise order platform | |
| CN108628961A (en) | Method for rapidly carrying out statistical analysis by utilizing backflow data | |
| CN110955413A (en) | Financial data processing system | |
| CN102411757A (en) | Method and system for forecasting capacity of large host central processing unit (CPU) | |
| CN111915100B (en) | High-precision freight prediction method and freight prediction system | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| Zhao et al. | Analysis of enterprise management information system based on cloud computing | |
| CN111915048A (en) | Novel power failure management method based on intelligent analysis decision theory technology | |
| Zatsarinnaya et al. | An automated software package creation for energy consumption accounting | |
| CN110503386A (en) | A kind of data processing system for market-oriented project | |
| Cui et al. | Design and implementation of intelligent building engineering information management system | |
| Pesantez et al. | Evaluating Changes in Urban Water Consumption and Impacts to Water Infrastructure During the COVID-19 Pandemic | |
| Zhao et al. | Research on the construction of data pool and the management model of data pool integrating block chain concept for ubiquitous electric power Internet of Things | |
| Liu et al. | Research on electric power with development and application of line loss rate forecasting software based on MLRM-GM | |
| Shenoy et al. | Energy data analysis | |
| Boff et al. | Waiting in Queue: A Historical Evaluation of Interconnection Policy |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181009 |