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 96
- Downloads 0
SGEDSS: Semantic Gene Expression Model for Communication Decision Supportsystem
Abstract: An effective decision support system needs to deal with several heterogeneous data sources. Sometimes, the knowledge was explored without integration data sources are wrong. Also, Decision support system is wea...
The Impact of Security Overhead Traffic on Network’s ResourcesPerformance
Abstract: Security of transferred data is a big concern for data networks users .One of the best securitysolutions is the IPSec Virtual Private Networking (IPSec VPN).In this paper, The Impact of additional traffic...
A Survey on Routing Protocols influencing Mobile Sink in enhancing life time of WSN for Data gathering
Abstract: Wireless Sensor Network is a group of specialized sensors have the ability to sense, monitor, communicate to the neighbors and recording conditions at assorted locations such as temperature, sound, pressure, se...
A Novel Approach for Workload Optimization and ImprovingSecurity in Cloud Computing Environments
Abstract: This paper discusses a propose cloud infrastructure that combines On-Demand allocation ofresources with improved utilization, opportunistic provisioning of cycles from idle cloud nodes to otherprocesses.B...
Recovery of Data in Cluster Computing By Using Fault TolerantMechanisms
Abstract: Many applications executing on cluster architectures consisting of several number of computerscreate several problems with reliability. The problems are system crashes, code failures and network problemse...