{"id":"https://openalex.org/W3038801694","doi":"https://doi.org/10.1145/3391533","title":"Handling SQL Databases in Automated System Test Generation","display_name":"Handling SQL Databases in Automated System Test Generation","publication_year":2020,"publication_date":"2020-07-06","ids":{"openalex":"https://openalex.org/W3038801694","doi":"https://doi.org/10.1145/3391533","mag":"3038801694"},"language":"en","primary_location":{"id":"doi:10.1145/3391533","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3391533","pdf_url":null,"source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"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":"ACM Transactions on Software Engineering and Methodology","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/A5052735480","display_name":"Andrea Arcuri","orcid":"https://orcid.org/0000-0003-0799-2930"},"institutions":[{"id":"https://openalex.org/I2800207870","display_name":"H\u00f8yskolen Kristiania","ror":"https://ror.org/03gss5916","country_code":"NO","type":"education","lineage":["https://openalex.org/I2800207870"]}],"countries":["NO"],"is_corresponding":false,"raw_author_name":"Andrea Arcuri","raw_affiliation_strings":["Kristiania University College, Oslo, Norway"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Kristiania University College, Oslo, Norway","institution_ids":["https://openalex.org/I2800207870"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041433839","display_name":"Juan Pablo Galeotti","orcid":"https://orcid.org/0000-0002-0747-8205"},"institutions":[{"id":"https://openalex.org/I151201029","display_name":"Consejo Nacional de Investigaciones Cient\u00edficas y T\u00e9cnicas","ror":"https://ror.org/03cqe8w59","country_code":"AR","type":"government","lineage":["https://openalex.org/I151201029","https://openalex.org/I4210123736","https://openalex.org/I4387155568"]},{"id":"https://openalex.org/I4210144290","display_name":"Institute of Astronomy and Space Physics","ror":"https://ror.org/03rq94151","country_code":"AR","type":"facility","lineage":["https://openalex.org/I151201029","https://openalex.org/I24354313","https://openalex.org/I4210123736","https://openalex.org/I4210144290","https://openalex.org/I4387155568"]}],"countries":["AR"],"is_corresponding":false,"raw_author_name":"Juan P. Galeotti","raw_affiliation_strings":["Depto. de Computaci\u00f3n, FCEyN-UBA, and ICC, CONICET-UBA, Argentina"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Depto. de Computaci\u00f3n, FCEyN-UBA, and ICC, CONICET-UBA, Argentina","institution_ids":["https://openalex.org/I151201029","https://openalex.org/I4210144290"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.351,"has_fulltext":false,"cited_by_count":47,"citation_normalized_percentile":{"value":0.98002996,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"29","issue":"4","first_page":"1","last_page":"31"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10743","display_name":"Software Testing and Debugging Techniques","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.9987999796867371,"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"}},{"id":"https://openalex.org/T12423","display_name":"Software Reliability and Analysis Research","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.8464926481246948},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.687347412109375},{"id":"https://openalex.org/keywords/unit-testing","display_name":"Unit testing","score":0.5379152297973633},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5080304145812988},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.4805039167404175},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4528539776802063},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.4401790201663971},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.39673104882240295},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.36067354679107666},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2660623788833618}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8464926481246948},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.687347412109375},{"id":"https://openalex.org/C148027188","wikidata":"https://www.wikidata.org/wiki/Q907375","display_name":"Unit testing","level":3,"score":0.5379152297973633},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5080304145812988},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.4805039167404175},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4528539776802063},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.4401790201663971},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.39673104882240295},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.36067354679107666},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2660623788833618}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3391533","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3391533","pdf_url":null,"source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"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":"ACM Transactions on Software Engineering and Methodology","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.5400000214576721,"id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G8189079652","display_name":null,"funder_award_id":"20020170200249BA","funder_id":"https://openalex.org/F4320335478","funder_display_name":"Secretar\u00eda de Ciencia y T\u00e9cnica, Universidad de Buenos Aires"},{"id":"https://openalex.org/G8825638369","display_name":null,"funder_award_id":"274385","funder_id":"https://openalex.org/F4320323299","funder_display_name":"Norges Forskningsr\u00e5d"}],"funders":[{"id":"https://openalex.org/F4320323299","display_name":"Norges Forskningsr\u00e5d","ror":"https://ror.org/00epmv149"},{"id":"https://openalex.org/F4320335478","display_name":"Secretar\u00eda de Ciencia y T\u00e9cnica, Universidad de Buenos Aires","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W1526710119","https://openalex.org/W1572739102","https://openalex.org/W1836887430","https://openalex.org/W1848120755","https://openalex.org/W1977321274","https://openalex.org/W1993760289","https://openalex.org/W2011539648","https://openalex.org/W2022431239","https://openalex.org/W2075678045","https://openalex.org/W2101629181","https://openalex.org/W2107147876","https://openalex.org/W2110337982","https://openalex.org/W2127229029","https://openalex.org/W2266149187","https://openalex.org/W2270202525","https://openalex.org/W2293616642","https://openalex.org/W2295840463","https://openalex.org/W2586946380","https://openalex.org/W2740841986","https://openalex.org/W2790334838","https://openalex.org/W2804003629","https://openalex.org/W2957505323","https://openalex.org/W2997401484","https://openalex.org/W3004042307","https://openalex.org/W3004249941","https://openalex.org/W3007533873","https://openalex.org/W3106293840"],"related_works":["https://openalex.org/W2280422768","https://openalex.org/W3143197806","https://openalex.org/W4252555497","https://openalex.org/W3121175838","https://openalex.org/W3016293053","https://openalex.org/W2401723157","https://openalex.org/W2952904874","https://openalex.org/W4389302559","https://openalex.org/W1690653314","https://openalex.org/W2053033682"],"abstract_inverted_index":{"Automated":[0],"system":[1,181,207],"test":[2,140],"generation":[3,133],"for":[4,179],"web/enterprise":[5,72,117],"systems":[6,73],"requires":[7],"either":[8],"a":[9,14,78,108],"sequence":[10,157],"of":[11,41,53,90,116,125,134,158,200],"actions":[12],"on":[13,18,216],"GUI":[15],"(e.g.,":[16,33,55],"clicking":[17],"HTML":[19],"links":[20],"and":[21,35,49,84,184,222],"form":[22],"buttons)":[23],"or":[24,150],"direct":[25],"HTTP":[26],"calls":[27],"when":[28,99,145,172],"dealing":[29,173],"with":[30,77,174],"web":[31],"services":[32],"REST":[34],"SOAP).":[36],"When":[37],"doing":[38],"white-box":[39,101],"testing":[40,64,115],"such":[42],"systems,":[43,118],"their":[44],"code":[45],"can":[46,65],"be":[47,66,95],"analyzed,":[48],"the":[50,56,88,91,123,126,132,139,155,162,165,180,185,212],"same":[51],"type":[52],"heuristics":[54],"branch":[57],"distance":[58],")":[59],"used":[60],"in":[61,164,211,240],"search-based":[62,113],"unit":[63],"employed":[67],"to":[68,94,111,153,160,234],"improve":[69,230],"performance.":[70],"However,":[71],"do":[74],"often":[75],"interact":[76],"database.":[79],"To":[80],"obtain":[81],"higher":[82],"coverage":[83,231],"find":[85],"new":[86,238],"faults,":[87],"state":[89,124],"databases":[92,175],"needs":[93],"taken":[96],"into":[97,121],"account":[98,122],"generating":[100],"tests.":[102],"In":[103],"this":[104],"work,":[105],"we":[106,130],"present":[107],"novel":[109,228],"heuristic":[110],"enhance":[112],"software":[114],"which":[119],"takes":[120],"accessed":[127],"databases.":[128],"Furthermore,":[129],"enable":[131],"SQL":[135],"data":[136,187],"directly":[137],"from":[138],"cases.":[141],"This":[142],"is":[143,147,170],"useful":[144,171],"it":[146,169],"too":[148],"difficult":[149],"time":[151],"consuming":[152],"generate":[154],"right":[156,166],"events":[159],"put":[161],"database":[163],"state.":[167],"Also,":[168],"that":[176,226],"are":[177,188,209],"\u201cread-only\u201d":[178],"under":[182],"test,":[183],"actual":[186],"generated":[189,210],"by":[190],"other":[191],"services.":[192],"We":[193],"implemented":[194],"our":[195,227],"technique":[196],"as":[197],"an":[198],"extension":[199],"E":[201],"VO":[202],"M":[203],"ASTER":[204],",":[205],"where":[206],"tests":[208],"JUnit":[213],"format.":[214],"Experiments":[215],"six":[217],"RESTful":[218],"APIs":[219],"(five":[220],"open-source":[221],"one":[223],"industrial)":[224],"show":[225],"techniques":[229],"significantly":[232],"(up":[233],"+16.5%),":[235],"finding":[236],"seven":[237],"faults":[239],"those":[241],"systems.":[242]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":11},{"year":2022,"cited_by_count":9},{"year":2021,"cited_by_count":8}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}