Constructing a bifurcated database of context-dependent and context-independent data items
AssigneePerigis Corporation
InventorCharles St. John Herbert, III
Life of this patent
Estimating the term…
Abstract
A method of constructing a multi-lingual database includes the step of defining metadata to describe fields of a record as being either language-dependent or language-independent. The fields of the record are so described by flagging descriptions of columns associated with the fields in the metadata. A composite table, including a parent table and a child table, is then automatically generated. The parent table includes columns for the language-independent fields of the record, while the child table includes columns for the language-dependent fields of the record.
Claims35
A method of constructing a context-dependent database, the method including the steps of:
- creating metadata to describe fields of a record as being either context-dependent or context-independent;
- generating a context-independent table excluding columns for the context-dependent fields of the record;
- and
- generating a context-dependent table, associated with the context-independent table, excluding columns for the context-independent fields of the record.
A method of constructing a context-dependent view of database information in a database including a context-dependent table and a context-independent table, the method including the steps of:
- identifying a field of a record to be retrieved as being either context-dependent or context-independent;
- and
- if the field is context-dependent, then retrieving database information for the field exclusively from a column associated with the field in a context-dependent table without reference to a column associated with a field in the context-independent table.
A method of constructing a multi-lingual database, the method including the steps of:
- defining metadata to describe a first field of record as being language-dependent and a second field of the record as being language-independent;
- automatically generating a first table, including a column for the first field of the record, but not having column for the second field;
- and
- automatically generating a second table, associated with the first table, including a column for the second field of the record, but not having a column for the first field.
A computer-readable medium having a sequence of instructions stored thereon that, when executed by a processor, cause the processor to construct a database by performing the steps of:
- examining metadata that describes fields of a record as being either context-dependent or context-independent;
- automatically generating a context-independent table excluding columns for the context-dependent fields of the record;
- and
- generating a context-dependent table, associated with the context-independent table, excluding columns for the context-independent fields of the record.
A computer-readable medium having a sequence of instructions stored thereon that, when executed by a processor, cause the processor to construct a context-dependent view of database information by performing the steps of:
- identifying a field of a record to be retrieved as being either context-dependent or context-independent;
- and
- if the field is context-dependent, then retrieving database information for the field exclusively from a column associated with the field in a context-dependent table without reference to a column associated with a field in the context-independent table.
A method of constructing a context-dependent view of database information in a database including a context-dependent table and a context-independent table, the method including the steps of:
- referencing a metadata description of a column, associated with a field of a record to be retrieved, to determine whether the field is context-dependent or context-independent;
- and
- if the field is context-dependent, then retrieving database information for the field exclusively from a column associated with the field in a context-dependent table without reference to a column associated with a field in the context-independent table.
Dependencies are inferred from the claim text.