Different Techniques of On-the-Fly Search on SQL Relational Database: Survey

Ansari Aadil S., Ujwala M. Patil

Abstract: Searching in a database was harder task in earlier times. In order to make search faster and easy, different techniques were developed. Main aim was to enter a query, even by an ignorant user so that he can get the results easily and also the cost of retrieval should be low. So we have selected some of the techniques and evaluated them. When the size of the increases it becomes even tough to retrieve the results. An Optimal search technique must render the requested data in a stipulated time based on the user query. Since large amount of data has to be processed, there has to be some order for ranking the queries to make the search a more efficient one. On-the-fly search is a method which gives answers when user types in a keyword query, one after the another character by character. This system which retrieve answers when a user types a keyword query is search-as-you-type The survey is based on the different techniques for search-as-you-type on the data present in a relational DBMS. The main aim of different methods is how to implement search as-you-type using the native language for database mainly SQL. Improving actual database functionalities to achieve improved performance in order to get an interactive speed is the main problem. Performance of the search can be increased using auxiliary indexes.

Keywords: DBMS; SQL; On-the-fly.