A Study To Support First-N Queries And Incremental Updates To Answer Multi Keyword Queries

Abstract

Most search engines and online search forms maintain auto completion which demonstrates suggested queries or even answers on the fly as a user types in a keyword query character by character. As many search systems accumulate their information in a backend relational DBMS. Some databases such as Oracle and SQL server already support prefix search and we could use this feature to do search-as-you-type. Still not all databases provide this feature. For this reason we study new methods that can be used in all databases. One approach is to expand a separate application layer on the database to construct indexes and execute algorithms for answering queries. While this approach has the benefit of achieving a high performance its main drawback is duplicating data and indexes resulting in additional hardware costs. Another approach is to use database extenders such as DB2 Extenders, Informix Data Blades, Microsoft SQL Server Common Language Runtime (CLR) integration and Oracle Cartridges which permit developers to implement new functionalities to a DBMS. This approach is not possible for databases that do not provide such an extender interface such as MySQL. Because it needs to utilize proprietary interfaces provided by database vendors a solution for one database may not be portable to others. In addition an extender-based solution particularly those implemented in C/C++ could cause severe dependability and security problems to database engines.

Authors and Affiliations

Ala Rajitha| Balaji Institute of Technology & Science Narsampet warangal, arajitha222@gmail.com, Mr. Fasi Ahmed Parvez| Balaji Institute of Technology & Science Narsampet warangal

Keywords

Related Articles

Smart Monitoring and Controlling of a System Using ARM11 SOC

This paper focuses on Smart monitoring and controlling of a system using ARM 11 SOC .Here Raspberry pi which is ARM11 SoC development board acts as the platform to which interfaces modules and monitor controlling mo...

A Distributed Clone Detection Protocol Considering Clone Detection Probability, Network Lifetime and Data Buffer Storage

We propose an energy-efficient location-aware clone location convention in thickly conveyed WSNs, which can ensure successful clone attack recognition and keep up attractive system lifetime. In particular, we misuse...

Self-assured Collective Data Transferring in Vehicular Ad Hoc Networks

Vehicular adhoc networks (VANETs) is the present innovation utilizing as a part of vehicles like cars and vans. Vehicles are considered as portable hubs in a MANET to make a versatile system likewise the most imperat...

We initially give a productive certificateless signcryption plan and afterward outline a get to control conspire for the WBANs utilizing the given signcryption. Our plan accomplishes classification, respectability, v...

The filter design optimization (FDO) issue is described as finding a strategy of channel coefficients that yields a channel format with scarcest whimsies, fulfilling the channel destinations. It has gotten a mammoth e...

Download PDF file
  • EP ID EP16429
  • DOI -
  • Views 345
  • Downloads 12

How To Cite

Ala Rajitha, Mr. Fasi Ahmed Parvez (2014). A Study To Support First-N Queries And Incremental Updates To Answer Multi Keyword Queries. International Journal of Science Engineering and Advance Technology, 2(12), 989-991. https://europub.co.uk./articles/-A-16429