{"id":"https://openalex.org/W2112160987","doi":"https://doi.org/10.1017/s0960129513000479","title":"Database queries and constraints via lifting problems","display_name":"Database queries and constraints via lifting problems","publication_year":2013,"publication_date":"2013-10-11","ids":{"openalex":"https://openalex.org/W2112160987","doi":"https://doi.org/10.1017/s0960129513000479","mag":"2112160987"},"language":"en","primary_location":{"id":"doi:10.1017/s0960129513000479","is_oa":false,"landing_page_url":"https://doi.org/10.1017/s0960129513000479","pdf_url":null,"source":{"id":"https://openalex.org/S101766102","display_name":"Mathematical Structures in Computer Science","issn_l":"0960-1295","issn":["0960-1295","1469-8072"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311721","host_organization_name":"Cambridge University Press","host_organization_lineage":["https://openalex.org/P4310311721","https://openalex.org/P4310311702"],"host_organization_lineage_names":["Cambridge University Press","University of Cambridge"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Mathematical Structures in Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1202.2591","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"DAVID I. SPIVAK","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"DAVID I. SPIVAK","raw_affiliation_strings":["Department of Mathematics, Massachusetts Institute of Technology, Cambridge, MA 02139, United States of America Email:"],"affiliations":[{"raw_affiliation_string":"Department of Mathematics, Massachusetts Institute of Technology, Cambridge, MA 02139, United States of America Email:","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":0.9963,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.83371613,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"24","issue":"6","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.5315999984741211,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.5315999984741211,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.2669000029563904,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.05620000138878822,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/sparql","display_name":"SPARQL","score":0.7145000100135803},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.612500011920929},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5508999824523926},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5015000104904175},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4675000011920929},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.45500001311302185},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.43959999084472656},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.37929999828338623}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8136000037193298},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.7145000100135803},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.612500011920929},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5508999824523926},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5015000104904175},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4893999993801117},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4675000011920929},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.45500001311302185},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.43959999084472656},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40560001134872437},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39910000562667847},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.37929999828338623},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.37720000743865967},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.3718999922275543},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.36959999799728394},{"id":"https://openalex.org/C9376300","wikidata":"https://www.wikidata.org/wiki/Q168817","display_name":"Algebraic number","level":2,"score":0.3352999985218048},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.32420000433921814},{"id":"https://openalex.org/C2989065042","wikidata":"https://www.wikidata.org/wiki/Q7378971","display_name":"Algebraic properties","level":2,"score":0.2847999930381775},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.28200000524520874},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.2782999873161316},{"id":"https://openalex.org/C2987255567","wikidata":"https://www.wikidata.org/wiki/Q33002955","display_name":"Knowledge graph","level":2,"score":0.25769999623298645},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.2524999976158142}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1017/s0960129513000479","is_oa":false,"landing_page_url":"https://doi.org/10.1017/s0960129513000479","pdf_url":null,"source":{"id":"https://openalex.org/S101766102","display_name":"Mathematical Structures in Computer Science","issn_l":"0960-1295","issn":["0960-1295","1469-8072"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311721","host_organization_name":"Cambridge University Press","host_organization_lineage":["https://openalex.org/P4310311721","https://openalex.org/P4310311702"],"host_organization_lineage_names":["Cambridge University Press","University of Cambridge"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Mathematical Structures in Computer Science","raw_type":"journal-article"},{"id":"pmh:oai:arXiv.org:1202.2591","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1202.2591","pdf_url":"https://arxiv.org/pdf/1202.2591","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1202.2591","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1202.2591","pdf_url":"https://arxiv.org/pdf/1202.2591","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W36355091","https://openalex.org/W143316254","https://openalex.org/W575783123","https://openalex.org/W1480448853","https://openalex.org/W1620763508","https://openalex.org/W1978577500","https://openalex.org/W1987993132","https://openalex.org/W2010329103","https://openalex.org/W2071391326","https://openalex.org/W2084051193","https://openalex.org/W2113582770","https://openalex.org/W2129064963","https://openalex.org/W2150941507","https://openalex.org/W2172068359","https://openalex.org/W2494316805","https://openalex.org/W4236256974","https://openalex.org/W4248269519","https://openalex.org/W6634655293","https://openalex.org/W6674672912"],"related_works":[],"abstract_inverted_index":{"Previous":[0],"work":[1],"has":[2],"demonstrated":[3],"that":[4,20,23],"categories":[5],"are":[6],"useful":[7],"and":[8,26,75,83],"expressive":[9],"models":[10],"for":[11],"databases.":[12],"In":[13,40,85],"the":[14,55,60,64,72,126,130],"current":[15],"paper":[16],"we":[17,91,107],"build":[18],"on":[19,102],"model,":[21],"showing":[22],"certain":[24,95,114],"queries":[25,82,101],"constraints":[27,70],"correspond":[28],"to":[29,37,49,59,87,113,123,128],"lifting":[30,52],"problems,":[31],"as":[32],"found":[33],"in":[34],"modern":[35],"approaches":[36],"algebraic":[38],"topology.":[39],"our":[41],"formulation,":[42],"each":[43],"SPARQL":[44],"graph":[45],"pattern":[46],"query":[47,61],"corresponds":[48],"a":[50,94],"category-theoretic":[51],"problem,":[53],"whereby":[54],"set":[56,65],"of":[57,66,81,100,116,132],"solutions":[58],"is":[62],"precisely":[63],"lifts.":[67],"We":[68],"interpret":[69],"within":[71],"same":[73],"formalism,":[74],"then":[76],"investigate":[77],"some":[78],"basic":[79],"properties":[80],"constraints.":[84],"particular,":[86],"any":[88],"database":[89,97],"\u03c0,":[90,124],"can":[92],"associate":[93],"derived":[96],"Qry":[98,117],"(\u03c0)":[99],"\u03c0.":[103],"As":[104],"an":[105],"application,":[106],"explain":[108],"how":[109],"giving":[110],"users":[111],"access":[112,122],"parts":[115],"(\u03c0),":[118],"rather":[119],"than":[120],"direct":[121],"improves":[125],"ability":[127],"manage":[129],"impact":[131],"schema":[133],"evolution.":[134]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":2}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2016-06-24T00:00:00"}