{"id":"https://openalex.org/W2001808951","doi":"https://doi.org/10.1145/1951365.1951441","title":"True language-level SQL debugging","display_name":"True language-level SQL debugging","publication_year":2011,"publication_date":"2011-03-21","ids":{"openalex":"https://openalex.org/W2001808951","doi":"https://doi.org/10.1145/1951365.1951441","mag":"2001808951"},"language":"en","primary_location":{"id":"doi:10.1145/1951365.1951441","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1951365.1951441","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th International Conference on Extending Database Technology","raw_type":"proceedings-article"},"type":"conference-paper","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/A5088806837","display_name":"Torsten Grust","orcid":"https://orcid.org/0000-0002-8279-0493"},"institutions":[{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Torsten Grust","raw_affiliation_strings":["WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany","institution_ids":["https://openalex.org/I8087733"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067643828","display_name":"Fabian Kliebhan","orcid":null},"institutions":[{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Fabian Kliebhan","raw_affiliation_strings":["WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany","institution_ids":["https://openalex.org/I8087733"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039369697","display_name":"Jan Rittinger","orcid":null},"institutions":[{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Jan Rittinger","raw_affiliation_strings":["WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany","institution_ids":["https://openalex.org/I8087733"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071167002","display_name":"Tom Schreiber","orcid":null},"institutions":[{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Tom Schreiber","raw_affiliation_strings":["WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"WSI, Universit\u00e4t T\u00fcbingen, T\u00fcbingen, Germany","institution_ids":["https://openalex.org/I8087733"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I8087733"],"apc_list":null,"apc_paid":null,"fwci":1.1441,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.74693406,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"562","last_page":"565"},"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.9986000061035156,"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.9986000061035156,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9972000122070312,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9926000237464905,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8375736474990845},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.8097496628761292},{"id":"https://openalex.org/keywords/debugger","display_name":"Debugger","score":0.7769845724105835},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.7715007066726685},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7368173003196716},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.6524848937988281},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.45353177189826965},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.42748984694480896},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.4264333248138428},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.4167461097240448},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.27430713176727295},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.19569674134254456},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.08293724060058594}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8375736474990845},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.8097496628761292},{"id":"https://openalex.org/C2778485113","wikidata":"https://www.wikidata.org/wiki/Q193231","display_name":"Debugger","level":3,"score":0.7769845724105835},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7715007066726685},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7368173003196716},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6524848937988281},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.45353177189826965},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.42748984694480896},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.4264333248138428},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4167461097240448},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27430713176727295},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.19569674134254456},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.08293724060058594},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1951365.1951441","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1951365.1951441","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 14th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.204.6033","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.204.6033","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.informatik.uni-tuebingen.de/files/publications/sql-debugging.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.428.8304","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.428.8304","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2011-Uppsala/papers/edbt/a58-grust.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/15","display_name":"Life in Land"}],"awards":[{"id":"https://openalex.org/G805801513","display_name":null,"funder_award_id":"GR2036/3-1","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"}],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1964770056","https://openalex.org/W2008116177","https://openalex.org/W2141575847","https://openalex.org/W2148941801","https://openalex.org/W2164636932","https://openalex.org/W2165674271","https://openalex.org/W4211008735","https://openalex.org/W6641390829","https://openalex.org/W6680987061"],"related_works":["https://openalex.org/W2379897365","https://openalex.org/W151073879","https://openalex.org/W2336094686","https://openalex.org/W1980548249","https://openalex.org/W2463360381","https://openalex.org/W2791515211","https://openalex.org/W1890767558","https://openalex.org/W2803214644","https://openalex.org/W2359391484","https://openalex.org/W1970548936"],"abstract_inverted_index":{"We":[0],"demonstrate":[1],"Habitat,":[2],"a":[3],"declarative":[4],"observational":[5],"debugger":[6],"for":[7],"SQL.":[8],"Habitat":[9],"facilitates":[10],"true":[11],"language-level":[12],"(not:":[13],"plan-level)":[14],"debugging":[15],"of,":[16],"probably":[17],"flawed,":[18],"SQL":[19,29],"queries":[20],"that":[21],"yield":[22],"unexpected":[23],"results.":[24],"Users":[25],"may":[26],"mark":[27],"arbitrary":[28],"subexpressions---ranging":[30],"from":[31],"literals,":[32],"over":[33],"fragments":[34],"of":[35],"predicates,":[36],"to":[37],"entire":[38],"subquery":[39],"blocks---to":[40],"observe":[41],"whether":[42],"these":[43],"evaluate":[44],"as":[45],"expected.":[46]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":4},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}