Search for the blind: A schema independent query method using concept hierarchy and keywords

Dong Ha Lee; Su Woong Kim; Gabrielle Methou; Jeon Young Lee

doi:10.1016/s0360-8352(97)00215-5

Search for the blind: A schema independent query method using concept hierarchy and keywords

Dong Ha Lee, Su Woong Kim, Gabrielle Methou, Jeon Young Lee

Department of Artificial Intelligence

Research output: Contribution to journal › Article › peer-review

Abstract

Some database schema is very complex and it changes more frequently than the past. On the other hands, in such application database as scientific database and decision-support database, the importance of ad-hoc queries is expected to increase. Therefore the ability of a system to support ad-hoc queries without knowing the database schema information is needed. In this paper, we will describe a method to create candidate structured queries with concept hierarchy using user-input keywords. We will create structured queries in the following step; first, we extract the schema items related to keywords, and second, we compose possible paths between schema items, thus formulate candidate SQL queries.

Original language	English
Pages (from-to)	657-660
Number of pages	4
Journal	Computers and Industrial Engineering
Volume	33
Issue number	3-4
DOIs	https://doi.org/10.1016/s0360-8352(97)00215-5
Publication status	Published - 1997 Dec

Bibliographical note

Funding Information:
* This paper was supported in part by '95 SPECIAL FUND for UNIVERSITY RESEARCH INSTITUE, Korea Research Foundation.

All Science Journal Classification (ASJC) codes

Computer Science(all)
Engineering(all)

Access to Document

10.1016/s0360-8352(97)00215-5

Cite this

@article{ce4a762bf44742dbbcad047130199fa6,

title = "Search for the blind: A schema independent query method using concept hierarchy and keywords",

abstract = "Some database schema is very complex and it changes more frequently than the past. On the other hands, in such application database as scientific database and decision-support database, the importance of ad-hoc queries is expected to increase. Therefore the ability of a system to support ad-hoc queries without knowing the database schema information is needed. In this paper, we will describe a method to create candidate structured queries with concept hierarchy using user-input keywords. We will create structured queries in the following step; first, we extract the schema items related to keywords, and second, we compose possible paths between schema items, thus formulate candidate SQL queries.",

author = "Lee, {Dong Ha} and Kim, {Su Woong} and Gabrielle Methou and Lee, {Jeon Young}",

note = "Funding Information: * This paper was supported in part by '95 SPECIAL FUND for UNIVERSITY RESEARCH INSTITUE, Korea Research Foundation.",

year = "1997",

month = dec,

doi = "10.1016/s0360-8352(97)00215-5",

language = "English",

volume = "33",

pages = "657--660",

journal = "Computers and Industrial Engineering",

issn = "0360-8352",

publisher = "Elsevier Limited",

number = "3-4",

}

TY - JOUR

T1 - Search for the blind

T2 - A schema independent query method using concept hierarchy and keywords

AU - Lee, Dong Ha

AU - Kim, Su Woong

AU - Methou, Gabrielle

AU - Lee, Jeon Young

N1 - Funding Information: * This paper was supported in part by '95 SPECIAL FUND for UNIVERSITY RESEARCH INSTITUE, Korea Research Foundation.

PY - 1997/12

Y1 - 1997/12

N2 - Some database schema is very complex and it changes more frequently than the past. On the other hands, in such application database as scientific database and decision-support database, the importance of ad-hoc queries is expected to increase. Therefore the ability of a system to support ad-hoc queries without knowing the database schema information is needed. In this paper, we will describe a method to create candidate structured queries with concept hierarchy using user-input keywords. We will create structured queries in the following step; first, we extract the schema items related to keywords, and second, we compose possible paths between schema items, thus formulate candidate SQL queries.

AB - Some database schema is very complex and it changes more frequently than the past. On the other hands, in such application database as scientific database and decision-support database, the importance of ad-hoc queries is expected to increase. Therefore the ability of a system to support ad-hoc queries without knowing the database schema information is needed. In this paper, we will describe a method to create candidate structured queries with concept hierarchy using user-input keywords. We will create structured queries in the following step; first, we extract the schema items related to keywords, and second, we compose possible paths between schema items, thus formulate candidate SQL queries.

UR - http://www.scopus.com/inward/record.url?scp=0031373650&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0031373650&partnerID=8YFLogxK

U2 - 10.1016/s0360-8352(97)00215-5

DO - 10.1016/s0360-8352(97)00215-5

M3 - Article

AN - SCOPUS:0031373650

SN - 0360-8352

VL - 33

SP - 657

EP - 660

JO - Computers and Industrial Engineering

JF - Computers and Industrial Engineering

IS - 3-4

ER -

Search for the blind: A schema independent query method using concept hierarchy and keywords

Abstract

Bibliographical note

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this