专利内容由知识产权出版社提供
专利名称：Database management system and method发明人：Yuya Isoda,Kazuhiko Mogi,Kouji
Kimura,Kazuo Goda,Yuto Hayamizu,MasaruKitsuregawa
申请号：US16282342申请日：20190222公开号：US11061907B2公开日：20210713
专利附图：
摘要：If a query indicates joining of N (N is an integer of no less than 3) relation tables,a database management system calculates a query cost that is based on a power
consumption amount for query execution, for each of a first query plan candidate in whicha temporary table is generated and the temporary table is stored in a storage device unitwith a first access cost, a second query plan candidate in which a temporary table isgenerated and the temporary table is stored in a storage device unit with a secondaccess cost that is higher than the first access cost and a third query plan candidate inwhich the N relation tables are joined in a pipelined manner without generation of atemporary table, selects a relatively low-query cost query plan candidate and executesthe query based on the query plan candidate.
申请人：Hitachi, Ltd.,The University of Tokyo
地址：Tokyo JP,Tokyo JP
国籍：JP,JP
代理机构：Mattingly & Malur, PC
更多信息请下载全文后查看
