Tracking changes in a database tool

• US 8,893,017 B2
• Filed: 05/29/2008
• Issued: 11/18/2014
• Est. Priority Date: 05/29/2008
• Status: Active Grant

• Current Assignee: Adobe Inc.
• Original Assignee: Adobe Systems Incorporated (Adobe Inc.)
• Inventors: Rein, Todd, Stroh, Eylon, Rai, Shashi, Qualizza, Marco, Dolgov, Roman, Ethier, Chris, Shaver, Robert
• Primary Examiner(s): Belousov, Andrey
• Application Number:
  US12/129,635
• Publication Number:
  US 20140033101A1
• Time in Patent Office: 2,364 Days
• Field of Search: 715/738, 715/751, 715/770, 715/843
• US Class Current: 715/751
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

In one example embodiment, a system and method is illustrated that includes receiving input to execute a function associated with a display element of a Graphical User Interface (GUI), the display element to display edit history data relating to a displayed portion of structured data. The system and method also includes retrieving the edit history data for the displayed portion of the structured data based upon the function, the edit history data reflecting changes made to the displayed portion of the structured data. The system and method also includes displaying the edit history data in the GUI as part of the display element.

Claims

1. A computer implemented method comprising:

displaying an indicator relating to a displayed portion of structured data in response to a graphical pointer being near the portion of structured data, the indicator indicating that the portion of structured data is associated with edit history data;

receiving input to execute a function associated with a display element of a Graphical User Interface (GUI), the display element being a drop-down menu to display the edit history data relating to the portion of structured data;

in response to receiving the input;

accessing an edit history database at a server including accessing the edit history database over a network using a networking protocol, the edit history database tracking changes to content of the structured data as the changes are made by a plurality of users including tracking a particular change from a first version of the content of the structured data to a second version of the content of the structured data, the particular change being accessible to the plurality of users;

retrieving, from the edit history database, the edit history data for the displayed portion of the structured data based upon the function, the edit history data reflecting changes to the displayed portion of the structured data made by the plurality of users; and

displaying the edit history data in the GUI as part of the display element.

2. The computer implemented method of claim 1, wherein the function associated with the display element includes a mouse-over function, a focus function, right-click function, left-click function, or a keyboard function.

3. The computer implemented method of claim 1, further comprising receiving input to execute the function associated with the display element, the display element located proximate to the displayed portion of the structured data.

4. The computer implemented method of claim 1, wherein the changes include at least one of a deletion of editing record data, deletion of a column, deletion of a row, a change to a data style, adding a row, adding a column, changing a data type, changing a relationship between tables in a schema, changing a function used to process data included in a database table, creating a new table, or changing privileges associated with editing the structured data.

5. The computer implemented method of claim 1, wherein the displayed portion of the structured data includes at least one of a database table, a structured data column, a structured data row, or a structured data schema.

6. The computer implemented method of claim 1, further comprising highlighting the displayed portion of the structured data.

7. The computer implemented method of claim 1, wherein the edit history data includes identity information that identifies at least one of a user, date information, or time information.

8. The computer implemented method of claim 1, further comprising:

receiving additional input to display the display element, the display element to display additional edit history data relating to an additional displayed portion of the structured data;

retrieving additional edit history data for the additionally displayed portion of the structured data based on the function, the additional edit history data including additional changes made to the additionally displayed portion of the structured data; and

displaying the additional edit history data in real time on the display as part of the display element.

9. The computer implemented method of claim 1, further comprising highlighting changes made to the structured data subsequent to a previous session.

10. A computer implemented method comprising:

storing, in a database, a plurality of versions of structured data, the database tracking changes to content of the structured data as the changes are made by a plurality of users including tracking a change from a first version of the content of the structured data to a current version of the content of the structured data, the particular change being accessible to the plurality of users;

receiving identification of the first version selected by a user from the plurality of versions of the structured data, the first version being different from the current version of the structured data;

identifying the change between the first version and the current version of the structured data; and

generating a display of a change indicator to identify the change between the first version and the current version of the structured data including generating the display in response to a graphical pointer being near the current version of the content of the structured data, the change indicator being specific to a structure element of the structured data and being displayed in a drop-down menu relating to the structure element.

11. The method of claim 10, further comprising displaying version information to the user identifying the plurality of versions of the structured data, and receiving of the identification of the first version based on the display version information.

12. The method of claim 11, wherein the version information concurrently presents information identifying the plurality of versions of the structured data to the user.

13. The method of claim 11, wherein the version information that is displayed to the user includes temporal information associated with at least one of the versions of the plurality of versions of the structured data.

14. The method of claim 10, wherein the structured data is a table, and the change indicator is specific with respect to at least one of a cell, row or column of the table.

15. The method of claim 10, further comprising receiving selection of the change indicator and, responsive to the receiving of the selection of the change indicator, displaying change information pertaining to the change between the first version of the current version of structured data.

16. The method of claim 15, wherein the receiving of the selection of the change indicator includes detecting a master of operation with respect to a tooltip function associated with the change indicator.

17. The method of claim 15, wherein the change information includes at least one of user, time, date or type information pertaining to the change between the first version and the current version of structured data.

18. The method of claim 10, wherein the identification of the change between the first version and the current version of the structured data is performed dynamically responsive to the receipt of the identification of the first version.

19. The method of claim 10, wherein the identification of the change between the first version and that the current version of the structured data is performed using stored changed data reflecting changes between the first version and the current version.

20. A computer system comprising:

a display to display an indicator relating to a displayed portion of structured data in response to a graphical pointer being near the portion of structured data, the indicator indicating that the portion of structured data is associated with edit history data;

a receiver to receive input to execute a function associated with a display element of a Graphical User interface (GUI), the display element being a drop-down menu to display the edit history data relating to the portion of structured data; and

a retriever to, in response to receiving the input;

access an edit history database at a server including accessing the edit history database over a network using a networking protocol, the edit history database tracking changes to content of the structured data as the changes are made by a plurality of users including tracking a particular change from a first version of the content of the structured data to a second version of the content of the structured data, the particular change being accessible to the plurality of users, and

retrieve, using at least one processor coupled to a memory, from the edit history database, the edit history data for the displayed portion of the structured data based upon the function, the edit history data reflecting changes to the displayed portion of the structured data made by the plurality of users;

wherein the display is further configured to display the edit history data in the GUI as part of the display element.

21. The computer system of claim 20, wherein the function associated with the display element includes a mouse-over function, a focus function, right-click function, left-click function, or a keyboard function.

22. The computer system of claim 20, further comprising an additional receiver to receive input to execute the function associated with the display element, the display element located proximate to the displayed portion of the structured data.

23. The computer system of claim 20, wherein the changes include at least one of a deletion of editing record data, deletion of a column, deletion of a row, a change to a data style, adding a row, adding a column, changing a data type, changing a relationship between tables in a schema, changing a function used to process data included in a database table, creating a new table, or changing privileges associated with editing the structured data.

24. The computer system of claim 20, wherein the displayed portion of the structured data includes at least one of a database table, a structured data column, a structured data row, or a structured data schema.

25. The computer system of claim 20, further comprising a highlighting engine to highlight the displayed portion of the structured data.

26. The computer system of claim 20, wherein the edit history data includes identity information that identifies at least one of a user, date information, or time information.

27. The computer system of claim 20, further comprising:

an additional receiver to receive additional input to display the display element, the display element to display additional edit history data relating to an additional displayed portion of the structured data;

an additional retriever to retrieve additional edit history data for the additionally displayed portion of the structured data based on the function, the additional edit history data including additional changes made to the additionally displayed portion of the structured data; and

an additional display to display the additional edit history data in real time on the display as part of the display element.

28. The computer system of claim 20, further comprising a highlighting engine to highlight changes made to the structured data subsequent to a previous session.

29. An apparatus comprising:

means for displaying an indicator relating to a displayed portion of structured data in response to a graphical pointer being near the portion of structured data, the indicator indicating that the portion of structured data is associated with edit history data;

means for receiving input to execute a function associated with a display element of a Graphical User interface (GUI), the display element being a drop-down menu to display the edit history data relating to the portion of structured data;

means for accessing an edit history database at a server including accessing the edit history database over a network using a networking protocol, the edit history database tracking changes to content of the structured data as the changes are made by a plurality of users including tracking a particular change from a first version of the content of the structured data to a second version of the content of the structured data, the particular change being accessible to the plurality of users;

means for retrieving, using at least one processor coupled to a memory, from the edit history database, the edit history data for the displayed portion of the structured data based upon the function, the edit history data reflecting changes to the displayed portion of the structured data made by the plurality of users; and

means for displaying the edit history data in the GUI as part of the display element.

30. A machine-readable non-transitory storage medium comprising instructions, which when implemented by one or more machines, cause the one or more machines to perform the following operations:

displaying an indicator relating to a displayed portion of structured data in response to a graphical pointer being near the portion of structured data, the indicator indicating that the portion of structured data is associated with edit history data;

receive input to execute a function associated with a display element of a Graphical User Interface (GUI), the display element being a drop-down menu to display the edit history data relating to the portion of structured data;

access an edit history database at a server including accessing the edit history database over a network using a networking protocol, the edit history database tracking changes to content of the structured data as the changes are made by a plurality of users including tracking a particular change from a first version of the content of the structured data to a second version of the content of the structured data, the particular change being accessible to the plurality of users;

retrieve, from the edit history database, the edit history data for the displayed portion of the structured data based upon the function, the edit history data reflecting changes to the displayed portion of the structured data made by the plurality of users; and

display the edit history data in the GUI as part of the display element.