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

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> コンテンツ配信方法
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
CN106716412B (zh) 2014-09-25 2020-08-14 甲骨文国际公司 用于支持分布式计算环境中的零拷贝二进制基数树的系统和方法
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
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

Also Published As

Publication number Publication date
US20220374431A1 (en) 2022-11-24
JP7904236B2 (ja) 2026-08-12
US12111832B2 (en) 2024-10-08
EP4341826A1 (en) 2024-03-27
JP2024521730A (ja) 2024-06-04
WO2022246253A1 (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
US12093285B2 (en) Techniques for live repartitioning of cross-service database shards
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
US20230144341A1 (en) Edge attestation for authorization of a computing node in a cloud infrastructure system
US20250315437A1 (en) Techniques for providing synchronous and asynchronous data processing
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

Legal Events

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