首页> 外国专利> STORAGE SYSTEM AND STORING METHOD OF RELATIONAL DATABASE FOR HIGH QUERY PERFORMANCE WITH LOW DATA REDUNDANCY AND PROCESSING METHOD OF QUERY BASED ON STORING METHOD OF RELATIONAL DATABASE

STORAGE SYSTEM AND STORING METHOD OF RELATIONAL DATABASE FOR HIGH QUERY PERFORMANCE WITH LOW DATA REDUNDANCY AND PROCESSING METHOD OF QUERY BASED ON STORING METHOD OF RELATIONAL DATABASE

机译:具有低数据冗余的高查询性能关系数据库的存储系统和存储方法,以及基于关系数据库存储方法的查询处理方法

摘要

A relational database storage method according to an embodiment generates a join graph including tables and edges based on a query set including database schema and join predicate information including information on references and constraints between database tables The types of the tables are classified based on the cost of the join operation between the tables included in the join graph, the types of the edges in the join graph are classified based on the types of the tables connected to each other by the edges, Adds a virtual edge between two tables satisfying an indirect edge condition in the database, and creates a database partition plan for the join graph based on the types of edges including the virtual edge.
机译:根据实施例的关系数据库存储方法基于包括数据库模式的查询集生成包括表和边的连接图,以及包括数据库表之间的引用和约束的信息的连接谓词信息。表的类型基于数据库的成本而分类。联接图中包含的表之间的联接操作,联接图中的边的类型基于通过边彼此连接的表的类型进行分类,在满足间接边条件的两个表之间添加虚拟边在数据库中,并根据包括虚拟边在内的边类型为连接图创建数据库分区计划。

著录项

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号