US6112199A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data item values
Assignee: Chartoleaux KG LLC
•
Filing: 1996-10-18
•
Granted: 2000-08-29
•
Expires: 2016-10-18
Abstract
Abstract An improved method for value derivation allows for the definition of derived and defaulted information as database table columns. Derivation formulas are defined independently to the database management system. A derivation formula is assigned to each derived or defaulted column during their definition. Derivation formula parameter value assignments are also defined for each derived or defaulted column, if required by the derivation formula associated with the column. In addition, a derivation type is assigned to each derived or defaulted column specifying the conditions under which the value of the column is to be derived. During key processes, such as while inserting a row into a database or retrieving a row from a database, the database management system will determine whether a value is to be derived for each affected column. The database management system makes this determination through the examination of the derivation type associated with the column. If the database management system determines that the value for a derived or defaulted column is to be derived, it automatically invokes the derivation formula assigned to the column using any derivation parameter value assignments specified in the column definition. The database management system will then assume the values resulting from the derivation formula as the values of the derived or defaulted column.
Inventors
- 👤 Paul M. Nelson
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 22:49
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2291; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 43
Claim 1
Independent Claim
206 words
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; and means 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; and means 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.
Claim 2
Independent Claim
206 words
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; and means 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; and means 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.
Claim 3
Dependent Claim
22 words
The system of claim 1 wherein: said storage device does not store the value of said derived data item in said database.
Claim 4
Dependent Claim
84 words
The system of claim 1 further comprising: means for detecting whether said value of said derived data item is a prescribed value signifying that said result of said derivation formula should be assigned as said value of said derived data item; said means for assigning including means for assigning the result of said derivation formula as said value of said derived data item only in the event said means for detecting determines that said value of said derived data item is the prescribed value.
Claim 5
Independent Claim
206 words
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; and means 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; and means 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 insertion of said value of said derived data item into said database.
Claim 6
Independent Claim
206 words
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; and means 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; and means 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 insertion of said value of said derived data item into said database.
Claim 7
Independent Claim
215 words
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; and means 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; means 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; and means for defining a derived user data type to said database management system as a template; said means for associating said derivation characteristic with said derived data item including means for referring to the template for the purpose of defaulting said derivation characteristic.
Claim 8
Independent Claim
215 words
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; and means 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; means 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; and means for defining a derived user data type to said database management system as a template; said means for associating said derivation characteristic with said derived data item including means for referring to the template for the purpose of defaulting said derivation characteristic.
Claim 9
Independent Claim
219 words
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; and means 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; and means 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 means for defining a derivation characteristic to said database management system includes means for defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 10
Independent Claim
219 words
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; and means 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; and means 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 means for defining a derivation characteristic to said database management system includes means for defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 11
Independent Claim
201 words
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; and means 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; means 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; and means for defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for the derivation formula parameters.
Claim 12
Independent Claim
201 words
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; and means 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; means 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; and means for defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for the derivation formula parameters.
Claim 13
Independent Claim
162 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 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.
Claim 14
Independent Claim
162 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 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.
Claim 15
Dependent Claim
75 words
The method of claim 8 further comprising: detecting whether said value of said derived data item is a prescribed value signifying that said result of said derivation formula should be assigned as said value of said derived data item; assigning the result of said derivation formula as said value of said derived data item only in the event said means for detecting determines that said value of said derived data item is the prescribed value.
Claim 16
Independent Claim
162 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 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 insertion of said value of said derived data item into said database.
Claim 17
Independent Claim
162 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 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 insertion of said value of said derived data item into said database.
Claim 18
Independent Claim
163 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; and defining a derived user data type to said database management system as a template; said associating said derivation characteristic with said derived data item including referring to the template for defaulting said derivation characteristic.
Claim 19
Independent Claim
163 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; and defining a derived user data type to said database management system as a template; said associating said derivation characteristic with said derived data item including referring to the template for defaulting said derivation characteristic.
Claim 20
Independent Claim
172 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; said defining of said derivation characteristic to said database management system includes defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 21
Independent Claim
172 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; said defining of said derivation characteristic to said database management system includes defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 22
Independent Claim
156 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; and defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for said derivation formula parameters.
Claim 23
Independent Claim
156 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and 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 execute said derivation formula associated with said derived data item; and defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for said derivation formula parameters.
Claim 24
Independent Claim
138 words
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; and means for assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during retrieval of said value of said derived data item from said database.
Claim 25
Independent Claim
138 words
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; and means for assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during retrieval of said value of said derived data item from said database.
Claim 26
Independent Claim
138 words
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; and means for assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during insertion of said value of said derived data item into said database.
Claim 27
Independent Claim
138 words
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; and means for assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during insertion of said value of said derived data item into said database.
Claim 28
Independent Claim
180 words
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; and means 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; means for associating the derivation characteristic with said derived data item; and means for defining a derived user data type to said database management system as a template; said means for associating said derivation characteristic with said derived data item including means for referring to the template for the purpose of defaulting said derivation characteristic.
Claim 29
Independent Claim
180 words
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; and means 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; means for associating the derivation characteristic with said derived data item; and means for defining a derived user data type to said database management system as a template; said means for associating said derivation characteristic with said derived data item including means for referring to the template for the purpose of defaulting said derivation characteristic.
Claim 30
Independent Claim
184 words
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; and means 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; and means for associating the derivation characteristic with said derived data item; said means for defining a derivation characteristic to said database management system includes means for defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 31
Independent Claim
184 words
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; and means 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; and means for associating the derivation characteristic with said derived data item; said means for defining a derivation characteristic to said database management system includes means for defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 32
Independent Claim
167 words
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; and means 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; and means for associating the derivation characteristic with said derived data item; and means for defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for the derivation formula parameters.
Claim 33
Independent Claim
167 words
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; and means 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; and means for associating the derivation characteristic with said derived data item; and means for defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for the derivation formula parameters.
Claim 34
Independent Claim
105 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during retrieval of said value of said derived data item from said database.
Claim 35
Independent Claim
105 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during retrieval of said value of said derived data item from said database.
Claim 36
Independent Claim
105 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during insertion of said value of said derived data item into said database.
Claim 37
Independent Claim
105 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; said derived data item being derived by said database management system during insertion of said value of said derived data item into said database.
Claim 38
Independent Claim
133 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; associating the derivation characteristic with said derived data item; and defining a derived user data type to said database management system as a template; said associating said derivation characteristic with said derived data item including referring to the template for defaulting said derivation characteristic.
Claim 39
Independent Claim
133 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; associating the derivation characteristic with said derived data item; and defining a derived user data type to said database management system as a template; said associating said derivation characteristic with said derived data item including referring to the template for defaulting said derivation characteristic.
Claim 40
Independent Claim
144 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and associating the derivation characteristic with said derived data item; said defining of said derivation characteristic to said database management system includes defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 41
Independent Claim
144 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; and assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; and associating the derivation characteristic with said derived data item; said defining of said derivation characteristic to said database management system includes defining a multiple value derivation formula indicator to said database management system, said multiple value derivation formula indicator indicating whether said derivation formula is capable of returning a set of result values.
Claim 42
Independent Claim
126 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; associating the derivation characteristic with said derived data item; and defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for said derivation formula parameters.
Claim 43
Independent Claim
126 words
A method for automatic value derivation in a database comprising: defining a derived data item to a database management system; defining a derivation formula independently of the derived data item to the database management system; associating the derivation formula with the derived data item; executing said derivation formula associated with said derived data item and generating a result of said derivation formula having been executed; assigning the result of said derivation formula as a value of said derived data item; defining a derivation characteristic to said database management system; associating the derivation characteristic with said derived data item; and defining derivation formula parameters for said derivation formula; said derivation characteristic including a set of derivation formula parameter assignments that specify values for said derivation formula parameters.
References Cited (Backward Citations)
US4498145A
Cited
US5097408A
Cited
US4868733A
Cited
US4918593A
Cited
US4939689A
Cited
US5276870A
Cited
US4885705A
Cited
US5471629A
Cited
US5369761A
Cited
US5201046A
Cited
US5548749A
Cited
US5603021A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-08-29 | 2004-02-28 | 2004-08-29 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-08-29 | 2008-02-28 | 2008-08-29 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-08-29 | 2012-02-28 | 2012-08-29 | $7700.00 | Window Closed / Lapsed |