Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
METHOD FOR OPTIMIZING DATABASE USING KNOB VECTOR REPRESENTATION
Document Type and Number:
WIPO Patent Application WO/2024/090664
Kind Code:
A1
Abstract:
A method for optimizing a database using knob vector representation comprises the steps of: receiving, by means of a computer device, an input of information about a target workload of the database; and determining, by means of the computer device, an optimal setting value for the database using a genetic algorithm. The computer device determines the degree of suitability on the basis of the difference between a predicted value output by a learning model that receives an input of the setting values of knobs in the genetic algorithm and a default value of the target workload.

Inventors:
PARK SANG HYUN (KR)
LEE JI EUN (KR)
CHOI JONG HWAN (KR)
SEO SANG MIN (KR)
Application Number:
PCT/KR2022/019378
Publication Date:
May 02, 2024
Filing Date:
December 01, 2022
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
UIF UNIV INDUSTRY FOUNDATION YONSEI UNIV (KR)
International Classes:
G06F16/25; G06F16/21; G06N3/04; G06N3/08; G06N20/00
Foreign References:
US20060230006A12006-10-12
KR20220095092A2022-07-06
KR20220073453A2022-06-03
KR20170113619A2017-10-12
Other References:
VAN AKEN DANA; PAVLO ANDREW; GORDON GEOFFREY J.; ZHANG BOHAN: "Automatic Database Management System Tuning Through Large-scale Machine Learning", PROCEEDINGS OF THE 39TH ACM SIGPLAN CONFERENCE ON PROGRAMMING LANGUAGE DESIGN AND IMPLEMENTATION, SOCIETY FOR COMPUTER SIMULATION INTERNATIONALPUB1344, SAN DIEGO, CA, USA, 9 May 2017 (2017-05-09) - 18 April 2018 (2018-04-18), San Diego, CA, USA, pages 1009 - 1024, XP059200512, ISBN: 978-1-5108-6016-2, DOI: 10.1145/3035918.3064029
JIEUN LEE: "K2vtune: Automatic Database Tuning with Knob Vector Representation", SSRN ELECTRONIC JOURNAL, SOCIAL SCIENCE RESEARCH NETWORK, US, 1 January 2022 (2022-01-01), US , XP093162748, ISSN: 1556-5068, DOI: 10.2139/ssrn.4225456
Attorney, Agent or Firm:
ISIS IP LAW LLC (KR)
Download PDF: