{"id":"https://openalex.org/W2140667122","doi":"https://doi.org/10.1145/1282480.1282492","title":"The entity-relationship model","display_name":"The entity-relationship model","publication_year":1975,"publication_date":"1975-01-01","ids":{"openalex":"https://openalex.org/W2140667122","doi":"https://doi.org/10.1145/1282480.1282492","mag":"2140667122"},"language":"en","primary_location":{"id":"doi:10.1145/1282480.1282492","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1282480.1282492","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1282480.1282492","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st International Conference on Very Large Data Bases - VLDB '75","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1282480.1282492","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5001555844","display_name":"Peter P. S. Chen","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":"Peter P. S. Chen","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, Massachusetts","Massachusetts Institute of Technology, Cambridge, Massachusetts#TAB#"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, Massachusetts","institution_ids":["https://openalex.org/I63966007"]},{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, Massachusetts#TAB#","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5001555844"],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":0.717,"has_fulltext":false,"cited_by_count":175,"citation_normalized_percentile":{"value":0.79478528,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"173","last_page":"173"},"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.9998000264167786,"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.9998000264167786,"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/T11719","display_name":"Data Quality and Management","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9980000257492065,"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/computer-science","display_name":"Computer science","score":0.816953182220459},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.733883798122406},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.571313738822937},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.5626083612442017},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.535963773727417},{"id":"https://openalex.org/keywords/logical-data-model","display_name":"Logical data model","score":0.5358942747116089},{"id":"https://openalex.org/keywords/semantic-data-model","display_name":"Semantic data model","score":0.5037874579429626},{"id":"https://openalex.org/keywords/base","display_name":"Base (topology)","score":0.48818737268447876},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.43848860263824463},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.43805167078971863},{"id":"https://openalex.org/keywords/idef1x","display_name":"IDEF1X","score":0.42690083384513855},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.34735244512557983},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.27287787199020386},{"id":"https://openalex.org/keywords/semantic-web","display_name":"Semantic Web","score":0.21598070859909058},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.21588444709777832},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.17914429306983948}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.816953182220459},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.733883798122406},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.571313738822937},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.5626083612442017},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.535963773727417},{"id":"https://openalex.org/C203702819","wikidata":"https://www.wikidata.org/wiki/Q17146953","display_name":"Logical data model","level":3,"score":0.5358942747116089},{"id":"https://openalex.org/C90312973","wikidata":"https://www.wikidata.org/wiki/Q7449052","display_name":"Semantic data model","level":2,"score":0.5037874579429626},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.48818737268447876},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.43848860263824463},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43805167078971863},{"id":"https://openalex.org/C196621874","wikidata":"https://www.wikidata.org/wiki/Q385210","display_name":"IDEF1X","level":4,"score":0.42690083384513855},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.34735244512557983},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.27287787199020386},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.21598070859909058},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.21588444709777832},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.17914429306983948},{"id":"https://openalex.org/C22550185","wikidata":"https://www.wikidata.org/wiki/Q7095047","display_name":"Ontology-based data integration","level":3,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1282480.1282492","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1282480.1282492","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1282480.1282492","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st International Conference on Very Large Data Bases - VLDB '75","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/1282480.1282492","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1282480.1282492","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1282480.1282492","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st International Conference on Very Large Data Bases - VLDB '75","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2140667122.pdf","grobid_xml":"https://content.openalex.org/works/W2140667122.grobid-xml"},"referenced_works_count":23,"referenced_works":["https://openalex.org/W2461054","https://openalex.org/W34640755","https://openalex.org/W100283742","https://openalex.org/W115666658","https://openalex.org/W161872263","https://openalex.org/W203144304","https://openalex.org/W1505165377","https://openalex.org/W1988104678","https://openalex.org/W1988128185","https://openalex.org/W2012056301","https://openalex.org/W2031662355","https://openalex.org/W2036589402","https://openalex.org/W2040921809","https://openalex.org/W2047499522","https://openalex.org/W2052570934","https://openalex.org/W2079399699","https://openalex.org/W2084248336","https://openalex.org/W2095241310","https://openalex.org/W2103920867","https://openalex.org/W2111869173","https://openalex.org/W2151772024","https://openalex.org/W2163887589","https://openalex.org/W2165467455"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W2400510421","https://openalex.org/W2010499454","https://openalex.org/W1571189946","https://openalex.org/W4299340269","https://openalex.org/W846443833","https://openalex.org/W329546212","https://openalex.org/W2437073216","https://openalex.org/W4248533530","https://openalex.org/W3129264560"],"abstract_inverted_index":{"A":[0,18],"data":[1,32,49,54],"model,":[2,6],"called":[3],"the":[4,9,13,38,41],"entity-relationship":[5],"which":[7],"incorporates":[8],"semantic":[10],"information":[11,51],"in":[12],"real":[14],"world":[15],"is":[16,22,44],"proposed.":[17],"special":[19],"diagramatic":[20,42],"technique":[21,43],"introduced":[23],"for":[24],"exhibiting":[25],"entities":[26],"and":[27,35,40,53],"relationships.":[28],"An":[29],"example":[30],"of":[31],"base":[33],"design":[34],"description":[36],"using":[37],"model":[39],"given.":[45],"The":[46],"implications":[47],"on":[48],"integrity,":[50],"retrieval,":[52],"manipulation":[55],"are":[56],"discussed.":[57]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":10},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}