Data processing: database and file management or data structures – Database design – Data structure types
Patent
1996-10-18
2000-08-29
Ho, Ruay Lian
Data processing: database and file management or data structures
Database design
Data structure types
707 2, 707 3, G06F 1730
Patent
active
061121991
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.
REFERENCES:
patent: 4498145 (1985-02-01), Baker et al.
patent: 4868733 (1989-09-01), Fujisawa et al.
patent: 4885705 (1989-12-01), Choi
patent: 4918593 (1990-04-01), Huber
patent: 4939689 (1990-07-01), Davis et al.
patent: 5097408 (1992-03-01), Huber
patent: 5201046 (1993-04-01), Goldberg et al.
patent: 5276870 (1994-01-01), Shan et al.
patent: 5369761 (1994-11-01), Conley et al.
patent: 5471629 (1995-11-01), Risch
patent: 5548749 (1996-08-01), Kroenke et al.
patent: 5603021 (1997-02-01), Spencer et al.
LandOfFree
Data item values does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Data item values, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data item values will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1259007