Under the present invention, when a SQL statement having a full select portion that references a view containing a join operation (e.g., a LOJ operation) is received, the reference to the view will be moved out of the full select portion. Once moved, the view and its join operation will be resolved separately from the SQL statement. The results of this resolution will be placed in a temporary table. A reference to the temporary table is then inserted in the full select portion, and the SQL statement is thereafter performed.

 
Web www.patentalert.com

< Methods and systems for displaying matching business objects

< Method and apparatus for indexing, searching and displaying data

> System and methods for user-customizable enterprise workflow management

> Method for synchronizing and updating bookmarks on multiple computer devices

~ 00603