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 US11520738B2 (en) 2019-09-20 2020-04-01 Internal key hash directory in table
US16/837,730 2020-04-01

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 (enExample)
JP (1) JP2021051732A (enExample)
KR (1) KR102645141B1 (enExample)
CN (1) CN112540981B (enExample)
TW (1) TWI819230B (enExample)

Families Citing this family (9)

* 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 北京泰迪未来科技股份有限公司 大规模单向散列值的存储方法及装置

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
EP2270687A2 (en) 1995-04-11 2011-01-05 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
US8521751B2 (en) * 2008-08-22 2013-08-27 Nec Corporation Search device, a search method and a program
US20110270820A1 (en) * 2009-01-16 2011-11-03 Sanjiv Agarwal Dynamic Indexing while Authoring and Computerized Search Methods
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 株式会社東芝 ｋｅｙ−ｖａｌｕｅストア方式を有するメモリシステム
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
JP7189867B2 (ja) * 2016-08-25 2022-12-14 コーニンクレッカ フィリップス エヌ ヴェ 空間データの保存又は取り出しのためのシステム、方法、コンピュータ・プログラム及び記録媒体
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
US20210089498A1 (en) 2021-03-25
TWI819230B (zh) 2023-10-21
US11520738B2 (en) 2022-12-06
TW202113624A (zh) 2021-04-01
CN112540981B (zh) 2025-09-02
KR20210034471A (ko) 2021-03-30
JP2021051732A (ja) 2021-04-01
CN112540981A (zh) 2021-03-23

Similar Documents

Publication Publication Date Title
KR102645141B1 (ko) 데이터베이스 내 타겟 키를 검색하는 방법, 시스템, 및 비-휘발성 컴퓨터 판독가능한 매체
Zhang et al. Scalable top-k spatial keyword search
EP0961211B1 (en) Database method and apparatus using hierarchical bit vector index structure
JP6299596B2 (ja) クエリ類似度評価システム、評価方法、及びプログラム
WO2018161548A1 (zh) 一种基于二值码字典树的搜索方法
CN116048396B (zh) 基于日志结构化合并树的数据存储装置和存储控制方法
Wang et al. An Efficient Sliding Window Approach for Approximate Entity Extraction with Synonyms.
US20230342395A1 (en) Network key value indexing design
TW201807573A (zh) 電子裝置、資料洗滌裝置及對資料儲存裝置執行洗滌的方法
KR102568662B1 (ko) 복수의 스킵리스트를 병합하기 위한 지퍼 컴팩션 방법 및 장치
Sinha LSH vs randomized partition trees: Which one to use for nearest neighbor search?
CN113342828A (zh) 基于d维映射的哈希表冲突解决方法
KR20200140698A (ko) 동시 삽입 및 삭제를 이용한 캐시에서의 무경합 룩업을 위한 메커니즘
KR20010109067A (ko) 특징 벡터 데이터 공간의 인덱싱 방법
KR20230092443A (ko) 다중 버전 동시성제어 데이터베이스 시스템에서 신속한 데이터 버전 탐색 방법 및 장치
Endres et al. Indexing for skyline computation
Wang et al. Fast similarity search for high-dimensional dataset
JP3639480B2 (ja) 類似データ検索方法，類似データ検索装置，および類似データ検索用プログラム記録媒体
US20210089403A1 (en) Metadata table management scheme for database consistency
WO2017027007A1 (en) Using a shared priority queue for multi-threaded searching
RU2656721C1 (ru) Способ организации хранения частично совпадающих больших объектов
Mack et al. A content-based image retrieval technique with tolerance via multi-page differentiate hashing and binary-tree searching multi-object buckets
Hu et al. Preserving-ignoring transformation based index for approximate k nearest neighbor search
CN116932527B (zh) 数组遍历方法、装置及存储介质
US12216582B1 (en) Disk-based merge for combining merged hash maps

Legal Events

Date Code Title Description
PA0109 Patent application

Patent event code: PA01091R01D

Comment text: Patent Application

Patent event date: 20200605

PG1501 Laying open of application
E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

Comment text: Notification of reason for refusal

Patent event date: 20230921

Patent event code: PE09021S01D

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

Patent event code: PE07011S01D

Comment text: Decision to Grant Registration

Patent event date: 20231213

GRNT Written decision to grant
PR0701 Registration of establishment

Comment text: Registration of Establishment

Patent event date: 20240307

Patent event code: PR07011E01D

PR1002 Payment of registration fee

Payment date: 20240308

End annual number: 3

Start annual number: 1

PG1601 Publication of registration