Type Ahead Search in Database using SQL
Main Article Content
Abstract
A type ahead search system computes answers on the fly as a user types in a keyword query character by character. We are going to study how to support type ahead search on data in a relational DBMS. We focus on how to help this type of search using the SQL. A prominent task that tests is how to influence existing database functionalities to meet the high performance to achieve an interactive speed. We extended the efficient way to the case of fuzzy queries, and suggested various techniques to improve query performance. We suggested incremental computation method to answer multi keyword queries, and calculated how to support first N queries and incremental updates. Our experimental results on large and real data sets showed that the proposed techniques can enables DBMS systems to support search as you type on large tables.
DOI: 10.17762/ijritcc2321-8169.150246
DOI: 10.17762/ijritcc2321-8169.150246
Article Details
How to Cite
, S. S. D. P. B. S. S. (2015). Type Ahead Search in Database using SQL. International Journal on Recent and Innovation Trends in Computing and Communication, 3(2), 641–645. https://doi.org/10.17762/ijritcc.v3i2.3878
Section
Articles