1 Solution Requirements
1.1 Data Collection Requirements
The data types of the energy meter are: 1 current, 2 voltage, 3 power factor, 4 total power, 5 total power loss information, 6 maximum demand, 7 power (peak, peak, flat, valley)
1.2 Database Requirements
The database contains 1 current, 2 voltage, 3 power factor, 4 total power, 5 total power loss information, 6 maximum demand, 7 power It is best to give an example of the name of the table in the corresponding database.
SQL data store for locally deployed databases , which can synchronize cloud database data three times within ten minutes .
1.3 Platform Requirements
(1) Can the power data in the platform correspond to the statistical power after the "infrared collector" sets the mutual inductor multiple?
(2 ) For devices in a software group, can the total power of the group be automatically summarized and the group name be displayed on the right?
(3 ) Can the software display the statistical information of the three indicators of "total electricity consumption for the day", "total electricity consumption for the month" and "total electricity consumption for the year"?
(4) View on a mobile phone. For example, after logging into the WeChat public account, click "Monitor" to display all collectors. The display can be grouped. If the number of installations increases in the future, the mobile phone will display hundreds of collectors. It is impossible to determine which three of them are the collectors of the specified user, which is inconvenient to view and count.
2 Data collection plan
This data collection uses a 4G wireless infrared meter reader, uses infrared communication to send and receive data, and finally pushes it to the platform through a wireless module.
Wireless infrared meter reader
3 Database Solution
At the request of the customer, a database (data) was established and a data table (data) was created, including keys (data number, organization code, company, equipment name, equipment number, update date, total power, forward spike, forward peak, forward flat, forward valley, phase A voltage, phase B voltage, phase C voltage, phase A current, phase B current, phase C current, power factor, total active power, total reactive power).
The server is deployed in the cloud, using Alibaba Cloud servers (provided by the customer), which can collect data and send it to the database within five minutes (as required by the customer). Then it is uploaded to the big screen through the database.
Database display
4 Cloud platform computer and mobile phone data display solution
Computer interface diagram
Mobile phone interface diagram
5 Actual installation effect