CN117708218B - Industrial Internet of things data access method and database system based on service sub-platform - Google Patents
Industrial Internet of things data access method and database system based on service sub-platform Download PDFInfo
- Publication number
- CN117708218B CN117708218B CN202410165462.2A CN202410165462A CN117708218B CN 117708218 B CN117708218 B CN 117708218B CN 202410165462 A CN202410165462 A CN 202410165462A CN 117708218 B CN117708218 B CN 117708218B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- sub
- service
- management
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000003860 storage Methods 0.000 claims abstract description 135
- 238000013507 mapping Methods 0.000 claims abstract description 59
- 238000012545 processing Methods 0.000 claims description 21
- 238000004519 manufacturing process Methods 0.000 abstract description 8
- 238000007726 management method Methods 0.000 description 111
- 238000009434 installation Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000005553 drilling Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000227 grinding Methods 0.000 description 1
- 238000009776 industrial production Methods 0.000 description 1
- 238000003754 machining Methods 0.000 description 1
- 238000003801 milling Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of intelligent manufacturing, in particular to an industrial Internet of things data access method and a database system based on a service sub-platform, wherein the data access method comprises the following steps: establishing primary storage identifiers corresponding to object data one by one, establishing secondary storage identifiers corresponding to sensing data one by one, establishing primary mapping relation between the primary storage identifiers and the secondary storage identifiers, establishing tertiary storage identifiers corresponding to management data one by one, establishing secondary mapping relation between the secondary storage identifiers and the tertiary storage identifiers, sending an access request through a user platform, acquiring service data corresponding to the access request according to the access request through a service database, acquiring management data corresponding to the access request by combining the tertiary storage identifiers, and acquiring sensing data and object data corresponding to the access request based on the secondary mapping relation and the primary mapping relation. The invention can store the data efficiently and access the data rapidly.
Description
Technical Field
The invention relates to the technical field of intelligent manufacturing, in particular to an industrial Internet of things data access method and a database system based on a service sub-platform.
Background
The industrial internet of things continuously integrates various acquisition sensors, control sensors or controllers with sensing and monitoring capabilities, mobile communication, intelligent analysis and other technologies into various links of an industrial production process, so that the manufacturing efficiency is greatly improved, the product quality is improved, the product cost and the resource consumption are reduced, and finally the traditional industry is improved to an intelligent new stage. From the application form, the application of the industrial Internet of things has the characteristics of instantaneity, automation, embedded (software), safety, information intercommunication and interconnection and the like.
However, it is found in practice that the current industrial internet of things applications exist under the following conditions: (1) The equipment has wide distribution, multiple models, scattered files, shared information, manual arrangement dependence and difficult management; (2) Equipment faults can not be acquired in time, the labor cost and the communication cost are high, and the service timeliness is poor; (3) The data such as the running state, the installation position, the running parameters and the like of the equipment cannot be monitored, collected and analyzed in time, and the monitoring is difficult to realize in time and effective; (4) The after-sales personnel are numerous, the after-sales personnel cannot be arranged in time, and the working conditions of the after-sales personnel cannot be collected and checked, so that the difficulty of after-sales management is increased; (5) Manufacturers use a plurality of PLC (Programmable Logic Controller ) products, but because of different protocols and a large total data volume, the data access speed is slow.
In summary, in the existing industrial internet of things, due to the numerous nodes, it is difficult to quickly process and store information data in the industrial internet of things, and when the information data in the industrial internet of things needs to be accessed, it is difficult to quickly feed back the accessed content due to the influence of factors such as network delay and bandwidth limitation in the internet of things.
Disclosure of Invention
The invention provides the service sub-platform-based industrial Internet of things data access method and the database system, which are used for rapidly processing and storing information data in the industrial Internet of things and providing high-efficiency and stable access content feedback.
In order to achieve the above object, the technical scheme of the present invention is as follows: the industrial Internet of things database system based on the service sub-platform comprises an object platform, a sensing network platform, a management platform, a service platform and a user platform;
the object platform comprises a plurality of object acquisition devices, wherein the object acquisition devices are used for acquiring data generated by the covered devices and processing the data into object data;
The sensing network platform comprises a sensing network database and a plurality of sensing sub-platforms which interact with the sensing network database, the sensing sub-platforms are arranged in one-to-one correspondence with the object acquisition equipment, and independent sensing sub-databases are arranged in the sensing sub-platforms; the sensing sub-database is used for acquiring the object data and sending the object data to the sensing sub-platform, and the sensing sub-platform is used for processing the object data into sensing data and sending the sensing data to the sensing network database;
The management platform comprises a management database and a plurality of management sub-platforms which interact with the management database, wherein independent management sub-databases are arranged in the management sub-platforms, and the management sub-databases interact with the sensing network database; the management sub-database is used for acquiring the sensing data and sending the sensing data to the management sub-platform, and the management sub-platform is used for processing the sensing data into management data and sending the management data to the management database;
The service platform comprises a service database and a plurality of service sub-platforms which interact with the service database, wherein independent service sub-databases are arranged in the service sub-platforms, and the service sub-databases interact with the management database; the service sub-database is used for acquiring the management data and sending the management data to the service sub-platform, and the service sub-platform is used for processing the management data into service data and sending the service data to the service database;
The sensing sub-database is also used for establishing primary storage identifiers corresponding to the object data one by one and feeding back the primary storage identifiers to the sensing network database; the management sub-database is also used for establishing secondary storage identifiers corresponding to the sensing data one by one, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database; the service sub-database is also used for establishing three-level storage identifiers corresponding to the management data one by one, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database;
the user platform is used for sending an access request, the service database is used for obtaining service data corresponding to the access request according to the access request, obtaining management data corresponding to the access request by combining the tertiary storage identification, obtaining sensing data and object data corresponding to the access request based on the secondary mapping relation and the primary mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform.
Further, the object data comprises an operation state, an installation position, an operation parameter and a fault condition of the equipment, the sensing sub-database is used for generating a primary main identifier according to the operation state, the installation position, the operation parameter and the fault condition of the equipment in the object data, generating a primary secondary identifier according to a source position and a target position of the object data, and combining the primary main identifier and the primary secondary identifier into a primary storage identifier.
Further, the management sub-database is used for acquiring the source position and the target position of the sensing data to generate a secondary identification, distributing a secondary main identification to the sensing data, and combining the secondary main identification and the secondary identification into a secondary storage identification;
The service sub-database is used for acquiring the source position and the target position of the management data to generate tertiary secondary identifications, distributing tertiary main identifications to the management data, and combining the tertiary main identifications and the tertiary secondary identifications into tertiary storage identifications;
The secondary main identifier is combined with a plurality of secondary identifiers, and the tertiary main identifier is combined with a plurality of tertiary identifiers.
Further, the service database is used for reading the access request and obtaining service data corresponding to the access request; extracting a third-level main identifier corresponding to the service data, traversing the management database according to the second-level identifier, and obtaining management data corresponding to the access request;
and the service database is used for extracting the sensing data and the object data corresponding to the access request from the management database and the service database according to the primary mapping relation and the secondary mapping relation.
Further, the primary mapping relationship includes a storage location of the primary storage identifier and a storage location of the secondary storage identifier, and the secondary mapping relationship includes a storage location of the secondary storage identifier and a storage location of the tertiary storage identifier.
Further, the user platform is used for establishing access sequences according to the access frequency of the access requests;
The service database is used for establishing three-level storage identification sequences according to the access sequences, and when the access request is acquired, the service database is sequentially inquired according to the three-level storage identification sequences so as to acquire management data corresponding to the access request.
Further, the service sub-databases are used for acquiring the data source range in the access request, matching the data source range in the access request with the data source range in each service sub-database, inquiring the IP addresses of one or more matched or partially matched service sub-databases, and sending a data access request to one or more matched or partially matched sub-service databases;
If the data source range in the data access request received by the service database relates to the data source ranges of a plurality of service sub-databases, matching to obtain the service sub-databases, correspondingly splitting the data source range in the data access request according to the data source ranges of the matched service sub-databases, and respectively sending the data access request to the plurality of service sub-databases, wherein the split sub-data source ranges matched with the service sub-databases are contained in the request.
The industrial Internet of things data access method based on the service sub-platform comprises the following steps:
collecting data generated by the covering equipment through the object collecting equipment and processing the data into object data;
The object data are obtained through a sensing sub-database and sent to a sensing sub-platform which belongs to the object data, and the sensing sub-platform processes the object data into sensing data and sends the sensing data to the sensing network database;
The sensing data are acquired through a management sub-database and sent to a management sub-platform, and the management sub-platform processes the sensing data into management data and sends the management data to the management database;
The management data is obtained through a service sub-database and sent to a service sub-platform, and the service sub-platform processes the management data into service data and sends the service data to the service database;
establishing primary storage identifiers corresponding to the object data one by one through the sensing sub database, and feeding back the primary storage identifiers to the sensing network database;
Establishing secondary storage identifiers corresponding to the sensing data one by one through a management sub database, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database;
Establishing three-level storage identifiers corresponding to the management data one by one through a service sub-database, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database;
Sending an access request through a user platform, acquiring service data corresponding to the access request through the service database according to the access request, acquiring management data corresponding to the access request by combining the three-level storage identifier, acquiring sensing data and object data corresponding to the access request based on the two-level mapping relation and the one-level mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform.
The invention has the beneficial effects that:
(1) The invention collects the running state, the installation position, the running parameters and the fault condition of the equipment through the object collecting equipment, and sequentially receives data through independent sub-databases on the sensing network platform, the management platform and the service platform, processes the data through the independent sub-platforms, and gathers the data in the databases of the platforms; meanwhile, each sub database generates a corresponding storage identifier, and a mapping relation between the storage identifiers is established. Therefore, efficient and orderly storage of data is completed, even if the acquired equipment data volume is large and disordered, the plurality of sub-platforms and the sub-databases simultaneously receive and process the data, and finally, the data is subjected to unified summarization processing through the databases, so that the data can be conveniently, continuously and efficiently stored and integrally managed.
(2) According to the invention, based on the storage identifiers in each platform and the mapping relation between the storage identifiers, service data, management data, sensing data and object data corresponding to the access request can be rapidly acquired when the access request occurs, and the whole group of data is fed back together, so that the accessed content can be rapidly fed back, only the service data is required to be queried, and the other same group of data is rapidly extracted based on the storage identifiers and the mapping relation, thereby reducing the pressure on the Internet of things.
(3) According to the invention, the data source range in the request is matched with the data source range in each service sub-database, so that the actual position stored by the service data corresponding to the access request can be obtained efficiently, the corresponding data access request is sent to the actual storage position thereof, the actual position stored by the song component part of the service data can still be obtained for the service data which is stored in a scattered manner, and a plurality of data access requests are sent to the corresponding actual storage positions thereof, thereby improving the obtaining efficiency of the service data corresponding to the access request.
Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.
Drawings
FIG. 1 is a schematic diagram of an embodiment of an industrial Internet of things database system based on a service sub-platform according to the present invention;
fig. 2 is a flow chart of an industrial internet of things data access method based on a service sub-platform.
Detailed Description
The following description of the embodiments of the present invention will be made apparent and fully in view of the accompanying drawings, in which some, but not all embodiments of the invention are shown. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The following is a further detailed description of the embodiments:
example 1: as shown in fig. 1: the industrial Internet of things database system based on the service sub-platform comprises an object platform, a sensing network platform, a management platform, a service platform and a user platform, wherein the object platform and the sensing network platform interact with each other, the sensing network platform and the management platform interact with each other, the management platform and the service platform interact with each other, and the service platform and the user platform interact with each other.
The object platform comprises a plurality of object physical entities and corresponding object acquisition equipment, wherein the object acquisition equipment is used for acquiring data generated by the covered object physical entities and processing the data into object data; the object physical entity is a production line for executing manufacturing in the industrial Internet of things, production line equipment, a data collector and the like. The production line equipment comprises industrial robots, grinding machines, drilling machines, numerical control machine tool machining centers, flexible manufacturing systems, various portable moving tools, lathes, milling machines, planing machines and the like.
The object data comprises the running state, the installation position, the running parameters, the fault condition and the like of the equipment, wherein the running state comprises the conditions of working speed, working space, working load, working precision, repetition precision, running speed, power, daily output, fault condition, working time length and the like.
The sensing network platform comprises a sensing network database and a plurality of sensing sub-platforms which interact with the sensing network database, the sensing sub-platforms and the object acquisition equipment are arranged in a one-to-one correspondence manner, and independent sensing sub-databases are arranged in the sensing sub-platforms; in this embodiment, the sensor network platform is configured as a communication network and gateway.
The sensing sub-database is used for acquiring the object data and sending the object data to the sensing sub-platform, and the sensing sub-platform is used for processing the object data into sensing data and sending the sensing data to the sensing network database.
And the object data in the sensing network platform is acquired by an independent sensing sub-database, the object data is processed by the sensing sub-platform corresponding to the sensing sub-database, and then the sensing data is fed back to the sensing network database in a centralized manner.
The management platform comprises a management database and a plurality of management sub-platforms which are interacted with the management database, wherein independent management sub-databases are arranged in the management sub-platforms, and the management sub-databases are interacted with the sensing network database; in this embodiment, the management platform is configured as a server.
The management sub-database is used for acquiring the sensing data and sending the sensing data to the management sub-platform, and the management sub-platform is used for processing the sensing data into the management data and sending the management data to the management database.
And the sensing data in the management platform is acquired by an independent management sub-database, the processing of the sensing data is carried out by the management sub-platform corresponding to the management sub-database, and then the management data is fed back to the management database in a centralized manner.
The service platform comprises a service database and a plurality of service sub-platforms which interact with the service database, wherein independent service sub-databases are arranged in the service sub-platforms, and the service sub-databases interact with the management database; in this embodiment, the service is also configured as a server.
The service sub-database is used for acquiring the management data and sending the management data to the service sub-platform, and the service sub-platform is used for processing the management data into service data and sending the service data to the service database.
The sensing data in the service platform is obtained by an independent service sub-database, management data processing is carried out by the service sub-platform corresponding to the service sub-database, and then the service data is fed back to the service database in a centralized manner.
The sensing sub-database is also used for establishing primary storage identifiers corresponding to the object data one by one and feeding the primary storage identifiers back to the sensing network database; the management sub database is also used for establishing secondary storage identifiers corresponding to the sensing data one by one, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database; the service sub-database is also used for establishing three-level storage identifiers corresponding to the management data one by one, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database.
Specifically, the sensing sub-database is used for generating a primary main identifier according to the running state, the installation position, the running parameters and the fault condition of equipment in the object data, generating a primary secondary identifier according to the source position and the target position of the object data, and combining the primary main identifier and the primary secondary identifier into a primary storage identifier.
The management sub-database is used for acquiring the source position and the target position of the sensing data to generate a secondary identification, distributing a secondary main identification for the sensing data, and combining the secondary main identification and the secondary identification into a secondary storage identification;
The service sub-database is used for acquiring the source position and the target position of the management data to generate tertiary sub-identifiers, distributing tertiary main identifiers for the management data, and combining the tertiary main identifiers and the tertiary sub-identifiers into tertiary storage identifiers;
The secondary main mark is combined with a plurality of secondary marks, and the tertiary main mark is combined with a plurality of tertiary marks.
For example, when the equipment generates a fault condition, the fault condition is sequentially collected by the object platform, then processed by the sensing network platform, the management platform and the service platform, and finally fed back to the user platform, namely the terminal equipment used by the user; generating a primary identifier in the sensor network platform based on the device position generated by the fault condition and the target position in the sensor network platform to which the fault condition is to be sent, wherein the primary identifier can be a series of independent serial numbers; generating a primary main identifier based on the fault condition, wherein the primary main identifier can be a series of independent serial numbers; the corresponding primary storage identifier is the superposition of two serial numbers, and the superposition is realized through character string connection, for example, the primary main identifier is abcd, the primary secondary identifier is 1234, and the combined primary storage identifier is abcd 1234.
Firstly, generating a secondary identifier and a tertiary identifier based on the source position and the target position of the processed fault condition in a management platform and a service platform based on the processed fault condition (sensing data and management data); then, a secondary main identifier and a tertiary main identifier are allocated to the processed fault condition, and the secondary main identifier and the tertiary main identifier are generally allocated in a sequential manner. For example, the secondary and tertiary primary labels are "0001", the secondary and tertiary labels are "1234", and the combined secondary and tertiary storage labels are "00011234".
The user platform is configured to send an access request, and in this embodiment, the user platform is configured as a terminal device. The service database is used for acquiring service data corresponding to the access request according to the access request, acquiring management data corresponding to the access request by combining the three-level storage identifier, acquiring sensing data and object data corresponding to the access request based on the two-level mapping relation and the one-level mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform.
Specifically, the service database is used for reading the access request and acquiring service data corresponding to the access request; extracting a third-level main identifier corresponding to the service data, traversing the management database according to the second-level identifier, and acquiring management data corresponding to the access request;
The service database is used for extracting the sensing data and the object data corresponding to the access request from the management database and the service database according to the first-level mapping relation and the second-level mapping relation.
The first-level mapping relation comprises a storage position of a first-level storage identifier and a storage position of a second-level storage identifier, and the second-level mapping relation comprises a storage position of the second-level storage identifier and a storage position of a third-level storage identifier.
When the data in the industrial Internet of things is required to be read, a user sends an access request through a user platform, a service database queries the inside of the user based on the content of the access request to find sensing data corresponding to the access request, then corresponding management data can be obtained according to the three-level storage identification, and then corresponding sensing data and object data can be obtained based on the first-level mapping relation and the second-level mapping relation.
For example, fault information of a certain device is recorded in the industrial internet of things, wherein a primary storage identifier is abcd1234, a secondary storage identifier is 00011234, and a tertiary storage identifier is 10011234; after service data corresponding to the fault information is queried, the three-level storage identifier 10011234 corresponding to the fault information can be queried in the service database, the management data storage position corresponding to the fault information can be acquired through the three-level storage identifier 10011234, then the two-level storage identifier 00011234 and the one-level storage identifier abcd1234 can be acquired based on the first-level mapping relation and the second-level mapping relation, sensing data and object data corresponding to the fault information can be acquired through the two-level storage identifier 00011234 and the one-level storage identifier abcd123, the fault information is recorded in the object data, and accordingly all data related to the fault information in the industrial Internet of things are fed back.
By the database system, not only can ordered data be processed quickly, but also all data related to the accessed content can be quickly fetched and fed back when the data is accessed.
In addition, as shown in fig. 2, an industrial internet of things data access method based on a service sub-platform is provided, which is applicable to the database system, and includes the following steps:
s1: collecting data generated by the covering equipment through the object collecting equipment and processing the data into object data;
S2: acquiring object data through a sensing sub-database and sending the object data to a sensing sub-platform which belongs to the sensing sub-database, and processing the object data into sensing data by the sensing sub-platform and sending the sensing data to a sensing network database;
s3: the sensing data are acquired through the management sub-database and sent to the management sub-platform, and the management sub-platform processes the sensing data into management data and sends the management data to the management database;
S4: acquiring management data through a service sub-database and sending the management data to a service sub-platform, and processing the management data into service data by the service sub-platform and sending the service data to the service database;
s5: establishing primary storage identifiers corresponding to the object data one by one through a sensing sub-database, and feeding the primary storage identifiers back to a sensing network database;
S6: establishing secondary storage identifiers corresponding to the sensing data one by one through a management sub database, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database;
S7: establishing three-level storage identifiers corresponding to management data one by one through a service sub-database, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database;
S8: sending an access request through a user platform, acquiring service data corresponding to the access request through a service database according to the access request, acquiring management data corresponding to the access request by combining the three-level storage identifier, acquiring sensing data and object data corresponding to the access request based on the two-level mapping relation and the one-level mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform.
Example 2: the difference from embodiment 1 is that the user platform is configured to establish an access ranking according to the access frequency of the access requests; the service database is used for establishing three-level storage identification sequences according to the access sequences, and when the access request is acquired, the service database is sequentially inquired according to the three-level storage identification sequences so as to acquire management data corresponding to the access request.
For example, when the frequency of accessing a certain device fault information by a user is high, the device fault information will be located at the high level of the access sequence, so that the service database establishes three-level storage identification sequences corresponding to the access sequence in the service database, and when the fault information is accessed, the fault information of the device is preferably compared, and thus the management data corresponding to the access request is quickly retrieved.
Example 3: the difference from embodiment 2 is that the service sub-databases are used to obtain the data source scope in the access request, and according to the data source scope in the access request and the data source scope in each service sub-database, query the IP address of the matched or partially matched one or more service sub-databases, and send the data access request to the matched or partially matched one or more sub-service databases.
If the data source range in the data access request received by the service database relates to the data source ranges of a plurality of service sub-databases, the service sub-databases are obtained by matching, the data source ranges in the data access request are correspondingly split according to the data source ranges of the matched service sub-databases, the data access request is respectively sent to the plurality of service sub-databases, and the split sub-data source ranges matched with the service sub-databases are contained in the request, so that the query speed of the service data is improved.
It is apparent that the above examples are given by way of illustration only and are not limiting of the embodiments. Other variations or modifications of the above teachings will be apparent to those of ordinary skill in the art. It is not necessary here nor is it exhaustive of all embodiments. While still being apparent from variations or modifications that may be made by those skilled in the art are within the scope of the invention.
Claims (6)
1. The industrial Internet of things database system based on the service sub-platform is characterized by comprising an object platform, a sensing network platform, a management platform, a service platform and a user platform;
the object platform comprises a plurality of object acquisition devices, wherein the object acquisition devices are used for acquiring data generated by the covered devices and processing the data into object data;
The sensing network platform comprises a sensing network database and a plurality of sensing sub-platforms which interact with the sensing network database, the sensing sub-platforms are arranged in one-to-one correspondence with the object acquisition equipment, and independent sensing sub-databases are arranged in the sensing sub-platforms; the sensing sub-database is used for acquiring the object data and sending the object data to the sensing sub-platform, and the sensing sub-platform is used for processing the object data into sensing data and sending the sensing data to the sensing network database;
The management platform comprises a management database and a plurality of management sub-platforms which interact with the management database, wherein independent management sub-databases are arranged in the management sub-platforms, and the management sub-databases interact with the sensing network database; the management sub-database is used for acquiring the sensing data and sending the sensing data to the management sub-platform, and the management sub-platform is used for processing the sensing data into management data and sending the management data to the management database;
The service platform comprises a service database and a plurality of service sub-platforms which interact with the service database, wherein independent service sub-databases are arranged in the service sub-platforms, and the service sub-databases interact with the management database; the service sub-database is used for acquiring the management data and sending the management data to the service sub-platform, and the service sub-platform is used for processing the management data into service data and sending the service data to the service database;
The sensing sub-database is also used for establishing primary storage identifiers corresponding to the object data one by one and feeding back the primary storage identifiers to the sensing network database; the management sub-database is also used for establishing secondary storage identifiers corresponding to the sensing data one by one, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database; the service sub-database is also used for establishing three-level storage identifiers corresponding to the management data one by one, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database;
The user platform is used for sending an access request, the service database is used for acquiring service data corresponding to the access request according to the access request, acquiring management data corresponding to the access request by combining the three-level storage identifier, acquiring sensing data and object data corresponding to the access request based on the two-level mapping relation and the one-level mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform;
The sensing sub database is used for generating a primary main identifier according to the running state, the mounting position, the running parameters and the fault condition of the equipment in the object data, generating a primary secondary identifier according to the source position and the target position of the object data, and combining the primary main identifier and the primary secondary identifier into a primary storage identifier;
the management sub-database is used for acquiring the source position and the target position of the sensing data to generate a secondary identification, distributing a secondary main identification for the sensing data, and combining the secondary main identification and the secondary identification into a secondary storage identification;
The service sub-database is used for acquiring the source position and the target position of the management data to generate tertiary secondary identifications, distributing tertiary main identifications to the management data, and combining the tertiary main identifications and the tertiary secondary identifications into tertiary storage identifications;
The secondary main identifier is combined with a plurality of secondary identifiers, and the tertiary main identifier is combined with a plurality of tertiary identifiers.
2. The industrial internet of things database system based on the service sub-platform according to claim 1, wherein the service database is used for reading the access request and obtaining service data corresponding to the access request; extracting a third-level main identifier corresponding to the service data, traversing the management database according to the second-level identifier, and obtaining management data corresponding to the access request;
and the service database is used for extracting the sensing data and the object data corresponding to the access request from the management database and the service database according to the primary mapping relation and the secondary mapping relation.
3. The service-split-platform-based industrial internet of things database system according to claim 1, wherein the primary mapping relationship comprises a storage location of the primary storage identifier and a storage location of the secondary storage identifier, and the secondary mapping relationship comprises a storage location of the secondary storage identifier and a storage location of the tertiary storage identifier.
4. The service-partition-platform-based industrial internet of things database system according to claim 1, wherein the user platform is configured to establish an access ranking according to the access frequency of the access requests;
The service database is used for establishing three-level storage identification sequences according to the access sequences, and when the access request is acquired, the service database is sequentially inquired according to the three-level storage identification sequences so as to acquire management data corresponding to the access request.
5. The service sub-platform based industrial internet of things database system according to claim 1, wherein the service sub-databases are configured to obtain a data source range in the access request, match the data source range in the access request with the data source range in each of the service sub-databases, query IP addresses of one or more of the service sub-databases that are matched or partially matched, and send a data access request to the one or more of the sub-service databases that are matched or partially matched;
If the data source range in the data access request received by the service database relates to the data source ranges of a plurality of service sub-databases, matching to obtain the service sub-databases, correspondingly splitting the data source range in the data access request according to the data source ranges of the matched service sub-databases, and respectively sending the data access request to the plurality of service sub-databases, wherein the split sub-data source ranges matched with the service sub-databases are contained in the request.
6. The industrial internet of things data access method based on the service sub-platform is performed through the industrial internet of things database system based on the service sub-platform according to any one of claims 1 to 5, and is characterized by comprising the following steps:
collecting data generated by the covering equipment through the object collecting equipment and processing the data into object data;
The object data are obtained through a sensing sub-database and sent to a sensing sub-platform which belongs to the object data, and the sensing sub-platform processes the object data into sensing data and sends the sensing data to the sensing network database;
The sensing data are acquired through a management sub-database and sent to a management sub-platform, and the management sub-platform processes the sensing data into management data and sends the management data to the management database;
The management data is obtained through a service sub-database and sent to a service sub-platform, and the service sub-platform processes the management data into service data and sends the service data to the service database;
establishing primary storage identifiers corresponding to the object data one by one through the sensing sub database, and feeding back the primary storage identifiers to the sensing network database;
Establishing secondary storage identifiers corresponding to the sensing data one by one through a management sub database, extracting the primary storage identifiers, establishing a primary mapping relation between the primary storage identifiers and the secondary storage identifiers, and feeding back the primary mapping relation to the management database;
Establishing three-level storage identifiers corresponding to the management data one by one through a service sub-database, extracting the two-level storage identifiers, establishing a two-level mapping relation between the two-level storage identifiers and the three-level storage identifiers, and feeding back the one-level mapping relation to the management database;
Sending an access request through a user platform, acquiring service data corresponding to the access request through the service database according to the access request, acquiring management data corresponding to the access request by combining the three-level storage identifier, acquiring sensing data and object data corresponding to the access request based on the two-level mapping relation and the one-level mapping relation, and feeding back the management data, the sensing data and the object data corresponding to the access request to the user platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410165462.2A CN117708218B (en) | 2024-02-05 | 2024-02-05 | Industrial Internet of things data access method and database system based on service sub-platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410165462.2A CN117708218B (en) | 2024-02-05 | 2024-02-05 | Industrial Internet of things data access method and database system based on service sub-platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117708218A CN117708218A (en) | 2024-03-15 |
| CN117708218B true CN117708218B (en) | 2024-05-03 |
Family
ID=90146588
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410165462.2A Active CN117708218B (en) | 2024-02-05 | 2024-02-05 | Industrial Internet of things data access method and database system based on service sub-platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117708218B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117951140A (en) * | 2024-03-25 | 2024-04-30 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things sub-service platform data interaction system |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017216811A1 (en) * | 2016-06-16 | 2017-12-21 | Attinad Sotfware Pvt. Ltd. | A system and method of sensor profiling and identity modeling of resources in iot systems |
| WO2021232150A1 (en) * | 2020-05-19 | 2021-11-25 | National Research Council Of Canada | A multi-channel and agnostic hardware-software interface and database architecture for predictive and prescriptive materials discovery |
| CN114629940A (en) * | 2022-05-13 | 2022-06-14 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things system beneficial to system expansibility and control method |
| CN115099557A (en) * | 2022-05-09 | 2022-09-23 | 广东电网有限责任公司电力调度控制中心 | Intelligent power grid analysis method based on intelligent monitoring |
| CN115277784A (en) * | 2022-08-09 | 2022-11-01 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things system convenient for realizing local authority control and control method |
| CN115374109A (en) * | 2022-07-29 | 2022-11-22 | 华为技术有限公司 | Data access method, device, computing equipment and system |
| CN115665197A (en) * | 2022-10-19 | 2023-01-31 | 成都数智索信息技术有限公司 | Automatic warehousing system and method based on data acquisition of Internet of things |
| CN116192907A (en) * | 2023-04-26 | 2023-05-30 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things monitoring method and system based on service sub-platform |
| CN116882426A (en) * | 2023-07-11 | 2023-10-13 | 江西方兴科技股份有限公司 | Electromechanical equipment management platform based on identification analysis |
| CN116894649A (en) * | 2023-09-11 | 2023-10-17 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things main service platform data distribution system, method and medium |
-
2024
- 2024-02-05 CN CN202410165462.2A patent/CN117708218B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2017216811A1 (en) * | 2016-06-16 | 2017-12-21 | Attinad Sotfware Pvt. Ltd. | A system and method of sensor profiling and identity modeling of resources in iot systems |
| WO2021232150A1 (en) * | 2020-05-19 | 2021-11-25 | National Research Council Of Canada | A multi-channel and agnostic hardware-software interface and database architecture for predictive and prescriptive materials discovery |
| CN115099557A (en) * | 2022-05-09 | 2022-09-23 | 广东电网有限责任公司电力调度控制中心 | Intelligent power grid analysis method based on intelligent monitoring |
| CN114629940A (en) * | 2022-05-13 | 2022-06-14 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things system beneficial to system expansibility and control method |
| CN115374109A (en) * | 2022-07-29 | 2022-11-22 | 华为技术有限公司 | Data access method, device, computing equipment and system |
| CN115277784A (en) * | 2022-08-09 | 2022-11-01 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things system convenient for realizing local authority control and control method |
| CN115665197A (en) * | 2022-10-19 | 2023-01-31 | 成都数智索信息技术有限公司 | Automatic warehousing system and method based on data acquisition of Internet of things |
| CN116192907A (en) * | 2023-04-26 | 2023-05-30 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things monitoring method and system based on service sub-platform |
| CN116882426A (en) * | 2023-07-11 | 2023-10-13 | 江西方兴科技股份有限公司 | Electromechanical equipment management platform based on identification analysis |
| CN116894649A (en) * | 2023-09-11 | 2023-10-17 | 成都秦川物联网科技股份有限公司 | Industrial Internet of things main service platform data distribution system, method and medium |
Non-Patent Citations (3)
| Title |
|---|
| Logistics management data security transmission system based on Internet of things technology;Zheng Yang;《2021 International Conference on Intelligent Transportation, Big Data & Smart City》;20210903;466-472 * |
| 基于工业互联网标识解析体系的数据共享机制;刘阳;《计算机集成制造系统》;20191215;第25卷(第12期);3032-3042 * |
| 面向工业互联网的分布式标识解析系统架构设计与实现;王志远;《中国优秀硕士学位论文全文数据库 信息科技辑》;20231115(第11期);I139-244 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117708218A (en) | 2024-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN117708218B (en) | Industrial Internet of things data access method and database system based on service sub-platform | |
| CN108040005B (en) | Digit control machine tool intelligent monitoring gateway based on thing networking | |
| CN112765768B (en) | Discrete workshop digital traceability method based on Internet of things | |
| CN101770222B (en) | Method for online managing cutting tool of numerically controlled lathe | |
| CN105607579B (en) | A kind of machine tooling intelligent power saving control method and system | |
| CN110032602B (en) | Product information storage, inquiry and management system and method | |
| CN101222377A (en) | Method and device for processing slave machine parameter in distributed master-salve machine communication | |
| CN108873847B (en) | Data acquisition method for die forging production line | |
| CN116483015B (en) | Workshop equipment monitoring method, device, equipment and storage medium | |
| CN105554169A (en) | OID configuration and analytic methods, ORS client, and OID node and database thereof | |
| CN116527718A (en) | Data acquisition method and system for industrial Internet of things gateway | |
| Flick et al. | Ascertainment of energy consumption information in the age of industrial big data | |
| CN111638689B (en) | Production line data centralized acquisition and control system and method based on automatic master control system | |
| Verma et al. | Real-time remote monitoring of an air compressor using MTConnect standard protocol | |
| CN112859740A (en) | Data acquisition device of numerical control machine tool | |
| CN112818180A (en) | Storage and query method of wafer processing historical data and process control system | |
| CN116016579A (en) | Data acquisition system of automatic equipment | |
| CN109446260B (en) | Distributed management method and system for real-time data of mass data points | |
| CN102360199B (en) | Processing workpiece quantity on-line statistical method under numeric control environment | |
| CN112182443B (en) | MES-oriented identification query system and method | |
| CN206946292U (en) | Power collecting system and numerical control machine tool monitoring system | |
| CN103279435A (en) | Control system, control equipment and input and output control method of control system and control equipment | |
| CN113791593B (en) | Measuring point derivation method and system for distributed control system, terminal device and readable storage medium | |
| CN112987652B (en) | Machine tool data acquisition method and device and machine tool data sharing method and device | |
| CN220543273U (en) | Numerical control machine tool data acquisition system |
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 |