CN111966695B - Time sequence database system for oil and gas field production - Google Patents
Time sequence database system for oil and gas field production Download PDFInfo
- Publication number
- CN111966695B CN111966695B CN202011143186.8A CN202011143186A CN111966695B CN 111966695 B CN111966695 B CN 111966695B CN 202011143186 A CN202011143186 A CN 202011143186A CN 111966695 B CN111966695 B CN 111966695B
- Authority
- CN
- China
- Prior art keywords
- data
- time sequence
- index
- time
- file
- 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
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 27
- 238000005259 measurement Methods 0.000 claims abstract description 15
- 238000013144 data compression Methods 0.000 claims abstract description 11
- 238000013500 data storage Methods 0.000 claims abstract description 9
- 230000002159 abnormal effect Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000000034 method Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 230000006835 compression Effects 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 239000003129 oil well Substances 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- 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/2477—Temporal data queries
-
- 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/02—Agriculture; Fishing; Forestry; Mining
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Animal Husbandry (AREA)
- Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Agronomy & Crop Science (AREA)
- Mathematical Physics (AREA)
- Marine Sciences & Fisheries (AREA)
- Mining & Mineral Resources (AREA)
- Fuzzy Systems (AREA)
- Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the field of oil field production data processing, and discloses a time sequence database system applied to oil production, which comprises: at least one networked computer; the computer runs a software data acquisition module, a data storage module, a data compression module and a data early warning module of the system, the modules are sequentially connected, the data storage module divides time sequence data into a plurality of data files according to a preset time period for storage, each data file is divided into a plurality of data blocks, an index file is established, keys are established in the index file based on different combinations of measurement and index attributes of the time sequence data, the data blocks corresponding to the time sequence data to be stored or inquired are finally found through values corresponding to the keys, and the time sequence data of a plurality of data sources are processed in a multi-window mode through establishing an early warning model. The invention reduces the storage consumption, reduces the complexity of operation and ensures the reliability of the early warning result.
Description
Technical Field
The invention relates to the field of oil field production data processing, in particular to a time sequence database system for oil and gas field production.
Background
With the continuous promotion of the internet in the field of oil and gas field production, an oil well production monitoring platform generates more and more data based on time sequences, the data are called as time sequence data, each large oil and gas field is researched and utilizes the time sequence data to carry out data mining, and an alarm early warning function module is perfected, so that automatic early warning and advanced early warning are realized, and the intelligent levels of production control, production analysis and production decision are improved.
In the oil and gas field production process, need a large amount of sensors to a detection object to monitor and detect, mean that need save a large amount of data, along with index object's accumulation, a large amount of historical data need be saved to the database system, if improper to data processing, will cause a large amount of storage device wasting of resources. Various abnormal conditions sometimes occur to a detection object, and the early warning reliability of the abnormal conditions in the prior art is not high.
The existing database in the field of oil and gas field production has the technical problems of high storage consumption, poor writing performance and low query efficiency, a common early warning model for early warning of time sequence data has the technical problems of single data source of model analysis and consumption of a large amount of service computing resources in the process of model analysis, and in the process of actual production and operation, service early warning is complex and variable.
Disclosure of Invention
The invention aims to at least solve one of the technical problems in the prior art, and provides a time sequence database system for oil-gas field production, which can save the cost of server storage resources, improve the data query efficiency and ensure the reliability of an early warning result.
According to a first aspect of the present invention there is provided a time series database system for oil and gas field production, the system comprising:
at least one networked computer;
the computer runs a software data acquisition module, a data storage module, a data compression module and a data early warning module of the system, the modules are connected in sequence, and the attributes of the time sequence data comprise measurement, index, period, timestamp and data value attributes;
the data acquisition module is used for acquiring time sequence data in oil and gas field production and establishing a plurality of data sources;
the data storage module is used for dividing the time sequence data into a plurality of data files according to a preset time period for storage, dividing each data file into a plurality of data blocks, establishing an index file, numbering the data files and the index file according to the timestamps, constructing keys in the index file based on different combinations of the measurement and index attributes of the time sequence data, finding the storage position of the corresponding index of the time sequence data of each combination in the index file through the value corresponding to the key, pointing to the storage position of the data block of the time sequence data of each combination in different data files, and finally finding the storage position of the data file corresponding to the time sequence data to be stored or inquired by calculating the number of the data file;
the data compression module is used for sequentially compressing all the data files before a preset time point t0 into compressed files;
the data early warning module is used for constructing an early warning model, analyzing the early warning model into a plurality of operation windows according to different combinations of the measurement and index attributes of the time sequence data of the data sources, carrying out model settlement on the data sources related to the operation windows in each settlement period, and judging whether to send out early warning information according to set judgment scores.
According to the first aspect of the present invention, the data compression module, configured to sequentially compress all the data files before the preset time point t0 into compressed files, includes: and compressing each data file before the preset time point t0 into the compressed file according to the data blocks in the data file.
According to the first aspect of the present invention, when time series data to be stored spans a plurality of data files in time, the time series data is divided into a plurality of segments according to the time period before being written, if a segment occupies a part of the data block, the data block pointed by the index is located, and then the data point in the segment is stored in the data block, if the segment spans the entire block, the data of the segment is added to different data files, and the storage location pointed by the corresponding index is recorded.
The embodiment of the invention at least has the following beneficial technical effects: aiming at the data particularity in the field of oil and gas field production, a time sequence database is divided into data blocks for storage, so that the storage consumption is reduced, keys in an index file are constructed according to the measurement and index attributes of time sequence data, a large amount of data can be stored, flexible condition query is supported, and the query efficiency of time sequence data is improved; meanwhile, the invention adopts an early warning model construction scheme of each model with multiple data sources, combines multi-index and multi-algorithm operation and windowing processing, combines and judges cooperatively, reduces the complexity of operation and ensures the reliability of an early warning result.
Drawings
The invention is further described below with reference to the accompanying drawings and examples;
FIG. 1 is a logical block diagram of a time-series database system for oil and gas field production according to an embodiment of the present invention;
FIG. 2 is a schematic diagram illustrating the storage of time series data in a data file of a time series database according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a logical relationship among an early warning model, a data source, and an operation window in a time series database according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to the present preferred embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to like elements throughout.
In the description of the present invention, the meaning of a plurality of means is one or more, the meaning of a plurality of means is two or more, and larger, smaller, larger, etc. are understood as excluding the number, and larger, smaller, inner, etc. are understood as including the number.
The time sequence database of the invention is applied to the field of oil and gas field production, referring to fig. 1, which is a logic structure diagram of the time sequence database system in the embodiment of the invention, and provides a time sequence database system applied to oil and gas field production, the system comprises: at least one networked computer; the system comprises a software data acquisition module, a data storage module, a data compression module and a data early warning module which are operated on a computer, wherein the modules are sequentially connected, and the attributes of time sequence data comprise measurement, index, period, timestamp and index data value attributes.
In the embodiment of the invention, the data acquisition module is used for acquiring time sequence data in oil-gas field production and establishing a plurality of data sources. The time series data can be obtained by a method including, but not limited to, a time series database, a relational database, a polling data service, a manual import, etc.
It is to be understood that the time-series data is a time series recorded in chronological order, which varies depending on time, and the degree of variation of which data can be reflected by a numerical value. The acquired time sequence data source can be time sequence data acquired at fixed frequency in the field of oil and gas field production. The time series data has at least the following properties, Metric, Metric Target, period, timestamp Stamp, and the Metric data value itself.
The Metric of the time series data in the embodiment of the application represents the attribution of the data; target is the measured value of the designated frequency acquisition, and the period refers to the period of the measured value acquisition. For example: the instantaneous flow rate of the oil pipeline G1 collected once per minute is 100L/min; the oil pipeline G1 is a measurement attribute, the instantaneous flow is an index attribute, the period per minute is a period, and 100L/min is a data value of an index. The timestamp Stamp is the total number of milliseconds from greenwich time 1970, 00 h 00 s 000 ms (beijing time: 1970, 01, 08 h 00 s 000 ms) to the present. The timing data of embodiments of the present application may have a number of different metrics and indicators.
In the time sequence database system, a data storage module is used for dividing time sequence data into a plurality of data files for storage according to a preset time period, dividing each data file into a plurality of data blocks, establishing an index file, numbering the data files and the index files according to the timestamps, constructing keys in the index files based on different combinations of measurement and index attributes of the time sequence data, finding the storage position of the time sequence data of each combination in the index file through the value corresponding to the key, pointing to the storage position of the data block of the time sequence data of each combination in different data files, and finally finding the storage position in the data file corresponding to the time sequence data to be stored or inquired by calculating the number of the data file.
In the embodiment of the invention, when the time sequence data is written into the database system, the acquired time sequence data is divided into a plurality of data files for storage in the database according to a certain time period, and each data file is numbered according to the timestamp, so that the position of the data file can be conveniently searched in the following process. Since the time series data can have a plurality of metrics and indexes, and the metrics and indexes have a plurality of different combination modes, each data file to be stored is divided into a plurality of data blocks, each data block only stores the index data value of the time series data under one combination of the metrics and the indexes in the time period, and the time period refers to the time period in which the data file to be stored is located. And the number of the data blocks in each data file is the combined number of the measurement indexes.
Referring to fig. 2, a schematic diagram of storage of time series data in a data file in an embodiment of the present invention is shown, where a Block-X axis represents a data Block in the data file, a TS-Y axis represents a data file number, R represents a data file area, and Values-Z represents each data value point in the data Block.
In the time sequence database, an index file is established corresponding to the plurality of data files, and the index file records the storage positions of the time sequence data in the data files. In the embodiment of the invention, one index file maps N data files, wherein N is a positive integer. In the index file, an index is established for each data block in the data file, a key is constructed by utilizing the attribute measurement and the index of the time sequence data, and the value corresponding to the key is the storage address of the index file after the combination of each corresponding measurement and index. Because each data block correspondingly stores the index data value of the time series data under the combination mode of the metric and the index, the data blocks of the metric and the index combination in different time periods can be found through the keys in the index file, and the data blocks are respectively positioned in a plurality of data files in different time periods.
As a specific example of the embodiment of the present invention, for example, after time series data is written into a data file of a database, the time series data in the data file 1 includes metric attributes M1 and M2 and metric attributes T1 and T2, and then the combination of metrics and metrics includes four combination modes M1T1, M1T2, M2T1 and M2T2, so that the data file 1 includes four data blocks, which are respectively used for storing metric data values of time series data of different combinations. The time period of this data file 1 is T1, and accordingly, the time-series data under the M1T1 combination is stored in the temporally successive data file 2 for the time period T2, and so on.
In the embodiment of the invention, the time sequence data is divided into different data files for storage, and the data files are numbered, so that the appointed data file can be quickly positioned. Assuming that the time interval of the data area is 7 days, data of 1970-01-0100: 00:00:000 to 1970-01-0700: 00:00:000 is divided into one data area, i.e., one data file. A data file number is then assigned based on the time stamp.
For example, the data file number is obtained by dividing the millisecond time stamp at the beginning of the data area by the integer part of the millisecond time difference of 7 days.
In an embodiment of the present invention, the index file number is calculated by taking a difference between the current timestamp Stamp and greenwich time Stamp0 (00 min 00 s 000 ms 00 h 01/01 h 1970), and the index file number is obtained by rounding down (floor) a result of dividing the timestamp difference by the total number of millisecond timestamps of N × time interval.
For example, when N is 8 and the time interval is 7 days, the index file number is: floor ((Stamp-Stamp 0)/(8 × 7 × 86400000)).
In one embodiment of the invention, the time series data may be stored in bulk to a time series database. When time sequence data to be stored cross a plurality of data files in time, dividing the time sequence data into a plurality of sections according to the time period before writing, if a certain section occupies a part of the data block, locating the index to find the data block pointed by the index, storing the data point in the certain section into the data block, if the section crosses the whole block, adding the data of the section into different data files, and recording the storage position pointed by the corresponding index.
For example, one storage task is to store voltage index time series data from a point M18 to a point 9, and assuming that the time interval of the data file, i.e. the above time period is 30 minutes and the time series data period Beat is 1 minute, the data to be stored spans two areas, the data from the point 8 to the point 8 is divided into data blocks of one data area by means of data partitioning, the data from the point 8 to the point 9 is divided into data blocks of another data area, and corresponding indexes are searched and stored in corresponding data files, respectively.
As time is accumulated, the data storage capacity in the time series database is increased, and the time series data often has the characteristic of poor applicability of historical data, so that necessary compression processing needs to be performed on the time series data accumulated in history.
In view of the above technical problem, the database in the embodiment of the present invention further includes a data compression module, configured to sequentially compress all the data files before the preset time point t0 into compressed files.
Specifically, each data file in the database contains a plurality of data blocks, and when the data file before t0 is compressed, each data file is compressed by using the existing data compression algorithm with the data blocks in the data file as units. In the present embodiment, the compression algorithm used is a data compression algorithm in the prior art, including but not limited to deflate, bzip2, etc.
The embodiment of the invention also comprises a process of early warning the abnormal data condition of the data source. Therefore, the time sequence database system comprises a data early warning module for constructing an early warning model, analyzing the early warning model into a plurality of operation windows according to different combinations of the measurement and index attributes of the time sequence data of a plurality of data sources, performing model settlement on the data sources related to the operation windows in each settlement period, and judging whether to send out early warning information according to set judgment.
It will be appreciated that the early warning model may be a static data model, with settlement periods, early warning objects, data source(s), and decision score attributes set.
The settlement period refers to that the early warning model settles according to a fixed period and judges whether to send out an early warning message or not. For example, every 30 minutes, it is judged whether or not the average flow rate of the last 1 hour is abnormal. The early warning object refers to an entity object corresponding to the early warning model, such as a device, an oil well and the like, and after the model is successfully judged, an alarm message aiming at the object is sent out. The judgment score is the required score for the early warning model settlement success.
As a specific embodiment of the present invention, the early warning model is associated with time series data of a plurality of data sources, weight scores are respectively set for all the data sources in the model, and are used to determine whether the data is abnormal, if the data is normal, the weight score of the data source is 0, if the data is abnormal, a preset weight score is taken, after the abnormal condition of all the data sources in the model is determined, the weight scores of all the data sources are accumulated, if the accumulated weight score exceeds the determination score of the model, an early warning message is sent, otherwise, no early warning message is sent.
For example, the model decision score 100 is set to 60, 40, and 40 for the data source 1, the data source 2, and the data source 3, respectively. And accumulating scores of the data sources with successful settlement, and sending out an early warning message if the total score exceeds the judgment score. Therefore, the data source 1+2 or the data source 1+3 will send out the early warning, and the data source 2+3 will not send out the early warning. The meaning of the early warning of the combination of a plurality of data sources is realized, and the reliability of the early warning message can be greatly improved by depending on the logic judgment of the plurality of data sources.
In the embodiment of the present invention, if there are multiple pre-warning models, for example, 2 pre-warning models, the logical relationship among the pre-warning models, the data source, and the operation window is as shown in fig. 3. It should be noted that the calculation window γ in fig. 3 may be used when the models a and B perform settlement at the same time, that is, as described above, the calculation window may be associated with all data sources having the same Metric and the same index Target, so that system memory resources are saved, which is more significant when the number of the early warning models is large.
The embodiments of the present invention have been described in detail with reference to the accompanying drawings, but the present invention is not limited to the above embodiments, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention.
Claims (3)
1. A time series database system for oil and gas field production, comprising:
at least one networked computer;
the computer runs a software data acquisition module, a data storage module, a data compression module and a data early warning module of the system, the modules are connected in sequence, and the attributes of the time sequence data comprise measurement, index, period, timestamp and data value attributes;
the data acquisition module is used for acquiring time sequence data in oil and gas field production and establishing a plurality of data sources;
the data storage module is used for dividing the time sequence data into a plurality of data files according to a preset time period for storage, dividing each data file into a plurality of data blocks, establishing an index file, numbering the data files and the index file according to the timestamps, constructing keys in the index file based on different combinations of the measurement and index attributes of the time sequence data, finding the storage position of the corresponding index of the time sequence data of each combination in the index file through the value corresponding to the key, pointing to the storage position of the data block of the time sequence data of each combination in different data files, and finally finding the storage position of the data file corresponding to the time sequence data to be stored or inquired by calculating the number of the data file; the data files are numbered in a mode that an integer part of millisecond time difference of a time interval of each data file is divided by a millisecond timestamp of the beginning of each data file; the numbering mode of the index file is that a timestamp difference value is obtained by calculating the difference value according to the current timestamp Stamp and the Greenwich mean time Stamp0, and the result of dividing the timestamp difference value by the total number of the millisecond timestamps of Nx time intervals is rounded downwards;
the data compression module is used for sequentially compressing all the data files before a preset time point t0 into compressed files;
the data early warning module is used for constructing an early warning model, analyzing the early warning model into a plurality of operation windows according to different combinations of the measurement and index attributes of the time sequence data of the data sources, carrying out model settlement on the data sources related to the operation windows in each settlement period, and judging whether to send out early warning information according to set judgment scores.
2. The time series database system for oil and gas field production of claim 1,
the data compression module is configured to sequentially compress all the data files before a preset time point t0 into compressed files, and includes: and compressing each data file before the preset time point t0 into the compressed file according to the data blocks in the data file.
3. The time series database system for oil and gas field production of claim 1,
when time sequence data to be stored cross a plurality of data files in time, dividing the time sequence data into a plurality of sections according to the time period before writing, if a certain section occupies a part of the data block, locating the index to find the data block pointed by the index, storing the data point in the certain section into the data block, if the section crosses the whole block, adding the data of the section into different data files, and recording the storage position pointed by the corresponding index.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011143186.8A CN111966695B (en) | 2020-10-23 | 2020-10-23 | Time sequence database system for oil and gas field production |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011143186.8A CN111966695B (en) | 2020-10-23 | 2020-10-23 | Time sequence database system for oil and gas field production |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111966695A CN111966695A (en) | 2020-11-20 |
| CN111966695B true CN111966695B (en) | 2021-01-08 |
Family
ID=73387211
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011143186.8A Active CN111966695B (en) | 2020-10-23 | 2020-10-23 | Time sequence database system for oil and gas field production |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111966695B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112286948B (en) * | 2020-11-18 | 2023-05-23 | 成都佳华物链云科技有限公司 | Data storage method, data reading method and data storage device of time sequence database |
| CN112953913A (en) * | 2021-01-29 | 2021-06-11 | 江苏提米智能科技有限公司 | Method for realizing rapid access, aggregation, storage and release of industrial Internet of things intelligent equipment data |
| CN113312313B (en) * | 2021-01-29 | 2023-09-29 | 淘宝（中国）软件有限公司 | Data query method, nonvolatile storage medium and electronic device |
| CN112463803A (en) * | 2021-02-01 | 2021-03-09 | 山东柏源技术有限公司 | Time sequence data storage method, device and equipment for petroleum production |
| CN112835908B (en) * | 2021-02-22 | 2023-01-10 | 广东数程科技有限公司 | Time sequence data storage method, system, storage device and storage medium |
| CN114630030A (en) * | 2022-03-10 | 2022-06-14 | 陕西安控科技有限公司 | Oil and gas field mobile measure operation equipment monitoring system and method thereof |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2932405A1 (en) * | 2012-12-17 | 2015-10-21 | General Electric Company | System for storage, querying, and analysis of time series data |
| CN105427193A (en) * | 2015-12-17 | 2016-03-23 | 山东鲁能软件技术有限公司 | Device and method for big data analysis based on distributed time sequence data service |
| CN106250505A (en) * | 2016-08-01 | 2016-12-21 | 中国矿业大学 | A kind of Dynamic Compression of the Minepit environment Real-time Monitoring Data of variable step size |
| CN108256088A (en) * | 2018-01-23 | 2018-07-06 | 清华大学 | A kind of storage method and system of the time series data based on key value database |
| CN108399263A (en) * | 2018-03-15 | 2018-08-14 | 北京大众益康科技有限公司 | The storage of time series data and querying method and storage and processing platform |
| CN111400265A (en) * | 2020-03-04 | 2020-07-10 | 浙江永贵电器股份有限公司 | Storage method based on large-redundancy time sequence data |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102495851B (en) * | 2011-11-17 | 2014-11-05 | 百度在线网络技术（北京）有限公司 | Method, system and device for storing and querying timing sequence data |
| CN106776823B (en) * | 2016-11-25 | 2018-12-07 | 华为技术有限公司 | A kind of time series data management method, equipment and device |
-
2020
- 2020-10-23 CN CN202011143186.8A patent/CN111966695B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2932405A1 (en) * | 2012-12-17 | 2015-10-21 | General Electric Company | System for storage, querying, and analysis of time series data |
| CN105427193A (en) * | 2015-12-17 | 2016-03-23 | 山东鲁能软件技术有限公司 | Device and method for big data analysis based on distributed time sequence data service |
| CN106250505A (en) * | 2016-08-01 | 2016-12-21 | 中国矿业大学 | A kind of Dynamic Compression of the Minepit environment Real-time Monitoring Data of variable step size |
| CN108256088A (en) * | 2018-01-23 | 2018-07-06 | 清华大学 | A kind of storage method and system of the time series data based on key value database |
| CN108399263A (en) * | 2018-03-15 | 2018-08-14 | 北京大众益康科技有限公司 | The storage of time series data and querying method and storage and processing platform |
| CN111400265A (en) * | 2020-03-04 | 2020-07-10 | 浙江永贵电器股份有限公司 | Storage method based on large-redundancy time sequence data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111966695A (en) | 2020-11-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111966695B (en) | Time sequence database system for oil and gas field production | |
| CN101187943B (en) | Automatic update system, automatic updating method, and program therefor | |
| CN112286867B (en) | Oil-gas field time sequence data storage method, oil-gas field time sequence data query device and storage medium | |
| CN108255981B (en) | Method for storing and searching index minute freezing of timestamp sequence numbers of continuous time periods | |
| CN112449696A (en) | Time series data diagnosis device, additional learning method, and program | |
| CN111292442B (en) | Recalculation method for correcting vehicle travel segment based on vehicle report supplementing data | |
| CN106598822B (en) | A kind of abnormal deviation data examination method and device for Capacity Assessment | |
| CN113221455A (en) | Equipment health state detection method and device | |
| CN112766429B (en) | Method, device, computer equipment and medium for anomaly detection | |
| JP2002532799A (en) | Case-based reasoning system and method and apparatus for sensor prediction, especially in technological processes of cement kilns | |
| CN105575155A (en) | Method and equipment for determining vehicle driving information | |
| CN110413631B (en) | Data query method and device | |
| CN115859200A (en) | Data detection method and system | |
| CN115480119A (en) | Transformer abnormity monitoring method and system based on acoustic signals and frequent item set mining | |
| CN112303810A (en) | Air conditioner health prediction method based on machine learning | |
| CN111400265B (en) | Storage method based on large-redundancy time sequence data | |
| CN112668749B (en) | Coal mine gas early warning method based on class mark weighting extreme learning machine | |
| CN113221352A (en) | Complex equipment health management method and system based on digital twins | |
| CN112307151A (en) | Navigation data processing method and device | |
| CN110765074B (en) | Method and system for quickly accessing electric load curve data of acquisition terminal | |
| CN112163060A (en) | System for processing mass GPS data by big data technology | |
| CN110562296A (en) | LKJ (LKJ series-control) based running file data continuous fluctuation abnormity identification method | |
| US11954945B2 (en) | Systems and methods for analyzing machine performance | |
| CN112270473B (en) | Early warning method and device for oil-gas field time sequence data | |
| CN112069168B (en) | Cloud storage method for equipment operation data |
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 |