Modeling method and device for water meter equipment model, computer equipment and medium

Abstract

The invention relates to the technical field of electronic information, and discloses a water meter equipment model modeling method and device, computer equipment and a medium, and the method comprises the steps: building an asset manufacturer database of water meter equipment; acquiring operation data of each water meter device, and establishing a water meter device standard object model based on the asset manufacturer database and the operation data of each water meter device; and establishing a water meter equipment model based on the water meter equipment standard substance model. The purpose of automatically generating the simulation model by the entity water meter equipment is achieved, the large-scale water meter equipment is efficiently processed, the analysis of the simulation model can be effectively fed back to the maintenance of the water meter equipment and the production process of the water meter equipment in real time, the network transmission performance of the water meter simulation model is improved, and the production efficiency is improved. The problem that maintenance and repair of the water meter equipment cannot be effectively fed back due to lack of a simulation model corresponding to the water meter equipment is solved.

Description

Technical Field

[0001] The present invention relates to the field of electronic information technology, and in particular to a water meter equipment modeling method, device, computer equipment and medium. Background Art

[0002] NB-IOT (Narrow Band Internet of Things) smart water meters are widely used in the market, generating massive amounts of device IoT data. This data plays a vital role in monitoring device operating status, predicting faults, and optimizing performance.

[0003] However, current data analysis methods and technologies have a large amount of data lag, inaccurate water meter equipment asset identification, and are unable to efficiently process large-scale IoT (Internet of Things) data. The lack of simulation models corresponding to water meter equipment limits the transmission of water meter equipment information over the network, making it impossible to quickly report and analyze massive amounts of data and to send feedback to business systems. Consequently, it is impossible to effectively provide feedback for equipment maintenance and repair, or to promote the production process of equipment meters. Summary of the Invention

[0004] In view of this, the present invention provides a water meter equipment modeling method, apparatus, computer equipment and medium to solve the problem that the lack of a simulation model corresponding to the water meter equipment leads to ineffective feedback to the maintenance and repair of the water meter equipment.

[0005] In a first aspect, the present invention provides a method for modeling a water meter device model, the method comprising:

[0006] Establish an asset manufacturer database for water meter equipment;

[0007] Obtain the operating data of each water meter device and establish a water meter device standard model based on the asset manufacturer database and the operating data of each water meter device;

[0008] A water meter equipment model is established based on the water meter equipment standard object model.

[0009] The water meter equipment modeling method provided by the present invention realizes accurate identification of a large number of water meter equipment assets by establishing an asset manufacturer database of water meter equipment, obtains the operating data of each water meter equipment, and establishes a water meter equipment standard model based on the asset manufacturer database and the operating data of each water meter equipment, and establishes a water meter equipment model based on the water meter equipment standard model, thereby achieving the purpose of automatically generating a simulation model for the physical water meter equipment, efficiently processing large-scale water meter equipment, and the analysis of the simulation model can be effectively fed back to the repair and maintenance of the water meter equipment and the water meter equipment production process in real time, thereby improving the network transmission performance of the water meter simulation model and solving the problem that the lack of a simulation model corresponding to the water meter equipment leads to the inability to effectively feed back to the maintenance and repair of the water meter equipment.

[0010] In an optional implementation, establishing an asset manufacturer database of water meter equipment includes:

[0011] Obtain water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocols through multiple access methods;

[0012] Based on the water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol, an asset table, a manufacturer table, a protocol table, and a maintenance record table are constructed respectively;

[0013] The asset table, manufacturer table, agreement table and maintenance record table are aggregated to obtain the asset manufacturer database.

[0014] The water meter equipment modeling method provided by the present invention obtains water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol through multiple access methods, and constructs an asset table, a manufacturer table, a protocol table, and a maintenance record table based on the water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol. Finally, an asset manufacturer database of the water meter equipment is obtained, which realizes the effective identification of massive water meter equipment assets, improves the accuracy and completeness of the identification, and provides conditions for the subsequent establishment of a water meter equipment object model.

[0015] In an optional embodiment, the multiple access modes include a proxy access mode, a probe access mode, and a log access mode;

[0016] Access water meter asset information, manufacturer information corresponding to each water meter asset, and communication protocols through various access methods, including:

[0017] Water meter device asset information, manufacturer information corresponding to each water meter device asset, and communication protocol are obtained through an agent access method, a probe access method, and / or a log access method.

[0018] In an optional embodiment, obtaining water meter device asset information, manufacturer information corresponding to each water meter device asset, and communication protocol through proxy access includes:

[0019] Set up a security SDK or security agent for device identity authentication on each water meter device, report each water meter device information through the security SDK or security agent, and parse and obtain each water meter device asset information, manufacturer information, and communication protocol from each water meter device information;

[0020] The following information is obtained through probe access:

[0021] Install and deploy data scanning and parsing software, identify each water meter device information by running active scanning tasks or scheduled scanning tasks, and parse and obtain each water meter device asset information, manufacturer information, and communication protocol;

[0022] The following information is obtained through log access:

[0023] Obtain the water meter device operation log through the API interface, and identify each water meter device information based on the water meter device operation log, parse and obtain each water meter device asset information, manufacturer information and communication protocol in each water meter device information, or obtain each water meter device daily operation freeze data, or use a smart card chip or a gateway that supports the preset communication protocol to read the device daily operation freeze data and extract each water meter device asset information, manufacturer information and communication protocol.

[0024] The water meter equipment modeling method provided by the present invention obtains water meter equipment information through multiple access methods to realize the identification of each water meter equipment asset information, manufacturer information and communication protocol, ensures the integrity of water meter equipment assets, and is beneficial to the maintenance and repair of water meter equipment.

[0025] In an optional embodiment, constructing an asset table, a manufacturer table, a protocol table, and a maintenance record table based on water meter device asset information, manufacturer information corresponding to each water meter device asset, and a communication protocol includes:

[0026] Extract the asset ID, model, serial number, production date, installation location and device status information of each water meter device from the water meter device asset information and use a unified data structure to represent it to generate an asset table;

[0027] Extract the manufacturer name, contact person, contact information, address, and technical support phone number of each water meter device from the manufacturer information corresponding to each water meter device asset and represent them in a unified data structure to generate a manufacturer table;

[0028] Extract the communication protocol name, protocol frame structure, frame length, uplink information and downlink instructions of each water meter device from the communication protocol corresponding to each water meter device asset and represent them in a unified data structure to generate a protocol table;

[0029] The maintenance record ID, asset ID, maintenance date, maintenance reason, maintenance result, maintenance personnel and maintenance cost of each water meter device are extracted from the water meter device asset information and represented in a unified data structure to generate a maintenance record table.

[0030] The water meter equipment modeling method provided by the present invention realizes the initialization of water meter equipment information by establishing a water meter equipment asset table, a manufacturer table, a protocol table and a maintenance record table, quickly screens all water meter equipment assets, and ensures that all water meter assets are checked without omission. The data analysis solves the problems of data analysis failure and inability to analyze when massive water meter equipment data is accessed, and provides conditions for the subsequent establishment of a water meter equipment object model.

[0031] In an optional embodiment, the operation data of each water meter device is operation data from the water meter device operation log or device daily operation frozen data;

[0032] The water meter equipment standard model is established based on the asset manufacturer database and the operating data of each water meter equipment, including:

[0033] Generate attribute information, service information and event information of each water meter device based on the asset manufacturer database and the operation data of each water meter device;

[0034] A water meter equipment standard object model is established based on attribute information, service information and event information.

[0035] The water meter device modeling method provided by the present invention simulates the device through uplink communication and downlink instructions, constructs big data analysis, and constructs simulation data based on attribute information, service information and event information. The simulation data is used to solve the communication and positioning problems between the test Internet of Things platform and the device end, etc., providing conditions for the subsequent establishment of the water meter device model.

[0036] In an optional embodiment, establishing a water meter device model based on a water meter device standard object model includes:

[0037] The water meter device standard object model is converted into standard JSON data to obtain a water meter device model. The standard JSON data includes the expected state, report state, state document, latest update time and version number of the water meter device model.

[0038] The water meter equipment modeling method provided by the present invention converts the water meter equipment standard object model into standard JSON data to obtain the water meter equipment model. The standard JSON data includes the expected status, report status, status document, the latest update time and version number of the water meter equipment model, which facilitates the data storage of the water meter equipment model, realizes the real simulation of the water meter equipment and the purpose of network equipment, is conducive to the reporting of IOT data of the water meter equipment, solves the limitations of the water meter model in network transmission, and provides conditions for the maintenance and repair of the water meter equipment.

[0039] In a second aspect, the present invention provides a water meter equipment model modeling device, the device comprising:

[0040] Asset manufacturer database establishment module, used to establish the asset manufacturer database of water meter equipment;

[0041] A water meter equipment standard object model establishment module is used to obtain the operating data of each water meter equipment and establish a water meter equipment standard object model based on the asset manufacturer database and the operating data of each water meter equipment;

[0042] The water meter equipment model establishment module is used to establish a water meter equipment model based on the water meter equipment standard object model.

[0043] In a third aspect, the present invention provides a computer device comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the water meter equipment modeling method of the first aspect or any corresponding embodiment thereof by executing the computer instructions.

[0044] In a fourth aspect, the present invention provides a computer-readable storage medium having computer instructions stored thereon, the computer instructions being used to enable a computer to execute the water meter equipment modeling method of the first aspect or any corresponding embodiment thereof.

[0045] In a fifth aspect, the present invention provides a computer program product, comprising computer instructions for causing a computer to execute the water meter device modeling method of the first aspect or any corresponding embodiment thereof. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the specific embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0047] Figure 1is a flow chart of a method for modeling a water meter device model according to an embodiment of the present invention;

[0048] Figure 2 is a flow chart of another water meter device modeling method according to an embodiment of the present invention;

[0049] Figure 3 is a flow chart of another method for modeling a water meter device model according to an embodiment of the present invention;

[0050] Figure 4 is a schematic diagram of a process for performing data completion using a water meter device model according to an embodiment of the present invention;

[0051] Figure 5 is a structural block diagram of a water meter device modeling apparatus according to an embodiment of the present invention;

[0052] Figure 6 Schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0053] To make the purpose, technical solutions, and advantages of the embodiments of the present invention more clear, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts shall fall within the scope of protection of the present invention.

[0054] According to an embodiment of the present invention, an embodiment of a method for modeling a water meter device model is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0055] In this embodiment, a water meter device modeling method is provided, which can be used in an Internet of Things platform, where the Internet of Things platform is connected to devices such as a central processing unit and a server. Figure 1 FIG. 1 is a flow chart of a method for modeling a water meter device model according to an embodiment of the present invention. Figure 1 As shown, the process includes the following steps:

[0056] Step S101: Establishing an asset manufacturer database of water meter equipment.

[0057] Specifically, establishing an asset manufacturer database for water meter equipment means conducting asset discovery and identification on massive water meter equipment, establishing an asset manufacturer database for water meter equipment to quickly and accurately identify water meter equipment information, and reporting key information of the equipment (such as manufacturer, model, category, etc.) through different information channels. Different information channels, such as multiple access methods, include but are not limited to agents, probes, logs, and other methods, which can quickly discover water meter equipment assets and ensure that there are no omissions in the inventory of water meter equipment assets.

[0058] Step S102: Acquire the operating data of each water meter device, and establish a water meter device standard object model based on the asset manufacturer database and the operating data of each water meter device.

[0059] Specifically, the water meter equipment standard object model is the water meter equipment model information, which extracts water meter equipment attribute information, service information, event information, etc. based on the asset manufacturer database and the operation data of each water meter equipment.

[0060] The water meter equipment standard object model is obtained by summarizing attribute information, service information and event information.

[0061] Step S103: establishing a water meter device model based on the water meter device standard object model.

[0062] Specifically, the water meter device model consists of three parts: device state, device metadata, and device desired state. The device state records the device's current attributes and status; the device metadata contains additional information such as the device's identifier, type, and firmware version; and the device desired state is the device's expected state set by the application and can be used to remotely control the device.

[0063] The attribute information, service information and event information of the water meter equipment standard object model are converted into a standard data storage format to obtain the water meter equipment model.

[0064] The water meter equipment modeling method provided in this embodiment realizes accurate identification of a large number of water meter equipment assets by establishing an asset manufacturer database of water meter equipment, obtains the operating data of each water meter equipment, and establishes a water meter equipment standard object model based on the asset manufacturer database and the operating data of each water meter equipment, and establishes a water meter equipment model based on the water meter equipment standard model, thereby achieving the purpose of automatically generating a simulation model for the physical water meter equipment, efficiently processing large-scale water meter equipment, and the analysis of the simulation model can be effectively fed back to the repair and maintenance of the water meter equipment and the water meter equipment production process in real time, thereby improving the network transmission performance of the water meter simulation model and solving the problem that the lack of a simulation model corresponding to the water meter equipment leads to the inability to effectively feed back to the maintenance and repair of the water meter equipment.

[0065] In this embodiment, a water meter device modeling method is provided, which can be used in an Internet of Things platform, where the Internet of Things platform is connected to devices such as a central processing unit and a server. Figure 2 FIG. 1 is a flow chart of a method for modeling a water meter device model according to an embodiment of the present invention. Figure 2 As shown, the process includes the following steps:

[0066] Step S201: Establish an asset manufacturer database for water meter equipment.

[0067] Specifically, because each manufacturer has launched various types of water meter equipment for unique business, NB-IO water meters are emerging in an endless stream, and there are differences in water meter protocols, it is necessary to build a water meter equipment asset library and a manufacturer library. For the NB-IOT water meters launched by water meter manufacturers on the market, a one-to-one corresponding data storage library for water meter equipment manufacturers, assets, and communication protocols is established to solve problems such as data parsing failure and inability to parse when massive water meter equipment data is accessed, thereby preventing data from being delayed and losing timeliness.

[0068] The above step S201 includes:

[0069] Step S2011: Acquire water meter device asset information, manufacturer information corresponding to each water meter device asset, and communication protocol through multiple access methods.

[0070] In an optional embodiment, the multiple access modes include but are not limited to proxy access, probe access, and log access. The above step S2011 includes:

[0071] Step a: obtaining water meter device asset information, manufacturer information corresponding to each water meter device asset, and communication protocol through an agent access method, a probe access method, and / or a log access method.

[0072] The proxy access method for obtaining water meter asset information, manufacturer information corresponding to each water meter asset, and communication protocol includes:

[0073] A security SDK or security agent for device identity authentication is set up on each water meter device. Each water meter device information is reported through the security SDK or security agent, and the asset information, manufacturer information, and communication protocol of each water meter device in the information is parsed and obtained.

[0074] It should be noted that when performing the parsing operation, the manufacturer model, communication protocol and asset model in the water meter device information are first parsed, and the manufacturer model, communication protocol and asset model are converted into binary data. Finally, the asset information, manufacturer information and communication protocol of each water meter device are identified through byte pairing.

[0075] The following information is obtained through probe access:

[0076] Install and deploy data scanning and parsing software on the cloud IoT platform, identify the information of each water meter device by running the active scanning task or scheduled scanning task of the data scanning and parsing software, and parse and obtain the asset information, manufacturer information and communication protocol of each water meter device in the information of each water meter device.

[0077] Data scanning and parsing software is a tool that can identify, extract and process text, images and other information in documents. It is used in document management, data extraction and automated processing.

[0078] It should be noted that the parsing operation when using the probe access method is the same as the parsing operation when using the proxy access method.

[0079] The following information is obtained through log access:

[0080] Obtain the water meter device operation log from the cloud IoT platform or proxy server through the API interface, identify each water meter device information based on the water meter device operation log, parse and obtain each water meter device asset information, manufacturer information and communication protocol in each water meter device information, or obtain each water meter device daily operation frozen data, use the smart card chip or use a gateway that supports the preset communication protocol to read the device daily operation frozen data from the water meter storage chip to extract each water meter device asset information, manufacturer information and communication protocol.

[0081] The water meter device operation log can be synchronized with the cloud IoT platform's data and analysis platform logs and third-party log systems (third-party log systems are log recording and analysis systems provided by third parties, mainly used to monitor and manage various log information during system operation). Preset communication protocols include RS485, MBus, LoRaWAN, and others.

[0082] Step S2012: construct an asset table, a manufacturer table, a protocol table, and a maintenance record table based on the water meter device asset information, the manufacturer information corresponding to each water meter device asset, and the communication protocol.

[0083] In some optional implementations, the above step S2012 includes:

[0084] Step a1: extract the asset ID, model, serial number, production date, installation location and device status information of each water meter device from the water meter device asset information and use a unified data structure to represent it to generate an asset table.

[0085] Specifically, the unified data structure may be in a format such as Excel or CSV, which is used to standardize the relationships and storage methods between data elements. It is set according to actual conditions and is not specifically limited here.

[0086] The specific structure of the asset table is as follows: asset_id (asset ID): Uniquely identifies each device. model (model): The specific model of the device. serial_number (serial number): The unique serial number of the device. production_date (production date): The production date of the device. installation_date (installation date): The installation date of the device. location (installation location): The installation location of the device. status (device status): The current status of the device, such as online, offline, or under maintenance.

[0087] Step a2: extract the manufacturer name, contact person, contact information, address and technical support phone number of each water meter device from the manufacturer information corresponding to each water meter device asset and represent them in a unified data structure to generate a manufacturer table.

[0088] The specific structure of the vendor table is as follows: vendor_name (vendor name): the name of the device manufacturer. contact_person (contact person): the name of the manufacturer's contact person. contact_info (contact information): the manufacturer's contact phone number or email address. address (address): the manufacturer's detailed address. support_phone (technical support phone number): the manufacturer's technical support phone number.

[0089] Step a3: extract the communication protocol name, protocol frame structure, frame length, uplink information and downlink instructions of each water meter device from the communication protocol corresponding to each water meter device asset and represent them with a unified data structure to generate a protocol table.

[0090] The specific structure of the protocol table is as follows: protocol_name (protocol name): The name of the device communication protocol. frame_structure (protocol frame structure): The data frame structure of the protocol. frame_length (frame length): The length of the data frame. uplink_info (uplink information): The format of information sent by the device to the server. downlink_commands (downlink commands): The format of control commands sent by the server to the device.

[0091] Step a4: extract the maintenance record ID, asset ID, maintenance date, maintenance reason, maintenance result, maintenance personnel and maintenance cost of each water meter device from the water meter device asset information and represent them in a unified data structure to generate a maintenance record table.

[0092] The maintenance record table has the following structure: record_id (record ID): Unique identifier of the maintenance record. asset_id (asset ID): ID of the equipment being repaired. maintenance_date (maintenance date): Date of the repair. reason (maintenance reason): Reason for the repair. result (maintenance result): Result of the repair. technician (maintenance technician): Name of the technician who performed the repair. cost (maintenance cost): Cost of the repair.

[0093] The water meter device modeling method provided in this embodiment obtains water meter device information through multiple access methods to achieve identification of each water meter device's asset information, manufacturer information, and communication protocol, thereby ensuring the integrity of water meter device assets and facilitating water meter device maintenance and repair.

[0094] Step S2013: Aggregate the asset table, manufacturer table, agreement table, and maintenance record table to obtain an asset manufacturer database.

[0095] The water meter equipment modeling method provided in this embodiment initializes water meter equipment information by establishing a water meter equipment asset table, a manufacturer table, a protocol table, and a maintenance record table, quickly screening all water meter equipment assets and ensuring a thorough inventory of water meter assets. The data analysis solves the problems of data parsing failure and inability to parse when accessing massive water meter IOT data, thus providing conditions for the subsequent establishment of a water meter equipment object model.

[0096] It should be noted that when building the asset manufacturer database, a data entry module, a data query and statistics module, and an NB-IOT device management module were also built.

[0097] The data entry module is used to access the IoT platform and supports batch import of formats such as Excel and CSV, reducing the workload of manual entry. It also performs verification during data import to ensure data integrity and accuracy.

[0098] A data query and statistics module is built to help managers quickly find and analyze asset information. It supports multi-condition queries, such as by asset ID, model, manufacturer, and installation location. It provides statistical reports on water marker equipment asset distribution, usage, and failure rates, and supports exporting to formats such as PDF and Excel. It intuitively displays asset distribution and status through charts and maps.

[0099] The NB-IOT device management module integrates NB-IOT device management, enabling efficient management of NB-IOT devices. It monitors device status in real time, including online status, battery level, and signal strength. It receives, analyzes, and stores data uploaded by devices. It also supports remote control commands, such as those for opening and closing valves and adjusting water flow. Devices can be tagged, such as "High-Voltage Area" or "Key Monitoring Area," for quick and easy discovery and management. Devices can be grouped based on criteria such as geographic location and functional type for refined management.

[0100] Step S202: Obtain the operating data of each water meter device and establish a water meter device standard model based on the asset manufacturer database and the operating data of each water meter device. Figure 1 Step S102 of the illustrated embodiment will not be described in detail here.

[0101] Step S203: Establish a water meter equipment model based on the water meter equipment standard object model. Figure 1 Step S103 of the illustrated embodiment will not be described in detail here.

[0102] The water meter equipment modeling method provided in this embodiment obtains water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol through multiple access methods. Based on the water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol, an asset table, a manufacturer table, a protocol table, and a maintenance record table are respectively constructed. Ultimately, an asset and manufacturer database of water meter equipment is obtained, which realizes the effective identification of massive water meter equipment assets, improves the accuracy and completeness of identification, and provides conditions for the subsequent establishment of a water meter equipment object model.

[0103] In this embodiment, a water meter device modeling method is provided, which can be used in an Internet of Things platform, where the Internet of Things platform is connected to devices such as a central processing unit and a server. Figure 3 FIG. 1 is a flow chart of a method for modeling a water meter device model according to an embodiment of the present invention. Figure 3 As shown, the process includes the following steps:

[0104] Step S301: Establish a water meter equipment asset manufacturer database. Figure 2 Step S201 of the illustrated embodiment will not be described in detail here.

[0105] Step S302: Acquire the operating data of each water meter device, and establish a water meter device standard object model based on the asset manufacturer database and the operating data of each water meter device.

[0106] Specifically, the operation data of each water meter device is the operation data from the water meter device operation log or the device daily operation frozen data in the water meter storage chip. The above step S302 includes:

[0107] Step S3021: Generate attribute information, service information, and event information of each water meter device based on the asset manufacturer database and the operation data of each water meter device.

[0108] Specifically, attribute information includes: water meter indication, voltage, strong magnetism, valve, valve abnormality, operating status, ambient temperature, relative humidity, water temperature, water pressure, etc. Service information includes: water meter valve opening and closing, water meter value adjustment, etc. Event information includes: voltage abnormality alarm, strong magnetism alarm, valve abnormality alarm, etc.

[0109] Step S3022: Establish a water meter equipment standard object model based on attribute information, service information, and event information.

[0110] Specifically, the water meter equipment standard model is as follows:

[0111] Attributes: water_meter_reading, voltage, magnetic_field, valve_status, valve_abnormal, operating_state, environment_temperature, relative_humidity, water_temperature, water_pressure.

[0112] Services: open_valve (open valve), close_valve (close valve), adjust_water_flow (adjust water flow).

[0113] Events: voltage_anomaly_alert (voltage anomaly alarm), magnetic_field_alert (strong magnetic field alarm), valve_abnormal_alert (valve abnormal alarm).

[0114] Step S303: establishing a water meter device model based on the water meter device standard object model.

[0115] Specifically, the above step S303 includes:

[0116] Step b: converting the water meter equipment standard object model into standard JSON data to obtain the water meter equipment model. The standard JSON data includes the expected status, report status, status document, latest update time and version number of the water meter equipment model.

[0117] Specifically, a water meter device model is built based on the standard object model of the water meter device. The shadow is converted into standard JSON data (JavaScript Object Notation, a lightweight data exchange format). Taking a single NB-IoT remote valve-controlled water meter as an example, the constructed water meter device model is as follows: "desired" represents the desired state of the device. The "desired" section is included only if the water meter device model document has services and desired states.

[0118] Reported refers to the reported status of the device. The water meter device writes data in the reported section to report its latest status. Reading this parameter value obtains the device status.

[0119] Metadata refers to the device status document, which records the device status change history. The water meter device model will automatically update the metadata value after the device document is updated.

[0120] timestamp: The latest update time of the device status document, expressed as the timestamp of each attribute.

[0121] version: The version number of the water meter device model, which is synchronized with the version number of the water meter itself, is used to ensure that the document being updated is the latest version.

[0122] For water meter device model simulation, we simulated a real water meter device and established a connection with network equipment. We used uplink communication and downlink commands to simulate the device, build big data analysis, and construct simulated data based on water volume coefficients and time period water volume data. We used this simulated data to test communication and positioning issues between the IoT platform and the device.

[0123] Furthermore, the water meter device model is connected to the network, establishing a data transmission bridge between the water meter device model and the data. Multiple transmission protocols (such as MQTT (Message Queuing Telemetry Transport), 689, 485, 4G / 5G, TCP / IP, and Modbus (serial communication protocol)) are used to ensure secure and efficient data transmission. Effective reporting of water meter device data is achieved through wireless remote transmission of smart devices, data forwarding from collectors / gateways, and data integration, storage, and backup on smart terminals.

[0124] For uplink communication, water meter device model data establishes a persistent connection with the platform via the MQTT protocol, publishing the device ID and payload to the platform. After being accessed, parsed, and stored by the platform, the data is transferred in real time to the web service server via an AMQP (Advanced Message Queuing Protocol) consumer group, an application-layer standard for unified messaging services, and then invoked through the service API.

[0125] Downlink instructions can be issued by business application platforms or mobile applications. The business server calls an HTTPS-based API interface to publish to a specific topic, pushing the instructions to the underlying platform. The underlying platform then transmits the instructions quickly and efficiently to the device end via the MQTT protocol, enabling the device to execute the instructions.

[0126] The water meter device modeling method provided in this embodiment simulates the device through uplink communication and downlink commands, constructs big data analytics, and builds simulated data based on attribute information, service information, and event information. This simulated data solves communication and positioning issues between the IoT platform and the device. The water meter device model is converted into standard JSON data, which includes the model's expected state, reported state, status document, and the latest update time and version number. This facilitates data storage of the water meter device model, achieves realistic simulation of the water meter device, and integrates it with network devices. This facilitates data reporting, overcomes the limitations of water meter model network transmission, and facilitates maintenance and repair of the water meter device.

[0127] As one or more specific application examples of the embodiments of the present invention, the water meter device model obtained by the water meter device modeling method provided by the present invention is applied to a massive data completion solution, as follows:

[0128] Initialize the water meter device model: When the water meter device comes online, it reports its initial status to the cloud. The cloud then creates a water meter device model based on the received information.

[0129] Continuous state synchronization: During normal operation, water meter devices periodically send status updates to the Cloud IoT platform. These updates are recorded in the water meter device model. The Cloud IoT platform can use this information to track the latest status of the device.

[0130] Data processing when the device is offline: When the device is offline due to network problems or other reasons, it can temporarily store data in local storage. At the same time, the cloud IoT platform continues to maintain the current state of the water meter device model.

[0131] Synchronization after the device comes back online: When the device comes back online, it first queries the water meter device model to obtain the latest expected and current states. The device then uploads the locally stored data to the cloud IoT platform and merges it with the current state in the water meter device model.

[0132] Data completion logic: During the merging process, the water meter device model and the cloud IoT platform application can determine how to handle offline data based on pre-set rules. For example, the average usage rate during the device's offline period or the last reported data value can be used as a replacement value to fill in missing data.

[0133] Data consistency guarantee: To ensure data consistency, updates to water meter device models are usually atomic, that is, either all succeed or all fail, which helps avoid data conflicts and inconsistencies.

[0134] like Figure 4 As shown, the water meter device model constructed by the present invention is connected to the network layer of the device simulator simulating the real device and the cloud Internet of Things platform respectively. The communication capability between the platform and the water meter device is tested using simulated data to realize the data collection and preliminary classification of the water meter device to establish the effective data of the analysis period. The specific implementation is as follows:

[0135] a. Configure data source Topic 1, which is obtained from water meter device 1 and contains data or status information collected by various water meter devices. This data is usually delivered in JSON format or other structured form.

[0136] b. Determine the SQL expression, use the SQL statement to process the data configuration flow in the transformation data source Topic1, process the data according to the preset rules, and output the results to the target data source Topic2.

[0137] The preset rules include: ① Data validation rules, which ensure that the received data conforms to the expected format and range. For example, check whether the water meter reading is a positive number, or verify whether the timestamp format is correct; ② Data conversion rules: perform necessary conversions on the original data to make it easier to process or more suitable for storage. For example, convert the water meter reading from liters (L) to cubic meters (m 3 ). ③ Aggregation rules: Aggregate multiple readings over a period of time to generate statistical data. For example, calculate the total water consumption in a day, or find the average water consumption rate. ④ State change detection rules: Identify changes in equipment status, such as switching from normal operation to failure mode, abnormal valve closure, etc., and take corresponding actions accordingly. ⑤ Event trigger rules: Trigger certain actions based on the occurrence of specific conditions. For example, automatically generate a bill on the first day of each month. ⑥ Data cleaning rules: Remove noisy data, erroneous records or duplicates to improve data quality and the accuracy of analysis results.

[0138] c. Message communication: Using lightweight message protocols such as MQTT and CoAP (Constrained Application Protocol) ensures efficient and reliable communication between water meter devices, servers and IoT platforms.

[0139] d. Uplink command simulation and downlink specified debugging, custom TOPIC, attribute reporting, and event reporting. Custom TOPIC operations include: custom Topic for message reporting, entering payload data (valid data), and setting QoS (Quality of Service) to 0 or 1.

[0140] The maximum expiration time for QoS 0 messages is 86,400 seconds, and the maximum expiration time for QoS 1 messages is 604,800 seconds. If the message expiration time (seconds) is not set, the maximum expiration time for the corresponding QoS message is used by default.

[0141] Attribute reporting uses the water meter device standard object model within the water meter device model to establish values ​​that conform to the attribute data type and value range. Numeric attributes support setting random numbers; random(a,b) represents a random number between integers a and b. Send instructions, push policies, and set development schedules to conduct regular push testing.

[0142] Among them, event reporting, according to the attributes generated by the object model and the corresponding event selected in the event, configure the event reporting data in the JSON format required by the event, such as {"Valve":"OPEN"}.

[0143] 3. For the complete daily data breakdown:

[0144] a. Water meters regularly upload water usage data to the cloud IoT platform. This data includes, but is not limited to, water flow readings, voltage, magnetic field strength, valve status, ambient temperature, relative humidity, water temperature and pressure. The device shadow model in the cloud platform records the meter's real-time and historical status. The reported portion of the water meter device model, or the device status section, contains the latest device status, while the metadata portion, or the device status document, records the update time of each attribute.

[0145] b. Data cleaning: Remove invalid or erroneous data, such as values ​​significantly outside the normal range. Data integrity check: Check the completeness of data for each water use date. If data for a certain time period is missing, mark that day as "missing," otherwise mark it as "complete."

[0146] c. Divide and determine the time intervals. Divide each full day into multiple time periods at predetermined intervals (e.g., hourly intervals). For example, a day can be divided into 24 time periods, each lasting one hour. Assign each time period a unique number, e.g., 00:00-01:00 is Time Period 1, 01:00-02:00 is Time Period 2, and so on.

[0147] d. Extract water usage data for each time period from the reported portion of the water meter device model. Read the reported portion of the device shadow document to obtain the latest value of each attribute. Then, extract water usage data for each time period based on the timestamp and time period number assigned in the previous step.

[0148] 4. Target data ratio:

[0149] a. Build a table structure containing water usage data based on the above water usage data. The table structure is as follows: id: primary key, auto-increment; asset_id: asset ID; date: date; hour: hour; water_meter_reading: water meter reading; voltage: voltage; magnetic_field: strong magnetism; valve_status: valve status; valve_abnormal: valve abnormality; operating_state: operating status; environment_temperature: ambient temperature; relative_humidity: relative humidity; water_temperature: water temperature; water_pressure: water pressure; timestamp: timestamp.

[0150] b. Extract data from the water usage table and select dates with complete data, that is, records with a non-null water usage value greater than or equal to 0. Calculate the number of records with water usage greater than zero in each time period and the total number of records in each time period.

[0151] c. Define a Common Table Expression (CTE) to calculate the total number of records in each time period and the number of records with water consumption greater than zero. Select the selected sequence and calculate the total number of records in each time period and the number of records with water consumption greater than zero in each time period.

[0152] Filter out dates with complete data, that is, records with water consumption values ​​that are not empty and greater than or equal to 0, group by date and hour to calculate the data for each time period, select the required columns from the CTE, and divide the number of records with water consumption greater than zero by 1.0 / total number of records to calculate the proportion of records with water consumption greater than zero in each time period to the total number of records. Finally, sort by date and hour so that the results are arranged in chronological order.

[0153] The final output format for a certain day is: Date Hour Total-Records Non-Zero-Records Non-Zero-Ratio. This time sequence is arranged to facilitate subsequent analysis and calculation.

[0154] 5. Definition of time period:

[0155] When calculating the proportion of water consumption greater than zero in each segmented time period, the time period can be further categorized to provide a more detailed analysis of water use patterns, including:

[0156] a. Peak hours are periods of high water consumption, usually occurring during certain fixed times of the day, such as morning (6:00-9:00) and evening (17:00-21:00).

[0157] b. Low water consumption period: The period of time when water consumption is low, usually at night or in the early morning. Late night (23:00-5:00).

[0158] c. Off-peak hours: The time period between peak hours and off-peak hours when water consumption is relatively stable. These include morning (9:00-12:00), afternoon (12:00-17:00), and evening (21:00-23:00).

[0159] d. Divide the day into 24 periods, each lasting one hour. Categorize each period according to the defined peak, off-peak, and off-peak periods.

[0160] 6. Calculation of water coefficient:

[0161] Based on the statistical results of actual water consumption data, we dynamically divide water consumption into peak, off-peak, and off-peak periods. We calculate the average and standard deviation of water consumption for each period, and dynamically categorize the period based on the distribution of water consumption. Periods where water consumption exceeds the average plus one standard deviation are defined as peak periods, periods where water consumption falls below the average minus one standard deviation are defined as off-peak periods, and all other periods are defined as off-peak periods.

[0162] Assume the water usage data is as follows: Period 0:100; Period 1:120; Period 2:80; Period 3:90; Period 4:70; Period 5:60; Period 6:300; Period 7:350; Period 8:400; Period 9:150; Period 10:180; Period 11:200; Period 12:160; Period 13:170; Period 14:190; Period 15:210; Period 16:220; Period 17:320; Period 18:360; Period 19:410; Period 20:450; Period 21:250; Period 22:230; Period 23:1100. Then, the mean is (100 + 120 + 80 + ... + 230 + 110) / 24 = 200. The standard deviation is σ ≈ 100.

[0163] From the above calculation, we can see that the mean value (μ) = 200 and the standard deviation (σ) ≈ 100.

[0164] Peak period: water consumption > μ+σ=200+100=300; off-peak period: water consumption < μ-σ=200-100=100; off-peak period: other periods (i.e. water consumption between 100 and 300).

[0165] For the period when the water consumption is 300, the peak period water consumption coefficient = 300 / 200 = 1.5; for the period when the water consumption is 100, the off-peak period water consumption coefficient = 100 / 200 = 0.5; for the period when the water consumption is equal to the average value of 200, the off-peak period water consumption coefficient = 200 / 200 = 1.0.

[0166] The water consumption coefficient for each period is determined by the ratio of actual water consumption to average water consumption during each period. The water consumption coefficient during peak hours is generally greater than 1, the water consumption coefficient during off-peak hours is generally less than 1, and the water consumption coefficient during off-peak hours is close to 1.

[0167] When the time axis is extended (such as one year), when calculating the average water consumption coefficient of a certain day, the day is divided into peak period, low peak period and flat peak period, and the calculation rules are the same as the rules for each period of each day.

[0168] 7. For data completion and correction:

[0169] Using the calculated water usage coefficient, the water usage for the missing day can be estimated. Assume there is a date missing_date with a missing day and the total average water usage for that day missing_daily_avg_usage is known.

[0170] The coefficient of each period is extracted from the water consumption coefficient, and the water consumption coefficient is multiplied by the total average water consumption of the missing days to obtain the estimated water consumption for each period.

[0171] Calculate the average water consumption for each full day and the average water consumption for each time period to obtain daily_avg and hourly_avg, and calculate the water consumption coefficient for each time period: time period * hourly_avg / daily_avg = usage_coefficients (water consumption coefficient).

[0172] Finally, the water consumption coefficient is multiplied by the total average water consumption of the missing days to obtain the estimated water consumption for each period. The water consumption data of the missing days can be supplemented to ensure the integrity and continuity of the data.

[0173] 8. Dynamic update of water meter equipment model:

[0174] The default data or abnormal data is supplemented based on the water meter device model converted from the physical model and the time period data simulated according to the water meter device model.

[0175] If a water meter device is offline for a certain period of time, you can complete the data by following the steps below:

[0176] Pre-offline status recording: Before the device goes offline, its current status (such as water meter reading) will be recorded in the water meter device model.

[0177] Local temporary data: The device still records local water meter data while offline, but cannot upload it. Synchronization after re-online: After the device is online, it queries the current status of the water meter device model and uploads the locally stored data.

[0178] Data completion: Based on the time points and offline data recorded in the water meter device model, the estimated data for the missing time period is calculated and completed.

[0179] 9. For system integration and automation:

[0180] By integrating it into an automated process, the entire data processing and completion process can be automatically executed without human intervention. The integrated automated process can be implemented in the following ways:

[0181] Batch jobs: You can schedule batch jobs to run periodically. These jobs automatically load new data, perform data cleaning, calculate statistics (such as mean and standard deviation), divide data into time periods, and update water use coefficients.

[0182] Workflow management system: Integrate into a workflow engine for management (such as Zapier, or a custom developed workflow engine) to orchestrate complex business logic. This can include a series of steps starting from receiving raw data to finally generating a report.

[0183] Cloud IoT Platform: Integrated into a platform that supports a rules engine, triggering actions when receiving specific messages. When a new water meter reading is received, the platform automatically evaluates the data and adjusts the time period based on predefined rules.

[0184] This embodiment also provides a water meter device modeling device, which is used to implement the above-mentioned embodiments and preferred embodiments. Details already described will not be repeated here. As used below, the term "module" may refer to a combination of software and / or hardware that implements a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, implementation using hardware, or a combination of software and hardware, is also possible and contemplated.

[0185] This embodiment provides a water meter equipment model modeling device, such as Figure 5 Shown, including:

[0186] The asset manufacturer database establishment module 501 is used to establish an asset manufacturer database of water meter equipment.

[0187] The water meter equipment standard object model establishment module 502 is used to obtain the operating data of each water meter equipment and establish a water meter equipment standard object model based on the asset manufacturer database and the operating data of each water meter equipment.

[0188] The water meter device model establishment module 503 is used to establish a water meter device model based on the water meter device standard object model.

[0189] In some optional implementations, the asset manufacturer database establishment module 501 includes:

[0190] A water meter device information acquisition unit, configured to acquire water meter device asset information, manufacturer information corresponding to each water meter device asset, and a communication protocol table structure construction unit through multiple access methods, configured to respectively construct an asset table, a manufacturer table, a protocol table, and a maintenance record table based on the water meter device asset information, the manufacturer information corresponding to each water meter device asset, and the communication protocol;

[0191] The asset manufacturer database construction unit is used to aggregate the asset table, manufacturer table, agreement table and maintenance record table to obtain the asset manufacturer database.

[0192] In some optional implementations, the multiple access modes include a proxy access mode, a probe access mode, and a log access mode, and the water meter device information acquisition unit includes:

[0193] The data access acquisition subunit acquires water meter device asset information, manufacturer information corresponding to each water meter device asset, and communication protocol through an agent access method, a probe access method, and / or a log access method.

[0194] In some optional implementations, the table structure building unit includes:

[0195] The asset table generation subunit is used to extract the asset ID, model, serial number, production date, installation location and device status information of each water meter device from the water meter device asset information and use a unified data structure to represent it to generate an asset table.

[0196] The manufacturer table generation subunit is used to extract the manufacturer name, contact person, contact information, address and technical support telephone number of each water meter device from the manufacturer information corresponding to each water meter device asset and represent them in a unified data structure to generate a manufacturer table.

[0197] The protocol table generation subunit is used to extract the communication protocol name, protocol frame structure, frame length, uplink information and downlink instructions of each water meter device from the communication protocol corresponding to each water meter device asset and generate a protocol table by representing them with a unified data structure.

[0198] The maintenance record table generation subunit is used to extract the maintenance record ID, asset ID, maintenance date, maintenance reason, maintenance result, maintenance personnel and maintenance cost of each water meter device from the water meter device asset information and generate a maintenance record table by representing them in a unified data structure.

[0199] In some optional implementations, the operating data of each water meter device is operating data from the water meter device operation log or the device daily operation frozen data in the water meter storage chip, and the water meter device standard object model establishment module 502 includes:

[0200] The key information generation unit is used to generate attribute information, service information and event information of each water meter device based on the asset manufacturer database and the operation data of each water meter device.

[0201] The water meter equipment standard object model establishing unit is used to establish a water meter equipment standard object model based on attribute information, service information and event information.

[0202] In some optional implementations, the water meter device model building module 503 includes:

[0203] The water meter device model establishment unit is used to convert the water meter device standard object model into standard JSON data to obtain the water meter device model. The standard JSON data includes the expected status, report status, status document, latest update time and version number of the water meter device model.

[0204] The further functional description of each of the above modules and units is the same as that of the above corresponding embodiments and will not be repeated here.

[0205] The water meter equipment model modeling device in this embodiment is presented in the form of a functional unit, where the unit refers to an ASIC (Application Specific Integrated Circuit) circuit, a processor and memory that executes one or more software or fixed programs, and / or other devices that can provide the above functions.

[0206] The embodiment of the present invention also provides a computer device having the above Figure 5 The water meter equipment model modeling device shown.

[0207] See also Figure 6 , Figure 6 is a structural diagram of a computer device provided by an optional embodiment of the present invention, such as Figure 6 As shown, the computer device includes: one or more processors 10, memory 20, and interfaces for connecting various components, including high-speed interfaces and low-speed interfaces. Various components utilize different buses to communicate with each other and can be installed on a common mainboard or installed in other ways as needed. The processor can process the instructions executed in the computer device, including instructions stored in the memory or on the memory to display the graphical information of the GUI on an external input / output device (such as, a display device coupled to the interface). In some optional embodiments, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Equally, multiple computer devices can be connected, and each device provides part of the necessary operations (for example, as a server array, a group of blade servers, or a multi-processor system). Figure 6 A processor 10 is taken as an example.

[0208] The processor 10 may be a central processing unit, a network processor, or a combination thereof. The processor 10 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit, a programmable logic device, or a combination thereof. The programmable logic device may be a complex programmable logic device, a field programmable gate array, a general purpose array logic, or any combination thereof.

[0209] The memory 20 stores instructions that can be executed by at least one processor 10, so that the at least one processor 10 executes the method shown in the above embodiment.

[0210] The memory 20 may include a program storage area and a data storage area, wherein the program storage area may store an operating system and application programs required for at least one function; the data storage area may store data created based on the use of the computer device, etc. In addition, the memory 20 may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some optional embodiments, the memory 20 may optionally include a memory remotely located relative to the processor 10, and these remote memories may be connected to the computer device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0211] The memory 20 may include a volatile memory, such as a random access memory; the memory may also include a non-volatile memory, such as a flash memory, a hard disk or a solid-state drive; the memory 20 may also include a combination of the above types of memory.

[0212] The computer device further includes an input device 30 and an output device 40. The processor 10, the memory 20, the input device 30 and the output device 40 may be connected via a bus or other means. Figure 6 The bus connection is taken as an example.

[0213] The input device 30 can receive input digital or character information and generate key signal input related to user settings and function control of the computer device, such as a touch screen, a keypad, a mouse, a trackpad, a touch pad, an indicator stick, one or more mouse buttons, a trackball, a joystick, etc. The output device 40 can include a display device, an auxiliary lighting device (e.g., an LED), and a tactile feedback device (e.g., a vibration motor). The above-mentioned display device includes but is not limited to a liquid crystal display, a light emitting diode, a display, and a plasma display. In some optional embodiments, the display device can be a touch screen.

[0214] The embodiment of the present invention also provides a computer-readable storage medium. The above-mentioned method according to the embodiment of the present invention can be implemented in hardware, firmware, or implemented as a computer code that can be recorded in a storage medium, or implemented as a computer code that is originally stored in a remote storage medium or a non-temporary machine-readable storage medium and downloaded through a network and will be stored in a local storage medium, so that the method described herein can be stored in such software processing on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. Among them, the storage medium can be a magnetic disk, an optical disk, a read-only storage memory, a random access memory, a flash memory, a hard disk or a solid-state drive, etc.; further, the storage medium can also include a combination of the above-mentioned types of memory. It can be understood that a computer, a processor, a microprocessor controller or programmable hardware includes a storage component that can store or receive software or computer code. When the software or computer code is accessed and executed by a computer, a processor or hardware, the method shown in the above embodiment is implemented.

[0215] A portion of the present invention may be applied as a computer program product, such as a computer program instruction, which, when executed by a computer, can call or provide the method and / or technical solution according to the present invention through the operation of the computer. Those skilled in the art should understand that the form in which the computer program instruction exists in a computer-readable medium includes, but is not limited to, a source file, an executable file, an installation package file, etc. Accordingly, the way in which the computer program instruction is executed by the computer includes, but is not limited to: the computer directly executes the instruction, or the computer compiles the instruction and then executes the corresponding compiled program, or the computer reads and executes the instruction, or the computer reads and installs the instruction and then executes the corresponding installed program. Here, the computer-readable medium may be any available computer-readable storage medium or communication medium that can be accessed by the computer.

[0216] Although the embodiments of the present invention have been described with reference to the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the present invention. Such modifications and variations are all within the scope defined by the appended claims.

Claims

1. A water meter equipment modeling method, characterized in that: The method comprises: Establish an asset manufacturer database for water meter equipment; Acquire the operation data of each water meter device, and establish a water meter device standard object model based on the asset manufacturer database and the operation data of each water meter device; A water meter equipment model is established based on the water meter equipment standard object model.

2. The water meter equipment modeling method according to claim 1, characterized in that: The establishment of the asset manufacturer database of water meter equipment includes: Obtain water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol through multiple access methods; Based on the water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol, an asset table, a manufacturer table, a protocol table, and a maintenance record table are respectively constructed; The asset table, manufacturer table, agreement table and maintenance record table are aggregated to obtain an asset manufacturer database.

3. The water meter equipment modeling method according to claim 2, characterized in that: The multiple access modes include proxy access mode, probe access mode and log access mode; The water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol are obtained through various access methods, including: The water meter device asset information, the manufacturer information corresponding to each water meter device asset, and the communication protocol are obtained through a proxy access method, a probe access method, and / or a log access method.

4. The water meter equipment modeling method according to claim 3 is characterized in that: The method of obtaining water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol through proxy access includes: A security SDK or security agent for device identity authentication is set on each water meter device, and each water meter device information is reported through the security SDK or security agent, and the asset information, manufacturer information and communication protocol of each water meter device in the water meter device information are parsed and obtained; The water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol obtained through probe access include: Install and deploy data scanning and parsing software, identify each water meter device information by running the active scanning task or scheduled scanning task of the data scanning and parsing software, and parse and obtain the asset information, manufacturer information and communication protocol of each water meter device in the water meter device information; The water meter equipment asset information, manufacturer information corresponding to each water meter equipment asset, and communication protocol obtained through log access include: The water meter device operation log is obtained through the API interface, and the information of each water meter device is identified based on the water meter device operation log, and the asset information, manufacturer information and communication protocol of each water meter device in the water meter device information are parsed to obtain the daily operation freeze data of each water meter device, or the daily operation freeze data of each water meter device is read using a smart card chip or a gateway that supports the preset communication protocol and extracts the asset information, manufacturer information and communication protocol of each water meter device.

5. The water meter equipment modeling method according to claim 2, characterized in that: Based on the water meter equipment asset information, the manufacturer information corresponding to each water meter equipment asset, and the communication protocol, an asset table, a manufacturer table, a protocol table, and a maintenance record table are respectively constructed, including: Extract the asset ID, model, serial number, production date, installation location and device status information of each water meter device from the water meter device asset information and generate an asset table by using a unified data structure to represent them; Extract the name, contact person, contact information, address and technical support telephone number of each water meter equipment manufacturer from the manufacturer information corresponding to each water meter equipment asset and represent them in a unified data structure to generate a manufacturer table; Extract the communication protocol name, protocol frame structure, frame length, uplink information and downlink instruction of each water meter device from the communication protocol corresponding to each water meter device asset and represent them in a unified data structure to generate a protocol table; The maintenance record ID, asset ID, maintenance date, maintenance reason, maintenance result, maintenance personnel and maintenance cost of each water meter device are extracted from the water meter device asset information and represented by a unified data structure to generate a maintenance record table.

6. The water meter equipment modeling method according to claim 1, characterized in that: The operation data of each water meter device is the operation data from the water meter device operation log or the device daily operation frozen data; Establishing a water meter equipment standard object model based on the asset manufacturer database and the operation data of each water meter equipment includes: Generate attribute information, service information and event information of each water meter device based on the asset manufacturer database and the operation data of each water meter device; A water meter equipment standard object model is established based on the attribute information, service information and event information.

7. The method according to claim 1, characterized in that The water meter equipment model is established based on the water meter equipment standard object model, comprising: The water meter equipment standard object model is converted into standard JSON data to obtain a water meter equipment model, wherein the standard JSON data includes an expected state, a report state, a state document, a latest update time and a version number of the state document of the water meter equipment model.

8. A water meter equipment model modeling device, characterized in that: The device comprises: Asset manufacturer database establishment module, used to establish the asset manufacturer database of water meter equipment; A water meter equipment standard object model establishment module, used for acquiring the operation data of each water meter equipment, and establishing a water meter equipment standard object model based on the asset manufacturer database and the operation data of each water meter equipment; The water meter equipment model building module is used to build a water meter equipment model based on the water meter equipment standard object model.

9. A computer device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the water meter equipment modeling method according to any one of claims 1 to 7 by executing the computer instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the water meter device model building method according to any one of claims 1 to 7.

Images