JP2022526886A - 拡張可能データ・スキップ方法、システム、プログラム - Google Patents

拡張可能データ・スキップ方法、システム、プログラム Download PDF

Info

Publication number
JP2022526886A
JP2022526886A JP2021556686A JP2021556686A JP2022526886A JP 2022526886 A JP2022526886 A JP 2022526886A JP 2021556686 A JP2021556686 A JP 2021556686A JP 2021556686 A JP2021556686 A JP 2021556686A JP 2022526886 A JP2022526886 A JP 2022526886A
Authority
JP
Japan
Prior art keywords
data
index
data skip
skip index
criterion
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.)
Pending
Application number
JP2021556686A
Other languages
English (en)
Japanese (ja)
Other versions
JP2022526886A5 (https=
Inventor
タ－シュマ、ポーラ、キム
カズマ、ガイ
ルシ、ガル
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 JP2022526886A publication Critical patent/JP2022526886A/ja
Publication of JP2022526886A5 publication Critical patent/JP2022526886A5/ja
Pending legal-status Critical Current

Links

Images

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)
JP2021556686A 2019-03-31 2020-03-20 拡張可能データ・スキップ方法、システム、プログラム Pending JP2022526886A (ja)

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
JP2022526886A true JP2022526886A (ja) 2022-05-27
JP2022526886A5 JP2022526886A5 (https=) 2022-08-17

Family

ID=72604307

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2021556686A Pending JP2022526886A (ja) 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 武汉达梦数据库股份有限公司 一种天文数据索引方法、装置、设备及介质

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2005267612A (ja) * 2004-03-18 2005-09-29 Microsoft Corp 暗黙の述部を使用する改良されたクエリ・オプティマイザ
US20110047144A1 (en) * 2009-08-18 2011-02-24 International Business Machines Corporation System, method, and apparatus for parallelizing query optimization

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8402016B2 (en) * 2009-05-27 2013-03-19 Hewlett-Packard Development Company, L.P. Fetching optimization in multi-way pipelined database joins
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

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2005267612A (ja) * 2004-03-18 2005-09-29 Microsoft Corp 暗黙の述部を使用する改良されたクエリ・オプティマイザ
US20110047144A1 (en) * 2009-08-18 2011-02-24 International Business Machines Corporation System, method, and apparatus for parallelizing query optimization

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
GB2596769A (en) 2022-01-05
WO2020201882A1 (en) 2020-10-08
US20200311088A1 (en) 2020-10-01

Similar Documents

Publication Publication Date Title
EP3782045B1 (en) Efficient, in-memory, relational representation for heterogeneous graphs
Venkataraman et al. Sparkr: Scaling r programs with spark
US9304835B1 (en) Optimized system for analytics (graphs and sparse matrices) operations
US10180984B2 (en) Pivot facets for text mining and search
CN105122243B (zh) 用于半结构化数据的可扩展分析平台
US10152607B2 (en) Secure access to hierarchical documents in a sorted, distributed key/value data store
US11657069B1 (en) Dynamic compilation of machine learning models based on hardware configurations
Alarabi et al. TAREEG: A MapReduce-based system for extracting spatial data from OpenStreetMap
US8914323B1 (en) Policy-based data-centric access control in a sorted, distributed key-value data store
US11636124B1 (en) Integrating query optimization with machine learning model prediction
JP2019194882A (ja) ファーストクラスデータベース要素としての半構造データの実装
US20160188391A1 (en) Sophisticated run-time system for graph processing
JP6670097B2 (ja) 関係型データベース表の列横断的検索
Aji et al. Demonstration of Hadoop-GIS: a spatial data warehousing system over MapReduce
US20210182259A1 (en) Level-based hierarchies
US20230359668A1 (en) Dataflow graph datasets
US20190286828A1 (en) Fine-grained privacy enforcement and policy-based data access control at scale
US20250284680A1 (en) Multi-vector search
CN110914814A (zh) 分布式存储环境的认知文件和对象管理
WO2024156113A1 (en) Runtime error attribution for database queries specified using a declarative database query language
US20150356131A1 (en) Accessing an external table in parallel to execute a query
Tanase et al. A highly efficient runtime and graph library for large scale graph analytics
JP2022526886A (ja) 拡張可能データ・スキップ方法、システム、プログラム
Agarwal et al. Map reduce: a survey paper on recent expansion
US10599626B2 (en) Organization for efficient data analytics

Legal Events

Date Code Title Description
RD04 Notification of resignation of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7424

Effective date: 20220512

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20220803

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20220824

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20230927

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20231003

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20231204

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20240305

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20240625

A911 Transfer to examiner for re-examination before appeal (zenchi)

Free format text: JAPANESE INTERMEDIATE CODE: A911

Effective date: 20240704

A912 Re-examination (zenchi) completed and case transferred to appeal board

Free format text: JAPANESE INTERMEDIATE CODE: A912

Effective date: 20241025

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20250617

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20251106

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20260414