CN110163492B - Index processing method and device of rail transit energy management system and storage medium - Google Patents
Index processing method and device of rail transit energy management system and storage medium Download PDFInfo
- Publication number
- CN110163492B CN110163492B CN201910365323.3A CN201910365323A CN110163492B CN 110163492 B CN110163492 B CN 110163492B CN 201910365323 A CN201910365323 A CN 201910365323A CN 110163492 B CN110163492 B CN 110163492B
- Authority
- CN
- China
- Prior art keywords
- data
- index
- record
- calculation
- factor
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 19
- 238000004364 calculation method Methods 0.000 claims abstract description 273
- 238000013507 mapping Methods 0.000 claims abstract description 43
- 238000012545 processing Methods 0.000 claims abstract description 43
- 238000012544 monitoring process Methods 0.000 claims abstract description 37
- 238000012216 screening Methods 0.000 claims abstract description 24
- 238000004590 computer program Methods 0.000 claims description 22
- 238000012423 maintenance Methods 0.000 abstract description 3
- 238000000034 method Methods 0.000 description 18
- 230000006870 function Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000004378 air conditioning Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000005265 energy consumption Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 239000003550 marker Substances 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000004134 energy conservation Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000004886 process control Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G06Q50/40—
Abstract
The invention provides an index processing method, an index processing device and a computer readable storage medium of a rail transit energy management system, wherein the index processing method comprises the following steps: the rail transit energy management system is connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through interfaces, and data are collected; determining a calculation index record and a factor index record in a database of the rail transit energy management system; determining factor index data corresponding to the factor index record from the acquired data, and updating the database based on the factor index data; searching a factor index record having a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain calculation index data; updating the database based on the calculated metric data. The invention avoids the complicated operation of manual screening and editing, reduces the maintenance workload and improves the reliability of index processing.
Description
Technical Field
The invention belongs to the technical field of rail transit, and particularly relates to an index processing method and device of a rail transit energy management system and a computer readable storage medium.
Background
With the development of the rail transit industry and the improvement of the national energy-saving policy, the construction of the rail transit energy management system is more and more emphasized. The rail transit energy management system is a system for monitoring, counting and evaluating rail transit energy consumption, and can better achieve the purposes of energy conservation and emission reduction based on indexes in the rail transit energy management system.
In the prior art, a calculation formula or a report form is usually adopted to construct a calculation model of indexes in a rail transit energy management system, the calculation model needs to be manually edited one by one, and because of differences of collected data sources of station ends in a rail transit line, each station end needs to construct a calculation model independently, the complexity of manual screening and editing increases along with the continuous increase of the types of data, the data calculation errors in the indexes caused by human factors cannot be avoided, and the reliability of index processing is low.
Disclosure of Invention
The embodiment of the invention provides an index processing method and device of a rail transit energy management system and a computer readable storage medium, which can improve the reliability of index processing in the rail transit energy management system.
The technical scheme of the embodiment of the invention is realized as follows:
the embodiment of the invention provides an index processing method of a rail transit energy management system, which comprises the following steps:
the rail transit energy management system is connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through interfaces, and data are collected;
determining a calculation index record and a factor index record in a database of the rail transit energy management system;
determining factor index data corresponding to the factor index record from the acquired data, and updating the database based on the factor index data;
searching a factor index record having a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain calculation index data;
updating the database based on the calculated metric data.
The embodiment of the invention provides an index processing device of a rail transit energy management system, which comprises:
the acquisition unit is used for being connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through the rail transit energy management system and acquiring data;
the determining unit is used for determining a calculation index record and a factor index record in a database of the rail transit energy management system;
the first updating unit is used for determining factor index data corresponding to the factor index record from the acquired data and updating the database based on the factor index data;
the searching unit is used for searching the factor index record which has a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain the calculation index data;
a second updating unit for updating the database based on the calculated index data.
The embodiment of the invention provides an index processing device of a rail transit energy management system, which comprises a memory, a processor and a computer program which is stored in the memory and can run on the processor, wherein the processor realizes the following steps when executing the computer program:
the rail transit energy management system is connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through interfaces, and data are collected;
determining a calculation index record and a factor index record in a database of the rail transit energy management system;
determining factor index data corresponding to the factor index record from the acquired data, and updating the database based on the factor index data;
searching a factor index record having a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain calculation index data;
updating the database based on the calculated metric data.
An embodiment of the present invention provides a computer-readable storage medium, in which a computer program is stored, and when executed by a processor, the computer program implements:
the rail transit energy management system is connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through interfaces, and data are collected;
determining a calculation index record and a factor index record in a database of the rail transit energy management system;
determining factor index data corresponding to the factor index record from the acquired data, and updating the database based on the factor index data;
searching a factor index record having a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain calculation index data;
updating the database based on the calculated metric data.
The embodiment of the invention has the beneficial effects that:
the embodiment of the invention is connected with a rail transit comprehensive monitoring system, an electric power monitoring system and an energy-saving control cabinet through a rail transit energy management system, collects data, updates a database based on the data corresponding to the factor index records in the database, searches the factor index records with a mapping relation with the calculation index records to be updated in the database, calculates the data in the searched factor index records to obtain the calculation index data, and updates the database based on the calculation index data.
Drawings
Fig. 1 is a flowchart of an implementation of an index processing method of a rail transit energy management system according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating an implementation of establishing a mapping relationship between a calculation index record and a factor index record according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating an implementation of calculating the calculated index data and updating the database according to an embodiment of the present invention;
FIG. 4 is a flowchart of another implementation of establishing a mapping relationship between a calculation index record and a factor index record according to an embodiment of the present invention;
fig. 5 is a flowchart illustrating an implementation of determining a calculation index record and a factor index record in a database of a rail transit energy management system according to an embodiment of the present invention;
FIG. 6 is a flow chart of an implementation of updating a database at a hub according to an embodiment of the present invention;
FIG. 7 is a flow chart of an implementation of establishing a data set according to an embodiment of the present invention;
fig. 8 is a block diagram of an index processing apparatus of a rail transit energy management system according to an embodiment of the present invention;
fig. 9 is a schematic diagram of an index processing device of a rail transit energy management system according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to explain the technical means of the present invention, the following description will be given by way of specific examples.
Fig. 1 shows an implementation flow of an index processing method of a rail transit energy management system provided by an embodiment of the present invention, which is detailed as follows:
and S101, connecting the rail transit energy management system with a rail transit comprehensive monitoring system, an electric power monitoring system and an energy-saving control cabinet through interfaces, and acquiring data.
The rail transit energy management System is a System for monitoring, counting and evaluating energy consumption generated in the rail transit operation process, and is connected with a rail transit Integrated monitoring System (ISCS), an electric power monitoring System and an energy-saving Control cabinet through interfaces so as to realize data acquisition, namely, the rail transit Integrated monitoring System, the electric power monitoring System and the energy-saving Control cabinet are used as data sources to acquire data from the data sources. The rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet are usually deployed at a station end, and the energy-saving control cabinet is a part of a rail transit energy management system, wherein the rail transit comprehensive monitoring system is used for realizing the functions of monitoring, remote dispatching, coordinated dispatching and the like of fixed electromechanical equipment, and is particularly used for acquiring data such as 400V electric quantity data, water meter data, equipment running state, station temperature, station humidity, passenger flow and the like in a rail transit station; the power monitoring system is mainly used for acquiring electric quantity data of the transformer substation, a main substation, a step-down substation and a traction hybrid substation, wherein the electric quantity data comprises 35 kilovolt electric quantity data and part of 400 volt electric quantity data; the energy-saving control cabinet mainly aims at an air conditioning system and is used for acquiring data such as pressure, flow and temperature of the air conditioning system. It should be noted that the communication protocol applied by the interface according to the embodiment of the present invention may be determined according to an actual application scenario, for example, the communication protocol may be an International Electrotechnical Commission (IEC) 104 protocol, a Modbus protocol, or an Object Linking and Embedding for Process Control (OPC) protocol, and the embodiment of the present invention does not limit this.
In S102, a calculation index record and a factor index record in a database of the rail transit energy management system are determined.
The track traffic energy management system has various data types and large data quantity, and in order to perform statistics and evaluation on the acquired data, in the embodiment of the invention, calculation index records and factor index records in a database of the track traffic energy management system are determined. The calculation index record and the factor index record are both database records, the factor index record refers to a database record which is used as a calculation factor in the database to participate in calculation, and the calculation index record refers to a database record for storing a result obtained by calculating the factor index record. The calculation index record and the factor index record can be pre-established in a database, in order to conveniently identify the two database records, the calculation index record and the factor index record can be respectively arranged in different data tables of the database, and in the step, the database record in the data tables is determined to be the calculation index record or the factor index record by identifying the data tables, wherein the data tables are the constituent parts of the database, and at least one database record is usually included in one data table.
In S103, factor index data corresponding to the factor index record is determined from the collected data, and the database is updated based on the factor index data.
And determining data corresponding to the factor index record from the acquired data, and naming the determined data as factor index data for distinguishing. Specifically, the corresponding relationship between the factor index record and the name or data address of the corresponding factor index data may be preset, and whether the data is the factor index data or not may be determined by the name or data address of the collected data.
Updating the database based on the determined factor index data, specifically, when the factor index record does not store the factor index data, adding the determined factor index data corresponding to the factor index record into the factor index record; when the factor index record stores the factor index data, the updating is realized based on the currently determined factor index data covering the original factor index data in the factor index record.
In S104, a factor index record having a mapping relationship with the calculation index record to be updated is searched, and the found factor index data in the factor index record is calculated to obtain calculation index data.
The calculation index record is a database record for storing the result obtained by calculating the factor index record, when the calculation index record needs to be updated, the factor index record having a mapping relation with the calculation index record to be updated is searched, and the factor index data in the searched factor index record is calculated to obtain the calculation index data. For example, the calculation index record is a database record storing an evaluation result of the energy usage of the air conditioning system, when the calculation index record needs to be updated, a factor index record having a mapping relationship with the calculation index record is searched, for example, a plurality of factor index records storing pressure, flow rate, temperature and the like of the air conditioning system are stored, and then the factor index data in the searched factor index records are calculated to obtain the calculation index data.
In one implementation, a calculation strategy corresponding to a calculation index record to be updated is determined, and factor index data in the found factor index record is calculated according to the calculation strategy to obtain calculation index data. For different calculation index records, the calculation modes of the calculation index data may be different, so that the calculation strategies corresponding to the calculation index records in the database can be set, when a certain calculation index record needs to be updated, the calculation strategy corresponding to the calculation index record is determined, and the factor index data in the searched factor index record is calculated according to the calculation strategy to obtain the calculation index data. The above calculation strategies include, but are not limited to, common mathematical operations, logical judgment, and advanced algorithms. For example, a certain calculation index record is used for storing a statistical result of the total passenger flow volume of the station side, and the factor index record which has a mapping relation with the calculation index record and stores the passenger flow volume of each entrance and exit of the station side, the calculation strategy corresponding to the calculation index record may be set as an addition operation, when the calculation index record needs to be updated, the addition operation is performed on the factor index data in each factor index record which has a mapping relation with the calculation index record, and the obtained result is the calculation index data. By the method, the calculation index data is obtained according to the calculation mode corresponding to the calculation index record, and the calculation accuracy is improved.
In one implementation, an update frequency corresponding to the calculation index record is determined, and a factor index record having a mapping relation with the calculation index record is searched according to the update frequency. In the embodiment of the present invention, an update frequency may be set for the calculation index record, for example, for a calculation index record in which the type of the calculation index data is an accumulated amount, the update frequency is set to be 5 to 10 seconds to perform one update, and the accumulated amount refers to an amount that continuously increases with time, such as electricity consumption degrees or water consumption degrees; for the calculation index record in which the type of the calculation index data is an analog quantity, which is a quantity having no direct relation with time, such as voltage or current, the update is performed once with the update frequency set to 2 to 3 seconds. By the method, the updating frequency corresponding to the calculation index record is determined, the factor index record having the mapping relation with the calculation index record is searched according to the set updating frequency, the updating requirement of the calculation index record can be met, and the real-time performance is improved.
In S105, the database is updated based on the calculated index data.
Updating the database based on the obtained calculation index data, and similarly, when the corresponding calculation index record does not store the calculation index data, directly adding the obtained calculation index data into the calculation index record; when the calculation index record stores the calculation index data, the original calculation index data in the calculation index record is covered based on the currently determined calculation index data. It should be noted that the database record usually includes at least one field, and different fields indicate different attributes of the database record, in the embodiment of the present invention, the factor indicator data can be set to be stored in a specified field of the factor indicator record, and the calculation indicator data can also be set to be stored in a specified field of the calculation indicator record, so as to improve the normalization of data update.
In the embodiment of the invention, the database can be updated by applying a total updating mode, and when the calculation index data corresponding to all the calculation index records in the database are calculated, the calculated calculation index data are uniformly updated into the corresponding calculation index records. In one implementation, when the number of the calculation index data exceeds the set batch number, dividing the calculated calculation index data into at least two batches according to the set batch number; and updating the database respectively based on the calculation index data of each batch, wherein the quantity of the calculation index data of each batch is not more than the set batch quantity. Since the processing capacity of the energy management system for rail transit may be limited, in addition to the whole updating manner, the system may update the batches according to the set number of batches, for example, the set number of batches is 2000, when the number of the calculation index data corresponding to different currently calculated calculation index records exceeds 2000, for example, 3000, the calculation index data is divided into two batches according to the set number of batches, the first batch is the calculated 2000 calculation index data, and the second batch is the calculated 1000 calculation index data. And then, updating the databases respectively based on the calculation index data of each batch, specifically, uniformly updating the calculation index data of the first batch into the corresponding calculation index records in the databases, and uniformly updating the calculation index data of the second batch into the corresponding calculation index records in the databases, so that the applicability of the updating operation to the rail transit energy management system is improved.
As can be known from the above exemplary implementation of fig. 1 in the embodiment of the present invention, the rail transit energy management system is connected to the rail transit integrated monitoring system, the power monitoring system, and the energy-saving control cabinet via the interfaces and collects data, determines the calculation index record and the factor index record in the database, determines the factor index data corresponding to the factor index record from the collected data, updates the database based on the factor index data, searches the factor index record having a mapping relationship with the calculation index record to be updated, calculates the factor index data in the searched factor index record to obtain the calculation index data, and updates the database based on the calculation index data, which avoids the tedious operations of manual screening and editing, can increase or decrease the database records in the database according to the actual application scenarios, and reduces the maintenance workload, the reliability of index processing in the rail transit energy management system is improved.
Fig. 2 is a flowchart illustrating an implementation of establishing a mapping relationship between a calculation index record and a factor index record according to an embodiment of the present invention, and as shown in fig. 2, the method may include the following steps:
in S201, a calculation index data set is created based on the calculation index record, and a factor index data set is created based on the factor index record.
In order to analyze the correlation between the calculation index record and the factor index record, in the embodiment of the present invention, a calculation index data set is established based on the determined calculation index record, and a factor index data set is established based on the determined factor index record, where the calculation index data set and the factor index data set are only used for indicating to classify the calculation index record and the factor index record, and a specific classification manner is not limited.
In S202, the calculation index data set and the factor index data set are polled to determine attribute data in the calculation index record and the factor index record at set attribute flag bits.
Polling is carried out on the established calculation index data set and the factor index data set, and attribute data of each calculation index record in the calculation index data set at the set attribute zone bit and attribute data of each factor index record in the factor index data set at the set attribute zone bit are determined. The attribute flag bit is a field for indicating the correlation in the set database record, and data under the attribute flag bit is named as attribute data for easy distinction.
In S203, determining the attribute data in the calculation index record as screening data, traversing the factor index data set, and comparing the traversed attribute data in the factor index record with the screening data.
When determining a factor index record corresponding to a calculation index record, determining the attribute data in the calculation index record as screening data, traversing the factor index data set, and comparing the traversed attribute data in the factor index record with the screening data.
In S204, an update factor index data set is established based on the factor index record in which the attribute data and the screening data are in consistency, and a mapping relationship is established between the calculation index record and the update factor index data set.
When the attribute data of a certain factor index record is compared with the screening data to be consistent, the factor index record is proved to be related to the calculation index record corresponding to the screening data, so that an update factor index data set is established based on the factor index record of which the attribute data is compared with the screening data to be consistent, and a mapping relation is established between the calculation index record and the update factor index data set, namely, a mapping relation is established between the calculation index record and each factor index record in the update factor index data set, wherein the established mapping relation can be a map mapping relation. For example, if the attribute data of a certain calculation index record is a "variable frequency fan", the attribute data is used as screening data, each factor index record in the factor index record is traversed, an update factor index data set is established for the factor index record of the "variable frequency fan" based on the attribute data, and a mapping relationship is established between the calculation index record and the update factor index data set. As can be known from the above exemplary implementation of fig. 2 in the embodiment of the present invention, a calculation index data set and a factor index data set are established, attribute data in each calculation index record and in each factor index record at a set attribute flag are determined, the attribute data in the calculation index record is determined as screening data, an update factor index data set is established based on the factor index record in which the attribute data is consistent with the screening data, and a mapping relationship is established between the calculation index record and the update factor index data set.
In order to better understand the contents of the embodiments of the present invention, an implementation flowchart of calculating to obtain calculation index data and updating a database is provided as shown in fig. 3, a calculation index data set is established according to calculation index records in the database, a factor index data set is established according to factor index records, attribute data of each calculation index record and each factor index record is determined, and 1: n is an integer not less than zero. Determining a calculation strategy corresponding to the calculation index record on the basis of the existing mapping relation, if a calculation program corresponding to the calculation index record is selected, calculating factor index data in N factor index records corresponding to the calculation index record according to the calculation strategy to obtain calculation index data, and updating the calculation index data into a database and specifically into the calculation index record.
In order to better understand the content of the embodiment of the present invention, another implementation flowchart for mapping the calculation index record and the factor index record is provided as shown in fig. 4, attribute data of the calculation index record is determined, and attribute data of an mth factor index record in the factor index data set is determined, where m is an integer not less than 1. When the attribute data of the calculation index record is the same as the attribute data of the mth factor index record, storing the factor index record into an update factor index data set; and when the attribute data of the calculation index record is different from the attribute data of the mth factor index record, enabling m to execute a self-increment operation, namely executing the operation that m is m +1, and then determining the attribute data of the mth factor index record updated in the factor index data set. After the mth factor index record is stored in the updated factor index data set, when m is smaller than the number of the factor index records in the factor index data set, similarly, enabling m to execute a self-increment operation, and then determining the attribute data of the updated mth factor index record in the factor index data set; and when m is not less than the number of the factor index records in the factor index data set, establishing a mapping relation between the calculation index record and the update factor index data set.
Fig. 5 is a flowchart illustrating an implementation of determining a calculation index record and a factor index record in a database of a rail transit energy management system according to an embodiment of the present invention, and as shown in fig. 5, the method may include the following steps:
in S501, a database record in the database of the track traffic energy management system is determined, and type data located in a set type flag bit in the database record is determined.
In addition to distinguishing the calculation index record and the factor index record according to the data table, another implementation manner is provided in the embodiments of the present invention, first, a database record in a database of the track transportation energy management system is determined, and type data located in a set type flag bit in the database record is determined, where the type flag bit is a field used for indicating a record type in the set database record, and for convenience of distinguishing, data under the type flag bit is named as type data.
In S502, when the type data is the first setting data, the database record is determined as the calculation index record.
When the type data of the database record is the first setting data, the database record is determined as the calculation index record.
In S503, when the type data is the second setting data, the database record is determined as the factor index record.
And when the type data of the database record is the second set data, determining the database record as the factor index record. Since the value range of the type data is limited to the first setting data and the second setting data, the type flag bit may be set as a boolean flag bit, that is, the type data is limited to two values, i.e., true and false, and the first setting data is set as true and the second setting data is set as false, or the first setting data is set as false and the second setting data is set as true.
As can be seen from the above exemplary implementation of fig. 5 in the embodiment of the present invention, the database record in the database of the rail transit energy management system is determined, and the type data in the database record at the set type flag bit is determined; when the type data is first set data, determining the database record as a calculation index record; when the type data is the second set data, the database record is determined to be the factor index record, and the embodiment of the invention determines whether the database record is the calculation index record or the factor index record by determining the type data, so that the calculation index record and the factor index record can be stored in one data table, and the freedom and the flexibility of storage are improved.
Fig. 6 is a flowchart illustrating an implementation of updating a central database according to an embodiment of the present invention, and as shown in fig. 6, the method may include the following steps:
in S601, database records in a central database of the track traffic energy management system are determined, and a database record with type data as the first setting data is determined as a calculation index record, where the central database includes database records in databases of at least two station ends.
The rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet are deployed at a station end, and the database updated in the method is substantially the database of the station end. In the embodiment of the invention, database records in the database at the center end are determined, and the database records with the type data as the first set data are determined as calculation index records, wherein the database at the center end comprises database records specific to the center end and database records in the database at least two station ends managed by the center end. It is worth mentioning that the communication connection between the central end and at least two station ends managed by the central end can be pre-established, so that the central end can conveniently obtain database records in the database of the station ends.
In S602, the field data in the calculation index record at the set field flag is determined.
And determining data of a set field zone bit in the calculation index record, wherein the field zone bit is a field which is used for indicating the field of the database record in the set database record, and for the convenience of distinguishing, the data under the field zone bit is named as field data.
In S603, when the site data is the set station site data, the calculation index record is determined as the center factor index record.
And when the field data is set station field data, determining the corresponding calculation index record as a central factor index record, and taking the original calculation index data in the calculation index record as the factor index data in the central factor index record.
In S604, when the field data is the set central field data, the calculation index record is determined as the central calculation index record.
And when the field data is set central field data, determining the corresponding calculation index record as a central calculation index record, and taking the original calculation index data in the calculation index record as the calculation index data in the central calculation index record. For example, assuming that the set station site data includes "station 1" and "station 2", the center site data is "center 1", and when the site data of a certain calculation index record of the center-side database is "station 1", the calculation index record is determined as the center factor index record; when the field data of a certain calculation index record of the center-end database is 'center 1', the calculation index record is determined as a center calculation index record.
In S605, a center factor index record having a mapping relationship with a center calculation index record to be updated is searched, and the factor index data in the searched center factor index record is calculated to obtain calculation index data.
In this step, a central factor index record having a mapping relationship with the central calculation index record to be updated in the central database is searched, and the factor index data in the searched central factor index record is calculated to obtain calculation index data. Similarly, the mapping relationship between the central calculation index record and the central factor index record can be established by using the ways of establishing a data set, polling and traversing in the above contents, which are not described herein again.
In S606, the center-side database is updated based on the calculated index data.
And after the calculation index data is obtained, updating the center database based on the calculation index data, specifically updating the corresponding center calculation index record in the center database based on the calculation index data.
As can be known from the above exemplary implementation of fig. 6 in the embodiment of the present invention, a central factor index record and a central calculation index record in a central-end database are determined, a central factor index record having a mapping relationship with the central calculation index record to be updated is searched, factor index data in the searched central factor index record is calculated to obtain calculation index data, and the central-end database is updated based on the calculation index data.
In order to better understand the content of the embodiment of the present invention, an implementation flowchart of establishing a data set is provided as shown in fig. 7, and in fig. 7, a field name is obtained first whether the target of index processing is a station side or a center side. When the object of index processing is judged to be a station end according to the field name, reading type data positioned at a type flag bit in a database record of a database, judging whether the database record is a calculation index record according to the type data, and storing the database record into a calculation index data set when the database record is the calculation index record; when the database record is not a calculation index record, the database record is stored into the factor index dataset. For another situation, namely, when the object of index processing is judged not to be a station site according to the site name but to be a center end, for convenience of explanation, assuming that all station ends of a whole track traffic line are managed by the center end, the center end database comprises database records in databases of all station ends of the whole line, in order to improve the processing efficiency, computing index records are filtered out from a plurality of database records in the center end database according to type data, the site data positioned at site marker positions in each computing index record is determined, whether the computing index record is a center computing index record is judged according to the site data, and when the computing index record is the center computing index record, the computing index record is stored in a computing index data set in the center end database; and when the calculation index record is not the central calculation index record, storing the calculation index record into a factor index data set in the central-end database.
It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
Corresponding to the index processing method of the rail transit energy management system described in the foregoing embodiment, fig. 8 shows a block diagram of an index processing apparatus of the rail transit energy management system provided in the embodiment of the present invention, and referring to fig. 8, the index processing apparatus includes:
the acquisition unit 81 is used for being connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through the rail transit energy management system and acquiring data;
a determining unit 82, configured to determine a calculation index record and a factor index record in a database of the rail transit energy management system;
a first updating unit 83, configured to determine factor index data corresponding to the factor index record from the acquired data, and update the database based on the factor index data;
the searching unit 84 is configured to search a factor index record having a mapping relationship with the calculation index record to be updated, and calculate the factor index data in the searched factor index record to obtain calculation index data;
a second updating unit 85 for updating the database based on the calculated index data.
In one implementation, the lookup unit 84 further includes:
a data set establishing unit for establishing a calculation index data set based on the calculation index record and a factor index data set based on the factor index record;
the polling unit is used for polling the calculation index data set and the factor index data set and determining attribute data which are positioned in the set attribute flag bit in the calculation index record and the factor index record;
the traversing unit is used for determining the attribute data in the calculation index record as screening data, traversing the factor index data set, and comparing the traversed attribute data in the factor index record with the screening data;
and the mapping establishing unit is used for establishing an updating factor index data set based on the factor index records with consistent attribute data and screening data in comparison and establishing a mapping relation between the calculation index records and the updating factor index data set.
In one implementation, the determining unit 82 includes:
the type data determining unit is used for determining database records in a database of the rail transit energy management system and determining type data of set type zone bits in the database records;
a first record determining unit configured to determine the database record as a calculation index record when the type data is first setting data;
and the second record determining unit is used for determining the database record as a factor index record when the type data is second set data.
In one implementation, the index processing apparatus further includes:
the central record determining unit is used for determining database records in a central database of the rail transit energy management system, determining the database records with the type data as the first set data as calculation index records, and the central database comprises database records in databases of at least two station ends;
the field data determining unit is used for determining field data positioned at a set field marker bit in the calculation index record;
the station site determining unit is used for determining the calculation index record as a center factor index record when the site data is set station site data;
the central site determining unit is used for determining the calculation index record as a central calculation index record when the site data is set central site data;
the central calculation unit is used for searching a central factor index record which has a mapping relation with a central calculation index record to be updated, and calculating factor index data in the searched central factor index record to obtain calculation index data;
and the center updating unit is used for updating the center-end database based on the calculated index data.
In one implementation, the lookup unit 84 includes:
and the strategy determining unit is used for determining a calculation strategy corresponding to the calculation index record to be updated, and calculating the factor index data in the searched factor index record according to the calculation strategy to obtain the calculation index data.
In one implementation, the second updating unit 85 includes:
the dividing unit is used for dividing the calculated calculation index data into at least two batches according to the set batch number when the number of the calculation index data exceeds the set batch number;
and the unified updating unit is used for updating the database respectively based on the calculation index data of each batch, wherein the quantity of the calculation index data of each batch is not more than the set batch quantity.
Therefore, the index processing device of the rail transit energy management system provided by the embodiment of the invention avoids the complicated operation of manual screening and editing by updating the database, reduces the maintenance workload and improves the reliability of index processing.
Fig. 9 is a schematic diagram of an index processing device of a rail transit energy management system according to an embodiment of the present invention. As shown in fig. 9, the index processing device 9 of the rail transit energy management system of the embodiment includes: a processor 90, a memory 91 and a computer program 92 stored in said memory 91 and operable on said processor 90, such as an index handling program of a rail transit energy management system. The processor 90, when executing the computer program 92, implements the index processing method embodiments of the rail transit energy management systems, such as S101 to S105 shown in fig. 1. Alternatively, the processor 90, when executing the computer program 92, implements the functions of the units in the index processing device embodiments of the rail transit energy management systems, such as the functions of the units 81 to 85 shown in fig. 8.
Illustratively, the computer program 92 may be divided into one or more units, which are stored in the memory 91 and executed by the processor 90 to carry out the invention. The one or more units may be a series of instruction segments of a computer program capable of performing specific functions, and the instruction segments are used for describing the execution process of the computer program 92 in the index processing device 9 of the rail transit energy management system. For example, the computer program 92 may be divided into an acquisition unit, a determination unit, a first update unit, a search unit, and a second update unit, and each unit has the following specific functions:
the acquisition unit is used for being connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through the rail transit energy management system and acquiring data;
the determining unit is used for determining a calculation index record and a factor index record in a database of the rail transit energy management system;
the first updating unit is used for determining factor index data corresponding to the factor index record from the acquired data and updating the database based on the factor index data;
the searching unit is used for searching the factor index record which has a mapping relation with the calculation index record to be updated, and calculating the factor index data in the searched factor index record to obtain the calculation index data;
a second updating unit for updating the database based on the calculated index data.
The index processing device 9 of the rail transit energy management system may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The index processing device of the rail transit energy management system may include, but is not limited to, a processor 90 and a memory 91. Those skilled in the art will understand that fig. 9 is only an example of the index processing device 9 of the rail transit energy management system, and does not constitute a limitation on the index processing device 9 of the rail transit energy management system, and may include more or less components than those shown in the drawings, or combine some components, or different components, for example, the index processing device of the rail transit energy management system may further include an input and output device, a network access device, a bus, and the like.
The Processor 90 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage 91 may be an internal storage unit of the index processing device 9 of the rail transit energy management system, for example, a hard disk or a memory of the index processing device 9 of the rail transit energy management system. The memory 91 may also be an external storage device of the index processing device 9 of the rail transit energy management system, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are equipped on the index processing device 9 of the rail transit energy management system. Further, the memory 91 may also include both an internal storage unit and an external storage device of the index processing apparatus 9 of the rail transit energy management system. The memory 91 is used for storing the computer program and other programs and data required by the index processing device of the rail transit energy management system. The memory 91 may also be used to temporarily store data that has been output or is to be output.
It is clearly understood by those skilled in the art that, for convenience and simplicity of description, the above division of the functional units is merely used as an example, and in practical applications, the above function distribution may be performed by different functional units according to needs, that is, the internal structure of the index processing device of the rail transit energy management system is divided into different functional units to perform all or part of the above described functions. Each functional unit in the embodiments may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units are only used for distinguishing one functional unit from another, and are not used for limiting the protection scope of the application. The specific working process of the units in the system may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method for processing the index of the rail transit energy management system may be implemented in other ways. For example, the above-described embodiments of the index processing device of the rail transit energy management system are merely illustrative, for example, the division of the units is only a logical functional division, and other division manners may be available in actual implementation, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the computer program may implement the embodiments of the method according to the embodiments. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like. It should be noted that the computer readable medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable media does not include electrical carrier signals and telecommunications signals as is required by legislation and patent practice.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. An index processing method of a rail transit energy management system is characterized by comprising the following steps:
the rail transit energy management system is connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through interfaces, and data are collected;
determining a calculation index record and a factor index record in a database of the rail transit energy management system; the calculation index record and the factor index record are preset in different data tables of a database;
determining factor index data corresponding to the factor index record from the acquired data, and updating the database based on the factor index data;
determining an updating frequency corresponding to the calculation index record to be updated, searching a factor index record having a mapping relation with the calculation index record to be updated according to the updating frequency, and calculating factor index data in the searched factor index record to obtain calculation index data;
updating the database based on the calculated metric data.
2. The index processing method of claim 1, wherein before searching for the factor index record having a mapping relationship with the calculated index record to be updated, further comprising:
establishing a calculation index data set based on the calculation index record, and establishing a factor index data set based on the factor index record;
polling the calculation index data set and the factor index data set to determine attribute data of set attribute flag bits in the calculation index record and the factor index record;
determining the attribute data in the calculation index record as screening data, traversing the factor index data set, and comparing the traversed attribute data in the factor index record with the screening data;
and establishing an updating factor index data set based on the factor index records with consistent attribute data and screening data in comparison, and establishing a mapping relation between the calculation index records and the updating factor index data set.
3. The index processing method of claim 1, wherein the determining a calculated index record and a factor index record in a database of the rail transit energy management system comprises:
determining a database record in a database of the rail transit energy management system, and determining type data of a set type zone bit in the database record;
when the type data is first set data, determining the database record as a calculation index record;
and when the type data is second set data, determining the database record as a factor index record.
4. The index processing method according to claim 3, characterized by further comprising:
determining database records in a central-end database of the rail transit energy management system, and determining the database records with type data as the first set data as calculation index records, wherein the central-end database comprises database records in databases of at least two station ends;
determining field data of a set field zone bit in the calculation index record;
when the field data is set station field data, determining the calculation index record as a center factor index record;
when the field data is set central field data, determining the calculation index record as a central calculation index record;
searching a center factor index record having a mapping relation with a center calculation index record to be updated, and calculating factor index data in the searched center factor index record to obtain calculation index data;
and updating the central-end database based on the calculated index data.
5. The index processing method of claim 1, wherein the calculating the factor index data in the found factor index record to obtain calculated index data comprises:
and determining a calculation strategy corresponding to the calculation index record to be updated, and calculating the factor index data in the searched factor index record according to the calculation strategy to obtain the calculation index data.
6. An index processing method according to any one of claims 1 to 5, wherein said updating the database based on the calculated index data includes:
when the number of the calculation index data exceeds the set batch number, dividing the calculated calculation index data into at least two batches according to the set batch number;
and updating the database respectively based on the calculation index data of each batch, wherein the quantity of the calculation index data of each batch is not more than the set batch quantity.
7. An index processing device of a rail transit energy management system is characterized by comprising:
the acquisition unit is used for being connected with the rail transit comprehensive monitoring system, the electric power monitoring system and the energy-saving control cabinet through the rail transit energy management system and acquiring data;
the determining unit is used for determining a calculation index record and a factor index record in a database of the rail transit energy management system; the calculation index record and the factor index record are preset in different data tables of a database;
the first updating unit is used for determining factor index data corresponding to the factor index record from the acquired data and updating the database based on the factor index data;
the searching unit is used for determining the updating frequency corresponding to the calculation index record to be updated, searching the factor index record with the mapping relation with the calculation index record to be updated according to the updating frequency, and calculating the factor index data in the searched factor index record to obtain the calculation index data;
a second updating unit for updating the database based on the calculated index data.
8. The index processing apparatus of claim 7, wherein the search unit further comprises:
a data set establishing unit for establishing a calculation index data set based on the calculation index record and a factor index data set based on the factor index record;
the polling unit is used for polling the calculation index data set and the factor index data set and determining attribute data which are positioned in the set attribute flag bit in the calculation index record and the factor index record;
the traversing unit is used for determining the attribute data in the calculation index record as screening data, traversing the factor index data set, and comparing the traversed attribute data in the factor index record with the screening data;
and the mapping establishing unit is used for establishing an updating factor index data set based on the factor index records with consistent attribute data and screening data in comparison and establishing a mapping relation between the calculation index records and the updating factor index data set.
9. An index processing device of a rail transit energy management system, the device comprising a memory, a processor and a computer program stored in the memory and operable on the processor, wherein the processor implements the index processing method according to any one of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium storing a computer program, wherein the computer program is executed by a processor to implement the index processing method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910365323.3A CN110163492B (en) | 2019-04-30 | 2019-04-30 | Index processing method and device of rail transit energy management system and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910365323.3A CN110163492B (en) | 2019-04-30 | 2019-04-30 | Index processing method and device of rail transit energy management system and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110163492A CN110163492A (en) | 2019-08-23 |
| CN110163492B true CN110163492B (en) | 2021-11-12 |
Family
ID=67633229
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910365323.3A Active CN110163492B (en) | 2019-04-30 | 2019-04-30 | Index processing method and device of rail transit energy management system and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110163492B (en) |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FR2897701B1 (en) * | 2006-02-17 | 2008-07-11 | Alstom Transport Sa | SECURITY SYSTEM FOR ACQUIRING DIGITAL INFORMATION. |
| US10970280B2 (en) * | 2015-10-07 | 2021-04-06 | International Business Machines Corporation | Query plan based on a data storage relationship |
| CN106447532A (en) * | 2016-09-14 | 2017-02-22 | 国网上海市电力公司 | Electric energy green evaluation method |
| CN106920047B (en) * | 2017-03-10 | 2020-11-17 | 广东电网有限责任公司电力调度控制中心 | Power grid statistical data derivation calculation method and system based on hierarchical storage model |
| CN107491505B (en) * | 2017-07-31 | 2020-06-16 | 北京市天元网络技术股份有限公司 | Universal index processing method and system |
| CN109421747B (en) * | 2017-08-30 | 2020-08-25 | 比亚迪股份有限公司 | Monitoring system and method based on rail transit |
| CN109190930A (en) * | 2018-08-14 | 2019-01-11 | 北京九狐时代智能科技有限公司 | A kind of index generation method and device |
-
2019
- 2019-04-30 CN CN201910365323.3A patent/CN110163492B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110163492A (en) | 2019-08-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034244B (en) | Line loss abnormity diagnosis method and device based on electric quantity curve characteristic model | |
| CN106372747B (en) | Random forest-based reasonable line loss rate estimation method for transformer area | |
| CN109451532A (en) | A kind of check method and device of base station location | |
| CN112305485B (en) | Method and device for correcting harmonic voltage measurement error of capacitor voltage transformer | |
| CN109450089B (en) | Transformer area low voltage identification method and device and terminal equipment | |
| CN112684400B (en) | Electric energy meter operation error data monitoring method and system for small electric quantity station area | |
| CN115048990A (en) | Carbon emission metering method and device based on intelligent park operation management scene | |
| CN114528951A (en) | Distribution network line single line diagram abnormity diagnosis and analysis method, system and device | |
| CN108072858B (en) | Electric energy meter quality management method and system and terminal equipment | |
| CN111147959B (en) | Processing method and device for change information of centralized meter reading system equipment and computer equipment | |
| CN115549078A (en) | Power grid integration planning method based on digital twinning | |
| CN112651848A (en) | Interactive park energy management and control system and method | |
| CN110555619A (en) | Power supply capacity evaluation method based on intelligent power distribution network | |
| CN110163492B (en) | Index processing method and device of rail transit energy management system and storage medium | |
| CN113627289A (en) | Deep learning-based power equipment identification method and device | |
| WO2024056050A1 (en) | Massive flexible load rapid aggregation control method and apparatus | |
| CN115908071B (en) | Method, device, equipment and medium for measuring and calculating carbon emission of urban traffic trip | |
| CN108564261A (en) | Method, apparatus and computer equipment are determined based on the power information of work ticket | |
| CN116303480A (en) | Electric energy meter error checking method based on cloud computing | |
| CN110969296A (en) | Electric heating load prediction method and device and terminal equipment | |
| CN114519267A (en) | Data updating method of underground cable model | |
| CN113376564B (en) | Smart electric meter metering correction method and device based on data analysis and terminal | |
| CN114994401A (en) | Line loss abnormity detection method and device | |
| CN116136580A (en) | Line loss grading detection method and device based on sensing equipment | |
| CN205050193U (en) | Powerline network risk analysis device |
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 | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20240417 Address after: 211100 No. 69 Suyuan Avenue, Jiangning Economic and Technological Development Zone, Nanjing City, Jiangsu Province Patentee after: NR ELECTRIC Co.,Ltd. Country or region after: China Patentee after: NR ENGINEERING Co.,Ltd. Patentee after: NR ELECTRIC POWER ELECTRONICS Co.,Ltd. Address before: 211100 No. 69 Suyuan Avenue, Jiangning Economic and Technological Development Zone, Nanjing City, Jiangsu Province Patentee before: NR ELECTRIC Co.,Ltd. Country or region before: China Patentee before: NR ENGINEERING Co.,Ltd. |