CN117321581A - 用于加速sql查询的确定性分布式高速缓存的技术 - Google Patents

用于加速sql查询的确定性分布式高速缓存的技术 Download PDF

Info

Publication number
CN117321581A
CN117321581A CN202280033210.3A CN202280033210A CN117321581A CN 117321581 A CN117321581 A CN 117321581A CN 202280033210 A CN202280033210 A CN 202280033210A CN 117321581 A CN117321581 A CN 117321581A
Authority
CN
China
Prior art keywords
data
nodes
cache
worker node
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.)
Pending
Application number
CN202280033210.3A
Other languages
English (en)
Chinese (zh)
Inventor
D·卡瓦利
A·马尔卡德
S·查拉伯蒂
H·R·布塔尼
V·巴斯卡尔
S·阿基纳佩利
D·达斯
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.)
Oracle International Corp
Original Assignee
Oracle International 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 Oracle International Corp filed Critical Oracle International Corp
Publication of CN117321581A publication Critical patent/CN117321581A/zh
Pending 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/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)
CN202280033210.3A 2021-05-21 2022-05-20 用于加速sql查询的确定性分布式高速缓存的技术 Pending CN117321581A (zh)

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 (1)

Publication Number Publication Date
CN117321581A true CN117321581A (zh) 2023-12-29

Family

ID=82020297

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202280033210.3A Pending CN117321581A (zh) 2021-05-21 2022-05-20 用于加速sql查询的确定性分布式高速缓存的技术

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

Family Cites Families (16)

* 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> コンテンツ配信方法
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
WO2016049575A1 (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
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
US10298715B2 (en) * 2015-04-15 2019-05-21 Hitachi, Ltd. Distributed processing system, task processing method, and storage medium
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

Also Published As

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

Similar Documents

Publication Publication Date Title
US12282781B2 (en) Cluster bootstrapping for distributed computing systems
US12524280B2 (en) Techniques for consistent multi-tenant behavior in microservices based applications
US12111832B2 (en) Techniques for a deterministic distributed cache to accelerate SQL queries
US12386974B2 (en) Threat change analysis system
JP2016524255A (ja) シャードのオンライン追加によるナイーブなクライアント側シャーディング
US12253915B2 (en) Techniques for scalable distributed system backups
US11650830B2 (en) Techniques for modifying a compute instance
US20220103554A1 (en) Isolated cell architecture for cloud computing platform
US11917033B2 (en) Techniques for managing distributed computing components
US12079246B2 (en) System and methods for dynamic log indexing and processing
US20250030680A1 (en) Compartment level binding for workload identity
US20250258804A1 (en) Techniques For Safe Database Migration With No Downtime
US12613853B2 (en) Fast iterators for key-value databases
US12271396B2 (en) Discovery of discrete partitioning information
US20250030542A1 (en) Replication of customer keys stored in a virtual vault
US12353420B2 (en) Techniques for providing synchronous and asynchronous data processing

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination