Manuscript Number : IJSRSET152276
Database Traversal to Support Search Enhance Technique using SQL
Authors(4) :-Sivakumar K, Sriram U, Yasar Arafath S, Bhanu Priya
A search-as-you-type system computes answers on-the-fly as a user sorts during a keyword question character by character. We have a tendency to support search-as-you-type on information residing during relative software. We have a tendency to target the way to support this kind of search mistreatment the native information language, SQL. A main challenge is the way to leverage existing information functionalities to satisfy the high performance demand to realize associate interactive speed. We have a tendency to use auxiliary indexes hold on as tables to extend search performance. We have a tendency to gift solutions for each single-keyword queries and multi keyword queries, and develop novel techniques for fuzzy search mistreatment SQL by permitting mismatches between question keywords and answers. We gift techniques to answer first-N queries and discuss the way to support updates expeditiously. Experiments on massive, real information sets show that our techniques modify software systems on a trade goods pc to support search-as-you-type on tables with a lot of records.
Sivakumar K
Search-as-you-type, databases, SQL, fuzzy search
Publication Details
Published in :
Volume 1 | Issue 2 | March-April 2015 Article Preview
Computer Science and Engineering, Dhanalakshmi College of Engineering, Chennai, Tamilnadu, India
Sriram U
Computer Science and Engineering, Dhanalakshmi College of Engineering, Chennai, Tamilnadu, India
Yasar Arafath S
Computer Science and Engineering, Dhanalakshmi College of Engineering, Chennai, Tamilnadu, India
Bhanu Priya
Computer Science and Engineering, Dhanalakshmi College of Engineering, Chennai, Tamilnadu, India
Date of Publication :
2015-04-25
License: This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) :
200-204
Manuscript Number :
IJSRSET152276
Publisher : Technoscience Academy
Journal URL :
http://ijsrset.com/IJSRSET152276