View-independent annotation of commercial data
View Patent ↗A first view of commercial data is presented to a first user. A data selection criterion is received from the user. A first data set is identified based on the selection criterion. Annotation content is received from the user. The annotation content and the first view of the commercial data is associated with the first data set. A query is received for a second view from a second user, in which the second view includes at least a portion of the first data set. The second view is presented to the second user, together with the annotations associated with the portion of the first data set included in the second view.
1. A data annotation system comprising:
a commercial data store containing commercial data arranged in a database with a number of records;
an annotation data store containing annotations associated with the commercial data store; and
a report generator for presenting a report including:
a view of data from the commercial data store pertinent to a query; and
an annotation from the annotation data store pertinent to the data;
wherein the annotation is a view-independent annotation containing a description of the query, the view, at least one aggregation behavior preference specifying whether the annotation should be aggregated or disaggregated with the data in the view, and other information to reconstruct a context in which the annotation was made, and wherein the annotation is linked to the view of data from the commercial data store.
2. The system of claim 1 , wherein the annotation is stored in one of the number of records in the database corresponding to a commercial item to which the annotation pertains.
3. The system of claim 2 , wherein available commercial items include a product, a collection of products, a store, a collection of stores, a transaction, a collection of transactions, a time, and a time frame.
4. The system of claim 1 , wherein the annotations are stored in a database separate from the commercial data, and wherein the annotations are linked to the commercial data by one or more keys.
5. The system of claim 1 , wherein the annotations are stored in a database separate from the commercial data, and wherein the annotations are linked to the commercial data by one or more dimensional constraints.
6. A method comprising:
receiving a query from a user including 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;
presenting the first view to the user in a display;
receiving an annotation from the user linked to the data in the first view, wherein the annotation is a view-independent annotation containing a description of the first view, the query for the first view, at least one aggregation behavior preference specifying whether the annotation should be aggregated or disaggregated with the data in the first data set, and other information to reconstruct a context in which the annotation was made;
using a computer, associating the annotation with the first data set and the query that produced the first view;
receiving a query for a second view of the commercial data from a second user, in which the second view includes at least a portion of the first data set associated with the annotation; and
presenting the second view of the commercial data to the second user, together with the annotation.
7. The method of claim 6 , wherein the annotation is presented within a threaded conversation including a plurality of annotations from one or more users.
8. The method of claim 6 , wherein the annotation is presented chronologically with a plurality of annotations from one or more users.
9. The method of claim 6 further comprising storing the annotation in one of the number of records in the database containing a commercial item associated with the annotation.
10. The method of claim 6 further comprising linking the annotation to one of the records of the database.
11. The method of claim 6 further comprising linking the annotation to the data 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.
12. The method of claim 6 further comprising linking the annotation to the data with a dynamic association that links the annotation to a dimensional constraint of the commercial data irrespective of how the commercial data changes.
13. A computer program product for annotating data, 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 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;
presenting the first view to the user in a display;
receiving an annotation from the user linked to data in the first view and including information from the user, wherein the annotation is a view-independent annotation containing a description of the first view, the query for the first view, at least one aggregation behavior preference specifying whether the annotation should be aggregated or disaggregated with the data in the first data set, and other information to reconstruct a context in which the annotation was made;
associating the annotation with the first data set and the query that produced the first view;
receiving a query for a second view of the commercial data from a second user, in which the second view includes at least a portion of the first data set associated with the annotation; and
presenting the second view of the commercial data to the second user, together with the annotation.
14. The computer program product of claim 13 wherein associating the annotation with the first data set includes associating the annotation with a dimensional constraint of the query.
15. The computer program product of claim 13 wherein associating the annotation with the first data set includes storing the annotation in a second database and linking the annotation to one of the records in the first data set.
16. The computer program product of claim 13 further comprising code that performs the step of receiving a plurality of annotations to the first data set from one or more users.
17. The computer program product of claim 16 further comprising code that performs the step of arranging the plurality of annotations in a threaded message.
18. The computer program product of claim 16 further comprising code that performs the step of arranging the plurality of annotations chronologically.
19. The computer program product of claim 13 wherein associating the annotation with the first data set includes storing information sufficient to reconstruct a display of the first data set at the time that the annotation was made.
20. The computer program product of claim 19 wherein the information includes at least one of cursor positioning, highlighting, and zoom levels.