本文针对局部网环境下的分布式数据库系统分布查询优化策略作了讨论.半联接不适合传输速度快而工作站速度慢的局部网.而FR技术需要将所在有不在处理站点上的数据传送到处理站点,需要巨大的I/O费用.本文提出,联接时利用Fetch as Needed技...本文针对局部网环境下的分布式数据库系统分布查询优化策略作了讨论.半联接不适合传输速度快而工作站速度慢的局部网.而FR技术需要将所在有不在处理站点上的数据传送到处理站点,需要巨大的I/O费用.本文提出,联接时利用Fetch as Needed技术,吸取FR思想,在确定一个分割关系,和一组处理站点后,为每一个站点,赋予一个忙碌程度参数,使得在联接时,多个处理站点不至于同时到同一个站点取数据,使串行度尽可能减少.展开更多
In this paper we introduce mainly the relation between general projection and outerjoin and the relation between general projection and semijoin. We also put forward pseudodistributive law of general projection. Then ...In this paper we introduce mainly the relation between general projection and outerjoin and the relation between general projection and semijoin. We also put forward pseudodistributive law of general projection. Then we provide a more mature theory about general projection.展开更多
文摘本文针对局部网环境下的分布式数据库系统分布查询优化策略作了讨论.半联接不适合传输速度快而工作站速度慢的局部网.而FR技术需要将所在有不在处理站点上的数据传送到处理站点,需要巨大的I/O费用.本文提出,联接时利用Fetch as Needed技术,吸取FR思想,在确定一个分割关系,和一组处理站点后,为每一个站点,赋予一个忙碌程度参数,使得在联接时,多个处理站点不至于同时到同一个站点取数据,使串行度尽可能减少.
文摘In this paper we introduce mainly the relation between general projection and outerjoin and the relation between general projection and semijoin. We also put forward pseudodistributive law of general projection. Then we provide a more mature theory about general projection.
