{"id":"https://openalex.org/W1985181755","doi":"https://doi.org/10.1145/512976.512998","title":"An algebra of relations for machine computation","display_name":"An algebra of relations for machine computation","publication_year":1975,"publication_date":"1975-01-01","ids":{"openalex":"https://openalex.org/W1985181755","doi":"https://doi.org/10.1145/512976.512998","mag":"1985181755"},"language":"en","primary_location":{"id":"doi:10.1145/512976.512998","doi":"https://doi.org/10.1145/512976.512998","is_oa":false,"landing_page_url":"https://doi.org/10.1145/512976.512998","pdf_url":null,"source":{"id":"https://openalex.org/S7407088133","display_name":"ACM SIGPLAN-SIGACT Symposium on Principles of Programming Languages (POPL)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGACT-SIGPLAN symposium on Principles of programming languages - POPL '75","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5113477008","display_name":"Patrick A. V. Hall","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210121844","display_name":"IBM (United Kingdom)","ror":"https://ror.org/02wat9f69","country_code":"GB","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210121844"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Patrick Hall","raw_affiliation_strings":["IBM (UK) Scientific Centre, Durham, England","IBM (UK) Scientific Centre, Durham, England#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England","institution_ids":["https://openalex.org/I4210121844"]},{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England#TAB#","institution_ids":["https://openalex.org/I4210121844"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Peter Hitchcock","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210121844","display_name":"IBM (United Kingdom)","ror":"https://ror.org/02wat9f69","country_code":"GB","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210121844"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Peter Hitchcock","raw_affiliation_strings":["IBM (UK) Scientific Centre, Durham, England","IBM (UK) Scientific Centre, Durham, England#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England","institution_ids":["https://openalex.org/I4210121844"]},{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England#TAB#","institution_ids":["https://openalex.org/I4210121844"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047921537","display_name":"Stephen J. P. Todd","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210121844","display_name":"IBM (United Kingdom)","ror":"https://ror.org/02wat9f69","country_code":"GB","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210121844"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Stephen Todd","raw_affiliation_strings":["IBM (UK) Scientific Centre, Durham, England","IBM (UK) Scientific Centre, Durham, England#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England","institution_ids":["https://openalex.org/I4210121844"]},{"raw_affiliation_string":"IBM (UK) Scientific Centre, Durham, England#TAB#","institution_ids":["https://openalex.org/I4210121844"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210121844"],"apc_list":null,"apc_paid":null,"fwci":2.5714,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.88757396,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"225","last_page":"232"},"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.9901999831199646,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9901999831199646,"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/T10126","display_name":"Logic, programming, and type systems","score":0.004999999888241291,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.0005000000237487257,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.9810000061988831},{"id":"https://openalex.org/keywords/order-independence","display_name":"order independence","score":0.593999981880188},{"id":"https://openalex.org/keywords/relational-expressions","display_name":"relational expressions","score":0.765999972820282},{"id":"https://openalex.org/keywords/effectiveness","display_name":"effectiveness","score":0.5450000166893005},{"id":"https://openalex.org/keywords/equi-join","display_name":"equi-join","score":0.8309999704360962},{"id":"https://openalex.org/keywords/union-operation","display_name":"union operation","score":0.6480000019073486},{"id":"https://openalex.org/keywords/database-theory","display_name":"database theory","score":0.4440000057220459},{"id":"https://openalex.org/keywords/machine-computation","display_name":"machine computation","score":0.7739999890327454}],"concepts":[{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.8662667870521545},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8211096525192261},{"id":"https://openalex.org/C16739119","wikidata":"https://www.wikidata.org/wiki/Q5139948","display_name":"Codd's theorem","level":5,"score":0.6964331269264221},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6554163694381714},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6499822735786438},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.6167029738426208},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.5970951914787292},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.5951529741287231},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.595018744468689},{"id":"https://openalex.org/C10282146","wikidata":"https://www.wikidata.org/wiki/Q5965969","display_name":"Relation algebra","level":5,"score":0.5535208582878113},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5487467050552368},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4848810136318207},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.46262288093566895},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4412633776664734},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4198063611984253},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27020877599716187},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2600986361503601},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.23748698830604553},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20308509469032288},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.15054434537887573},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.13194069266319275},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.11126750707626343},{"id":"https://openalex.org/C14394260","wikidata":"https://www.wikidata.org/wiki/Q4723980","display_name":"Algebra representation","level":3,"score":0.09292522072792053},{"id":"https://openalex.org/C207764348","wikidata":"https://www.wikidata.org/wiki/Q7858706","display_name":"Two-element Boolean algebra","level":4,"score":0.06222352385520935}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/512976.512998","doi":"https://doi.org/10.1145/512976.512998","is_oa":false,"landing_page_url":"https://doi.org/10.1145/512976.512998","pdf_url":null,"source":{"id":"https://openalex.org/S7407088133","display_name":"ACM SIGPLAN-SIGACT Symposium on Principles of Programming Languages (POPL)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGACT-SIGPLAN symposium on Principles of programming languages - POPL '75","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1546746643","https://openalex.org/W2012056301","https://openalex.org/W2029241887","https://openalex.org/W2094611165","https://openalex.org/W2102101008","https://openalex.org/W2165467455"],"related_works":["https://openalex.org/W138495147","https://openalex.org/W1568120865","https://openalex.org/W1518606923","https://openalex.org/W2095800950","https://openalex.org/W2498029466","https://openalex.org/W1771227339","https://openalex.org/W2016556220","https://openalex.org/W12098501","https://openalex.org/W2159465592","https://openalex.org/W36983325"],"abstract_inverted_index":{"This":[0,36],"paper":[1],"extends":[2],"the":[3,21,31,53],"relational":[4,55,96],"algebra":[5],"of":[6,23,33,38,49,57,77,91,101],"data":[7],"bases,":[8],"presented":[9],"by":[10,73],"Codd":[11],"[4]":[12],"and":[13,103],"others,":[14],"in":[15],"four":[16],"areas.":[17],"The":[18],"first":[19],"is":[20],"use":[22,37],"selector":[24,39],"names":[25,40],"to":[26,43],"remove":[27],"order":[28],"dependencies":[29],"from":[30],"columns":[32],"a":[34,45,74,88],"relation.":[35],"enables":[41],"us":[42],"define":[44],"more":[46],"general":[47],"class":[48],"operations,":[50],"which":[51],"include":[52],"normal":[54],"operations":[56],"union,":[58],"equi-join":[59],"etc.,":[60],"as":[61,70,72,87,98],"special":[62],"cases.":[63],"Thirdly":[64],"we":[65,94],"introduce":[66],"relations":[67,81,102],"represented":[68],"algorithmically":[69],"well":[71],"stored":[75],"set":[76,90],"tuples.":[78,92],"Such":[79],"computed":[80],"cannot":[82],"always":[83],"be":[84],"effectively":[85],"realised":[86],"finite":[89],"Finally":[93],"consider":[95],"expressions":[97],"algorithmic":[99],"representations":[100],"characterize":[104],"their":[105],"effectiveness.":[106]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}