{"id":"https://openalex.org/W4226187622","doi":"https://doi.org/10.14778/3503585.3503603","title":"Retrofitting GDPR compliance onto legacy databases","display_name":"Retrofitting GDPR compliance onto legacy databases","publication_year":2021,"publication_date":"2021-12-01","ids":{"openalex":"https://openalex.org/W4226187622","doi":"https://doi.org/10.14778/3503585.3503603"},"language":"en","primary_location":{"id":"doi:10.14778/3503585.3503603","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3503585.3503603","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037522797","display_name":"Archita Agarwal","orcid":null},"institutions":[{"id":"https://openalex.org/I20577493","display_name":"Denison University","ror":"https://ror.org/05pqx1c24","country_code":"US","type":"education","lineage":["https://openalex.org/I20577493"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Archita Agarwal","raw_affiliation_strings":["Denison University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Denison University","institution_ids":["https://openalex.org/I20577493"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072941929","display_name":"Marilyn George","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Marilyn George","raw_affiliation_strings":["Brown University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Brown University","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003477469","display_name":"Aaron Jeyaraj","orcid":null},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aaron Jeyaraj","raw_affiliation_strings":["Brown University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Brown University","institution_ids":["https://openalex.org/I27804330"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5025826441","display_name":"Malte Schwarzkopf","orcid":"https://orcid.org/0000-0002-5066-6332"},"institutions":[{"id":"https://openalex.org/I27804330","display_name":"Brown University","ror":"https://ror.org/05gq02987","country_code":"US","type":"education","lineage":["https://openalex.org/I27804330"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Malte Schwarzkopf","raw_affiliation_strings":["Brown University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Brown University","institution_ids":["https://openalex.org/I27804330"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2683,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.80773346,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"15","issue":"4","first_page":"958","last_page":"970"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10927","display_name":"Access Control and Trust","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7790588140487671},{"id":"https://openalex.org/keywords/general-data-protection-regulation","display_name":"General Data Protection Regulation","score":0.6982173323631287},{"id":"https://openalex.org/keywords/bespoke","display_name":"Bespoke","score":0.6923236846923828},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5593219995498657},{"id":"https://openalex.org/keywords/data-protection-act-1998","display_name":"Data Protection Act 1998","score":0.36437106132507324},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3554912209510803},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.1897762417793274}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7790588140487671},{"id":"https://openalex.org/C3090818","wikidata":"https://www.wikidata.org/wiki/Q1172506","display_name":"General Data Protection Regulation","level":3,"score":0.6982173323631287},{"id":"https://openalex.org/C44210515","wikidata":"https://www.wikidata.org/wiki/Q16968978","display_name":"Bespoke","level":2,"score":0.6923236846923828},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5593219995498657},{"id":"https://openalex.org/C69360830","wikidata":"https://www.wikidata.org/wiki/Q1172237","display_name":"Data Protection Act 1998","level":2,"score":0.36437106132507324},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3554912209510803},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.1897762417793274},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3503585.3503603","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3503585.3503603","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","score":0.7599999904632568,"display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W760598031","https://openalex.org/W1964312191","https://openalex.org/W2099725016","https://openalex.org/W2112129552","https://openalex.org/W2140313762","https://openalex.org/W2140523882","https://openalex.org/W2182148130","https://openalex.org/W2394595640","https://openalex.org/W2737168042","https://openalex.org/W2758610895","https://openalex.org/W2978817023","https://openalex.org/W2981442692","https://openalex.org/W2981810231","https://openalex.org/W3125140672","https://openalex.org/W3149592999","https://openalex.org/W3175787319","https://openalex.org/W6733170484"],"related_works":["https://openalex.org/W2917102635","https://openalex.org/W3023256691","https://openalex.org/W2603253017","https://openalex.org/W2789497412","https://openalex.org/W2901967497","https://openalex.org/W2910484607","https://openalex.org/W2794700933","https://openalex.org/W3171079982","https://openalex.org/W3048759155","https://openalex.org/W2087147177"],"abstract_inverted_index":{"New":[0],"privacy":[1,166],"laws":[2],"like":[3],"the":[4,83,125],"European":[5],"Union's":[6],"General":[7],"Data":[8],"Protection":[9],"Regulation":[10],"(GDPR)":[11],"require":[12],"database":[13],"administrators":[14],"(DBAs)":[15],"to":[16,21,28,53,76,127,152],"identify":[17,115],"all":[18],"information":[19],"related":[20],"an":[22,129],"individual":[23],"on":[24,109],"request,":[25],"e.g.":[26],",":[27],"return":[29],"or":[30,98],"delete":[31],"it.":[32],"This":[33],"requires":[34],"time-consuming":[35],"manual":[36,157],"labor":[37],"today,":[38],"particularly":[39],"for":[40,64,82],"legacy":[41,65],"schemas":[42],"and":[43,120,145,155],"applications.":[44],"In":[45,132],"this":[46],"paper,":[47],"we":[48],"investigate":[49],"what":[50],"it":[51],"takes":[52],"provide":[54],"mostly-automated":[55],"tools":[56],"that":[57,69,80,114],"assist":[58],"DBAs":[59],"in":[60,102],"GDPR-compliant":[61],"data":[62,100],"extraction":[63],"databases.":[66],"We":[67],"find":[68],"a":[70,78,133],"combination":[71],"of":[72,85,159],"techniques":[73],"is":[74,162],"needed":[75],"realize":[77],"tool":[79],"works":[81],"databases":[84],"real-world":[86],"applications,":[87,91,140],"such":[88],"as":[89],"web":[90,139],"which":[92],"may":[93],"violate":[94],"strict":[95],"normal":[96],"forms":[97],"encode":[99],"relationships":[101],"bespoke":[103],"ways.":[104],"Our":[105],"tool,":[106],"GDPRizer,":[107],"relies":[108],"foreign":[110],"keys,":[111],"query":[112],"logs":[113],"implied":[116],"relationships,":[117],"data-driven":[118],"methods,":[119],"coarse-grained":[121],"annotations":[122],"provided":[123],"by":[124],"DBA":[126],"extract":[128],"individual's":[130],"data.":[131],"case":[134],"study":[135],"with":[136],"three":[137],"popular":[138],"GDPRizer":[141,148,164],"achieves":[142],"100%":[143],"precision":[144],"96--100%":[146],"recall.":[147],"saves":[149],"work":[150],"compared":[151],"hand-written":[153],"queries,":[154],"while":[156],"verification":[158],"its":[160],"outputs":[161],"required,":[163],"simplifies":[165],"compliance.":[167]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":3}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}