CN103440362A - Modeling method for transmission and transformation project construction management display platform with extensible dimensionality - Google Patents

Modeling method for transmission and transformation project construction management display platform with extensible dimensionality Download PDF

Info

Publication number
CN103440362A
CN103440362A CN2013103189294A CN201310318929A CN103440362A CN 103440362 A CN103440362 A CN 103440362A CN 2013103189294 A CN2013103189294 A CN 2013103189294A CN 201310318929 A CN201310318929 A CN 201310318929A CN 103440362 A CN103440362 A CN 103440362A
Authority
CN
China
Prior art keywords
modeling method
dimension
dimensionality
project
display platform
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
Application number
CN2013103189294A
Other languages
Chinese (zh)
Inventor
曾光
谢洪平
秦健
丁志锋
柏彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
State Grid Jiangsu Electric Power Co Ltd
Economic and Technological Research Institute of State Grid Jiangsu Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Jiangsu Electric Power Co Ltd
Economic and Technological Research Institute of State Grid Jiangsu Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, State Grid Jiangsu Electric Power Co Ltd, Economic and Technological Research Institute of State Grid Jiangsu Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN2013103189294A priority Critical patent/CN103440362A/en
Publication of CN103440362A publication Critical patent/CN103440362A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications

Abstract

The invention discloses a modeling method for a transmission and transformation project construction management display platform with extensible dimensionality. The modeling method comprises the following steps that geographical information dimensionality is subjected to abstraction, and then is made into a normalized ER (entity-relation) diagram; the normalized ER diagram is divided into dispersed business processing processes, and then each dispersed business processing process is independently modeled; subsequently, many-to-many relations containing data or additive non-keyword facts in the model ER diagram of a single business process are selected and marked to form a fact table; then all the rest tables are composited into a plane table with single-connection keywords capable of directly connecting to the fact table, so that a dimensionality table is formed. With the adoption of a dimensionality extension platform implemented by the modeling method, the secondary development problem is avoided directly through dimensionality definition and standard date access; according to the modeling method, modern information technology and advanced management idea are utilized to improve the efficiency and quality of project management, so that the informationization and real-time decision-making of transmission and transformation project management are realized.

Description

A kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension
Technical field
The invention belongs to the project of transmitting and converting electricity construction field, particularly a kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension.
Background technology
The project of transmitting and converting electricity implementation management, mainly control progress and whole construction situation, actual conditions because project of transmitting and converting electricity is built, have close relationship with geography information, and the project of transmitting and converting electricity construction has been introduced Geographic Information System and realized vivid displaying and management as carrier.
In recent years, along with the develop rapidly of power grid construction, high-level management, difficulty of construction strengthens, how to improve scientific and technical innovation, the management innovation ability of power grid construction, how to protect project of transmitting and converting electricity construction progress, quality and safety, become the emphasis of project of transmitting and converting electricity implementation management.The capital constructions such as power construction constituent parts computing machine, the network equipment are substantially sound at present; Aspect software, especially the professional system of engineering construction information management aspect relatively is short of, and is difficult to meet the needs of project of transmitting and converting electricity management.
This current class be take Geographic Information System as basic management system, with other software systems, has same problem: demand can change and change along with the requirement of management, and the variation of demand has brought not stopping of developing to change.
As from the foregoing, problem in the urgent need to address is, when how to realize the expansion of business scope, to avoid or reduce the work of system development, and there is no associated description in prior art.
Summary of the invention
The object of the present invention is to provide a kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension.
The technical solution that realizes the object of the invention is: a kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension comprises the following steps:
Step 1, the geography information dimension is carried out abstract, make normalized ER figure;
Step 2, normalized ER figure is divided into to the business procession of dispersion, then modeling separately;
Step 3, select the many-to-many relationship that contains data or the additive property non-keyword fact in the model E R figure of single business procedure, they are labeled as to fact table;
Step 4, all tables that are left are combined into to the flat table with the monotroded key word that is directly connected to fact table, thereby form dimension table;
Step 5, incidence relation is set up in master meter and geographic position and exhibition information, thereby complete the dimension modeling; Wherein geographic position comprises longitude, dimension and height, and exhibition information comprises icon, color and map level.
Compared with prior art, its remarkable advantage is in the present invention: 1) the dimension expansion platform of invention, directly by dimension, define and the normal data access, and avoided the problem of secondary development; 2) the present invention is except being applicable to the project of transmitting and converting electricity construction field, equally also is applicable to the business of the other field that other need to be based on Geographic Information System; 3) the present invention utilizes modern information technologies and advanced management thought, improves efficiency and the quality of engineering management, realizes project of transmitting and converting electricity IT application in management and decision-making real time implementation.
Below in conjunction with accompanying drawing, the present invention is described in further detail.
The accompanying drawing explanation
Fig. 1 is geography information figure layer schematic diagram of the present invention.
Fig. 2 is a kind of modeling method process flow diagram of expanding the project of transmitting and converting electricity implementation management display platform of dimension of the present invention.
Embodiment
In conjunction with Fig. 1 and Fig. 2, a kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension of the present invention comprises the following steps:
Step 1, the geography information dimension is carried out abstract, make normalized ER figure;
Step 2, normalized ER figure is divided into to the business procession of dispersion, then modeling separately;
Step 3, select the many-to-many relationship that contains data or the additive property non-keyword fact in the model E R figure of single business procedure, they are labeled as to fact table;
Step 4, all tables that are left are combined into to the flat table with the monotroded key word that is directly connected to fact table, thereby form dimension table;
Step 5, incidence relation is set up in master meter and geographic position and exhibition information, thereby complete the dimension modeling; Wherein geographic position comprises longitude, dimension and height, and exhibition information comprises icon, color and map level.
Below in conjunction with embodiment, the present invention is done to further detailed description:
Embodiment 1
A kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension comprises the following steps:
Step 1, Jiangsu Province's geography information dimension is carried out abstract, make normalized ER figure;
Step 2, normalized ER figure is divided into to the business procession of dispersion, then modeling separately;
Step 3, select the many-to-many relationship that contains data or the additive property non-keyword fact in the model E R figure of single business procedure, they are labeled as to fact table;
Step 4, all tables that are left are combined into to the flat table with the monotroded key word that is directly connected to fact table, thereby form area, Jiangsu Province dimension table;
Step 5, incidence relation is set up in master meter and geographic position and exhibition information, thereby complete the dimension modeling; Wherein geographic position comprises each department, Jiangsu Province longitude, dimension and height, and exhibition information comprises icon, color and map level.
Embodiment 2
A kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension comprises the following steps:
Step 1, Shanghai City geography information dimension is carried out abstract, make normalized ER figure;
Step 2, normalized ER figure is divided into to the business procession of dispersion, then modeling separately;
Step 3, select the many-to-many relationship that contains data or the additive property non-keyword fact in the model E R figure of single business procedure, they are labeled as to fact table;
Step 4, all tables that are left are combined into to the flat table with the monotroded key word that is directly connected to fact table, thereby form area, Shanghai City dimension table;
Step 5, incidence relation is set up in master meter and geographic position and exhibition information, thereby complete the dimension modeling; Wherein geographic position comprises each department, Shanghai City longitude, dimension and height, and exhibition information comprises icon, color and map level.
As from the foregoing, a kind of modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension of the present invention, directly define by dimension and the normal data access, avoided the problem of secondary development; Except being applicable to the project of transmitting and converting electricity construction field, equally also be applicable to the business of the other field that other need to be based on Geographic Information System; The present invention utilizes modern information technologies and advanced management thought, improves efficiency and the quality of engineering management, realizes project of transmitting and converting electricity IT application in management and decision-making real time implementation.

Claims (3)

1. the modeling method that can expand the project of transmitting and converting electricity implementation management display platform of dimension, is characterized in that, comprises the following steps:
Step 1, the geography information dimension is carried out abstract, make normalized ER figure;
Step 2, normalized ER figure is divided into to the business procession of dispersion, then modeling separately;
Step 3, select the many-to-many relationship that contains data or the additive property non-keyword fact in the model E R figure of single business procedure, they are labeled as to fact table;
Step 4, all tables that are left are combined into to the flat table with the monotroded key word that is directly connected to fact table, thereby form dimension table;
Step 5, incidence relation is set up in master meter and geographic position and exhibition information, thereby complete the dimension modeling.
2. the modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension according to claim 1, is characterized in that, in step 5, geographic position comprises longitude, latitude and height.
3. the modeling method of expanding the project of transmitting and converting electricity implementation management display platform of dimension according to claim 1, is characterized in that, in step 5, exhibition information comprises icon, color and map level.
CN2013103189294A 2013-07-27 2013-07-27 Modeling method for transmission and transformation project construction management display platform with extensible dimensionality Pending CN103440362A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2013103189294A CN103440362A (en) 2013-07-27 2013-07-27 Modeling method for transmission and transformation project construction management display platform with extensible dimensionality

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2013103189294A CN103440362A (en) 2013-07-27 2013-07-27 Modeling method for transmission and transformation project construction management display platform with extensible dimensionality

Publications (1)

Publication Number Publication Date
CN103440362A true CN103440362A (en) 2013-12-11

Family

ID=49694055

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2013103189294A Pending CN103440362A (en) 2013-07-27 2013-07-27 Modeling method for transmission and transformation project construction management display platform with extensible dimensionality

Country Status (1)

Country Link
CN (1) CN103440362A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108647339A (en) * 2018-05-14 2018-10-12 五八有限公司 A kind of dimensionality analysis method, apparatus, equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120109888A1 (en) * 2010-07-28 2012-05-03 Beijing Borqs Software Technology Co., Ltd. Data partitioning method of distributed parallel database system
CN102750363A (en) * 2012-06-13 2012-10-24 天津市规划信息中心 Construction method of urban geographic information data warehouse
CN103106188A (en) * 2013-02-21 2013-05-15 用友软件股份有限公司 Imaging analysis system and imaging analysis method of data model

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120109888A1 (en) * 2010-07-28 2012-05-03 Beijing Borqs Software Technology Co., Ltd. Data partitioning method of distributed parallel database system
CN102750363A (en) * 2012-06-13 2012-10-24 天津市规划信息中心 Construction method of urban geographic information data warehouse
CN103106188A (en) * 2013-02-21 2013-05-15 用友软件股份有限公司 Imaging analysis system and imaging analysis method of data model

Non-Patent Citations (6)

* Cited by examiner, † Cited by third party
Title
刘军 等: "基于数据仓库的维度建模优化", 《计算机与数字工程》 *
叶彬 等: "数据仓库在电力系统中的应用", 《电力系统及其自动化学报》 *
李施斌: "Web GIS技术在输变电工程项目管理系统中的应用研究", 《中国优秀硕士学位论文全文数据库工程科技Ⅱ辑(月刊)》 *
王晓辉: "基于SOA的电力GIS平台及关键技术研究", 《中国博士学位论文全文数据库信息科技辑(月刊)》 *
王蕊 等: "基于 GIS 的输变电项目景观可视化环境影响评价研究", 《气象与环境学报》 *
高晓菲: "基于数据仓库的电力支持决策系统", 《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108647339A (en) * 2018-05-14 2018-10-12 五八有限公司 A kind of dimensionality analysis method, apparatus, equipment and storage medium

Similar Documents

Publication Publication Date Title
CN107067163A (en) A kind of breakdown maintenance work dispatching method and device
CN104794609A (en) Instant communication system capable of supporting enterprise cooperative office
CN105787827A (en) Intelligent scenic spot informationized integrated management platform
Huang et al. Next-generation innovation and development of intelligent transportation system in China
CN103955566A (en) Electric transmission line three-dimensional design method based on Google Earth and electric transmission line three-dimensional design system based on Google Earth
CN104951994A (en) GIS-based comprehensive display method and system of distribution network production special topic view
CN104506623A (en) Method and device for displaying information of net friends of social network
CN105608119A (en) Rapid thematic map drawing technology
CN111988404B (en) Intelligent production and operation integrated digital platform
CN111669764B (en) Novel mobile base station site selection method, system and computer equipment based on GIS technology
CN104461423A (en) Resource information distribution display method and device based on GIS
CN104850068B (en) A kind of intelligent modeling method of complicated production manufacture process
CN107564401A (en) Project map shows method in real time
CN105610487B (en) Cross-domain coordinated scheduling method for satellite observation resources
CN103440362A (en) Modeling method for transmission and transformation project construction management display platform with extensible dimensionality
CN104574214A (en) Grid power distribution network emergency repair displaying method and system
CN107121688A (en) A kind of location tracking system for security device
Patzold The role of 5g in limiting the impact of the covid-19 pandemic [mobile radio]
CN203301527U (en) Cloud server-based building information modeling (BIM) collaborative design device
CN106204212A (en) A kind of difference quotient agent management system based on APP
CN105678508A (en) Project complete period management man-machine interaction system
Xu et al. Based on the owner of the construction project management research
CN103942646A (en) Power communication resource management system
CN112241869A (en) Intelligent management method for entrepreneurship park
Leung et al. Energy efficiency in buildings in Asia: Realizing the untapped opportunity

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20131211