CN107450908B - Design method of energy consumption information acquisition system data organization structure - Google Patents
Design method of energy consumption information acquisition system data organization structure Download PDFInfo
- Publication number
- CN107450908B CN107450908B CN201710472273.XA CN201710472273A CN107450908B CN 107450908 B CN107450908 B CN 107450908B CN 201710472273 A CN201710472273 A CN 201710472273A CN 107450908 B CN107450908 B CN 107450908B
- Authority
- CN
- China
- Prior art keywords
- information acquisition
- acquisition system
- type
- energy consumption
- node
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a design method of a data organization structure of an energy consumption information acquisition system, which comprises the following steps of 1, dividing the data organization structure of the energy consumption information acquisition system into areas, large users and stations; 2. defining a data format of the data organization structure node by adopting a JSON format; 3. establishing a JavaWeb project by using Eclipse software, importing an energy consumption information acquisition system project, and creating a unit and a user file through a 'unit management' and 'user file' function menu; 4. and accessing a system database through the JDBC API to read out the data organization structure, converting the List object read from the database into a standard JSON character string through a fromObject of the JSONArray, and calling a Tree plug-in provided by easy UI to display the data in a left-side Tree form. The invention is compatible with the actual situation of collecting and reading the electricity, water, gas and heat meters, can flexibly realize the display of the organization structure, can embody the relation between the organization structures, and can inquire the user and meter situation under the organization unit by simply clicking.
Description
Technical Field
The invention relates to the technical field of energy consumption information acquisition systems, in particular to a design method of a data organization structure of an energy consumption information acquisition system.
Background
In order to realize the collection and reading of four meters of electricity, water, gas and heat, an energy operation dynamic data integration platform across industries needs to be built: energy consumption information acquisition system. At present, the construction of an energy-using information acquisition system usually takes an electric meter centralized reading system as a basic system, and then integrates the acquired data of water, gas and heat. The current electric meter reading system forms a uniform industry specification, and the data organization structure of the current electric meter reading system is generally divided into: transformer area, large users and transformer substations. However, some data organization structures of the existing electric meter centralized reading system are not suitable for the process of introducing water, gas and heat meters for centralized reading. For example, concepts of a substation and a transformer area only exist in an electric meter centralized reading system, so that the electric meter centralized reading system faces a situation of disordered data organization structure in the process of expanding and upgrading the electric meter centralized reading system into an energy consumption information acquisition system for realizing four-meter centralized reading. If the energy information acquisition system for constructing the data organization structure of the existing electric meter centralized reading system is directly adopted, the following technical problems are solved:
1. the compatibility and expandability of a data organization structure are poor;
2. the organization structures can only be listed simply, and the relation among the organization units cannot be shown in the transverse direction;
3. only the organization unit is reached in the longitudinal direction, and the user and meter conditions under the organization unit cannot be shown.
Disclosure of Invention
In order to enable the data organization structure of the existing electric meter centralized reading system to be compatible with water, gas and heat meters better and solve the defects in the prior art, the invention designs a new energy consumption information acquisition system data organization structure, which is divided into: the method has the advantages that three categories of areas, large users and stations are expanded, so that the method is effectively compatible with the practical application condition of electricity, water, gas and heat collection and reading, the display of organizational structures can be flexibly realized, the relation among the organizational structures can be reflected, and the user and meter conditions in organizational units can be inquired through simple clicking.
The technical scheme adopted by the invention is as follows:
the region can be divided into two conditions, in one condition, a sub-region can be created under the region, and the application range of the system is greatly expanded; in another case, a cell, building, cell is created under the area, and the lowest level may extend to the user level. The concept of the large user is derived from a power system, the large user corresponds to a company and an industrial park in an electric meter centralized reading system, and the concept of the large user in an energy consumption information acquisition system is expanded, for example, the large user comprises a car washing yard and an individual industrial and commercial company. The plant station includes: the transformer substation, the heating station, the gas station and the water station can be expanded to meter level by large users and stations.
And 2, defining the data format of the nodes capable of organizing the system data by using the JSON format.
Step 3, establishing a JavaWeb project by using Eclipse software, importing an energy consumption information acquisition system project and a database connected with the energy consumption information acquisition system, creating a unit and a user file by using a unit management function menu and a user file function menu in the energy consumption information acquisition system, and recording the unit and the user information into the database one by one;
and 4, accessing the energy consumption information acquisition system database through JDBC API to read out the data organization structure and the List object, converting the List object into a standard JSON character string through a fromObject of the JSONArray of the JAVA object, and calling a Tree plug-in provided by easy UI to display the data in the energy consumption information acquisition system in a left-side Tree form.
Further, the data format of the node in step 2 includes the following fields:
FLAG-FLAG, ID-node ID, PID-parent ID, TEXT-node content, ORG _ NO-node organization code, ORG _ TYPE-node organization TYPE, ICON-ICON, TYPE _ NAME-node TYPE NAME, ISLEAF-whether leaf node, ORDER _ BY-sort, ORG _ TYPE 1-parent node organization TYPE, TYPE _ NAME 1-parent node organization TYPE NAME, USER1_ METER _ TYPE-USER METER TYPE, OPEN-node whether expand, maxte-maximum TYPE value, MINTYPE-minimum TYPE value.
The different properties are explained as follows:
the FLAG-FLAG bit is 0 or 1, when the data information read from the database conforms to the JSON data format, the FLAG is 1, otherwise, the FLAG is 0;
ID-node ID, three major types of users are respectively defined as character forms, areas are defined as sel _ org, stations are defined as sel _ gtg, major users are defined as sel _ con, metering points under the areas are sel _ cus, and metering points under the stations/major users are sel _ cmp. In order to distinguish node types, the node ID is usually represented by a 'type character + ID' to avoid the situation that the area ID and the user ID are the same. For example, a certain area node ID can be generally defined as 'sel _ org 1.1.1', and a certain station ID is 'sel _ gtg 1234'.
PID-parent ID, the type and ID of which are the same;
TEXT-node content, which can be generally considered as the name of the node display;
ORG _ NO-node organization code, representing remark information of the node;
ORG _ TYPE-node organization TYPE, 1 represents area, 2 represents cell, 3 represents building, 4 represents unit; 301 represents a substation, 302 represents a water pressure station, 303 represents a gas pressure station, and 304 represents a hot pressing station; the user shows with VARCHAR2(8) (can become long to save space), and the high quads are as the extension usefulness, and the low quads from high order to low order represent ammeter, water gauge, gas table, hotlist respectively, and 1 shows to be valid, and 0 shows to be invalid. For example, if a user has an electric meter, a water meter and a gas meter, the user is represented by "00001110";
ICON-ICON, including area, district, building, unit, large user, transformer substation, hydraulic pressure station, air pressure station, hot pressing station, ammeter, water meter, gas meter, heat meter;
TYPE _ NAME-node TYPE NAME;
ISLEAF-whether it is a leaf node, 1 means yes, 0 means no.
ORDER _ BY-sequencing, wherein the ORDER _ BY-sequencing is arranged according to the sequence of areas, large users and stations, the areas are 1, the large users are 2 and the stations are 3, and the user experience is improved;
ORG _ TYPE 1-parent organization TYPE;
TYPE _ NAME 1-father node organization TYPE NAME;
USER1_ METER _ TYPE-allowed USER METER TYPEs (electric METER, water METER, gas METER and heat METER) are established, the upper four digits are used for expansion, the lower four digits represent the electric METER, the water METER, the gas METER and the heat METER from the upper digits to the lower digits respectively, 1 represents effective, and 0 represents ineffective;
OPEN — whether the node is expanded, 1 for expansion, 0 for closure;
MAXTYPE-maximum type value, controlled in code management, in the system 1 represents area, 2 represents cell, 3 represents building, 4 represents unit, 301 represents substation, 302 represents hydraulic station, 303 represents pneumatic station, 304 represents hot-pressing station, so MAXTYPE is fixed 304;
MINTPYE-minimum type value, see MAXTPYE, MINTPYE is a fixed value of 1 (to limit the number of types).
Further, when the unit and user files are established in the step 3, sub-areas or cells can be established under the areas, and only buildings and units are established under the cells, and users are established under the units; the station and the large user can only create the meter, and the user cannot be created.
The invention has the beneficial effects that:
the invention designs a data organization structure of an energy consumption information acquisition system, which is divided into the following parts: the method has the advantages that areas, large users and stations are expanded, the actual situation of electricity, water, gas and heat collection and reading of four tables is effectively compatible, the display of organization structures can be flexibly realized, the relation among the organization structures can be reflected, and the user and meter conditions under organization units can be inquired through simple clicking.
Drawings
FIG. 1 is a schematic diagram of a data organization structure of the present invention;
FIG. 2 is a data organizational diagram of a cell;
fig. 3 is a left tree representation of a certain cell data organization structure.
Detailed Description
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
FIG. 1 is a schematic diagram of the data organization structure of the present invention, the system adopts B/S mode, and the data organization structure is shown in the form of "left tree".
The design method of the data organization structure of the energy information acquisition system is realized based on the easy UI Tree plug-in, and the plug-in displays hierarchical data in a webpage in a Tree structure, thereby providing the functions of unfolding, folding, dragging, editing and asynchronous loading for users. A tree may be defined in the < ul > element. The tag may define leaf nodes and child nodes. The node will be the < li > element within the ul list, enabling full presentation of the relationship between the organizational structure in the portrait and landscape orientation.
Based on the above principle, the process of designing the data organization structure is as follows:
s1, dividing the data organization structure of the energy consumption information acquisition system into three categories, namely area, large user and station;
s2, firstly, defining the attribute of the data organization structure node, and adopting JSON format { "attribute 1": attribute value 1"," attribute 2": attribute value 2",. "attribute value n" } to define the data format of the data organization structure node;
the following takes the organization structure of a certain cell as an example to illustrate the specific implementation process of the present invention:
first, the data format of the node defining the data organization structure of the cell is: { "FLAG": "," ID ":", "PID": "," TEXT ":" "," ORG _ NO ":", "ORG _ TYPE": "," ICON ":", "TYPE _ NAME": "", "ISLEAF": "", "ORDER _ BY": "," ORG _ TYPE1":", "TYPE _ NAME1": "," USER1_ M ETER _ TYPE ":" "," OPEN ":", "MAXYPE": and "MINYPE": and "}.
The attribute values of the data organization structure nodes corresponding to this embodiment are shown in the following table:
s3, using Eclipse software to establish java web engineering, importing the energy consumption information collection system project, connecting the database of the energy consumption information collection system, and creating the unit and user profile of the cell by using the "unit management" and "user profile" function menus in the energy consumption information collection system, as shown in fig. 2. The community comprises a happy community and a new world community, enters a unit management menu, creates the happy community and the new world community, and creates buildings 1, 2, 3, 4 and 5 under the happy community; building a new world floor 5 under the new world cell, and building 2 units under the floor 5. Under the "user profile" menu, 2 users are created downstairs under happy cell # 5, and 2 users are created under new-world cell unit 2.
S4, accessing the energy-consumption information acquisition system database through JDBC API to read out the data organization structure and the List object, converting the List object into a standard JSON character string through the fromObject of the JSONArray, calling the Tree plug-in provided by easy UI to display the data in the energy-consumption information acquisition system in the form of a left-side Tree, and finally displaying the result as shown in FIG. 3.
Claims (4)
1. A design method for a data organization structure of an energy consumption information acquisition system is characterized in that the energy consumption information acquisition system is a cross-industry energy operation dynamic data integration platform for realizing the acquisition and the reading of four meters of electricity, water, gas and heat, and comprises the following steps:
step 1, dividing a data organization structure of an energy consumption information acquisition system into three categories, namely a region, a large user and a station;
step 2, defining a data format of a node capable of organizing a structure by the data of the information acquisition system by adopting a JSON format;
step 3, establishing a JavaWeb project by using Eclipse software, importing an energy consumption information acquisition system project and a database connected with the energy consumption information acquisition system, creating a unit and a user file by using a unit management function menu and a user file function menu in the energy consumption information acquisition system, and recording the unit and the user information into the database one by one;
and 4, accessing the energy consumption information acquisition system database through JDBC API to read out the data organization structure and the List object, converting the List object into a standard JSON character string through a fromObject of the JSONArray of the JAVA object, and calling a Tree plug-in provided by easy UI to display the data in the energy consumption information acquisition system in a left-side Tree form.
2. The method as claimed in claim 1, wherein the data format of the node in step 2 comprises the following fields:
FLAG-FLAG, ID-node ID, PID-parent ID, TEXT-node content, ORG _ NO-node organization code, ORG _ TYPE-node organization TYPE, ICON-ICON, TYPE _ NAME-node TYPE NAME, ISLEAF-whether leaf node, ORDER _ BY-sort, ORG _ TYPE 1-parent node organization TYPE, TYPE _ NAME 1-parent node organization TYPE NAME, USER1_ METER _ TYPE-USER METER TYPE, OPEN-node whether expand, maxte-maximum TYPE value, MINTYPE-minimum TYPE value.
3. The method as claimed in claim 2, wherein the FLAG-FLAG bit is 0 or 1; the ID-node ID is displayed in a form of type characters and ID; the users in the ORG _ TYPE-node organization TYPE are shown by VARCHAR2 (8); the ORDER _ BY-ordering is arranged according to the sequence of the region, the large user and the plant station.
4. The method for designing the data organization structure of the energy consumption information acquisition system according to claim 1, wherein when the unit and user files are created in step 3, sub-areas or cells are created under the area, and only buildings, units created under the floors and users created under the units can be created under the cells; the station and the large user can only create the meter, and the user cannot be created.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710472273.XA CN107450908B (en) | 2017-06-20 | 2017-06-20 | Design method of energy consumption information acquisition system data organization structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710472273.XA CN107450908B (en) | 2017-06-20 | 2017-06-20 | Design method of energy consumption information acquisition system data organization structure |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107450908A CN107450908A (en) | 2017-12-08 |
| CN107450908B true CN107450908B (en) | 2020-09-22 |
Family
ID=60486818
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710472273.XA Active CN107450908B (en) | 2017-06-20 | 2017-06-20 | Design method of energy consumption information acquisition system data organization structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107450908B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111782711A (en) * | 2020-07-01 | 2020-10-16 | 南京认知物联网研究院有限公司 | Water quantity data statistical method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN202189460U (en) * | 2011-07-30 | 2012-04-11 | 毛振刚 | Novel remote meter reading management system |
| CN102446221A (en) * | 2011-12-22 | 2012-05-09 | 南京联创科技集团股份有限公司 | Dynamic tree structured directory retrieval method in BS (browser/server) structure software |
| CN105205186A (en) * | 2015-10-31 | 2015-12-30 | 南京南瑞继保电气有限公司 | Data organization method for industrial enterprise energy measurement system data query |
| CN105632146A (en) * | 2015-12-30 | 2016-06-01 | 宁波三星医疗电气股份有限公司 | Collecting system for collecting water, gas, heat and electricity meter data |
| CN105893297A (en) * | 2016-06-29 | 2016-08-24 | 积成电子股份有限公司 | Four-meter centralized-reading interface converter meter reading protocol self-learning method |
| CN106781415A (en) * | 2017-01-20 | 2017-05-31 | 中国电力科学研究院 | A kind of automatic method and system for safeguarding centralized automatic meter-reading collector messaging parameter |
-
2017
- 2017-06-20 CN CN201710472273.XA patent/CN107450908B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN202189460U (en) * | 2011-07-30 | 2012-04-11 | 毛振刚 | Novel remote meter reading management system |
| CN102446221A (en) * | 2011-12-22 | 2012-05-09 | 南京联创科技集团股份有限公司 | Dynamic tree structured directory retrieval method in BS (browser/server) structure software |
| CN105205186A (en) * | 2015-10-31 | 2015-12-30 | 南京南瑞继保电气有限公司 | Data organization method for industrial enterprise energy measurement system data query |
| CN105632146A (en) * | 2015-12-30 | 2016-06-01 | 宁波三星医疗电气股份有限公司 | Collecting system for collecting water, gas, heat and electricity meter data |
| CN105893297A (en) * | 2016-06-29 | 2016-08-24 | 积成电子股份有限公司 | Four-meter centralized-reading interface converter meter reading protocol self-learning method |
| CN106781415A (en) * | 2017-01-20 | 2017-05-31 | 中国电力科学研究院 | A kind of automatic method and system for safeguarding centralized automatic meter-reading collector messaging parameter |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107450908A (en) | 2017-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102611199B (en) | Design and configuration integrated system for intelligent substation | |
| CN107272615B (en) | A kind of substation model processing method for deploying integral system | |
| CN101882812B (en) | Object-oriented implementation method for intelligent electronic device of digital substation | |
| CN101510207B (en) | Tree menu dynamic maintenance method and apparatus based on web page | |
| EP4160544A1 (en) | Three-dimensional model application method and system for nuclear power engineering modular construction | |
| CN105320811A (en) | Method for establishing topological connected model of urban underground electricity pipe network | |
| CN102184628B (en) | Intelligent divisional low-power-consumption wireless networking meter reading method | |
| CN104008162A (en) | Template based one-button type thematic map automatic forming method and system | |
| CN101944204A (en) | Geographic information system applied to power system and method for improving display efficiency thereof | |
| CN101661527A (en) | Automatic switching system from geographical wiring diagram of distribution network to single line diagram | |
| CN102622463A (en) | Drawing-model uniformity based method for automatic check of design drawings | |
| CN108153965B (en) | Method for automatically generating interval chart based on SCD file | |
| CN104008218A (en) | Electric power engineering three-dimensional integrated design platform | |
| CN108170855B (en) | CityGML and IFC data unified query and data extraction method | |
| CN105608119A (en) | Rapid thematic map drawing technology | |
| KR102311360B1 (en) | 3d modeling file conversion system | |
| CN104978411A (en) | Train model development method and apparatus for high-speed train | |
| CN105701271A (en) | Creating and deleting method for device in electric power system graph/model hybrid simulation modeling | |
| CN107450908B (en) | Design method of energy consumption information acquisition system data organization structure | |
| CN112948572A (en) | Method for visually displaying equipment information and relation of power system through knowledge graph | |
| KR101021486B1 (en) | Interactive operating procedures system based on the web for nuclear or thermal power plant | |
| CN107885840A (en) | Urban information model service method and system | |
| CN101739498B (en) | Method for accurately designing and building ArcGIS symbol library | |
| CN103036705B (en) | The visualization system of pipeline and fiber optic resource management system | |
| CN104503769A (en) | Character dot matrix liquid crystal interface implementation method based on XML (extensive markup language) configuration file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |