A Study To Support First-N Queries And Incremental Updates To Answer Multi Keyword Queries
Journal Title: International Journal of Science Engineering and Advance Technology - Year 2014, Vol 2, Issue 12
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
- EP ID EP16429
- DOI -
- Views 321
- Downloads 12
Distributed Manipulation Through Unidentified Data Accumulated In Cloud
Cloud computing is a rising registering standard in which resources of the processing structure are given as an administration over the Internet. As ensuring as it might be, this standard also conveys quite a few peo...
Bridge Construction for New Broad Guage Line
From the moment human started exploring he started to travel across the world after the world- war II due to the industrial revolution these became even intense to travel for overseas human used only ships but to tra...
A software fault prediction is a demonstrated strategy in accomplishing high software unwavering quality. Prediction of fault-inclined modules gives one approach to help software quality designing through enhanced bo...
Switching Activity Reduction Technique In Soc Testing
This paper discusses the generation Pseudo Random number generation using Low Power Linear Feedback Shift Resister (LFSR) which is more suitable for Built-In-Test (BIT) structures used for testing of VLSI circuits. B...
Contribution of Information Sharing In Wireless Sensor Network With Prune Delay
The increase in the number of smart phone users has lead to the increase in the peer-to-peer adhoc content sharing. Traditional data delivery schemes are not suitable for such networks due to intermittent connectivit...