CN114519057A - Smart building equipment historical data storage method - Google Patents
Smart building equipment historical data storage method Download PDFInfo
- Publication number
- CN114519057A CN114519057A CN202210145453.8A CN202210145453A CN114519057A CN 114519057 A CN114519057 A CN 114519057A CN 202210145453 A CN202210145453 A CN 202210145453A CN 114519057 A CN114519057 A CN 114519057A
- Authority
- CN
- China
- Prior art keywords
- equipment
- data
- data storage
- storing
- value
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Fuzzy Systems (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for storing historical data of intelligent building equipment, which is convenient for later statistical analysis. The method comprises the following steps: (10) real-time data acquisition: acquiring real-time data of construction equipment; (20) selecting a data storage format: selecting different formats of stored data according to the service analysis characteristics; (30) storing data with the device: in each data storage period, storing the real-time data of the construction equipment in an equipment data table with equipment as a unit, and turning to (60); (40) store data with device type: in each data storage period, storing the real-time data of the construction equipment into an equipment data table with equipment as a unit, and turning to (60); (50) formulating the stored data: storing the real-time data of the construction equipment in a total value data table taking a total value as a unit in each data storage period, and turning to (60); (60) and (3) finishing data storage: and finishing data storage and waiting for service application extraction.
Description
Technical Field
The invention belongs to the technical field of intelligent building equipment management, and particularly relates to a historical data storage method for intelligent building equipment.
Background
In the field of internet of things of smart buildings, devices are generally divided according to system type, the system generally refers to systems in the building, such as a power supply and distribution system, a water supply and drainage system, a fire fighting system, an air conditioning system and the like, the type refers to the type classification of devices of a certain type of system, such as a power supply and distribution system, the type division generally refers to high-voltage power distribution devices, a low-voltage power distribution cabinet, a standby power supply device, a low-voltage power distribution cabinet, an electricity meter box, an entrance box, public lighting, power supply and distribution kit accessories and the like, the type refers to types of devices of a certain type of system, such as a high-voltage power distribution device type, a high-voltage incoming line cabinet, a high-voltage metering cabinet, a high-voltage outgoing line cabinet, a high-voltage power distribution cabinet, a high-voltage interconnection cabinet, a high-voltage ring main unit, a direct current screen, a transformer, a high-voltage lifting cabinet, an active electric quantity filtering cabinet, a high-voltage compensation cabinet and the like. Each device belongs to a system type, a standard measuring point is generally designated for the system type, and then the device has measuring point attributes, measuring point types are int, float, string, pool and the like, and the measuring points have names, English short codes, unit attributes, data format definitions and the like.
The statistical analysis of historical data of equipment in business needs reasonable storage of the historical data of the equipment, and the statistical analysis is usually carried out in the following dimensions, wherein the statistical dimensions comprise buildings, floors, regions, tenants, entrances and exits, periods (period type definitions, minutes, seconds, minutes, hours, days, weeks, months and years) and the like. At present, the whole quantity of the data is generally stored according to the actual report value of the equipment. When the business has the statistical analysis requirement, the big data statistics or analysis is carried out from the full data to obtain the business data needed by the business.
However, the above construction equipment history data storage method has disadvantages in that:
1. for the business analysis requirements of different projects, repeatedly performing development codes to perform statistical analysis;
2. the delivery process of the project is long, and the labor cost of development is high;
3. different projects require testers to spend more time performing business tests.
In summary, the prior art has the following problems: the historical data of the intelligent building equipment stored is not beneficial to later-stage statistical analysis.
Disclosure of Invention
The invention aims to provide a method for storing historical data of intelligent building equipment, which is convenient for later statistical analysis.
The technical solution for realizing the purpose of the invention is as follows:
a smart building equipment historical data storage method comprises the following steps:
(10) acquiring real-time data: acquiring real-time data of the construction equipment;
(20) selecting a data storage format: selecting different data storage formats according to the characteristics of the service analysis;
when the device is selected to store data, jumping to (30);
when the data is selected to be stored in the device type, jumping to (40);
when the data is selected to be stored in the formula, jumping to (50);
(30) Storing, with a device: in each data storage period, storing real-time data of the construction equipment in an equipment data table with equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (60);
(40) store data with device type: in each data storage period, storing real-time data of the construction equipment into an equipment data table with equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (60);
(50) formulating the stored data: in each data storage period, storing the real-time data of the construction equipment in a total value data table taking a total value as a unit, wherein the structure of the total value data table is defined by the combination of the total value, the period type and the period value obtained by selecting a corresponding calculation formula according to the service characteristics; and jumping to the step (60);
(60) and (3) finishing data storage: and finishing data storage and waiting for service application extraction.
Compared with the prior art, the invention has the following remarkable advantages: the later statistical analysis is convenient to use. The concrete embodiment is as follows:
1. Conventional business data statistics need not be developed, and business statistical data can be obtained through equipment, equipment types and a formula custom configuration mode. The device and the device type can configure service statistical data from the multi-cycle dimensionality of the device and the class of devices; the service statistical data can be configured from dimensions such as buildings, floors, areas, tenants and the like through formula configuration;
2. supporting equipment array configuration: introduced as a calculation factor, the implementation can participate in the formulation operation by defining a set of devices as a device array, which simplifies the implementation configuration of the total value. The introduction of the device array generally originates from the service statistics of the group of devices for multiple times, and does not need to frequently input the group of devices as a calculation factor;
3. support for aggregate configuration: the service application can define a total value according to a custom partition, for example, a dimension such as a statistical area, a floor or a tenant and the like is used for counting data (such as electric charge) of a certain system type. The user can more flexibly carry out formulaic statistics according to the requirements of the user on the service scene by self-defining the total value;
4. support for iterative calculation of the aggregate value: the result of the total value can be used as a calculation factor of other total values to carry out iterative calculation, and infinite iterative calculation is supported. In the service operation, if 5 tenants in the campus with the highest electricity consumption cost are calculated, all the tenants in the campus can be defined as a total value, and the top 5 of the ranking of the total value arrays is taken through a self-defined function;
5. Standardization of service software interface: interface normalization for statistical analysis over a most likely standardized project, the standardized interface comprising: paging to obtain measuring point information of the equipment; acquiring historical data of a designated measuring point of equipment in a designated period; acquiring total value storage data; periodic statistics (e.g., averages, summations, etc.) are obtained by system class type.
The invention is described in further detail below with reference to the figures and the detailed description.
Drawings
Fig. 1 is a main flow chart of a method for storing historical data of intelligent construction equipment according to the invention.
FIG. 2 is a flow chart of the step of formulating stored data in FIG. 1.
Detailed Description
The invention relates to a historical data storage method of intelligent building equipment, which is used for storing the historical data of the real-time data of the intelligent building equipment according to the configuration rule so as to utilize the utilization of later statistical analysis.
If the power consumption of a certain building is analyzed, and the current building has a general household table, single equipment is selected for storage; for example, the access records of each access control are checked, the equipment of the system type of each access control is stored, and tick access records are obtained; and for example, the total electricity consumption of a certain tenant is calculated, and the combination is possibly a multi-block area multi-block metering summary table, and then the formula storage is adopted.
As shown in fig. 1, the method for storing historical data of intelligent building equipment of the invention comprises the following steps:
(10) real-time data acquisition: acquiring real-time data of the construction equipment;
(20) selecting a data storage format: selecting different data storage formats according to the characteristics of the service analysis, and jumping to the step (30) when the equipment is selected to store data; when the data is selected to be stored in the device type, jumping to (40); when the data is selected to be stored in the formula, jumping to (50);
(30) storing data with the device: in each data storage period, storing real-time data of the construction equipment in an equipment data table taking equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (60);
the step (20) of storing data by the device is specifically as follows:
and in each data storage period, selecting equipment from the real-time data of the construction equipment, wherein the equipment comprises equipment identification, equipment coding, a selected period type and a selected period value, and storing the equipment in a storage table with equipment as a unit, and the storage table structure is defined according to the equipment identification, the equipment coding, the period type and the period value combination.
(40) Store data with device type: in each data storage period, storing real-time data of the construction equipment into an equipment data table with equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (50);
unlike (20), scope access extends to all devices of the system class type, with the benefit that one class of device can be configured at a time, rather than requiring one device configuration;
(50) formulating the stored data: in each data storage period, storing the real-time data of the construction equipment in a total value data table taking a total value as a unit, wherein the structure of the total value data table is defined by the combination of the total value, the period type and the period value obtained by selecting a corresponding calculation formula according to the service characteristics; and jumping to the step (50);
the calculation formula corresponding to the service characteristics includes a calculation factor, a calculation sign and a function.
As shown in fig. 2, the (50) formulating the stored data step includes:
(51) and determining a total value calculation formula: selecting a corresponding total value formula according to the service characteristics of the user;
(52) calculating factor calculation sign determination: selecting a calculation factor and a calculation symbol according to the sum value formula;
The calculation factor can be a constant, a variable (a measuring point of the equipment), an equipment array and a total value;
if tenant A is a region or a plurality of regions of a campus, assuming three general electric meters a1, a2 and a3, the electricity charge of tenant A per month is counted on the business. From the service requirement, we can know that a total value needs to be stored, the stored cycle type is month, the cycle value is 1, the formula of the total value is the total electricity quantity, namely the local electricity price and the total electricity quantity of tenant A, then the calculation factors are the local electricity price and the total electricity quantity of tenant A, the calculation sign is, here, we define the total electricity quantity of tenant A as a total value, the total value is equipment array a1, a2, a3, and the function is summation and the monthly increment value of the equipment (i.e. the total quantity of the last day of each month-the last day of the previous month)
(53) Storage cycle type cycle value determination: determining a storage cycle type and a cycle value according to service requirements;
as in the above example: according to the service requirement, it can be determined that the storage period type is month and the period value is 1.
(54) Constructing a total value data table: according to the total value, the cycle type and the cycle value obtained by the calculation formula, a total value data table with the total value as a unit is defined in a combined mode;
(55) And (3) data storage: storing building equipment real-time data in the aggregate value data table during each data storage period.
(60) And (3) finishing data storage: and finishing data storage and waiting for service application extraction.
After the data storage is finished, the service application can acquire the data required by the service through a standard general interface of the historical data storage service.
Claims (3)
1. A smart construction equipment historical data storage method is characterized by comprising the following steps:
(10) acquiring real-time data: acquiring real-time data of the construction equipment;
(20) selecting a data storage format: selecting different data storage formats according to the characteristics of the service analysis;
when the device is selected to store data, jumping to (30);
when the data is selected to be stored in the device type, jumping to (40);
when the data is selected to be stored in the formula, jumping to (50);
(30) storing data with the device: in each data storage period, storing real-time data of the construction equipment in an equipment data table taking equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (60);
(40) store data with device type: in each data storage period, storing real-time data of the construction equipment into an equipment data table with equipment as a unit, wherein the structure of the equipment data table is defined according to equipment identification, equipment coding, cycle type and cycle value combination; and jumping to the step (60);
(50) Formulating the stored data: in each data storage period, storing the real-time data of the construction equipment in a total value data table taking a total value as a unit, wherein the structure of the total value data table is defined by the combination of the total value, the period type and the period value obtained by selecting a corresponding calculation formula according to the service characteristics; and jumping to the step (60);
(60) and (3) finishing data storage: and finishing data storage and waiting for service application extraction.
2. The intelligent building equipment historical data storage method according to claim 1, wherein the step (20) of storing data by equipment is specifically as follows:
and in each data storage period, selecting equipment from the real-time data of the construction equipment, wherein the equipment comprises equipment identification, equipment coding, a selected period type and a selected period value, and storing the equipment in a storage table with equipment as a unit, and the storage table structure is defined according to the equipment identification, the equipment coding, the period type and the period value combination.
3. The intelligent construction equipment historical data storage method according to claim 1, wherein the (50) formulaically storing data step comprises:
(51) and determining a total value calculation formula: selecting a corresponding total value formula according to the service characteristics of the user;
(52) Calculating factors, calculating signs and calculating function determination: selecting a calculation factor, a calculation symbol and a calculation function according to the sum value formula;
(53) storage cycle type cycle value determination: determining a storage cycle type and a cycle value according to the service requirement;
(54) constructing a total value data table: according to the total value, the cycle type and the cycle value obtained by the calculation formula, a total value data table with the total value as a unit is defined in a combined mode;
(55) data storage: storing building equipment real-time data in the aggregate value data table during each data storage period.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210145453.8A CN114519057A (en) | 2022-02-14 | 2022-02-14 | Smart building equipment historical data storage method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210145453.8A CN114519057A (en) | 2022-02-14 | 2022-02-14 | Smart building equipment historical data storage method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114519057A true CN114519057A (en) | 2022-05-20 |
Family
ID=81598532
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210145453.8A Pending CN114519057A (en) | 2022-02-14 | 2022-02-14 | Smart building equipment historical data storage method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114519057A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116737988A (en) * | 2023-05-29 | 2023-09-12 | 四川云控交通科技有限责任公司 | Intelligent building data management method and management system |
-
2022
- 2022-02-14 CN CN202210145453.8A patent/CN114519057A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116737988A (en) * | 2023-05-29 | 2023-09-12 | 四川云控交通科技有限责任公司 | Intelligent building data management method and management system |
| CN116737988B (en) * | 2023-05-29 | 2024-03-08 | 四川云控交通科技有限责任公司 | Intelligent building data management method and management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR101904831B1 (en) | Intellgent building management system and method for controlling thereof | |
| CN114519057A (en) | Smart building equipment historical data storage method | |
| CN109444800A (en) | Platform area recognition methods based on wireless communication acquisition | |
| CN114279058A (en) | Energy consumption allocation method for air conditioner of public building | |
| CN105867274B (en) | Electric control system and method are connect based on remote bill control, the anti-intelligent residential district dress table visited one house after another | |
| CN108490285A (en) | A kind of low-voltage platform area line loss per unit computational methods based on fall of potential method | |
| CN110825834A (en) | Method and system for measuring correlation matching between automation terminal data and GIS system distribution transformer and readable storage medium | |
| CN107167655A (en) | Power supply service system and method based on intelligent electric meter terminal | |
| CN111969598B (en) | User side energy storage optimization method and system considering excitation type demand side response | |
| CN205827195U (en) | Electric control system is connect based on remote bill control, the anti-intelligent residential district dress table visited one house after another | |
| CN112364755A (en) | Big data-based power consumption monitoring and management system for smart electric meter | |
| Santos et al. | Development of an IoT-based water and power monitoring system for residential building | |
| CN112016174A (en) | Multi-source distribution network grid diagram-based user variable relationship checking method | |
| Shinde et al. | New development in energy meter reading system | |
| CN115830856A (en) | Big data based information service system and method | |
| CN113592531A (en) | Method and system for calculating number of idle users in transformer area | |
| CN113076302A (en) | Power grid data management method, device, equipment and medium | |
| CN114860790A (en) | Marketing meter reading abnormity analysis system | |
| CN114358753A (en) | Dynamic energy consumption charging apportionment method, system, computer equipment and storage medium | |
| Vogel | Urban segregation in Sweden housing policy, housing markets, and the spacial distribution of households in metropolitan areas | |
| JP2003324844A (en) | Electricity charge simulation system for introduction of high-voltage receiving facility to collective housing such as condominium | |
| CN112803412A (en) | Distribution network contact point type identification method and system | |
| CN111552699A (en) | Resident energy consumption reporting system based on electric power point reward | |
| JP3022315U (en) | Electric power meter reading system | |
| CN114781105A (en) | Energy loss calculation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |