CN116361397A - Method and device for separating time sequence data of electric power Internet of things into database and table - Google Patents
Method and device for separating time sequence data of electric power Internet of things into database and table Download PDFInfo
- Publication number
- CN116361397A CN116361397A CN202211564161.4A CN202211564161A CN116361397A CN 116361397 A CN116361397 A CN 116361397A CN 202211564161 A CN202211564161 A CN 202211564161A CN 116361397 A CN116361397 A CN 116361397A
- Authority
- CN
- China
- Prior art keywords
- time sequence
- database
- sequence data
- things
- server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000000926 separation method Methods 0.000 claims abstract description 9
- 238000003860 storage Methods 0.000 claims abstract description 9
- 238000005259 measurement Methods 0.000 claims description 30
- 230000006855 networking Effects 0.000 claims 1
- 238000007726 management method Methods 0.000 abstract description 41
- 238000013500 data storage Methods 0.000 abstract description 4
- 238000012544 monitoring process Methods 0.000 abstract description 2
- 238000012545 processing Methods 0.000 description 9
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000006978 adaptation Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000005422 blasting Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000010248 power generation Methods 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16Y—INFORMATION AND COMMUNICATION TECHNOLOGY SPECIALLY ADAPTED FOR THE INTERNET OF THINGS [IoT]
- G16Y10/00—Economic sectors
- G16Y10/35—Utilities, e.g. electricity, gas or water
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Accounting & Taxation (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Computing Systems (AREA)
Abstract
The invention discloses a method and a device for separating a time sequence database of an electric power Internet of things, which are used for separating the time sequence data reported by side equipment into database of a number DBj of a time sequence database server of a number Si, and writing the relation between the side equipment and the time sequence database server, database into a relation database table iot _index_relation; respectively writing the time sequence data after the database separation into different tables of the database according to the type of the time sequence data; when the time sequence data is queried, the numbers of the corresponding time sequence library server and database are found according to the iot _index_relation table, the corresponding table is found according to the type of the time sequence data, and then the numbers and the tables of the time sequence library server and database are spliced to query sql according to the specific queried service to realize query. According to the invention, the time sequence data storage and retrieval efficiency of the Internet of things management platform is improved, the distributed storage and rapid retrieval of the time sequence data of each professional device of the electric power Internet of things are supported, and a reliable data source is provided for the omnibearing operation monitoring of the device.
Description
Technical Field
The invention relates to a method and a device for separating a time sequence database and a table of an electric power internet of things, and belongs to the technical field of intelligent power grid data processing.
Background
The electric power internet of things is application of the internet of things in a smart grid, effectively integrates communication infrastructure resources and electric power system infrastructure resources, aims at accelerating intelligent transformation of an electric power system, improves utilization efficiency of the electric power system infrastructure, and provides important technical support for power generation, transformation, transmission, distribution and power utilization links of the power grid.
The electric power Internet of things management platform is an indispensable part of the electric power Internet of things, plays a role in supporting the up and down, is mainly used for realizing unified access, management and application of various specialized and various types of terminal equipment, provides standardized data and platform capability for an enterprise platform and a business system in an open interface mode, and mainly comprises the functions of connection management, equipment management, message processing, northbound interface service, platform management and the like.
Aiming at the fact that more and more devices are accessed by the current electric power Internet of things management platform, more and more data are reported, and the storage and retrieval efficiency of platform time sequence data face a great challenge. How to reduce the memory overhead caused by the sequential library server index is a technical problem that needs to be solved by the skilled person.
Disclosure of Invention
The purpose is as follows: in order to overcome the defects in the prior art, the invention provides a method and a device for separating a time sequence data database and a table of an electric power Internet of things.
The technical scheme is as follows: in order to solve the technical problems, the invention adopts the following technical scheme:
in a first aspect, a method for separating a time sequence database and a table of an electric power internet of things comprises the following steps:
step 1: and setting the serial number Si of a time sequence library server used by the electric power Internet of things management platform, wherein i epsilon N, N is an integer.
Step 2: setting the number DBj of the database configured by each time sequence library server, wherein j epsilon M, M is an integer.
Step 3: and writing the time sequence data reported by the side equipment into database of the number DBj of the time sequence library server of the number Si for library division, wherein i=deviceId% N, j=deviceId/10%M, wherein% is a modulo function, deviceId represents the serial number of the side equipment, deviceId is an integer, and the relation between the side equipment and the time sequence library server, database is written into a relation type database table iot _index_relation.
Step 4: and writing the time sequence data after the database separation into different tables of the database according to the type of the time sequence data.
Step 5: when the time sequence data is queried, the numbers of the corresponding time sequence library server and database are found according to the deviceId query iot _index_relation table, the corresponding table is found according to the type of the time sequence data, and then the numbers and the tables of the time sequence library server and database are spliced to query sql according to the specific queried service, so that the query is realized.
Preferably, the key fields of the relational database table iot _index_relation include: id. device_id, server_address, and database_name, wherein id represents the sequence number of the relational database table iot _index_relation, device_id represents the sequence number of the edge device, server_address represents the address consisting of the sequence library server number Si, and database_name represents the database number DBj.
Preferably, the table comprises: management data measurement of the side, service data measurement of the side, management data measurement of the side-managed end device, and service data measurement of the side-managed end device.
Preferably, n=2 and m=2.
Preferably, the timing library uses influxdb.
In a second aspect, a device for separating a time sequence database and a meter of an electric power internet of things comprises the following modules:
and a server setting module: the method is used for setting the serial number Si of a time sequence library server used by the electric power Internet of things management platform, wherein i epsilon N, N is an integer.
A database setting module: and the serial number DBj is used for setting the database configured by each time sequence library server, wherein j epsilon M, and M are integers.
And a library separation module: the database dividing method is used for writing time sequence data reported by the side equipment into database of a number DBj of a time sequence database server of a number Si, wherein i=deviceId% N, j=deviceId/10%M,% is a modulo function, deviceId represents the serial number of the side equipment, deviceId is an integer, and the relation between the side equipment and the time sequence database server, database is written into a relation type database table iot _index_relation.
The sub-table storage module: and the time sequence data after the database separation is written into different tables of the database according to the type of the time sequence data.
And a query module: when the method is used for inquiring time sequence data, the corresponding time sequence library server and database numbers are found according to the deviceId inquiry iot _index_relation table, the corresponding table is found according to the time sequence data types, the numbers and the table of the time sequence library server and database are spliced according to the specific inquired service inquiry sql, and inquiry is achieved.
Preferably, the key fields of the relational database table iot _index_relation include: id. device_id, server_address, and database_name, wherein id represents the sequence number of the relational database table iot _index_relation, device_id represents the sequence number of the edge device, server_address represents the address consisting of the sequence library server number Si, and database_name represents the database number DBj.
Preferably, the table comprises: management data measurement of the side, service data measurement of the side, management data measurement of the side-managed end device, and service data measurement of the side-managed end device.
Preferably, n=2 and m=2.
Preferably, the timing library uses influxdb.
The beneficial effects are that: according to the method and the device for separating the time sequence data of the electric power Internet of things, provided by the invention, based on the time sequence data reported by the side equipment of the electric power Internet of things, the widely used open source time sequence database influxdb in the industry is taken as an example, the method for separating the time sequence data is designed, the time sequence data storage and retrieval efficiency of an Internet of things management platform is improved, the distributed storage and quick retrieval of the time sequence data of each professional equipment of the electric power Internet of things are supported, and a reliable data source is provided for the omnibearing operation monitoring of the equipment.
Drawings
Fig. 1 is a schematic diagram of a traffic data flow according to the present invention.
Detailed Description
The invention will be further described with reference to specific examples.
According to the method for separating the time sequence data of the electric power Internet of things into the time sequence databases and the table, a certain number of time sequence database servers can be expanded through the Internet of things management platform to match mass time sequence data storage and statistical analysis of each professional terminal device in the electric power Internet of things at present. The method comprises the following steps:
step 1, numbering N time sequence library servers used by a platform: such as Si (i e N, n=2).
Step 2, configuring M databases by each time sequence library server: such as DBj (j e M, m=2).
Step 3, the time sequence data processing service divides the database by writing the data reported by the edge device into the j=deviceid/10% m databases of the i=deviceid% N time sequence database server, and writes the relationship between the edge device and the time sequence database server, database into the relationship database table iot _index_relation, as shown in table 1 below.
| id | device_id | server_address | database_name |
| 1 | 11 | http://S1:port | DB1 |
| 2 | 12 | http://S0:port | DB0 |
| 3 | 23 | http://S1:port | DB1 |
Table 1 relational database table iot _index_relation
The deviceId is a distributed ID maintained by the Internet of things management platform, the ID is globally unique and monotonically increasing, and the method for dividing the database into tables is relatively simple and light in weight, and meanwhile, the distribution equilibrium can be ensured.
Step 4, the time sequence data processing service writes the data reported by the edge devices into a time sequence base according to the edge/end and service/management, wherein the data reported by each edge device can be divided into the following four tables (measurement):
management data measurement of edge (edge_management)
Business data measurement of edge (edge_service)
Management data measurement (edge_terminal_management) of an end device for edge management
Business data measurement (edge_terminal_service) of end device for edge management
Such as: the service data of the edge1 equipment management end equipment is written into an edge1_terminal_service table of DB1 of S1;
and 5, when the time sequence data is queried, the corresponding time sequence library server and database are found according to the deviceId query iot _index_relation table, and the quick and accurate query is realized according to the queried specific service splicing query sql.
If the service data of the end device managed by the side device (deviceid=11) is queried, the query sql is:
select content from S1.DB1. 11_terminal_service where ……；
according to the time sequence data database and table dividing device for the electric power Internet of things, a certain number of time sequence database servers can be expanded through the Internet of things management platform to match mass time sequence data storage and statistical analysis of professional terminal equipment in the electric power Internet of things at present. The device comprises the following modules:
and a server setting module: the method is used for numbering N time sequence library servers used by the platform: such as Si (i e N, n=2).
A database setting module: m databases are configured for each timing base server: such as DBj (j e M, m=2).
And a library separation module: the j=deviceid/10% m databases of the i=deviceid% N time base servers for the time series data processing service to divide the data reported by the edge device into the databases, and the relationship between the edge device and the time base server, database is written into the relational database table iot _index_relation, as shown in table 1 below.
| id | device_id | server_address | database_name |
| 1 | 11 | http://S1:port | DB1 |
| 2 | 12 | http://S0:port | DB0 |
| 3 | 23 | http://S1:port | DB1 |
Table 1 relational database table iot _index_relation
The sub-table storage module: the data reported by each edge device can be divided into the following four tables (measurement) according to the edge/end and service/management:
management data measurement of edge (edge_management)
Business data measurement of edge (edge_service)
Management data measurement (edge_terminal_management) of an end device for edge management
Business data measurement (edge_terminal_service) of end device for edge management
Such as: the service data of the edge1 equipment management end equipment is written into an edge1_terminal_service table of DB1 of S1;
and a query module: when the method is used for inquiring time sequence data, the corresponding time sequence library server and database are found according to the deviceId inquiry iot _index_relation table, and the quick and accurate inquiry is realized according to the specific service splice inquiry sql of the inquiry.
If the service data of the end device managed by the side device (deviceid=11) is queried, the query sql is:
select content from S1.DB1. 11_terminal_service where ……；
examples:
in the electric power internet of things, the time sequence data mainly comprises the following categories:
1) Edge proxy device, edge framework running state data.
2) Edge application/container run state data.
3) Real-time service data collected by the terminal equipment.
4) Historical messages of platform device interactions.
When the data is written into the time sequence library, some service attribute field, such as specialty, region, equipment ID, APP/container name and the like, can be written based on the service characteristics. For later queries or statistics, these field are often set to tag to enable conditional retrieval.
With the increase of business complexity, tags will be more and more, and services per library (databases) will be more and more based on the design principle of influxdb. The series are similar to the index of the relational database, and in order to improve the retrieval efficiency, the series are loaded into the memory, so that the running memory usage of the inflixdb server is gradually increased. Meanwhile, all time sequence data are written into the same table of the same library, and the query efficiency is greatly reduced along with the increase of the data quantity. If the time sequence data are not subjected to the database and table division design, one tag (value reaches 10w level) can be used for blasting one 64G influxdb server, and the condition query time based on the one tag can reach more than 10 seconds, so that the service stability and the use experience are seriously affected.
As shown in fig. 1, a method for separating a time sequence database and a table of an electric power internet of things comprises the following steps:
step 1: the platform uses 2 influxdb servers: influxdb1, infuxdb 2.
Step 2: two databases are set per influxdb server: database1, database2.
Step 3: and (3) carrying out database separation on the database process of which influxdb server is written into the edge equipment through a load balancing algorithm, and maintaining the relationship between the edge equipment and the influxdb server through a relational database.
Step 4: the reported data are classified according to the side/end and service/management, and the reported data of each side device can be divided into four measurements as follows:
management data measurement of edge (edge_management)
Business data measurement of edge (edge_service)
End device management data management (edge_terminal_management) for edge management
End device service data (measurement edge_terminal_service) for edge management of (1)
The method is mainly used for dividing the data written into the time sequence library by the equipment accessed through the Internet of things management platform in the electric power Internet of things into the library and the table through load balancing and data characteristics, so that the memory overhead caused by self-building index of the time sequence library server in actual use is reduced, and meanwhile, the retrieval efficiency of the data is effectively improved.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The foregoing is only a preferred embodiment of the invention, it being noted that: it will be apparent to those skilled in the art that various modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the invention.
Claims (10)
1. A method for separating time sequence data of an electric power internet of things into a database and a table is characterized by comprising the following steps: the method comprises the following steps:
step 1: setting the serial number Si of a time sequence library server used by the electric power Internet of things management platform, wherein i epsilon N, N is an integer;
step 2: setting a database number DBj of each time sequence library server, wherein j epsilon M, M is an integer;
step 3: the method comprises the steps of writing time sequence data reported by side equipment into database of a number DBj of a time sequence library server of a number Si for library division, wherein i=deviceId% N, j=deviceId/10%M,% is a modulo function, deviceId represents the serial number of the side equipment, deviceId is an integer, and the relation between the side equipment and the time sequence library server, database is written into a relation type database table iot _index_relation;
step 4: respectively writing the time sequence data after the database separation into different tables of the database according to the type of the time sequence data;
step 5: when the time sequence data is queried, the numbers of the corresponding time sequence library server and database are found according to the deviceId query iot _index_relation table, the corresponding table is found according to the type of the time sequence data, and then the numbers and the tables of the time sequence library server and database are spliced to query sql according to the specific queried service, so that the query is realized.
2. The method for separating the time sequence data of the electric power internet of things into the database and the table according to claim 1, which is characterized in that: the key fields of the relational database table iot _index_relation include: id. device_id, server_address, and database_name, wherein id represents the sequence number of the relational database table iot _index_relation, device_id represents the sequence number of the edge device, server_address represents the address consisting of the sequence library server number Si, and database_name represents the database number DBj.
3. The method for separating the time sequence data of the electric power internet of things into the database and the table according to claim 1, which is characterized in that: the table includes: management data measurement of the side, service data measurement of the side, management data measurement of the side-managed end device, and service data measurement of the side-managed end device.
4. The method for separating the time sequence data of the electric power internet of things into the database and the table according to claim 1, which is characterized in that: n=2, m=2.
5. The method for separating the time sequence data of the electric power internet of things into the database and the table according to claim 1, which is characterized in that: the timing library employs influxdb.
6. The utility model provides an electric power thing networking time sequence data divides base to divide table device which characterized in that: the device comprises the following modules:
and a server setting module: the method comprises the steps of setting a serial number Si of a time sequence library server used by an electric power Internet of things management platform, wherein i is E N, and N is an integer;
a database setting module: the method comprises the steps of setting a number DBj of a database configured by each time sequence library server, wherein j epsilon M, M is an integer;
and a library separation module: the method comprises the steps of writing time sequence data reported by side equipment into database of a number DBj of a time sequence library server of a number Si for library division, wherein i=deviceId% N, j=deviceId/10%M,% is a modulo function, deviceId represents the serial number of the side equipment, deviceId is an integer, and the relation between the side equipment and the time sequence library server, database is written into a relation type database table iot _index_relation;
the sub-table storage module: the method comprises the steps of respectively writing time sequence data after library separation into different tables of database according to the types of the time sequence data;
and a query module: when the method is used for inquiring time sequence data, the corresponding time sequence library server and database numbers are found according to the deviceId inquiry iot _index_relation table, the corresponding table is found according to the time sequence data types, the numbers and the table of the time sequence library server and database are spliced according to the specific inquired service inquiry sql, and inquiry is achieved.
7. The power internet of things time sequence data base and table dividing device according to claim 6, wherein: the key fields of the relational database table iot _index_relation include: id. device_id, server_address, and database_name, wherein id represents the sequence number of the relational database table iot _index_relation, device_id represents the sequence number of the edge device, server_address represents the address consisting of the sequence library server number Si, and database_name represents the database number DBj.
8. The power internet of things time sequence data base and table dividing device according to claim 6, wherein: the table includes: management data measurement of the side, service data measurement of the side, management data measurement of the side-managed end device, and service data measurement of the side-managed end device.
9. The power internet of things time sequence data base and table dividing device according to claim 6, wherein: n=2, m=2.
10. The power internet of things time sequence data base and table dividing device according to claim 6, wherein: the timing library employs influxdb.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211564161.4A CN116361397B (en) | 2022-12-07 | 2022-12-07 | Method and device for separating time sequence data of electric power Internet of things into database and table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211564161.4A CN116361397B (en) | 2022-12-07 | 2022-12-07 | Method and device for separating time sequence data of electric power Internet of things into database and table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116361397A true CN116361397A (en) | 2023-06-30 |
| CN116361397B CN116361397B (en) | 2024-07-16 |
Family
ID=86925902
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211564161.4A Active CN116361397B (en) | 2022-12-07 | 2022-12-07 | Method and device for separating time sequence data of electric power Internet of things into database and table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116361397B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117376380A (en) * | 2023-10-10 | 2024-01-09 | 国电南瑞科技股份有限公司 | Multi-cluster-mode Internet of things management platform and data processing method thereof |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016188280A1 (en) * | 2015-05-25 | 2016-12-01 | 阿里巴巴集团控股有限公司 | Write-in method and device for database sub-tables |
| CN107622079A (en) * | 2017-07-28 | 2018-01-23 | 阿里巴巴集团控股有限公司 | Data storage, querying method and device |
| CN107967284A (en) * | 2016-10-20 | 2018-04-27 | 北京京东尚科信息技术有限公司 | Method and apparatus for storing, inquiring about sequence information |
| CN109522311A (en) * | 2018-11-20 | 2019-03-26 | 北京锐安科技有限公司 | Date storage method, device, server and storage medium |
| CN114090530A (en) * | 2021-11-23 | 2022-02-25 | 中国银行股份有限公司 | Log summarizing and inquiring method and device under distributed architecture |
-
2022
- 2022-12-07 CN CN202211564161.4A patent/CN116361397B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016188280A1 (en) * | 2015-05-25 | 2016-12-01 | 阿里巴巴集团控股有限公司 | Write-in method and device for database sub-tables |
| CN107967284A (en) * | 2016-10-20 | 2018-04-27 | 北京京东尚科信息技术有限公司 | Method and apparatus for storing, inquiring about sequence information |
| CN107622079A (en) * | 2017-07-28 | 2018-01-23 | 阿里巴巴集团控股有限公司 | Data storage, querying method and device |
| CN109522311A (en) * | 2018-11-20 | 2019-03-26 | 北京锐安科技有限公司 | Date storage method, device, server and storage medium |
| CN114090530A (en) * | 2021-11-23 | 2022-02-25 | 中国银行股份有限公司 | Log summarizing and inquiring method and device under distributed architecture |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117376380A (en) * | 2023-10-10 | 2024-01-09 | 国电南瑞科技股份有限公司 | Multi-cluster-mode Internet of things management platform and data processing method thereof |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116361397B (en) | 2024-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110022226B (en) | Object-oriented data acquisition system and acquisition method | |
| CN111552687B (en) | Time sequence data storage method, query method, device, equipment and storage medium | |
| CN109063196B (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN107145537B (en) | Table data importing method and system | |
| CN108052635A (en) | A kind of heterogeneous data source unifies conjunctive query method | |
| CN107330098B (en) | Query method, computing node and query system for custom report | |
| CN104331435A (en) | Low-influence high-efficiency mass data extraction method based on Hadoop big data platform | |
| CN110222029A (en) | A kind of big data multidimensional analysis computational efficiency method for improving and system | |
| CN116361397B (en) | Method and device for separating time sequence data of electric power Internet of things into database and table | |
| CN104599032A (en) | Distributed memory power grid construction method and system for resource management | |
| JP7313382B2 (en) | Frequent Pattern Analysis of Distributed Systems | |
| CN112686418B (en) | Method and device for predicting performance aging | |
| CN111125199B (en) | Database access method and device and electronic equipment | |
| CN112579578A (en) | Metadata-based data quality management method, device and system and server | |
| CN115033646A (en) | Method for constructing real-time warehouse system based on Flink and Doris | |
| CN109871380B (en) | Crowd pack application method and system based on Redis | |
| CN113761390B (en) | Method and system for analyzing attribute intimacy | |
| CN113360576A (en) | Power grid mass data real-time processing method and device based on Flink Streaming | |
| CN112667747A (en) | Dynamic configuration multi-database distributed persistence method supporting user-defined plug-in | |
| CN109769027B (en) | Message pushing method, device and equipment | |
| CN112817930A (en) | Data migration method and device | |
| CN113297274B (en) | Signing data query method and system | |
| CN115391286A (en) | Link tracking data management method, device, equipment and storage medium | |
| CN101996246B (en) | Method and system for instant indexing | |
| CN112434010A (en) | Interaction method for master station database of electricity consumption information 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 |