CN113632072B - 可扩展数据跳过 - Google Patents

可扩展数据跳过 Download PDF

Info

Publication number
CN113632072B
CN113632072B CN202080023334.4A CN202080023334A CN113632072B CN 113632072 B CN113632072 B CN 113632072B CN 202080023334 A CN202080023334 A CN 202080023334A CN 113632072 B CN113632072 B CN 113632072B
Authority
CN
China
Prior art keywords
data
skip
criterion
skip index
index
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
Application number
CN202080023334.4A
Other languages
English (en)
Chinese (zh)
Other versions
CN113632072A (zh
Inventor
P·K·塔-施玛
G·卡茨马
G·鲁什
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
International Business Machines Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Publication of CN113632072A publication Critical patent/CN113632072A/zh
Application granted granted Critical
Publication of CN113632072B publication Critical patent/CN113632072B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • G06F16/24534—Query rewriting; Transformation
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/9032—Query formulation
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • G06F16/90335—Query processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN202080023334.4A 2019-03-31 2020-03-20 可扩展数据跳过 Active CN113632072B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US16/371,019 US11106674B2 (en) 2019-03-31 2019-03-31 Extensible data skipping
US16/371,019 2019-03-31
PCT/IB2020/052602 WO2020201882A1 (en) 2019-03-31 2020-03-20 Extensible data skipping

Publications (2)

Publication Number Publication Date
CN113632072A CN113632072A (zh) 2021-11-09
CN113632072B true CN113632072B (zh) 2025-05-30

Family

ID=72604307

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202080023334.4A Active CN113632072B (zh) 2019-03-31 2020-03-20 可扩展数据跳过

Country Status (6)

Country Link
US (1) US11106674B2 (https=)
JP (1) JP2022526886A (https=)
CN (1) CN113632072B (https=)
DE (1) DE112020000536T5 (https=)
GB (1) GB2596769A (https=)
WO (1) WO2020201882A1 (https=)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11954085B1 (en) 2022-09-22 2024-04-09 International Business Machines Corporation Hierarchical data skipping using data sketches
CN118708590B (zh) * 2024-06-27 2025-05-30 武汉达梦数据库股份有限公司 一种天文数据索引方法、装置、设备及介质

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050210023A1 (en) * 2004-03-18 2005-09-22 Renato Barrera Query optimizer using implied predicates
US8402016B2 (en) * 2009-05-27 2013-03-19 Hewlett-Packard Development Company, L.P. Fetching optimization in multi-way pipelined database joins
US8166022B2 (en) * 2009-08-18 2012-04-24 International Business Machines Corporation System, method, and apparatus for parallelizing query optimization
US10430430B2 (en) * 2010-03-15 2019-10-01 Vmware, Inc. Computer relational database method and system having role based access control
US8489649B2 (en) * 2010-12-13 2013-07-16 Oracle International Corporation Extensible RDF databases
US10311105B2 (en) * 2010-12-28 2019-06-04 Microsoft Technology Licensing, Llc Filtering queried data on data stores
US10108649B2 (en) * 2014-02-25 2018-10-23 Internatonal Business Machines Corporation Early exit from table scans of loosely ordered and/or grouped relations using nearly ordered maps
US9846567B2 (en) * 2014-06-16 2017-12-19 International Business Machines Corporation Flash optimized columnar data layout and data access algorithms for big data query engines
US9952808B2 (en) 2015-03-26 2018-04-24 International Business Machines Corporation File system block-level tiering and co-allocation
US10725994B2 (en) * 2016-04-08 2020-07-28 International Business Machines Corporation Automatically revising synopsis table structure
US10649991B2 (en) 2016-04-26 2020-05-12 International Business Machines Corporation Pruning of columns in synopsis tables
US10185726B2 (en) 2016-08-26 2019-01-22 BlueTalon, Inc. Access control for nested data fields

Also Published As

Publication number Publication date
GB202115146D0 (en) 2021-12-08
US11106674B2 (en) 2021-08-31
CN113632072A (zh) 2021-11-09
DE112020000536T5 (de) 2021-10-21
JP2022526886A (ja) 2022-05-27
GB2596769A (en) 2022-01-05
WO2020201882A1 (en) 2020-10-08
US20200311088A1 (en) 2020-10-01

Similar Documents

Publication Publication Date Title
US11797558B2 (en) Generating data transformation workflows
Yang et al. Pase: Postgresql ultra-high-dimensional approximate nearest neighbor search extension
Rost et al. Distributed temporal graph analytics with GRADOOP
CN105122243B (zh) 用于半结构化数据的可扩展分析平台
Alarabi et al. TAREEG: A MapReduce-based system for extracting spatial data from OpenStreetMap
Huai et al. Major technical advancements in apache hive
US9870393B2 (en) Graph processing in database
US9146994B2 (en) Pivot facets for text mining and search
US20140365527A1 (en) Secure access to hierarchical documents in a sorted, distributed key/value data store
JP6670097B2 (ja) 関係型データベース表の列横断的検索
US9218394B2 (en) Reading rows from memory prior to reading rows from secondary storage
US20180181581A1 (en) Systems and methods for implementing object storage and fast metadata search using extended attributes
Vrgoc et al. Millenniumdb: A persistent, open-source, graph database
US20250284680A1 (en) Multi-vector search
CN113632072B (zh) 可扩展数据跳过
CN112835638B (zh) 一种基于嵌入式应用程序的配置信息管理方法及装置
US12536186B1 (en) Implementing vector index build and search using query operators
CN112988778A (zh) 一种处理数据库查询脚本的方法和装置
Alkowaileet et al. Large-scale complex analytics on semi-structured datasets using AsterixDB and Spark
EP4535186A1 (en) Efficient sorting techniques facilitating the creation and use of dataset summary metadata
Hagedorn Efficient processing of large-scale spatio-temporal data
CN121996620A (zh) 数据写入方法、数据查询方法、电子设备和存储介质
CN119829641A (zh) 一种数据库加密字段模糊检索方法和装置
Shui et al. JetXSLT: a resource-conscious XSLT processor
Lehner et al. Web-Scale Analytics for BIG 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