CN105469188A - Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method - Google Patents
Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method Download PDFInfo
- Publication number
- CN105469188A CN105469188A CN201510788980.0A CN201510788980A CN105469188A CN 105469188 A CN105469188 A CN 105469188A CN 201510788980 A CN201510788980 A CN 201510788980A CN 105469188 A CN105469188 A CN 105469188A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- distribution network
- server
- power supply
- 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
- 238000013439 planning Methods 0.000 title claims abstract description 86
- 238000009826 distribution Methods 0.000 title claims abstract description 44
- 238000004458 analytical method Methods 0.000 title claims abstract description 33
- 238000007726 management method Methods 0.000 claims abstract description 41
- 238000000034 method Methods 0.000 claims abstract description 15
- 238000012423 maintenance Methods 0.000 claims abstract description 7
- 238000013523 data management Methods 0.000 claims abstract description 4
- 238000004364 calculation method Methods 0.000 claims description 30
- 238000007667 floating Methods 0.000 claims description 14
- 238000012795 verification Methods 0.000 claims description 11
- 230000005611 electricity Effects 0.000 claims description 8
- 238000010586 diagram Methods 0.000 claims description 7
- 238000012544 monitoring process Methods 0.000 claims description 7
- 238000012550 audit Methods 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000007689 inspection Methods 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 238000003860 storage Methods 0.000 claims 1
- 230000003993 interaction Effects 0.000 abstract description 4
- 238000012545 processing Methods 0.000 abstract description 3
- 238000012552 review Methods 0.000 description 11
- 238000013461 design Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 7
- 238000007619 statistical method Methods 0.000 description 4
- 238000013480 data collection Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000008676 import Effects 0.000 description 3
- 238000002360 preparation method Methods 0.000 description 3
- 235000006719 Cassia obtusifolia Nutrition 0.000 description 2
- 235000014552 Cassia tora Nutrition 0.000 description 2
- 244000201986 Cassia tora Species 0.000 description 2
- 238000005553 drilling Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 239000008358 core component Substances 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000004141 dimensional analysis Methods 0.000 description 1
- 235000019580 granularity Nutrition 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000007639 printing 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Water Supply & Treatment (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- General Health & Medical Sciences (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
技术领域technical field
本发明涉及一种配电网规划数据在线智能分析系统及方法。The invention relates to an online intelligent analysis system and method for distribution network planning data.
背景技术Background technique
现有的配电网规划范围覆盖所有市辖供电区和县级供电区，覆盖范围广，数据信息量大，编制任务繁重等各种原因，如图1，导致配电网规划数据质量低、数据准确性差。The existing distribution network planning covers all municipal power supply areas and county-level power supply areas. Various reasons, such as wide coverage, large amount of data information, and heavy compilation tasks, as shown in Figure 1, lead to low quality of distribution network planning data. Data accuracy is poor.
目前配电网规划报告编制中，项目清册信息搜集大多采用人工筛选的方式，上级部门发起一次数据采集，需要通过电话通知和催报下级填报单位。各级工作人员手工填写，再通过电子邮件或纸质文档的方式发送至上级部门，上级部门针对填报内容进行人工核查与数据汇总统计，工作效率低，数据准确性难以掌控。At present, in the preparation of the distribution network planning report, most of the information collection of the project inventory adopts the method of manual screening. When the higher-level department initiates a data collection, it needs to notify and remind the lower-level reporting units by phone. Staff at all levels fill it out manually, and then send it to the higher-level department by email or paper documents. The higher-level department conducts manual verification and data summary statistics on the filled-in content. The work efficiency is low, and the accuracy of the data is difficult to control.
人工统计汇总，造成流程不畅，零散的数据也很难进行分析应用。无法实现数据采集流程的管理，无法拓宽信息渠道，掌握电网规划信息处理的规律。规划数据口径多、重复录入，信息交换困难，数据质量难以保证。Manual statistics and summarization lead to unsmooth processes, and it is difficult to analyze and apply scattered data. The management of the data collection process cannot be realized, the information channels cannot be broadened, and the laws of power grid planning information processing cannot be mastered. There are many planning data calibers, repeated entry, difficult information exchange, and difficult to guarantee data quality.
发明内容Contents of the invention
本发明为了解决上述问题，提出了一种配电网规划数据在线智能分析系统及方法，本系统具有规划数据图表采集单元自动设计、规划数据填报任务自动提醒、规划数据报送全流程监控、规划数据计算与校核管理、规划数据汇总与格式化输出、数据综合查询与分析等高度信息化、自动化、智能化的优点。In order to solve the above problems, the present invention proposes an online intelligent analysis system and method for distribution network planning data. It has the advantages of high informatization, automation and intelligence, such as data calculation and verification management, planning data summary and formatted output, comprehensive data query and analysis.
为了实现上述目的，本发明采用如下技术方案：In order to achieve the above object, the present invention adopts the following technical solutions:
一种配电网规划数据在线智能分析系统，包括中心服务层、地市供电管理层和下级供电管理层，下级供电管理层统计用电数据，并上传给地市供电管理层，地市供电管理层将接收的数据和自己的用电数据形成报表，发送给中心服务层进行分析和统计；An online intelligent analysis system for distribution network planning data, including a central service layer, a prefecture-level power supply management layer, and a lower-level power supply management layer. The layer forms a report of the received data and its own electricity consumption data, and sends it to the central service layer for analysis and statistics;
所述中心服务层包括报表服务器、模型服务器、关系数据库服务器和实时数据库服务器；其中：所述报表服务器，用于处理数据库交互，客户端服务申请响应，提供各类数据服务，提供统一界面运行报表数据管理、权限管理、报表户维护、访问控制和插件维护；The central service layer includes a report server, a model server, a relational database server, and a real-time database server; wherein: the report server is used to process database interaction, respond to client service applications, provide various data services, and provide a unified interface to run reports Data management, authority management, report account maintenance, access control and plug-in maintenance;
所述模型服务器，用于根据配电网模型搭建数据关系模型；The model server is used to build a data relationship model according to the distribution network model;
所述关系数据库服务器，用于保存配电网数据关系，供报表服务器调取；The relational database server is used to save the distribution network data relationship for retrieval by the report server;
所述实时数据库服务器，用于存储服务器端所有填报的数据以及系统相关的配置；The real-time database server is used to store all data and system-related configurations filled in at the server end;
所述地市供电管理层，包括接口服务器和工作站，所述接口服务器，用于提供中心服务层和工作站通信的接口；The city power supply management layer includes an interface server and a workstation, and the interface server is used to provide an interface for communication between the central service layer and the workstation;
所述下级供电管理层，用于采集各个县级市、区的配电网用电数据，获取电力数据。The lower-level power supply management layer is used to collect power consumption data of distribution networks in various county-level cities and districts, and obtain power data.
所述配电网规划数据在线智能分析系统，还连接有PMS生产管理系统、电网GIS、输变电设备状态监测、雷电定位系统，电动汽车运营支持系统、SCADA系统和EMS系统。The online intelligent analysis system for distribution network planning data is also connected with PMS production management system, power grid GIS, status monitoring of power transmission and transformation equipment, lightning positioning system, electric vehicle operation support system, SCADA system and EMS system.
所述报表类型包括表格支持横向浮动报表、纵向浮动报表、交叉浮动报表、嵌套浮动报表和并列浮动报表。The report types include tables supporting horizontal floating reports, vertical floating reports, cross floating reports, nested floating reports and parallel floating reports.
所述报表的表现方式包括柱状图、饼图、折线图、面积图、条形图、雷达图、散点图、走势图或仪表盘。The presentation manner of the report includes a column chart, a pie chart, a line chart, an area chart, a bar chart, a radar chart, a scatter chart, a trend chart or a dashboard.
所述报表服务器进行规划表格数据运算与计算，包括表内表间运算，支持按条件选择计算，支持跨报表期运算、取上期和累计。The report server performs calculations and calculations on planning table data, including calculations within and between tables, supports selection and calculation based on conditions, and supports calculations across report periods, fetching previous period and accumulating.
所述报表服务器根据表内公式、表间公式或跨任务公式进行自动运算，并根据运算公式和审核条件进行筛选。The report server performs automatic calculation according to formulas in tables, formulas between tables or cross-task formulas, and performs screening according to calculation formulas and review conditions.
所述模型服务器，用于检查所填报数据是否满足一定的勾稽关系，实现表内、表间多种审核关系与批量审核，建立报表模板规则，按照其对填报的数据进行自动的数据检查，对于不合法的指标予以标示，并定位到单元格。The model server is used to check whether the data filled in the report satisfies a certain checking relationship, realize multiple audit relationships and batch audits within and between tables, establish report template rules, and perform automatic data inspection on the reported data according to it. Invalid indicators are marked and positioned to the cell.
所述实时数据库服务器，用于实现对数据层层汇总、按指定条件汇总、多报表期汇总，其中，数据层层汇总包括所有数据进行统计分析，查询上报情况、审核情况、锁定情况、审批情况，系统以表格的形式列出查询结果，并标明各类用户的数量。The real-time database server is used to realize layer-by-layer summary of data, summary according to specified conditions, and multi-report period summary, wherein the layer-by-layer summary of data includes all data for statistical analysis, query reporting status, review status, locking status, and approval status , the system lists the query results in the form of a table, and indicates the number of various users.
一种基于上述系统的工作方法，包括以下步骤：A working method based on the above system, comprising the following steps:
(1)下级供电管理层统计用电数据，并上传给地市供电管理层，地市供电管理层将接收的数据和自己的用电数据形成数据源；(1) The lower-level power supply management manages the statistics of electricity consumption and uploads it to the prefecture-level power supply management. The prefecture-city power supply management forms a data source with the received data and its own power consumption data;
(2)将数据源进行数据运算、审核和汇总，形成报表，发送给中心服务层进行分析和统计；(2) Perform data calculation, review and summary of data sources to form reports and send them to the central service layer for analysis and statistics;
(3)报表服务器进行规划表格数据运算与计算，包括表内表间运算，支持按条件选择计算，支持跨报表期运算、取上期和累计，并根据拟定的表内公式、表间公式或跨任务公式进行自动运算，并根据运算公式和审核条件进行筛选；(3) The report server performs planning table data calculation and calculation, including intra-table and inter-table calculations, supports selection and calculation according to conditions, supports cross-report period calculations, fetches the previous period and accumulates, and calculates according to the proposed internal formulas, inter-table formulas or cross-report formulas. The task formula performs automatic calculation, and filters according to the calculation formula and review conditions;
(4)模型服务器检查所填报数据是否满足一定的勾稽关系，实现表内、表间多种审核关系与批量审核，建立报表模板规则，按照其对填报的数据进行自动的数据检查，对于不合法的指标予以标示，并定位到单元格；(4) The model server checks whether the reported data satisfies a certain checking relationship, realizes multiple audit relationships and batch audits within and between tables, establishes report template rules, and performs automatic data inspection on the filled data according to them. The indicators are marked and positioned to the cell;
(5)进行表格和统计图形的可视化数据展现。(5) Perform visual data presentation of tables and statistical graphics.
本发明的有益效果为：The beneficial effects of the present invention are:
(1)本发明可以满足不断变化的配电网规划项目信息统计业务，减少了大量的人力工作，提高了电网规划数据处理的准确性和效率。(1) The present invention can satisfy the ever-changing distribution network planning project information statistics business, reduce a lot of manpower work, and improve the accuracy and efficiency of power grid planning data processing.
(2)本发明提供从规划数据智能提取、规划图表智能设计、规划图表在线智能发布、规划数据智能管理、规划数据智能查询分析的在线智能分析系统，实现的规划数据图表采集单元自动设计、规划数据填报任务自动提醒、规划数据报送全流程监控、规划数据计算与校核管理、规划数据汇总与格式化输出、数据综合查询与分析等高度信息化、自动化、智能化的优势，为配电网规划数据采集、数据管理提供了完整的解决方案，能够大大提高规划人员的工作效率和工作质量，降低电网规划管理成本。(2) The present invention provides an online intelligent analysis system for intelligent extraction of planning data, intelligent design of planning charts, online intelligent publishing of planning charts, intelligent management of planning data, intelligent query and analysis of planning data, and the automatic design and planning of the planning data chart acquisition unit. The advantages of high informationization, automation and intelligence, such as automatic reminder of data filling tasks, monitoring of the whole process of planning data submission, planning data calculation and verification management, planning data summary and formatted output, comprehensive data query and analysis, etc., provide power distribution Network planning data collection and data management provide a complete solution, which can greatly improve the work efficiency and work quality of planners, and reduce the cost of power grid planning and management.
附图说明Description of drawings
图1为现有配电网规划数据分析的不足；Figure 1 shows the shortcomings of existing distribution network planning data analysis;
图2为配电网规划数据在线智能分析系统网络架构图；Figure 2 is a network architecture diagram of the online intelligent analysis system for distribution network planning data;
图3为报表服务器系统架构图；Figure 3 is a report server system architecture diagram;
图4为配电网规划数据在线智能分析系统功能架构图；Figure 4 is a functional architecture diagram of the online intelligent analysis system for distribution network planning data;
图5本发明的流程图。Figure 5 is a flowchart of the present invention.
具体实施方式：detailed description:
下面结合附图与实施例对本发明作进一步说明。The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
如图1所示，配电网规划范围覆盖所有市辖供电区和县级供电区，覆盖范围广，数据信息量大，编制任务繁重等各种原因，导致配电网规划数据质量低、数据准确性差。As shown in Figure 1, distribution network planning covers all municipal power supply areas and county-level power supply areas. Due to various reasons such as wide coverage, large amount of data information, and heavy compilation tasks, the quality of distribution network planning data is low and the data quality is low. Poor accuracy.
如图2所示，配电网规划数据在线智能分析系统网络架构，包括报表服务器、接口服务器、模型服务器、关系数据库服务器、实时数据库服务器和工作站组成。为满足系统建设数据需要，接入的业务应用系统包括：PMS生产管理系统、电网GIS、输变电设备状态监测、雷电定位系统，电动汽车运营支持系统、SCADA系统和EMS系统等。As shown in Figure 2, the network architecture of the distribution network planning data online intelligent analysis system consists of a report server, an interface server, a model server, a relational database server, a real-time database server and a workstation. In order to meet the data needs of system construction, the connected business application systems include: PMS production management system, power grid GIS, power transmission and transformation equipment status monitoring, lightning positioning system, electric vehicle operation support system, SCADA system and EMS system, etc.
各类业务系统数据信息的集成，从实现技术上，根据不同系统实际情况，可分别采用WebService服务或开放中间库的形式实现。整合PMS、EMS、GIS、智能配网运行监控、规划计划管理、用电信息采集、电能质量监测、基建管理、运营监控管理等专业支撑系统，构建基于统一电网模型的统一数据支撑，建立电网设备、图形标准(规划图、设计图、运行图)、运行信息等基础数据字典以及高级分析数据质量审核机制。The integration of data information of various business systems can be realized in the form of WebService service or open intermediate library in terms of implementation technology and according to the actual situation of different systems. Integrate PMS, EMS, GIS, intelligent distribution network operation monitoring, planning plan management, power consumption information collection, power quality monitoring, infrastructure management, operation monitoring management and other professional support systems, build unified data support based on a unified grid model, and establish grid equipment , graphics standards (planning diagrams, design diagrams, operation diagrams), basic data dictionaries such as operation information, and advanced analysis data quality review mechanisms.
其中报表服务器为系统平台的基础和核心组件，基于JSP、JavaBean、WebService技术实现的Web应用，主要用于处理数据库交互，客户端服务甲请响应，提供各类数据服务，提供统一界面运行报表数据管理(数据浏览、填报、催报、汇总、计算、审核等)、权限管理、报表户维护、访问控制、插件维护等功能。数据库服务器用来存储服务器端所有填报的数据以及系统相关的配置。Among them, the report server is the basic and core component of the system platform. It is a web application based on JSP, JavaBean, and WebService technologies. It is mainly used to process database interaction. The client service A please respond, provide various data services, and provide a unified interface to run report data. Management (data browsing, reporting, reminder, summary, calculation, auditing, etc.), authority management, report account maintenance, access control, plug-in maintenance and other functions. The database server is used to store all the data and system-related configuration on the server side.
规划报表智能设计：采用类似MicrosoftOffice的操作界面，所见即所得的编辑方式，采用类似Excel的单元格设计思想，各种复杂的配电网规划表格模板格式都能直接反映到计算机屏幕上。提供增删行列、任意合并拆分单元格、插入文字框、图形对象、设置单元格属性等操作方式，快速设计任意复杂的规划报表格式，并能实现录入格式与打印格式的完全一致。报表设计工具可直接从Excel中导入配电网规划项目清册模板格式；也允许直接将Excel、Word中的内容直接粘贴到报表对象上。Intelligent design of planning reports: using an operation interface similar to Microsoft Office, WYSIWYG editing, and Excel-like cell design ideas, various complex distribution network planning form template formats can be directly reflected on the computer screen. Provide operation methods such as adding and deleting rows and columns, arbitrarily merging and splitting cells, inserting text boxes, graphic objects, setting cell properties, etc., quickly designing any complex planning report format, and can realize the complete consistency between the input format and the print format. The report design tool can directly import the template format of the distribution network planning project inventory from Excel; it also allows the content in Excel and Word to be directly pasted to the report object.
规划数据智能采集填报：规划基础数据填报：完成规划报表设计后，通过系统生成在线自动统计任务，建立省经研院、地市经研所、县公司三级信息报送流程。同时，通过规划基础数据平台，自动从平台中获取该数据，实现该规划数据的自动获取，无需再手工填报。Intelligent collection and reporting of planning data: filling and reporting of basic planning data: After the planning report design is completed, online automatic statistical tasks are generated through the system, and a three-level information reporting process of provincial economic research institutes, prefectural and municipal economic research institutes, and county companies is established. At the same time, by planning the basic data platform, the data is automatically obtained from the platform to realize the automatic acquisition of the planning data without manual filling.
规划数据智能运算：规划表格数据运算与计算：系统包括表内表间运算，支持按条件选择计算，支持跨报表期运算，取上期、累计等功能。实现与Excel语法类似的公式引擎，实现表内公式、表间公式、跨任务公式自动运算，能自动、智能地根据运算公式和审核条件进行舍位平衡。Intelligent calculation of planning data: calculation and calculation of planning table data: the system includes calculations between tables and tables, supports selection and calculation according to conditions, supports cross-report period calculations, and functions such as taking the previous period and accumulating. Realize a formula engine similar to Excel syntax, realize automatic calculation of formulas in tables, formulas between tables, and cross-task formulas, and automatically and intelligently perform rounding and balancing according to calculation formulas and review conditions.
规划数据智能校核管理：规划表格数据审核：系统提供数据审核功能，用于检查所填报数据是否满足一定的勾稽关系，实现表内、表间等多种审核关系与批量审核功能。系统按照报表模板规则对填报的数据进行自动的数据检查，对于不合法的指标系统予以醒目地标示出来，并自动定位到单元格。Intelligent verification management of planning data: data review of planning forms: the system provides data review function to check whether the filled-in data meets a certain verification relationship, and realizes multiple review relationships and batch review functions within the table and between tables. The system automatically checks the data filled in according to the rules of the report template, and the system will prominently mark illegal indicators and automatically locate them in the cells.
规划数据智能统计分析：系统实现对数据层层汇总、按指定条件汇总、多报表期汇总功能。数据汇总包括所有数据进行统计分析。查询上报情况、审核情况、锁定情况、审批情况，系统以表格的形式列出查询结果，并标明各类用户的数量。实现基于配电网规划数据清单列表、项目类型查询、项目信息成果打印等基本分析功能。多维分析模块提供了钻取、旋转、切片和钻到其他表等功能，可以得到不同粒度的数据；系统支持对话框OLAP和拖拽式OLAP，使分析更加方便灵活。Intelligent statistical analysis of planning data: the system realizes the functions of summarizing data layer by layer, summarizing according to specified conditions, and summarizing multiple reporting periods. Data summarization included all data for statistical analysis. Query reporting status, review status, locking status, and approval status, the system lists the query results in the form of a table, and indicates the number of various users. Realize basic analysis functions based on distribution network planning data list list, project type query, and project information result printing. The multi-dimensional analysis module provides functions such as drilling, rotating, slicing and drilling to other tables to obtain data of different granularities; the system supports dialog OLAP and drag-and-drop OLAP, making analysis more convenient and flexible.
规划数据智能化展示：实现表格和统计图形等多种可视化数据展现形式，具备自定义报表排版和编辑功能。表格支持横向浮动报表、纵向浮动报表、交叉浮动报表、嵌套浮动报表、并列浮动报表等多种类型的报表。提供多种统计图类型和样式，类型包括：柱状图、饼图、折线图、面积图、条形图、雷达图、散点图、走势图、仪表盘等。丰富的统计图类型和样式可以让用户定义出各种美观的报表和领导驾驶舱。Intelligent display of planning data: Realize various visual data display forms such as tables and statistical graphics, and have custom report layout and editing functions. Tables support horizontal floating reports, vertical floating reports, cross floating reports, nested floating reports, parallel floating reports and other types of reports. Provides a variety of statistical chart types and styles, including: histogram, pie chart, line chart, area chart, bar chart, radar chart, scatter chart, trend chart, dashboard, etc. Abundant chart types and styles allow users to define various beautiful reports and leadership cockpits.
规划报告辅助编制：系统内置配电网规划大纲模板，可将配电网规划数据快速导入各功能模块内容到规划书的相应章节中，形成规划大纲书数据内容自动生成，具备Word和Excel文档或数据快速导入、导出功能，模板可根据用户需求调整。Auxiliary preparation of planning reports: The system has a built-in distribution network planning outline template, which can quickly import the distribution network planning data into the corresponding chapters of the planning book to form the data content of the planning outline book, with Word and Excel documents or Fast data import and export functions, templates can be adjusted according to user needs.
如图3所示，报表服务器系统架构采用浏览器插件+J2EE应用服务器+数据仓库的架构方式，用户通过浏览器Web页面访问报表服务器，报表服务器基于JSP+JavaBean+WebService技术，主要用于处理数据库交互，提供数据浏览、填报、催报、汇总、计算、审核等服务。数据库服务器用来存储服务器端所有填报的数据以及系统相关的配置，可以与客户业务软件系统共享一个数据库。As shown in Figure 3, the report server system architecture adopts the browser plug-in + J2EE application server + data warehouse architecture. Users access the report server through the browser Web page. The report server is based on JSP+JavaBean+WebService technology and is mainly used to process databases. Interaction, providing services such as data browsing, reporting, reminders, summarization, calculation, and auditing. The database server is used to store all the data filled in on the server side and system-related configurations, and can share a database with the customer's business software system.
如图4所示，配电网规划数据在线智能分析系统功能架构主要包括规划数据智能提取、规划图表智能设计、规划图表在线智能发布、规划数据智能管理、规划数据智能查询分析等功能。As shown in Figure 4, the functional architecture of the online intelligent analysis system for distribution network planning data mainly includes functions such as intelligent extraction of planning data, intelligent design of planning charts, online intelligent publishing of planning charts, intelligent management of planning data, and intelligent query and analysis of planning data.
如图5所示，配电网规划数据在线智能分析系统工作流程，从规划报表智能设计、规划数据智能采集填报、规划数据智能运算、规划数据智能校核管理到规划数据智能统计分析过程智能化实现，成果数据可以用于规划数据智能化展示或者规划报告辅助编制。As shown in Figure 5, the workflow of the online intelligent analysis system for distribution network planning data includes intelligent design of planning reports, intelligent collection and filling of planning data, intelligent calculation of planning data, intelligent verification and management of planning data, and intelligent statistical analysis of planning data. Realized, the result data can be used for intelligent display of planning data or auxiliary preparation of planning reports.
上述虽然结合附图对本发明的具体实施方式进行了描述，但并非对本发明保护范围的限制，所属领域技术人员应该明白，在本发明的技术方案的基础上，本领域技术人员不需要付出创造性劳动即可做出的各种修改或变形仍在本发明的保护范围以内。Although the specific implementation of the present invention has been described above in conjunction with the accompanying drawings, it does not limit the protection scope of the present invention. Those skilled in the art should understand that on the basis of the technical solution of the present invention, those skilled in the art do not need to pay creative work Various modifications or variations that can be made are still within the protection scope of the present invention.
Claims (9)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510788980.0A CN105469188A (en) | 2015-11-16 | 2015-11-16 | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510788980.0A CN105469188A (en) | 2015-11-16 | 2015-11-16 | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105469188A true CN105469188A (en) | 2016-04-06 |
Family
ID=55606856
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510788980.0A Pending CN105469188A (en) | 2015-11-16 | 2015-11-16 | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105469188A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106779333A (en) * | 2016-11-29 | 2017-05-31 | 华中科技大学 | A kind of intelligent model towards power equipment and its realize system |
| CN107146166A (en) * | 2017-04-24 | 2017-09-08 | 国网江西省电力公司经济技术研究院 | An auxiliary system for distribution network planning |
| CN107292471A (en) * | 2016-04-10 | 2017-10-24 | 国网山东省电力公司经济技术研究院 | Transparence, real time implementation, the intelligent grid planning management method of panorama |
| CN107293210A (en) * | 2016-04-10 | 2017-10-24 | 国网山东省电力公司经济技术研究院 | The planning figure automatic switching method of geographical map, electric hookup based on GIS figures |
| CN107391777A (en) * | 2017-09-25 | 2017-11-24 | 国网江苏省电力公司泰州供电公司 | A kind of power supply enterprise's operation data analytical equipment and method |
| CN109165625A (en) * | 2018-09-11 | 2019-01-08 | 国网山东省电力公司莱芜供电公司 | A kind of test report intelligent generation method based on image recognition |
| CN109635265A (en) * | 2018-11-29 | 2019-04-16 | 济南荣耀合创电力科技有限公司 | A kind of test report generation system based on image recognition |
| CN110930264A (en) * | 2019-11-15 | 2020-03-27 | 国网安徽省电力有限公司黄山供电公司 | A regional power grid trip information management and control system |
| CN111782718A (en) * | 2020-08-11 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Plug-in data reporting system and data reporting method |
| CN112200458A (en) * | 2020-10-12 | 2021-01-08 | 贵州电网有限责任公司 | Power distribution network planning data application method and system |
| CN113095955A (en) * | 2021-04-06 | 2021-07-09 | 华能吉林发电有限公司 | Regional power generation company business data chart one-key generation export |
| CN114372662A (en) * | 2021-11-29 | 2022-04-19 | 国网山东省电力公司日照供电公司 | A lean analysis system and method for power grid planning based on big data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103426070A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Compilation method and device of group combined financial statement |
| CN103793778A (en) * | 2013-11-08 | 2014-05-14 | 远光软件股份有限公司 | Report data real-time audit method and device |
| CN103927694A (en) * | 2014-04-18 | 2014-07-16 | 江苏省电力公司常州供电公司 | Real-time analysis and decision system of regional loads of urban power grid and working method thereof |
| CN104063761A (en) * | 2014-06-26 | 2014-09-24 | 国家电网公司 | SCADA data development system based on smart grid |
| CN104123675A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Power distribution network simulation research and analysis system and method based on network-wide data |
-
2015
- 2015-11-16 CN CN201510788980.0A patent/CN105469188A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123675A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Power distribution network simulation research and analysis system and method based on network-wide data |
| CN103426070A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Compilation method and device of group combined financial statement |
| CN103793778A (en) * | 2013-11-08 | 2014-05-14 | 远光软件股份有限公司 | Report data real-time audit method and device |
| CN103927694A (en) * | 2014-04-18 | 2014-07-16 | 江苏省电力公司常州供电公司 | Real-time analysis and decision system of regional loads of urban power grid and working method thereof |
| CN104063761A (en) * | 2014-06-26 | 2014-09-24 | 国家电网公司 | SCADA data development system based on smart grid |
Non-Patent Citations (1)
| Title |
|---|
| 荀挺等: "电网调控数据综合智能分析决策架构设计", 《电力系统保护与控制》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107292471A (en) * | 2016-04-10 | 2017-10-24 | 国网山东省电力公司经济技术研究院 | Transparence, real time implementation, the intelligent grid planning management method of panorama |
| CN107293210A (en) * | 2016-04-10 | 2017-10-24 | 国网山东省电力公司经济技术研究院 | The planning figure automatic switching method of geographical map, electric hookup based on GIS figures |
| CN106779333B (en) * | 2016-11-29 | 2020-05-26 | 华中科技大学 | Intelligent model implementation system for power equipment |
| CN106779333A (en) * | 2016-11-29 | 2017-05-31 | 华中科技大学 | A kind of intelligent model towards power equipment and its realize system |
| CN107146166A (en) * | 2017-04-24 | 2017-09-08 | 国网江西省电力公司经济技术研究院 | An auxiliary system for distribution network planning |
| CN107146166B (en) * | 2017-04-24 | 2020-12-01 | 国网江西省电力公司经济技术研究院 | An auxiliary system for distribution network planning |
| CN107391777A (en) * | 2017-09-25 | 2017-11-24 | 国网江苏省电力公司泰州供电公司 | A kind of power supply enterprise's operation data analytical equipment and method |
| CN109165625A (en) * | 2018-09-11 | 2019-01-08 | 国网山东省电力公司莱芜供电公司 | A kind of test report intelligent generation method based on image recognition |
| CN109635265A (en) * | 2018-11-29 | 2019-04-16 | 济南荣耀合创电力科技有限公司 | A kind of test report generation system based on image recognition |
| CN110930264A (en) * | 2019-11-15 | 2020-03-27 | 国网安徽省电力有限公司黄山供电公司 | A regional power grid trip information management and control system |
| CN111782718A (en) * | 2020-08-11 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Plug-in data reporting system and data reporting method |
| CN111782718B (en) * | 2020-08-11 | 2023-12-29 | 支付宝(杭州)信息技术有限公司 | Plug-in data reporting system and data reporting method |
| CN112200458A (en) * | 2020-10-12 | 2021-01-08 | 贵州电网有限责任公司 | Power distribution network planning data application method and system |
| CN112200458B (en) * | 2020-10-12 | 2023-10-20 | 贵州电网有限责任公司 | Power distribution network planning data application method and system |
| CN113095955A (en) * | 2021-04-06 | 2021-07-09 | 华能吉林发电有限公司 | Regional power generation company business data chart one-key generation export |
| CN114372662A (en) * | 2021-11-29 | 2022-04-19 | 国网山东省电力公司日照供电公司 | A lean analysis system and method for power grid planning based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105469188A (en) | Distribution network planning data online intelligent analysis system and distribution network planning data online intelligent analysis method | |
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| WO2022012285A1 (en) | Multi-source integrated multi-platform energy information management system | |
| CN102385739B (en) | A kind of county power supply company integration information management platform | |
| CN112132327A (en) | Intelligent planning system for distribution network for multi-source data fusion | |
| CN105701617A (en) | Overall process information management and control visualization method based on electric power material supply chain and system thereof | |
| CN107424079A (en) | A kind of heavy construction energy consumption management system and method based on big data platform | |
| CN104778551A (en) | Designing and analyzing method of visualization grid | |
| CN107835107A (en) | A kind of metering display systems based on power network metering topological sum WebGis | |
| CN102842072A (en) | Town cadastre management method and system | |
| CN112527857A (en) | Multi-angle line loss visual data analysis platform based on intelligent electric meter | |
| CN110298693A (en) | A kind of big data system recommended based on vegetable price prediction | |
| CN110956692A (en) | Method for combining three-dimensional scene visualization based on power supply reliability data analysis | |
| CN102184196A (en) | Petition integrated management information system | |
| CN109447466B (en) | Overall process visual management and control system based on power distribution network communication network construction | |
| Li et al. | Research and design of mineral resource management system based on big data and GIS technology | |
| CN202533938U (en) | Touch query machine/mobile equipment-based land grading and evaluation processing system | |
| CN116523328A (en) | Intelligent decision-making method for cooperation of aviation equipment and manufacturing industry chain | |
| CN114612056A (en) | Unified report service method and device based on data middlebox and electronic equipment | |
| CN105574204B (en) | Retrieval method and system for distributed power grid regulation and control operation data | |
| CN103345485B (en) | A kind of mainframe platform dynamic statement automatic generation method and system | |
| CN102750653A (en) | Method and system for performing multi-dimensional benchmarking analysis on electric power scheduling information | |
| CN105488632A (en) | Method and device for analyzing electric data based on dimensional model | |
| CN108132997A (en) | A kind of electric network data management sums up structure and its resolution principle | |
| Wang et al. | BIM-based government engineering quality supervision system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into 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: 20160406 |