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

Ｓｑｌクエリを加速するための決定的分散キャッシュのための技術 Download PDF

Info

Publication number
JP2024521730A
JP2024521730A JP2023571975A JP2023571975A JP2024521730A JP 2024521730 A JP2024521730 A JP 2024521730A JP 2023571975 A JP2023571975 A JP 2023571975A JP 2023571975 A JP2023571975 A JP 2023571975A JP 2024521730 A JP2024521730 A JP 2024521730A
Authority
JP
Japan
Prior art keywords
data
nodes
cache
worker node
token
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
JP2023571975A
Other languages
English (en)
Japanese (ja)
Other versions
JP2024521730A5 (https=
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
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/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 Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2023571975A 2021-05-21 2022-05-20 Ｓｑｌクエリを加速するための決定的分散キャッシュのための技術 Pending JP2024521730A (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 (2)

Publication Number Publication Date
JP2024521730A true JP2024521730A (ja) 2024-06-04
JP2024521730A5 JP2024521730A5 (https=) 2025-05-19

Family

ID=82020297

Family Applications (1)

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

Country Status (5)

Country Link
US (1) US12111832B2 (https=)
EP (1) EP4341826A1 (https=)
JP (1) JP2024521730A (https=)
CN (1) CN117321581A (https=)
WO (1) WO2022246253A1 (https=)

Families Citing this family (7)

* 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
CN115729476B (zh) * 2022-12-15 2025-11-28 南京鹏云网络科技有限公司 用于分布式存储系统的数据写入方法和装置
CN116186092A (zh) * 2023-03-14 2023-05-30 哈尔滨工业大学 基于Hadoop的知识图谱关系表存储的缓存方法及系统
US12072772B1 (en) 2023-04-12 2024-08-27 Kyndryl, Inc. Crowd sourced data restores
US20250103595A1 (en) * 2023-09-26 2025-03-27 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 (5)

* 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> 分散キャッシュ制御方法及び分散制御装置及び分散キャッシュシステム及び分散キャッシュ制御プログラムを格納した記憶媒体
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 (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012102103A1 (ja) * 2011-01-25 2012-08-02 日本電気株式会社 情報処理装置、情報処理システム、情報処理方法および情報処理プログラム
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
JP7208967B2 (ja) * 2017-09-29 2023-01-19 オラクル・インターナショナル・コーポレイション 異種ターゲットに対して使用するために分散型データソースからの変更データをキャプチャするためのシステムおよび方法
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 (6)

* 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> 分散キャッシュ制御方法及び分散制御装置及び分散キャッシュシステム及び分散キャッシュ制御プログラムを格納した記憶媒体
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 オラクル・インターナショナル・コーポレイション 分散コンピューティング環境内でゼロコピー２進基数木をサポートするためのシステムおよび方法
WO2016166844A1 (ja) * 2015-04-15 2016-10-20 株式会社日立製作所 分散処理システム、タスク処理方法、記憶媒体

Also Published As

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

Similar Documents

Publication Publication Date Title
US12524280B2 (en) Techniques for consistent multi-tenant behavior in microservices based applications
US12294585B2 (en) Techniques for automatically configuring minimal cloud service access rights for container applications
US12282781B2 (en) Cluster bootstrapping for distributed computing systems
US12111832B2 (en) Techniques for a deterministic distributed cache to accelerate SQL queries
US10223024B2 (en) Storage controller for provisioning storage services for an application based upon application-specific requirements
US12380102B2 (en) System and method for upgrading sparkline cluster with zero downtime
US11658972B2 (en) Isolated cell architecture for cloud computing platform
US11921726B2 (en) Logical partitions via header-based partition filtering
US12253915B2 (en) Techniques for scalable distributed system backups
US11650830B2 (en) Techniques for modifying a compute instance
US12079246B2 (en) System and methods for dynamic log indexing and processing
US20230216750A1 (en) Techniques for allocating capacity in cloud-computing environments
US20240403197A1 (en) Application performance monitoring for monolithic applications and distributed systems
JP2024524260A (ja) ダウンタイムなしで安全にデータベースを移行するための技術
US12271396B2 (en) Discovery of discrete partitioning information
US11494366B1 (en) Change data capture on no-master data stores

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