{"id":"https://openalex.org/W2067171475","doi":"https://doi.org/10.1016/0306-4379(94)90018-3","title":"An analysis of SQL integrity constraints from an entity-relationship model perspective","display_name":"An analysis of SQL integrity constraints from an entity-relationship model perspective","publication_year":1994,"publication_date":"1994-06-01","ids":{"openalex":"https://openalex.org/W2067171475","doi":"https://doi.org/10.1016/0306-4379(94)90018-3","mag":"2067171475"},"language":"en","primary_location":{"id":"doi:10.1016/0306-4379(94)90018-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0306-4379(94)90018-3","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","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/A5045978751","display_name":"Alberto H. F. Laender","orcid":"https://orcid.org/0000-0001-5032-2233"},"institutions":[{"id":"https://openalex.org/I110200422","display_name":"Universidade Federal de Minas Gerais","ror":"https://ror.org/0176yjw32","country_code":"BR","type":"education","lineage":["https://openalex.org/I110200422"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"A.H.F Laender","raw_affiliation_strings":["Departamento de Ci\u00eancia da Computa\u00e7\u0101o, Universidade Federal de Minas Gerais Caixa Postal 702, 30161-970 Belo Horizonte MG, Brasil"],"affiliations":[{"raw_affiliation_string":"Departamento de Ci\u00eancia da Computa\u00e7\u0101o, Universidade Federal de Minas Gerais Caixa Postal 702, 30161-970 Belo Horizonte MG, Brasil","institution_ids":["https://openalex.org/I110200422"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077506036","display_name":"Marco A. Casanova","orcid":"https://orcid.org/0000-0003-0765-9636"},"institutions":[{"id":"https://openalex.org/I4210113516","display_name":"IBM Research - Brazil","ror":"https://ror.org/01fxqdx25","country_code":"BR","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113516","https://openalex.org/I4210114115"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"M.A Casanova","raw_affiliation_strings":["Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil"],"affiliations":[{"raw_affiliation_string":"Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil","institution_ids":["https://openalex.org/I4210113516"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064618217","display_name":"Alexandre Plastino de Carvalho","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113516","display_name":"IBM Research - Brazil","ror":"https://ror.org/01fxqdx25","country_code":"BR","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113516","https://openalex.org/I4210114115"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"A.P de Carvalho","raw_affiliation_strings":["Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil"],"affiliations":[{"raw_affiliation_string":"Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil","institution_ids":["https://openalex.org/I4210113516"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049345910","display_name":"L. F. G. G. M. Ridolfi","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113516","display_name":"IBM Research - Brazil","ror":"https://ror.org/01fxqdx25","country_code":"BR","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113516","https://openalex.org/I4210114115"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"L.F.G.G.M Ridolfi","raw_affiliation_strings":["Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil"],"affiliations":[{"raw_affiliation_string":"Centro Cient\u00edfico Rio, IBM Brasil Caixa Postal 4624, 20071-001 Rio de Janeiro RJ, Brasil","institution_ids":["https://openalex.org/I4210113516"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5045978751"],"corresponding_institution_ids":["https://openalex.org/I110200422"],"apc_list":{"value":2970,"currency":"USD","value_usd":2970},"apc_paid":null,"fwci":1.0771,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.80687831,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"19","issue":"4","first_page":"331","last_page":"358"},"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.9994999766349792,"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.9994999766349792,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9958000183105469,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9925000071525574,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8758381009101868},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7014327049255371},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6753649711608887},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.5927708745002747},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.5048097372055054},{"id":"https://openalex.org/keywords/entity\u2013relationship-model","display_name":"Entity\u2013relationship model","score":0.4625057578086853},{"id":"https://openalex.org/keywords/perspective","display_name":"Perspective (graphical)","score":0.4562590718269348},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3916976749897003},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.36546844244003296},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.31912967562675476},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.25223708152770996},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.22818505764007568},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1975257694721222}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8758381009101868},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7014327049255371},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6753649711608887},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.5927708745002747},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.5048097372055054},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.4625057578086853},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.4562590718269348},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3916976749897003},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.36546844244003296},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31912967562675476},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.25223708152770996},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.22818505764007568},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1975257694721222}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0306-4379(94)90018-3","is_oa":false,"landing_page_url":"https://doi.org/10.1016/0306-4379(94)90018-3","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities","score":0.8199999928474426}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W174180747","https://openalex.org/W238210582","https://openalex.org/W286127917","https://openalex.org/W1489733459","https://openalex.org/W1499704384","https://openalex.org/W1505294616","https://openalex.org/W1511714305","https://openalex.org/W1597408892","https://openalex.org/W1602005574","https://openalex.org/W1967291753","https://openalex.org/W2055318225","https://openalex.org/W2113827629","https://openalex.org/W2122789628","https://openalex.org/W2140037779","https://openalex.org/W2144192824","https://openalex.org/W2171042068","https://openalex.org/W2751199251","https://openalex.org/W2945526390","https://openalex.org/W6607072452","https://openalex.org/W6609209386","https://openalex.org/W6629424530","https://openalex.org/W6630120888"],"related_works":["https://openalex.org/W2366107444","https://openalex.org/W4388145910","https://openalex.org/W2381570729","https://openalex.org/W1976205134","https://openalex.org/W4312076878","https://openalex.org/W2093763175","https://openalex.org/W1517033997","https://openalex.org/W4254938143","https://openalex.org/W4250921898","https://openalex.org/W1546850634"],"abstract_inverted_index":null,"counts_by_year":[{"year":2018,"cited_by_count":2},{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}