...
首页> 外文期刊>IEEE Transactions on Knowledge and Data Engineering >PrefDB: Supporting Preferences as First-Class Citizens in Relational Databases
【24h】

PrefDB: Supporting Preferences as First-Class Citizens in Relational Databases

机译:PrefDB:支持作为关系数据库中的一等公民的首选项

获取原文
获取原文并翻译 | 示例
           

摘要

In this paper, we argue that preference-aware query processing needs to be pushed closer to the DBMS. We introduce a preference-aware relational data model that extends database tuples with preferences and an extended algebra that captures the essence of processing queries with preferences. Based on a set of algebraic properties and a cost model that we propose, we provide several query optimization strategies for extended query plans. Further, we describe a query execution algorithm that blends preference evaluation with query execution, while making effective use of the native query engine. We have implemented our framework and methods in a prototype system, PrefDB. PrefDB allows transparent and efficient evaluation of preferential queries on top of a relational DBMS. Our extensive experimental evaluation on two real-world datasets demonstrates the feasibility and advantages of our framework.
机译:在本文中,我们认为需要将偏好感知的查询处理推向DBMS。我们介绍了一种偏好感知的关系数据模型,该模型可扩展具有优先选项的数据库元组,以及一个扩展的代数,可捕获具有优先选项的查询的本质。基于一组提议的代数性质和一个成本模型,我们为扩展查询计划提供了几种查询优化策略。此外,我们描述了一种查询执行算法,该算法将首选项评估与查询执行相结合,同时有效利用了本机查询引擎。我们已经在原型系统PrefDB中实现了我们的框架和方法。 PrefDB允许在关系型DBMS上透明有效地评估优先查询。我们对两个真实世界的数据集进行了广泛的实验评估,证明了我们框架的可行性和优势。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号