Fuzzy Multi-Join and Top-K Query Model for Search-As-You-Type in Multiple Tables?

A search-as-you-type system determines answers on-the-fly as a user types in a keyword query, character by character. There arises a higher need to know the support search-as-you-type on data residing in a relational DBMS. The existing work on keyword query focuses on to support type of search using the native database SQL. The leverage existing database functionalities is to meet high performance requirement to achieve an interactive speed. It uses auxiliary indexes that are stored as tables to increase search performance. But the main drawbacks in existing work were that it handle search as you type for databases for single table at the same time multiple tables were not taken into consideration. The Proposed work presents a Fuzzy Multi-Join technique to support multiple tables for search as-you-type in relational databases. Further the proposal presents a Top-K Query Search model to support ranking queries for search as-you-type in relational databases Top-k join queries are generated in relational query processors.