Supporting Search-As-You-Type Using SQL in Databases

Provided by: IJCTT-International Journal of Computer Trends and Technology
Topic: Data Management
Format: PDF
A search-as-you-type system determines answers while a user types a keyword query character by character. The authors study the search-as-you-type on data which is residing in a relational DBMS. They focus on native database language, SQL as how to support this type of search. A main challenge is how to make full use of existing database functionalities to meet the high-performance to achieve an interactive speed. Further they study how to use auxiliary indexes stored in the tables to increase the search performance. They present solutions for both multi keyword queries and single-keyword queries, and develop novel techniques for the fuzzy search using SQL by allowing the mismatches between query keywords and answers.

Find By Topic