Articles liés à Enabling privacy-preserving SQL-log analysis: in MySQL...

Enabling privacy-preserving SQL-log analysis: in MySQL and Oracle - Couverture souple

Fang, Hongjie

 
9783330517974: Enabling privacy-preserving SQL-log analysis: in MySQL and Oracle
Couverture souple
ISBN 10 : 3330517972 ISBN 13 : 9783330517974
Editeur : AV Akademikerverlag, 2017

Synopsis

The topic of this scientific work is enabling privacy-preserving SQL-log analysis. Our goal is to find out an anonymization method, which aims to protect the privacy of SQL-log, meanwhile it has as less effect on the query plans as possible. Our experimental database and queries come from the famous TPC-H benchmark, in which we have the well constructed schema of original tables and all the 22 queries are designed to test as many aspects of the database as possible. We use existing DBMSs (Oracle and MySQL) to carry out our approach and test the performance of the anonymization method in the two DBMSs. As final results, our original anonymization method has successfully anonymized 95.45% of the queries in MySQL, which have always the same query plans. Experiments within Oracle need to be adjusted 3 times to improve the ratio of well anonymized query statements from 50% to 89.47%.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

The topic of this scientific work is enabling privacy-preserving SQL-log analysis. Our goal is to find out an anonymization method, which aims to protect the privacy of SQL-log, meanwhile it has as less effect on the query plans as possible. Our experimental database and queries come from the famous TPC-H benchmark, in which we have the well constructed schema of original tables and all the 22 queries are designed to test as many aspects of the database as possible. We use existing DBMSs (Oracle and MySQL) to carry out our approach and test the performance of the anonymization method in the two DBMSs. As final results, our original anonymization method has successfully anonymized 95.45% of the queries in MySQL, which have always the same query plans. Experiments within Oracle need to be adjusted 3 times to improve the ratio of well anonymized query statements from 50% to 89.47%.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
AV Akademikerverlag
Date d'édition
2017
Langue
anglais
ISBN 10 
3330517972
ISBN 13 
9783330517974
Reliure
Broché
Nombre de pages
104
Coordonnées du fabricant
non disponible
Personne responsable
non disponible