{"id":"https://openalex.org/W1558965055","doi":"https://doi.org/10.1002/9780470050118.ecse501","title":"Entity\u2010Relationship Model","display_name":"Entity\u2010Relationship Model","publication_year":2008,"publication_date":"2008-09-11","ids":{"openalex":"https://openalex.org/W1558965055","doi":"https://doi.org/10.1002/9780470050118.ecse501","mag":"1558965055"},"language":"en","primary_location":{"id":"doi:10.1002/9780470050118.ecse501","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse501","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"},"type":"other","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/A5037961481","display_name":"Tok Wang Ling","orcid":"https://orcid.org/0000-0002-0496-0565"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Tok Wang Ling","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019988958","display_name":"Mong Li Lee","orcid":"https://orcid.org/0000-0002-9636-388X"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Mong Li Lee","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5037961481"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"10"},"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.9998999834060669,"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.9998999834060669,"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/T11106","display_name":"Data Management and Algorithms","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.994700014591217,"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/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.9377816915512085},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.728453516960144},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.596375048160553},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.5827512145042419},{"id":"https://openalex.org/keywords/data-model","display_name":"Data model (GIS)","score":0.5321319103240967},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5292676687240601},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5285153388977051},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5007836818695068},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41460463404655457},{"id":"https://openalex.org/keywords/translation","display_name":"Translation (biology)","score":0.41217613220214844},{"id":"https://openalex.org/keywords/chen","display_name":"Chen","score":0.41064849495887756},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.39077913761138916},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34973007440567017},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.16377797722816467}],"concepts":[{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.9377816915512085},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.728453516960144},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.596375048160553},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.5827512145042419},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.5321319103240967},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5292676687240601},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5285153388977051},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5007836818695068},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41460463404655457},{"id":"https://openalex.org/C149364088","wikidata":"https://www.wikidata.org/wiki/Q185917","display_name":"Translation (biology)","level":4,"score":0.41217613220214844},{"id":"https://openalex.org/C2776085556","wikidata":"https://www.wikidata.org/wiki/Q183361","display_name":"Chen","level":2,"score":0.41064849495887756},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39077913761138916},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34973007440567017},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16377797722816467},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C105580179","wikidata":"https://www.wikidata.org/wiki/Q188928","display_name":"Messenger RNA","level":3,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/9780470050118.ecse501","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse501","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1490065891","https://openalex.org/W1508819576","https://openalex.org/W1523552828","https://openalex.org/W1858055726","https://openalex.org/W1971778345","https://openalex.org/W1979078782","https://openalex.org/W2028705450","https://openalex.org/W2113827629","https://openalex.org/W2945526390"],"related_works":["https://openalex.org/W4297044271","https://openalex.org/W4248533530","https://openalex.org/W2512945146","https://openalex.org/W3085968255","https://openalex.org/W279222092","https://openalex.org/W2366387924","https://openalex.org/W2048137832","https://openalex.org/W2187344422","https://openalex.org/W1483941649","https://openalex.org/W1558965055"],"abstract_inverted_index":{"Abstract":[0],"Data":[1],"modeling":[2,34],"is":[3],"an":[4],"important":[5],"phase":[6,51],"in":[7,23],"the":[8,49,58,62,92,95,101,107],"development":[9],"of":[10,52,61,77,103],"a":[11,38],"database":[12,43,53,85],"system.":[13],"The":[14],"Entity\u2010Relationship":[15],"(ER)":[16],"model":[17,26],"was":[18],"introduced":[19],"by":[20],"Peter":[21],"Chen":[22],"1977.":[24],"This":[25,55],"has":[27,36],"been":[28],"widely":[29],"used":[30],"for":[31,40],"conceptual":[32,84],"data":[33],"and":[35,45,67,69,100],"become":[37],"tool":[39],"communication":[41],"between":[42],"designers":[44],"end":[46],"users":[47],"at":[48],"analysis":[50],"development.":[54],"article":[56],"presents":[57],"main":[59],"constructs":[60],"ER":[63,93,98,104],"model,":[64,94],"namely,":[65],"entities":[66],"relationships":[68],"their":[70],"associated":[71],"attributes,":[72],"as":[73,75],"well":[74],"some":[76],"its":[78],"extensions.":[79],"We":[80],"also":[81],"discuss":[82],"how":[83],"design":[86],"can":[87],"be":[88],"carried":[89],"out":[90],"using":[91],"normal":[96],"form":[97],"diagram":[99],"translation":[102],"diagrams":[105],"to":[106],"relational":[108],"model.":[109]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}