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

Scalable Coding of PRNG Encrypted Images

This paper proposes a unique scheme of scalable coding for PRNG encrypted images. In the encryption stage, the original pixel values are masked by a modulo-256 addition with pseudorandom numbers that are resulting fr...

A Novel Approach For Large-Scale D ata Processing Platform On Peer- To- Peer Based Bestpeer++

We introduce BestPeer++, a framework which conveys versatile information sharing administrations for corporate system applications in the cloud taking into account BestPeer—a distributed (P2P) based information adm...

Implementing Secure Authorized Deduplication Technique in Hybrid Cloud

Using the cloud resources optimally, like reducing the amount of storage space and saving bandwidth, is a challenging task. This can be highly achieved by adopting one of the important data compression techniques for...

We propose another revocable IBE plot with a cloud revocation authority (CRA) to unravel the two inadequacies, to be specific, the execution is essentially enhanced and the CRA holds just a framework mystery for ever...

Face Recognition Based Security System Using Sift Algorithm

Present days most of the door lock systems are organized by humans with the application of keys, secured password & unpredictable pattern to operate the door. The purpose of this paper is to help the users to develop...

Download PDF file
  • EP ID EP16429
  • DOI -
  • Views 306
  • 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