INDEX GENERATION PROGRAM, INDEX GENERATION APPARATUS AND INDEX GENERATION METHOD

To accelerate search of target data described in an SQL statement.SOLUTION: An information processing apparatus 100 performs: processing to input a control statement being the control statement, in which a plurality of phrases having the control statement changed depending on a description position...

Full description

Saved in:
Bibliographic Details
Main Authors IDE TAKEHIRO, KATAOKA MASAHIRO, DENG CHEN
Format Patent
LanguageEnglish
Japanese
Published 22.07.2019
Subjects
Online AccessGet full text

Cover

Loading…
More Information
Summary:To accelerate search of target data described in an SQL statement.SOLUTION: An information processing apparatus 100 performs: processing to input a control statement being the control statement, in which a plurality of phrases having the control statement changed depending on a description position of the phrase included in the control statement are included; processing to generate first index information associated with positional information for each phrase in the control statement; and processing to generate a second index information group associated with the phrase being a target related to each of reserved words included in the control statement from the first index information.SELECTED DRAWING: Figure 1 【課題】SQL文に記述された対象データの検索を高速化すること。【解決手段】情報処理装置100は、制御文であって、当該制御文に含まれる語句の記述位置により当該制御文の内容が変化する語句を複数含む制御文を入力する処理と、制御文における語句ごとの位置情報に関する第1のインデックス情報を生成する処理と、第1のインデックス情報から、制御文に含まれる予約語それぞれに関して対象となる語句に関する第2のインデックス情報群を生成する処理と、を実行する。【選択図】図1
Bibliography:Application Number: JP20180000329