{"id":"https://openalex.org/W2094439713","doi":"https://doi.org/10.1145/582250.582252","title":"Entity-relationship approach to the conceptual schema design","display_name":"Entity-relationship approach to the conceptual schema design","publication_year":1980,"publication_date":"1980-01-01","ids":{"openalex":"https://openalex.org/W2094439713","doi":"https://doi.org/10.1145/582250.582252","mag":"2094439713"},"language":"en","primary_location":{"id":"doi:10.1145/582250.582252","doi":"https://doi.org/10.1145/582250.582252","is_oa":false,"landing_page_url":"https://doi.org/10.1145/582250.582252","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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 1980 ACM SIGMOD international conference on Management of data - SIGMOD '80","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/A5005233704","display_name":"Hirotaka Sakai","orcid":"https://orcid.org/0000-0002-4076-5214","observed_orcids":["https://orcid.org/0000-0002-4076-5214"]},"institutions":[{"id":"https://openalex.org/I65143321","display_name":"Hitachi (Japan)","ror":"https://ror.org/02exqgm79","country_code":"JP","type":"company","lineage":["https://openalex.org/I65143321"]}],"countries":["JP"],"is_corresponding":true,"raw_author_name":"Hirotaka Sakai","raw_affiliation_strings":["Hitachi Institute of Technology, Hitachi, Ltd. Tokyo, Japan#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Hitachi Institute of Technology, Hitachi, Ltd. Tokyo, Japan#TAB#","institution_ids":["https://openalex.org/I65143321"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5005233704"],"corresponding_institution_ids":["https://openalex.org/I65143321"],"apc_list":null,"apc_paid":null,"fwci":2.0985,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.86320755,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"1"},"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.9824000000953674,"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.9824000000953674,"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/T13681","display_name":"Engineering and Information Technology","score":0.00139999995008111,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.0010999999940395355,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/entity-relationship-model","display_name":"entity-relationship model","score":0.906000018119812},{"id":"https://openalex.org/keywords/conceptual-schema-design","display_name":"conceptual schema design","score":0.9950000047683716},{"id":"https://openalex.org/keywords/functional-dependencies","display_name":"functional dependencies","score":0.6850000023841858},{"id":"https://openalex.org/keywords/transitive-dependencies","display_name":"transitive dependencies","score":1.0},{"id":"https://openalex.org/keywords/hierarchical-decomposition","display_name":"hierarchical decomposition","score":0.7730000019073486},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.6259999871253967}],"concepts":[{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.8498088717460632},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7207294702529907},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7014652490615845},{"id":"https://openalex.org/C191399111","wikidata":"https://www.wikidata.org/wiki/Q64861","display_name":"Transitive relation","level":2,"score":0.5767172574996948},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.5486456155776978},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.526703417301178},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5101514458656311},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.5017163753509521},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4696371257305145},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4494037330150604},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40499410033226013},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.40379393100738525},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2863927483558655},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1918720304965973},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.17824557423591614},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1627441942691803},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.1593121886253357},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/582250.582252","doi":"https://doi.org/10.1145/582250.582252","is_oa":false,"landing_page_url":"https://doi.org/10.1145/582250.582252","pdf_url":null,"source":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"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 1980 ACM SIGMOD international conference on Management of data - SIGMOD '80","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1556556153","https://openalex.org/W1971475250","https://openalex.org/W1998512182","https://openalex.org/W2144192824","https://openalex.org/W2177160337","https://openalex.org/W2180847728","https://openalex.org/W3157769651"],"related_works":["https://openalex.org/W4300796287","https://openalex.org/W2058057636","https://openalex.org/W2014253080","https://openalex.org/W2171042068","https://openalex.org/W2008081838","https://openalex.org/W1569182207","https://openalex.org/W1498996471","https://openalex.org/W2152202622","https://openalex.org/W2105155294","https://openalex.org/W7097722711"],"abstract_inverted_index":{"The":[0,16,26,72],"purpose":[1],"of":[2,32,59,74],"this":[3],"paper":[4],"is":[5,19,35,65,79],"to":[6,11,37,85],"present":[7],"a":[8,29,83],"systematic":[9],"approach":[10],"the":[12,22,33,40,45,48,52,57,63,69,75,87],"conceptual":[13,23],"schema":[14,24,64],"design.":[15],"entity-relationship":[17,27],"model":[18],"used":[20],"as":[21,44,82],"model.":[25],"schema,":[28],"formal":[30],"description":[31],"model,":[34],"defined":[36],"explicitly":[38],"state":[39],"dependency":[41],"structures":[42],"such":[43],"functional":[46],"dependencies,":[47,50],"transitive":[49],"and":[51],"hierarchical":[53],"decompositions.":[54],"Based":[55],"upon":[56],"analysis":[58],"these":[60],"structural":[61],"properties,":[62],"iteratively":[66],"transformed":[67],"into":[68],"refined":[70],"form.":[71],"notion":[73],"access":[76],"weight":[77],"matrix":[78],"also":[80],"introduced":[81],"measure":[84],"evaluate":[86],"schemas.":[88]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-10-26T11:51:55.731654","created_date":"2016-06-24T00:00:00"}