구문 패턴과 개체명사전을 이용한 자연어 질의문장의 SQL 자동 변환 방법

Abstract

Information society can be realized based on efficient collection, management and retrieval of large - scale information. Since the database (DB) is an important and important field in the information society, a system that facilitates DB access to general users can be regarded as an important core technology in the future. However, there is a restriction that general users should have knowledge of DB and business knowledge such as SQL in order to use DB directly. In order to solve the above limitations, researches on NLIDB (Natural Language Interfaces to Database System) are under way. To construct NLIDB, natural language processing technology and processing technology for DBMS (Database Management System) query language should precede. In this paper, I propose a method to convert to SQL statement so that general users without DB and SQL knowledge can search DB through natural language processing of query for the purpose of searching and using DB with general computing performance. The proposed method generates SQL by matching the columns using N-gram and named entity dictionary through natural language query. We analyze the experiment through the proposed method and describe the experimental result.