An annotation management system for relational databases
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
ULDBs: databases with uncertainty and lineage
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Provenance and Annotation for Visual Exploration Systems
IEEE Transactions on Visualization and Computer Graphics
Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
ViP: A User-Centric View-Based Annotation Framework for Scientific Data
SSDBM '08 Proceedings of the 20th international conference on Scientific and Statistical Database Management
Engineering Privacy Requirements in Business Intelligence Applications
SDM '08 Proceedings of the 5th VLDB workshop on Secure Data Management
On the provenance of non-answers to queries over extracted data
Proceedings of the VLDB Endowment
Supporting annotations on relations
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Provenance for nested subqueries
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Provenance in Databases: Why, How, and Where
Foundations and Trends in Databases
Believe it or not: adding belief annotations to databases
Proceedings of the VLDB Endowment
Relational completeness of query languages for annotated databases
DBPL'07 Proceedings of the 11th international conference on Database programming languages
I4E: interactive investigation of iterative information extraction
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
Annotations: dynamic semantics in stream processing
PIKM '10 Proceedings of the 3rd workshop on Ph.D. students in information and knowledge management
The Foundations for Provenance on the Web
Foundations and Trends in Web Science
Relational completeness of query languages for annotated databases
Journal of Computer and System Sciences
iMONDRIAN: a visual tool to annotate and query scientific databases
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Combining dependent annotations for relational algebra
Proceedings of the 15th International Conference on Database Theory
An annotation management system for multidimensional databases
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Database support for enabling data-discovery queries over semantically-annotated observational data
Transactions on Large-Scale Data- and Knowledge-Centered Systems VI
Proceedings of the 16th International Conference on Database Theory
Supporting data aspects in pig latin
Proceedings of the 12th annual international conference on Aspect-oriented software development
The W3C PROV family of specifications for modelling provenance metadata
Proceedings of the 16th International Conference on Extending Database Technology
Enhancing scientific information systems with semantic annotations
Proceedings of the 28th Annual ACM Symposium on Applied Computing
Hi-index | 0.00 |
We demonstrate DBNotes, a Post-It note system for relational databases where every piece of data may be associated with zero or more notes (or annotations). These annotations are transparently propagated along as data is being transformed. The method by which annotations are propagated is based on provenance (aka lineage): the annotations associated with a piece of data d in the result of a transformation consist of the annotations associated with each piece of data in the source where d is copied from. One immediate application of this system is to use annotations to systematically trace the provenance and flow of data. If every piece of source data is attached with an annotation that describes its address (i.e., origins), then the annotations of a piece of data in the result of a transformation describe its provenance. Hence, one can easily determine the provenance of data through a sequence of transformation steps simply by examining the annotations. Annotations can also be used to store additional information about data. Since a database schema is often proprietary, the ability to insert new information about data without having to change the underlying schema is a useful feature. For example, an error report could be attached to an erroneous piece of data, and this error report will be propagated to other databases along transformations, thus notifying other users of the error. Overall, the annotations on the result of a transformation can also provide an estimate on the quality of the resulting database.