• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文会议>Proof of Designed Reliability >Distributed/heterogeneous query processing in Microsoft SQL server
【24h】

Distributed/heterogeneous query processing in Microsoft SQL server

机译：Microsoft SQL Server中的分布式/异构查询处理

获取原文
获取原文并翻译 | 示例
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

This paper presents an architecture overview of the distributed, heterogeneous query processor (DHQP) in the Microsoft SQL server database system to enable queries over a large collection of diverse data sources. The paper highlights three salient aspects of the architecture. First, the system introduces well-defined abstractions such as connections, commands, and rowsets that enable sources to plug into the system. These abstractions are formalized by the OLE DB data access interfaces. The generality of OLE DB and its broad industry adoption enables our system to reach a very large collection of diverse data sources ranging from personal productivity tools, to database management systems, to file system data. Second, the DHQP is built-in to the relational optimizer and execution engine of the system. This enables DH queries and updates to benefit from the cost-based algebraic transformations and execution strategies available in the system. Finally, the architecture is inherently extensible to support new data sources as they emerge as well as serves as a key extensibility point for the relational engine to add new features such as full-text search and distributed partitioned views.
机译：本文介绍了Microsoft SQL Server数据库系统中的分布式异构查询处理器（DHQP）的体系结构概述，以支持对大量不同数据源的查询。本文重点介绍了体系结构的三个重要方面。首先，系统引入了定义明确的抽象，例如连接，命令和行集，这些抽象使源可以插入系统。这些抽象由OLE DB数据访问接口形式化。 OLE DB的普遍性及其在业界的广泛采用使我们的系统能够收集到大量的各种数据源，从个人生产力工具，数据库管理系统到文件系统数据。其次，DHQP内置于系统的关系优化器和执行引擎中。这使DH查询和更新可以受益于系统中基于成本的代数转换和执行策略。最后，该体系结构具有固有的可扩展性，以在新数据源出现时支持它们，并用作关系引擎添加诸如全文搜索和分布式分区视图之类的新功能的关键扩展点。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号