arrow
返回

Semantic optimization techniques for preference queries

delete2007-07-01
delete15
delete
OA
AI
J
Jan Chomicki *
DOI:10.1016/j.is.2006.05.002delete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
Preference queries are relational algebra or SQL queries that contain occurrences of the winnow operator (find the most preferred tuples in a given relation). Such queries are parameterized by specific preference relations. Semantic optimization techniques make use of integrity constraints holding in the database. In the context of semantic optimization of preference queries, we identify two fundamental properties: containment of preference relations relative to integrity constraints and satisfaction of order axioms relative to integrity constraints. We show numerous applications of those notions to preference query evaluation and optimization. As integrity constraints, we consider constraint-generating dependencies, a class generalizing functional dependencies. We demonstrate that the problems of containment and satisfaction of order axioms can be captured as specific instances of constraint-generating dependency entailment. This makes it possible to formulate necessary and sufficient conditions for the applicability of our techniques as constraint validity problems. We characterize the computational complexity of such problems. (c) 2006 Elsevier B.V. All rights reserved.
Keyword:
preference queries
query optimization
query evaluation
integrity constraints
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

Enterprise Information Systems 封面图
Enterprise Information Systems
IF:
3.9
论文数:
2.8K
被引数:
1.8K

机构

暂无机构信息
引用论文

引用论文

err分享
err收藏
When Theater Comes to Engineering Design: Oh How Creative They Can Be当戏剧走进工程设计:他们能有多具创造力
err2017-06-06
err0
PREAI
errFerris M. Pfeiffer; Rachel E. Bauer; Steve Borgelt; Suzanne Burgoyne; Sheila Grant; Heather K. Hunt; Jennie J. Pardoe; David C. Schmidt
err分享
err收藏
Black Soy Peptide Supplementation Improves Glucose Control in Subjects with Prediabetes and Newly Diagnosed Type 2 Diabetes Mellitus
err2010-12-01
err0
PREAI
errJung Hyun Kwak; Jong Ho Lee; Chang-Won Ahn; Soo-Hyun Park; Sun-Taek Shim; Yong Duk Song; Eun Narae Han; Ki Ho Lee; Jey-Sook Chae
err分享
err收藏
Photoconducting properties of a ladder polymer梯形聚合物的光电导性能
err1995-04-15
err0
PREAI
errK. S. Narayan; B. E. Taylor-Hamilton; R. J. Spry; J. B. Ferguson
err分享
err收藏
学者 查看更多内容