{"id":"https://openalex.org/W4323365709","doi":"https://doi.org/10.1142/s0218194023500109","title":"SQL#: A Language for Maintainable and Debuggable Database Queries","display_name":"SQL#: A Language for Maintainable and Debuggable Database Queries","publication_year":2023,"publication_date":"2023-03-07","ids":{"openalex":"https://openalex.org/W4323365709","doi":"https://doi.org/10.1142/s0218194023500109"},"language":"en","primary_location":{"id":"doi:10.1142/s0218194023500109","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1142/s0218194023500109","pdf_url":null,"source":{"id":"https://openalex.org/S131442419","display_name":"International Journal of Software Engineering and Knowledge Engineering","issn_l":"0218-1940","issn":["0218-1940","1793-6403"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Engineering and Knowledge 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/A5084244959","display_name":"Yamin Hu","orcid":"https://orcid.org/0000-0002-6077-8709"},"institutions":[{"id":"https://openalex.org/I125839683","display_name":"Beijing Institute of Technology","ror":"https://ror.org/01skt4w74","country_code":"CN","type":"education","lineage":["https://openalex.org/I125839683","https://openalex.org/I890469752"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yamin Hu","raw_affiliation_strings":["School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China","institution_ids":["https://openalex.org/I125839683"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100729484","display_name":"Hao Jiang","orcid":"https://orcid.org/0000-0002-0270-5165"},"institutions":[{"id":"https://openalex.org/I143868143","display_name":"Anhui University","ror":"https://ror.org/05th6yx34","country_code":"CN","type":"education","lineage":["https://openalex.org/I143868143"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hao Jiang","raw_affiliation_strings":["School of Artificial Intelligence, Anhui University, Hefei 230601, P.\u00a0R.\u00a0China"],"affiliations":[{"raw_affiliation_string":"School of Artificial Intelligence, Anhui University, Hefei 230601, P.\u00a0R.\u00a0China","institution_ids":["https://openalex.org/I143868143"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089829380","display_name":"Hanlin Tang","orcid":"https://orcid.org/0000-0003-0306-1637"},"institutions":[{"id":"https://openalex.org/I125839683","display_name":"Beijing Institute of Technology","ror":"https://ror.org/01skt4w74","country_code":"CN","type":"education","lineage":["https://openalex.org/I125839683","https://openalex.org/I890469752"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hanlin Tang","raw_affiliation_strings":["School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China","institution_ids":["https://openalex.org/I125839683"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101529805","display_name":"Xin Lin","orcid":"https://orcid.org/0000-0002-7491-8928"},"institutions":[{"id":"https://openalex.org/I200845125","display_name":"Nanjing University of Information Science and Technology","ror":"https://ror.org/02y0rxk19","country_code":"CN","type":"education","lineage":["https://openalex.org/I200845125"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xin Lin","raw_affiliation_strings":["School of Artificial Intelligence/School of Future Technology, Nanjing University of Information Science and Technology, Nanjing 210044, P.\u00a0R.\u00a0China"],"affiliations":[{"raw_affiliation_string":"School of Artificial Intelligence/School of Future Technology, Nanjing University of Information Science and Technology, Nanjing 210044, P.\u00a0R.\u00a0China","institution_ids":["https://openalex.org/I200845125"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063539409","display_name":"Zongyao Hu","orcid":"https://orcid.org/0000-0001-7095-3905"},"institutions":[{"id":"https://openalex.org/I125839683","display_name":"Beijing Institute of Technology","ror":"https://ror.org/01skt4w74","country_code":"CN","type":"education","lineage":["https://openalex.org/I125839683","https://openalex.org/I890469752"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zongyao Hu","raw_affiliation_strings":["School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Beijing Institute of Technology, Beijing 100081, P.\u00a0R.\u00a0China","institution_ids":["https://openalex.org/I125839683"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5084244959"],"corresponding_institution_ids":["https://openalex.org/I125839683"],"apc_list":null,"apc_paid":null,"fwci":0.4018,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.57987666,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"33","issue":"05","first_page":"619","last_page":"649"},"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.9995999932289124,"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.9995999932289124,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9972000122070312,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.996999979019165,"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.8747071027755737},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.7748540043830872},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.7719724178314209},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.7471409440040588},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7354242205619812},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.7152709364891052},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6121147274971008},{"id":"https://openalex.org/keywords/autocommit","display_name":"Autocommit","score":0.5727241635322571},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.5469115972518921},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.545803964138031},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5388142466545105},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.5243221521377563},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.5166735649108887},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.448527455329895},{"id":"https://openalex.org/keywords/user-defined-function","display_name":"User-defined function","score":0.4250003397464752},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4123817980289459},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29974156618118286},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.11251199245452881}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8747071027755737},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7748540043830872},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7719724178314209},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7471409440040588},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7354242205619812},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7152709364891052},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6121147274971008},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.5727241635322571},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.5469115972518921},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.545803964138031},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5388142466545105},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5243221521377563},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5166735649108887},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.448527455329895},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.4250003397464752},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4123817980289459},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29974156618118286},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.11251199245452881},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1142/s0218194023500109","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1142/s0218194023500109","pdf_url":null,"source":{"id":"https://openalex.org/S131442419","display_name":"International Journal of Software Engineering and Knowledge Engineering","issn_l":"0218-1940","issn":["0218-1940","1793-6403"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Engineering and Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.7699999809265137}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W1964770056","https://openalex.org/W2001808951","https://openalex.org/W2013861609","https://openalex.org/W2040811166","https://openalex.org/W2133731789","https://openalex.org/W2137022750","https://openalex.org/W2157564610","https://openalex.org/W2541443726","https://openalex.org/W2810302553","https://openalex.org/W2904500626","https://openalex.org/W2943832735","https://openalex.org/W2944391422","https://openalex.org/W2945102109","https://openalex.org/W2963426888","https://openalex.org/W3086891830","https://openalex.org/W3153343958","https://openalex.org/W4205381461","https://openalex.org/W4252628039","https://openalex.org/W4310364079"],"related_works":["https://openalex.org/W2750425440","https://openalex.org/W1890845846","https://openalex.org/W1432037690","https://openalex.org/W2240099544","https://openalex.org/W1520902996","https://openalex.org/W4386768611","https://openalex.org/W2912795851","https://openalex.org/W2282090486","https://openalex.org/W2376524225","https://openalex.org/W1510725189"],"abstract_inverted_index":{"Structured":[0],"Query":[1],"Language":[2],"(SQL)":[3],"is":[4],"the":[5,24,54,61,76,82,97,104,115,119,122,128,143,151,155,159,166,170],"dominant":[6],"language":[7,38],"for":[8,150],"managing":[9],"relational":[10],"databases.":[11],"However,":[12],"complex":[13,46,139],"SQL":[14,186],"queries":[15,47,177],"are":[16],"hard":[17],"to":[18,44,60,74,127,153,184],"write":[19],"and":[20,27,51,103,158,174,180],"maintain":[21],"because":[22],"of":[23,64,78,100,121,131,145,172],"intricate":[25,105],"inter-table":[26],"inter-column":[28],"relations.":[29],"To":[30],"this":[31],"end,":[32],"we":[33,68],"propose":[34],"a":[35,70,85,89],"novel":[36],"query":[37],"called":[39],"SQL#,":[40],"which":[41,92,134],"allows":[42],"programmers":[43,95,137],"construct":[45],"module":[48,50],"by":[49,178],"explicitly":[52],"specify":[53],"relations":[55,106],"between":[56,107],"different":[57,108],"modules":[58],"according":[59],"logical":[62,129],"steps":[63,130],"constructing":[65,132],"queries.":[66,80,141],"Besides,":[67],"design":[69,144],"SQL#-based":[71,167],"system,":[72],"aiming":[73],"facilitate":[75],"maintenance":[77],"SQL#":[79,86,101,111,140,146],"Specifically,":[81],"system":[83,116,152,168],"renders":[84],"program":[87],"into":[88],"hierarchical":[90,156],"graph,":[91],"could":[93,135],"help":[94,136],"understand":[96],"high-level":[98],"structures":[99],"programs":[102],"components":[109],"within":[110],"programs.":[112],"In":[113],"addition,":[114],"can":[117],"ease":[118],"generation":[120],"intermediate":[123,160],"tables":[124],"that":[125,165],"correspond":[126],"queries,":[133],"debug":[138],"Notably,":[142],"makes":[147],"it":[148],"easy":[149],"generate":[154],"graph":[157],"tables.":[161],"Controlled":[162],"experiments":[163],"suggest":[164],"reduces":[169],"durations":[171],"writing":[173],"understanding":[175],"database":[176],"79%":[179],"39%,":[181],"respectively,":[182],"compared":[183],"raw":[185],"code.":[187]},"counts_by_year":[{"year":2024,"cited_by_count":2}],"updated_date":"2025-12-24T23:09:58.560324","created_date":"2025-10-10T00:00:00"}