User interface for visually depicting inner/outer/left/right joins in a database system
作者： Kester Li , Jonathan Michael Levine , Darryl Jon Mocek
DOI:
关键词: User input 、 Database 、 Window (computing) 、 Matching (statistics) 、 Join (sigma algebra) 、 Computer science 、 Table (database) 、 Joins 、 User interface
摘要: A method, apparatus, and article of manufacture which provides for visually depicting join relationships in a database management system. The method comprises the steps on monitor coupled to computer receiving command from user input device into computer, wherein selectively chooses relationship. are depicted window displaying matching records first table joined second table, all table.
google.it 参考文章(16)
Nicholas Haddock, Derek Proudian, Andrew Nelson, Multi-modal user interface ,(1992)
Mir H. Pirahesh, Josephine M. Cheng, Chandrasekaran Mohan, Outer join operations using responsibility regions assigned to inner tables in a relational database ,(1994)
Mir H. Pirahesh, Praveen Seshadri, Ting Y. Leung, System for optimizing correlated SQL queries in a relational database using magic decorrelation ,(1995)
Charles E. Gayraud, Perry A. Gee, John G. Bennett, System and methods including automatic linking of tables for improved relational database modeling with interface ,(1993)
Sven Olof Gunnar Westling, Erik Bertil Hedin, Gregor I. Jonsson, Lars Erik Olsson, Mohammad A. Sanamrad, Natural language analyzing apparatus and method ,(1992)
Barbara C. Sangster, J. Scott Daup, Gerald V. Peterson, Brian P. Anderson, Richard Kasson, Shirley A. Zierke, Charles E. Shapiro, Data base system which maintains project query list, desktop list and status of multiple ongoing research projects ,(1988)
Claudio Fratarcangeli, Gregory S. Aimi, Richard E. Cullingford, Donald P. Strasburger, Steven Shwartz, Database retrieval system having a natural language interface ,(1989)
Gautam Bhargava, Piyush Goel, Balakrishna Ragmavendra Iyer, Method and apparatus for reordering complex SQL queries containing inner and outer join operations ,(1994)
Douglas Robert Mcgregor, Computerised information-retrieval database systems ,(1992)