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
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)
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)
| 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)
| 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)
| 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 |
-
2021
- 2021-06-16 US US17/349,813 patent/US12111832B2/en active Active
-
2022
- 2022-05-20 EP EP22729996.3A patent/EP4341826A1/en active Pending
- 2022-05-20 JP JP2023571975A patent/JP7904236B2/ja active Active
- 2022-05-20 WO PCT/US2022/030337 patent/WO2022246253A1/en not_active Ceased
- 2022-05-20 CN CN202280033210.3A patent/CN117321581A/zh active Pending
Patent Citations (5)
| 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 |