TY - GEN
T1 - An architecture for regulatory compliant database management
AU - Mitra, Soumyadeb
AU - Winslett, Marianne
AU - Snodgrass, Richard T.
AU - Yaduvanshi, Shashank
AU - Ambokar, Sumedh
PY - 2009
Y1 - 2009
N2 - Spurred by financial scandals and privacy concerns, governments worldwide have moved to ensure confidence in digital records by regulating their retention and deletion. These requirements have led to a huge market for compliance storage servers, which ensure that data are not shredded or altered before the end of their mandatory retention period. These servers preserve unstructured and semi-structured data at a file-level granularity: email, spreadsheets, reports, instant messages. In this paper, we extend this level of protection to structured data residing in relational databases. We propose a compliant DBMS architecture and two refinements that illustrate the additional security that one can gain with only a slight performance penalty, with almost no modifications to the DBMS kernel. We evaluate our proposed architecture through experiments with TPC-C on a high-performance DBMS, and show that the runtime overhead for transaction processing is approximately 10% in typical configurations.
AB - Spurred by financial scandals and privacy concerns, governments worldwide have moved to ensure confidence in digital records by regulating their retention and deletion. These requirements have led to a huge market for compliance storage servers, which ensure that data are not shredded or altered before the end of their mandatory retention period. These servers preserve unstructured and semi-structured data at a file-level granularity: email, spreadsheets, reports, instant messages. In this paper, we extend this level of protection to structured data residing in relational databases. We propose a compliant DBMS architecture and two refinements that illustrate the additional security that one can gain with only a slight performance penalty, with almost no modifications to the DBMS kernel. We evaluate our proposed architecture through experiments with TPC-C on a high-performance DBMS, and show that the runtime overhead for transaction processing is approximately 10% in typical configurations.
UR - http://www.scopus.com/inward/record.url?scp=67649646394&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=67649646394&partnerID=8YFLogxK
U2 - 10.1109/ICDE.2009.69
DO - 10.1109/ICDE.2009.69
M3 - Conference contribution
AN - SCOPUS:67649646394
SN - 9780769535456
T3 - Proceedings - International Conference on Data Engineering
SP - 162
EP - 173
BT - Proceedings - 25th IEEE International Conference on Data Engineering, ICDE 2009
T2 - 25th IEEE International Conference on Data Engineering, ICDE 2009
Y2 - 29 March 2009 through 2 April 2009
ER -