A power detection method based on cloud platform

By adopting hierarchical structure and form-based management in the power management system, the problems of inflexible and poor correlation in traditional systems are solved, efficient data processing and traceability are achieved, and troubleshooting efficiency and system response speed are improved.

CN118708573BActive Publication Date: 2024-11-15NANTONG LIANBANG DIGITAL INTELLIGENCE INFORMATION TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411205989.X
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-08-30
Publication Date
2024-11-15
Estimated Expiration
2044-08-30

AI Technical Summary

Technical Problem

Traditional power management systems have problems such as inflexible data management, poor scalability, complex maintenance, low data entry efficiency and lack of data correlation, which makes it difficult to trace the data source and change process, affecting the efficiency of fault resolution.

Method used

Using a hierarchical structured data storage solution, the smart cloud platform is divided into network layer, protection device layer, loop structure layer, computing layer, alarm layer and user management layer. Data is managed in the form of a form, and mapping relationships between tables are established to realize Modular design and data traceability.

Benefits of technology

It improves data processing efficiency and traceability, reduces operation complexity, enhances data relevance and transparency, simplifies troubleshooting, and improves massive data processing and system response speed.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118708573B_ABST
    Figure CN118708573B_ABST
Patent Text Reader

Abstract

The present invention discloses a cloud platform-based power detection method, which belongs to the field of power technology, including constructing a network layer, a protection device layer, a loop structure layer, a computing layer, an alarm layer and a user management layer on a smart cloud platform, solving the technical problems of adopting a hierarchical data storage structure, making data modular, intuitively reflecting the underlying hardware system architecture, strengthening the relationship between data, and improving the efficiency and traceability of data processing. The present invention adopts a layered database storage, which is easy to manage and maintain, improves the security and integrity of data, and reduces data redundancy. The hierarchical structure makes system expansion more convenient, and each layer of modules can be added or modified according to needs, thereby improving data transparency and traceability, improving the efficiency of troubleshooting and problem solving, and improving data processing speed and system response speed. Through layered and modular design, performance bottlenecks caused by excessive single-point pressure are avoided.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention belongs to the field of electric power technology, and in particular relates to an electric power detection method based on a cloud platform. Background Art

[0002] With the development of society and the advancement of science and technology, electricity, as an important energy source, plays a vital role in production and life. The stability and safety of the power system directly affect the normal operation of all walks of life and the quality of life of residents.

[0003] The smart power consumption platform is a comprehensive management system based on advanced technologies such as the Internet of Things, cloud computing, big data, and artificial intelligence. It collects power data in real time by installing various sensors and intelligent protection devices on power-consuming equipment and lines. The intelligent protection devices are network-connected devices and transmit them to the cloud for storage and processing through the network. The platform analyzes and mines the data, provides fault warning, energy consumption analysis, safety monitoring and other functions, and realizes intelligent and refined management of the power system.

[0004] Traditional technologies have the following disadvantages:

[0005] 1. Traditional power management systems usually adopt a single database storage structure, which makes data management inflexible and has poor scalability.

[0006] 2. The traditional power management system cannot intuitively reflect the system architecture of the underlying hardware from the structure of the database, and the actual maintenance process is cumbersome.

[0007] 3. Data entry and management mostly rely on manual operations, which are prone to errors and inefficient.

[0008] 4. There is a lack of association and mapping relationship between different data, making it difficult to trace the source and change process of the data.

[0009] 5. When data problems occur, it is difficult to quickly locate the source of the problem and the specific data, which affects the efficiency of problem solving. Summary of the invention

[0010] The purpose of the present invention is to provide an electric power detection method based on a cloud platform, which solves the technical problems of adopting a hierarchical data storage structure, modularizing the data, intuitively reflecting the underlying hardware system architecture, strengthening the relationship between data, and improving the efficiency and traceability of data processing.

[0011] To achieve the above object, the present invention adopts the following technical solutions:

[0012] A power detection method based on a cloud platform comprises the following steps:

[0013] Step 1: Establish a smart cloud platform, gateway and protection equipment, and build the network layer, protection equipment layer, loop structure layer, computing layer, alarm layer and user management layer on the smart cloud platform;

[0014] Step 2: Establish network links between the smart cloud platform, gateways, and protection devices at the network layer, and record the subordinate relationships of the network links. Create several gateway tables based on the subordinate relationships. A gateway table stores the link information between a gateway and multiple protection devices. The link information includes the MAC address of the protection device.

[0015] Step 3: Enter the basic information of the protection device at the protection device layer, create several protection device tables, establish a mapping relationship between the protection device table and the gateway table, automatically obtain the MAC address of the protection device according to the mapping relationship, and check the MAC address of the protection device according to the basic information. After the verification is correct, store the basic information and the MAC address of the protection device in the protection device table. One protection device table corresponds to one protection device;

[0016] Step 4: Retrieve the protection device table and gateway table at the loop structure layer, build a loop architecture through the basic information of the protection device and the subordinate relationship of the network link, create several loop tables, and establish a mapping relationship between the loop table and the protection device table. In the loop table, mark the loop to which the protection device belongs in the loop architecture according to the mapping relationship. One loop table corresponds to one protection device table and one gateway table;

[0017] Step 5: Retrieve the loop table at the calculation layer, obtain the power data collected by the corresponding protection device in the loop table, create a power data table and a threshold setting table, and establish a mapping relationship between the power data table, the threshold setting table and the loop table. One power data table corresponds to one loop table.

[0018] Calculate the power data to obtain energy consumption data, perform threshold judgment on the power data according to the preset threshold in the threshold setting table to obtain alarm data, and store the power data, energy consumption data and alarm data in the power data table;

[0019] Step 6: Enter user information in the user management layer, create several user information tables, each of which corresponds to one user, and store user information in the user information table;

[0020] Step 7: Retrieve the power data table at the alarm layer, generate alarm information based on the alarm data in the power data table, send alarm notifications to relevant personnel based on the alarm information, create several alarm information tables, and establish a mapping relationship between the alarm information table, user information table and power data table. Each alarm information table corresponds to a power data table and a user information table.

[0021] Preferably, when executing step 2, the following steps are specifically included:

[0022] Step 2-1: Any gateway A establishes a data link with the smart cloud platform;

[0023] Step 2-2: After multiple protection devices establish links with gateway A, gateway A obtains and saves the MAC address of each protection device that establishes a link with itself, updates the connection status of the protection device in real time, and generates a link device MAC list and a link device online status list;

[0024] Step 2-3: Create a gateway table corresponding to gateway A, which includes the gateway table primary key, gateway name, installation location, online status, linked device MAC list, linked device online status list and update time, and set constraints in the gateway table;

[0025] Step 2-4: According to the methods from step 2-1 to step 2-3, create a gateway table for all gateways that establish data links with the smart cloud platform.

[0026] Preferably, when executing step 3, the following steps are specifically included:

[0027] Step 3-1: The user enters the basic information of any protection device B into the smart cloud platform through any client connected to the smart cloud platform. The basic information includes the device MAC, installation location, device name, device constraints, manufacturer, model, last maintenance date, and installation date;

[0028] Step 3-2: Protect device B from connecting to any gateway;

[0029] Step 3-3: Retrieve all gateway tables, and query and check the corresponding protection device B in all gateway tables according to the entered device MAC: If the entered device MAC is found in any gateway table, execute step 3-5; if the entered device MAC is not found in all gateway tables, execute step 3-4;

[0030] Step 3-4: Send an error message for entering the device MAC through the client and execute step 3-1;

[0031] Step 3-5: Create a protection device table for protection device B based on the link relationship between protection device B and the gateway. The protection device table includes the protection device table primary key and the gateway table ID. Enter the device MAC, installation location, device name, device constraint, manufacturer, model, installation date, creation time, update time, and last maintenance date. The gateway table ID indicates the relationship between the protection device table and the gateway table that is mapped using the primary key and foreign key.

[0032] Step 3-6: According to the methods of step 3-1 to step 3-5, a protection device table is created for each protection device, and each protection device table corresponds to a gateway table.

[0033] Preferably, when executing step 4, the following steps are specifically included:

[0034] Step 4-1: retrieve the protection device table, and retrieve the corresponding gateway table according to the mapping relationship in the protection device table;

[0035] Step 4-2: According to the installation positions of the devices in the protection device table and the installation positions of the gateways in the gateway table, a loop architecture is constructed. In the loop architecture, each loop corresponds to one protection device, and each gateway corresponds to multiple loops;

[0036] Step 4-3: Create loop tables for all loops based on the loop architecture. Each loop table includes the loop table primary key, protection device table ID, loop name, loop constraint, loop status, creation time, and update time. The protection device table ID represents the relationship between the loop table and the protection device table mapped using the primary key and foreign key.

[0037] Preferably, when executing step 5, the following steps are specifically included:

[0038] Step 5-1: Retrieve any loop table C, and retrieve the corresponding protection device table according to the mapping relationship in the loop table C;

[0039] Step 5-2: Obtain power data collected by the corresponding protection device in the protection device table, the power data including voltage, current, active power, reactive power, power factor, temperature and leakage current;

[0040] Step 5-3: Calculate energy consumption data based on power data;

[0041] Step 5-4: Create a threshold setting table, and the user enters the threshold of the preset power data in the threshold setting table through any client connected to the smart cloud platform. The threshold setting table specifically includes the threshold setting table primary key, loop ID setting, overvoltage threshold, undervoltage threshold, overcurrent threshold, temperature threshold, creation time and update time, where the loop ID is set to the entered loop name;

[0042] Step 5-5: Perform threshold judgment based on power data and threshold setting table to generate alarm data;

[0043] Step 5-6: Create a power data table, store both power data and alarm data in the power data table, the power data table specifically includes the power data table primary key, loop table ID, threshold setting table ID, timestamp, voltage, voltage alarm, current, current alarm, active power, reactive power, power factor, temperature, temperature alarm, leakage current, leakage current alarm, energy consumption data and creation time, wherein the loop table ID represents the relationship between the power data table and the loop table mapped by the primary key and foreign key, and the threshold setting table ID represents the relationship between the power data table and the threshold setting table mapped by the primary key and foreign key;

[0044] Voltage alarm, current alarm, temperature alarm and leakage current alarm are alarm data;

[0045] Step 5-7: According to the methods of step 5-1 to step 5-7, create corresponding power data tables for all circuits.

[0046] Preferably, when executing step 6, the user enters user information through any client connected to the smart cloud platform. The user information table includes the user information table primary key, user name, username, password, role, mobile phone number, email, creation time and update time, wherein the user name is the identity authentication name entered by the user, the username is the user account name automatically assigned by the user management layer, the role is the priority setting of the user's management authority, and the priority protects three levels: high, medium and low. Each user corresponds to a user information table, and each user information table corresponds to a unique username.

[0047] Preferably, when executing step 7, the following steps are specifically included:

[0048] Step 7-1: Retrieve any power data table D;

[0049] Step 7-2: query the alarm data in the power data table D, and generate alarm information according to the alarm data;

[0050] Step 7-3: Select a user information table ID and create an alarm information table corresponding to the power data table D. The alarm information table includes the alarm information table primary key, the power data table ID, the user information table ID, the alarm constraint, the alarm status, the alarm details, the creation time and the update time. The power data table ID indicates the relationship between the alarm information table and the power data table mapped by the primary key and the foreign key, and the user information table ID indicates the relationship between the alarm information table and the user information table mapped by the primary key and the foreign key;

[0051] The user information table ID is selected as the user information table with the role set as high;

[0052] The alarm status is generated by the alarm data: when any item in the alarm data has a threshold alarm, the alarm status is set to 1; otherwise, the alarm status is set to 0;

[0053] When the alarm status is set to 1, the alarm data is stored in the alarm details;

[0054] Step 7-4: traverse the user information table and create a corresponding alarm information table for each user information table whose role is set to high;

[0055] Step 7-5: traverse all alarm information tables, create an alarm notification according to each alarm information table with an alarm status of 1, and send an alarm notification to the corresponding user according to the user information table ID in the alarm information table;

[0056] Step 7-6: According to the methods of steps 7-1 to 7-5, create alarm information tables corresponding to all power data tables, and send corresponding alarm notifications.

[0057] The cloud platform-based power detection method described in the present invention solves the technical problems of adopting a hierarchical data storage structure to modularize data, intuitively reflect the underlying hardware system architecture, strengthen the relationship between data, and improve the efficiency and traceability of data processing. The present invention adopts a layered database storage. By dividing the smart cloud platform into a network layer, a protection device layer, a loop structure layer, a computing layer, an alarm layer, and a user management layer, the system realizes a modular design, which is easy to manage and maintain. The data isolation between different layers improves the security and integrity of the data and reduces data redundancy. The hierarchical structure makes the system expansion more convenient. Each layer module can be added or modified according to needs without affecting the functions of other layers. The present invention adopts data management in the form of a form. By managing data in the form, the data structure is clear and easy to query, modify and Maintenance, the data display in the form of forms is intuitive and clear, and users can easily view and edit relevant information. Users only need to fill in individual forms to complete complete data entry and management, which reduces the complexity of operation and improves work efficiency. Through the mapping relationship between forms, the source and change process of the data can be traced back, which improves data transparency and traceability. The foreign key relationship between forms makes the data highly correlated, which is convenient for multi-table joint query and comprehensive analysis. When data problems occur, the relevant forms and specific data can be quickly located, which improves the efficiency of troubleshooting and problem solving. The present invention adopts a hierarchical structure and form-based management, which can effectively process massive data, improve data processing speed and system response speed, and through hierarchical and modular design, the data processing load can be evenly distributed to each layer and module to avoid performance bottlenecks caused by excessive pressure at a single point. BRIEF DESCRIPTION OF THE DRAWINGS

[0058] Figure 1 is a system architecture diagram of the present invention;

[0059] Figure 2 It is a flow chart of the present invention. DETAILED DESCRIPTION

[0060] like Figure 1 and Figure 2 A power detection method based on a cloud platform is shown, comprising the following steps:

[0061] Step 1: Establish a smart cloud platform, gateway and protection equipment, and build the network layer, protection equipment layer, loop structure layer, computing layer, alarm layer and user management layer on the smart cloud platform;

[0062] In this embodiment, the smart cloud platform is a data center or a server cluster.

[0063] Step 2: Establish network links between the smart cloud platform, gateways, and protection devices at the network layer, and record the subordinate relationships of the network links. Create several gateway tables based on the subordinate relationships. A gateway table stores the link information between a gateway and multiple protection devices. The link information includes the MAC address of the protection device.

[0064] When executing step 2, the specific steps include:

[0065] Step 2-1: Any gateway A establishes a data link with the smart cloud platform;

[0066] Step 2-2: After multiple protection devices establish links with gateway A, gateway A obtains and saves the MAC address of each protection device that establishes a link with itself, updates the connection status of the protection device in real time, and generates a link device MAC list and a link device online status list;

[0067] Step 2-3: Create a gateway table corresponding to gateway A, which includes the gateway table primary key, gateway name, installation location, online status, linked device MAC list, linked device online status list and update time, and set constraints in the gateway table;

[0068] Step 2-4: According to the methods from step 2-1 to step 2-3, create a gateway table for all gateways that establish data links with the smart cloud platform.

[0069] In this embodiment, the gateway table is shown in Table 1:

[0070]

[0071] In the network layer, multiple protection devices are connected to one gateway. The present invention uses the gateway as the data subject and establishes a MAC list of linked devices under each gateway. It automatically obtains the MAC of the online protection device to facilitate future maintenance. When replacing the device, it only needs to report the MAC address of the new device to obtain the data form of the new device. The degree of intelligence and data correlation are higher than traditional technologies.

[0072] Step 3: Enter the basic information of the protection device at the protection device layer, create several protection device tables, establish a mapping relationship between the protection device table and the gateway table, automatically obtain the MAC address of the protection device according to the mapping relationship, and check the MAC address of the protection device according to the basic information. After the verification is correct, store the basic information and the MAC address of the protection device in the protection device table. One protection device table corresponds to one protection device;

[0073] When executing step 3, the specific steps include:

[0074] Step 3-1: The user enters the basic information of any protection device B into the smart cloud platform through any client connected to the smart cloud platform. The basic information includes the device MAC, installation location, device name, device constraints, manufacturer, model, last maintenance date, and installation date;

[0075] Step 3-2: Protect device B from connecting to any gateway;

[0076] Step 3-3: Retrieve all gateway tables, and query and check the corresponding protection device B in all gateway tables according to the entered device MAC: If the entered device MAC is found in any gateway table, execute step 3-5; if the entered device MAC is not found in all gateway tables, execute step 3-4;

[0077] Step 3-4: Send an error message for entering the device MAC through the client and execute step 3-1;

[0078] Step 3-5: Create a protection device table for protection device B based on the link relationship between protection device B and the gateway. The protection device table includes the protection device table primary key and the gateway table ID. Enter the device MAC, installation location, device name, device constraint, manufacturer, model, installation date, creation time, update time, and last maintenance date. The gateway table ID indicates the relationship between the protection device table and the gateway table that is mapped using the primary key and foreign key.

[0079] Step 3-6: According to the methods of step 3-1 to step 3-5, a protection device table is created for each protection device, and each protection device table corresponds to a gateway table.

[0080] In this embodiment, the protection device table is shown in Table 2:

[0081]

[0082] The present invention sets a protection device table for each protection device to indicate the attributes and installation location of the protection device, wherein the attributes include the device name, manufacturer and model.

[0083] Creating a separate form for each device can well indicate the position of the device in the entire system architecture and facilitate future maintenance and data traceability.

[0084] In the protection device table, the device MAC entered is the MAC address of the device entered by the user. This address is different from the linked device MAC list in the gateway table. The linked device MAC list in the gateway table is automatically obtained by the gateway. In actual application, after a new protection device is connected to the system architecture, it is necessary to check these two MAC addresses to determine the position of the protection device in the system architecture.

[0085] DEFAULT CURRENT_TIMESTAMP is a keyword used in the column definition of a database table. It is usually used to automatically set or update the value of a column to the current timestamp (that is, the time when the record is inserted or updated).

[0086] DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP means that when a record is inserted, the field is automatically set to the current timestamp, and when a record is updated, the field is automatically updated to the current timestamp.

[0087] Step 4: Retrieve the protection device table and gateway table at the loop structure layer, build a loop architecture through the basic information of the protection device and the subordinate relationship of the network link, create several loop tables, and establish a mapping relationship between the loop table and the protection device table. In the loop table, mark the loop to which the protection device belongs in the loop architecture according to the mapping relationship. One loop table corresponds to one protection device table and one gateway table;

[0088] When executing step 4, the specific steps include:

[0089] Step 4-1: retrieve the protection device table, and retrieve the corresponding gateway table according to the mapping relationship in the protection device table;

[0090] Step 4-2: According to the installation positions of the devices in the protection device table and the installation positions of the gateways in the gateway table, a loop architecture is constructed. In the loop architecture, each loop corresponds to one protection device, and each gateway corresponds to multiple loops;

[0091] Step 4-3: Create loop tables for all loops based on the loop architecture. Each loop table includes the loop table primary key, protection device table ID, loop name, loop constraint, loop status, creation time, and update time. The protection device table ID represents the relationship between the loop table and the protection device table mapped using the primary key and foreign key.

[0092] In this embodiment, the circuit table is shown in Table 3:

[0093]

[0094] In this embodiment, due to different application scenarios, it is necessary to label the circuits of each power system to indicate the name of the circuit controlled by each protection device, and then display the entire circuit architecture. The present invention creates a circuit table for each protection device table, and the corresponding relationship is a one-to-one relationship, which can intuitively reflect the corresponding relationship between the circuit architecture and the equipment installation location, greatly facilitating future maintenance work and data traceability.

[0095] Step 5: Retrieve the loop table at the calculation layer, obtain the power data collected by the corresponding protection device in the loop table, create a power data table and a threshold setting table, and establish a mapping relationship between the power data table, the threshold setting table and the loop table. One power data table corresponds to one loop table.

[0096] Calculate the power data to obtain energy consumption data, perform threshold judgment on the power data according to the preset threshold in the threshold setting table to obtain alarm data, and store the power data, energy consumption data and alarm data in the power data table;

[0097] When executing step 5, the specific steps include:

[0098] Step 5-1: Retrieve any loop table C, and retrieve the corresponding protection device table according to the mapping relationship in the loop table C;

[0099] Step 5-2: Obtain power data collected by the corresponding protection device in the protection device table, the power data including voltage, current, active power, reactive power, power factor, temperature and leakage current;

[0100] Step 5-3: Calculate energy consumption data based on power data;

[0101] Step 5-4: Create a threshold setting table, and the user enters the threshold of the preset power data in the threshold setting table through any client connected to the smart cloud platform. The threshold setting table specifically includes the threshold setting table primary key, loop ID setting, overvoltage threshold, undervoltage threshold, overcurrent threshold, temperature threshold, creation time and update time, where the loop ID is set to the entered loop name;

[0102] Step 5-5: Perform threshold judgment based on power data and threshold setting table to generate alarm data;

[0103] Step 5-6: Create a power data table, store both power data and alarm data in the power data table, the power data table specifically includes the power data table primary key, loop table ID, threshold setting table ID, timestamp, voltage, voltage alarm, current, current alarm, active power, reactive power, power factor, temperature, temperature alarm, leakage current, leakage current alarm, energy consumption data and creation time, wherein the loop table ID represents the relationship between the power data table and the loop table mapped by the primary key and foreign key, and the threshold setting table ID represents the relationship between the power data table and the threshold setting table mapped by the primary key and foreign key;

[0104] Voltage alarm, current alarm, temperature alarm and leakage current alarm are alarm data;

[0105] Step 5-7: According to the methods of step 5-1 to step 5-7, create corresponding power data tables for all circuits.

[0106] In this embodiment, the power data table is shown in Table 4, and the threshold setting table is shown in Table 5:

[0107]

[0108]

[0109] In this embodiment, the power data table is the entire data body, and each protection device corresponds to a power data table at the same creation time. Although multiple power data tables will be generated over time as time increases, in actual applications, time can be used as a traceability benchmark to query the data generated by a protection device in multiple time periods. Due to the association between the circuit data table and the loop report, the generated data can intuitively reflect the power consumption of a certain loop, which greatly facilitates the user's query and identification.

[0110] Step 6: Enter user information in the user management layer, create several user information tables, each of which corresponds to one user, and store user information in the user information table;

[0111] When executing step 6, the user enters user information through any client connected to the smart cloud platform. The user information table includes the user information table primary key, user name, username, password, role, mobile phone number, email, creation time and update time. Among them, the user name is the identity authentication name entered by the user, the username is the user account name automatically assigned by the user management layer, and the role is the priority setting of the user's management authority. The priority protection is high, medium and low. Each user corresponds to a user information table, and each user information table corresponds to a unique username.

[0112] In this embodiment, the user information table is shown in Table 6:

[0113]

[0114] In this embodiment, the user name is generally the user's real name, which is used to query the user's identity and authenticate. The user name is the account name assigned to the user on the system. A user is assigned a unique account name. The role is the user's management role, which is used to indicate the role's authority. The authority is assigned priority based on size, generally high, medium and low. In this embodiment, high-priority users are listed as users who can receive alarm notifications.

[0115] Step 7: Retrieve the power data table at the alarm layer, generate alarm information based on the alarm data in the power data table, send alarm notifications to relevant personnel based on the alarm information, create several alarm information tables, and establish a mapping relationship between the alarm information table, user information table and power data table. Each alarm information table corresponds to a power data table and a user information table.

[0116] When executing step 7, the specific steps include:

[0117] Step 7-1: Retrieve any power data table D;

[0118] Step 7-2: query the alarm data in the power data table D, and generate alarm information according to the alarm data;

[0119] Step 7-3: Select a user information table ID and create an alarm information table corresponding to the power data table D. The alarm information table includes the alarm information table primary key, the power data table ID, the user information table ID, the alarm constraint, the alarm status, the alarm details, the creation time and the update time. The power data table ID indicates the relationship between the alarm information table and the power data table mapped by the primary key and the foreign key, and the user information table ID indicates the relationship between the alarm information table and the user information table mapped by the primary key and the foreign key;

[0120] The user information table ID is selected as the user information table with the role set as high;

[0121] The alarm status is generated by the alarm data: when any item in the alarm data has a threshold alarm, the alarm status is set to 1; otherwise, the alarm status is set to 0;

[0122] When the alarm status is set to 1, the alarm data is stored in the alarm details;

[0123] Step 7-4: traverse the user information table and create a corresponding alarm information table for each user information table whose role is set to high;

[0124] Step 7-5: traverse all alarm information tables, create an alarm notification according to each alarm information table with an alarm status of 1, and send an alarm notification to the corresponding user according to the user information table ID in the alarm information table;

[0125] Step 7-6: According to the methods of steps 7-1 to 7-5, create alarm information tables corresponding to all power data tables, and send corresponding alarm notifications.

[0126] In this embodiment, the alarm information table is shown in Table 7:

[0127]

[0128] In this embodiment, due to the complexity of power data and the huge amount of data, the present invention creates an alarm information table for each power data table. Even if no alarm data is generated in the power data table, the corresponding alarm information table still exists (the alarm status is 0 at this time). This makes it convenient to trace the data source of the alarm event and find the cause of the alarm in the future.

[0129] Since there can be multiple users set with high priority, once alarm data is generated, it is necessary to send alarm notifications to these users one by one. The method adopted by the present invention is to correspond one user information table to each alarm information table. If it needs to be sent to multiple people, multiple alarm information tables are required. The purpose of doing this is to facilitate the tracing of alarm events in the future, that is, to determine the alarm events of each person at a certain time, which greatly improves the accuracy of tracing.

[0130] The cloud platform-based power detection method described in the present invention solves the technical problems of adopting a hierarchical data storage structure to modularize data, intuitively reflect the underlying hardware system architecture, strengthen the relationship between data, and improve the efficiency and traceability of data processing. The present invention adopts a layered database storage. By dividing the smart cloud platform into a network layer, a protection device layer, a loop structure layer, a computing layer, an alarm layer, and a user management layer, the system realizes a modular design, which is easy to manage and maintain. The data isolation between different layers improves the security and integrity of the data and reduces data redundancy. The hierarchical structure makes the system expansion more convenient. Each layer module can be added or modified according to needs without affecting the functions of other layers. The present invention adopts data management in the form of a form. By managing data in the form, the data structure is clear and easy to query, modify and Maintenance, the data display in the form of forms is intuitive and clear, and users can easily view and edit relevant information. Users only need to fill in individual forms to complete complete data entry and management, which reduces the complexity of operation and improves work efficiency. Through the mapping relationship between forms, the source and change process of the data can be traced back, which improves data transparency and traceability. The foreign key relationship between forms makes the data highly correlated, which is convenient for multi-table joint query and comprehensive analysis. When data problems occur, the relevant forms and specific data can be quickly located, which improves the efficiency of troubleshooting and problem solving. The present invention adopts a hierarchical structure and form-based management, which can effectively process massive data, improve data processing speed and system response speed, and through hierarchical and modular design, the data processing load can be evenly distributed to each layer and module to avoid performance bottlenecks caused by excessive pressure at a single point.

Claims

1. A power detection method based on a cloud platform, characterized in that: The steps include: Step 1: Establish a smart cloud platform, gateway and protection equipment, and build the network layer, protection equipment layer, loop structure layer, computing layer, alarm layer and user management layer on the smart cloud platform; Step 2: Establish network links between the smart cloud platform, gateways, and protection devices at the network layer, and record the subordinate relationships of the network links. Create several gateway tables based on the subordinate relationships. A gateway table stores the link information between a gateway and multiple protection devices. The link information includes the MAC address of the protection device. Step 3: Enter the basic information of the protection device at the protection device layer, create several protection device tables, establish a mapping relationship between the protection device table and the gateway table, automatically obtain the MAC address of the protection device according to the mapping relationship, and check the MAC address of the protection device according to the basic information. After the verification is correct, store the basic information and the MAC address of the protection device in the protection device table. One protection device table corresponds to one protection device; Step 4: Retrieve the protection device table and gateway table at the loop structure layer, build a loop architecture through the basic information of the protection device and the subordinate relationship of the network link, create several loop tables, and establish a mapping relationship between the loop table and the protection device table. In the loop table, mark the loop to which the protection device belongs in the loop architecture according to the mapping relationship. One loop table corresponds to one protection device table and one gateway table; Step 5: Retrieve the loop table at the calculation layer, obtain the power data collected by the corresponding protection device in the loop table, create a power data table and a threshold setting table, and establish a mapping relationship between the power data table, the threshold setting table and the loop table. One power data table corresponds to one loop table. Calculate the power data to obtain energy consumption data, perform threshold judgment on the power data according to the preset threshold in the threshold setting table to obtain alarm data, and store the power data, energy consumption data and alarm data in the power data table; When executing step 5, the specific steps include: Step 5-1: Retrieve any loop table C, and retrieve the corresponding protection device table according to the mapping relationship in the loop table C; Step 5-2: Obtain power data collected by the corresponding protection device in the protection device table, the power data including voltage, current, active power, reactive power, power factor, temperature and leakage current; Step 5-3: Calculate energy consumption data based on power data; Step 5-4: Create a threshold setting table, and the user enters the threshold of the preset power data in the threshold setting table through any client connected to the smart cloud platform. The threshold setting table specifically includes the threshold setting table primary key, loop ID setting, overvoltage threshold, undervoltage threshold, overcurrent threshold, temperature threshold, creation time and update time, where the loop ID is set to the entered loop name; Step 5-5: Perform threshold judgment based on power data and threshold setting table to generate alarm data; Step 5-6: Create a power data table, store both power data and alarm data in the power data table, the power data table specifically includes the power data table primary key, loop table ID, threshold setting table ID, timestamp, voltage, voltage alarm, current, current alarm, active power, reactive power, power factor, temperature, temperature alarm, leakage current, leakage current alarm, energy consumption data and creation time, wherein the loop table ID represents the relationship between the power data table and the loop table mapped by the primary key and foreign key, and the threshold setting table ID represents the relationship between the power data table and the threshold setting table mapped by the primary key and foreign key; Voltage alarm, current alarm, temperature alarm and leakage current alarm are alarm data; Step 5-7: According to the method of step 5-1 to step 5-6, establish corresponding power data tables for all circuits; Step 6: Enter user information in the user management layer, create several user information tables, each of which corresponds to one user, and store user information in the user information table; Step 7: Retrieve the power data table at the alarm layer, generate alarm information based on the alarm data in the power data table, send alarm notifications to relevant personnel based on the alarm information, create several alarm information tables, and establish a mapping relationship between the alarm information table, user information table and power data table. Each alarm information table corresponds to a power data table and a user information table.

2. The cloud platform-based power detection method according to claim 1, characterized in that: When executing step 2, the specific steps include: Step 2-1: Any gateway A establishes a data link with the smart cloud platform; Step 2-2: After multiple protection devices establish links with gateway A, gateway A obtains and saves the MAC address of each protection device that establishes a link with itself, updates the connection status of the protection device in real time, and generates a link device MAC list and a link device online status list; Step 2-3: Create a gateway table corresponding to gateway A, which includes the gateway table primary key, gateway name, installation location, online status, linked device MAC list, linked device online status list and update time, and set constraints in the gateway table; Step 2-4: According to the methods from step 2-1 to step 2-3, create a gateway table for all gateways that establish data links with the smart cloud platform.

3. The cloud platform-based power detection method according to claim 1, characterized in that: When executing step 3, the specific steps include: Step 3-1: The user enters the basic information of any protection device B into the smart cloud platform through any client connected to the smart cloud platform. The basic information includes the device MAC, installation location, device name, device constraints, manufacturer, model, last maintenance date, and installation date; Step 3-2: Protect device B from connecting to any gateway; Step 3-3: Retrieve all gateway tables, and query and check the corresponding protection device B in all gateway tables according to the entered device MAC: If the entered device MAC is found in any gateway table, execute step 3-5; if the entered device MAC is not found in all gateway tables, execute step 3-4; Step 3-4: Send an error message for entering the device MAC through the client and execute step 3-1; Step 3-5: Create a protection device table for protection device B based on the link relationship between protection device B and the gateway. The protection device table includes the protection device table primary key and the gateway table ID. Enter the device MAC, installation location, device name, device constraint, manufacturer, model, installation date, creation time, update time, and last maintenance date. The gateway table ID indicates the relationship between the protection device table and the gateway table that is mapped using the primary key and foreign key. Step 3-6: According to the methods of step 3-1 to step 3-5, a protection device table is created for each protection device, and each protection device table corresponds to a gateway table.

4. The cloud platform-based power detection method according to claim 1, characterized in that: When executing step 4, the specific steps include: Step 4-1: retrieve the protection device table, and retrieve the corresponding gateway table according to the mapping relationship in the protection device table; Step 4-2: According to the installation positions of the devices in the protection device table and the installation positions of the gateways in the gateway table, a loop architecture is constructed. In the loop architecture, each loop corresponds to one protection device, and each gateway corresponds to multiple loops; Step 4-3: Create loop tables for all loops based on the loop architecture. Each loop table includes the loop table primary key, protection device table ID, loop name, loop constraint, loop status, creation time, and update time. The protection device table ID represents the relationship between the loop table and the protection device table mapped using the primary key and foreign key.

5. The cloud platform-based power detection method according to claim 1, characterized in that: When executing step 6, the user enters user information through any client connected to the smart cloud platform. The user information table includes the user information table primary key, user name, username, password, role, mobile phone number, email, creation time and update time. Among them, the user name is the identity authentication name entered by the user, the username is the user account name automatically assigned by the user management layer, and the role is the priority setting of the user's management authority. The priority protection is high, medium and low. Each user corresponds to a user information table, and each user information table corresponds to a unique username.

6. The cloud platform-based power detection method according to claim 5, characterized in that: When executing step 7, the specific steps include: Step 7-1: Retrieve any power data table D; Step 7-2: query the alarm data in the power data table D, and generate alarm information according to the alarm data; Step 7-3: Select a user information table ID and create an alarm information table corresponding to the power data table D. The alarm information table includes the alarm information table primary key, the power data table ID, the user information table ID, the alarm constraint, the alarm status, the alarm details, the creation time and the update time. The power data table ID indicates the relationship between the alarm information table and the power data table mapped by the primary key and the foreign key, and the user information table ID indicates the relationship between the alarm information table and the user information table mapped by the primary key and the foreign key; The user information table ID is selected as the user information table with the role set as high; The alarm status is generated by the alarm data: when any item in the alarm data has a threshold alarm, the alarm status is set to 1; otherwise, the alarm status is set to 0; When the alarm status is set to 1, the alarm data is stored in the alarm details; Step 7-4: traverse the user information table and create a corresponding alarm information table for each user information table whose role is set to high; Step 7-5: traverse all alarm information tables, create an alarm notification according to each alarm information table with an alarm status of 1, and send an alarm notification to the corresponding user according to the user information table ID in the alarm information table; Step 7-6: According to the methods of steps 7-1 to 7-5, create alarm information tables corresponding to all power data tables, and send corresponding alarm notifications.