{"id":"https://openalex.org/W4292154173","doi":"https://doi.org/10.3217/jucs-015-03-0584","title":"Structural Coverage Criteria for Testing SQL Queries","display_name":"Structural Coverage Criteria for Testing SQL Queries","alternate_titles":[],"publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W4292154173","doi":"https://doi.org/10.3217/jucs-015-03-0584","mag":"2103881553"},"language":"en","primary_location":{"id":"mag:2103881553","doi":null,"is_oa":false,"landing_page_url":"http://www.jucs.org/jucs_15_3/structural_coverage_criteria_for/jucs_15_03_0584_0619_cabal.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S58563349","display_name":"JUCS - Journal of Universal Computer Science","issn_l":"0948-6968","issn":["0948-6968","0948-695X"],"is_oa":false,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-scientific","cwts-core","ddh","doaj","dongbi-d","jufo-1","norway-1","oarl","poland-40","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310317875","host_organization_name":"Verlag der Technischen Universit\u00e4t Graz","host_organization_lineage":["https://openalex.org/P4310317875"],"host_organization_lineage_names":["Verlag der Technischen Universit\u00e4t Graz"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"JUCS - Journal of Universal Computer Science","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W4292154173"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/10651/8124","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004612852","display_name":"Javier Tuya","orcid":"https://orcid.org/0000-0002-1091-934X","observed_orcids":["https://orcid.org/0000-0002-1091-934X"]},"institutions":[{"id":"https://openalex.org/I165339363","display_name":"Universidad de Oviedo","ror":"https://ror.org/006gksa02","country_code":"ES","type":"education","lineage":["https://openalex.org/I165339363"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Javier Tuya","raw_affiliation_strings":["University of Oviedo, Oviedo, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Oviedo, Oviedo, Spain","institution_ids":["https://openalex.org/I165339363"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011754991","display_name":"Mar\u00eda Jos\u00e9 Su\u00e1rez\u2010Cabal","orcid":"https://orcid.org/0000-0001-8262-2871","observed_orcids":["https://orcid.org/0000-0001-8262-2871"]},"institutions":[{"id":"https://openalex.org/I165339363","display_name":"Universidad de Oviedo","ror":"https://ror.org/006gksa02","country_code":"ES","type":"education","lineage":["https://openalex.org/I165339363"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"M. Jos\u00e9 Su\u00e1rez-Cabal","raw_affiliation_strings":["University of Oviedo, Oviedo, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Oviedo, Oviedo, Spain","institution_ids":["https://openalex.org/I165339363"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I165339363"],"apc_list":null,"apc_paid":null,"fwci":5.2905,"has_fulltext":true,"cited_by_count":25,"citation_normalized_percentile":{"value":0.94864079,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":96},"biblio":{"volume":"15","issue":null,"first_page":"584","last_page":"619"},"is_retracted":false,"is_pulled":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/T10317","display_name":"Advanced Database Systems and Queries","score":0.0,"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/T11032","display_name":"VLSI and Analog Circuit Testing","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/database-applications","display_name":"database applications","score":0.718999981880188},{"id":"https://openalex.org/keywords/test-adequacy","display_name":"test adequacy","score":0.6880000233650208},{"id":"https://openalex.org/keywords/test-suite-size","display_name":"test suite size","score":0.8550000190734863},{"id":"https://openalex.org/keywords/fault-detection","display_name":"fault detection","score":0.8109999895095825},{"id":"https://openalex.org/keywords/database-testing","display_name":"database testing","score":0.5509999990463257}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7174611687660217},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6272002458572388},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5785295367240906},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.48642969131469727},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.43233510851860046},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40039053559303284},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37040841579437256},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3234471082687378},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3031047582626343},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0921294093132019},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.06979513168334961}],"mesh":[],"locations_count":6,"locations":[{"id":"mag:2103881553","doi":null,"is_oa":false,"landing_page_url":"http://www.jucs.org/jucs_15_3/structural_coverage_criteria_for/jucs_15_03_0584_0619_cabal.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S58563349","display_name":"JUCS - Journal of Universal Computer Science","issn_l":"0948-6968","issn":["0948-6968","0948-695X"],"is_oa":false,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-scientific","cwts-core","ddh","doaj","dongbi-d","jufo-1","norway-1","oarl","poland-40","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310317875","host_organization_name":"Verlag der Technischen Universit\u00e4t Graz","host_organization_lineage":["https://openalex.org/P4310317875"],"host_organization_lineage_names":["Verlag der Technischen Universit\u00e4t Graz"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"JUCS - Journal of Universal Computer Science","raw_type":null},{"id":"pmh:oai:digibuo.uniovi.es:10651/8124","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/10651/8124","pdf_url":null,"source":{"id":"https://openalex.org/S7407122574","display_name":"Repositorio de la Universidad de Oviedo (RUO)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I165339363","host_organization_name":"Universidad de Oviedo","host_organization_lineage":["https://openalex.org/I165339363"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:zenodo.org:7000667","doi":null,"is_oa":true,"landing_page_url":"https://zenodo.org/record/7000667","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"JUCS - Journal of Universal Computer Science 15((3)) 584-619","raw_type":"info:eu-repo/semantics/article"},{"id":"doi:10.3217/jucs-015-03-0584","doi":"https://doi.org/10.3217/jucs-015-03-0584","is_oa":true,"landing_page_url":"https://doi.org/10.3217/jucs-015-03-0584","pdf_url":null,"source":{"id":"https://openalex.org/S4306400660","display_name":"TUGraz OPEN Library (Graz University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4092182","host_organization_name":"Graz University of Technology","host_organization_lineage":["https://openalex.org/I4092182"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"DataPaper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.150.8342","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.150.8342","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.jucs.org/jucs_15_3/structural_coverage_criteria_for/jucs_15_03_0584_0619_cabal.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.216.1676","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.216.1676","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.jucs.org/jucs_15_3/structural_coverage_criteria_for/jucs_15_03_0584_0619_cabal.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:digibuo.uniovi.es:10651/8124","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/10651/8124","pdf_url":null,"source":{"id":"https://openalex.org/S7407122574","display_name":"Repositorio de la Universidad de Oviedo (RUO)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I165339363","host_organization_name":"Universidad de Oviedo","host_organization_lineage":["https://openalex.org/I165339363"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320335322","display_name":"European Regional Development Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4292154173.pdf","grobid_xml":"https://content.openalex.org/works/W4292154173.grobid-xml"},"referenced_works_count":34,"referenced_works":["https://openalex.org/W7052981","https://openalex.org/W71027922","https://openalex.org/W1523736726","https://openalex.org/W1567503821","https://openalex.org/W1602107463","https://openalex.org/W1968915456","https://openalex.org/W1971827564","https://openalex.org/W1974858479","https://openalex.org/W1990391007","https://openalex.org/W2003638749","https://openalex.org/W2013711971","https://openalex.org/W2022274639","https://openalex.org/W2044009024","https://openalex.org/W2049695835","https://openalex.org/W2057128392","https://openalex.org/W2085621618","https://openalex.org/W2086783690","https://openalex.org/W2097452255","https://openalex.org/W2107531799","https://openalex.org/W2108557864","https://openalex.org/W2109322951","https://openalex.org/W2119021158","https://openalex.org/W2121084350","https://openalex.org/W2131467114","https://openalex.org/W2132516581","https://openalex.org/W2144378488","https://openalex.org/W2145542873","https://openalex.org/W2149255455","https://openalex.org/W2154897437","https://openalex.org/W2157913501","https://openalex.org/W2166463284","https://openalex.org/W2545480118","https://openalex.org/W4245310301","https://openalex.org/W4250799063"],"related_works":["https://openalex.org/W2023616316","https://openalex.org/W4239146630","https://openalex.org/W2919453305","https://openalex.org/W2157913501","https://openalex.org/W1971827564","https://openalex.org/W4241617507","https://openalex.org/W2126392066","https://openalex.org/W7100068915","https://openalex.org/W762694403","https://openalex.org/W2034204026"],"abstract_inverted_index":{"Abstract:":[0],"Adequacy":[1],"criteria":[2,12,39,90,116],"provide":[3],"an":[4],"objective":[5],"measurement":[6],"of":[7,30,46,111,124,134,140,149],"test":[8,48,122,151],"quality.":[9],"Although":[10],"these":[11],"are":[13,40,117,153],"a":[14,47,128,132],"major":[15],"research":[16],"issue":[17],"in":[18,65,82,101],"software":[19],"testing,":[20],"little":[21],"work":[22],"has":[23],"been":[24],"specifically":[25],"targeted":[26],"towards":[27],"the":[28,44,57,63,67,77,80,95,98,102,107,112,138,147,150],"testing":[29],"database-driven":[31],"applications.":[32],"In":[33],"this":[34],"paper,":[35],"two":[36],"structural":[37],"coverage":[38,115],"provided":[41],"for":[42,50],"evaluating":[43],"adequacy":[45],"suite":[49,152],"SQL":[51],"queries":[52,68,125],"that":[53,142],"retrieve":[54],"information":[55,72],"from":[56,73,127],"database.":[58],"The":[59,89,114],"first":[60],"deals":[61],"with":[62,79],"way":[64,81],"which":[66,83],"select":[69],"and":[70,76,97,109,146],"join":[71],"different":[74],"tables":[75],"second":[78],"selected":[84],"data":[85,99],"is":[86],"further":[87],"processed.":[88],"take":[91],"into":[92],"account":[93],"both":[94],"structure":[96],"loaded":[100],"database,":[103],"as":[104,106],"well":[105],"syntax":[108],"semantics":[110],"query.":[113],"subsequently":[118],"used":[119],"to":[120,137],"develop":[121],"inputs":[123],"drawn":[126],"real-life":[129],"application.":[130],"Finally,":[131],"number":[133],"issues":[135],"related":[136],"kind":[139],"faults":[141],"can":[143],"be":[144],"detected":[145],"size":[148],"discussed.":[154]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4292154173","counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2022-08-18T00:00:00"}
