CN110941742A - Method for establishing marketing and distribution through data map - Google Patents
Method for establishing marketing and distribution through data map Download PDFInfo
- Publication number
- CN110941742A CN110941742A CN201911064820.6A CN201911064820A CN110941742A CN 110941742 A CN110941742 A CN 110941742A CN 201911064820 A CN201911064820 A CN 201911064820A CN 110941742 A CN110941742 A CN 110941742A
- Authority
- CN
- China
- Prior art keywords
- data
- distribution
- transformer
- line
- 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
- 238000009826 distribution Methods 0.000 title claims abstract description 119
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000004519 manufacturing process Methods 0.000 claims abstract description 34
- 238000005516 engineering process Methods 0.000 claims abstract description 11
- 238000013075 data extraction Methods 0.000 claims abstract description 3
- 235000015097 nutrients Nutrition 0.000 claims abstract description 3
- 238000001228 spectrum Methods 0.000 claims abstract description 3
- 238000009792 diffusion process Methods 0.000 claims description 6
- 230000005611 electricity Effects 0.000 claims description 4
- 230000002159 abnormal effect Effects 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 9
- 238000009960 carding Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 238000010835 comparative analysis Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for establishing a marketing and distribution through data map. The method comprises the following steps: (1) extracting production data: extracting data for a power supply area from a PMS production management system, comprising: transformer substation, distribution line, distribution transformer; (2) generating a distribution production topological graph: processing the production data by adopting a graph database technology; (3) marketing data extraction: extracting business data of a power supply area, comprising: power supply line, power supply area, area customer; (4) marketing data topological graph generation: processing the production data by adopting a graph database technology; (5) and (3) contrast of the difference of the nutrient distribution pattern spectrum: and comparing the power distribution production map and the marketing map of the production of the same power supply area. The invention adopts a topological map mode to check marketing and power distribution production data, accurately finds the difference of system data, improves the data checking efficiency and ensures the consistency of marketing and power distribution data. The method is suitable for being used as a data map.
Description
Technical Field
The invention relates to an operation and distribution through service in the field of electric power, in particular to an operation and distribution through data map.
Background
At present, the marketing and distribution through service mainly takes data acquisition and recording as main parts, the main mode is manual participation, and the time period is long. The carding result has large correlation with the technical experience of workers, is complex and inconsistent, cannot be verified accurately, and the marketing and distribution entities and the relationship change dynamically along with the time, so that the manual carding speed cannot catch up with the changing speed.
Disclosure of Invention
In order to establish the marketing and distribution through data map, the invention provides an establishing method of the marketing and distribution through data map. According to the method, marketing and power distribution production data are checked by adopting a topological map mode, the difference of marketing and power distribution system data is accurately found, the data checking efficiency is improved, and the consistency of marketing and power distribution data is guaranteed. The technical problem of building a marketing and distribution through data map is solved.
The technical scheme adopted by the invention for solving the technical problems is as follows:
the method comprises the following steps:
(1) extracting production data: extracting data of a power supply area from a PMS production management system, the data comprising: transformer substation, distribution line, distribution transformer;
(2) generating a distribution production topological graph: the method is characterized in that production data are processed by adopting a graph database technology, the graph database technology is characterized in that a database stored in a graphical mode is used, data which are mutually associated are formed by utilizing the relation among the data, and then the logical relation and the data relation are stored in a graphical mode; the graph database is not provided with a fixed database table and a mode structure definition of fields, the relation before the data is marked by containing attributes, and the associated data is stored in an unstructured mode, so that the associated characteristic of the data is more directly expressed, and the relation between the data is more abundantly displayed;
(3) marketing data extraction: the business data of a power supply area is extracted from the SG186 marketing business system, and the business data mainly comprises the following components: power supply line, power supply area, area customer;
(4) marketing data topological graph generation: the method is characterized in that production data are processed by adopting a graph database technology, the graph database technology is characterized in that a database stored in a graphical mode is used, data which are mutually associated are formed by utilizing the relation among the data, and then the logical relation and the data relation are stored in a graphical mode; the graph database is not provided with a fixed database table and a mode structure definition of fields, the relation before the data is marked by containing attributes, and the associated data is stored in an unstructured mode, so that the associated characteristic of the data is more directly expressed, and the relation between the data is more abundantly displayed;
(5) and (3) contrast of the difference of the nutrient distribution pattern spectrum: comparing a power distribution production map and a marketing map of production in the same power supply area;
further, extracting the production data, wherein the transformer substation data is the name of a transformer substation and the capacity of the transformer substation is 66 KV; the distribution line data comprises a line name, a line length and a power supply transformer substation; the data of the distribution transformer is the name of the transformer, the capacity of the transformer and the power supply line of the transformer; the logical relationship of the data relationship is as follows: a transformer substation-distribution line-distribution transformer relation; namely, the transformer substation outputs power to each distribution line and each distribution transformer under the distribution line;
furthermore, the power distribution production topological graph is generated by firstly taking a transformer substation as a central point, drawing a central dot, drawing dot nodes according to the corresponding relation between the transformer substation and the power distribution lines in the extracted data, taking all the power distribution lines supplied by the transformer substation as nodes, connecting the transformer substation central point and each power distribution line node through a straight line, wherein the direction of the straight line is that the transformer substation central point points to each power distribution line node, and the association and the inclusion attributes of the transformer substation and the power distribution lines are indicated;
secondly, drawing a distribution transformer node dot point by taking the distribution line node as a central point according to the corresponding relation between the distribution line data and the distribution transformer data, and connecting the distribution line node and each distribution transformer node through a straight line; the direction of the straight line points to the distribution line nodes to each distribution transformer node and the distribution transformers contained under the surface distribution line; a topological graph for displaying data relation is formed through data association of a transformer, a distribution line and a distribution transformer, the graph comprises a transformer center point, distribution line nodes, distribution transformer nodes, connection straight lines and connection directions, the connection distribution is carried out in a star-shaped mode, the transformer substation is used as the center node, the distribution line branch nodes are connected in an outward diffusion mode, lines are connected with the distribution transformer nodes in a downward diffusion mode, relation information such as transformer substation-line relation, line relation and line-distribution transformer relation is visually displayed, and the relation information is stored in a picture mode.
Further, the marketing data is extracted, and the power supply line data comprises line names, line lengths, voltage levels and substations (outlets); the station area data is the name, the circuit and the attribute (private station and public) of the station area; the platform area customer data comprises platform area names, customer names, electricity capacity, electricity price categories and industry categories; the data logic relationship is as follows: line-block customer; a plurality of transformer areas are distributed under the circuit, and the transformer areas supply power to subordinate customers;
further, generating a marketing data topological graph: firstly, taking a power supply line as a node, drawing a dot, taking all subordinated power distribution areas of the line as nodes according to the corresponding relation between the power supply line and the power distribution area in extracted data, drawing the dot node, connecting the power supply line node and each power distribution area node through a straight line, wherein the direction of the straight line is that the power supply line node points to each power distribution area node, and indicating the power supply distribution area contained in the power supply line; drawing a circular point of a central point of the transformer substation according to the corresponding relation between the data of the power supply line and the transformer substation (outlet), and connecting the power supply line node and the transformer substation (outlet) node through a straight line; the direction of the straight line points to a substation (outlet) node to which a power supply line node points, and each power supply line on the surface is supplied with power by the substation; forming a topological graph for displaying data relation by data association of a power supply line and a transformer area, wherein the graph comprises power supply line nodes, power supply area nodes, transformer central points, connecting straight lines and connecting directions, the nodes are connected and distributed in a star-shaped mode, a transformer substation is used as the central node, the power supply line nodes are connected in an outward diffusion mode, the power supply line is downwards connected with power supply area branch nodes, the relation information of the transformer area, the line and the transformer area is visually displayed, and the relation information is stored in a picture mode;
further, the marketing and distribution diagram difference comparison includes that firstly, the same transformer substation in the two diagrams is selected, line nodes and station area nodes connected with the topological structure of the transformer substation in the two diagrams are calculated respectively, transformer nodes and station area nodes in the same topological position are removed, the rest transformer nodes and station area nodes are station areas and transformers with differences in the two diagrams, firstly, the station area exists in the marketing diagram, the distribution production diagram does not exist, secondly, the station area exists in the distribution production diagram, the marketing diagram does not exist, the nodes are marked with red in the diagram, the nodes are indicated to be abnormal station areas, and marketing and distribution data difference comparison is completed.
The method has the advantages that the marketing and power distribution production data are checked by adopting a topological map mode, so that the difference of marketing and power distribution system data is accurately found, the data checking efficiency is improved, and the consistency of marketing and power distribution data is guaranteed. The method is suitable for establishing and applying the marketing and distribution through data map.
The working principle of the invention is as follows:
the method comprises the steps of generating a production standing book data map by using a database technology and utilizing relational information of a transformer substation, a distribution line, a distribution transformer, a transformer substation-line relation, a line-distribution transformer relation and the like in a production system, and establishing storage management of station-line-transformer standing book data and related incidence relations of production business based on the database. And constructing a marketing standing book data map based on the cleaned information of the transformer substation, the cleaned circuit information, the cleaned scheduling naming information of the equipment, the relevant topology and the like, and establishing the storage management of the station-line-variable-user data and the topological relation of the marketing service based on the map database. Through the comparative analysis of the atlas, a list of the different distribution areas is formed, and the distribution areas with different marketing and distribution through data are found.
The invention has the advantages that:
based on a graph data mode, a power distribution production data graph and a marketing data graph are established, nodes with differences in the graphs are compared, matching of data similarity of unknown transformer areas is achieved, systematic checking of data is carried out in a normalized mode, and daily monitoring of data transaction is strengthened.
Claims (6)
1. A method for establishing a marketing and distribution through data map is characterized by comprising the following steps: the method comprises the following steps:
extracting production data: extracting data of a power supply area from a PMS production management system, the data comprising: transformer substation, distribution line, distribution transformer;
(2) generating a distribution production topological graph: the method is characterized in that production data are processed by adopting a graph database technology, the graph database technology is characterized in that a database stored in a graphical mode is used, data which are mutually associated are formed by utilizing the relation among the data, and then the logical relation and the data relation are stored in a graphical mode; the graph database is not provided with a fixed database table and a mode structure definition of fields, the relation before the data is marked by containing attributes, and the associated data is stored in an unstructured mode, so that the associated characteristic of the data is more directly expressed, and the relation between the data is more abundantly displayed;
(3) marketing data extraction: the business data of a power supply area is extracted from the SG186 marketing business system, and the business data mainly comprises the following components: power supply line, power supply area, area customer;
(4) marketing data topological graph generation: the method is characterized in that production data are processed by adopting a graph database technology, the graph database technology is characterized in that a database stored in a graphical mode is used, data which are mutually associated are formed by utilizing the relation among the data, and then the logical relation and the data relation are stored in a graphical mode; the graph database is not provided with a fixed database table and a mode structure definition of fields, the relation before the data is marked by containing attributes, and the associated data is stored in an unstructured mode, so that the associated characteristic of the data is more directly expressed, and the relation between the data is more abundantly displayed;
(5) and (3) contrast of the difference of the nutrient distribution pattern spectrum: and comparing the power distribution production map and the marketing map of the production of the same power supply area.
2. The method for establishing a marketing through data map as claimed in claim 1, wherein: extracting the production data, wherein the transformer substation data is the name of a transformer substation and the capacity of the transformer substation is 66 KV; the distribution line data comprises a line name, a line length and a power supply transformer substation; the data of the distribution transformer is the name of the transformer, the capacity of the transformer and the power supply line of the transformer; the logical relationship of the data relationship is as follows: a transformer substation-distribution line-distribution transformer relation; namely, the transformer substation outputs power to each distribution line and each distribution transformer under the distribution line.
3. The method for establishing a marketing through data map as claimed in claim 1, wherein: the method comprises the steps of generating a distribution production topological graph, namely firstly, taking a transformer substation as a central point, drawing a central dot, drawing dot nodes according to the corresponding relation between the transformer substation and distribution lines in extracted data, taking all the distribution lines supplied by the transformer substation as nodes, connecting the transformer substation central point and each distribution line node through a straight line, and indicating the association and the inclusion attributes of the transformer substation and the distribution lines, wherein the direction of the straight line is pointed to each distribution line node from the transformer substation central point;
secondly, drawing a distribution transformer node dot point by taking the distribution line node as a central point according to the corresponding relation between the distribution line data and the distribution transformer data, and connecting the distribution line node and each distribution transformer node through a straight line; the direction of the straight line points to the distribution line nodes to each distribution transformer node and the distribution transformers contained under the surface distribution line; a topological graph for displaying data relation is formed through data association of a transformer, a distribution line and a distribution transformer, the graph comprises a transformer center point, distribution line nodes, distribution transformer nodes, connection straight lines and connection directions, the connection distribution is carried out in a star-shaped mode, the transformer substation is used as the center node, the distribution line branch nodes are connected in an outward diffusion mode, lines are connected with the distribution transformer nodes in a downward diffusion mode, relation information such as transformer substation-line relation, line relation and line-distribution transformer relation is visually displayed, and the relation information is stored in a picture mode.
4. The method for establishing a marketing through data map as claimed in claim 1, wherein: extracting marketing data, wherein the power supply line data comprises a line name, a line length, a voltage grade and a transformer substation (outlet); the station area data is the name, the circuit and the attribute (private station and public) of the station area; the platform area customer data comprises platform area names, customer names, electricity capacity, electricity price categories and industry categories; the data logic relationship is as follows: line-block customer; namely, a plurality of transformer areas are distributed under the line, and the transformer areas supply power to subordinate customers.
5. The method for establishing a marketing through data map as claimed in claim 1, wherein: marketing data topological graph generation: firstly, taking a power supply line as a node, drawing a dot, taking all subordinated power distribution areas of the line as nodes according to the corresponding relation between the power supply line and the power distribution area in extracted data, drawing the dot node, connecting the power supply line node and each power distribution area node through a straight line, wherein the direction of the straight line is that the power supply line node points to each power distribution area node, and indicating the power supply distribution area contained in the power supply line; drawing a circular point of a central point of the transformer substation according to the corresponding relation between the data of the power supply line and the transformer substation (outlet), and connecting the power supply line node and the transformer substation (outlet) node through a straight line; the direction of the straight line points to a substation (outlet) node to which a power supply line node points, and each power supply line on the surface is supplied with power by the substation; a topological graph for displaying data relation is formed through data association of a power supply line and a transformer area, the graph comprises power supply line nodes, power supply area nodes, transformer central points, connecting straight lines and connecting directions, the nodes are connected and distributed in a star mode, a transformer substation is used as the central node and is connected with the power supply line nodes in an outward diffusion mode, the power supply line is connected with power supply area branch nodes downwards, relation information of the transformer area, the transformer area and the transformer area is visually displayed, and the relation information is stored in a picture mode.
6. The method for establishing a marketing through data map as claimed in claim 1, wherein: the method comprises the steps of firstly selecting the same transformer station in two maps, respectively calculating line nodes and station area nodes connected by a topological structure of the transformer station in the two maps, removing transformer nodes and station area nodes at the same topological position, and marking the nodes in red in the maps as abnormal station areas to finish the difference comparison of marketing and distribution data, wherein the rest transformer nodes and station area nodes are the station areas and transformers with differences in the two maps.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911064820.6A CN110941742A (en) | 2019-11-04 | 2019-11-04 | Method for establishing marketing and distribution through data map |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911064820.6A CN110941742A (en) | 2019-11-04 | 2019-11-04 | Method for establishing marketing and distribution through data map |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110941742A true CN110941742A (en) | 2020-03-31 |
Family
ID=69906243
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911064820.6A Pending CN110941742A (en) | 2019-11-04 | 2019-11-04 | Method for establishing marketing and distribution through data map |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110941742A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256929A (en) * | 2020-10-23 | 2021-01-22 | 全球能源互联网研究院有限公司 | Graph database-based electric power industry expansion method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107741999A (en) * | 2017-09-01 | 2018-02-27 | 美林数据技术股份有限公司 | A kind of method of topological structure of electric cross-system Auto-matching and structure based on figure calculating and machine learning |
| RU2017109702A3 (en) * | 2017-03-23 | 2018-09-24 | ||
| CN109977273A (en) * | 2019-03-28 | 2019-07-05 | 杭州安恒信息技术股份有限公司 | A kind of topology drawing generating method, device, equipment and readable storage medium storing program for executing |
-
2019
- 2019-11-04 CN CN201911064820.6A patent/CN110941742A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| RU2017109702A3 (en) * | 2017-03-23 | 2018-09-24 | ||
| CN107741999A (en) * | 2017-09-01 | 2018-02-27 | 美林数据技术股份有限公司 | A kind of method of topological structure of electric cross-system Auto-matching and structure based on figure calculating and machine learning |
| CN109977273A (en) * | 2019-03-28 | 2019-07-05 | 杭州安恒信息技术股份有限公司 | A kind of topology drawing generating method, device, equipment and readable storage medium storing program for executing |
Non-Patent Citations (1)
| Title |
|---|
| 柴博;周爱华;裘洪彬;陈睿;宋岩;: "基于图数据库的电力通信网络运行方式建模技术" * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256929A (en) * | 2020-10-23 | 2021-01-22 | 全球能源互联网研究院有限公司 | Graph database-based electric power industry expansion method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109460833B (en) | Method and system for processing equipment data and repair work order data of distribution network fault | |
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN103970887B (en) | A kind of information flow display system and method based on GIS power distribution network figures | |
| CN109635127B (en) | Power equipment portrait knowledge map construction method based on big data technology | |
| CN103715767B (en) | Intelligent grid information integerated and display platform | |
| CN109286188B (en) | 10kV power distribution network theoretical line loss calculation method based on multi-source data set | |
| CN102403718B (en) | Generating method for power grid topological relationship based on Arcgis | |
| CN111160868A (en) | Unified distribution network frame topology construction method based on graph fusion technology | |
| CN110427521B (en) | Power distribution network single line diagram generation system | |
| CN109933634B (en) | Power system graph drawing method based on power radiation range | |
| CN105354680B (en) | GIS-based power grid section auxiliary determination analysis method | |
| CN104463702A (en) | Implementation method and system of business expansion scheme based on power grid GIS framework | |
| CN109617732A (en) | A kind of electric power wireless private network integration mixed networking and integrated management approach | |
| CN110046734B (en) | Dynamic grid dividing method and system for low-voltage power grid based on marketing and distribution front end fusion | |
| CN111192010A (en) | Standing book data processing method and device | |
| CN110826165A (en) | GIS-based power supply path display method for important power users | |
| CN109871566B (en) | Loop construction method based on power grid topology technology and storage medium | |
| CN110941742A (en) | Method for establishing marketing and distribution through data map | |
| CN103577569B (en) | Method for realizing PSASP (power system analysis software package) data file graphics on basis of SVG (scalable vector graphics) technology | |
| CN105260401A (en) | Method and device for querying and storing electric data | |
| CN111915063A (en) | Power supply path network topology analysis display method, system and storage medium based on micro-service architecture | |
| CN106940827A (en) | Modularization power supply plan automatic generation method based on AR technologies and VR technologies | |
| CN109193946B (en) | Urgent repair information release system for power consumer | |
| CN105005855A (en) | Income benefits map drawing method for grid assets group per ten thousand yuan electricity sale | |
| CN108596502B (en) | Method for simplifying geographic model of power grid to power distribution network planning service model |
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: 20200331 |