Systems and methods for context-sensitive data annotation and annotation visualization

• US 10,452,679 B2
• Filed: 09/30/2016
• Issued: 10/22/2019
• Est. Priority Date: 09/30/2016
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google LLC (Alphabet Inc.)
• Inventors: Otaguro, David
• Primary Examiner(s): Casanova, Jorge A
• Application Number:
  US15/282,680
• Publication Number:
  US 20180096039A1
• Time in Patent Office: 1,117 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 values, wherein the plurality of data values are a function of values of a plurality of source data entries stored in a database;

receiving, from a first user, a selection of an element of the first data visualization associated with one or more of the plurality of data values;

identifying a subset of the plurality of source data entries based on the selection, wherein the one or more of the plurality of data values are a function of the subset of the plurality of source data entries;

receiving, from the first user, annotation data associated with the selection and one or more privileges associated with the annotation data;

recording, in the database, an associative record associating the received annotation data with the identified subset of the plurality of source data entries and the one or more privileges;

receiving, from a second user, a request to generate a second data visualization representative of data that includes a data value, wherein the data value is a function of at least one source data entry from the identified subset of the plurality of source data entries;

determining, based on the one or more privileges, whether the second user is authorized to view the annotation data;

generating the second data visualization in response to the request;

causing a user device to display the second data visualization with the received annotation data in association with a portion of the second data visualization representative of the data value in response to a first determination that the second user is authorized to view the annotation data; and

causing the user device to display the second data visualization without the annotation data in response to a second determination that the second user is not authorized to view the annotation data.

2. The method of claim 1, further comprising storing, in the database, a scope definition for the association between the received annotation data and the identified subset of the plurality of source data entries.

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 one or more privileges include an Access Control List (ACL).

7. The method of claim 1, wherein the plurality of data values are aggregated data values, wherein the method further comprises:

generating the first data visualization based on the aggregated data values, wherein the aggregated data values are derived from the plurality of source data entries stored in the database; and

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

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

9. The method of claim 1, wherein the one or more privileges further identify one or more users authorized to respond to the annotation data;

wherein the method further comprises;

determining whether the second user is authorized to respond to the annotation data based on the one or more privileges;

receiving second annotation data from the second user, wherein the second annotation data is a response to the annotation data; and

recording, in the database, the second annotation data in response to a third determination that the second user is authorized to respond to the annotation data.

10. The method of claim 9, wherein the annotation data comprises an invitation inviting the second user to respond to the annotation data, wherein the invitation identifies the second user.

11. A system comprising:

a data storage system storing a plurality of source 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 a plurality of data values, wherein the plurality of data values are a function of values of the plurality of source data entries stored in the database;

receive, via the network interface from a first user, a selection of an element of the first data visualization associated with one or more of the plurality of data values;

identify a subset of the plurality of source data entries based on the selection, wherein the one or more of the plurality of data values are a function of the subset of the plurality of source data entries;

receive, via the network interface from the first user, annotation data associated with the selection and one or more privileges associated with the annotation data;

record, in the database, an associative record associating the received annotation data with the identified subset of the plurality of source data entries and the one or more privileges;

receive, via the network interface from a second user, a request to generate a second data visualization representative of data that includes a data value, wherein the data value is a function of at least one source data entry from the identified subset of the plurality of source data entries;

determine, based on the one or more privileges, whether the second user is authorized to view the annotation data;

generate the second data visualization in response to the request;

cause a user device to display the second data visualization with the received annotation data in association with a portion of the second data visualization representative of the data value in response to a first determination that the second user is authorized to view the annotation data; and

cause the user device to display the second data visualization without the annotation data in response to a second determination that the second user is not authorized to view the annotation data.

12. The system of claim 11, wherein the database stores a scope definition for the association between the received annotation data and the identified subset of the plurality of source data entries.

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

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

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

16. The system of claim 11, wherein the one or more privileges include an Access Control List (ACL).

17. The system of claim 11, wherein the plurality of data values are aggregated data values, wherein the memory further storing instructions that, when executed by the processor, cause the processor to:

generate the first data visualization based on the aggregated data values, wherein the aggregated data values are derived from the plurality of source data entries stored in the database; and

identify the subset of the plurality of source data entries by identifying one or more of the plurality of source data entries corresponding to, and aggregated into, one or more of the aggregated data values 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 plurality of source data entries.

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 values, wherein the plurality of data values are a function of values of a plurality of source data entries stored in a database;

receive, via a network interface from a first user, a selection of an element of the first data visualization associated with one or more of the plurality of data values;

identify a subset of the plurality of source data entries based on the selection, wherein the one or more of the plurality of data values are a function of the subset of the plurality of source data entries;

receive, via the network interface from the first user, annotation data associated with the selection and one or more privileges associated with the annotation data;

record, in the database, an associative record associating the received annotation data with the identified subset of the plurality of source data entries and the one or more privileges; and

receiving, via the network interface from a second user, a request to generate a second data visualization representative of data that includes a data value, wherein the data value is a function of at least one source data entry from the identified subset of the plurality of source data entries;

determine, based on the one or more privileges, whether the second user is authorized to view the annotation data;

generate the second data visualization in response to the request;

cause a user device to display the second data visualization with the received annotation data in association with a portion of the second data visualization representative of the data value in response to a first determination that the second user is authorized to view the annotation data; and

cause the user device to display the second data visualization without the annotation data in response to a second determination that the second user is not authorized to view the annotation data.

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 source data entries.