MX2022007684A - Metodo y aparato para almacenar y consultar datos de serie temporal, y servidor y medio de almacenamiento de los mismos. - Google Patents
Metodo y aparato para almacenar y consultar datos de serie temporal, y servidor y medio de almacenamiento de los mismos.Info
- Publication number
- MX2022007684A MX2022007684A MX2022007684A MX2022007684A MX2022007684A MX 2022007684 A MX2022007684 A MX 2022007684A MX 2022007684 A MX2022007684 A MX 2022007684A MX 2022007684 A MX2022007684 A MX 2022007684A MX 2022007684 A MX2022007684 A MX 2022007684A
- Authority
- MX
- Mexico
- Prior art keywords
- data
- query
- time series
- storing
- series data
- Prior art date
Links
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/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/174—Redundancy elimination performed by the file system
- G06F16/1744—Redundancy elimination performed by the file system using compression, e.g. sparse files
-
- 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
- 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
- G06F16/24553—Query execution of query operations
- G06F16/24561—Intermediate data storage techniques for performance improvement
-
- 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
-
- H—ELECTRICITY
- H03—ELECTRONIC CIRCUITRY
- H03M—CODING; DECODING; CODE CONVERSION IN GENERAL
- H03M7/00—Conversion of a code where information is represented by a given sequence or number of digits to a code where the same, similar or subset of information is represented by a different sequence or number of digits
- H03M7/30—Compression; Expansion; Suppression of unnecessary data, e.g. redundancy reduction
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2212/00—Indexing scheme relating to accessing, addressing or allocation within memory systems or architectures
- G06F2212/40—Specific encoding of data in memory or cache
- G06F2212/401—Compressed data
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Compression, Expansion, Code Conversion, And Decoders (AREA)
Abstract
Se describen un método y un aparato para almacenar y consultar datos de serie temporal. El método incluye: determinar un tipo de datos que serán almacenados; comprimir los datos que serán almacenados mediante un método de compresión de datos correspondiente al tipo de datos; almacenar datos comprimidos en una tabla de almacenamiento de datos correspondiente al tipo de datos; recibir una solicitud de consulta que incluya un tipo de datos de consulta y una condición de tiempo de consulta; consultar datos de destino que cumplan las condiciones de tiempo de consulta desde una tabla de almacenamiento de datos correspondiente al tipo de datos de consulta. En las modalidades de la presente invención, se adoptan diferentes métodos de compresión para diferentes tipos de datos, lo que mejora la eficiencia de compresión de datos de serie temporal y ahorra recursos de almacenamiento. Además, al llevar a cabo una consulta de datos, los datos de serie temporal que cumplan una condición de tiempo de consulta se buscan en una tabla de almacenamiento de datos correspondiente a un tipo de datos de consulta, lo que mejora la eficiencia de consulta de diferentes tipos de datos de serie temporal.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911318297.5A CN111078755B (zh) | 2019-12-19 | 2019-12-19 | 时序数据的存储查询方法、装置、服务器及存储介质 |
PCT/SG2020/050748 WO2021126079A1 (en) | 2019-12-19 | 2020-12-15 | Method and apparatus for storing and querying time series data, and server and storage medium thereof |
Publications (1)
Publication Number | Publication Date |
---|---|
MX2022007684A true MX2022007684A (es) | 2022-09-26 |
Family
ID=70315770
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
MX2022007684A MX2022007684A (es) | 2019-12-19 | 2020-12-15 | Metodo y aparato para almacenar y consultar datos de serie temporal, y servidor y medio de almacenamiento de los mismos. |
Country Status (12)
Country | Link |
---|---|
US (1) | US20230097797A1 (es) |
EP (1) | EP4078404A4 (es) |
JP (1) | JP7279266B2 (es) |
KR (1) | KR102511271B1 (es) |
CN (1) | CN111078755B (es) |
AU (1) | AU2020410479A1 (es) |
BR (1) | BR112022012121A2 (es) |
CA (1) | CA3165340A1 (es) |
MX (1) | MX2022007684A (es) |
MY (1) | MY197705A (es) |
WO (1) | WO2021126079A1 (es) |
ZA (1) | ZA202207174B (es) |
Families Citing this family (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111563546A (zh) * | 2020-04-29 | 2020-08-21 | 北京字节跳动网络技术有限公司 | 传感器数据匹配方法、装置、设备和存储介质 |
CN112035720A (zh) * | 2020-08-13 | 2020-12-04 | 海尔优家智能科技(北京)有限公司 | 事件提醒的触发方法和装置、存储介质及电子设备 |
CN112463793B (zh) * | 2020-11-24 | 2022-07-26 | 傲普(上海)新能源有限公司 | 一种基于influxdb数据库的EMS信息展示系统以及方法 |
CN112559811A (zh) * | 2020-12-23 | 2021-03-26 | 唐山松下产业机器有限公司 | 焊接数据的存储方法和存储系统 |
CN112818029A (zh) * | 2021-01-13 | 2021-05-18 | 远景智能国际私人投资有限公司 | 时序数据的查询方法、装置、设备及可读存储介质 |
CN113342536A (zh) * | 2021-07-01 | 2021-09-03 | 广东电网有限责任公司 | 一种基于数据云统一数据采集工具的应用数据处理系统 |
CN113850288B (zh) * | 2021-08-06 | 2022-08-19 | 中标慧安信息技术股份有限公司 | 物联网协同化数据处理与存储方法及系统 |
CN113849505A (zh) * | 2021-09-14 | 2021-12-28 | 联想(北京)有限公司 | 数据压缩方法及装置 |
CN114547073B (zh) * | 2022-02-10 | 2023-03-21 | 清华大学 | 时序数据的聚合查询方法、装置及存储介质 |
CN114726379B (zh) * | 2022-06-13 | 2022-09-13 | 西安热工研究院有限公司 | 基于时序数据库样本存储特征的自适应压缩方法及系统 |
CN117389972B (zh) * | 2023-12-11 | 2024-02-27 | 云粒智慧科技有限公司 | 条状空间数据压缩方法、装置、电子设备及存储介质 |
Family Cites Families (60)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4730348A (en) * | 1986-09-19 | 1988-03-08 | Adaptive Computer Technologies | Adaptive data compression system |
JP3733984B2 (ja) * | 1997-01-29 | 2006-01-11 | 富士ゼロックス株式会社 | 情報蓄積装置および情報蓄積方法 |
US6374266B1 (en) * | 1998-07-28 | 2002-04-16 | Ralph Shnelvar | Method and apparatus for storing information in a data processing system |
US6885319B2 (en) * | 1999-01-29 | 2005-04-26 | Quickshift, Inc. | System and method for generating optimally compressed data from a plurality of data compression/decompression engines implementing different data compression algorithms |
US20010054131A1 (en) * | 1999-01-29 | 2001-12-20 | Alvarez Manuel J. | System and method for perfoming scalable embedded parallel data compression |
US6880008B1 (en) * | 1999-03-31 | 2005-04-12 | Sony Corporation | System and method for retrieving a backup file having a file name exactly corresponding to the date and time of a client request, if no exact match for the date and time corresponding to the client request is found, to search for the backup file having the file name with a date and time that are closest to but prior to the specified date and time |
US7181478B1 (en) * | 2000-08-11 | 2007-02-20 | General Electric Company | Method and system for exporting flight data for long term storage |
US6525678B1 (en) * | 2000-10-06 | 2003-02-25 | Altera Corporation | Configuring a programmable logic device |
JP2002163180A (ja) | 2000-11-27 | 2002-06-07 | Nissan Motor Co Ltd | データ収集装置およびデータ転送方法 |
GB2372671B (en) * | 2001-02-27 | 2003-04-30 | 3Com Corp | Processing network events to reduce the number of events to be displayed |
AU2003282786A1 (en) * | 2002-08-30 | 2004-03-19 | Racom Products | Modular analog wireless data telemetry system adapted for use with web based location information distribution method and method for developing and disseminating information for use therewith |
US7099992B2 (en) * | 2002-12-30 | 2006-08-29 | Micron Technology, Inc. | Distributed programmable priority encoder capable of finding the longest match in a single operation |
US7174260B2 (en) * | 2004-04-01 | 2007-02-06 | Blue Line Innovations Inc. | System and method for reading power meters |
US8238194B2 (en) * | 2004-09-23 | 2012-08-07 | Schlumberger Technology Corporation | Methods and systems for compressing sonic log data |
JP2006317362A (ja) * | 2005-05-16 | 2006-11-24 | Kobe Steel Ltd | データ圧縮型記録装置 |
WO2008034213A1 (en) | 2006-09-18 | 2008-03-27 | Infobright Inc. | A method and system for data compression in a relational database |
US9063979B2 (en) * | 2007-11-01 | 2015-06-23 | Ebay, Inc. | Analyzing event streams of user sessions |
US7765346B2 (en) * | 2007-12-14 | 2010-07-27 | Bmc Software, Inc. | Dynamic compression of systems management data |
CN101267644B (zh) * | 2008-04-22 | 2010-11-17 | 广东高新兴通信股份有限公司 | 一种对监控数据的存储方法 |
US20090307763A1 (en) * | 2008-06-05 | 2009-12-10 | Fiberlink Communications Corporation | Automated Test Management System and Method |
IL203628A (en) * | 2010-01-31 | 2015-09-24 | Verint Systems Ltd | Systems and methods for decoding network traffic |
US9298854B2 (en) * | 2010-05-14 | 2016-03-29 | Hitachi, Ltd. | Time-series data management device, system, method, and program |
WO2011153623A2 (en) * | 2010-06-08 | 2011-12-15 | Aastra Technologies Limited | Method and system for video communication |
US8260989B2 (en) * | 2010-08-18 | 2012-09-04 | Hewlett-Packard Development Company, L.P. | Method and system for low-powered data transmission |
US9218232B2 (en) * | 2011-04-13 | 2015-12-22 | Bar-Ilan University | Anomaly detection methods, devices and systems |
US20130091266A1 (en) * | 2011-10-05 | 2013-04-11 | Ajit Bhave | System for organizing and fast searching of massive amounts of data |
JP2013206387A (ja) * | 2012-03-29 | 2013-10-07 | Ntt Docomo Inc | データ検索システム及びデータ検索方法 |
US10009391B1 (en) * | 2012-05-31 | 2018-06-26 | Leading Market Technologies, Inc. | Apparatus and method for acquiring, managing, sharing, monitoring, analyzing and publishing web-based time series data |
CN103577456B (zh) * | 2012-07-31 | 2016-12-21 | 国际商业机器公司 | 用于处理时序数据的方法和装置 |
US9264478B2 (en) * | 2012-10-30 | 2016-02-16 | Microsoft Technology Licensing, Llc | Home cloud with virtualized input and output roaming over network |
CN103794006B (zh) * | 2012-10-31 | 2016-12-21 | 国际商业机器公司 | 用于处理多个传感器的时序数据的方法和装置 |
GB2508190A (en) * | 2012-11-22 | 2014-05-28 | Wonga Technology Ltd | Monitoring user interaction with webpages using unique identifiers for page components |
US9015183B2 (en) * | 2012-11-26 | 2015-04-21 | International Business Machines Corporation | Accelerating time series data base queries using dictionary based representations |
US10360196B2 (en) * | 2014-04-15 | 2019-07-23 | Splunk Inc. | Grouping and managing event streams generated from captured network data |
CN104135530A (zh) * | 2014-08-06 | 2014-11-05 | 上海斐讯数据通信技术有限公司 | 一种增量上报的方法及装置 |
CN106330995A (zh) * | 2015-06-19 | 2017-01-11 | 陕西重型汽车有限公司 | 用于车联网的三级数据压缩装置及其方法 |
US9516052B1 (en) * | 2015-08-01 | 2016-12-06 | Splunk Inc. | Timeline displays of network security investigation events |
US10318516B1 (en) * | 2015-09-22 | 2019-06-11 | Amazon Technologies, Inc. | System for optimizing serialization of values |
JP6599727B2 (ja) * | 2015-10-26 | 2019-10-30 | 株式会社Screenホールディングス | 時系列データ処理方法、時系列データ処理プログラム、および、時系列データ処理装置 |
US10754334B2 (en) | 2016-05-09 | 2020-08-25 | Strong Force Iot Portfolio 2016, Llc | Methods and systems for industrial internet of things data collection for process adjustment in an upstream oil and gas environment |
CN106021395A (zh) * | 2016-05-12 | 2016-10-12 | 成都鼎智汇科技有限公司 | 物联网环境下的药品信息存储方法 |
US10070387B2 (en) * | 2016-05-18 | 2018-09-04 | Qualcomm, Incorporated | Deep sleep mode abort mechanism for machine-type communication devices |
WO2017223468A1 (en) * | 2016-06-23 | 2017-12-28 | Schneider Electric USA, Inc. | Transactional-unstructured data driven sequential federated query method for distributed systems |
US9753935B1 (en) * | 2016-08-02 | 2017-09-05 | Palantir Technologies Inc. | Time-series data storage and processing database system |
WO2018049430A2 (en) * | 2016-08-11 | 2018-03-15 | Integem Inc. | An intelligent interactive and augmented reality based user interface platform |
EP3531310A4 (en) * | 2016-10-24 | 2020-04-29 | Beijing Wellintech Co., Ltd. | METHOD FOR EXTRACTING A DATABASE BASED ON A SPATIO-TEMPORAL DATABASE |
US9809159B1 (en) * | 2016-12-28 | 2017-11-07 | Allstate Insurance Company | System and methods for detecting vehicle braking events using data from fused sensors in mobile devices |
CN107038204B (zh) * | 2016-12-30 | 2019-05-03 | 北京工业大学 | 物联网感知数据状态矢量提取及表示方法 |
US20180217910A1 (en) * | 2017-01-27 | 2018-08-02 | Ca, Inc. | Scalable data logging |
US11269877B2 (en) * | 2017-06-22 | 2022-03-08 | Sap Se | Visualization-oriented time series data aggregation |
JP2019079317A (ja) | 2017-10-25 | 2019-05-23 | 株式会社東芝 | エッジサーバ |
CN108021650A (zh) * | 2017-11-30 | 2018-05-11 | 冶金自动化研究设计院 | 一种时序数据的高效存储和读取系统 |
CN107871022B (zh) * | 2017-12-20 | 2018-12-11 | 清华大学 | 一种时序数据列式存储、查询方法及系统 |
CN108256088A (zh) * | 2018-01-23 | 2018-07-06 | 清华大学 | 一种基于键值数据库的时序数据的存储方法及系统 |
US20190286994A1 (en) * | 2018-03-14 | 2019-09-19 | Scaled Inference, Inc. | Methods and systems for transforming computing analytics frameworks into cross-platform real-time decision-making systems by executing intelligent decisions on an endpoint device |
CN108566320A (zh) * | 2018-03-28 | 2018-09-21 | 青岛海信智慧家居系统股份有限公司 | 一种信息上报的方法及电子设备 |
US11410063B2 (en) * | 2018-09-28 | 2022-08-09 | B.yond, Inc. | Self-intelligent improvement in predictive data models |
CN109582708A (zh) * | 2018-11-19 | 2019-04-05 | 冶金自动化研究设计院 | 一种时序数据库系统 |
CN110460656B (zh) * | 2019-08-01 | 2022-04-01 | 安徽领云物联科技有限公司 | 一种工业环保物联网远程监测云平台 |
US20210034586A1 (en) * | 2019-08-02 | 2021-02-04 | Timescale, Inc. | Compressing data in database systems using hybrid row/column storage representations |
-
2019
- 2019-12-19 CN CN201911318297.5A patent/CN111078755B/zh active Active
-
2020
- 2020-12-15 MX MX2022007684A patent/MX2022007684A/es unknown
- 2020-12-15 EP EP20902057.7A patent/EP4078404A4/en active Pending
- 2020-12-15 WO PCT/SG2020/050748 patent/WO2021126079A1/en unknown
- 2020-12-15 CA CA3165340A patent/CA3165340A1/en active Pending
- 2020-12-15 KR KR1020227024660A patent/KR102511271B1/ko active IP Right Grant
- 2020-12-15 BR BR112022012121A patent/BR112022012121A2/pt unknown
- 2020-12-15 US US17/787,280 patent/US20230097797A1/en not_active Abandoned
- 2020-12-15 AU AU2020410479A patent/AU2020410479A1/en not_active Abandoned
- 2020-12-15 JP JP2022537436A patent/JP7279266B2/ja active Active
- 2020-12-15 MY MYPI2022003240A patent/MY197705A/en unknown
-
2022
- 2022-06-28 ZA ZA2022/07174A patent/ZA202207174B/en unknown
Also Published As
Publication number | Publication date |
---|---|
US20230097797A1 (en) | 2023-03-30 |
ZA202207174B (en) | 2022-10-26 |
CA3165340A1 (en) | 2021-06-24 |
WO2021126079A1 (en) | 2021-06-24 |
AU2020410479A1 (en) | 2022-07-21 |
EP4078404A1 (en) | 2022-10-26 |
KR102511271B1 (ko) | 2023-03-17 |
EP4078404A4 (en) | 2023-01-04 |
BR112022012121A2 (pt) | 2022-08-30 |
KR20220108186A (ko) | 2022-08-02 |
JP7279266B2 (ja) | 2023-05-22 |
CN111078755B (zh) | 2023-07-28 |
JP2023502543A (ja) | 2023-01-24 |
MY197705A (en) | 2023-07-06 |
CN111078755A (zh) | 2020-04-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
MX2022007684A (es) | Metodo y aparato para almacenar y consultar datos de serie temporal, y servidor y medio de almacenamiento de los mismos. | |
AU2019101570A4 (en) | Data storage, data check, and data linkage method and apparatus | |
MY196252A (en) | Blockchain-Based Data Storage and Query Method and Device | |
PH12020550738A1 (en) | Blockchain-based transaction processing method and apparatus, and electronic device | |
MX2015007303A (es) | Metodo y dispositivo para el establecimiento de una libreria de etiquetas, metodo y dispositivo para la busqueda de un usuario. | |
CN106503175B (zh) | 相似文本的查询、问题扩展方法、装置及机器人 | |
PH12019500772A1 (en) | Order information determination method and apparatus | |
RU2014113315A (ru) | Устройство обработки информации, способ и программа | |
WO2017058734A4 (en) | Distributed stream-based database triggers | |
RU2013114990A (ru) | Способ и устройство для сохранения данных с использованием хэширования | |
CN105138541A (zh) | 音频指纹匹配查询的方法和装置 | |
CN103678718A (zh) | 数据库同步方法及系统 | |
AU2019101568A4 (en) | Method and apparatus for recognizing service request to change mobile phone number | |
CN104636349A (zh) | 一种索引数据压缩以及索引数据搜索的方法和设备 | |
GB2578709A (en) | Context aware delta algorithm for genomic files | |
WO2018144350A3 (en) | Efficient retrieval of memory values during trace replay | |
CN112632568B (zh) | 温度数据的存储和采集方法、系统、电子设备和存储介质 | |
CN104618361A (zh) | 一种网络流数据重排序方法 | |
WO2021027252A1 (zh) | 块链式账本中的数据存储方法、装置及设备 | |
EP3822823A3 (en) | Method and apparatus for querying historical street view, electronic device, storage medium and computer program product | |
CN104778252A (zh) | 索引的存储方法和装置 | |
CN110019319B (zh) | 数据查询方法及装置 | |
RU2014134715A (ru) | Способ и терминал для редактирования информации в приложениях службы социальной сети | |
CN111176574B (zh) | 一种小文件存储方法、装置、设备及介质 | |
SG11201802258XA (en) | Scoring information matching method and device, storage medium and server |