{"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","publication_year":2020,"publication_date":"2020-04-07","ids":{"openalex":"https://openalex.org/W4292154173","doi":"https://doi.org/10.3217/jucs-015-03-0584"},"language":"en","primary_location":{"id":"pmh:oai:digibuo.uniovi.es:10651/8124","is_oa":true,"landing_page_url":"http://hdl.handle.net/10651/8124","pdf_url":"http://hdl.handle.net/10651/8124","source":{"id":"https://openalex.org/S4306402334","display_name":"Consultation of the Doctoral Thesis Database (TESEO) (Ministerio de Educaci\u00f3n, Cultura y Deporte)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801976130","host_organization_name":"Ministerio de Educaci\u00f3n Cultura y Deporte","host_organization_lineage":["https://openalex.org/I2801976130"],"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"},"type":"article","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"},"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"},"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":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.36635104,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9919000267982483,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9919000267982483,"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/T11719","display_name":"Data Quality and Management","score":0.9782999753952026,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9721999764442444,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision 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.7174611687660217},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6272002458572388},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5785295367240906},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.48642969131469727},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.43233510851860046},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40039053559303284},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37040841579437256},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.3234471082687378},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3031047582626343},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.0921294093132019},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.06979513168334961}],"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":3,"locations":[{"id":"pmh:oai:digibuo.uniovi.es:10651/8124","is_oa":true,"landing_page_url":"http://hdl.handle.net/10651/8124","pdf_url":"http://hdl.handle.net/10651/8124","source":{"id":"https://openalex.org/S4306402334","display_name":"Consultation of the Doctoral Thesis Database (TESEO) (Ministerio de Educaci\u00f3n, Cultura y Deporte)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801976130","host_organization_name":"Ministerio de Educaci\u00f3n Cultura y Deporte","host_organization_lineage":["https://openalex.org/I2801976130"],"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","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,"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","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,"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":null,"raw_source_name":null,"raw_type":"DataPaper"}],"best_oa_location":{"id":"pmh:oai:digibuo.uniovi.es:10651/8124","is_oa":true,"landing_page_url":"http://hdl.handle.net/10651/8124","pdf_url":"http://hdl.handle.net/10651/8124","source":{"id":"https://openalex.org/S4306402334","display_name":"Consultation of the Doctoral Thesis Database (TESEO) (Ministerio de Educaci\u00f3n, Cultura y Deporte)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801976130","host_organization_name":"Ministerio de Educaci\u00f3n Cultura y Deporte","host_organization_lineage":["https://openalex.org/I2801976130"],"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":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320335322","display_name":"European Regional Development Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4292154173.pdf","grobid_xml":"https://content.openalex.org/works/W4292154173.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W2614112517","https://openalex.org/W2340883001","https://openalex.org/W4318225407","https://openalex.org/W2348171219","https://openalex.org/W4366683866","https://openalex.org/W2361335440","https://openalex.org/W650213220","https://openalex.org/W20807724","https://openalex.org/W2184401408"],"abstract_inverted_index":{"Adequacy":[0],"criteria":[1,11,38,89,115],"provide":[2],"an":[3],"objective":[4],"measurement":[5],"of":[6,29,45,110,123,133,139,148],"test":[7,47,121,150],"quality.":[8],"Although":[9],"these":[10],"are":[12,39,116,152],"a":[13,46,127,131],"major":[14],"research":[15],"issue":[16],"in":[17,64,81,100],"software":[18],"testing,":[19],"little":[20],"work":[21],"has":[22],"been":[23],"specifically":[24],"targeted":[25],"towards":[26],"the":[27,43,56,62,66,76,79,94,97,101,106,111,137,146,149],"testing":[28],"database-driven":[30],"applications.":[31],"In":[32],"this":[33],"paper,":[34],"two":[35],"structural":[36],"coverage":[37,114],"provided":[40],"for":[41,49],"evaluating":[42],"adequacy":[44],"suite":[48,151],"SQL":[50],"queries":[51,67,124],"that":[52,141],"retrieve":[53],"information":[54,71],"from":[55,72,126],"database.":[57],"The":[58,88,113],"first":[59],"deals":[60],"with":[61,78],"way":[63,80],"which":[65,82],"select":[68],"and":[69,75,96,108,145],"join":[70],"different":[73],"tables":[74],"second":[77],"selected":[83],"data":[84,98],"is":[85],"further":[86],"processed.":[87],"take":[90],"into":[91],"account":[92],"both":[93],"structure":[95],"loaded":[99],"database,":[102],"as":[103,105],"well":[104],"syntax":[107],"semantics":[109],"query.":[112],"subsequently":[117],"used":[118],"to":[119,136],"develop":[120],"inputs":[122],"drawn":[125],"real-life":[128],"application.":[129],"Finally,":[130],"number":[132],"issues":[134],"related":[135],"kind":[138],"faults":[140],"can":[142],"be":[143],"detected":[144],"size":[147],"discussed":[153]},"counts_by_year":[],"updated_date":"2026-08-31T07:19:18.363097","created_date":"2025-10-10T00:00:00"}