Method, system, and program for performing a join operation on a multi column table and satellite tables
作者： William Y. Kyu , Fen-Ling Lin , Peter Hoa , Desai Paramesh Sampatrai , Stephen Yao Ching Chen
DOI:
关键词:
摘要: Disclosed is a system, method, and program for performing join operation on multi-column table at least two satellite tables having condition. Each comprised of multiple rows one column. column corresponding to the in each table. A performed generate first result comprising concatenations tables. Less than all concatenated that satisfy condition are then selected. The selected joined
lens.org 参考文章(34)
Arun Narasimha Swami, Bernhard Schiefer, Method and apparatus for optimizing data retrieval using index scanning ,(1994)
James E. Gray, Optimizing table join ordering using graph theory prior to query optimization ,(1996)
Chi Kim Hoang, Global optimization of correlated subqueries and exists predicates ,(1995)
Craig Reginald Tomlyn, William Earl Malloy, Relational database modifications based on multi-dimensional database modifications ,(1997)
Michael James Carey, Gerald George Kiernan, Query optimization with deferred updates and autonomous sources ,(2001)
David E. Simmen, Sanjai Tiwari, Mir H. Pirahesh, Lori G. Strain, Ting Y. Leung, Exploitation of uniqueness properties using a 1-tuple condition for the optimization of SQL queries ,(1995)
Atul Chadha, Ashish Gupta, Venkatesh Harinarayan, Piyush Goel, Balakrishna Raghavendra Iyer, Encoded-vector indices for decision support and warehousing ,(1996)
Murali M. Krishna, Cardinality-based join ordering ,(1998)
Alan Downing, Alan Demers, Minimum leaf spanning tree ,(1998)