{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,11]],"date-time":"2025-09-11T21:40:23Z","timestamp":1757626823061,"version":"3.44.0"},"reference-count":80,"publisher":"Elsevier BV","issue":"1","license":[{"start":{"date-parts":[[1996,6,1]],"date-time":"1996-06-01T00:00:00Z","timestamp":833587200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[1996,6,1]],"date-time":"1996-06-01T00:00:00Z","timestamp":833587200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/legal\/tdmrep-license"},{"start":{"date-parts":[[1999,2,9]],"date-time":"1999-02-09T00:00:00Z","timestamp":918518400000},"content-version":"vor","delay-in-days":983,"URL":"http:\/\/creativecommons.org\/licenses\/by-nc-nd\/4.0\/"}],"content-domain":{"domain":["elsevier.com","sciencedirect.com"],"crossmark-restriction":true},"short-container-title":["Data & Knowledge Engineering"],"published-print":{"date-parts":[[1996,6]]},"DOI":"10.1016\/0169-023x(95)00035-q","type":"journal-article","created":{"date-parts":[[2002,7,25]],"date-time":"2002-07-25T13:28:40Z","timestamp":1027603720000},"page":"1-37","update-policy":"https:\/\/doi.org\/10.1016\/elsevier_cm_policy","source":"Crossref","is-referenced-by-count":2,"title":["Semantic integrity constraints in knowledge-based database design systems"],"prefix":"10.1016","volume":"20","author":[{"given":"Veda C.","family":"Storey","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Heng-Li","family":"Yang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Robert C.","family":"Goldstein","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"year":"1974","series-title":"The Design and Analysis of Computer Algorithms","author":"Aho","key":"10.1016\/0169-023X(95)00035-Q_BIB1"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB2","series-title":"Proc. Trends & Applications","first-page":"43","article-title":"Integrity aspects in data base management systems","author":"Bertino","year":"1984"},{"article-title":"Design-by-example: A design tool for the relational model of data","year":"1985","author":"Bitton","key":"10.1016\/0169-023X(95)00035-Q_BIB3"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB4","series-title":"Conceptual Modeling, Databases, and Case","first-page":"465","article-title":"Using expert systems in schema design","author":"Bouzeghoub","year":"1992"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB5","series-title":"New Applications of Data Bases","first-page":"203","article-title":"The design of an expert system for database design","author":"Bouzeghoub","year":"1984"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB6","series-title":"Proc. of the Eleventh Int. Conf. on Very Large Data Base","first-page":"82","article-title":"Database design tools: An expert system approach","author":"Bouzeghoub","year":"1985"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB7","first-page":"251","article-title":"SECSI: An expert system approach for database design","volume":"86","author":"Bouzeghoub","year":"1986"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB8","series-title":"Int. Conf. on Data Engineering","first-page":"399","article-title":"Gambit: An interactive database design tool for data structures, integrity constraints and transactions","author":"Braegger","year":"1984"},{"issue":"7","key":"10.1016\/0169-023X(95)00035-Q_BIB9","doi-asserted-by":"crossref","first-page":"574","DOI":"10.1109\/TSE.1985.232501","article-title":"Gambit: An interactive database design tool for data structures, integrity constraints and transactions","volume":"SE-11","author":"Braegger","year":"1985","journal-title":"IEEE Trans. Software Eng."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB10","series-title":"Aspects of Databases, Proc. 9th British National Conference on Databases","first-page":"38","article-title":"Object-oriented integrity enforcement in a relational environment","author":"Briales","year":"1991"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB11","series-title":"Fourth Conf. on Entity-Relationship Approach","first-page":"199","article-title":"Expert system for translating an E-R diagram into databases","author":"Briand","year":"1985"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB12","series-title":"On Knowledge-Base Management Systems","first-page":"201","article-title":"Database management: A survey","author":"Brodie","year":"1986"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB13","series-title":"Entity-Relationship","first-page":"381","article-title":"SA-ER: A methodology that links structured analysis and Entity-Relationship modelling for database design","author":"Carsnell","year":"1987"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB14","series-title":"Proc. Seventh Int. Conf. on Entity-Relationship Approach","article-title":"OPTIM_ER: An automated tool for supporting the logical design within a complete CASE environment","author":"Catarci","year":"1988"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB15","series-title":"DS-3 (Artificial Intelligence in Databases and Informations)","first-page":"51","article-title":"Information systems design: An expert system approach","author":"Cauvet","year":"1990"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB16","series-title":"Methodologies for Intelligent Systems","first-page":"56","article-title":"A Knowledge base for an information system design tool","author":"Cauvet","year":"1987"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB17","article-title":"Deriving Production Rules for Constraint Maintenance","author":"Ceri","year":"1990","journal-title":"IBM Research Report, RJ 7348"},{"year":"1995","series-title":"DesignAidIITM","key":"10.1016\/0169-023X(95)00035-Q_BIB18"},{"year":"1995","series-title":"Chen Workbench","key":"10.1016\/0169-023X(95)00035-Q_BIB19"},{"issue":"1","key":"10.1016\/0169-023X(95)00035-Q_BIB20","doi-asserted-by":"crossref","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 Trans. Database Syst."},{"issue":"2","key":"10.1016\/0169-023X(95)00035-Q_BIB21","doi-asserted-by":"crossref","first-page":"107","DOI":"10.1016\/0169-023X(94)90011-6","article-title":"Reverse engineering of relational databases: Extraction of an EER model from a relational database","volume":"12","author":"Chiang","year":"1994","journal-title":"Data and Knowledge Eng."},{"article-title":"Form driven conceptual data modeling","year":"1985","author":"Choobineh","key":"10.1016\/0169-023X(95)00035-Q_BIB22"},{"issue":"2","key":"10.1016\/0169-023X(95)00035-Q_BIB23","doi-asserted-by":"crossref","first-page":"242","DOI":"10.1109\/32.4641","article-title":"An expert database design system based on analysis of forms","volume":"14","author":"Choobineh","year":"1988","journal-title":"IEEE Trans. Software Eng."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB24","series-title":"Database Modelling, Databases, and Case","first-page":"433","article-title":"The role of form analysis in computer-aided software engineering","author":"Choobineh","year":"1992"},{"volume":"Vol. II","year":"1983","author":"Date","key":"10.1016\/0169-023X(95)00035-Q_BIB25"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB26","first-page":"1","article-title":"On data schema transformation","author":"de Troyer","year":"1993"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB27","series-title":"Proc. of ACM SIGMOD Int. Management of Data","first-page":"418","article-title":"RIDL: A tool for the computer-assisted engineering of large databases in the presence of integrity constraints","author":"de Troyer","year":"1989"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB28","first-page":"99","article-title":"On rule-based generation of conceptual database updates","volume":"DS-2","author":"de Troyer","year":"1988"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB29","series-title":"Computer Assistance During the Information Systems Life Cycle","first-page":"375","article-title":"RIDL\u2217 on the CRIS case: A workbench for NIAM","author":"de Troyer","year":"1988"},{"issue":"4","key":"10.1016\/0169-023X(95)00035-Q_BIB30","doi-asserted-by":"crossref","first-page":"479","DOI":"10.1109\/32.16607","article-title":"A generalized expert system for database design","volume":"15","author":"Dogac","year":"1989","journal-title":"IEEE Trans. Software Eng."},{"year":"1995","series-title":"ERwin","key":"10.1016\/0169-023X(95)00035-Q_BIB31"},{"year":"1981","series-title":"Database Security and Integrity","author":"Fernandez","key":"10.1016\/0169-023X(95)00035-Q_BIB32"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB33","series-title":"Conceptual Modeling, Databases, and Case","first-page":"413","article-title":"TARA: Tool-Assisted Requirements Analysis","author":"Finkelstein","year":"1992"},{"year":"1984","series-title":"Database Management Systems","key":"10.1016\/0169-023X(95)00035-Q_BIB34"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB35","series-title":"Entity-Relationship Approach","first-page":"515","article-title":"The CHRIS CONSULTANT","author":"Furtado","year":"1988"},{"year":"1995","series-title":"The semantic integrity constraint representation model","author":"Goldstein","key":"10.1016\/0169-023X(95)00035-Q_BIB36"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB37","series-title":"Proc. Fourth Conf. on Entity-Relationship Approach","first-page":"64","article-title":"A Computer-Aid for E-R Modelling","author":"Hawryszkiewycz","year":"1985"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB38","series-title":"Entity-Relationship Approach","first-page":"497","article-title":"TSER: A data modelling system using the two-stage Entity-Relationship approach","author":"Hsu","year":"1988"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB39","unstructured":"IBM Corporation, 1995."},{"year":"1988","series-title":"Intellibase","key":"10.1016\/0169-023X(95)00035-Q_BIB40"},{"issue":"3","key":"10.1016\/0169-023X(95)00035-Q_BIB41","doi-asserted-by":"crossref","first-page":"287","DOI":"10.1016\/0169-023X(93)90011-D","article-title":"COMIC: A system and methodology for conceptual modelling and information construction","volume":"9","author":"Kangassalo","year":"1993","journal-title":"Data and Knowledge Eng."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB42","series-title":"Proc. ECAI","article-title":"An intelligent interview system for conceptual design of database","author":"Kawaguchi","year":"1986"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB43","series-title":"Entity-Relationship","first-page":"35","article-title":"A conceptual modelling expert system","author":"Kerstern","year":"1987"},{"year":"1995","series-title":"The KEY Product Family","key":"10.1016\/0169-023X(95)00035-Q_BIB44"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB45","series-title":"Entity-Relationship Approach","first-page":"533","article-title":"An extended Entity-Relationship (E2R) database specification and its automatic verification and transformation into the logical relational design","author":"Kozaczynski","year":"1988"},{"issue":"4","key":"10.1016\/0169-023X(95)00035-Q_BIB46","doi-asserted-by":"crossref","first-page":"167","DOI":"10.1049\/sej.1994.0022","article-title":"Knowledge-based CASE tools: Improving performance using domain-specific knowledge","volume":"9","author":"Lloyd-Williams","year":"1994","journal-title":"Software Eng. J."},{"issue":"3","key":"10.1016\/0169-023X(95)00035-Q_BIB47","first-page":"197","article-title":"Expert system support for object-oriented database design","volume":"1","author":"Lloyd-Williams","year":"1993","journal-title":"Int. J. Appl. Expert Systems"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB48","doi-asserted-by":"crossref","first-page":"263","DOI":"10.1007\/BF00155764","article-title":"Expert systems for database design: A comparative review","volume":"6","author":"Lloyd-Williams","year":"1992","journal-title":"Artificial Intelligence Rev."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB49","series-title":"Conceptual Modeling, Databases, and Case","first-page":"373","article-title":"CASE \u2014 Methods and support tools","author":"Loucopoulos","year":"1992"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB50","series-title":"Entity-Relationship Approach to Software Engineering","first-page":"205","article-title":"What is the binary-relationship approach?","author":"Mark","year":"1983"},{"year":"1984","series-title":"Generation of conceptual data models","author":"Maryanski","key":"10.1016\/0169-023X(95)00035-Q_BIB51"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB52","series-title":"IEEE COMPSAC","first-page":"368","article-title":"A tool for generating semantic database applications","author":"Maryanski","year":"1985"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB53","first-page":"245","article-title":"Towards methods for practical reasoning about conceptual database design","volume":"DS-2","author":"Meersman","year":"1988"},{"year":"1995","series-title":"Design\/IDEP: Modeling for Results","key":"10.1016\/0169-023X(95)00035-Q_BIB54"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB55","series-title":"A Panel on AI and Databases, Proc. Eighth. Int. Joint Conf. on Artificial Intelligence","first-page":"1199","article-title":"Knowledge representation and databases","author":"Mylopoulos","year":"1983"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB56","unstructured":"G.M. Nijssen, A gross architecture for the next generation database management system, in: G,M. Nijssen, ed., Proc. of the 1F1P TC-2 Conference Modelling in Database Management Systems."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB57","doi-asserted-by":"crossref","first-page":"173","DOI":"10.1016\/0169-023X(88)90014-6","article-title":"A knowledge-based approach to relational database design","volume":"3","author":"Obretenov","year":"1988","journal-title":"Data & Knowledge Eng."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB58","unstructured":"Oracle Corporation, Redwood Shores, California, 1995."},{"year":"1982","series-title":"Combinatorial Optimization: Algorithms and Complexity","author":"Papadimitriou","key":"10.1016\/0169-023X(95)00035-Q_BIB59"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB60","first-page":"293","article-title":"A knowledge base for information system design","volume":"DS-2","author":"Proix","year":"1988"},{"issue":"9","key":"10.1016\/0169-023X(95)00035-Q_BIB61","doi-asserted-by":"crossref","first-page":"95","DOI":"10.1145\/223248.223277","article-title":"Deriving functional dependencies from the Entity Relationship model: An expert systems approach","volume":"38","author":"Ram","year":"1995","journal-title":"Communications of the ACM"},{"article-title":"Automated tools for database design: State of the art","year":"1990","author":"Ram","key":"10.1016\/0169-023X(95)00035-Q_BIB62"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB63","series-title":"Conceptual Database Design: An Entity-Relationship Approach","article-title":"Database design tools","author":"Reiner","year":"1992"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB64","first-page":"241","article-title":"An expert system approach to information system design","volume":"86","author":"Rolland","year":"1986"},{"year":"1991","series-title":"Object-Oriented Modeling and Design","author":"Rumbaugh","key":"10.1016\/0169-023X(95)00035-Q_BIB65"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB66","series-title":"Proc. the First Conf. on Artificial Intelligence Application","first-page":"439","article-title":"CODES: A database design expert system prototype","author":"Ruoff","year":"1984"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB67","series-title":"ACM-SIGMOD Proc. Int. Conf. on Management of Data","first-page":"9","article-title":"Design and implementation of an extendible integrity subsystem","author":"Simon","year":"1984"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB68","doi-asserted-by":"crossref","first-page":"61","DOI":"10.1016\/0169-023X(93)90045-Q","article-title":"A selective survey of the use of artificial intelligence methods for database design systems","volume":"11","author":"Storey","year":"1993","journal-title":"Data and Knowledge Eng."},{"key":"10.1016\/0169-023X(95)00035-Q_BIB69","doi-asserted-by":"crossref","DOI":"10.1145\/1113523.1113538","article-title":"View Creation: An Expert System for Database Design","author":"Storey","year":"1986"},{"issue":"1","key":"10.1016\/0169-023X(95)00035-Q_BIB70","doi-asserted-by":"crossref","first-page":"25","DOI":"10.2307\/249508","article-title":"Knowledge-based approaches to database design","volume":"17","author":"Storey","year":"1993","journal-title":"Management Information Systems Quart."},{"issue":"1","key":"10.1016\/0169-023X(95)00035-Q_BIB71","first-page":"31","article-title":"Design and development of an expert database design system","volume":"3","author":"Storey","year":"1990","journal-title":"Int. J. Expert Systems: Research and Applications"},{"issue":"3","key":"10.1016\/0169-023X(95)00035-Q_BIB72","first-page":"19","article-title":"An expert view creation system for database design","volume":"2","author":"Storey","year":"1990","journal-title":"Expert Systems Rev."},{"issue":"3","key":"10.1016\/0169-023X(95)00035-Q_BIB73","doi-asserted-by":"crossref","first-page":"305","DOI":"10.1145\/44498.45064","article-title":"A methodology for creating user views in database design","volume":"13","author":"Storey","year":"1988","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB74","series-title":"On Knowledge Base Management Systems: Integrating Artificial Intelligence and Database Technologies","first-page":"339","article-title":"Knowledge-based systems: A survey","author":"Szolovits","year":"1986"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB75","series-title":"The Eighth Int. Conf. on E-R Approach","article-title":"An expert system for conceptual data modelling","author":"Tauzovich","year":"1989"},{"year":"1982","series-title":"Data Models","author":"Tsichritzis","key":"10.1016\/0169-023X(95)00035-Q_BIB76"},{"issue":"2","key":"10.1016\/0169-023X(95)00035-Q_BIB77","doi-asserted-by":"crossref","first-page":"153","DOI":"10.1016\/0169-023X(92)90035-A","article-title":"CONTEXT: A CONstrainT EXplanation Tool","volume":"8","author":"Urban","year":"1992","journal-title":"Data and Knowledge Eng."},{"year":"1983","series-title":"Database Design","author":"Wiederhold","key":"10.1016\/0169-023X(95)00035-Q_BIB78"},{"article-title":"Incorporating Semantic Integrity Constraints in a Database Schema","year":"1992","author":"Yang","key":"10.1016\/0169-023X(95)00035-Q_BIB79"},{"key":"10.1016\/0169-023X(95)00035-Q_BIB80","series-title":"Methodologies for Intelligent Systems","first-page":"379","article-title":"Conceptual schema design: A machine learning approach","author":"Yasdi","year":"1987"}],"container-title":["Data & Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X9500035Q?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X9500035Q?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2025,9,9]],"date-time":"2025-09-09T23:35:26Z","timestamp":1757460926000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0169023X9500035Q"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1996,6]]},"references-count":80,"journal-issue":{"issue":"1","published-print":{"date-parts":[[1996,6]]}},"alternative-id":["0169023X9500035Q"],"URL":"https:\/\/doi.org\/10.1016\/0169-023x(95)00035-q","relation":{},"ISSN":["0169-023X"],"issn-type":[{"type":"print","value":"0169-023X"}],"subject":[],"published":{"date-parts":[[1996,6]]},"assertion":[{"value":"Elsevier","name":"publisher","label":"This article is maintained by"},{"value":"Semantic integrity constraints in knowledge-based database design systems","name":"articletitle","label":"Article Title"},{"value":"Data & Knowledge Engineering","name":"journaltitle","label":"Journal Title"},{"value":"https:\/\/doi.org\/10.1016\/0169-023X(95)00035-Q","name":"articlelink","label":"CrossRef DOI link to publisher maintained version"},{"value":"converted-article","name":"content_type","label":"Content Type"},{"value":"Copyright \u00a9 1996 Published by Elsevier B.V.","name":"copyright","label":"Copyright"}]}}