{"id":"https://openalex.org/W2093763175","doi":"https://doi.org/10.4018/jdm.1999100102","title":"Enhancing the ER Model with Integrity Methods","display_name":"Enhancing the ER Model with Integrity Methods","publication_year":1999,"publication_date":"1999-10-01","ids":{"openalex":"https://openalex.org/W2093763175","doi":"https://doi.org/10.4018/jdm.1999100102","mag":"2093763175"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.1999100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.1999100102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"type":"article","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/A5112310880","display_name":"Mira Balaban","orcid":"https://orcid.org/0000-0002-0272-9829"},"institutions":[{"id":"https://openalex.org/I124227911","display_name":"Ben-Gurion University of the Negev","ror":"https://ror.org/05tkyf982","country_code":"IL","type":"education","lineage":["https://openalex.org/I124227911"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Mira Balaban","raw_affiliation_strings":["Ben-Gurion University of the Negev, Israel"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ben-Gurion University of the Negev, Israel","institution_ids":["https://openalex.org/I124227911"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021749916","display_name":"Peretz Shoval","orcid":"https://orcid.org/0000-0002-0183-2832"},"institutions":[{"id":"https://openalex.org/I124227911","display_name":"Ben-Gurion University of the Negev","ror":"https://ror.org/05tkyf982","country_code":"IL","type":"education","lineage":["https://openalex.org/I124227911"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Peretz Shoval","raw_affiliation_strings":["Ben-Gurion University of the Negev, Israel"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ben-Gurion University of the Negev, Israel","institution_ids":["https://openalex.org/I124227911"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6165,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.87146436,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"10","issue":"4","first_page":"14","last_page":"23"},"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.9980999827384949,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9951000213623047,"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/computer-science","display_name":"Computer science","score":0.819243311882019},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.7378993630409241},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7291355133056641},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.646241307258606},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6441302299499512},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5541545152664185},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5325101017951965},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5099431276321411},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.4675411581993103},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.42697829008102417},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.4254644513130188},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.40709376335144043},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3996853530406952},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3550838232040405},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.30397024750709534}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.819243311882019},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.7378993630409241},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7291355133056641},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.646241307258606},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6441302299499512},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5541545152664185},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5325101017951965},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5099431276321411},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4675411581993103},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42697829008102417},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.4254644513130188},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.40709376335144043},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3996853530406952},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3550838232040405},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.30397024750709534},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"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/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.1999100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.1999100102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:10:y:1999:i:4:p:14-23","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.1999100102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.41999998688697815}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W8304365","https://openalex.org/W1495679621","https://openalex.org/W1516892340","https://openalex.org/W1549670460","https://openalex.org/W1994107079","https://openalex.org/W2032941574","https://openalex.org/W2054120401","https://openalex.org/W2070884469","https://openalex.org/W2070960941","https://openalex.org/W2093134728","https://openalex.org/W2159765281","https://openalex.org/W2751199251","https://openalex.org/W2986348978","https://openalex.org/W3128864998"],"related_works":["https://openalex.org/W2007556552","https://openalex.org/W962397878","https://openalex.org/W2091588998","https://openalex.org/W2092382494","https://openalex.org/W2591891926","https://openalex.org/W2208604","https://openalex.org/W2081197949","https://openalex.org/W1846958406","https://openalex.org/W8114561","https://openalex.org/W2090365014"],"abstract_inverted_index":{"Entity":[0],"Relationship":[1],"(ER)":[2],"schemas":[3],"include":[4],"cardinality":[5,18,54,76,116,129],"constraints,":[6,130],"that":[7,113],"restrict":[8],"the":[9,45,53,71,75,84,87,96,104,115,128,165],"dependencies":[10],"among":[11,93],"entities":[12,31],"within":[13],"a":[14,48,57,67,132,144,155,180],"relationship":[15],"type.":[16],"The":[17,120],"constraints":[19,55,77,117],"have":[20],"direct":[21,72],"impact":[22],"on":[23],"application":[24,79],"transactions,":[25],"since":[26,83],"insertions":[27],"or":[28,32,185],"deletions":[29],"of":[30,47,86,95,135,150],"relationships":[33],"might":[34,90],"affect":[35],"related":[36],"entities.":[37],"Application":[38],"transactions":[39],"can":[40,123,159],"be":[41,91,124,174],"strengthened":[42],"to":[43,52,102],"preserve":[44],"consistency":[46],"database":[49,69,98,157,177],"with":[50,110],"respect":[51],"in":[56],"schema.":[58,99],"Yet,":[59],"once":[60],"an":[61,151,190],"ER":[62,88,106],"schema":[63,89,153,158],"is":[64,81,183,193],"translated":[65],"into":[66,118,154],"logical":[68,97,156],"schema,":[70],"correlation":[73],"between":[74],"and":[78,139],"transaction":[80],"lost,":[82],"components":[85],"decomposed":[92],"those":[94],"We":[100],"suggest":[101],"extend":[103],"Enhanced":[105],"(EER)":[107],"data":[108],"model":[109],"integrity":[111,121,161,171],"methods":[112,122,168],"take":[114],"account.":[119],"fully":[125],"defined":[126],"by":[127,163],"using":[131],"small":[133],"number":[134],"primitive":[136,166],"update":[137,167],"methods,":[138,188],"are":[140],"automatically":[141],"created":[142],"for":[143],"given":[145],"EER":[146,152],"diagram.":[147],"A":[148],"translation":[149],"create":[160],"routines":[162,172],"translating":[164],"alone.":[169],"These":[170],"may":[173],"implemented":[175],"as":[176,186],"procedures,":[178],"if":[179,189],"relational":[181],"DBMS":[182,192],"utilized,":[184],"class":[187],"object-oriented":[191],"utilized.":[194]},"counts_by_year":[{"year":2016,"cited_by_count":7}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}