GB2596769A - Extensible data skipping - Google Patents

Extensible data skipping Download PDF

Info

Publication number
GB2596769A
GB2596769A GB2115146.9A GB202115146A GB2596769A GB 2596769 A GB2596769 A GB 2596769A GB 202115146 A GB202115146 A GB 202115146A GB 2596769 A GB2596769 A GB 2596769A
Authority
GB
United Kingdom
Prior art keywords
criterion
data skipping
data
index
skipping 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.)
Withdrawn
Application number
GB2115146.9A
Other languages
English (en)
Other versions
GB202115146D0 (en
Inventor
Kim Ta-Shma Paula
Khazma Guy
Lushi Gal
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 GB202115146D0 publication Critical patent/GB202115146D0/en
Publication of GB2596769A publication Critical patent/GB2596769A/en
Withdrawn legal-status Critical Current

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/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/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/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)
GB2115146.9A 2019-03-31 2020-03-20 Extensible data skipping Withdrawn GB2596769A (en)

Applications Claiming Priority (2)

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

Publications (2)

Publication Number Publication Date
GB202115146D0 GB202115146D0 (en) 2021-12-08
GB2596769A true GB2596769A (en) 2022-01-05

Family

ID=72604307

Family Applications (1)

Application Number Title Priority Date Filing Date
GB2115146.9A Withdrawn GB2596769A (en) 2019-03-31 2020-03-20 Extensible data skipping

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 武汉达梦数据库股份有限公司 一种天文数据索引方法、装置、设备及介质

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100306212A1 (en) * 2009-05-27 2010-12-02 Hewlett-Packard Development Company, L.P. Fetching Optimization in Multi-way Pipelined Database Joins
US20170293649A1 (en) * 2016-04-08 2017-10-12 International Business Machines Corporation Automatically revising synopsis table structure
US20180011690A1 (en) * 2014-06-16 2018-01-11 International Business Machines Corporation Flash optimized columnar data layout and data access algorithms for big data query engines

Family Cites Families (9)

* 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
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
US9952808B2 (en) 2015-03-26 2018-04-24 International Business Machines Corporation File system block-level tiering and co-allocation
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100306212A1 (en) * 2009-05-27 2010-12-02 Hewlett-Packard Development Company, L.P. Fetching Optimization in Multi-way Pipelined Database Joins
US20180011690A1 (en) * 2014-06-16 2018-01-11 International Business Machines Corporation Flash optimized columnar data layout and data access algorithms for big data query engines
US20180225090A1 (en) * 2014-06-16 2018-08-09 International Business Machines Corporation Flash optimized columnar data layout and data access algorithms for big data query engines
US20170293649A1 (en) * 2016-04-08 2017-10-12 International Business Machines Corporation Automatically revising synopsis table structure

Also Published As

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

Similar Documents

Publication Publication Date Title
CN107463632B (zh) 一种分布式NewSQL数据库系统和数据查询方法
JP6964384B2 (ja) 異種データソース混在環境におけるフィールド間の関係性の自動的発見のための方法、プログラム、および、システム
US8745021B2 (en) Transformation of complex data source result sets to normalized sets for manipulation and presentation
GB2614014A (en) Learning-based workload resource optimization for database management systems
EP4600841A3 (en) Systems and methods for accessing data entities managed by a data processing system
De Virgilio et al. R2G: a Tool for Migrating Relations to Graphs.
TW202004527A (zh) 資料庫存取方法及裝置
US20180121501A1 (en) Translating gql queries into sql queries
US20160070707A1 (en) Keyword search on databases
CN111475534B (zh) 一种数据查询方法及相关设备
US20140379753A1 (en) Ambiguous queries in configuration management databases
US20140046975A1 (en) Aggregate data streams in relational database systems
Urbani et al. KOGNAC: efficient encoding of large knowledge graphs
GB2607518A (en) Hierarchical data
GB2596769A (en) Extensible data skipping
Sequeda et al. Ultrawrap: Using sql views for rdb2rdf
US10733185B2 (en) Access pattern based optimization of memory access
EP4546154A1 (en) Relational subtree matching for improved query performance
JP2022526886A5 (https=)
Schildgen et al. Marimba: A framework for making mapreduce jobs incremental
Mirza Null value conflict: Formal definition and resolution
US10289632B1 (en) Dynamic array type in a data store system
Haque et al. Distributed RDF triple store using hbase and hive
Unbehauen et al. SPARQL Update queries over R2RML mapped data sources
US20170147623A1 (en) Determining an intersection between keys defining multi-dimensional value ranges

Legal Events

Date Code Title Description
WAP Application withdrawn, taken to be withdrawn or refused ** after publication under section 16(1)