Context-dependent annotations to database views
View Patent ↗A technique for context-dependent annotations to database views may include receiving a query including a data selection criterion for retrieving data from a commercial data store, identifying a first view containing a first data set based on the query, displaying a result from the query to a user, and receiving annotation content from the user linked to data in the first view including view-related information to reconstruct the result as displayed to the user when the annotation content was received. The technique may also include receiving a query for a second view of the commercial data from a second user, where the second view includes at least a portion of the first data set, and presenting the second view of the commercial data to the second user, together with any of the annotation content associated with the portion of the first data set included in the second view.
1. A computer program product for context-dependent annotations to database views, the computer program product comprising computer executable code embodied in a non-transitory computer readable medium that, when executing on one or more computing devices, performs the steps of:
receiving a query from a user including a data selection criterion for retrieving data from a commercial data store containing commercial data arranged in a database with a number of records;
identifying a first view containing a first data set based on the query;
displaying a result from the query to the user;
receiving annotation content from the user linked to data in the first view, wherein the annotation content includes view-related information to reconstruct the result as displayed to the user when the annotation content was received, and wherein the annotation content further includes at least one aggregation behavior specifying whether an annotation should be aggregated or disaggregated with data in the first data set;
receiving a query for a second view of the commercial data from a second user, wherein the second view includes at least a portion of the first data set; and
presenting the second view of the commercial data to the second user, together with any of the annotation content associated with the portion of the first data set included in the second view.
2. The computer program product of claim 1 wherein the view-related information includes cursor positioning.
3. The computer program product of claim 1 wherein the view-related information includes highlighting.
4. The computer program product of claim 1 wherein the view-related information includes a zoom level.
5. The computer program product of claim 1 wherein the view-related information includes a display option.
6. The computer program product of claim 1 wherein the annotation is linked to a record in the first data set.
7. The computer program product of claim 1 wherein the annotation is linked to a dimension in the first data set.
8. The computer program product of claim 7 wherein the annotation is linked to a plurality of dimensions in the first data set.
9. The computer program product of claim 1 wherein the commercial data includes data for at least data for at least one of products, stores, and transactions.
10. The computer program product of claim 9 wherein the commercial data includes at least one of a total volume of sales of a product at a particular store, a collection of stores, or a geographic area.
11. The computer program product of claim 1 further comprising code that performs the step of receiving a plurality of annotations to the first data set from one or more users.
12. The computer program product of claim 11 further comprising code that performs the step of arranging the plurality of annotations in a threaded conversation.
13. The computer program product of claim 11 further comprising code that performs the step of arranging the plurality of annotations chronologically.
14. The computer program of claim 1 further comprising code that performs the step of linking the annotation content to the data in the first view with a static association that links the annotation to a dimensional constraint of the commercial data as the dimensional constraint existed at the time of the annotation.
15. The computer program of claim 1 further comprising code that performs the step of linking the annotation to the data with a dynamic association that links the annotation to a dimensional constraint of the commercial data independent of change to the commercial data.
16. The computer program of claim 1 wherein the annotation content is stored in one of the number of records in the commercial data store to which the annotation pertains.
17. The computer program product of claim 1 wherein the annotation content is stored in a database separate from the commercial data store.
18. The computer program product of claim 17 wherein the annotations are linked to the commercial data by one or more keys.