Dynamic Query Processing and Optimization in Relational Complex Databases with Keyword Search
Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2014, Vol 16, Issue 5
Abstract
Abstract: Dynamic queries are a novel approach to information seeking that may enable users to cope with information overload. They allow users to see an overview of the database, rapidly explore and conveniently filter out unwanted information. Users fly through information spaces by incrementally adjusting a query while continuously viewing the changing results. The main drawback of a form-based query interface is that it is restrictive. Modern scientific databases and web databases maintain large and heterogeneous data. These real-world databases contain over hundreds or even thousands of relations and attributes. Traditional predefined query forms are not able to satisfy various ad-hoc queries from users on those databases. So a Dynamic Query Form (DQF) system was proposed. Dynamic queries interfaces suggest that they offer a dramatic change from existing methods for querying databases. DQF, a query interface which is capable of dynamically generating query forms for users. Different from traditional document retrieval users in database retrieval are capable of performing different round of actions iteratively by filling in forms and retrieving results based on users desire and conditions at run time. Each iteration consists of two types of user interactions: Query Form Endowment and Query Execution. In Query Form Endowment DQF recommends the user selects the desired form components into the current query form and the form components selected by the user will be in ranked order. In Query Execution the user fills out the current query form and submits a query, DQF executes the query and shows the results and the user provides the feedback about the query results. F-measure value can be used for measuring the goodness of a query form. A comparison between the Customized query form and Dynamic query form can be generated. As an enhancement, the database querying can be formalized by combining the keyword search and forms. Here at query time, a user with a question to be answered issues standard keyword search queries; but instead of returning tuples, the system returns forms relevant to the question. This paper lacks the addressing of multi-criteria decision making. So skyline query concept is used for satisfying the multi-criteria decision making.
Authors and Affiliations
Remya Raj , Rosna P. Haroon
Keywords
Related Articles
- EP ID EP121585
- DOI 10.9790/0661-16534249
- Views 113
- Downloads 0
Computational Analysis of Sequences to Determine Expectation Value Commonly Used in Bioinformatics Database.
Abstract: Solanum lycopersicum economically important crop world wide, intensively investigated and model system for genetic studies in plant ,variability is a measure spread of data set. Genome analysis andannotation us...
A Review on Study and Comparison between 2D Gel Electrophoresis and Mass Spectrometry
Protein structure prediction is an important area of life sciences. The Protein prophecy is unbreakable because of its complex structure. The main problem in proteomics is to estimate the several proteins available in ce...
Detection and Localization of Multiple Spoofing Attackers in Wireless Networks
Wireless spoofing attacks are easy to launch and can significantly impact the performance of networks. Although the identity of a node can be verified through cryptographic authentication, conventional security a...
A web-based Child vaccination system in Bangladesh
Vaccination is the way of prevention from various infectious diseases. It stimulates the immune system against a pathogen. In many developed countries, the process of Vaccination system is not technology based. In Bangla...
New and Unconventional Techniques in Pictorial Steganography and Steganalysis
Steganography involves transferring data through a given channel in such a way that the communication channel itself is hidden from all involved parties. It is a form of security through obscurity; this technique p...