12. A program having computer readable program code means on a computer usable medium, the program comprising: means having a capability to build objects in a memory based upon a view type referenced in a query received from an application; and means for applying query rewrite optimizations to the query referencing the view type, wherein the query rewrite optimizations determine which portions of the query to push down to a database at a second tier for resolution and which portions of the query are to be processed by the query engine at a first tier to build objects from the view types.
12. A program having computer readable program code means on a computer usable medium, the program comprising: means having a capability to build objects in a memory based upon a view type referenced in a query received from an application; and means for applying query rewrite optimizations to the query referencing the view type, wherein the query rewrite optimizations determine which portions of the query to push down to a database at a second tier for resolution and which portions of the query are to be processed by the query engine at a first tier to build objects from the view types. 19. The program of claim 12 wherein the means for applying query rewrite optimizations further comprises: means for submitting the rewritten query to a data source without object building if the query referencing the view type only requests values to be returned.