Ship power utilization state automatic statistical method and system based on ship-shore communication gateway measuring point data, and medium

Abstract

The embodiment of the invention discloses a ship electricity utilization state automatic statistical method and system based on ship-shore communication gateway measuring point data and a medium. The method comprises the steps that S1, a ship-shore communication gateway collects measuring point data of a target ship equipment state and sends the measuring point data to a cloud server; s2, the cloud server receives the ship-shore communication gateway measuring point data of the target ship and analyzes the ship-shore communication gateway measuring point data; s3, the power connection state of the target ship is judged according to the analyzed data, and statistics is carried out; s4, storing the updated power connection state and the statistical data of the target ship in a big data platform to obtain power utilization state information of the target ship; wherein the real-time data is updated to the data warehouse in real time in a streaming data processing mode, and the non-real-time data is stored in the data warehouse according to a period in an offline data processing mode.

Description

Technical Field

[0001] The present invention belongs to the field of data processing technology, in particular to the field of Internet of Things (IoT) data transmission processing technology, and specifically relates to a method, system and medium for automatically counting the power consumption status of ships based on measurement point data of ship-to-shore communication gateways. Background Art

[0002] With the growth of maritime transport, pollution caused by ships has attracted widespread public attention. To reduce pollution caused by ships in ports, shore power technology, which offers energy-saving and emission-reduction features, has been adopted as a power supply method. In the past, the status of shore power equipment and shore power usage on board ships was typically reported manually. This manual reporting process is time-consuming, results are subject to certain errors, and the statistical intervals are long, making it impossible to display the status of ships and power usage in real time. Summary of the Invention

[0003] In view of this, some embodiments disclose a method for automatically counting ship power consumption status based on measurement point data of a ship-to-shore communication gateway, comprising the steps of:

[0004] S1. The ship-shore communication gateway collects the measurement point data of the target ship equipment status and sends it to the cloud server;

[0005] S2. The cloud server receives the target ship's ship-to-shore communication gateway measurement point data and analyzes it;

[0006] S3. Determine the power connection status of the target ship based on the analyzed data and perform statistics;

[0007] S4. The updated power connection status and statistical data of the target ship are stored in the big data platform to obtain the power consumption status information of the target ship; among them, real-time data is updated to the data warehouse in real time through streaming data processing, and non-real-time data is stored in the data warehouse periodically through offline data processing.

[0008] On the other hand, some embodiments disclose an automatic statistical system for ship power consumption status based on measurement point data of a ship-to-shore communication gateway, including:

[0009] a data acquisition module configured to collect measurement point data of the target ship's equipment status using a ship-to-shore communication gateway and send the data to a cloud server;

[0010] a data analysis module configured to utilize a cloud server to receive and analyze the measurement point data of the ship-to-shore communication gateway of the target ship;

[0011] A data statistics module is configured to determine the power connection status of the target ship based on the analyzed data and to perform statistics;

[0012] The data update module is configured to store the updated power connection status and statistical data of the target ship to the big data platform to obtain the power consumption status information of the target ship; among them, real-time data is updated to the data warehouse in real time through streaming data processing, and non-real-time data is stored in the data warehouse periodically through offline data processing.

[0013] On the other hand, some embodiments disclose a computer-readable storage medium storing executable code. When the executable code is read and processed, the method for automatically counting the ship's power consumption status based on the ship-to-shore communication gateway measurement point data disclosed in the embodiments of the present invention is executed.

[0014] The embodiment of the present invention discloses an automatic statistics method for ship power consumption status based on ship-to-shore communication gateway measurement point data. By obtaining the ship status and power consumption data from the ship-to-shore communication gateway, the ship power consumption and power consumption duration are automatically counted according to the different statuses of the measurement points, replacing manual statistics and saving labor time. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 、 one Flowchart of a method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data disclosed in some embodiments. DETAILED DESCRIPTION

[0016] The term "embodiment" is used herein specifically to describe any embodiment as "exemplary," and should not be construed as superior or preferable to other embodiments. Performance indicators in the embodiments of the present invention were tested using conventional testing methods in the art, unless otherwise specified. It should be understood that the terms used in the embodiments of the present invention are intended solely to describe specific implementations and are not intended to limit the disclosure of the embodiments of the present invention.

[0017] Unless otherwise specified, the technical and scientific terms used herein have the same meanings as commonly understood by those skilled in the art to which the embodiments of the present invention pertain; any experimental methods and technical means not otherwise specified in the embodiments of the present invention refer to experimental methods and technical means commonly used by those skilled in the art.

[0018] As used herein, the terms "substantially" and "approximately" are used to describe small fluctuations. For example, they can refer to less than or equal to ±5%, such as less than or equal to ±2%, such as less than or equal to ±1%, such as less than or equal to ±0.5%, such as less than or equal to ±0.2%, such as less than or equal to ±0.1%, such as less than or equal to ±0.05%. Numerical data expressed or presented in range format herein are used for convenience and brevity only and should therefore be interpreted flexibly to include not only the values explicitly listed as the limits of the range, but also all independent values or subranges contained within the range. For example, a numerical range of "1-5%" should be interpreted to include not only the explicitly listed values of 1% to 5%, but also the independent values and subranges within the indicated range. Thus, included in this numerical range are independent values such as 2%, 3.5%, and 4%, and subranges such as 1% to 3%, 2% to 4%, and 3% to 5%, etc. This principle also applies to ranges that only list a single value. Furthermore, this interpretation applies regardless of the width of the range or the characteristics described.

[0019] Throughout this document, including in the claims, transitional terms such as "comprises," "includes," "with," "having," "contains," "involving," and "accommodating" are understood to be open-ended, meaning "including but not limited to." Only the transitional terms "consisting of" and "composed of" are closed transitional terms.

[0020] In order to better illustrate the present invention, numerous specific details are provided in the following specific examples. It should be understood by those skilled in the art that the present invention can be practiced without certain specific details. In the examples, some methods, means, instruments, and equipment well known to those skilled in the art are not described in detail in order to highlight the main purpose of the present invention.

[0021] Under the premise of no conflict, the technical features disclosed in the embodiments of the present invention can be arbitrarily combined, and the resulting technical solutions belong to the contents disclosed in the embodiments of the present invention.

[0022] Some embodiments disclose a method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data, such as Figure 1 As shown, the steps include:

[0023] S1. The ship-to-shore communication gateway collects measurement point data on the status of target ship equipment and sends it to the cloud server. Generally, to ensure data transmission security, the application layer uses username and password authentication, and the transport layer uses TLS encryption and certificate verification mechanisms to prevent man-in-the-middle attacks. The ship-to-shore communication gateway uses the server username and password and encrypts the measurement point data based on the installed signature certificate. It connects to the cloud server via the 5G / 4G communication network and sends the measurement point data to it. When the 5G / 4G communication is poor and cannot connect to the cloud server, the ship-to-shore communication gateway needs to support data caching and resend the cached data when communication is restored.

[0024] S2. The cloud server receives the target ship's ship-to-shore communication gateway measurement point data and analyzes it;

[0025] S3. Determine the power connection status of the target ship based on the analyzed data and perform statistics;

[0026] S4. The updated power connection status and statistical data of the target ship are stored in the big data platform to obtain the power consumption status information of the target ship. Generally, the power consumption status information of the target ship includes the power consumption of the ship and the duration of power consumption.

[0027] Some embodiments disclose a method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data, wherein step S1 includes:

[0028] S101. The ship-to-shore communication gateway collects the status of the target ship's equipment to form measurement point data. Typically, the ship-to-shore communication gateway is connected to the ship's electric meter equipment through an interface to collect data such as electric energy, voltage, current, and power from the electric meter. The positioning system module in the ship-to-shore communication gateway equipment is used to collect data such as system time, longitude and latitude, heading and speed to form measurement point data.

[0029] S102. Encrypt the measurement point data based on the certificate and key, and send the encrypted measurement point data to the cloud server. Typically, the ship-to-shore communication gateway uses the server username and password and encrypts the measurement point data based on the installed signature certificate.

[0030] In some embodiments, the method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data disclosed in step S2 includes:

[0031] S201. The cloud server obtains the target ship's ship-to-shore communication gateway measurement point data and parses the gateway measurement point data according to the message protocol. Typically, the data message protocol is the MQTT protocol, and the measurement point message data is transmitted and parsed according to the format of Table 1 below:

[0032] Table 1MQTT message encapsulation format

[0033] Serial number Field illustrate 1 did The ClientID filled in the MQTT report, that is, the device ID 2 utime Reporting time 3 pid PLC address 4 type 0: analog quantity, 1: remote signal quantity 5 addr Collection address (measurement point) 6 addrv Collected Value 7 ctime Collection time

[0034] S202: Parse the gateway measurement point data into measurement point power usage status data according to the measurement point table. Typically, data can be parsed according to the measurement point table listed in Table 2 below: Typically, for each measurement point data, the data format and data value range are determined. If the format is incorrect or the value is out of range, the measurement point data is deemed invalid. The system receives all measurement point data. If any measurement point has invalid data, the data for that device is invalid. Otherwise, all measurement point data for that device is saved.

[0035] Table 2 Measuring point table

[0036]

[0037]

[0038] Some embodiments disclose a method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data, wherein step S3 includes:

[0039] S301. Determine the current power connection status of the target ship based on the obtained power consumption status data of the measuring points; if the current power connection status changes, record the status change log and associate it with the corresponding measuring point data;

[0040] Generally, the current power connection status is determined based on the "Phase A Voltage" at measuring point 31 and the "Phase A Current" at measuring point 34 in Table 2: (a) If both the Phase A voltage and the Phase A current are 0, the power connection status is "Not Connected"; (b) If the Phase A voltage is greater than 0 and the Phase A current is equal to 0, the power connection status is "Connected"; (c) If the Phase A voltage is greater than 0 and the Phase A current is greater than 0, the power connection status is "Charging";

[0041] Furthermore, the current power-on state is compared with the original power-on state. If the state changes, a change log is recorded, saving the original state, new state, change time, and related measurement point data.

[0042] S302. Determine the state change cycle of a power connection based on the state change log, and count the power connection amount, power connection duration and other data of the target ship within the state change cycle. Generally, the state change cycle can be determined according to the following rules: (a) When the cable is connected, the state changes from "not connected" to "connected"; (b) When the power connection starts, the state changes from "connected" to "charging"; (c) When the power connection ends, the state changes from "charging" to "connected"; (d) When the cable is unplugged, the state changes from "connected" to "not connected".

[0043] In some embodiments, the state change process of a ship being connected to power once includes: (a) connecting the cable; (b) starting to connect the power; (c) ending the connection; and (d) unplugging the cable. In Table 2, the "combined active total electric energy" at measuring point 21 has begun to change when the power is connected. To accurately calculate the statistical data, the power connection amount is calculated using the difference in electric energy between states (a) and (d), and the power connection duration is calculated using the time difference between states (b) and (c), that is:

[0044] Power consumption = total active energy when the cable is unplugged - total active energy when the cable is connected;

[0045] Power connection time = system time when power connection ends - system time when power connection starts;

[0046] Power-on start time = system time when power is started.

[0047] Some embodiments disclose a method for automatically counting the power consumption status of a ship based on the measurement point data of a ship-shore communication gateway. Step S4: storing and updating the power connection status and statistical data of the ship to a big data platform. For real-time data, the data is updated to the data warehouse in real time through streaming data processing. Usually, for real-time data such as power connection status, flink streaming data processing technology is used for real-time update. To ensure data consistency, timestamps and watermarks are used to identify the progress in the event stream, and an allowed delay time is set so that the data is updated to the data warehouse in sequence. For non-real-time data, the data is stored in the data warehouse periodically through offline data processing. Usually, for non-real-time data such as statistical data, a heterogeneous migration method is adopted to first establish a data model, establish a mapping relationship between fields, set a data migration cycle (day / week / month) and execution time, and regularly migrate the data to the data warehouse through scheduled tasks.

[0048] Some embodiments disclose an automatic statistical system for ship power consumption status based on ship-to-shore communication gateway measurement point data, including:

[0049] a data acquisition module configured to collect measurement point data of the target ship's equipment status using a ship-to-shore communication gateway and send the data to a cloud server;

[0050] a data analysis module configured to utilize a cloud server to receive and analyze the measurement point data of the ship-to-shore communication gateway of the target ship;

[0051] A data statistics module is configured to determine the power connection status of the target ship based on the analyzed data and to perform statistics;

[0052] The data update module is configured to store the updated power connection status and statistical data of the target ship to the big data platform to obtain the power consumption status information of the target ship; among them, real-time data is updated to the data warehouse in real time through streaming data processing, and non-real-time data is stored in the data warehouse periodically through offline data processing.

[0053] The computer-readable storage medium disclosed in some embodiments stores executable code, which, when read and processed, executes the method for automatically counting the ship's power consumption status based on the ship-to-shore communication gateway measurement point data disclosed in the embodiments of the present invention.

[0054] The technical details are further illustrated below with reference to embodiments.

[0055] Example 1

[0056] In Example 1, taking ship A as an example, an automatic statistical method for ship power consumption status based on measurement point data of a ship-to-shore communication gateway is exemplified.

[0057] Ship A is equipped with a ship-to-shore communication gateway. The gateway collects measurement point data from the ship's electricity meter, encrypts it using the installed signature certificate, and sends it to a cloud messaging server in real time via the 5G / 4G network. The cloud server then receives the encrypted measurement point data messages using the MQTT protocol.

[0058] The measurement point data message sent by ship A (communication gateway FG001) is:

[0059] {"did":"FG001","utime":"2025 / 03 / 01

[0060] 00:01:18","content":[{"pid":"1","type":"0","addr":"1","addrv":"0","ctime":"2025 / 03 / 01

[0061] 00:01:18"},...,{"pid":"1","type":"0","addr":"21","addrv":"215311","ctime":"2025 / 03 / 01

[0062] 00:01:18"},...,{"pid":"1","type":"0","addr":"31","addrv":"0","ctime":"2025 / 03 / 01

[0063] 00:01:18"},...,{"pid":"1","type":"0","addr":"34","addrv":"0","ctime":"2025 / 03 / 01

[0064] 00:01:18"},...,{"pid":"1","type":"0","addr":"48","addrv":"0","ctime":"2025 / 03 / 01

[0065] 00:01:18"}]};

[0066] According to the measuring point table in Table 2, the measuring point message data is parsed into the measuring point power consumption status data, as listed in Table 3;

[0067] Table 3. Analyzed power consumption data of measuring points

[0068]

[0069]

[0070] During the power connection process of ship A, the system can receive the power consumption status data list of the corresponding changes in the measuring points and judge the power connection status, as listed in Table 4;

[0071] Table 4. Measurement point data status judgment

[0072]

[0073] According to the change of the current power-on state, the corresponding state change log can be obtained, and the results are shown in Table 5.

[0074] Table 5. Status change log

[0075]

[0076]

[0077] According to the formula, calculate the power consumption and duration of this power connection:

[0078] Power consumption = total active energy when the cable is unplugged - total active energy when the cable is connected = 220565 – 215311 = 5254 kWh;

[0079] Power connection duration = system time at the end of power connection - system time at the start of power connection = 2025 / 03 / 01 02:11:18 - 2025 / 03 / 01 00:23:16 = 6482 seconds = 1 hour 48 minutes 02 seconds;

[0080] Power-on start time = system time when power is started = 2025 / 03 / 01 00:23:16;

[0081] When updating real-time data to the data warehouse, timestamps and watermarks are used to identify progress in the event stream. The window processing time is set to 20 seconds, the allowed delay time is 10 seconds, and the watermark time is added to the power data, as shown in Table 6:

[0082] Table 6. Real-time data adding timestamp

[0083]

[0084] By adding the watermark time, the disordered data No. 4 and No. 6 can be processed in the correct window order and updated to the data warehouse.

[0085] For non-real-time data, a heterogeneous migration approach is adopted to establish mapping relationships between fields, set the data migration cycle (day / week / month) and execution time, and regularly migrate data to the data warehouse through scheduled tasks, as listed in Table 7.

[0086] Table 7. Heterogeneous migration task settings

[0087]

[0088]

[0089] The technical solutions and technical details disclosed in the embodiments of the present invention are merely illustrative of the inventive concept of the present invention and do not constitute a limitation on the technical solutions of the embodiments of the present invention. Any conventional changes, replacements or combinations of the technical details disclosed in the embodiments of the present invention have the same inventive concept as the present invention and are within the scope of protection of the claims of the present invention.

Claims

1. A method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data, characterized in that: Including steps: S1. The ship-shore communication gateway collects the measurement point data of the target ship equipment status and sends it to the cloud server; S2. The cloud server receives the target ship's ship-to-shore communication gateway measurement point data and analyzes it; S3. Determine the power connection status of the target ship based on the analyzed data and perform statistics; S4. The updated power connection status and statistical data of the target ship are stored in the big data platform to obtain the power consumption status information of the target ship; among them, real-time data is updated to the data warehouse in real time through streaming data processing, and non-real-time data is stored in the data warehouse periodically through offline data processing.

2. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 1 is characterized in that: Step S1 includes: S101, the ship-shore communication gateway collects the status of the target ship equipment and generates measurement point data; S102: Encrypt the measurement point data based on the certificate and the key, and send the encrypted measurement point data to the cloud server.

3. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 2 is characterized in that: Step S2 includes: S201. The cloud server obtains the ship-to-shore communication gateway measurement point data of the target ship and parses the gateway measurement point data according to the message protocol; S202: According to the measurement point table, the gateway measurement point data is parsed into measurement point power usage status data.

4. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 3 is characterized in that: In step S201, the data message protocol is the MQTT protocol, and the measurement point message data is transmitted and parsed according to the format of the table below: 。 5. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 3 is characterized in that: In step S202, the data is parsed according to the following measurement point table:

6. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 3 is characterized in that: Step S3 includes: S301. Determine the current power connection status of the target ship based on the obtained power consumption status data of the measuring points; if the current power connection status changes, record the status change log and associate it with the corresponding measuring point data; S302: Determine a power-on state change cycle based on the state change log, and collect data such as the power-on amount and power-on duration of the target ship within the state change cycle.

7. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 6 is characterized in that: In step S301, the current power-on status is determined according to the following rules: (a) If both the phase A voltage and phase A current are 0, the power connection status is "not connected"; (b) If the phase A voltage is greater than 0 and the phase A current is equal to 0, the power connection status is "connected"; (c) If the phase A voltage is greater than 0 and the phase A current is greater than 0, the power-on status is "charging".

8. The method for automatically counting ship power consumption status based on ship-to-shore communication gateway measurement point data according to claim 6 is characterized in that: In step S302, the state change period is determined according to the following rules: (a) Connect the cable and the status changes from "Not Connected" to "Connected"; (b) Start connecting to the power supply, and the status changes from "Connected" to "Charging"; (c) The power connection is completed and the status changes from "Charging" to "Connected"; (d) Unplug the cable and the status changes from "Connected" to "Not Connected".

9. The automatic statistical system for ship power consumption status based on the measurement point data of the ship-shore communication gateway is characterized by: include: a data acquisition module configured to collect measurement point data of the target ship's equipment status using a ship-to-shore communication gateway and send the data to a cloud server; a data analysis module configured to utilize a cloud server to receive and analyze the measurement point data of the ship-to-shore communication gateway of the target ship; A data statistics module is configured to determine the power connection status of the target ship based on the analyzed data and to perform statistics; The data update module is configured to store the updated power connection status and statistical data of the target ship to the big data platform to obtain the power consumption status information of the target ship; among them, real-time data is updated to the data warehouse in real time through streaming data processing, and non-real-time data is stored in the data warehouse periodically through offline data processing.

10. A computer-readable storage medium storing executable code, characterized in that: When the executable code is read and processed, the method for automatically counting the ship's power consumption status based on the ship-to-shore communication gateway measurement point data according to any one of claims 1 to 8 is executed.

Images