Research article · 2017
Research articlePublished Mar 2014
Optimizing Evaluated Preference Data in Relational Database Using Query Optimization
Abstract
Select any words in the title or abstract, or press this and choose a sentence.
Preference-aware queries are needed to be processed closer to the DBMS. Preference database tuples are elaborated from the preference-aware relational data model and the queries with the preferences are processed using an extended algebra. Query optimization strategies are provided for extended query plan based on the set of algebraic properties and cost model. Further illustration of an query execution algorithm that blends preference evaluation with query execution, simultaneously utilizing the native query engine. The framework and methods have been implemented in a prototype system, PrefDB. Transparent and efficient evaluations of preferential queries of a relational DBMS are allowed by PrefDB. This results in experimenting extensive evaluation on two real world data sets which illustrates the feasibility and advantages of the framework. Early pruning of results based on score or confidence during query processing are enabled by combining the prefer operator with the rank and rank join operators.
Subjects
EngineeringAsk about this article
Answers come only from this article's title, abstract and keywords, each sentence pointing to where it comes from. Your question is sent to OpenAI to write the answer. Scholars Central does not store it.
Similar by topic
Research article · Feb 2014
Schema for Object Oriented Dynamic Query Optimization and Modified Query using Mathematical Function Oriented Techniques in Databases
Research article · Apr 2013
Fuzzy Logic Based Query Optimization in Distributed Database
Research article · Apr 2015
Watermarking of Relational Databases Using Optimization Technique
Research article · 27 Jul 2015
On-Lib: An Application and Analysis of Fuzzy-Fast Query Searching and Clustering on Library Database
More from this journal
The newest in International Journal of Innovative Research in Science, Engineering and Technology.
Review article · 2018
Tech-Care: Personal Health Monitoring and Prediction System
Research article · 2018
Spectrum Sensing Methods for Cognitive Radio: A Survey
Review article · 2018
Utilization of Food Wastes to Prepare Film Forming Biomolecules (Retracted)
Conferences in this field
Upcoming conferences in this field.
Follow
New articles from what you follow go into your email digest, once you agree to alert emails.
- JournalInternational Journal of Innovative Research in Science, Engineering and Technology
- SubjectEngineering
- BylineArticles whose byline prints “Fathima Sanjas .M”
- BylineArticles whose byline prints “Shoba Rani .P”
