{"id":"https://openalex.org/W2740841986","doi":"https://doi.org/10.1145/3180155.3180202","title":"Search-based test data generation for SQL queries","display_name":"Search-based test data generation for SQL queries","publication_year":2018,"publication_date":"2018-05-27","ids":{"openalex":"https://openalex.org/W2740841986","doi":"https://doi.org/10.1145/3180155.3180202","mag":"2740841986"},"language":"en","primary_location":{"id":"doi:10.1145/3180155.3180202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3180155.3180202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th International Conference on Software Engineering","raw_type":"proceedings-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/A5090440718","display_name":"Jeroen Castelein","orcid":null},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Jeroen Castelein","raw_affiliation_strings":["Delft University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033008187","display_name":"Maur\u00edcio Aniche","orcid":"https://orcid.org/0000-0002-8893-2835"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Maur\u00edcio Aniche","raw_affiliation_strings":["Delft University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071333993","display_name":"Mozhan Soltani","orcid":"https://orcid.org/0000-0003-2788-796X"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Mozhan Soltani","raw_affiliation_strings":["Delft University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067127346","display_name":"Annibale Panichella","orcid":"https://orcid.org/0000-0002-7395-3588"},"institutions":[{"id":"https://openalex.org/I186903577","display_name":"University of Luxembourg","ror":"https://ror.org/036x5ad56","country_code":"LU","type":"education","lineage":["https://openalex.org/I186903577"]}],"countries":["LU"],"is_corresponding":false,"raw_author_name":"Annibale Panichella","raw_affiliation_strings":["Delft University of Technology and Snt-University of Luxembourg"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Delft University of Technology and Snt-University of Luxembourg","institution_ids":["https://openalex.org/I186903577"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090401584","display_name":"Arie van Deursen","orcid":"https://orcid.org/0000-0003-4850-3312"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Arie van Deursen","raw_affiliation_strings":["Delft University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.0057,"has_fulltext":false,"cited_by_count":31,"citation_normalized_percentile":{"value":0.94325246,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"2018","issue":null,"first_page":"1220","last_page":"1230"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9998999834060669,"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":0.9998999834060669,"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/T10260","display_name":"Software Engineering Research","score":0.9936000108718872,"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/T12423","display_name":"Software Reliability and Analysis Research","score":0.987500011920929,"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.8789350390434265},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7661460041999817},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7050927877426147},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.6574743986129761},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.602851152420044},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5250874757766724},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5155172348022461},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4780576527118683},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.46416500210762024},{"id":"https://openalex.org/keywords/user-defined-function","display_name":"User-defined function","score":0.41411495208740234},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4114648699760437},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.40097108483314514},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3744656443595886},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.35251691937446594},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.28517305850982666},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.19829845428466797}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8789350390434265},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7661460041999817},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7050927877426147},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.6574743986129761},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.602851152420044},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5250874757766724},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5155172348022461},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4780576527118683},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.46416500210762024},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.41411495208740234},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4114648699760437},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40097108483314514},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3744656443595886},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.35251691937446594},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.28517305850982666},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.19829845428466797}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3180155.3180202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3180155.3180202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th International Conference on Software Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:tudelft.nl:uuid:3b7e2cc6-4810-44a9-a19a-3cc8a260d495","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:3b7e2cc6-4810-44a9-a19a-3cc8a260d495","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"master thesis"},{"id":"pmh:oai:tudelft.nl:uuid:90a6431f-f78f-4ac3-bf87-c052cd9cd5d4","is_oa":false,"landing_page_url":"http://resolver.tudelft.nl/uuid:90a6431f-f78f-4ac3-bf87-c052cd9cd5d4","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"},{"id":"mag:3036287583","is_oa":false,"landing_page_url":"https://jglobal.jst.go.jp/en/detail?JGLOBAL_ID=201902275527149055","pdf_url":null,"source":{"id":"https://openalex.org/S4306512817","display_name":"IEEE Conference Proceedings","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"IEEE Conference Proceedings","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W1526710119","https://openalex.org/W1553010236","https://openalex.org/W1565494300","https://openalex.org/W1568834902","https://openalex.org/W1599808047","https://openalex.org/W1674046048","https://openalex.org/W1971650562","https://openalex.org/W1993760289","https://openalex.org/W1995446447","https://openalex.org/W1999217744","https://openalex.org/W2014515160","https://openalex.org/W2017995536","https://openalex.org/W2022431239","https://openalex.org/W2043193943","https://openalex.org/W2060440626","https://openalex.org/W2063387237","https://openalex.org/W2097998348","https://openalex.org/W2098054810","https://openalex.org/W2101629181","https://openalex.org/W2103211721","https://openalex.org/W2113531724","https://openalex.org/W2114402335","https://openalex.org/W2114869486","https://openalex.org/W2114934447","https://openalex.org/W2125055259","https://openalex.org/W2144319429","https://openalex.org/W2147002252","https://openalex.org/W2156817734","https://openalex.org/W2171831739","https://openalex.org/W2266149187","https://openalex.org/W2295840463","https://openalex.org/W2519801052","https://openalex.org/W2586946380","https://openalex.org/W2588045990","https://openalex.org/W2740841986","https://openalex.org/W2741261446","https://openalex.org/W2998993395","https://openalex.org/W4230416342","https://openalex.org/W4253364378","https://openalex.org/W4285719527","https://openalex.org/W4388727850"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2607400785","https://openalex.org/W2406556739","https://openalex.org/W2240099544","https://openalex.org/W638381921","https://openalex.org/W2512476881","https://openalex.org/W2217632272","https://openalex.org/W3108275191","https://openalex.org/W1890845846","https://openalex.org/W2128834514"],"abstract_inverted_index":{"Database-centric":[0],"systems":[1],"strongly":[2],"rely":[3],"on":[4,160,179],"SQL":[5,14,44,52,134,145],"queries":[6,23,123,146,201,226],"to":[7,22,48,56,220],"manage":[8],"and":[9,29,71,81,127,154,166,208],"manipulate":[10],"their":[11],"data.":[12,111],"These":[13],"commands":[15],"can":[16,78],"range":[17],"from":[18,182,203,242],"very":[19],"simple":[20],"selections":[21],"that":[24,60,216],"involve":[25],"several":[26],"tables,":[27],"sub-queries,":[28],"grouping":[30],"operations.":[31],"And,":[32],"as":[33,96,119,147,191],"with":[34,102,124],"any":[35],"important":[36],"piece":[37],"of":[38,92,105,187,224],"code,":[39],"developers":[40,54],"should":[41],"properly":[42],"test":[43,50,58,94,141],"queries.":[45,85],"In":[46,136],"order":[47],"completely":[49,221],"a":[51,67,97,148,175,188,232],"query,":[53,68],"need":[55],"create":[57],"data":[59,95,142],"exercise":[61],"all":[62,225],"possible":[63],"coverage":[64],"targets":[65],"in":[66,133,172,199,227],"e.g.,":[69],"JOINs":[70],"WHERE":[72],"predicates.":[73],"And":[74],"indeed,":[75],"this":[76,137],"task":[77],"be":[79],"challenging":[80],"time-consuming":[82],"for":[83,122,144],"complex":[84],"Previous":[86],"studies":[87],"have":[88,115],"modeled":[89],"the":[90,103,109,183,228,243],"problem":[91,100],"generating":[93],"constraint":[98],"satisfaction":[99],"and,":[101],"help":[104],"SAT":[106],"solvers,":[107],"generate":[108],"required":[110],"However,":[112],"such":[113,118],"approaches":[114,158],"strong":[116],"limitations,":[117],"partial":[120],"support":[121],"JOINs,":[125],"subqueries,":[126],"strings":[128],"(which":[129],"are":[130],"commonly":[131],"used":[132],"queries).":[135],"paper,":[138],"we":[139,152],"model":[140],"generation":[143],"search-based":[149],"problem.":[150],"Then,":[151],"devise":[153],"evaluate":[155,196],"three":[156,204],"different":[157],"based":[159,178],"random":[161,164],"search,":[162,165],"biased":[163],"genetic":[167],"algorithms":[168],"(GAs).":[169],"The":[170],"GA,":[171],"particular,":[173],"uses":[174],"fitness":[176],"function":[177],"information":[180],"extracted":[181,202],"physical":[184],"query":[185],"plan":[186],"database":[189],"engine":[190],"search":[192],"guidance.":[193],"We":[194],"then":[195],"each":[197],"approach":[198],"2,135":[200],"open":[205],"source":[206],"software":[207,211],"one":[209],"industrial":[210],"system.":[212],"Our":[213],"results":[214],"show":[215],"GA":[217],"is":[218],"able":[219],"cover":[222],"98.6%":[223],"dataset,":[229],"requiring":[230],"only":[231],"few":[233],"seconds":[234],"per":[235],"query.":[236],"Moreover,":[237],"it":[238],"does":[239],"not":[240],"suffer":[241],"limitations":[244],"affecting":[245],"state-of-the":[246],"art":[247],"techniques.":[248]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}