CN110866005A - Internet of things data acquisition management method and system, storage medium and terminal - Google Patents
Internet of things data acquisition management method and system, storage medium and terminal Download PDFInfo
- Publication number
- CN110866005A CN110866005A CN201910918090.5A CN201910918090A CN110866005A CN 110866005 A CN110866005 A CN 110866005A CN 201910918090 A CN201910918090 A CN 201910918090A CN 110866005 A CN110866005 A CN 110866005A
- Authority
- CN
- China
- Prior art keywords
- internet
- data
- things
- acquisition
- mode
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 36
- 238000000034 method Methods 0.000 claims abstract description 31
- 230000000007 visual effect Effects 0.000 claims abstract description 7
- 238000006243 chemical reaction Methods 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013480 data collection Methods 0.000 claims description 8
- 238000012800 visualization Methods 0.000 claims description 7
- 230000006855 networking Effects 0.000 claims 1
- 238000012545 processing Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 8
- 238000012986 modification Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000008447 perception Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- 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
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
- G06F16/258—Data format conversion from or to a database
-
- 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/29—Geographical information databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Remote Sensing (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a system for acquiring and managing data of an Internet of things, a storage medium and a terminal, and the method comprises the following steps: acquiring Internet of things data based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode; and managing the collected data of the Internet of things based on a visual interface. The data acquisition management method and system for the Internet of things, the storage medium and the terminal have various acquisition modes, and the problems of data repetition, uncertainty and the like caused by manual table establishment are effectively avoided.
Description
Technical Field
The invention relates to the technical field of Internet of things, in particular to a method and a system for acquiring and managing data of the Internet of things, a storage medium and a terminal.
Background
The Internet of things (IoT) is an important component of new-generation information technology and is also an important development stage of the "information-oriented" era. As the name implies, the Internet of things is the Internet with connected objects. Specifically, the internet of things is a network which connects sensors, controllers, machines, people, objects and the like together in a new mode by using communication technologies such as local networks or the internet and the like to form people-to-objects and object-to-object connection and realize informatization, remote management control and intellectualization. The internet of things is an extension of the internet, and comprises the internet and all resources on the internet, and is compatible with all applications of the internet, but all elements (all devices, resources, communication and the like) in the internet of things are personalized and privatized. The internet of things is widely applied to network fusion through communication perception technologies such as intelligent perception, identification technology and pervasive computing, and is also called as the third wave of development of the world information industry after computers and the internet.
In the prior art, when data acquisition of the internet of things is performed, a data table is usually created in a visualization tool, and then a file is imported into a corresponding table. This approach has the following disadvantages:
(1) if the data acquisition of the internet of things needs to be carried out for multiple times, multiple importing operations need to be executed, so that the operation is complicated;
(2) the data acquisition mode of the Internet of things is single, and the data can be acquired only in a file mode;
(3) in the process of importing data of the internet of things, information cannot be checked and corrected, so that the accuracy of the information cannot be guaranteed;
(4) a large number of internet of things perception sensors have address information, in the actual construction process, the requirement on coordinate addresses is high, conversion needs to be carried out in various coordinate systems, and the complexity is high.
Disclosure of Invention
In view of the above disadvantages of the prior art, an object of the present invention is to provide a method and a system for managing data acquisition of an internet of things, a storage medium, and a terminal, which have various acquisition modes and effectively avoid problems of data duplication, uncertainty, etc. caused by manual table establishment.
In order to achieve the above objects and other related objects, the present invention provides a data acquisition management method for internet of things, comprising the following steps: acquiring Internet of things data based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode; and managing the collected data of the Internet of things based on a visual interface.
In an embodiment of the present invention, when performing acquisition based on a file acquisition method, the method includes the following steps:
collecting data into a database based on an xlsx format or an xls format;
setting a main key and a plurality of fields, and automatically acquiring the field names in the form.
In an embodiment of the present invention, the method further includes modifying one or more of a name, a type, and a length of the field, and adding a comment to the field.
In one embodiment of the invention, when the collection is performed based on the file collection mode, the 84 coordinate and the Goods coordinate are recorded by default; after the files are collected, marking address fields and whether longitude and latitude fields exist or not; if the longitude and latitude exist, selecting the type of the longitude and latitude; if no address field or latitude and longitude field exists, no label exists; meanwhile, the address information is supported to be converted into the longitude and latitude information, and the longitude and latitude conversion is supported.
In an embodiment of the present invention, the database-based acquisition method includes the following steps:
selecting a resource type to be collected;
selecting a database type and a database address, setting a user name and a password, and connecting the database through the native JDBC;
selecting a data table to be collected, and defining the collection period of the database;
data is collected and stored based on the collection period.
In an embodiment of the present invention, when performing acquisition based on the API acquisition mode, the method includes the following steps:
selecting a resource type to be collected;
creating a data table, adding fields in the data table, defining field names, field comments, field types and field lengths, and setting addresses;
and collecting data in the document to the data table based on the API interface.
In an embodiment of the present invention, managing the collected data of the internet of things based on the visualization interface includes one or more of the following:
viewing a historical log of the data acquisition of the internet of things according to the name of the data of the internet of things and/or the creation time of the data of the internet of things;
data acquisition is continued for the same data resource of the Internet of things;
and modifying the collected data of the Internet of things.
Correspondingly, the invention provides an Internet of things data acquisition management system, which comprises an acquisition module and a management module;
the acquisition module is used for acquiring the data of the Internet of things based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode;
the management module is used for managing the collected data of the Internet of things based on a visual interface.
The invention provides a storage medium, wherein a computer program is stored on the storage medium, and when the program is executed by a processor, the Internet of things data acquisition management method is realized.
Finally, the invention provides a terminal comprising a processor and a memory;
the memory is used for storing a computer program;
the processor is used for executing the computer program stored in the memory so as to enable the terminal to execute the internet of things data acquisition management method.
As described above, the internet of things data acquisition management method and system, the storage medium and the terminal of the present invention have the following beneficial effects:
(1) the problems of data repetition, uncertainty and the like caused by manual table building firstly are avoided by setting fields and main keys during first acquisition;
(2) the collection mode is various, file collection, database collection and Application Programming Interface (API) collection are supported, and the problem of single collection mode is solved;
(3) the address can be converted into the longitude and latitude in the acquisition process, the conversion between the longitude and latitude is supported, and the system complexity is reduced;
(4) the data acquisition of the internet of things can be carried out through the visual page, so that the operation is simplified, and the operation difficulty of a user is reduced; the data can be collected into a database in a non-background mode and can be managed and displayed in a unified mode; collected data can be managed in a unified mode, operations such as modification and editing can be conducted, and subsequent management and maintenance are facilitated.
Drawings
Fig. 1 is a flowchart illustrating an internet of things data collection management method according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of an internet of things data acquisition management system according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of a terminal according to an embodiment of the invention.
Description of the element reference numerals
21 acquisition module
22 management module
31 processor
32 memory
Detailed Description
The embodiments of the present invention are described below with reference to specific embodiments, and other advantages and effects of the present invention will be easily understood by those skilled in the art from the disclosure of the present specification. The invention is capable of other and different embodiments and of being practiced or of being carried out in various ways, and its several details are capable of modification in various respects, all without departing from the spirit and scope of the present invention. It is to be noted that the features in the following embodiments and examples may be combined with each other without conflict.
It should be noted that the drawings provided in the following embodiments are only for illustrating the basic idea of the present invention, and the components related to the present invention are only shown in the drawings rather than drawn according to the number, shape and size of the components in actual implementation, and the type, quantity and proportion of the components in actual implementation may be changed freely, and the layout of the components may be more complicated.
The Internet of things data acquisition management method and system, the storage medium and the terminal have various acquisition modes, and the problems of data repetition, uncertainty and the like caused by manual table building in advance are avoided by setting fields and main keys during initial acquisition, so that the management is easy, and the user experience is greatly improved.
As shown in fig. 1, in an embodiment, the data collection and management method of the internet of things of the present invention includes the following steps:
and S1, acquiring the Internet of things data based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode.
Specifically, the data acquisition mode of the internet of things comprises a file acquisition mode, a database acquisition mode and an API acquisition mode, so that the diversification of data acquisition can be realized based on different data acquisition modes.
In an embodiment of the present invention, when performing acquisition based on a file acquisition method, the method includes the following steps:
a) data is collected into a database based on either the xlsx format or xls format.
Specifically, the file is uploaded to the database based on the xlsx format or xls format.
b) Setting a main key and a plurality of fields, and automatically acquiring the field names in the form.
Specifically, a plurality of fields are set in a table in xlsx format or xls format, and the name of each field can be automatically extracted. While the primary key is set. A primary key refers to a column or combination of columns whose value uniquely identifies each row in a table by which the physical integrity of the table is enforced. The main key is mainly used for being associated with the external keys of other tables and modifying and deleting the record. The primary key may be created by defining PRIMARY KEY constraints when creating or modifying a table. A table can only have one PRIMARY KEY constraint, and columns in the PRIMARY KEY constraint cannot accept null values. Since the PRIMARY KEY constraint ensures unique data, it is often used to define an identification column. The primary key has the following functions: 1) ensuring the integrity of the entity; 2) accelerating the operation speed of the database; 3) when a new record is added into the table, the DBMS can automatically check the primary key value of the new record, and the value is not allowed to be repeated with the primary key values of other records; 4) the DBMS automatically displays the records in the table in the order of the primary key values. If the primary key is not defined, the records in the table are displayed in the order in which the records were entered. If the main key is changed in the data updating process, automatic monitoring can be performed, and information replacement is performed, so that the accuracy of subsequent information input is facilitated.
Preferably, the name, type and length of each field can be modified, and each field can be annotated to facilitate understanding of semantics.
More preferably, the present invention defaults to entering 84 coordinates and Goods coordinates. When the collection is carried out based on the file collection mode, recording 84 coordinates and Goods coordinates by default; after the files are collected, marking address fields and whether longitude and latitude fields exist or not; if the longitude and latitude exist, selecting the type of the longitude and latitude; if no address field or latitude and longitude field exists, the label is not marked. If the latitude and longitude of other formats exist, the invention supports the conversion of the address into the latitude and longitude, supports the conversion of the latitude and longitude and also supports the conversion of the address information into the latitude and longitude information.
In an embodiment of the present invention, the database-based acquisition method includes the following steps:
a) the type of resource to be acquired is selected.
b) And selecting the type and address of the database, setting a user name and a password, and connecting the database through the native JDBC.
c) And selecting a data table to be acquired, and defining an acquisition period of the database.
d) Data is collected and stored based on the collection period.
In an embodiment of the present invention, when performing acquisition based on the API acquisition mode, the method includes the following steps:
a) the type of resource to be acquired is selected.
b) Creating a data table, adding fields in the data table, defining field names, field comments, field types and field lengths, and setting addresses.
c) And collecting data in the document to the data table based on the API interface.
Specifically, when data is collected, interface addresses, request modes, setting parameters and the like need to be provided, http requests are sent through tools such as postman and the like, and the data is collected into the data table according to document requirements.
And S2, managing the collected data of the Internet of things based on a visualization interface.
In an embodiment of the present invention, managing the collected data of the internet of things based on the visualization interface includes one or more of the following:
(1) screening review
Specifically, according to the name of the data of the internet of things and/or the creation time of the data of the internet of things, a historical log of data collection of the internet of things is checked.
(2) Supporting multiple acquisitions of data
Specifically, data collection can be continued for the same internet of things data resource, so that the data volume is increased.
(3) Supporting modification of data content
Specifically, the collected data of the internet of things is modified. Such as adding, deleting, or editing fields. And one or more combinations of field names, field types and field lengths are supported to be modified in the editing process.
As shown in fig. 2, in an embodiment, the data collection and management system of the internet of things of the present invention includes a collection module 21 and a management module 22.
The acquisition module 21 is configured to acquire the internet of things data based on a preset mode, where the preset mode includes one or more combinations of a file acquisition mode, a database acquisition mode, and an API acquisition mode.
Specifically, the data acquisition mode of the internet of things comprises a file acquisition mode, a database acquisition mode and an API acquisition mode, so that the diversification of data acquisition can be realized based on different data acquisition modes.
In an embodiment of the present invention, when performing acquisition based on a file acquisition method, the method includes the following steps:
a) data is collected into a database based on either the xlsx format or xls format.
Specifically, the file is uploaded to the database based on the xlsx format or xls format.
b) Setting a main key and a plurality of fields, and automatically acquiring the field names in the form.
Specifically, a plurality of fields are set in a table in xlsx format or xls format, and the name of each field can be automatically extracted. While the primary key is set. A primary key refers to a column or combination of columns whose value uniquely identifies each row in a table by which the physical integrity of the table is enforced. The main key is mainly used for being associated with the external keys of other tables and modifying and deleting the record. The primary key may be created by defining PRIMARY KEY constraints when creating or modifying a table. A table can only have one PRIMARY KEY constraint, and columns in the PRIMARY KEY constraint cannot accept null values. Since the PRIMARY KEY constraint ensures unique data, it is often used to define an identification column. The primary key has the following functions: 1) ensuring the integrity of the entity; 2) accelerating the operation speed of the database; 3) when a new record is added into the table, the DBMS can automatically check the primary key value of the new record, and the value is not allowed to be repeated with the primary key values of other records; 4) the DBMS automatically displays the records in the table in the order of the primary key values. If the primary key is not defined, the records in the table are displayed in the order in which the records were entered. If the main key is changed in the data updating process, automatic monitoring can be performed, and information replacement is performed, so that the accuracy of subsequent information input is facilitated.
Preferably, the name, type and length of each field can be modified, and each field can be annotated to facilitate understanding of semantics.
More preferably, the present invention defaults to entering 84 coordinates and Goods coordinates. When the collection is carried out based on the file collection mode, recording 84 coordinates and Goods coordinates by default; after the files are collected, marking address fields and whether longitude and latitude fields exist or not; if the longitude and latitude exist, selecting the type of the longitude and latitude; if no address field or latitude and longitude field exists, the label is not marked. If the latitude and longitude of other formats exist, the invention supports the conversion of the address into the latitude and longitude, supports the conversion of the latitude and longitude and also supports the conversion of the address information into the latitude and longitude information.
In an embodiment of the present invention, the database-based acquisition method includes the following steps:
a) the type of resource to be acquired is selected.
b) And selecting the type and address of the database, setting a user name and a password, and connecting the database through the native JDBC.
c) And selecting a data table to be acquired, and defining an acquisition period of the database.
d) Data is collected and stored based on the collection period.
In an embodiment of the present invention, when performing acquisition based on the API acquisition mode, the method includes the following steps:
a) the type of resource to be acquired is selected.
b) Creating a data table, adding fields in the data table, defining field names, field comments, field types and field lengths, and setting addresses.
c) And collecting data in the document to the data table based on the API interface.
Specifically, when data is collected, interface addresses, request modes, setting parameters and the like need to be provided, http requests are sent through tools such as postman and the like, and the data is collected into the data table according to document requirements.
The management module 22 is connected to the acquisition module 21 and configured to manage the acquired data of the internet of things based on a visualization interface.
In an embodiment of the present invention, managing the collected data of the internet of things based on the visualization interface includes one or more of the following:
(1) screening review
Specifically, according to the name of the data of the internet of things and/or the creation time of the data of the internet of things, a historical log of data collection of the internet of things is checked.
(2) Supporting multiple acquisitions of data
Specifically, data collection can be continued for the same internet of things data resource, so that the data volume is increased.
(3) Supporting modification of data content
Specifically, the collected data of the internet of things is modified. Such as adding, deleting, or editing fields. And one or more combinations of field names, field types and field lengths are supported to be modified in the editing process.
It should be noted that the division of the modules of the above system is only a logical division, and the actual implementation may be wholly or partially integrated into one physical entity, or may be physically separated. And these modules can be realized in the form of software called by processing element; or may be implemented entirely in hardware; and part of the modules can be realized in the form of calling software by the processing element, and part of the modules can be realized in the form of hardware. For example, the x module may be a processing element that is set up separately, or may be implemented by being integrated in a chip of the apparatus, or may be stored in a memory of the apparatus in the form of program code, and the function of the x module may be called and executed by a processing element of the apparatus. Other modules are implemented similarly. In addition, all or part of the modules can be integrated together or can be independently realized. The processing element described herein may be an integrated circuit having signal processing capabilities. In implementation, each step of the above method or each module above may be implemented by an integrated logic circuit of hardware in a processor element or an instruction in the form of software.
For example, the above modules may be one or more integrated circuits configured to implement the above methods, such as: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a Processing element scheduler code, the Processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
The storage medium of the invention stores a computer program, and the program is executed by a processor to realize the internet of things data acquisition management method. The storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic disk, U-disk, memory card, or optical disk.
As shown in fig. 3, in an embodiment, the terminal of the present invention includes: a processor 31 and a memory 32.
The memory 32 is used for storing computer programs.
The memory 32 includes: various media that can store program codes, such as ROM, RAM, magnetic disk, U-disk, memory card, or optical disk.
The processor 31 is connected to the memory 32, and is configured to execute the computer program stored in the memory 32, so that the terminal executes the internet of things data acquisition management method.
Preferably, the Processor 31 may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; the integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, or discrete hardware components.
In summary, the data acquisition management method and system, the storage medium and the terminal of the internet of things avoid the problems of data repetition, uncertainty and the like caused by manual table building firstly by setting the field and the main key during the first acquisition; the collection mode is various, file collection, database collection and API collection are supported, and the problem of single collection mode is solved; the address can be converted into the longitude and latitude in the acquisition process, the conversion between the longitude and latitude is supported, and the system complexity is reduced; the data acquisition of the internet of things can be carried out through the visual page, so that the operation is simplified, and the operation difficulty of a user is reduced; the data can be collected into a database in a non-background mode and can be managed and displayed in a unified mode; collected data can be managed in a unified mode, operations such as modification and editing can be conducted, and subsequent management and maintenance are facilitated. Therefore, the invention effectively overcomes various defects in the prior art and has high industrial utilization value.
The foregoing embodiments are merely illustrative of the principles and utilities of the present invention and are not intended to limit the invention. Any person skilled in the art can modify or change the above-mentioned embodiments without departing from the spirit and scope of the present invention. Accordingly, it is intended that all equivalent modifications or changes which can be made by those skilled in the art without departing from the spirit and technical spirit of the present invention be covered by the claims of the present invention.
Claims (10)
1. A data acquisition management method for the Internet of things is characterized by comprising the following steps: the method comprises the following steps:
acquiring Internet of things data based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode;
and managing the collected data of the Internet of things based on a visual interface.
2. The internet of things data acquisition management method according to claim 1, characterized in that: when the collection is carried out based on the file collection mode, the method comprises the following steps:
collecting data into a database based on an xlsx format or an xls format;
setting a main key and a plurality of fields, and automatically acquiring the field names in the form.
3. The internet of things data acquisition management method according to claim 2, characterized in that: further comprising modifying one or more of the name, type, length of the field, and adding comments to the field.
4. The internet of things data acquisition management method according to claim 2, characterized in that: when the collection is carried out based on the file collection mode, recording 84 coordinates and Goods coordinates by default; after the files are collected, marking address fields and whether longitude and latitude fields exist or not; if the longitude and latitude exist, selecting the type of the longitude and latitude; if no address field or latitude and longitude field exists, no label exists; meanwhile, the address information is supported to be converted into the longitude and latitude information, and the longitude and latitude conversion is supported.
5. The internet of things data acquisition management method according to claim 1, characterized in that: when the collection is carried out based on the database collection mode, the method comprises the following steps:
selecting a resource type to be collected;
selecting a database type and a database address, setting a user name and a password, and connecting the database through the native JDBC;
selecting a data table to be collected, and defining the collection period of the database;
data is collected and stored based on the collection period.
6. The internet of things data acquisition management method according to claim 1, characterized in that: when the acquisition is carried out based on the API acquisition mode, the method comprises the following steps:
selecting a resource type to be collected;
creating a data table, adding fields in the data table, defining field names, field comments, field types and field lengths, and setting addresses;
and collecting data in the document to the data table based on the API interface.
7. The internet of things data acquisition management method according to claim 1, characterized in that: managing the collected data of the internet of things based on a visualization interface comprises one or more of the following:
viewing a historical log of the data acquisition of the internet of things according to the name of the data of the internet of things and/or the creation time of the data of the internet of things;
data acquisition is continued for the same data resource of the Internet of things;
and modifying the collected data of the Internet of things.
8. The utility model provides a thing networking data acquisition management system which characterized in that: comprises an acquisition module and a management module;
the acquisition module is used for acquiring the data of the Internet of things based on a preset mode, wherein the preset mode comprises one or more combinations of a file acquisition mode, a database acquisition mode and an API acquisition mode;
the management module is used for managing the collected data of the Internet of things based on a visual interface.
9. A storage medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the internet of things data collection management method of any one of claims 1 to 7.
10. A terminal, characterized by: comprises a processor and a memory;
the memory is used for storing a computer program;
the processor is used for executing the computer program stored in the memory so as to enable the terminal to execute the internet of things data acquisition management method as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910918090.5A CN110866005A (en) | 2019-09-26 | 2019-09-26 | Internet of things data acquisition management method and system, storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910918090.5A CN110866005A (en) | 2019-09-26 | 2019-09-26 | Internet of things data acquisition management method and system, storage medium and terminal |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110866005A true CN110866005A (en) | 2020-03-06 |
Family
ID=69652161
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910918090.5A Pending CN110866005A (en) | 2019-09-26 | 2019-09-26 | Internet of things data acquisition management method and system, storage medium and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110866005A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113377851A (en) * | 2021-06-11 | 2021-09-10 | 上海妙一生物科技有限公司 | Data processing system and method |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1859196A (en) * | 2006-04-13 | 2006-11-08 | 吉林大学 | Telecommunication field network data acquisition processing system based on rule and realizing method |
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN107247721A (en) * | 2017-04-24 | 2017-10-13 | 江苏曙光信息技术有限公司 | Visualize collecting method |
| CN107958028A (en) * | 2017-11-16 | 2018-04-24 | 平安科技（深圳）有限公司 | Method, apparatus, storage medium and the terminal of data acquisition |
| CN108074030A (en) * | 2017-03-03 | 2018-05-25 | 哈尔滨安天科技股份有限公司 | A kind of safety analysis of assets information and Visualized management system and method |
| CN108197237A (en) * | 2017-12-29 | 2018-06-22 | 北京恒泰实达科技股份有限公司 | Visualization data, which collect, shows system |
| CN108366051A (en) * | 2018-01-25 | 2018-08-03 | 北京农业信息技术研究中心 | A kind of Internet of Things perception data shared system |
| CN108829731A (en) * | 2018-05-15 | 2018-11-16 | 吉贝克信息技术（北京）有限公司 | Data analysing method, system, computer readable storage medium and electric terminal |
| CN109492991A (en) * | 2018-10-18 | 2019-03-19 | 华南理工大学 | Distribution engineering builds intelligent comprehensive management system |
| CN109901889A (en) * | 2019-02-25 | 2019-06-18 | 快乐购有限责任公司 | The full link monitoring method of supporting business system O&M based on J2EE platform |
-
2019
- 2019-09-26 CN CN201910918090.5A patent/CN110866005A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1859196A (en) * | 2006-04-13 | 2006-11-08 | 吉林大学 | Telecommunication field network data acquisition processing system based on rule and realizing method |
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN102609769A (en) * | 2011-01-19 | 2012-07-25 | 上海中信信息发展股份有限公司 | Data acquisition tool and data acquisition method |
| CN108074030A (en) * | 2017-03-03 | 2018-05-25 | 哈尔滨安天科技股份有限公司 | A kind of safety analysis of assets information and Visualized management system and method |
| CN107247721A (en) * | 2017-04-24 | 2017-10-13 | 江苏曙光信息技术有限公司 | Visualize collecting method |
| CN107958028A (en) * | 2017-11-16 | 2018-04-24 | 平安科技（深圳）有限公司 | Method, apparatus, storage medium and the terminal of data acquisition |
| CN108197237A (en) * | 2017-12-29 | 2018-06-22 | 北京恒泰实达科技股份有限公司 | Visualization data, which collect, shows system |
| CN108366051A (en) * | 2018-01-25 | 2018-08-03 | 北京农业信息技术研究中心 | A kind of Internet of Things perception data shared system |
| CN108829731A (en) * | 2018-05-15 | 2018-11-16 | 吉贝克信息技术（北京）有限公司 | Data analysing method, system, computer readable storage medium and electric terminal |
| CN109492991A (en) * | 2018-10-18 | 2019-03-19 | 华南理工大学 | Distribution engineering builds intelligent comprehensive management system |
| CN109901889A (en) * | 2019-02-25 | 2019-06-18 | 快乐购有限责任公司 | The full link monitoring method of supporting business system O&M based on J2EE platform |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113377851A (en) * | 2021-06-11 | 2021-09-10 | 上海妙一生物科技有限公司 | Data processing system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| CN109997126B (en) | Event driven extraction, transformation, and loading (ETL) processing | |
| US11301419B2 (en) | Data retention handling for data object stores | |
| US11468103B2 (en) | Relational modeler and renderer for non-relational data | |
| WO2019095424A1 (en) | Data acquisition method and device, storage medium and terminal | |
| CN110119393B (en) | Code version management system and method | |
| CN111324610A (en) | Data synchronization method and device | |
| CN107301214B (en) | Data migration method and device in HIVE and terminal equipment | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN114741375A (en) | Rapid and automatic data migration system and method for multi-source heterogeneous database | |
| CN109800069B (en) | Method and device for realizing data management | |
| CN113190517B (en) | Data integration method and device, electronic equipment and computer readable medium | |
| CN110866005A (en) | Internet of things data acquisition management method and system, storage medium and terminal | |
| CN110704635A (en) | Conversion method and device for ternary group data in knowledge graph | |
| CN113722337B (en) | Service data determination method, device, equipment and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN114707953A (en) | Main data full life cycle management method, system, engine and storage medium | |
| CN114356945A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN111651531A (en) | Data import method, device, equipment and computer storage medium | |
| CN107861956B (en) | Method and device for inquiring data record of bayonet passing vehicle | |
| CN110928960B (en) | Data storage system, method, equipment and storage medium | |
| CN116521652B (en) | Method, system and medium for realizing migration of distributed heterogeneous database based on DataX | |
| CN117076515B (en) | Metadata tracing method and device in medical management system, server and storage medium | |
| CN117932098A (en) | Service request processing method, device and storage medium for history chat record | |
| CN116644081A (en) | Data operation method, device, electronic 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200306 |
|
| RJ01 | Rejection of invention patent application after publication |