JP7904236B2 - Sqlクエリを加速するための決定的分散キャッシュのための技術 - Google Patents

Sqlクエリを加速するための決定的分散キャッシュのための技術

Info

Publication number
JP7904236B2
JP7904236B2 JP2023571975A JP2023571975A JP7904236B2 JP 7904236 B2 JP7904236 B2 JP 7904236B2 JP 2023571975 A JP2023571975 A JP 2023571975A JP 2023571975 A JP2023571975 A JP 2023571975A JP 7904236 B2 JP7904236 B2 JP 7904236B2
Authority
JP
Japan
Prior art keywords
data
nodes
cluster
cache
node
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
JP2023571975A
Other languages
English (en)
Japanese (ja)
Other versions
JP2024521730A (ja
JP2024521730A5 (cg-RX-API-DMAC7.html
Inventor
カバリ,ディーバラジュル
マールケード,アニーシュ
チャクラボルティ,ソナック
ブタニ,ハリッシュ・ラメシュ
バスカー,ビベク
アキナペッリ,サンディープ
ダス,ディーバラジ
Original Assignee
オラクル・インターナショナル・コーポレイション
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 オラクル・インターナショナル・コーポレイション filed Critical オラクル・インターナショナル・コーポレイション
Publication of JP2024521730A publication Critical patent/JP2024521730A/ja
Publication of JP2024521730A5 publication Critical patent/JP2024521730A5/ja
Application granted granted Critical
Publication of JP7904236B2 publication Critical patent/JP7904236B2/ja
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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results
    • 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471—Distributed queries
    • 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/24552—Database cache management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Mathematical Physics (AREA)
  • Fuzzy Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2023571975A 2021-05-21 2022-05-20 Sqlクエリを加速するための決定的分散キャッシュのための技術 Active JP7904236B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
IN202141022725 2021-05-21
IN202141022725 2021-05-21
PCT/US2022/030337 WO2022246253A1 (en) 2021-05-21 2022-05-20 Techniques for a deterministic distributed cache to accelerate sql queries

Publications (3)

Publication Number Publication Date
JP2024521730A JP2024521730A (ja) 2024-06-04
JP2024521730A5 JP2024521730A5 (cg-RX-API-DMAC7.html) 2025-05-19
JP7904236B2 true JP7904236B2 (ja) 2026-08-12

Family

ID=82020297

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2023571975A Active JP7904236B2 (ja) 2021-05-21 2022-05-20 Sqlクエリを加速するための決定的分散キャッシュのための技術

Country Status (5)

Country Link
US (1) US12111832B2 (cg-RX-API-DMAC7.html)
EP (1) EP4341826A1 (cg-RX-API-DMAC7.html)
JP (1) JP7904236B2 (cg-RX-API-DMAC7.html)
CN (1) CN117321581A (cg-RX-API-DMAC7.html)
WO (1) WO2022246253A1 (cg-RX-API-DMAC7.html)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11789959B2 (en) * 2021-10-06 2023-10-17 S&P Global Inc. Data visualization method
US12111835B2 (en) * 2021-10-19 2024-10-08 NetSpring Data, Inc. Query generation and processing system
US12328394B2 (en) * 2022-06-07 2025-06-10 Bank Of America Corporation System for augmented hash-based portioning of non-fungible electronic resources for detection of unauthorized duplicates
CN115729476B (zh) * 2022-12-15 2025-11-28 南京鹏云网络科技有限公司 用于分布式存储系统的数据写入方法和装置
CN116186092B (zh) * 2023-03-14 2026-08-11 哈尔滨工业大学 基于Hadoop的知识图谱关系表存储的缓存方法及系统
US12072772B1 (en) 2023-04-12 2024-08-27 Kyndryl, Inc. Crowd sourced data restores
US12705242B2 (en) * 2023-09-26 2026-08-11 Teradata Us, Inc. System and method for caching object data in a cloud database system
US12361004B1 (en) * 2024-01-16 2025-07-15 Zoom Communications, Inc. Multi-agent search client

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000155712A (ja) 1998-11-19 2000-06-06 Nippon Telegr & Teleph Corp <Ntt> 分散キャッシュ配送方法及び分散キャッシュ配送プログラムを記憶した媒体
JP2006171822A (ja) 2004-12-13 2006-06-29 Nippon Telegr & Teleph Corp <Ntt> コンテンツ配信方法
US20160092466A1 (en) 2014-09-25 2016-03-31 Oracle International Corporation System and method for supporting zero-copy binary radix tree in a distributed computing environment
WO2016166844A1 (ja) 2015-04-15 2016-10-20 株式会社日立製作所 分散処理システム、タスク処理方法、記憶媒体

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11224219A (ja) * 1998-02-05 1999-08-17 Nippon Telegr & Teleph Corp <Ntt> 分散キャッシュ制御方法及び分散制御装置及び分散キャッシュシステム及び分散キャッシュ制御プログラムを格納した記憶媒体
EP2669810A1 (en) * 2011-01-25 2013-12-04 Nec Corporation Information processing device, information processing system, information processing method and information processing program
US8966184B2 (en) * 2011-01-31 2015-02-24 Intelligent Intellectual Property Holdings 2, LLC. Apparatus, system, and method for managing eviction of data
US8538926B2 (en) 2011-03-08 2013-09-17 Rackspace Us, Inc. Massively scalable object storage system for storing object replicas
US9509793B2 (en) * 2013-11-22 2016-11-29 Verizon Patent And Licensing Inc. Content caching in a network for efficient user device access
US10528596B2 (en) 2014-09-26 2020-01-07 Oracle International Corporation System and method for consistent reads between tasks in a massively parallel or distributed database environment
US10152425B2 (en) * 2016-06-13 2018-12-11 Advanced Micro Devices, Inc. Cache entry replacement based on availability of entries at another cache
US11989194B2 (en) * 2017-07-31 2024-05-21 Splunk Inc. Addressing memory limits for partition tracking among worker nodes
US11762836B2 (en) * 2017-09-29 2023-09-19 Oracle International Corporation System and method for capture of change data from distributed data sources, for use with heterogeneous targets
US10733114B2 (en) * 2018-08-28 2020-08-04 International Business Machines Corporation Data cache performance
US10970222B2 (en) * 2019-02-28 2021-04-06 Micron Technology, Inc. Eviction of a cache line based on a modification of a sector of the cache line
US11556471B2 (en) * 2019-04-30 2023-01-17 Hewlett Packard Enterprise Development Lp Cache coherency management for multi-category memories

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000155712A (ja) 1998-11-19 2000-06-06 Nippon Telegr & Teleph Corp <Ntt> 分散キャッシュ配送方法及び分散キャッシュ配送プログラムを記憶した媒体
JP2006171822A (ja) 2004-12-13 2006-06-29 Nippon Telegr & Teleph Corp <Ntt> コンテンツ配信方法
US20160092466A1 (en) 2014-09-25 2016-03-31 Oracle International Corporation System and method for supporting zero-copy binary radix tree in a distributed computing environment
JP2017531263A (ja) 2014-09-25 2017-10-19 オラクル・インターナショナル・コーポレイション 分散コンピューティング環境内でゼロコピー2進基数木をサポートするためのシステムおよび方法
WO2016166844A1 (ja) 2015-04-15 2016-10-20 株式会社日立製作所 分散処理システム、タスク処理方法、記憶媒体

Also Published As

Publication number Publication date
US20220374431A1 (en) 2022-11-24
US12111832B2 (en) 2024-10-08
EP4341826A1 (en) 2024-03-27
JP2024521730A (ja) 2024-06-04
WO2022246253A1 (en) 2022-11-24
CN117321581A (zh) 2023-12-29

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20250509

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20250509

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20260130

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20260203

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20260430

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20260707

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20260730