Patent ID: 6112199
Filing Date: 2000-08-29
Classification: G06F,Y10S

Abstract:
A system for automatic value derivation in a database comprising:a storage device for storing a database;a processor coupled to the storage device, the processor including a database management system comprising:means for defining a derived data item to the database management system;means for defining a derivation formula independently of the derived data item to the database management system;means for associating the derivation formula with the derived data item;means for executing said derivation formula associated with said derived data item and for generating a result of said derivation formula having been executed; andmeans for assigning the result of said derivation formula as a value of said derived data item;means for defining a derivation characteristic to said database management system; andmeans for associating the derivation characteristic with said derived data item, said derivation characteristic including a derivation type used to indicate the conditions under which said database management system will signal said means for executing to execute said derivation formula associated with said derived data item;said derivation type identifies said derived data item as being of a type to be derived by said database management system during retrieval of said value of said derived data item from said database.