User-Editable Contribution Taxonomy

• US 20080052297A1
• Filed: 08/25/2006
• Published: 02/28/2008
• Est. Priority Date: 08/25/2006
• Status: Abandoned Application

• Current Assignee: Intuit, Inc.
• Original Assignee: Intuit, Inc.
• Inventors: LeClair, Terry
• Application Number:
  US11/467,496
• Publication Number:
  US 20080052297A1
• Time in Patent Office: Days
• US Class Current: 707/100
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Database users can extend the database schema and associated taxonomy without requiring use of a database administration view. A system includes a server computer for communicating with users of the system, a taxonomy database for storing records having attributes and values forming the taxonomy, and a taxonomy engine for enabling the addition by users of attributes and values associated with nodes in the taxonomy database. A record is displayed to a user, for example as the result of a database search. The user indicates that she wishes to extend the database schema and add to the taxonomy, supplying the new attribute and value. The supplied attribute and value are received by the server and provided to the taxonomy engine. The taxonomy engine adds the new attribute to the schema and associates the supplied value with the attribute for the record in which the request originated.

Claims

1. A computer-implemented method for extending a database schema by a user other than a database administrator, the method comprising:

retrieving a record from a database, the record including at least one attribute defined by the schema;

displaying the retrieved record to a user;

receiving from the user a new attribute and a value for the new attribute;

modifying the schema to include the new attribute;

modifying the record to associate the value for the new attribute with the new attribute; and

storing the record in the database.

2. The method of claim 1 further comprising:

receiving from a second user a second value for the new attribute; and

modifying a composite value for the attribute of the record, the composite value determined based on all received values for the attribute of the record.

3. The method of claim 2 further comprising displaying the record including the modified composite value.

4. The method of claim 2 further comprising:

receiving from a third user a search query, the query specifying a query value for the new attribute;

responsive to the composite value for the attribute of the record matching the query value, displaying to the user the record including the composite value.

5. The method of claim 1 further comprising:

identifying a second record in the database having the new attribute;

obtaining for the second record a value for the new attribute.

6. The method of claim 5 wherein the value for the new attribute for the second record is obtained from the user.

7. The method of claim 5 wherein the value for the new attribute for the second record is obtained from a different user.

8. A system for extending a database schema by a user other than a database administrator, the system comprising:

a server computer for communicating with a user computer to display database records to a user and to receive from the user modifications to the database schema;

a taxonomy database for storing records, each record including at least one attribute defined by the database schema;

a taxonomy engine, coupled to the server computer and the taxonomy database, adapted to;

receive a new attribute and a value for the new attribute, the attribute and value supplied by the user computer;

modify the schema to include the new attribute;

modify the record to associate the value for the new attribute with the new attribute; and

store the record in the database.

9. The system of claim 8 wherein the taxonomy engine is further adapted to:

receive from a second user a second value for the new attribute; and

modify a composite value for the attribute of the record, the composite value determined based on all received values for the attribute of the record.

10. The system of claim 8 wherein the taxonomy engine is further adapted to:

identify a second record in the database having the new attribute; and

obtain for the second record a value for the new attribute.

11. The system of claim 10 wherein the value for the new attribute for the second record is obtained from the user computer.

12. The system of claim 10 wherein the value for the new attribute for the second record is obtained from a second user computer.

13. A computer program product for extending a database schema by a user other than a database administrator, the computer program product stored on a computer-readable medium and including program code configured to cause a processor to carry out the steps of:

retrieving a record from a database, the record including at least one attribute defined by the schema;

displaying the retrieved record to a user;

receiving from the user a new attribute and a value for the new attribute;

modifying the schema to include the new attribute;

modifying the record to associate the value for the new attribute with the new attribute; and

storing the record in the database.

14. A computer-implemented method for extending a database schema by a user other than a database administrator, the method comprising:

receiving at a web server a request from a user of a web browser to display a record of a database;

retrieving the requested record from the database, the record including at least one attribute defined by the schema, and displaying the record in the user'"'"'s web browser;

receiving from the user a request to add a new attribute and a value for the new attribute to the record;

modifying the database schema to include the new attribute received from the user;

modifying the retrieved record to associate the value received from the user for the new attribute with the new attribute;

storing the modified record in the database; and

displaying the modified record in the user'"'"'s web browser.