首页> 外文会议>Database and Expert Systems Applications >Utilising Multiple Computers in Database Query Processing and Descriptor Rule Management
【24h】

Utilising Multiple Computers in Database Query Processing and Descriptor Rule Management

机译:在数据库查询处理和描述符规则管理中使用多台计算机

获取原文

摘要

A fundamental problem to be solved in systems that derive rules from database tables to use in query optimisation is the workload involved. If the data server has to do the work it can interfere with query processing and cause slower query answering, which is the opposite of the required effect. This paper reports our investigation of the use of multiple workstations in the same local network as the data server to derive and maintain sets of rules describing data subsets. These rules are used in query optimisation. In a local area network of workstations, one computer accepts SQL queries and data manipulation commands from networked clients. This computer provides an interface to one or more database management systems located on computers in the network. It uses a collection of subset-descriptor rules for query reformulation before forwarding the semantically optimised query. It manages a set of workstations in the network, to derive and maintain the rules. The workstations are ordinary networked computers whose spare computing capacity is utilised by spawning background programs on them.
机译:从数据库表派生规则以用于查询优化的系统中要解决的基本问题是所涉及的工作负载。如果数据服务器必须执行此工作,则它可能会干扰查询处理并导致查询应答变慢,这与所需的效果相反。本文报告了我们对在与数据服务器相同的本地网络中使用多个工作站来派生和维护描述数据子集的规则集的调查。这些规则用于查询优化。在工作站的局域网中,一台计算机接受来自网络客户端的SQL查询和数据操作命令。此计算机提供了到位于网络中计算机上的一个或多个数据库管理系统的接口。在转发语义优化的查询之前,它使用子集描述符规则的集合来进行查询重构。它管理网络中的一组工作站,以导出和维护规则。工作站是普通的联网计算机,其备用计算能力是通过在工作站上生成后台程序来利用的。

著录项

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号