Database model system and method
AssigneeHewlett-Packard Development Company, L.P.
InventorNorman Robert Russell
Life of this patent
Estimating the term…
Abstract
A database model system and method are provided that permit changes to the data model, such as the addition, deletion, or modification of attributes, through changes to the data rather than to the fundamental data model schema. A method of structuring a database comprises providing a category table, a content table containing content corresponding to categories in the category table, and a category contents table containing a mapping scheme that maps content contained in the content table to categories in the category table. An attributes table containing attributes for an application utilizing the database and an attributes values table containing values corresponding to attributes in the attributes table are also provided.
Claims33
A method of structuring a computer database that is stored on a computer readable medium, said method comprising:
- providing a category table including categories for subject matter of the database;
- providing a content table containing content corresponding to categories in said category table;
- providing a category contents table containing a mapping scheme that maps content contained in said content table to categories in said category table;
- providing an attributes table containing attributes for an application utilizing said database;
- and
- providing an attributes values table containing values corresponding to said attributes in said attributes table, wherein a category for the subject matter can be changed by changing a row in the category table and a content corresponding to a category can be changed by changing a row in the content table, wherein a row in the attribute values table is modified based upon the changes in the rows in the category table and content table, in order to modify an attribute value.
A computer system for storing and transferring data, the system comprising:
- at least one server computer connected through a computer network;
- and
- at least one computer program executed by said at least one server computer, wherein said at least one computer program manages data stored in a database having a structure comprising:
- a category table including categories for subject matter of the database;
- a content table containing content corresponding to categories in said category table;
- a category contents table containing a mapping scheme that maps content contained in said content table to categories in said category table;
- an attributes table containing attributes for an application utilizing said database;
- and
- an attributes values table containing values corresponding to said attributes in said attributes table, wherein a category for the subject matter can be changed by changing a row in the category table and a content corresponding to a category can be changed by changing a row in the content table, wherein a row in the attribute values table is modified based upon the changes in the rows in the category table and content table, in order to modify an attribute value.
A method of structuring a computer database that is stored on a computer readable medium, said method comprising:
- providing an entity table having a minimal set of attributes;
- providing an entity attributes table having attributes corresponding to said entity table;
- and
- providing an entity attribute values table having values corresponding to said attributes, wherein an attribute can be changed by changing a row in the entity attributes table, wherein a row in the entity attribute values table is modified based upon the change in the row in the entity attribute table.
A computer system for storing and transferring data, said system comprising:
- at least one server computer connected through a computer network;
- and
- at least one computer program executed by said at least one server computer, wherein said at least one computer program manages data stored in a database having a structure comprising:
- A an entity table having a minimal set of attributes;
- an entity attributes table having attributes corresponding to said entity table;
- and
- an entity attribute values table having values corresponding to said attributes, wherein an attribute can be changed by changing a row in the entity attributes table, wherein a row in the entity attribute values table is modified based upon the change in the row in the entity attribute table.
A method of structuring a database that is stored on a computer readable medium, said method comprising:
- creating a data objects table containing attributes;
- creating an attributes table containing properties of said attributes in said data objects table;
- and
- creating a value table containing values for said properties for specific instances of said attributes, wherein an attribute can be changed by changing a row in the attributes table, wherein a row in the value table is modified based upon the change in the row in the attributes table.
A computer system for storing and transferring data, said system comprising:
- at least one server computer connected through a computer network;
- and
- at least one computer program,executed by said at least one server computer, wherein said at least one computer program manages data stored in a database having a structure comprising:
- a data objects table containing attributes;
- an attributes table containing properties of said attributes in said data objects table;
- and
- a value table containing values for said properties for specific instances;
- of said attributes, wherein an attribute can be changed by changing a row in the attributes table, wherein a row in the value table is modified based upon the change in the row in the attributes table.
Dependencies are inferred from the claim text.