{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,8,16]],"date-time":"2023-08-16T15:17:17Z","timestamp":1692199037172},"reference-count":23,"publisher":"Elsevier BV","issue":"4","license":[{"start":{"date-parts":[[1994,6,1]],"date-time":"1994-06-01T00:00:00Z","timestamp":770428800000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information Systems"],"published-print":{"date-parts":[[1994,6]]},"DOI":"10.1016\/0306-4379(94)90018-3","type":"journal-article","created":{"date-parts":[[2003,8,7]],"date-time":"2003-08-07T21:31:39Z","timestamp":1060291899000},"page":"331-358","source":"Crossref","is-referenced-by-count":9,"title":["An analysis of SQL integrity constraints from an entity-relationship model perspective"],"prefix":"10.1016","volume":"19","author":[{"given":"A.H.F","family":"Laender","sequence":"first","affiliation":[]},{"given":"M.A","family":"Casanova","sequence":"additional","affiliation":[]},{"given":"A.P","family":"de Carvalho","sequence":"additional","affiliation":[]},{"given":"L.F.G.G.M","family":"Ridolfi","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/0306-4379(94)90018-3_BIB1","series-title":"Database Language SQL2","year":"1990"},{"key":"10.1016\/0306-4379(94)90018-3_BIB2","series-title":"Proc. 10th Int. Conf. on Very Large Data Bases","article-title":"Equivalence and mapping of database schemes","author":"Atri","year":"1984"},{"key":"10.1016\/0306-4379(94)90018-3_BIB3","series-title":"Proc. 5th Int. Conf. on the Entity-Relationship Approach","article-title":"Translation of an extended entity-relationship model into the universal relation with inclusion formalism","author":"Azar","year":"1986"},{"key":"10.1016\/0306-4379(94)90018-3_BIB4","series-title":"Conceptual Database Design: An Entity-Relationship Approach","author":"Batini","year":"1992"},{"key":"10.1016\/0306-4379(94)90018-3_BIB5","series-title":"Proc. 15th Int. Conf. on Very Large Data Bases","article-title":"Optimization of relational schemas containing inclusion dependencies","author":"Casanova","year":"1989"},{"key":"10.1016\/0306-4379(94)90018-3_BIB6","article-title":"A data definition language for an extended entity-relationship model","author":"Casanova","year":"1989"},{"key":"10.1016\/0306-4379(94)90018-3_BIB7","series-title":"Proc. 9th Int. Conf. on Entity-Relationship Approach","article-title":"Algorithms for designing and maintaining optimized relational representations of entity-relationship schemas","author":"Casanova","year":"1990"},{"issue":"1","key":"10.1016\/0306-4379(94)90018-3_BIB8","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1016\/0169-023X(93)90043-O","article-title":"On the design and maintenance of optimized relational representations of entity-relationship schemas","volume":"11","author":"Casanova","year":"1993","journal-title":"Data and Knowledge Engineering"},{"key":"10.1016\/0306-4379(94)90018-3_BIB9","series-title":"Proc. 10th Int. Conf. on Entity-Relationship Approach","article-title":"An analysis of table constraints in SQL2 based on the entity-relationship model","author":"Casanova","year":"1991"},{"issue":"1","key":"10.1016\/0306-4379(94)90018-3_BIB10","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","article-title":"The entity-relationship model: toward a unified view of data","volume":"1","author":"Chen","year":"1976","journal-title":"ACM Transactions on Database Systems"},{"issue":"4","key":"10.1016\/0306-4379(94)90018-3_BIB11","doi-asserted-by":"crossref","first-page":"397","DOI":"10.1145\/320107.320109","article-title":"Extending the database relational model to capture more meaning","volume":"4","author":"Codd","year":"1979","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(94)90018-3_BIB12","series-title":"Fundamentals of Database Systems","author":"Elmasri","year":"1989"},{"issue":"5","key":"10.1016\/0306-4379(94)90018-3_BIB13","doi-asserted-by":"crossref","first-page":"508","DOI":"10.1093\/comjnl\/28.5.508","article-title":"Mapping from a conceptual schema to a target internal schema","volume":"28","author":"Flynn","year":"1985","journal-title":"The Computer Journal"},{"key":"10.1016\/0306-4379(94)90018-3_BIB14","series-title":"Proc. 10th Int. Conf. on Entity-Relationship Approach","article-title":"Semantic modeling of an accounting universe of discourse \u2014 the usefulness of inter-relationship constraints","author":"Guido","year":"1991"},{"key":"10.1016\/0306-4379(94)90018-3_BIB15","author":"Joint Technical Committee ISO\/IEC JCT1","year":"1991","journal-title":"International Standard ISO\/IEC 9075:199x(E) \u2014 Database Language SQL"},{"key":"10.1016\/0306-4379(94)90018-3_BIB16","series-title":"Proc 12th Int. Conf. on Entity-Relationship Approach","article-title":"A semantic comparison of the modelling capabilities of the ER and NIAM models","author":"Laender","year":"1993"},{"issue":"3","key":"10.1016\/0306-4379(94)90018-3_BIB17","doi-asserted-by":"crossref","first-page":"423","DOI":"10.1145\/132271.132273","article-title":"Representing extended entity-relationship structures in relational databases: a modular approach","volume":"17","author":"Markowitz","year":"1992","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0306-4379(94)90018-3_BIB18","series-title":"Conceptual Schema and Relational Database Design: A Fact-Oriented Approach","author":"Nijssen","year":"1989"},{"key":"10.1016\/0306-4379(94)90018-3_BIB19","series-title":"Proc. of the 9th Congress of the Brazilian Computer Society","article-title":"Correct translation of entity-relationship schemas into relational schemas","author":"Pacheco","year":"1989"},{"key":"10.1016\/0306-4379(94)90018-3_BIB20","article-title":"A tool for conceptual database design based on the entity relationship model","author":"Ridolfi","year":"1991"},{"key":"10.1016\/0306-4379(94)90018-3_BIB21","series-title":"Database Modeling and Design: The Entity-Relationship Approach","author":"Teorey","year":"1990"},{"issue":"2","key":"10.1016\/0306-4379(94)90018-3_BIB22","doi-asserted-by":"crossref","first-page":"197","DOI":"10.1145\/7474.7475","article-title":"A logical design methodology for relational databases using the extended entity-relationship model","volume":"18","author":"Teorey","year":"1986","journal-title":"ACM Computing Survey"},{"key":"10.1016\/0306-4379(94)90018-3_BIB23","series-title":"Information Systems Design Methodologies: A Comparative Review","article-title":"NIAM: An information analysis method","author":"Verheijen","year":"1982"}],"container-title":["Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437994900183?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0306437994900183?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,15]],"date-time":"2019-03-15T00:56:35Z","timestamp":1552611395000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0306437994900183"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1994,6]]},"references-count":23,"journal-issue":{"issue":"4","published-print":{"date-parts":[[1994,6]]}},"alternative-id":["0306437994900183"],"URL":"https:\/\/doi.org\/10.1016\/0306-4379(94)90018-3","relation":{},"ISSN":["0306-4379"],"issn-type":[{"value":"0306-4379","type":"print"}],"subject":[],"published":{"date-parts":[[1994,6]]}}}