Patent ID: 7516439
Filing Date: 2009-04-07
Classification: G06F,Y10S

Abstract:
1. A method in a computer system for providing an interface between at least one logical view of a relational database and a plurality of normalized relational database tables having stored data, comprising: receiving an indication of an operation to be performed on the at least one logical view, the at least one logical view including at least one combination of tables from a plurality of normalized relational database tables, the combination previously constructed without reference to foreign keys in the plurality of tables, the foreign keys reflecting a database relationship between the plurality of tables, and wherein the at least one logical view includes at least one virtual attribute that is not stored directly in the plurality of tables and that is a result of a calculation; automatically determining the corresponding plurality of normalized relational database tables that were used to construct the at least one logical view; and transparently and automatically causing the stored data in the corresponding plurality of normalized relational database tables to be adjusted in accordance with the indicated operation, thereby automatically performing the indicated operation on underlying data that corresponds to the logical view.