{"id":"https://openalex.org/W2007397391","doi":"https://doi.org/10.1145/2500365.2500586","title":"A practical theory of language-integrated query","display_name":"A practical theory of language-integrated query","publication_year":2013,"publication_date":"2013-09-25","ids":{"openalex":"https://openalex.org/W2007397391","doi":"https://doi.org/10.1145/2500365.2500586","mag":"2007397391"},"language":"en","primary_location":{"id":"doi:10.1145/2500365.2500586","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2500365.2500586","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM SIGPLAN international conference on Functional programming","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.research.ed.ac.uk/files/18383912/Cheney_Lindley_ET_AL_2013_A_practical_theory_of_language_integrated_query.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5056138547","display_name":"James Cheney","orcid":"https://orcid.org/0000-0002-1307-9286"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"James Cheney","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom","University of Edinburgh, edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]},{"raw_affiliation_string":"University of Edinburgh, edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061903791","display_name":"Sam Lindley","orcid":"https://orcid.org/0000-0002-1360-4714"},"institutions":[{"id":"https://openalex.org/I181647926","display_name":"University of Strathclyde","ror":"https://ror.org/00n3w3b69","country_code":"GB","type":"education","lineage":["https://openalex.org/I181647926"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Sam Lindley","raw_affiliation_strings":["University of Strathclyde, Glasgow, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Strathclyde, Glasgow, United Kingdom","institution_ids":["https://openalex.org/I181647926"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018878077","display_name":"Philip Wadler","orcid":"https://orcid.org/0000-0001-7619-6378"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Philip Wadler","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom","University of Edinburgh, edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]},{"raw_affiliation_string":"University of Edinburgh, edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5056138547"],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":15.8347,"has_fulltext":true,"cited_by_count":80,"citation_normalized_percentile":{"value":0.9916912,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"403","last_page":"416"},"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.9997000098228455,"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.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9940000176429749,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.9255281686782837},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8550590872764587},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.7422577142715454},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.7385536432266235},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6609312891960144},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.653037428855896},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6393964290618896},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5268099308013916},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.5228767395019531},{"id":"https://openalex.org/keywords/object-query-language","display_name":"Object Query Language","score":0.522422730922699},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4951447546482086},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.4340147376060486},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4172496795654297},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.40349867939949036},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3746859133243561},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3531118631362915},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32271629571914673},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.31630557775497437},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08528187870979309}],"concepts":[{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.9255281686782837},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8550590872764587},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.7422577142715454},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7385536432266235},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6609312891960144},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.653037428855896},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6393964290618896},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5268099308013916},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5228767395019531},{"id":"https://openalex.org/C117667704","wikidata":"https://www.wikidata.org/wiki/Q2011708","display_name":"Object Query Language","level":5,"score":0.522422730922699},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4951447546482086},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.4340147376060486},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4172496795654297},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.40349867939949036},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3746859133243561},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3531118631362915},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32271629571914673},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31630557775497437},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08528187870979309},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/2500365.2500586","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2500365.2500586","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM SIGPLAN international conference on Functional programming","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/c19bc072-653e-45bc-948f-1517fe7ed0e1","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/c19bc072-653e-45bc-948f-1517fe7ed0e1","pdf_url":"https://www.research.ed.ac.uk/files/18383912/Cheney_Lindley_ET_AL_2013_A_practical_theory_of_language_integrated_query.pdf","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cheney, J, Lindley, S & Wadler, P 2013, A Practical Theory of Language-integrated Query. in Proceedings of the 18th ACM SIGPLAN International Conference on Functional Programming. ICFP '13, New York, NY, USA, pp. 403-416. https://doi.org/10.1145/2500365.2500586","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:pure.ed.ac.uk:publications/c19bc072-653e-45bc-948f-1517fe7ed0e1","is_oa":true,"landing_page_url":null,"pdf_url":"https://www.research.ed.ac.uk/en/publications/c19bc072-653e-45bc-948f-1517fe7ed0e1","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.363.4332","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.363.4332","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://homepages.inf.ed.ac.uk/jcheney/publications/cheney13icfp.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:pure.ed.ac.uk:openaire/c19bc072-653e-45bc-948f-1517fe7ed0e1","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/c19bc072-653e-45bc-948f-1517fe7ed0e1","pdf_url":"https://www.research.ed.ac.uk/files/18383912/Cheney_Lindley_ET_AL_2013_A_practical_theory_of_language_integrated_query.pdf","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cheney, J, Lindley, S & Wadler, P 2013, A Practical Theory of Language-integrated Query. in Proceedings of the 18th ACM SIGPLAN International Conference on Functional Programming. ICFP '13, New York, NY, USA, pp. 403-416. https://doi.org/10.1145/2500365.2500586","raw_type":"contributionToPeriodical"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.6200000047683716,"display_name":"Quality Education"}],"awards":[{"id":"https://openalex.org/G1361938442","display_name":null,"funder_award_id":"Fellowship","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G1798638720","display_name":"From Data Types to Session Types---A Basis for Concurrency and Distribution","funder_award_id":"EP/K034413/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G6309358733","display_name":"Haskell Types with Added Value","funder_award_id":"EP/J014591/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G7918631928","display_name":null,"funder_award_id":"EP/K034413/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8131733557","display_name":null,"funder_award_id":"EP/J014591/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2007397391.pdf","grobid_xml":"https://content.openalex.org/works/W2007397391.grobid-xml"},"referenced_works_count":47,"referenced_works":["https://openalex.org/W46396489","https://openalex.org/W1488538795","https://openalex.org/W1493222705","https://openalex.org/W1513902353","https://openalex.org/W1522042692","https://openalex.org/W1556345310","https://openalex.org/W1598796492","https://openalex.org/W1784187793","https://openalex.org/W1827112781","https://openalex.org/W1969621165","https://openalex.org/W1977101058","https://openalex.org/W1981860171","https://openalex.org/W1985954365","https://openalex.org/W1994813568","https://openalex.org/W1996060755","https://openalex.org/W2005318605","https://openalex.org/W2007397391","https://openalex.org/W2025969711","https://openalex.org/W2029408547","https://openalex.org/W2047497632","https://openalex.org/W2078380329","https://openalex.org/W2088675571","https://openalex.org/W2090395143","https://openalex.org/W2094455839","https://openalex.org/W2104200012","https://openalex.org/W2112866468","https://openalex.org/W2118384863","https://openalex.org/W2118578267","https://openalex.org/W2121209363","https://openalex.org/W2131012971","https://openalex.org/W2132028142","https://openalex.org/W2136327713","https://openalex.org/W2137924956","https://openalex.org/W2147578933","https://openalex.org/W2170812622","https://openalex.org/W2174554963","https://openalex.org/W2179271410","https://openalex.org/W2339920159","https://openalex.org/W2553990570","https://openalex.org/W2763767150","https://openalex.org/W2998952999","https://openalex.org/W3098197594","https://openalex.org/W4248334436","https://openalex.org/W4254805745","https://openalex.org/W6629110257","https://openalex.org/W6629613022","https://openalex.org/W6642571637"],"related_works":["https://openalex.org/W2369494928","https://openalex.org/W2607400785","https://openalex.org/W1003283331","https://openalex.org/W2361332868","https://openalex.org/W2897196530","https://openalex.org/W1984116761","https://openalex.org/W2128834514","https://openalex.org/W2032308519","https://openalex.org/W1448465239","https://openalex.org/W2569286692"],"abstract_inverted_index":{"Language-integrated":[0],"query":[1,23,72,102],"is":[2,73],"receiving":[3],"renewed":[4],"attention,":[5],"in":[6,90,104],"part":[7],"because":[8],"of":[9,21,29,43,47,110],"its":[10],"support":[11],"through":[12],"Microsoft\u2019s":[13,93],"LINQ":[14,94],"framework.":[15],"We":[16,64,81],"present":[17,82],"a":[18,66,70,77],"practical":[19],"theory":[20],"language-integrated":[22],"based":[24],"on":[25],"quotation":[26],"and":[27,40,49],"normalisation":[28],"quoted":[30],"terms.":[31],"Our":[32],"technique":[33,87],"supports":[34],"join":[35],"queries,":[36,44,48],"abstraction":[37],"over":[38],"values":[39],"predicates,":[41],"composition":[42],"dynamic":[45],"generation":[46],"queries":[50],"with":[51],"nested":[52],"intermediate":[53],"data.":[54],"Higher-order":[55],"features":[56],"prove":[57,65],"useful":[58],"even":[59,89],"for":[60],"constructing":[61],"first-order":[62],"queries.":[63,112],"theorem":[67],"characterising":[68],"when":[69],"host":[71],"guaranteed":[74],"to":[75,98],"generate":[76],"single":[78],"SQL":[79,101,111],"query.":[80],"experimental":[83],"results":[84],"confirming":[85],"our":[86],"works,":[88],"situations":[91],"where":[92],"framework":[95],"either":[96],"fails":[97],"produce":[99],"an":[100,108],"or,":[103],"one":[105],"case,":[106],"produces":[107],"avalanche":[109]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":9},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":13},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":15},{"year":2013,"cited_by_count":5}],"updated_date":"2026-04-17T18:11:37.981687","created_date":"2025-10-10T00:00:00"}