{"id":"https://openalex.org/W2980759111","doi":"https://doi.org/10.1109/tkde.2019.2947061","title":"Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey","display_name":"Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey","publication_year":2019,"publication_date":"2019-10-14","ids":{"openalex":"https://openalex.org/W2980759111","doi":"https://doi.org/10.1109/tkde.2019.2947061","mag":"2980759111"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2019.2947061","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2947061","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5100335366","display_name":"Bo Zhang","orcid":"https://orcid.org/0000-0003-1428-6639"},"institutions":[{"id":"https://openalex.org/I108468826","display_name":"Stevens Institute of Technology","ror":"https://ror.org/02z43xh36","country_code":"US","type":"education","lineage":["https://openalex.org/I108468826"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bo Zhang","raw_affiliation_strings":["Department of Computer Science, Stevens Institute of Technology, Hoboken, NJ, USA"],"raw_orcid":"https://orcid.org/0000-0003-1428-6639","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Stevens Institute of Technology, Hoboken, NJ, USA","institution_ids":["https://openalex.org/I108468826"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089251186","display_name":"Boxiang Dong","orcid":"https://orcid.org/0000-0001-9520-1494"},"institutions":[{"id":"https://openalex.org/I166088655","display_name":"Montclair State University","ror":"https://ror.org/01nxc2t48","country_code":"US","type":"education","lineage":["https://openalex.org/I166088655"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Boxiang Dong","raw_affiliation_strings":["Department of Computer Science, Montclair State University, Montclair, NJ, USA"],"raw_orcid":"https://orcid.org/0000-0001-9520-1494","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Montclair State University, Montclair, NJ, USA","institution_ids":["https://openalex.org/I166088655"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100460778","display_name":"Hui Wang","orcid":"https://orcid.org/0000-0002-3913-815X"},"institutions":[{"id":"https://openalex.org/I108468826","display_name":"Stevens Institute of Technology","ror":"https://ror.org/02z43xh36","country_code":"US","type":"education","lineage":["https://openalex.org/I108468826"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wendy Hui Wang","raw_affiliation_strings":["Department of Computer Science, Stevens Institute of Technology, Hoboken, NJ, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Stevens Institute of Technology, Hoboken, NJ, USA","institution_ids":["https://openalex.org/I108468826"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.411,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.91396171,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"33","issue":"4","first_page":"1601","last_page":"1618"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11614","display_name":"Cloud Data Security Solutions","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11614","display_name":"Cloud Data Security Solutions","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10237","display_name":"Cryptography and Data Security","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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9961000084877014,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8279680013656616},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6943739056587219},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.6266627311706543},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5902915000915527},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.5760173201560974},{"id":"https://openalex.org/keywords/outsourcing","display_name":"Outsourcing","score":0.5355935096740723},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.529249370098114},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4490264356136322},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4371485412120819},{"id":"https://openalex.org/keywords/service-provider","display_name":"Service provider","score":0.42654529213905334},{"id":"https://openalex.org/keywords/service","display_name":"Service (business)","score":0.4169561564922333},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.410357266664505},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.32436060905456543},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.28375059366226196},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2403830885887146},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2145194113254547},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11824849247932434}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8279680013656616},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6943739056587219},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.6266627311706543},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5902915000915527},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.5760173201560974},{"id":"https://openalex.org/C46934059","wikidata":"https://www.wikidata.org/wiki/Q61515","display_name":"Outsourcing","level":2,"score":0.5355935096740723},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.529249370098114},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4490264356136322},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4371485412120819},{"id":"https://openalex.org/C116537","wikidata":"https://www.wikidata.org/wiki/Q2169973","display_name":"Service provider","level":3,"score":0.42654529213905334},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.4169561564922333},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.410357266664505},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.32436060905456543},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.28375059366226196},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2403830885887146},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2145194113254547},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11824849247932434},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","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.1109/tkde.2019.2947061","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2947061","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.550000011920929}],"awards":[{"id":"https://openalex.org/G5638804971","display_name":"SaTC-EDU: EAGER: Development and Evaluation of Privacy Education Tools via Open Collaboration","funder_award_id":"1464800","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8317828012","display_name":"CAREER: Verifiable Outsourcing of Data Mining Computations","funder_award_id":"1350324","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":80,"referenced_works":["https://openalex.org/W4180724","https://openalex.org/W87886728","https://openalex.org/W168953860","https://openalex.org/W1261868982","https://openalex.org/W1486370790","https://openalex.org/W1516571257","https://openalex.org/W1557386445","https://openalex.org/W1566967335","https://openalex.org/W1582090474","https://openalex.org/W1589205472","https://openalex.org/W1605419955","https://openalex.org/W1639305476","https://openalex.org/W1784881995","https://openalex.org/W1788452017","https://openalex.org/W1802540854","https://openalex.org/W1970606468","https://openalex.org/W1971394347","https://openalex.org/W1975320294","https://openalex.org/W1996360405","https://openalex.org/W2005725110","https://openalex.org/W2010010507","https://openalex.org/W2012364626","https://openalex.org/W2018746447","https://openalex.org/W2028004854","https://openalex.org/W2028358228","https://openalex.org/W2028596773","https://openalex.org/W2031955931","https://openalex.org/W2035426245","https://openalex.org/W2037272013","https://openalex.org/W2043414352","https://openalex.org/W2043884223","https://openalex.org/W2047168811","https://openalex.org/W2049982182","https://openalex.org/W2052388228","https://openalex.org/W2057636642","https://openalex.org/W2061432607","https://openalex.org/W2071425575","https://openalex.org/W2071520502","https://openalex.org/W2075280979","https://openalex.org/W2081225688","https://openalex.org/W2085619203","https://openalex.org/W2086963441","https://openalex.org/W2096394084","https://openalex.org/W2096576767","https://openalex.org/W2103747520","https://openalex.org/W2106011067","https://openalex.org/W2108669353","https://openalex.org/W2109101900","https://openalex.org/W2109549608","https://openalex.org/W2138117958","https://openalex.org/W2141006951","https://openalex.org/W2141102961","https://openalex.org/W2145320861","https://openalex.org/W2149540210","https://openalex.org/W2165558283","https://openalex.org/W2166670067","https://openalex.org/W2171027248","https://openalex.org/W2197647726","https://openalex.org/W2209019814","https://openalex.org/W2280363695","https://openalex.org/W2286477783","https://openalex.org/W2341583189","https://openalex.org/W2404959941","https://openalex.org/W2405491124","https://openalex.org/W2504390753","https://openalex.org/W2578778878","https://openalex.org/W2676157184","https://openalex.org/W2756936471","https://openalex.org/W3031770538","https://openalex.org/W4206786309","https://openalex.org/W4232836212","https://openalex.org/W6603611529","https://openalex.org/W6628278045","https://openalex.org/W6633783865","https://openalex.org/W6634625017","https://openalex.org/W6638099327","https://openalex.org/W6638273893","https://openalex.org/W6638436873","https://openalex.org/W6658310657","https://openalex.org/W6744563959"],"related_works":["https://openalex.org/W2379847823","https://openalex.org/W2554271401","https://openalex.org/W2992414350","https://openalex.org/W2349238422","https://openalex.org/W1003283331","https://openalex.org/W2406556739","https://openalex.org/W2003701127","https://openalex.org/W2351171547","https://openalex.org/W4242370757","https://openalex.org/W1875678085"],"abstract_inverted_index":{"Spurred":[0],"by":[1,60],"the":[2,14,49,56,61,67,70,83,86,97,114],"development":[3],"of":[4,44,72,92,113],"cloud":[5],"computing,":[6],"there":[7],"has":[8],"been":[9],"considerable":[10],"recent":[11],"interest":[12],"in":[13,20,96],"Database-as-a-Service":[15],"(DaaS)":[16],"paradigm.":[17],"Users":[18],"lacking":[19],"expertise":[21],"or":[22],"computational":[23],"resources":[24],"can":[25,48],"outsource":[26],"their":[27],"data":[28],"and":[29,81],"database":[30],"management":[31],"needs":[32],"to":[33],"a":[34],"third-party":[35],"service":[36,62],"provider.":[37],"Outsourcing,":[38],"however,":[39],"raises":[40],"an":[41],"important":[42],"issue":[43],"result":[45,90,110],"integrity:":[46],"how":[47],"client":[50],"verify":[51],"with":[52],"lightweight":[53],"overhead":[54],"that":[55],"query":[57,73,94],"results":[58,71],"returned":[59],"provider":[63],"are":[64],"correct":[65],"(i.e.,":[66],"same":[68],"as":[69],"execution":[74],"locally)?":[75],"This":[76],"survey":[77,101],"focuses":[78],"on":[79,85],"categorizing":[80],"reviewing":[82],"progress":[84],"current":[87],"approaches":[88],"for":[89,109],"integrity":[91,111],"SQL":[93],"evaluation":[95],"DaaS":[98],"model.":[99],"The":[100],"also":[102],"includes":[103],"some":[104],"potential":[105],"future":[106],"research":[107],"directions":[108],"verification":[112],"outsourced":[115],"computations.":[116]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}