SYSTEMS AND METHODS FOR CONTEXT-SENSITIVE DATA ANNOTATION AND ANNOTATION VISUALIZATION

• US 20180096039A1
• Filed: 09/30/2016
• Published: 04/05/2018
• Est. Priority Date: 09/30/2016
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Otaguro, David
• Granted Patent: US 10,452,679 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/9038 Presentation of query results

Abstract

Systems and methods for receiving, storing, and returning annotations in association with annotated data. Data visualizations can be generated using data selected from a data organization and storage system, e.g., a database. Annotation data is stored in association with the underlying data used to generate data visualizations. Future renderings of data visualizations using the same underlying data may then include the corresponding annotation data. In some implementations, a system includes a data storage system storing a plurality of data entries in a database and a processor configured to generate data visualizations representative of the plurality of data entries stored in the database, receive a selection of an element of a data visualization, identify data entries represented by the selected element; receive annotation data associated with the selection, and record data associating the received annotation data with the identified data entries.

Claims

1. A method comprising:

generating a first data visualization representative of a plurality of data entries stored in a database;

receiving a selection of an element of the first data visualization;

identifying a subset of the plurality of data entries represented by the selected element of the data visualization;

receiving annotation data associated with the selection;

recording, in the database, an associative record associating the received annotation data with the identified subset of the plurality of data entries represented by the selected element of the data visualization;

generating a second data visualization representative of data that includes a data entry from the identified subset; and

including, with the second data visualization, the received annotation data in association with a portion of the second data visualization representative of the included data entry from the identified subset.

2. The method of claim 1, comprising storing, in the database, a scope definition for the association between the received annotation data and the identified subset of the plurality of data entries represented by the selected element of the data visualization.

3. The method of claim 2, wherein the scope definition includes a data structure comprising a set of filters and a set of column identifiers.

4. The method of claim 2, wherein the scope definition includes a Structured Query Language (SQL) query.

5. The method of claim 2, wherein the scope definition includes a set of fixed row identifiers.

6. The method of claim 1, wherein the associative record includes permissions data limiting access to the associative record.

7. The method of claim 6, wherein the permissions data includes an Access Control List (ACL).

8. The method of claim 1, comprising:

generating the first data visualization from aggregated data derived from the represented plurality of data entries stored in a database; and

identifying the subset of the plurality of data entries represented by the selected element of the data visualization by identifying source data corresponding to, and aggregated into, the aggregated data represented by the selected element of the first data visualization.

9. The method of claim 8, wherein the first data visualization includes metadata describing the source data.

10. A system comprising:

a data storage system storing a plurality of data entries in a database;

a network interface;

a processor configured to execute instructions stored in a memory; and

the memory storing instructions that, when executed by the processor, cause the processor to;

generate a first data visualization representative of the plurality of data entries stored in the database;

receive, via the network interface, a selection of an element of the first data visualization;

identify a subset of the plurality of data entries represented by the selected element of the data visualization;

receive, via the network interface, annotation data associated with the selection;

record, in the database, an associative record associating the received annotation data with the identified subset of the plurality of data entries represented by the selected element of the data visualization;

generate a second data visualization representative of data that includes a data entry from the identified subset and include, with the second data visualization, the received annotation data in association with a portion of the second data visualization representative of the included data entry from the identified subset.

11. The system of claim 10, wherein the database stores a scope definition for the association between the received annotation data and the identified subset of the plurality of data entries represented by the selected element of the data visualization.

12. The system of claim 11, wherein the scope definition includes a data structure comprising a set of filters and a set of column identifiers.

13. The system of claim 11, wherein the scope definition includes a Structured Query Language (SQL) query.

14. The system of claim 11, wherein the scope definition includes a set of fixed row identifiers.

15. The system of claim 10, wherein the associative record includes permissions data limiting access to the associative record.

16. The system of claim 15, wherein the permissions data includes an Access Control List (ACL).

17. The system of claim 10, the memory further storing instructions that, when executed by the processor, cause the processor to:

generate the first data visualization from aggregated data derived from the represented plurality of data entries stored in a database; and

identify the subset of the plurality of data entries represented by the selected element of the data visualization by identifying source data corresponding to, and aggregated into, the aggregated data represented by the selected element of the first data visualization.

18. The system of claim 17, wherein the first data visualization includes metadata describing the source data.

19. A non-transitory computer-readable medium storing instructions that, when executed by a processor, cause the processor to:

generate a first data visualization representative of a plurality of data entries stored in a database;

receive, via a network interface, a selection of an element of the first data visualization;

identify a subset of the plurality of data entries represented by the selected element of the data visualization;

receive, via the network interface, annotation data associated with the selection;

record, in the database, an associative record associating the received annotation data with the identified subset of the plurality of data entries represented by the selected element of the data visualization; and

generate a second data visualization representative of data that includes a data entry from the identified subset and include, with the second data visualization, the received annotation data in association with a portion of the second data visualization representative of the included data entry from the identified subset.

20. The non-transitory computer-readable medium of claim 19, wherein the database stores a scope definition for the association between the received annotation data and the identified subset of the plurality of data entries represented by the selected element of the data visualization.