CN117009357A - Internet of things data management method, device, system and medium for smart city - Google Patents
Internet of things data management method, device, system and medium for smart city Download PDFInfo
- Publication number
- CN117009357A CN117009357A CN202311044085.9A CN202311044085A CN117009357A CN 117009357 A CN117009357 A CN 117009357A CN 202311044085 A CN202311044085 A CN 202311044085A CN 117009357 A CN117009357 A CN 117009357A
- Authority
- CN
- China
- Prior art keywords
- data
- internet
- things
- sensing
- platform
- 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
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000013523 data management Methods 0.000 title claims abstract description 24
- 230000008447 perception Effects 0.000 claims abstract description 54
- 238000013461 design Methods 0.000 claims abstract description 34
- 238000013075 data extraction Methods 0.000 claims abstract description 19
- 238000010276 construction Methods 0.000 claims description 22
- 238000003032 molecular docking Methods 0.000 claims description 18
- 238000003860 storage Methods 0.000 claims description 12
- 238000012545 processing Methods 0.000 claims description 10
- 230000005540 biological transmission Effects 0.000 claims description 8
- 230000010354 integration Effects 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 7
- 238000004140 cleaning Methods 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 5
- 210000001503 joint Anatomy 0.000 claims description 4
- 230000004044 response Effects 0.000 claims description 4
- 230000000699 topical effect Effects 0.000 claims description 3
- 238000007726 management method Methods 0.000 abstract description 6
- 238000005516 engineering process Methods 0.000 description 7
- 238000011161 development Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000006872 improvement Effects 0.000 description 3
- 238000009434 installation Methods 0.000 description 3
- 238000011835 investigation Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction 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
- 230000006855 networking Effects 0.000 description 1
- 210000002569 neuron Anatomy 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000031068 symbiosis, encompassing mutualism through parasitism Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16Y—INFORMATION AND COMMUNICATION TECHNOLOGY SPECIALLY ADAPTED FOR THE INTERNET OF THINGS [IoT]
- G16Y10/00—Economic sectors
- G16Y10/75—Information technology; Communication
Abstract
The application relates to a method, a device, a system and a medium for managing data of the Internet of things in a smart city, wherein the method comprises the following steps: constructing a data scheme according to preset data requirements; based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform; generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform; and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database. The method and the system meet the requirements of the smart city under the twinning hierarchy in the data management of the Internet of things, and improve the management efficiency of the data of the Internet of things.
Description
Technical Field
The application relates to the technical field of Internet of things, in particular to an Internet of things data management method, device, system and medium for a smart city.
Background
With the development of novel technology such as 5G, the Internet of things, big data, AI, CI M and the like, smart city business gradually changes from digital transformation to urban virtual-real symbiosis supported by a global Internet of things sensing platform, and data management is carried out on massive Internet of things data and the intrinsic value of the data is mined, so that the data management becomes an important ring for smart city construction. The current combination among novel technologies such as the Internet of things, big data, AI, CI M and the like is always cut, and each forms a system instead of organic fusion, so that the data management of the Internet of things in the smart city needs to be processed and constructed in a plurality of systems. Therefore, a complete data management method and system are required to be established to integrate the novel technology and technology, and the greatest advantages of the novel technology and the novel technology are brought into play to serve the Internet of things of the smart city.
The current smart city field has been developed from automation to digitization to digital twinning, and the internet of things is used as a sensing neuron of the smart city to provide massive sensing data at any time. At present, most of intelligent city Internet of things data management still stays in the technical means of traditional object models, application acquisition and the like, and analysis of digital signals to structured data is completed through a data format building object model uploaded by standard equipment and stored by using a big data technology. However, the current internet of things data governance cannot meet the requirements of the smart city under the digital twinning level, how to practically form data assets which are attached to government business lines, and realizing digital twinning becomes an important problem faced by the current internet of things data governance of the smart city. Therefore, there is a need for a method for managing data of the internet of things in a smart city, so as to meet the requirement that the data of the internet of things is managed in the smart city under the twinning level, and improve the management efficiency of the data of the internet of things.
Disclosure of Invention
The embodiment of the application aims to provide an Internet of things data governance method, device, system and medium for a smart city, so that the requirement of the smart city under a twinning level for Internet of things data governance is met, and the governance efficiency of the Internet of things data is improved.
In order to solve the above technical problems, an embodiment of the present application provides a method for managing data of internet of things in a smart city, including:
constructing a data scheme according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data standard and a sensing database table design scheme;
based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform;
generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform;
and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database.
In order to solve the above technical problems, an embodiment of the present application provides an internet of things data management system for a smart city, including:
the data scheme construction unit is used for constructing a data scheme according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data specification standard and a sensing database table design scheme;
the data extraction unit is used for extracting data from the stock internet of things sensing application and the internet of things sensing platform based on the data scheme to obtain sensing data, and accessing the sensing data into the internet of things big data platform;
the target question library generation unit is used for generating a target question library based on the database table corresponding to the perception database table design scheme through the big data platform of the Internet of things;
and the model construction unit is used for constructing a digital twin biological model from the target question library, the city information model platform and the perception data and storing the digital twin biological model in an object model database.
In order to solve the technical problems, the application adopts a technical scheme that: a computer device is provided comprising one or more processors; and the memory is used for storing one or more programs, so that the one or more processors can realize the data management method of the Internet of things of the smart city.
In order to solve the technical problems, the application adopts a technical scheme that: a computer readable storage medium having stored thereon a computer program which when executed by a processor implements the internet of things data governance method of any one of the above-described smart cities.
The embodiment of the application provides a method, a device, a system and a medium for managing data of the Internet of things in a smart city. The method comprises the following steps: constructing a data scheme according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data standard and a sensing database table design scheme; based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform; generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform; and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database. According to the embodiment of the application, the data scheme is constructed, and the data extraction and the construction target improvement are performed based on the data scheme, so that a digital twin biological model is constructed according to the target question bank, the urban information model platform and the perception data, the requirements of the intelligent city under the twin hierarchy for the data management of the Internet of things are met, and the management efficiency of the data of the Internet of things is improved.
Drawings
In order to more clearly illustrate the solution of the present application, a brief description will be given below of the drawings required for the description of the embodiments of the present application, it being apparent that the drawings in the following description are some embodiments of the present application, and that other drawings may be obtained from these drawings without the exercise of inventive effort for a person of ordinary skill in the art.
Fig. 1 is a flowchart of an implementation of a flow of a data management method of internet of things in a smart city according to an embodiment of the present application;
fig. 2 is a flowchart of implementation of a sub-flow in the data management method of the internet of things in a smart city according to an embodiment of the present application;
FIG. 3 is a flowchart of an implementation of a sub-flow in the method for data governance of the Internet of things in a smart city according to an embodiment of the present application;
fig. 4 is a flowchart of implementation of a sub-flow in the data management method of the internet of things in the smart city according to the embodiment of the present application;
fig. 5 is a flowchart of implementation of a sub-flow in the data management method of the internet of things in the smart city according to the embodiment of the present application;
FIG. 6 is a schematic diagram of an Internet of things data management system for a smart city according to an embodiment of the present application;
fig. 7 is a schematic diagram of a computer device according to an embodiment of the present application.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used in the description of the applications herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description of the application and the claims and the description of the drawings above are intended to cover a non-exclusive inclusion. The terms first, second and the like in the description and in the claims or in the above-described figures, are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.
In order to make the person skilled in the art better understand the solution of the present application, the technical solution of the embodiment of the present application will be clearly and completely described below with reference to the accompanying drawings.
The present application will be described in detail with reference to the drawings and embodiments.
It should be noted that, the method for managing data of the internet of things in the smart city provided by the embodiment of the application is generally executed by a server, and correspondingly, the system for managing data of the internet of things in the smart city is generally configured in the server.
Referring to fig. 1, fig. 1 illustrates a specific embodiment of a method for managing data of internet of things in a smart city.
It should be noted that, if there are substantially the same results, the method of the present application is not limited to the flow sequence shown in fig. 1, and the method includes the following steps:
s1: and constructing a data scheme according to preset data requirements, wherein the data scheme comprises a perception data access scheme, a perception data specification standard and a perception database table design scheme.
In the embodiment of the application, before the sensing data is acquired, data investigation is needed in advance, namely, a data scheme is constructed according to the preset data requirement. The data scheme comprises a perception data access scheme, a perception data specification standard and a perception database table design scheme.
Referring to fig. 2, fig. 2 shows a specific embodiment of step S1, which is described in detail as follows:
s11: and constructing the perception data access scheme according to a preset data docking mode and a data transmission period.
S12: and constructing the perception data specification standard according to the preset data field and the data type.
S13: and constructing the design scheme of the perception database table based on the perception data specification standard.
In the embodiment of the application, the perceived data access scheme is that after technical evaluation is carried out by research and development teams of a platform and a third party application, what data docking mode and data transmission period are adopted to realize data docking is determined. The sensing data standard is to learn and prescribe the field and the data type of the sensing data of the subsequent access platform after the sensing data of the application are checked. The design scheme of the perception database table is based on the standard of data specification, researches the business of the client, screens out the data focused by the client and verifies the data, thereby forming the design principle of the subject database and the thematic database.
Specifically, the perceived data access scheme is constructed according to a preset data docking mode and a data transmission period; constructing the perception data standard according to preset data fields and data types; and constructing the design scheme of the perception database table based on the perception data specification standard. The preset data requirements comprise a preset data docking mode and a preset data transmission period, and preset data fields and data types. It should be noted that, the preset data docking mode and the data transmission period, and the preset data field and the data type are set according to the actual situation, which is not limited herein.
Referring to fig. 3, fig. 3 shows a specific embodiment of step S13, which is described in detail as follows:
s131: and collecting data sources from an interface layer of the database according to the perception data specification standard, and carrying out data cleaning and data standardization processing on the data sources through an integration layer to obtain processed data.
S132: and constructing a data summarization model corresponding to the business data in the middle layer of the database, constructing an enterprise external data source in the summarization layer of the database, and constructing the perception database table design scheme based on the data summarization model and the enterprise external data source.
In the embodiment of the application, according to the perception data standard, a data source is acquired from an interface layer of the database, and the acquired data source is stored; and then carrying out data cleaning and data standardization processing on the data source through an integration layer to obtain processed data, and reserving original data of a system, wherein the original data is not processed by any service caliber, and the original data is subjected to long-period storage of full data. And then constructing a data summarization model corresponding to the business data in the middle layer of the database, wherein the data summarization model comprises a basic integration wide table, basic indexes/labels and a light-granularity summarization model. And finally, an enterprise external data source is built on a summarization layer of the database, wherein the enterprise external data source comprises an index set, a label set and an application wide table.
In a specific embodiment, the data setting needs to be performed at the summary layer, the middle layer, the integration layer and the interface layer of the database. The interface layer is mainly used for storing data sources directly collected from various systems, the interface layer data model is basically consistent with the source system, the data is not processed, and short-period storage is needed. The middle layer is mainly developed around the enterprise core business process, focuses on core business events and business entities in the business process, realizes intra-domain basic association, and forms a basic integration broad table, basic indexes/labels and a light-granularity summarization model. The summarization layer mainly forms enterprise statistics, marketing and summarization data according to management and client views, builds an application-oriented intelligent information system as a main source of the capability of providing data services from outside the enterprise data center, and is divided into an index set, a label set and an application wide table, and the data is permanently stored. The integration layer is mainly used for carrying out processing operations such as data cleaning, model and attribute value standardization and the like on the interface layer, retaining the original data of the system, and not carrying out processing treatment of any service caliber, and needs to store the full data for a long period.
S2: and carrying out data extraction from the stock Internet of things sensing application and the Internet of things sensing platform based on the data scheme to obtain sensing data, and accessing the sensing data into the Internet of things big data platform.
Referring to fig. 4, fig. 4 shows a specific embodiment of step S2, which is described in detail as follows:
s21: and extracting data from the stock internet of things sensing application and the internet of things sensing platform according to the sensing data access scheme and the sensing data specification standard to obtain sensing data.
S22: and the stock internet of things sensing application and the internet of things sensing platform are adopted to carry out cloud butt joint, and the sensing data are accessed into the internet of things big data platform. The cloud docking mode comprises library table synchronization, API interface docking, file synchronization and message synchronization.
Specifically, with the development of smart cities, a lot of internet of things applications are developed in different industries and different lines, and as the internet of things applications are independent and business self-closed systems, the cost of changing the connection base of the internet of things equipment at the bottom of the stock application is huge for the application itself, so that for the stock internet of things sensing application, a cloud-cloud docking mode of a platform and the application is generally adopted, including modes of library table synchronization, API interface docking, file synchronization, message synchronization and the like, to realize a sensing data access platform. Therefore, in the embodiment of the application, data extraction is carried out from the stock internet of things sensing application and the internet of things sensing platform according to the sensing data access scheme and the sensing data specification standard to obtain sensing data; and the method comprises the step of accessing the sensing data into the big data platform of the Internet of things by adopting a cloud butt joint mode of the stock Internet of things sensing application and the Internet of things sensing platform. The cloud-cloud docking mode comprises library table synchronization, API interface docking, file synchronization and message synchronization.
S3: and generating a target question library by the big data platform of the Internet of things based on the database table corresponding to the perception database table design scheme. The target question bank comprises a question bank and a question bank, wherein the question bank and the question bank comprise equipment file information, equipment attribution information, equipment business information and equipment topical information.
Specifically, through the steps, the data top layer design of the perception platform of the internet of things of the smart city and the acquisition of the perception data are completed, and in the application embodiment, the target question bank is generated through the large data platform of the internet of things based on the database table corresponding to the perception database table design scheme. The target question bank comprises a question bank and a question bank, wherein the question bank and the question bank comprise equipment file information, equipment attribution information, equipment business information and equipment topical information.
The equipment file information mainly refers to terminal attribute, geographic position, production installation information and the like of equipment, and mainly comprises the following components: device number, device model, device type, device name, installation address, latitude and longitude type, networking type, communication protocol, vendor, installation time, etc. The equipment attribution information mainly refers to the ownership information of equipment, and mainly comprises the following steps: the city, the area, the street, the commission, the equipment responsible person, the responsible person contact way and the like. The device service information mainly refers to service data and heartbeat information uploaded by the device, and is different from each other according to the device type, taking an intelligent dustbin as an example, and mainly comprises: garbage pile height (cm), garbage percentage (%), height in barrel (cm), temperature (deg.C), electric quantity (%), battery voltage (%), state (0-normal, 1-alarm, 2-heartbeat), transmission time, etc. The equipment thematic information is a regional library and an industry library designed according to the customer business and data research process so as to meet the customization requirement of customers and form specific data assets.
S4: and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database.
Referring to fig. 5, fig. 5 shows a specific embodiment of step S3, which is described in detail as follows:
s41: and synchronizing the equipment archive information in the target question bank to the city information model platform through the Internet of things big data platform, so that the Internet of things big data platform performs model construction to obtain a digital twin biological model. The model construction comprises equipment dotting, equipment model positioning and equipment model establishment.
S42: storing data storage path information of the response in the perception data to store the digital twin biological model in the object model database.
In particular, a large number of three-dimensional models of urban building and equipment and data interfaces for configuring the models are fabricated and stored in a city information model platform (CIM). In the embodiment of the application, the equipment file information is synchronized into the CIM platform through the big data platform, so that the equipment file information is matched with the CIM platform to finish equipment dotting, equipment model positioning, equipment model establishment and the like; simultaneously storing the data storage path information of the response; and finally combining the data storage path information with the equipment archive information to finally form a digital twin biological model to be stored in an object model database, so that the archiving of the equipment data asset and the CIM model is completed.
Further, since the object model database already stores digital twin object models of all devices, the digital twin object models comprise file information, attribution information, service information, thematic information and storage information of a three-dimensional model of the devices. The digital twin biological model can conveniently and rapidly support the data of the visual large screen, the Internet of things SaaS application and the third party system direct calling equipment and the CIM model to complete corresponding development work, the development efficiency is improved, the development time is greatly reduced, and the full-flow construction and the communication of the intelligent city Internet of things data management are completed from the technical level.
In the implementation of the application, a data scheme is constructed according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data standard and a sensing database table design scheme; based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform; generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform; and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database. According to the embodiment of the application, the data scheme is constructed, and the data extraction and the construction target improvement are performed based on the data scheme, so that a digital twin biological model is constructed according to the target question bank, the urban information model platform and the perception data, the requirements of the intelligent city under the twin hierarchy for the data management of the Internet of things are met, and the management efficiency of the data of the Internet of things is improved.
Further, the embodiment of the application solves the problem of how to unify access the data of the stock of the Internet of things application and the direct-connected equipment in the smart city project for a long time, provides a set of methodology for firstly forming the data access specification and then confirming the data access mode through data investigation, and complements the unification of the data access of the stock application oriented data access and the direct-connected equipment. The embodiment of the application provides a methodology of combining the device model information of the CI M platform in addition to considering four dimensions of device files, device attribution, device business and device thematic when the device object model is built, truly realizes digital twin of the smart city Internet of things project, and comprehensively builds the digital twin object model to accelerate the development and construction of Internet of things application after the Internet of things platform is deployed and landed. The embodiment of the application provides a complete data treatment flow and thought in the data treatment for the smart city scene, which can be used for guiding the formation of a perception subject database and a subject database in the data treatment process and rapidly forming data assets to realize data value.
Referring to fig. 6, as an implementation of the method shown in fig. 1, the present application provides an embodiment of an internet of things data management system for a smart city, where the embodiment of the apparatus corresponds to the embodiment of the method shown in fig. 1, and the apparatus may be specifically applied to various electronic devices.
As shown in fig. 6, the internet of things data management system of the smart city of the embodiment includes: a data scheme constructing unit 51, a data extracting unit 52, a target question bank generating unit 53, and a model constructing unit 54, wherein:
a data scheme construction unit 51, configured to construct a data scheme according to a preset data requirement, where the data scheme includes a perceived data access scheme, a perceived data specification standard, and a perceived database table design scheme;
the data extraction unit 52 is configured to perform data extraction from the stock internet of things sensing application and the internet of things sensing platform based on the data scheme, obtain sensing data, and access the sensing data to the internet of things big data platform;
a target question library generating unit 53, configured to generate a target question library by using the internet of things big data platform based on a database table corresponding to the perceived database table design scheme;
a model construction unit 54 for constructing a digital twin biological model from the target question library, the city information model platform and the perception data, and storing the digital twin biological model in an object model database.
Further, the data scheme construction unit 51 includes:
the sensing data access scheme construction unit is used for constructing the sensing data access scheme according to a preset data docking mode and a data transmission period;
the sensing data standard construction unit is used for constructing the sensing data standard according to preset data fields and data types;
and the perception database table design scheme construction unit is used for constructing the perception database table design scheme based on the perception data specification standard.
Further, the perceptual database table design scheme construction unit includes:
the data processing unit is used for collecting data sources from an interface layer of the database according to the perception data specification standard, and carrying out data cleaning and data standardization processing on the data sources through an integration layer to obtain processed data;
the data summarization model construction unit is used for constructing a data summarization model corresponding to the business data in the middle layer of the database, constructing an enterprise external data source in the summarization layer of the database, and constructing the perception database table design scheme based on the data summarization model and the enterprise external data source.
Further, the data extraction unit 52 includes:
the sensing data extraction unit is used for extracting data from the stock internet of things sensing application and the internet of things sensing platform according to the sensing data access scheme and the sensing data specification standard to obtain sensing data;
and the sensing data access unit is used for accessing the sensing data into the big data platform of the Internet of things by adopting the mode of cloud butt joint between the stock Internet of things sensing application and the Internet of things sensing platform.
Further, the cloud docking mode comprises library table synchronization, API interface docking, file synchronization and message synchronization.
Further, the target question bank comprises a question bank and a question bank, wherein the question bank and the question bank comprise equipment file information, equipment attribution information, equipment business information and equipment topic information.
Further, the model building unit 54 includes:
the digital twin biological model building unit is used for synchronizing the equipment archive information in the target question bank into the urban information model platform through the Internet of things big data platform so as to enable the Internet of things big data platform to perform model building to obtain a digital twin biological model, wherein the model building comprises equipment dotting, equipment model positioning and equipment model building;
and the digital twin biological model storage unit is used for storing the data storage path information of the response in the perception data so as to store the digital twin biological model in the biological model database.
In the implementation of the application, a data scheme is constructed according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data standard and a sensing database table design scheme; based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform; generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform; and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database. According to the embodiment of the application, the data scheme is constructed, and the data extraction and the construction target improvement are performed based on the data scheme, so that a digital twin biological model is constructed according to the target question bank, the urban information model platform and the perception data, the requirements of the intelligent city under the twin hierarchy for the data management of the Internet of things are met, and the management efficiency of the data of the Internet of things is improved.
In order to solve the technical problems, the embodiment of the application also provides computer equipment. Referring specifically to fig. 7, fig. 7 is a basic structural block diagram of a computer device according to the present embodiment.
The computer device 7 comprises a memory 71, a processor 72, a network interface 73 communicatively connected to each other via a system bus. It is noted that only a computer device 7 having three components memory 71, a processor 72, a network interface 73 is shown in the figures, but it should be understood that not all of the illustrated components are required to be implemented and that more or fewer components may be implemented instead. It will be appreciated by those skilled in the art that the computer device herein is a device capable of automatically performing numerical calculations and/or information processing in accordance with predetermined or stored instructions, the hardware of which includes, but is not limited to, microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASICs), programmable gate arrays (fields-Programmable Gate Array, FPGAs), digital processors (Digital Signal Processor, DSPs), embedded devices, etc.
The computer device may be a desktop computer, a notebook computer, a palm computer, a cloud server, or the like. The computer device can perform man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch pad or voice control equipment and the like.
The memory 71 includes at least one type of readable storage medium including flash memory, hard disk, multimedia card, card memory (e.g., SD or DX memory, etc.), random Access Memory (RAM), static Random Access Memory (SRAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), programmable Read Only Memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 71 may be an internal storage unit of the computer device 7, such as a hard disk or a memory of the computer device 7. In other embodiments, the memory 71 may also be an external storage device of the computer device 7, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the computer device 7. Of course, the memory 71 may also comprise both an internal memory unit of the computer device 7 and an external memory device. In this embodiment, the memory 71 is generally used for storing an operating system and various application software installed on the computer device 7, such as program codes of an internet of things data management method of a smart city. In addition, the memory 71 may also be used to temporarily store various types of data that have been output or are to be output.
Processor 72 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 72 is typically used to control the overall operation of the computer device 7. In this embodiment, the processor 72 is configured to execute the program code stored in the memory 71 or process data, for example, execute the program code of the above-mentioned internet of things data governance method of the smart city, so as to implement various embodiments of the internet of things data governance method of the smart city.
The network interface 73 may comprise a wireless network interface or a wired network interface, which network interface 73 is typically used to establish a communication connection between the computer device 7 and other electronic devices.
The present application also provides another embodiment, namely, a computer readable storage medium, where a computer program is stored, where the computer program is executable by at least one processor, so that the at least one processor performs the steps of a method for managing data of internet of things in a smart city as described above.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) comprising several instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method of the embodiments of the present application.
It is apparent that the above-described embodiments are only some embodiments of the present application, but not all embodiments, and the preferred embodiments of the present application are shown in the drawings, which do not limit the scope of the patent claims. This application may be embodied in many different forms, but rather, embodiments are provided in order to provide a thorough and complete understanding of the present disclosure. Although the application has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that modifications may be made to the embodiments described in the foregoing description, or equivalents may be substituted for elements thereof. All equivalent structures made by the content of the specification and the drawings of the application are directly or indirectly applied to other related technical fields, and are also within the scope of the application.
Claims (10)
1. The data management method of the Internet of things in the smart city is characterized by comprising the following steps of:
constructing a data scheme according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data standard and a sensing database table design scheme;
based on the data scheme, data extraction is carried out from the stock Internet of things sensing application and the Internet of things sensing platform to obtain sensing data, and the sensing data is accessed to the Internet of things big data platform;
generating a target question library based on a database table corresponding to the perceived database table design scheme through the Internet of things big data platform;
and constructing a digital twin biological model by the target question bank, the city information model platform and the perception data, and storing the digital twin biological model in a physical model database.
2. The method for managing data of the internet of things in a smart city according to claim 1, wherein the constructing a data scheme according to a preset data requirement comprises:
constructing the perception data access scheme according to a preset data docking mode and a data transmission period;
constructing the perception data standard according to preset data fields and data types;
and constructing the design scheme of the perception database table based on the perception data specification standard.
3. The method for managing internet of things data of a smart city according to claim 2, wherein the constructing a perception database table design scheme based on the perception data specification standard comprises:
collecting data sources from an interface layer of the database according to the perception data specification standard, and performing data cleaning and data standardization processing on the data sources through an integration layer to obtain processed data;
and constructing a data summarization model corresponding to the business data in the middle layer of the database, constructing an enterprise external data source in the summarization layer of the database, and constructing the perception database table design scheme based on the data summarization model and the enterprise external data source.
4. The method for managing internet of things data in a smart city according to claim 1, wherein the data extraction is performed from an inventory internet of things sensing application and an internet of things sensing platform based on the data scheme to obtain sensing data, and the sensing data is accessed to an internet of things big data platform, comprising:
performing data extraction from the stock internet of things sensing application and the internet of things sensing platform according to the sensing data access scheme and the sensing data specification standard to obtain sensing data;
and the stock internet of things sensing application and the internet of things sensing platform are adopted to carry out cloud butt joint, and the sensing data are accessed into the internet of things big data platform.
5. The method for managing data of the internet of things in a smart city according to claim 4, wherein the cloud-cloud docking mode comprises library table synchronization, API interface docking, file synchronization and message synchronization.
6. The method for data governance of the Internet of things of a smart city according to any one of claims 1 to 5, wherein,
the target question bank comprises a question bank and a question bank, wherein the question bank and the question bank comprise equipment file information, equipment attribution information, equipment business information and equipment topical information.
7. The method of claim 6, wherein the constructing the digital twin biological model from the target subject library, the city information model platform, and the perception data and storing the digital twin biological model in an object model database comprises:
synchronizing the equipment archive information in the target question bank into the city information model platform through the Internet of things big data platform so that the Internet of things big data platform performs model construction to obtain a digital twin biological model, wherein the model construction comprises equipment dotting, equipment model positioning and equipment model establishment;
storing data storage path information of the response in the perception data to store the digital twin biological model in the object model database.
8. An internet of things data governance system for a smart city, comprising:
the data scheme construction unit is used for constructing a data scheme according to preset data requirements, wherein the data scheme comprises a sensing data access scheme, a sensing data specification standard and a sensing database table design scheme;
the data extraction unit is used for extracting data from the stock internet of things sensing application and the internet of things sensing platform based on the data scheme to obtain sensing data, and accessing the sensing data into the internet of things big data platform;
the target question library generation unit is used for generating a target question library based on the database table corresponding to the perception database table design scheme through the big data platform of the Internet of things;
and the model construction unit is used for constructing a digital twin biological model from the target question library, the city information model platform and the perception data and storing the digital twin biological model in an object model database.
9. A computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program implementing the internet of things data governance method of a smart city according to any of claims 1 to 7.
10. A computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, and when executed by a processor, the computer program implements the internet of things data governance method of a smart city according to any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311044085.9A CN117009357A (en) | 2023-08-18 | 2023-08-18 | Internet of things data management method, device, system and medium for smart city |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311044085.9A CN117009357A (en) | 2023-08-18 | 2023-08-18 | Internet of things data management method, device, system and medium for smart city |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117009357A true CN117009357A (en) | 2023-11-07 |
Family
ID=88570943
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311044085.9A Pending CN117009357A (en) | 2023-08-18 | 2023-08-18 | Internet of things data management method, device, system and medium for smart city |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117009357A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117354055A (en) * | 2023-12-04 | 2024-01-05 | 广东润建电力科技有限公司 | Block chain twin Internet of things information data migration method and system |
-
2023
- 2023-08-18 CN CN202311044085.9A patent/CN117009357A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117354055A (en) * | 2023-12-04 | 2024-01-05 | 广东润建电力科技有限公司 | Block chain twin Internet of things information data migration method and system |
| CN117354055B (en) * | 2023-12-04 | 2024-03-12 | 广东润建电力科技有限公司 | Block chain twin Internet of things information data migration method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20190012914A1 (en) | Parking Identification and Availability Prediction | |
| CN107196788A (en) | A kind of processing method for burying point data, device, server and client | |
| CN103645951A (en) | Cross-platform mobile data management system and method | |
| US20140280064A1 (en) | Generating business intelligence geospatial elements | |
| US20160217537A1 (en) | Real estate data management system | |
| CN112989156A (en) | Big data based policy and enterprise matching method and system | |
| CN108363684A (en) | List creation method, device and server | |
| CN117009357A (en) | Internet of things data management method, device, system and medium for smart city | |
| CN107408065A (en) | Supervision application loads | |
| CN103562905A (en) | Improved data visualization configuration system and method | |
| CN112860662B (en) | Automatic production data blood relationship establishment method, device, computer equipment and storage medium | |
| CN107085599B (en) | POI recommendation method, device, equipment and computer readable storage medium | |
| CN116956326A (en) | Authority data processing method and device, computer equipment and storage medium | |
| WO2016206395A1 (en) | Weekly report information processing method and device | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| US20210279825A1 (en) | System and method for revenue and asset management based on micro-service architecture | |
| CN115438812A (en) | Life-saving management method and device for power transmission equipment, computer equipment and storage medium | |
| CN111916164B (en) | Method and device for realizing center-started investigation system in clinical research | |
| CN114625372A (en) | Automatic component compiling method and device, computer equipment and storage medium | |
| CN116010372A (en) | Space-time data processing system, method, device, equipment, medium and product | |
| CN113268695A (en) | Data embedding point processing method and device and related equipment | |
| Jobst et al. | Accessing spatial knowledge networks with maps | |
| CN107180073B (en) | POI recommendation method, device, equipment and computer readable storage medium | |
| CN116861013B (en) | CIM data credibility improving method | |
| CN116450613B (en) | Resource-oriented geographic sample data service method, 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 |