{"id":"https://openalex.org/W2000500583","doi":"https://doi.org/10.1145/2815072.2815075","title":"Relational foundations for functorial data migration","display_name":"Relational foundations for functorial data migration","publication_year":2015,"publication_date":"2015-10-27","ids":{"openalex":"https://openalex.org/W2000500583","doi":"https://doi.org/10.1145/2815072.2815075","mag":"2000500583"},"language":"en","primary_location":{"id":"doi:10.1145/2815072.2815075","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2815072.2815075","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th Symposium on Database Programming Languages","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1212.5303","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014088772","display_name":"David I. Spivak","orcid":"https://orcid.org/0000-0002-9326-5328"},"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":false,"raw_author_name":"David I. Spivak","raw_affiliation_strings":["Massachusetts Institute of Technology, USA","Massachusetts Institute Of Technology, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, USA","institution_ids":["https://openalex.org/I63966007"]},{"raw_affiliation_string":"Massachusetts Institute Of Technology, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071077157","display_name":"Ryan Wisnesky","orcid":"https://orcid.org/0000-0002-4768-7861"},"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":false,"raw_author_name":"Ryan Wisnesky","raw_affiliation_strings":["Massachusetts Institute of Technology, USA","Massachusetts Institute Of Technology, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, USA","institution_ids":["https://openalex.org/I63966007"]},{"raw_affiliation_string":"Massachusetts Institute Of Technology, USA","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4452,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.76630088,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"21","last_page":"28"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9976000189781189,"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.9976000189781189,"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.9890000224113464,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9466999769210815,"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/functor","display_name":"Functor","score":0.788368284702301},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.488102525472641},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4713399112224579},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.4600827991962433},{"id":"https://openalex.org/keywords/algebraic-number","display_name":"Algebraic number","score":0.46002310514450073},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4570621848106384},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4366070330142975},{"id":"https://openalex.org/keywords/algebraic-structure","display_name":"Algebraic structure","score":0.4318394660949707},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.42818763852119446},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35128694772720337},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.3044460415840149},{"id":"https://openalex.org/keywords/pure-mathematics","display_name":"Pure mathematics","score":0.2790149450302124},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.1503675878047943},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.14662721753120422}],"concepts":[{"id":"https://openalex.org/C156772000","wikidata":"https://www.wikidata.org/wiki/Q864475","display_name":"Functor","level":2,"score":0.788368284702301},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.488102525472641},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4713399112224579},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4600827991962433},{"id":"https://openalex.org/C9376300","wikidata":"https://www.wikidata.org/wiki/Q168817","display_name":"Algebraic number","level":2,"score":0.46002310514450073},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4570621848106384},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4366070330142975},{"id":"https://openalex.org/C182419690","wikidata":"https://www.wikidata.org/wiki/Q205464","display_name":"Algebraic structure","level":2,"score":0.4318394660949707},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.42818763852119446},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35128694772720337},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3044460415840149},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.2790149450302124},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1503675878047943},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.14662721753120422},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1145/2815072.2815075","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2815072.2815075","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th Symposium on Database Programming Languages","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1212.5303","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1212.5303","pdf_url":"https://arxiv.org/pdf/1212.5303","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"mag:2000500583","is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1212.5303.pdf","pdf_url":null,"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":"arXiv (Cornell University)","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.385.7914","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.385.7914","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://wisnesky.net/icdt14.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.752.4727","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.752.4727","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arxiv.org/pdf/1212.5303.pdf","raw_type":"text"},{"id":"doi:10.48550/arxiv.1212.5303","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1212.5303","pdf_url":null,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1212.5303","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1212.5303","pdf_url":"https://arxiv.org/pdf/1212.5303","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10","score":0.7900000214576721}],"awards":[{"id":"https://openalex.org/G6160262189","display_name":null,"funder_award_id":"N000141310260","funder_id":"https://openalex.org/F4320337345","funder_display_name":"Office of Naval Research"}],"funders":[{"id":"https://openalex.org/F4320337345","display_name":"Office of Naval Research","ror":"https://ror.org/00rk2pe57"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2000500583.pdf","grobid_xml":"https://content.openalex.org/works/W2000500583.grobid-xml"},"referenced_works_count":9,"referenced_works":["https://openalex.org/W21010746","https://openalex.org/W1498786002","https://openalex.org/W1597310467","https://openalex.org/W1620763508","https://openalex.org/W2010426631","https://openalex.org/W2042767697","https://openalex.org/W2106039833","https://openalex.org/W2112160987","https://openalex.org/W2997050146"],"related_works":["https://openalex.org/W2586289688","https://openalex.org/W2616355655","https://openalex.org/W1601165993","https://openalex.org/W2062058882","https://openalex.org/W1522816362","https://openalex.org/W2782325837","https://openalex.org/W2963086803","https://openalex.org/W3203176006","https://openalex.org/W974565807","https://openalex.org/W2029837744","https://openalex.org/W2105757856","https://openalex.org/W2004942342","https://openalex.org/W2040962856","https://openalex.org/W2051115073","https://openalex.org/W613219970","https://openalex.org/W1524101192","https://openalex.org/W3094740951","https://openalex.org/W2029610160","https://openalex.org/W2897457077","https://openalex.org/W3202683588"],"abstract_inverted_index":{"We":[0,93],"study":[1],"the":[2,44,118],"data":[3,74],"transformation":[4],"capabilities":[5],"associated":[6],"with":[7,117,124,135],"schemas":[8,24,33,57],"that":[9,105,112,130],"are":[10],"presented":[11],"by":[12],"directed":[13],"multi-graphs":[14],"and":[15,43,59,87,128],"path":[16],"equations.":[17],"Unlike":[18],"most":[19],"approaches":[20],"which":[21,61],"treat":[22,31],"graph-based":[23,32],"as":[25,34],"abbreviations":[26],"for":[27],"relational":[28,120],"schemas,":[29],"we":[30],"categories.":[35],"A":[36,53],"schema":[37],"S":[38,58],"is":[39,107],"a":[40,50,66,125],"finitely-presented":[41],"category,":[42,51],"collection":[45],"of":[46],"all":[47],"S-instances":[48],"forms":[49],"S-inst.":[52,92],"functor":[54],"F":[55],"between":[56,69],"T,":[60],"can":[62,114,132],"be":[63,115,133],"generated":[64],"from":[65],"visual":[67],"mapping":[68],"graphs,":[70],"induces":[71],"three":[72],"adjoint":[73],"migration":[75],"functors,":[76,103],"Sigma_F":[77],":":[78,83,89],"S-inst":[79,84],"->":[80,85,91],"T-inst,":[81,86],"Pi_F":[82],"Delta_F":[88],"T-inst":[90],"present":[94],"an":[95],"algebraic":[96],"query":[97],"language":[98],"FQL":[99,106,113],"based":[100],"on":[101],"these":[102],"prove":[104,111,129],"closed":[108],"under":[109],"composition,":[110],"implemented":[116,134],"select-project-product-union":[119],"algebra":[121],"(SPCU)":[122],"extended":[123],"key-generation":[126],"operation,":[127],"SPCU":[131],"FQL.":[136]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}