KR102645141B1 - 데이터베이스 내 타겟 키를 검색하는 방법, 시스템, 및 비-휘발성 컴퓨터 판독가능한 매체 - Google Patents

데이터베이스 내 타겟 키를 검색하는 방법, 시스템, 및 비-휘발성 컴퓨터 판독가능한 매체 Download PDF

Info

Publication number
KR102645141B1
KR102645141B1 KR1020200068315A KR20200068315A KR102645141B1 KR 102645141 B1 KR102645141 B1 KR 102645141B1 KR 1020200068315 A KR1020200068315 A KR 1020200068315A KR 20200068315 A KR20200068315 A KR 20200068315A KR 102645141 B1 KR102645141 B1 KR 102645141B1
Authority
KR
South Korea
Prior art keywords
hash
key
value
target
offset
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
KR1020200068315A
Other languages
English (en)
Korean (ko)
Other versions
KR20210034471A (ko
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 KR20210034471A publication Critical patent/KR20210034471A/ko
Application granted granted Critical
Publication of KR102645141B1 publication Critical patent/KR102645141B1/ko
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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/13—File access structures, e.g. distributed indices
    • G06F16/137—Hash-based
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/14—Details of searching files based on file metadata
    • G06F16/148—File search processing
    • G06F16/152—File search processing using file content signatures, e.g. hash values
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2255—Hash tables
    • 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
    • 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/24553—Query execution of query operations
    • G06F16/24558—Binary matching operations
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/31—Indexing; Data structures therefor; Storage structures
    • G06F16/316—Indexing structures
    • G06F16/325—Hash tables
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/901—Indexing; Data structures therefor; Storage structures
    • G06F16/9014—Indexing; Data structures therefor; Storage structures hash tables

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Library & Information Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Radar Systems Or Details Thereof (AREA)
KR1020200068315A 2019-09-20 2020-06-05 데이터베이스 내 타겟 키를 검색하는 방법, 시스템, 및 비-휘발성 컴퓨터 판독가능한 매체 Active KR102645141B1 (ko)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US201962903637P 2019-09-20 2019-09-20
US62/903,637 2019-09-20
US16/837,730 2020-04-01
US16/837,730 US11520738B2 (en) 2019-09-20 2020-04-01 Internal key hash directory in table

Publications (2)

Publication Number Publication Date
KR20210034471A KR20210034471A (ko) 2021-03-30
KR102645141B1 true KR102645141B1 (ko) 2024-03-12

Family

ID=74880963

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020200068315A Active KR102645141B1 (ko) 2019-09-20 2020-06-05 데이터베이스 내 타겟 키를 검색하는 방법, 시스템, 및 비-휘발성 컴퓨터 판독가능한 매체

Country Status (5)

Country Link
US (1) US11520738B2 (cg-RX-API-DMAC7.html)
JP (1) JP2021051732A (cg-RX-API-DMAC7.html)
KR (1) KR102645141B1 (cg-RX-API-DMAC7.html)
CN (1) CN112540981B (cg-RX-API-DMAC7.html)
TW (1) TWI819230B (cg-RX-API-DMAC7.html)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
FR3103664B1 (fr) * 2019-11-27 2023-04-07 Amadeus Sas Système de stockage distribué pour stocker des données contextuelles
US11756619B2 (en) * 2021-03-31 2023-09-12 Micron Technology, Inc. Key storage for sorted string tables using content addressable memory
US11954345B2 (en) * 2021-12-03 2024-04-09 Samsung Electronics Co., Ltd. Two-level indexing for key-value persistent storage device
CN114490638B (zh) * 2021-12-29 2025-03-11 北京乐普四方方圆科技股份有限公司 索引表创建方法和装置、目标记录查找方法和装置
JP2023140128A (ja) * 2022-03-22 2023-10-04 キオクシア株式会社 永続記憶装置、ホスト及び永続記憶装置の制御方法
US12135722B2 (en) * 2022-07-14 2024-11-05 Samsung Electronics Co., Ltd. Systems and methods for data comparison
US12038916B1 (en) 2022-12-30 2024-07-16 Atlassian Pty Ltd. User interface for formulating structured queries and generating graphical objects within a content collaboration platform
US12277112B2 (en) * 2022-12-30 2025-04-15 Atlassian Pty Ltd. Content collaboration platform with interface for conducting structured queries and embedding issue content of an issue tracking platform
CN117424698A (zh) * 2023-10-07 2024-01-19 北京泰迪未来科技股份有限公司 大规模单向散列值的存储方法及装置
KR102924090B1 (ko) * 2023-11-21 2026-02-06 주식회사 한글과컴퓨터 문서 파일의 빠른 저장을 지원하는 컴퓨팅 장치 및 그 동작 방법

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2014510318A (ja) 2011-02-03 2014-04-24 株式会社リコー アプリケーションを認証するためのシグネチャを生成する方法及びシステム
US20170250708A1 (en) 2016-02-29 2017-08-31 International Business Machines Corporation High-Throughput Compression of Data
US20190034427A1 (en) 2017-12-28 2019-01-31 Intel Corporation Data management system employing a hash-based and tree-based key-value data structure

Family Cites Families (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0826181A4 (en) 1995-04-11 2005-02-09 Kinetech Inc IDENTIFYING DATA IN A DATA PROCESSING SYSTEM
US6067547A (en) * 1997-08-12 2000-05-23 Microsoft Corporation Hash table expansion and contraction for use with internal searching
GB9811574D0 (en) 1998-05-30 1998-07-29 Ibm Indexed file system and a method and a mechanism for accessing data records from such a system
US7523098B2 (en) 2004-09-15 2009-04-21 International Business Machines Corporation Systems and methods for efficient data searching, storage and reduction
US7784094B2 (en) * 2005-06-30 2010-08-24 Intel Corporation Stateful packet content matching mechanisms
WO2010021376A1 (ja) * 2008-08-22 2010-02-25 日本電気株式会社 検索装置、検索方法およびプログラム
WO2010082207A1 (en) * 2009-01-16 2010-07-22 Sanjiv Agarwal Dynamic indexing while authoring
US20110276744A1 (en) 2010-05-05 2011-11-10 Microsoft Corporation Flash memory cache including for use with persistent key-value store
US8880554B2 (en) * 2010-12-03 2014-11-04 Futurewei Technologies, Inc. Method and apparatus for high performance, updatable, and deterministic hash table for network equipment
JP5524144B2 (ja) * 2011-08-08 2014-06-18 株式会社東芝 key−valueストア方式を有するメモリシステム
US8788788B2 (en) 2011-08-11 2014-07-22 Pure Storage, Inc. Logical sector mapping in a flash storage array
US9189509B1 (en) * 2012-09-21 2015-11-17 Comindware Ltd. Storing graph data representing workflow management
US20140297651A1 (en) * 2013-04-01 2014-10-02 Ori Software Development Ltd. Using hash table to retrieve leaf index blocks
US9537771B2 (en) * 2013-04-04 2017-01-03 Marvell Israel (M.I.S.L) Ltd. Exact match hash lookup databases in network switch devices
US9256549B2 (en) * 2014-01-17 2016-02-09 Netapp, Inc. Set-associative hash table organization for efficient storage and retrieval of data in a storage system
US9965482B2 (en) 2014-06-24 2018-05-08 Infinidat Ltd. Hash based read and write operations in a storage system
US20160350302A1 (en) * 2015-05-27 2016-12-01 Hedvig, Inc. Dynamically splitting a range of a node in a distributed hash table
US9971526B1 (en) * 2015-06-29 2018-05-15 Amazon Technologies, Inc. Volume-based key-value store
KR20170028825A (ko) * 2015-09-04 2017-03-14 퓨어 스토리지, 아이앤씨. 압축된 인덱스들을 사용한 해시 테이블들에서의 메모리 효율적인 스토리지 및 탐색
US10108547B2 (en) * 2016-01-06 2018-10-23 Netapp, Inc. High performance and memory efficient metadata caching
CN107153643B (zh) * 2016-03-02 2021-02-19 阿里巴巴集团控股有限公司 数据表连接方法及装置
CN106096023B (zh) * 2016-06-24 2019-03-08 腾讯科技(深圳)有限公司 数据读取方法、数据写入方法及数据服务器
US10515064B2 (en) * 2016-07-11 2019-12-24 Microsoft Technology Licensing, Llc Key-value storage system including a resource-efficient index
EP3504636A1 (en) * 2016-08-25 2019-07-03 Koninklijke Philips N.V. Storing and retrieving spatial data in/from a database
US10706106B2 (en) * 2017-02-09 2020-07-07 Micron Technology, Inc. Merge tree modifications for maintenance operations
US10474656B1 (en) * 2017-02-21 2019-11-12 Nutanix, Inc. Repurposing log files
CN109947669B (zh) * 2017-12-21 2024-11-01 北京忆恒创源科技股份有限公司 Kv存储设备的地址转换方法与系统
WO2019128166A1 (zh) * 2017-12-29 2019-07-04 北京忆恒创源科技有限公司 Kv存储设备以及使用kv存储设备提供文件系统
US11100071B2 (en) * 2018-10-10 2021-08-24 Micron Technology, Inc. Key-value store tree data block spill with compaction
CN110083601B (zh) * 2019-04-04 2021-11-30 中国科学院计算技术研究所 面向键值存储系统的索引树构建方法及系统

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2014510318A (ja) 2011-02-03 2014-04-24 株式会社リコー アプリケーションを認証するためのシグネチャを生成する方法及びシステム
US20170250708A1 (en) 2016-02-29 2017-08-31 International Business Machines Corporation High-Throughput Compression of Data
US20190034427A1 (en) 2017-12-28 2019-01-31 Intel Corporation Data management system employing a hash-based and tree-based key-value data structure

Also Published As

Publication number Publication date
TW202113624A (zh) 2021-04-01
CN112540981A (zh) 2021-03-23
CN112540981B (zh) 2025-09-02
TWI819230B (zh) 2023-10-21
US11520738B2 (en) 2022-12-06
US20210089498A1 (en) 2021-03-25
KR20210034471A (ko) 2021-03-30
JP2021051732A (ja) 2021-04-01

Similar Documents

Publication Publication Date Title
US11520738B2 (en) Internal key hash directory in table
Zhang et al. Scalable top-k spatial keyword search
EP0961211B1 (en) Database method and apparatus using hierarchical bit vector index structure
US20100082664A1 (en) Method for searching a tree structure
JP6299596B2 (ja) クエリ類似度評価システム、評価方法、及びプログラム
WO2018161548A1 (zh) 一种基于二值码字典树的搜索方法
CN116048396A (zh) 基于日志结构化合并树的数据存储装置和存储控制方法
KR20090065130A (ko) 시그니처 파일을 이용한 고차원 데이터 색인 및 검색방법과 그 시스템
Wang et al. An Efficient Sliding Window Approach for Approximate Entity Extraction with Synonyms.
KR20220105612A (ko) 해시 기반의 키 밸류에 관한 블록 변환 방법 및 시스템
KR102568662B1 (ko) 복수의 스킵리스트를 병합하기 위한 지퍼 컴팩션 방법 및 장치
Li et al. Sindi: an efficient index for approximate maximum inner product search on sparse vectors
KR20200140698A (ko) 동시 삽입 및 삭제를 이용한 캐시에서의 무경합 룩업을 위한 메커니즘
CN117389950A (zh) 基于学习索引的lsm树层设计方法及系统
WO2017027007A1 (en) Using a shared priority queue for multi-threaded searching
Tang et al. Exploit every bit: Effective caching for high-dimensional nearest neighbor search
KR20010109067A (ko) 특징 벡터 데이터 공간의 인덱싱 방법
Georgiadis et al. Skyline-based dissimilarity of images
KR20230092443A (ko) 다중 버전 동시성제어 데이터베이스 시스템에서 신속한 데이터 버전 탐색 방법 및 장치
Wang et al. Fast similarity search for high-dimensional dataset
Endres et al. Indexing for skyline computation
JP3639480B2 (ja) 類似データ検索方法,類似データ検索装置,および類似データ検索用プログラム記録媒体
US20210089403A1 (en) Metadata table management scheme for database consistency
RU2656721C1 (ru) Способ организации хранения частично совпадающих больших объектов
US12511275B2 (en) Disk-based merge for hash maps

Legal Events

Date Code Title Description
PA0109 Patent application

St.27 status event code: A-0-1-A10-A12-nap-PA0109

PG1501 Laying open of application

St.27 status event code: A-1-1-Q10-Q12-nap-PG1501

R17-X000 Change to representative recorded

St.27 status event code: A-3-3-R10-R17-oth-X000

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

PA0201 Request for examination

St.27 status event code: A-1-2-D10-D11-exm-PA0201

PA0302 Request for accelerated examination

St.27 status event code: A-1-2-D10-D17-exm-PA0302

St.27 status event code: A-1-2-D10-D16-exm-PA0302

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

St.27 status event code: A-1-2-D10-D21-exm-PE0902

P11-X000 Amendment of application requested

St.27 status event code: A-2-2-P10-P11-nap-X000

P13-X000 Application amended

St.27 status event code: A-2-2-P10-P13-nap-X000

E701 Decision to grant or registration of patent right
PE0701 Decision of registration

St.27 status event code: A-1-2-D10-D22-exm-PE0701

GRNT Written decision to grant
PR0701 Registration of establishment

St.27 status event code: A-2-4-F10-F11-exm-PR0701

PR1002 Payment of registration fee

St.27 status event code: A-2-2-U10-U11-oth-PR1002

Fee payment year number: 1

PG1601 Publication of registration

St.27 status event code: A-4-4-Q10-Q13-nap-PG1601

R18 Changes to party contact information recorded

Free format text: ST27 STATUS EVENT CODE: A-5-5-R10-R18-OTH-X000 (AS PROVIDED BY THE NATIONAL OFFICE)

R18-X000 Changes to party contact information recorded

St.27 status event code: A-5-5-R10-R18-oth-X000

R18 Changes to party contact information recorded

Free format text: ST27 STATUS EVENT CODE: A-5-5-R10-R18-OTH-X000 (AS PROVIDED BY THE NATIONAL OFFICE)

R18-X000 Changes to party contact information recorded

St.27 status event code: A-5-5-R10-R18-oth-X000

R18 Changes to party contact information recorded

Free format text: ST27 STATUS EVENT CODE: A-5-5-R10-R18-OTH-X000 (AS PROVIDED BY THE NATIONAL OFFICE)

R18-X000 Changes to party contact information recorded

St.27 status event code: A-5-5-R10-R18-oth-X000