Name
Abstract | ||
|---|---|---|
The increasing amounts of data produced by automated scientific instruments require scalable data management platforms for storing, transforming and analyzing scientific data. At the same time, it is paramount for scientific applications to keep track of the provenance information for quality control purposes and to be able to re-trace workflow steps. Relational database systems are designed to efficiently manage and analyze large data volumes, and modern extensible database systems can also host complex data transformations as stored procedures. However, the relational model does not naturally support data provenance or lineage tracking. In this paper, we focus on providing data provenance management in relational databases for stored procedures. Our approach, called PSP, leverages the XML capabilities of SQL:2003 to keep track of the lineage of the data that has been processed by any stored procedure in a relational database as part of a scientific workflow. We show how this approach can be implemented in a state-of-the-art DBMS and discuss how the captured provenance data can be efficiently queried and analyzed. |
Year | DOI | Venue |
|---|---|---|
2009 | 10.1007/978-3-642-04205-8_10 | DASFAA Workshops |
Keywords | Field | DocType |
large data volume,data provenance management,provenance data,stored procedures,relational databases,relational database,scientific data,provenance information,provenance,scalable data management platform,stored procedure,data provenance,automated scientific instrument,complex data,data provenance support,relational database.,relational database system,quality control,data management,relational model,database system | SQL,Data mining,Stored procedure,Database model,Relational database,Information retrieval,Computer science,Database design,Relational database management system,Relational model,Database,Change data capture | Conference |
Volume | ISSN | Citations |
5667 | 0302-9743 | 1 |
PageRank | References | Authors |
0.36 | 14 | 2 |
Name | Order | Citations | PageRank |
|---|---|---|---|
| Winly Jurnawan | 1 | 1 | 0.36 |
| Uwe Röhm | 2 | 308 | 31.42 |