Method for efficiently processing comments to records in a database, while avoiding replication/save conflicts

• US 9,424,553 B2
• Filed: 09/11/2012
• Issued: 08/23/2016
• Est. Priority Date: 06/23/2005
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Ierace, Vincent, Morris, Benjamin R.
• Primary Examiner(s): SAX, STEVEN PAUL
• Application Number:
  US13/610,121
• Publication Number:
  US 20130036118A1
• Time in Patent Office: 1,442 Days
• Field of Search: 715/738, 715/764, 715/512, 715/230, 715/229
• US Class Current: 1/1
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 40/169 Annotation, e.g. comment data or footnotes
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A system for processing comment contents associated with a parent document by providing a parent document user interface including a display object enabling a user to enter comment contents, creating a comment document associated with said parent document and storing said comment contents in said comment document, obtaining said comment contents from said comment document and displaying said comment contents within a region of said parent document user interface, copying, in response to detecting a change of state of said parent document from a state in which comments can be added to a state in which comments cannot be added, said comment contents from said comment document into said parent document, deleting said comment document, and presenting said comment contents after deleting said comment document.

Claims

1. A method comprising:

creating, by a processor in response to instructions stored on a storage medium, an issue record in an issue tracking database, the issue record indicating an issue;

creating, by the processor in response to users entering comments regarding the issue though interfaces representing the issue record, comment records associated with the issue record, wherein the comment records comprise two or more document types;

storing the comments regarding the issue in the comment records;

detecting an indication associated with the issue record, the indication based on receipt of a user input to close the issue record and preventing the creation of another comment record associated with the issue record;

in response to detecting the indication, creating, by the processor in response to instructions stored on the storage medium, a consolidated comment that includes the comments stored in the comment records; and

after the consolidated comment is created, deleting, by the processor in response to instructions stored on the storage medium, the comment records.

2. The method of claim 1, further comprising:

storing the consolidated comment in the issue record.

3. The method of claim 1, further comprising:

outputting information for displaying the interfaces representing the issue record to the users.

4. The method of claim 3, wherein outputting information for displaying the interfaces includes outputting information for displaying representations of a comment entry form.

5. The method of claim 3, wherein outputting information for displaying the interfaces includes outputting information for displaying the consolidated comment.

6. The method of claim 1, further comprising:

storing the issue record in a client database; and

transmitting information indicating the issue record and the comments to a server database.

7. The method of claim 1, wherein creating the consolidated comment comprises including the comment records in the consolidated comment in reverse chronological order.

19. The method of claim 1, wherein the document types comprise a database entry in a database and a file in a file system.

8. An apparatus comprising:

a memory; and

a processor configured to execute instructions stored on the memory to;

create an issue record in an issue tracking database, the issue record indicating an issue;

create, in response to users entering comments regarding the issue through interfaces representing the issue record, comment records associated with the issue record, wherein the comment records comprise two or more document types;

store the comments regarding the issue in the comment records;

detect an indication associated with the issue record, the indication based on receipt of a user input to close the issue record and preventing the creation of another comment record associated with the issue record; and

in response to detecting the indication, create a consolidated comment that includes the comments stored in the comment records; and

after the consolidated comment is created, delete the comment records.

9. The apparatus of claim 8, wherein the processor is configured to execute instructions stored on the memory to store the consolidated comment in the issue record.

10. The apparatus of claim 8, wherein the processor is configured to execute instructions stored on the memory to output information for displaying the interfaces representing the issue record.

11. The apparatus of claim 10, wherein the processor is configured to execute instructions stored on the memory to output the information for displaying the interfaces by outputting information for displaying representations of a comment entry form.

12. The apparatus of claim 10, wherein the processor is configured to execute instructions stored on the memory to output information for displaying the interfaces by outputting information for displaying the consolidated comment.

13. The apparatus of claim 8, further comprising:

a client database, wherein the processor is configured to execute instructions stored on the memory to;

store the issue record in the client database; and

cause a transmitter to transmit information indicating the issue record and the comment records to a server database.

14. The apparatus of claim 8, wherein creating the consolidated comment comprises including the comment records in the consolidated comment in reverse chronological order.

20. The apparatus of claim 8, wherein the document types comprise a database entry in a database and a file in a file system.

15. A system comprising:

a client including;

a first memory;

a client database; and

a first processor configured to execute instructions stored on the first memory to;

store an issue record indicating an issue in the client database;

store comment records associated with the issue record in the client database;

store comments regarding the issue in the comment records, wherein the comment records comprise two or more document types;

detect that the issue record is associated with a state preventing the creation of another comment record associated with the issue record based on receiving an indication of the state from a user input to close the issue record through an interface representing the issue record; and

create a consolidated comment that includes the comments stored in the comment records;

after the consolidated comment is created, delete the comment records based on detecting the state; and

a server including;

a second memory;

a server database; and

a second processor configured to execute instructions stored on the second memory to;

receive information indicating the issue record from the client; and

store an indication of the issue record in the server database.

16. The system of claim 15, wherein the first processor is configured to execute instructions stored on the first memory to:

store the consolidated comment in the issue record; and

cause a transmitter to transmit information indicating the consolidated comment to the server.

17. The system of claim 15, wherein the second processor is configured to execute instructions stored on the second memory to cause a transmitter to transmit information indicating the state to the client.

18. The system of claim 15, wherein the first processor is configured to execute instructions stored on the first memory to receive information indicating the state from the server.