首页>
外国专利>
WORKLOAD AWARE DATA PLACEMENT FOR JOIN-BASED QUERY PROCESSING IN A CLUSTER
WORKLOAD AWARE DATA PLACEMENT FOR JOIN-BASED QUERY PROCESSING IN A CLUSTER
展开▼
机译:集群中基于联接的查询处理的工作负荷AWARE数据位置
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method for distributing tables to a cluster of nodes managed by database management system (DBMS), is disclosed. Multiple data placement schemes are evaluated based on a query workload set to select a data placement scheme for the cluster of nodes. Tables, used in join operations in the workload set, are selected for evaluation of data placement schemes. Query execution costs for the workload set are generated based on estimating a query execution cost for each data placement scheme for the tables. The data placement scheme that has least costly estimated execution cost for the workload set is selected as the data placement scheme for the cluster of nodes managed by DBMS.
展开▼