Database model system and method

• US 6,687,704 B1
• Filed: 09/06/2000
• Issued: 02/03/2004
• Est. Priority Date: 08/31/2000
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Russell, Norman Robert
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/655,779
• Time in Patent Office: 1,245 Days
• Field of Search: 707/100-102, 707/2, 707/104.1, 707/4, 717/104, 717/168
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

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.

Claims

1. 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.

2. The method of claim 1, further comprising providing a category relationships table containing category relationships and rules corresponding to categories in said category table.

3. The method of claim 1, further comprising:

providing an attribute area table that defines the area of an application utilizing said database which is permitted to use certain of said attributes; and

providing an application area table that defines the areas of an application utilizing said database which may be referenced.

4. The method of claim 1, further comprising:

providing an attribute pre-defined value table that contains all pre-defined enumerated values for certain of said attributes; and

providing a category pre-defined values table that contains pre-defined values for certain categories in said category table.

5. The method of claim 1, further comprising:

providing a category types table that describes the category type for certain categories in said category table; and

providing a content type table that describes the type of content stored in said content table; and

providing a category relationship rule table that describes the relationship rules for said category types.

6. The method of claim 1, further comprising providing a content value table that contains the actual content corresponding to said content in said content table.

7. The method of claim 1, further comprising:

providing a content relationships table that describes the relationship among said content in said content table; and

providing a content relationship type table that defines the rationale for the relationship among said content in said content table.

8. The method of claim 1, further comprising:

providing a parameter names table that defines names of parameters;

providing an application parameter type table that groups parameter types; and

providing a parameter value table that defines values for said parameters in said parameter names table.

9. The method of claim 1, further comprising:

providing a template table that provides templates that are used to present categories and said content;

providing a template types table that defines types of templates; and

providing a presentation method table that identifies which of said templates are used to display said categories and said content.

32. The method of claim 1, wherein the modification to an attribute is permitted by changes to data in the database instead of changes to a structure of the database and definitions of the tables.

10. 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.

11. The system of claim 10, wherein said database structure further comprises a category relationships table containing category relationships and rules corresponding to categories in said category table.

12. The system of claim 10, wherein said database structure further comprises:

an attribute area table that defines the area of an application utilizing said database which is permitted to use certain of said attributes; and

an application area table that defines the areas of an application utilizing said database which may be referenced.

13. The system of claim 10, wherein said database structure further comprises:

an attribute pre-defined value table that contains all pre-defined enumerated values for certain of said attributes; and

a category pre-defined values table that contains pre-defined values for certain categories in said category table.

14. The system of claim 10, wherein said database structure further comprises:

a category types table that describes the category type for certain categories in said category table; and

a content type table that describes the type of content stored in said content table; and

a category relationship rule table that describes the relationship rules for said category types.

15. The system of claim 10, wherein said database structure further comprises providing a content value table that contains the actual content corresponding to said content in said content table.

16. The system of claim 10, wherein said database structure further comprises:

a content relationships table that describes the relationship among said content in said content table; and

a content relationship type table that defines the rationale for the relationship among said content in said content table.

17. The system of claim 10, wherein said database structure further comprises:

a parameter names table that defines names of parameters;

an application parameter type table that groups parameter types; and

a parameter value table that defines values for said parameters in said parameter names table.

18. The system of claim 10, wherein said database structure further comprises:

a template table that provides templates that are used to present categories and said content;

a template types table that defines types of templates; and

a presentation method table that identifies which of said templates are used to display said categories and said content.

19. The system of claim 10, further comprising a web server computer to provide Internet access to said at least one server computer.

33. The method of claim 10, wherein the modification to an attribute is permitted by changes to data in the database instead of changes to a structure of the database and definitions of the tables.

20. 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.

21. The method of claim 20, further comprising:

providing a content table containing content corresponding to said entity table; and

providing an entity contents table that maps said content to a corresponding entity.

22. The method of claim 20, further comprising providing an entity relationships table that contains relationships and rules corresponding to entities in said entity table.

23. 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.

24. The system of claim 23, wherein said database further comprises:

a content table containing content corresponding to said entity table; and

an entity contents table that maps said content to a corresponding entity.

25. The system of claim 23, wherein said database further comprises an entity relationships table that contains relationships and rules corresponding to entities in said entity table.

26. 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.

27. The method of claim 26, further comprising creating a relationships table containing object relationships corresponding to said attributes in said data objects table.

28. The method of claim 26, further comprising providing at least one foreign key in said value table to identify which value corresponds to a specific instance of said attributes for said properties.

29. 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.

30. The system of claim 29, wherein said database structure further comprises a relationships table containing object relationships corresponding to said attributes in said data objects table.

31. The method of claim 29, wherein said database structure further comprises at least one foreign key in said value table to identify which value corresponds to a specific instance of said attributes for said properties.