CN111581187A - Data management method and device for intelligent park, computer equipment and storage medium - Google Patents
Data management method and device for intelligent park, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111581187A CN111581187A CN202010405548.XA CN202010405548A CN111581187A CN 111581187 A CN111581187 A CN 111581187A CN 202010405548 A CN202010405548 A CN 202010405548A CN 111581187 A CN111581187 A CN 111581187A
- Authority
- CN
- China
- Prior art keywords
- building
- park
- identification
- equipment
- information table
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000013523 data management Methods 0.000 title claims abstract description 32
- 238000013508 migration Methods 0.000 claims description 31
- 230000005012 migration Effects 0.000 claims description 31
- 238000004590 computer program Methods 0.000 claims description 23
- 238000007619 statistical method Methods 0.000 claims description 16
- 238000012544 monitoring process Methods 0.000 claims description 14
- 238000009434 installation Methods 0.000 claims description 13
- 238000007726 management method Methods 0.000 abstract description 8
- 238000010586 diagram Methods 0.000 description 22
- 230000008569 process Effects 0.000 description 5
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 5
- 238000010248 power generation Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000005611 electricity Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
-
- 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/23—Updating
-
- 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/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to a data management method and device for an intelligent park, computer equipment and a storage medium. The method comprises the following steps: acquiring equipment data of each piece of equipment in the intelligent park; splitting the equipment identification of the equipment corresponding to the equipment data to obtain a park identification and a building identification; inquiring an affiliated intelligent park information table of the equipment data from an affiliated intelligent park information table of the constructed intelligent park database according to the park identification; inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification; inquiring an affiliated equipment data table of the equipment data from an affiliated equipment data table of the affiliated building information table according to the equipment identification; and filling the device data into the device data table. By adopting the method, the management efficiency can be improved.
Description
Technical Field
The application relates to the technical field of big data, in particular to a data management method and device for an intelligent park, computer equipment and a storage medium.
Background
With the rapid development and deep application of new technologies such as global internet of things, big data, cloud computing, artificial intelligence and the like, the construction of a smart park becomes a development trend. At present, the construction of a management system of the 'smart park' is not complete, the existing design is not popularized on a large scale, and a database constructed by a platform of the 'smart park' system is not developed in a completely traditional technology.
However, the management data of the existing intelligent park has the characteristics of multiple data types and large data volume, so that when the park data needs to be statistically analyzed, the corresponding data is often required to be screened from massive data and then analyzed and displayed, and the efficiency of data management is reduced.
Disclosure of Invention
In view of the above, it is desirable to provide a data management method, apparatus, computer device, and storage medium for an intelligent park that can improve management efficiency.
A method for managing data in an intelligent campus, the method comprising:
acquiring equipment data of each piece of equipment in the intelligent park;
splitting the equipment identification of the equipment corresponding to the equipment data to obtain a park identification and a building identification;
inquiring an affiliated intelligent park information table of the equipment data from an affiliated intelligent park information table of a constructed intelligent park database according to the park identification;
inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
inquiring an affiliated device data table of the device data from an affiliated device data table of the affiliated building information table according to the device identification;
and filling the equipment data into the affiliated equipment data table.
In one embodiment, the method further comprises:
receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a migrated building and a park identifier of a smart park of the migrated building;
according to the building identification of the migrated building, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from a constructed intelligent park database;
updating the park identification and the affiliated park identification field in the building identification of the building information table of the migrated building into the park identification of the smart park of the building to be migrated, and completing the migration of the building information;
and updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the smart park of the building to be moved, and finishing the movement of the equipment data.
In one embodiment, before acquiring the device data of each device in the smart campus, the method further includes a step of constructing a smart campus database, including:
generating park identifications of the intelligent parks;
generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise the park identifications;
generating a device identification of an accessory device of the building according to the building identification, wherein the device identification comprises the building identification;
and constructing a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment based on the park identification, the building identification and the equipment identification to obtain a smart park database.
In one embodiment, the constructing a smart campus information table of each smart campus, a building information table of each building, and a device data table of each device based on the campus identifier, the building identifier, and the device identifier to obtain a smart campus database includes:
acquiring basic information of an intelligent park, basic information of a building and basic information of equipment of each device;
respectively establishing an intelligent park information table, a building information table and an equipment data table of each equipment according to the intelligent park basic information, the building basic information and the equipment basic information;
and associating the park identification with the intelligent park information table and the building information table, associating the building identification with the building information table and the equipment data table, and associating the equipment identification with the equipment data table, and establishing the hierarchical relationship of the intelligent park information table, the building information table and the equipment data table to obtain an intelligent park database.
In one embodiment, said associating said campus identification with said smart campus information table and said building information table comprises:
setting the meter identification of the intelligent park information table as the park identification, and storing the park identification into the building information table;
the building identification is associated with the building information table and the device data table, including:
and setting the table identification of the building information table as the building identification, and storing the building identification into the equipment data table.
In one embodiment, the device data table comprises a device information general table and a device data sub-table;
the device sub-data table comprises a monitoring operation device data table, a statistical analysis device data table and an event record device data table.
In one embodiment, the populating the device data into the device data table includes:
acquiring fields in the data table of the equipment;
performing statistical analysis on the equipment data according to the fields to obtain the field values of the fields;
and filling the field value to the position of the corresponding field in the data table of the belonging device.
A data management apparatus of a comedy area, the apparatus comprising:
the acquisition module is used for acquiring equipment data of each piece of equipment in the intelligent park;
the splitting module is used for splitting the equipment identifier of the equipment corresponding to the equipment data to obtain a park identifier and a building identifier;
the park query module is used for querying an intelligent park information table to which the equipment data belongs from an auxiliary intelligent park information table of the constructed intelligent park database according to the park identification;
the building query module is used for querying the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
the equipment inquiry module is used for inquiring an affiliated equipment data table of the equipment data from an affiliated equipment data table of the affiliated building information table according to the equipment identification;
and the filling module is used for filling the equipment data into the equipment data table.
A computer apparatus comprising a memory storing a computer program and a processor implementing the steps of any of the above methods of data management for an intelligent campus when the computer program is executed.
A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method for data management of an intelligent park as defined in any one of the preceding claims.
According to the data management method and device for the smart park, the computer equipment and the storage medium, when the equipment data of the equipment in the smart park are obtained, the park identification and the building identification are obtained by splitting the equipment identification of the equipment corresponding to the equipment data, and then the equipment data table is inquired step by step from the established smart park database based on the park identification, the building identification and the equipment identification to fill the equipment data. According to the method, each equipment identifier in the smart park completely comprises the building identifier and the park identifier, so that corresponding equipment data can be quickly searched and positioned in the smart park database based on the equipment identifiers for operation management, and the data management efficiency of the smart park is improved.
Drawings
FIG. 1 is a diagram of an exemplary data management system for an intelligent campus;
FIG. 2 is a flow chart illustrating a data management method for an intelligent campus according to an embodiment;
FIG. 3 is a flow chart illustrating a data management method for an intelligent park according to another embodiment;
FIG. 4 is a diagram of an intelligent campus information table in one embodiment;
FIG. 5 is a schematic diagram of a building information table in one embodiment;
FIG. 6 is a diagram of a device information summary table in one embodiment;
FIG. 7 is a schematic diagram of a photovoltaic device operational information table in one embodiment;
FIG. 8 is a schematic view of a water meter monitoring table in one embodiment;
FIG. 9 is a schematic diagram of a meter monitoring table in one embodiment;
FIG. 10 is a diagram illustrating an example of a table of entrance guard operating records;
FIG. 11 is a diagram of a camera video record table in one embodiment;
FIG. 12 is a schematic diagram of an air monitoring information table in one embodiment;
FIG. 13 is a diagram of a table of temperature monitoring information in one embodiment;
FIG. 14 is a diagram of a statistical table of power generation amount information of a photovoltaic device according to an embodiment;
FIG. 15 is a diagram illustrating an exemplary power quality monitoring terminal operating table;
FIG. 16 is a diagram of a device event record table in one embodiment;
FIG. 17 is a block diagram of an intelligent campus database architecture in accordance with one embodiment;
FIG. 18 is a block diagram of a data management device of an intelligent campus in one embodiment;
FIG. 19 is a diagram showing an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The data management method of the intelligent park can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The server 104 acquires equipment data of each equipment in the intelligent park; the server 104 splits the device identifier of the device corresponding to the device data to obtain a campus identifier and a building identifier; the server 104 inquires the intelligent park information table to which the equipment data belongs from the auxiliary intelligent park information tables of the constructed intelligent park database according to the park identification; the server 104 inquires the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification; the server 104 inquires the affiliated device data table of the device data from the affiliated device data table of the affiliated building information table according to the device identification; the server 104 populates the device data table with the device data. The terminal 102 may be, but is not limited to, various device terminals in a smart park, such as a photovoltaic device, a water meter, an electric meter, a camera, and the like. The terminal may also be various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.
In one embodiment, as shown in fig. 2, a data management method for an intelligent park is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:
step S202, acquiring equipment data of each equipment in the intelligent park.
The intelligent park is a standard building or building group which is complete in water supply, power supply, gas supply, communication, roads, storage and supporting facilities, reasonable in layout and capable of meeting the requirements of production and scientific experiments in a certain specific industry, and comprises an industrial park, a logistics park, a municipal industrial park, a scientific and technological park, a creative park and the like. The devices are various industrial products used in buildings in smart parks, such as photovoltaic devices, electricity meters, water meters, office equipment, and the like. The device data is data generated using the device, such as device operational data, device status data, and the like.
Specifically, after the terminal acquires the device data of the devices in the intelligent park, the acquired device data is sent to the server. Taking the electric meter device as an example, the electric meter device may send the electric meter data to the terminal, and the terminal sends the electric meter data to the server. Or the server may directly obtain the meter data sent by the meter, including but not limited to the status of the meter, power usage, voltage, etc.
And step S204, splitting the equipment identifier of the equipment corresponding to the equipment data to obtain a park identifier and a building identifier.
Wherein, equipment identification is the only sign that is arranged in showing the wisdom garden equipment, and the garden shows the only sign that is used for showing the wisdom garden, and the building sign is the only sign that is arranged in showing each building in the wisdom garden.
Specifically, the device data carries a corresponding device identifier, for example, when the device data is data of an electric meter, the electric meter data carries an identifier of the electric meter. And splitting the equipment identifier according to the configured digits of the park identifier and the building identifier and the affiliation of the park identifier, the building identifier and the equipment identifier to obtain the park identifier and the building identifier. Since the smart park, the building and the equipment are attached to the building and the building is attached to the smart park, the equipment identifier is the park identifier to which the equipment belongs + the building identifier to which the equipment belongs + the equipment self-identifier (the identifier of the equipment). Namely, the park identification and the building identification are obtained by splitting from the equipment identification from left to right according to the configured digits of the park identification and the building identification. For example, the campus identity is 4 bits, the building identity is also 4 bits, and the device identity of the current device data is abcd1234xxx, then the campus identity abcd and the building identity 1234 are obtained by splitting.
And step S206, inquiring the intelligent park information table to which the equipment data belongs from the auxiliary intelligent park information tables of the constructed intelligent park database according to the park identification.
The intelligent park database is a database which is constructed and used for storing intelligent park information, building information to which the intelligent park belongs and equipment data to which the building belongs. The attached intelligent park information table refers to all intelligent park information tables in an intelligent park database. The intelligent park information table belongs to an intelligent park information table of an intelligent park to which the equipment data correspond.
Specifically, after the garden sign and the building sign that the server split obtained, because the table sign of wisdom garden information table is the garden sign. Therefore, the server matches all the intelligent park information tables in the established intelligent park database through the park identification, inquires the intelligent park information table corresponding to the park identification, and obtains the park information table to which the equipment data belongs.
And S208, inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification.
The auxiliary building information table is a building information table attached to the intelligent park information table, and the belonging building information table is a building information table of a building to which the equipment data correspond. The building information table is stored with a field 'affiliated park identification' associated with the table identification of the intelligent park information table, and the field stores park identifications of affiliated parks of the buildings corresponding to the building information table.
Specifically, the building information table comprises a affiliated park identification field related to the table identification of the intelligent park information table. Therefore, after the server inquires the intelligent park information table through the park identification, the building information table related to the park identification is directly obtained according to the park identification, and the affiliated building information table of the intelligent park information table is obtained. And then, the server matches the detached building identification from the affiliated building information table, inquires the affiliated building information table corresponding to the building identification, and obtains the affiliated building information table of the equipment data.
And step S210, inquiring an affiliated device data table of the device data from an affiliated device data table of the affiliated building information table according to the device identification.
The auxiliary equipment data table is an equipment data table attached to the building information table, and the equipment data table is a data table storing the equipment data. The device data table stores a field "installation location identification" associated with the table identification of the building information table, and the field stores a building identification of a building in which the device data table corresponds, for indicating in which building the device is installed.
Specifically, since the installation location identification field associated with the table identification of the building information table is included in the device data table. Therefore, after the server queries the affiliated building information table through the building identification, the device data table related to the building is directly acquired according to the building identification, and the accessory device data table of the affiliated building information table is obtained. And then, the server matches the accessory device data table by using the device identifier, inquires the accessory device data table corresponding to the device identifier, and obtains the device data table to which the device data belongs.
And step S212, filling the device data into the device data table.
Specifically, after the server queries and acquires the device data table to which the device data belongs through the park identifier, the building identifier and the device identifier, filling the device data to the position corresponding to the field in the device data according to the field configured in the device data table, and completing device data filling.
According to the data management method of the smart park, when the device data of the devices in the smart park are obtained, the park identification and the building identification are obtained by splitting the device identification of the devices corresponding to the device data, and then the device data table is inquired step by step from the established smart park database based on the park identification, the building identification and the device identification to fill the device data. According to the method, each equipment identifier in the smart park completely comprises the building identifier and the park identifier, so that corresponding equipment data can be quickly searched and positioned in the smart park database based on the equipment identifiers for operation management, and the data management efficiency of the smart park is improved.
In one embodiment, as shown in fig. 3, the data management method of the smart campus further includes:
step 302, receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a building to be migrated and a park identifier of a smart park of the building to be migrated.
The data migration command is a request for managing a building in one intelligent park by dividing the building into another intelligent park. The intelligent park for receiving the building to be migrated is the intelligent park for receiving the building to be migrated. For example, the building 1 of the smart park a is migrated to the smart park B, the building 1 is the migrated building, and the smart park B is the smart park to which the migrating building is to be migrated.
Specifically, a user can issue a data migration instruction to the server through the terminal, and the server receives a building identifier carrying a migrated building issued by the user through the terminal and a park identifier receiving a smart park of the migrated building.
And step 304, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from the constructed intelligent park database according to the building identification of the migrated building.
Specifically, the server splits the building identification of the migrated building to obtain the campus identification of the smart campus corresponding to the migrated building. And then, the server inquires the intelligent park information table corresponding to the migrated building from the intelligent park database of the framework according to the park identification. And then, inquiring the building information table corresponding to the migrated building from the building information table belonging to the intelligent park information table corresponding to the migrated building by using the building identifier. And meanwhile, acquiring the equipment data table associated with the building identification to obtain an auxiliary equipment data table.
And step 306, updating the park identification and the affiliated park identification field in the building identification of the building information table of the migrated building to accept the park identification of the smart park of the migrated building, and completing the migration of the building information.
Specifically, after the server acquires the building information table of the migrated building, the park identification in the building identification of the building information table of the migrated building is replaced by the park identification of the smart park of the migrated building. For example, the building identifier (the table identifier of the building information table) of the building information table of the migrated building is abcd1234 before the migration, and since the campus identifier of the smart campus to which the building to be migrated is accepted is efhi, the updated building identifier is efhi1234, that is, the process of migrating the data of the building 1234 from the smart campus abcd to the smart campus efhi is completed. According to the building identification efhi1234, the data of the building 1234 can be directly determined to be managed by the intelligent park efhi.
Meanwhile, the field 'the park identification to which the smart park belongs' is stored in the building information table. Therefore, the server synchronously updates the park identification of the migrated building from abcd to efhi, and the association relationship between the new intelligent park and the migrated building is established.
And step 308, updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building to receive the park identification of the smart park of the moved building, and finishing the migration of the equipment data.
Specifically, after the server acquires the auxiliary equipment data table of the building information table of the migrated building, the park identification in the equipment identification of the auxiliary equipment data table corresponding to the migrated building is replaced with the park identification of the smart park of the building to be migrated. For example, the device identifier of the auxiliary device data table of the building information table of the building to be migrated is abcd1234sb1 before migration, and since the campus identifier of the smart campus to be migrated is efhi, the updated device identifier is efhi1234sb1, that is, the process of migrating the data of the device sb1 from the smart campus abcd to the smart campus efhi is completed. According to the device identification efhi1234sb1, it can be directly determined that the data of the device sb1 is managed by the wisdom park efhi, and the device sb1 still belongs to the building 1234.
At the same time, the device data table stores the field "installation location identification" associated with the migrated building. Therefore, the server synchronously updates the installation position identification in the auxiliary equipment data table corresponding to the migrated building from abcd1234 to efhi1234, so as to establish a new association relationship between the intelligent park and the equipment.
In this embodiment, because each table in the wisdom garden database has the same affiliation according to the garden sign, building sign and the equipment sign that the affiliation between wisdom garden, building and the equipment generated, consequently when managing different buildings and equipment in different wisdom gardens, only need to change partial sign and can accomplish data management's migration, can continue to use this table, need not to change on a large scale, guarantee the portability of wisdom garden database to improve the efficiency of management.
In one embodiment, the data management method of the smart campus further includes the step of constructing a smart campus database including: generating park identifications of the intelligent parks; generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise park identifications; generating equipment identification of accessory equipment of the building according to the building identification, wherein the equipment identification comprises the building identification; based on the park identification, the building identification and the equipment identification, a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment are constructed, and a smart park database is obtained.
Specifically, the server first generates a park identification of the smart park, a building self-identification of each building, and an equipment self-identification of each equipment, and the park identification, the building self-identification, and the equipment self-identification may be randomly generated through a random function or may be generated by a user designation. Then, the server acquires the configured hierarchical relationship, wherein the hierarchical relationship comprises the intelligent park, the affiliated buildings of the intelligent parks and the affiliated devices of the affiliated buildings. The server determines the smart parks corresponding to the buildings according to the hierarchical relationship, generates park identifications for the corresponding smart parks and combines the park identifications with building self-identifications of the buildings, and the park identifications and the building self-identifications obtain building identifications of the buildings. Similarly, the building corresponding to each device is determined according to the hierarchical relationship, the building identifier generated for the building is combined with the device self-identifier, and the building identifier and the device self-identifier obtain the device identifier (park identifier, building self-identifier and device self-identifier).
Meanwhile, the server acquires basic information of the intelligent park, basic information of the building and basic information of the equipment, which are configured or uploaded in real time by a user. And acquiring an intelligent park information table template, a building information table template and an equipment data table template. Then, the server fills the basic information of the smart park, the basic information of the building and the basic information of the equipment into the smart park information table template, the building information table template and the equipment data table template respectively to obtain the established smart park information table, the building information table and the equipment data table.
After the intelligent park information table, the building information table and the equipment data table are established, the server associates the park identification with the intelligent park information table and the building information table, associates the building identification with the building information table and the equipment data table, associates the equipment identification with the equipment data table, establishes the hierarchical relationship of the intelligent park information table, the building information table and the equipment data table, and obtains the intelligent park database. Specifically, set up the table sign of wisdom garden information table into the garden sign to and with the garden sign storage to building information table in. And setting the table identification of the building information table as a building identification, and storing the building identification into the equipment data table. The device id is a table id set as device data.
Referring to fig. 4-5, fig. 4 provides a schematic diagram of a smart park information table and fig. 5 provides a schematic diagram of a building information table. Referring to fig. 4, fields stored in the intelligent campus information table include, but are not limited to, campus identification, name, province, city, county, address, floor area, the unit, person in charge, status, remarks, creation time, creator, update time, updater, and the like. Referring to fig. 5, the fields stored in the building information table include, but are not limited to, building identification, name, campus of residence identification, campus of residence name, upper level building (building) identification, location, floor area, department/unit of residence, person in charge, status, remark, time of creation, person in creation, time of update, person in update, and the like. In this embodiment, establish the wisdom garden database that possesses the upper and lower hierarchical relation through garden sign, building sign and equipment sign, improve the efficiency of the data management of wisdom garden.
In one embodiment, the device data table includes a device information summary table and a device data sub-table, the device information summary table being used to summarize all device information in the building. Referring to fig. 6, a schematic diagram of a device information summary table is provided, where, for an example of a device, the fields stored in the device information summary table include, but are not limited to, a device identifier, a device number, a name, an installation location identifier, a gateway identifier, a category code, a category name, a corresponding sub-table, a creation time, a creator, an update time, and an updater. Wherein < pk > represents the primary key and < fk > represents the foreign key.
The device data sub-table is used for storing device data of each device, and the table identifier of the device data sub-table can be represented by a device identifier. The data table is divided into a monitoring operation type equipment data table, a statistical analysis type equipment data table and an event recording type equipment data table. The monitoring operation type device data table comprises, but is not limited to, a photovoltaic device operation information table (refer to fig. 7), a water meter monitoring table (refer to fig. 8), an electric meter monitoring table (refer to fig. 9), an entrance guard operation recording table (refer to fig. 10), a camera video recording table (refer to fig. 11), an air monitoring information table (refer to fig. 12), a temperature monitoring information table (refer to fig. 13) and a wind power device operation information table. The statistical analysis type equipment data table comprises but is not limited to a photovoltaic equipment power generation amount information statistical table (refer to fig. 14), a wind power equipment power generation amount information statistical table and a power quality monitoring terminal operation table (refer to fig. 15). The event record class device data table includes, but is not limited to, a device event record table (refer to fig. 16). In the present embodiment, when the device data table includes the device information summary table and the device data sub table, the architecture diagram of the smart campus database is shown in fig. 17.
In this embodiment, by establishing the device data table including the device information summary table, all the device information of the building can be summarized through the device information summary table, which is convenient for management of the device information.
In one embodiment, step S212 includes: acquiring a field in a data table of the device; performing statistical analysis on the equipment data according to each field to obtain the field value of each field; and filling the field value to the position of the corresponding field in the data table of the belonging device.
The statistical analysis is a process of performing statistical analysis on each piece of equipment data, and the statistical analysis mode is determined by a field configured in an equipment data table. Taking the electric meter data as an example, when the data table of the electric meter comprises fields such as peak electric quantity, valley electric quantity, average electric quantity and total electric quantity, the server obtains field values corresponding to the fields such as the peak electric quantity, the valley electric quantity, the average electric quantity and the total electric quantity by carrying out statistical analysis on the electric quantity data of the equipment data. For example, the total amount of electricity is obtained by summing.
Specifically, after the server acquires the device data table to which the device data belongs, a field configured in the device data table is acquired first. And carrying out corresponding statistical analysis on the equipment data according to the fields to obtain the field values corresponding to the fields. And then, filling the obtained field value to the position of the corresponding field in the equipment data table to complete the filling of the equipment data. In the embodiment, the device data is filled after statistical analysis is carried out on the device data through the configured field, so that the accuracy of the filled data can be ensured.
In one embodiment, the data management method of the intelligent park device is explained in detail, and includes:
step 1, acquiring the relationship among the intelligent parks, the buildings and the equipment.
And 2, generating a park identification, a building identification and an equipment identification with the belonged relationship according to the belonged relationship.
And 3, establishing an intelligent park information table, a building information table, an equipment information general table and each equipment data sub-table according to the acquired intelligent park basic information, the building basic information and the equipment basic information of each equipment.
And 4, setting the park identification as the table identification of the intelligent park information table, and storing the park identification as the park field to which the park identification belongs in the building information table. And setting the building identification as the mark of the building information table, and storing the building identification as the installation position identification into the equipment information summary table. And setting the equipment identification as the equipment identification of each equipment in the equipment information general table and as the table identification of each equipment data sub-table. Thereby constituting an intelligent campus database architecture as shown in fig. 18.
And 5, after the equipment data of each equipment in the intelligent park are acquired, the park identification and the building identification are obtained by splitting the equipment identification of the equipment corresponding to the equipment data. Inquiring an affiliated smart park information table of the equipment data from an affiliated smart park information table of a constructed smart park database according to the park identification, and inquiring an affiliated building information table of the equipment data from an affiliated building information table of the affiliated smart park information table according to the building identification; and inquiring an affiliated device data table of the device data from an affiliated device data table of the affiliated building information table according to the device identification, and further filling the device data into the affiliated device data table.
Step 6, after receiving the building identification of the migrated building and receiving a park identification data migration instruction of the smart park of the migrated building, inquiring a building information table of the migrated building and an attached equipment data table of the building information table of the migrated building from the constructed smart park database according to the building identification of the migrated building; updating the park identification and the park identification field of the building identification of the building information table of the building to be migrated into the park identification of the smart park of the building to be migrated, and completing the migration of the building information; and meanwhile, updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the smart park of the moved building, and completing the migration of the equipment data.
It should be understood that although the various steps in the flow charts of fig. 2-3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-3 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least some of the other steps.
In one embodiment, as shown in fig. 18, there is provided a data management apparatus of an intelligent campus, including: an acquisition module 1802, a splitting module 1804, a campus querying module 1806, a building querying module 1808, a device querying module 1810, and a population module 1812, wherein:
an obtaining module 1802 is configured to obtain device data of each device in the smart park.
The splitting module 1804 is configured to split the device identifier of the device corresponding to the device data, so as to obtain the campus identifier and the building identifier.
And a park query module 1806, configured to query the smart park information table to which the device data belongs from the attached smart park information table of the smart park database constructed according to the park identifier.
And a building query module 1808, configured to query the affiliated building information table of the device data from the affiliated building information table of the intelligent park information table according to the building identifier.
And the device query module 1810 is configured to query the affiliated device data table of the device data from the affiliated device data table of the affiliated building information table according to the device identifier.
A padding module 1812, configured to pad the device data into the device data table.
In one embodiment, the data management device of the smart park further comprises a migration module for receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a building to be migrated and a park identifier of the smart park of the building to be migrated; according to the building identification of the migrated building, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from the constructed intelligent park database; updating the park identification and the park identification field of the building identification of the building information table of the building to be migrated into the park identification of the smart park of the building to be migrated, and completing the migration of the building information; and updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the intelligent park of the moved building, and finishing the migration of the equipment data.
In one embodiment, the data management device of the smart campus further comprises a building module for generating a campus identifier of each smart campus; generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise park identifications; generating equipment identification of accessory equipment of the building according to the building identification, wherein the equipment identification comprises the building identification; based on the park identification, the building identification and the equipment identification, a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment are constructed, and a smart park database is obtained.
In one embodiment, the building module is further used for acquiring basic information of the smart park, basic information of the building and basic information of equipment of each device; respectively establishing an intelligent park information table, a building information table and an equipment data table of each equipment according to the basic information of the intelligent park, the basic information of the building and the basic information of the equipment; associating the park identification with the intelligent park information table and the building information table, associating the building identification with the building information table and the equipment data table, and associating the equipment identification with the equipment data table, establishing a hierarchical relationship among the intelligent park information table, the building information table and the equipment data table, and obtaining an intelligent park database
In one embodiment, the building module is further configured to set the table identifier of the smart campus information table as a campus identifier, and store the campus identifier in the building information table; and setting the table identification of the building information table as a building identification, and storing the building identification into the equipment data table.
In one embodiment, the padding module 1812 is further configured to obtain a field in the device data table; performing statistical analysis on the equipment data according to each field to obtain the field value of each field; and filling the field value to the position of the corresponding field in the data table of the belonging device.
For the specific limitation of the data management device of the intelligent campus, reference may be made to the above limitation of the data management method of the intelligent campus, which is not described herein again. The modules in the data management device of the intelligent park can be completely or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 19. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing an intelligent park information table, a building information table, an equipment data table and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data management method for an intelligent campus.
Those skilled in the art will appreciate that the architecture shown in fig. 19 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program:
acquiring equipment data of each piece of equipment in the intelligent park;
splitting the equipment identification of the equipment corresponding to the equipment data to obtain a park identification and a building identification;
inquiring an affiliated intelligent park information table of the equipment data from an affiliated intelligent park information table of the constructed intelligent park database according to the park identification;
inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
inquiring an affiliated equipment data table of the equipment data from an affiliated equipment data table of the affiliated building information table according to the equipment identification;
and filling the device data into the device data table.
In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a migrated building and a park identifier of a smart park of the migrated building; according to the building identification of the migrated building, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from the constructed intelligent park database; updating the park identification and the park identification field of the building identification of the building information table of the building to be migrated into the park identification of the smart park of the building to be migrated, and completing the migration of the building information; and updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the intelligent park of the moved building, and finishing the migration of the equipment data.
In one embodiment, the processor, when executing the computer program, further performs the steps of: generating park identifications of the intelligent parks; generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise park identifications; generating equipment identification of accessory equipment of the building according to the building identification, wherein the equipment identification comprises the building identification; based on the park identification, the building identification and the equipment identification, a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment are constructed, and a smart park database is obtained.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring basic information of the intelligent park, basic information of the building and basic information of equipment of each device; respectively establishing an intelligent park information table, a building information table and an equipment data table of each equipment according to the basic information of the intelligent park, the basic information of the building and the basic information of the equipment; associating the park identification with the intelligent park information table and the building information table, associating the building identification with the building information table and the equipment data table, and associating the equipment identification with the equipment data table, establishing a hierarchical relationship among the intelligent park information table, the building information table and the equipment data table, and obtaining an intelligent park database
In one embodiment, the processor, when executing the computer program, further performs the steps of: setting a meter identifier of the intelligent park information table as a park identifier, and storing the park identifier into the building information table; and setting the table identification of the building information table as a building identification, and storing the building identification into the equipment data table.
In one embodiment, the processor, when executing the computer program, further performs the steps of: acquiring a field in a data table of the device; performing statistical analysis on the equipment data according to each field to obtain the field value of each field; and filling the field value to the position of the corresponding field in the data table of the belonging device.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring equipment data of each piece of equipment in the intelligent park;
splitting the equipment identification of the equipment corresponding to the equipment data to obtain a park identification and a building identification;
inquiring an affiliated intelligent park information table of the equipment data from an affiliated intelligent park information table of the constructed intelligent park database according to the park identification;
inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
inquiring an affiliated equipment data table of the equipment data from an affiliated equipment data table of the affiliated building information table according to the equipment identification;
and filling the device data into the device data table.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a migrated building and a park identifier of a smart park of the migrated building; according to the building identification of the migrated building, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from the constructed intelligent park database; updating the park identification and the park identification field of the building identification of the building information table of the building to be migrated into the park identification of the smart park of the building to be migrated, and completing the migration of the building information; and updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the intelligent park of the moved building, and finishing the migration of the equipment data.
In one embodiment, the computer program when executed by the processor further performs the steps of: generating park identifications of the intelligent parks; generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise park identifications; generating equipment identification of accessory equipment of the building according to the building identification, wherein the equipment identification comprises the building identification; based on the park identification, the building identification and the equipment identification, a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment are constructed, and a smart park database is obtained.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring basic information of the intelligent park, basic information of the building and basic information of equipment of each device; respectively establishing an intelligent park information table, a building information table and an equipment data table of each equipment according to the basic information of the intelligent park, the basic information of the building and the basic information of the equipment; and associating the park identification with the intelligent park information table and the building information table, associating the building identification with the building information table and the equipment data table, and associating the equipment identification with the equipment data table, and establishing a hierarchical relationship among the intelligent park information table, the building information table and the equipment data table to obtain the intelligent park database.
In one embodiment, the computer program when executed by the processor further performs the steps of: setting a meter identifier of the intelligent park information table as a park identifier, and storing the park identifier into the building information table; and setting the table identification of the building information table as a building identification, and storing the building identification into the equipment data table.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a field in a data table of the device; performing statistical analysis on the equipment data according to each field to obtain the field value of each field; and filling the field value to the position of the corresponding field in the data table of the belonging device.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for managing data in an intelligent campus, the method comprising:
acquiring equipment data of each piece of equipment in the intelligent park;
splitting the equipment identification of the equipment corresponding to the equipment data to obtain a park identification and a building identification;
inquiring an affiliated intelligent park information table of the equipment data from an affiliated intelligent park information table of a constructed intelligent park database according to the park identification;
inquiring the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
inquiring an affiliated device data table of the device data from an affiliated device data table of the affiliated building information table according to the device identification;
and filling the equipment data into the affiliated equipment data table.
2. The method of claim 1, further comprising:
receiving a data migration instruction, wherein the data migration instruction comprises a building identifier of a migrated building and a park identifier of a smart park of the migrated building;
according to the building identification of the migrated building, inquiring a building information table of the migrated building and an auxiliary equipment data table of the building information table of the migrated building from a constructed intelligent park database;
updating the park identification and the affiliated park identification field in the building identification of the building information table of the migrated building into the park identification of the smart park of the building to be migrated, and completing the migration of the building information;
and updating the park identification and the installation position identification field in the equipment identification of the auxiliary equipment data table of the building information table of the moved building into the park identification of the smart park of the building to be moved, and finishing the movement of the equipment data.
3. The method of claim 1, wherein said step of obtaining equipment data for each equipment on the smart campus further comprises the step of building a database of the smart campus comprising:
generating park identifications of the intelligent parks;
generating building identifications of affiliated buildings of the intelligent park according to the park identifications, wherein the building identifications comprise the park identifications;
generating a device identification of an accessory device of the building according to the building identification, wherein the device identification comprises the building identification;
and constructing a smart park information table of each smart park, a building information table of each building and an equipment data table of each equipment based on the park identification, the building identification and the equipment identification to obtain a smart park database.
4. The method of claim 3, wherein constructing a smart campus information table for each of the smart parks, a building information table for each of the buildings, and a device data table for each of the devices based on the campus identification, the building identification, and the device identification, resulting in a smart campus database, comprises:
acquiring basic information of an intelligent park, basic information of a building and basic information of equipment of each device;
respectively establishing an intelligent park information table, a building information table and an equipment data table of each equipment according to the intelligent park basic information, the building basic information and the equipment basic information;
and associating the park identification with the intelligent park information table and the building information table, associating the building identification with the building information table and the equipment data table, and associating the equipment identification with the equipment data table, and establishing the hierarchical relationship of the intelligent park information table, the building information table and the equipment data table to obtain an intelligent park database.
5. The method of claim 4, wherein associating the campus identification with the smart campus information table and the building information table comprises:
setting the meter identification of the intelligent park information table as the park identification, and storing the park identification into the building information table;
the building identification is associated with the building information table and the device data table, including:
and setting the table identification of the building information table as the building identification, and storing the building identification into the equipment data table.
6. The method according to claim 3 or 4, wherein the device data table comprises a device information general table and a device data sub-table;
the device sub-data table comprises a monitoring operation device data table, a statistical analysis device data table and an event record device data table.
7. The method of claim 1, wherein the populating the device data into the device data table includes:
acquiring fields in the data table of the equipment;
performing statistical analysis on the equipment data according to the fields to obtain the field values of the fields;
and filling the field value to the position of the corresponding field in the data table of the belonging device.
8. A data management apparatus of a comedy area, the apparatus comprising:
the acquisition module is used for acquiring equipment data of each piece of equipment in the intelligent park;
the splitting module is used for splitting the equipment identifier of the equipment corresponding to the equipment data to obtain a park identifier and a building identifier;
the park query module is used for querying an intelligent park information table to which the equipment data belongs from an auxiliary intelligent park information table of the constructed intelligent park database according to the park identification;
the building query module is used for querying the affiliated building information table of the equipment data from the affiliated building information table of the affiliated intelligent park information table according to the building identification;
the equipment inquiry module is used for inquiring an affiliated equipment data table of the equipment data from an affiliated equipment data table of the affiliated building information table according to the equipment identification;
and the filling module is used for filling the equipment data into the equipment data table.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010405548.XA CN111581187B (en) | 2020-05-14 | 2020-05-14 | Data management method, device, computer equipment and storage medium for intelligent park |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010405548.XA CN111581187B (en) | 2020-05-14 | 2020-05-14 | Data management method, device, computer equipment and storage medium for intelligent park |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111581187A true CN111581187A (en) | 2020-08-25 |
| CN111581187B CN111581187B (en) | 2023-06-30 |
Family
ID=72122951
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010405548.XA Active CN111581187B (en) | 2020-05-14 | 2020-05-14 | Data management method, device, computer equipment and storage medium for intelligent park |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111581187B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112597346A (en) * | 2020-12-14 | 2021-04-02 | 南京祥合利信息技术服务有限公司 | Intelligent park management method |
| CN117539869A (en) * | 2024-01-08 | 2024-02-09 | 北京睿企信息科技有限公司 | Data processing system for acquiring data table |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770479A (en) * | 2008-12-31 | 2010-07-07 | 北京亿阳信通软件研究院有限公司 | Association relationship query method and device |
| CN103049809A (en) * | 2012-08-23 | 2013-04-17 | 国电大渡河瀑布沟发电有限公司 | Equipment coding method |
| CN105677732A (en) * | 2015-12-28 | 2016-06-15 | 国云科技股份有限公司 | Method for designing JavaBean major key with service attribute identifier |
| CN108228611A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | Document information copies method and apparatus |
| JP2018180942A (en) * | 2017-04-13 | 2018-11-15 | 富士通株式会社 | Distributed data management program, distributed data management method, and distributed data management apparatus |
| CN108846574A (en) * | 2018-06-12 | 2018-11-20 | 广州广电研究院有限公司 | A kind of the wisdom garden management system and method for three-dimensional visualization |
| CN108876182A (en) * | 2018-07-02 | 2018-11-23 | 泛亚汽车技术中心有限公司 | Wisdom garden system and working method based on thermodynamic chart |
| CN110287192A (en) * | 2019-06-26 | 2019-09-27 | 浙江大搜车软件技术有限公司 | Search for application data processing method, device, computer equipment and storage medium |
| WO2019208630A1 (en) * | 2018-04-27 | 2019-10-31 | Yokogawa Electric Corporation | Management device, management method, and program |
| CN110647550A (en) * | 2019-10-08 | 2020-01-03 | 华润智慧能源有限公司 | Integrated energy system management method, device, equipment and storage medium |
-
2020
- 2020-05-14 CN CN202010405548.XA patent/CN111581187B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770479A (en) * | 2008-12-31 | 2010-07-07 | 北京亿阳信通软件研究院有限公司 | Association relationship query method and device |
| CN103049809A (en) * | 2012-08-23 | 2013-04-17 | 国电大渡河瀑布沟发电有限公司 | Equipment coding method |
| CN105677732A (en) * | 2015-12-28 | 2016-06-15 | 国云科技股份有限公司 | Method for designing JavaBean major key with service attribute identifier |
| CN108228611A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | Document information copies method and apparatus |
| JP2018180942A (en) * | 2017-04-13 | 2018-11-15 | 富士通株式会社 | Distributed data management program, distributed data management method, and distributed data management apparatus |
| WO2019208630A1 (en) * | 2018-04-27 | 2019-10-31 | Yokogawa Electric Corporation | Management device, management method, and program |
| CN108846574A (en) * | 2018-06-12 | 2018-11-20 | 广州广电研究院有限公司 | A kind of the wisdom garden management system and method for three-dimensional visualization |
| CN108876182A (en) * | 2018-07-02 | 2018-11-23 | 泛亚汽车技术中心有限公司 | Wisdom garden system and working method based on thermodynamic chart |
| CN110287192A (en) * | 2019-06-26 | 2019-09-27 | 浙江大搜车软件技术有限公司 | Search for application data processing method, device, computer equipment and storage medium |
| CN110647550A (en) * | 2019-10-08 | 2020-01-03 | 华润智慧能源有限公司 | Integrated energy system management method, device, equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 史立等: "园区管网信息管理与监控系统研究", 《计算机工程》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112597346A (en) * | 2020-12-14 | 2021-04-02 | 南京祥合利信息技术服务有限公司 | Intelligent park management method |
| CN117539869A (en) * | 2024-01-08 | 2024-02-09 | 北京睿企信息科技有限公司 | Data processing system for acquiring data table |
| CN117539869B (en) * | 2024-01-08 | 2024-03-15 | 北京睿企信息科技有限公司 | Data processing system for acquiring data table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111581187B (en) | 2023-06-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108427684B (en) | Data query method and device and computing equipment | |
| CN110168529B (en) | Data storage method, device and storage medium | |
| CN109145047B (en) | User tag portrait configuration method, data processing device and storage medium | |
| CN116680648B (en) | Service fusion data generation method and system for digital twin city | |
| CN111581187B (en) | Data management method, device, computer equipment and storage medium for intelligent park | |
| CN110958109B (en) | Light dynamic data integrity auditing method based on hierarchical merck hash tree | |
| CN113723810A (en) | Graph database-based power grid modeling method | |
| CN102158533B (en) | Distributed web service selection method based on QoS (Quality of Service) | |
| CN111597272A (en) | Method and device for storing engineering cost data, data server and storage medium | |
| CN110807547A (en) | Method and system for predicting family population structure | |
| CN113285960B (en) | Data encryption method and system for service data sharing cloud platform | |
| CN110399534B (en) | Terminal performance report generation method, device, equipment and storage medium | |
| CN109840250B (en) | Method, device, equipment and storage medium for managing access authority of intermediate field | |
| CN111898276A (en) | Overhead line model processing method and device, computer equipment and medium | |
| CN112541834B (en) | Identifier processing method, device and system for hydropower industry digital object | |
| CN115495452A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN114860806A (en) | Data query method and device of block chain, computer equipment and storage medium | |
| CN110134728B (en) | Method and system for providing map space data based on full text search | |
| CN111966691B (en) | Configuration method and system for rapidly querying directory to which object belongs in distributed storage system | |
| CN112905128B (en) | Access control user data management method and device, storage medium and electronic equipment | |
| CN111949682B (en) | Compensation protocol generation method, device, computer equipment and storage medium | |
| CN110019413A (en) | Magnanimity internet of things data digging system based on correlation rule | |
| CN118132813A (en) | Address searching method and device for full geographic element, computer equipment and medium | |
| CN112417283A (en) | Unit energy efficiency query method and device, computer equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |