{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,1]],"date-time":"2025-10-01T15:49:58Z","timestamp":1759333798959,"version":"build-2065373602"},"reference-count":57,"publisher":"Elsevier BV","issue":"1","license":[{"start":{"date-parts":[[1996,12,1]],"date-time":"1996-12-01T00:00:00Z","timestamp":849398400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[1996,12,1]],"date-time":"1996-12-01T00:00:00Z","timestamp":849398400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/legal\/tdmrep-license"},{"start":{"date-parts":[[1998,5,19]],"date-time":"1998-05-19T00:00:00Z","timestamp":895536000000},"content-version":"vor","delay-in-days":534,"URL":"http:\/\/creativecommons.org\/licenses\/by-nc-nd\/4.0\/"}],"content-domain":{"domain":["elsevier.com","sciencedirect.com"],"crossmark-restriction":true},"short-container-title":["Data &amp; Knowledge Engineering"],"published-print":{"date-parts":[[1996,12]]},"DOI":"10.1016\/s0169-023x(96)00022-5","type":"journal-article","created":{"date-parts":[[2003,4,4]],"date-time":"2003-04-04T19:18:15Z","timestamp":1049483895000},"page":"57-77","update-policy":"https:\/\/doi.org\/10.1016\/elsevier_cm_policy","source":"Crossref","is-referenced-by-count":21,"title":["A framework for the design and evaluation of reverse engineering methods for relational databases"],"prefix":"10.1016","volume":"21","author":[{"given":"Roger H.L.","family":"Chiang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Terence M.","family":"Barron","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Veda C.","family":"Storey","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/S0169-023X(96)00022-5_BIB1","series-title":"Entity-Relationship Approach\u2014ER'94: Business Modelling and Re-Engineering","first-page":"403","article-title":"Extracting an entity relationship schema from a relational database through reverse engineering","author":"Andersson","year":"1994"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB2","series-title":"Proc. AAAI-93 Workshop on Knowledge Discovery in Databases","first-page":"138","article-title":"Inferring approximate functional dependencies from example data","author":"Akutsu","year":"1993"},{"year":"1987","author":"Awong","article-title":"Schema mapping from the relational and hierarchical models to the Entity-Category-Relationship model","key":"10.1016\/S0169-023X(96)00022-5_BIB3"},{"issue":"1","key":"10.1016\/S0169-023X(96)00022-5_BIB4","doi-asserted-by":"crossref","first-page":"51","DOI":"10.1287\/isre.6.1.51","article-title":"Designing Information systems to optimize the accuracy-timeliness tradeoff","volume":"6","author":"Ballou","year":"1995","journal-title":"Information Syst. Res."},{"year":"1992","author":"Batini","series-title":"Conceptual database design: An Entity-Relationship approach","key":"10.1016\/S0169-023X(96)00022-5_BIB5"},{"issue":"4","key":"10.1016\/S0169-023X(96)00022-5_BIB6","doi-asserted-by":"crossref","first-page":"272","DOI":"10.1145\/320493.320489","article-title":"Synthesizing third normal form relations from functional dependencies","volume":"1","author":"Bernstein","year":"1976","journal-title":"ACM Trans. Database Syst."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB7","series-title":"Proc. Second Working Conf. on Reverse Engineering","first-page":"116","article-title":"Observed idiosyncracies of relational database designs","author":"Blaha","year":"1995"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB8","series-title":"Proc. Eleventh Int. Conf. on Very Large Databases","first-page":"82","article-title":"Database design tools: An expert system approach","author":"Bouzeghoub","year":"1985"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB9","series-title":"Proc. Sixth Int. Workshop on Computer Aided Software Engineering\u2014CAISE'94","first-page":"50","article-title":"The reverse engineering of relational databases","author":"Campbell","year":"1994"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB10","series-title":"Proc. Third Int. Conf. on Entity-Relationship Approach","first-page":"265","article-title":"Designing Entity-Relationship schemes for conventional information systems","author":"Casanova","year":"1983"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB11","series-title":"Proc. Fifth Int. Conf. on Database and Expert Systems Applications\u2014DEXA'94","first-page":"125","article-title":"Semantically enrichment relational databases into an object-oriented semantic model","author":"Castellanos","year":"1994"},{"volume":"5","year":"1993","series-title":"Special Issue on Learning and Discovery in Knowledge-Based Databases","key":"10.1016\/S0169-023X(96)00022-5_BIB12"},{"issue":"1","key":"10.1016\/S0169-023X(96)00022-5_BIB13","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 Trans. Database Syst."},{"year":"1993","author":"Chiang","article-title":"Reverse engineering of relational databases: Extraction of domain semantics","key":"10.1016\/S0169-023X(96)00022-5_BIB14"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB15","series-title":"Proc. 12th Int. Conf. on Entity-Relationship Approach","first-page":"336","article-title":"Performance evaluation of reverse engineering relational databases into Extended Entity-Relationship models","author":"Chiang","year":"1993"},{"issue":"2","key":"10.1016\/S0169-023X(96)00022-5_BIB16","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 Knowledge Eng."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB17","series-title":"Proc. 1995 IEEE Annual Int. Engineering Management Conf.","first-page":"185","article-title":"Quality issues in database reverse engineering: An overview","author":"Chiang","year":"1995"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB18","doi-asserted-by":"crossref","first-page":"13","DOI":"10.1109\/52.43044","article-title":"Reverse engineering and design recovery: A taxonomy","author":"Chikofsky","year":"1990","journal-title":"IEEE Software"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB19","series-title":"Entity-Relationship Approach","first-page":"271","article-title":"Converting a relational database model into an Entity-Relationship model","author":"Davis","year":"1988"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB20","series-title":"Entity-Relationship Approach to Information Modelling and Analysis","first-page":"339","article-title":"Schema translation using the Entity-Relationship approach","author":"Dumpala","year":"1981"},{"year":"1994","author":"Elmasri","series-title":"Fundamentals of Database Systems","key":"10.1016\/S0169-023X(96)00022-5_BIB21"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB22","series-title":"Proc. Sixth Int. Conf. on Data Engineering","first-page":"76","article-title":"A temporal model and query language for ER databases","author":"Elmasri","year":"1990"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB23","series-title":"Entity-Relationship Approach: The Core of Conceptual Modeling","first-page":"239","article-title":"Semantics of temporal data in an extended ER model","author":"Elmasri","year":"1991"},{"issue":"3","key":"10.1016\/S0169-023X(96)00022-5_BIB24","doi-asserted-by":"crossref","first-page":"213","DOI":"10.1016\/0169-023X(95)00006-E","article-title":"A survey of database design transformations based on the Entity-Relationship model","volume":"15","author":"Fahrner","year":"1995","journal-title":"Data Knowledge Eng."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB25","series-title":"Proc. Fourth Int. Conf. on Entity-Relationship Approach","first-page":"280","article-title":"Modeling the time dimension in an Entity-Relationship diagram","author":"Ferg","year":"1985"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB26","series-title":"Advanced Information Systems Engineering","first-page":"463","article-title":"An approach to eliciting the semantics of relational databases","author":"Fonkam","year":"1992"},{"year":"1985","author":"Goldtein","series-title":"Database Management and Technology","key":"10.1016\/S0169-023X(96)00022-5_BIB27"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB28","series-title":"Proc. Tenth Int. Conf. on Entity-Relationship Approach","first-page":"643","article-title":"Entity-generating schema transformation for Entity-Relationship models","author":"Hainaut","year":"1991"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB29","series-title":"Proc. Tenth Int. Conf. on Entity-Relationship Approach","first-page":"729","article-title":"Database reverse engineering: Models, techniques and strategies","author":"Hainaut","year":"1991"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB30","series-title":"Proc. IEEE Working Conf. on Reverse Engineering","first-page":"161","article-title":"Contribution to a theory of database reverse engineering","author":"Hainaut","year":"1993"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB31","series-title":"Proc. Second Working Conf. on Reverse Engineering","first-page":"136","article-title":"Requirements for information system reverse engineering support","author":"Hainaut","year":"1995"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB32","series-title":"Proc. Tenth Int. Conf. on Entity-Relationship Approach","first-page":"231","article-title":"An algorithm converting relational schemas to nested Entity-Relationship schemas","author":"Ji","year":"1991"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB33","series-title":"Proc. Tenth Int. Conf. on Data Engineering","first-page":"190","article-title":"A method for transforming relational schemas into conceptual schemas","author":"Johannesson","year":"1994"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB34","series-title":"Proc. Eighth Int. Conf. on Entity-Relationship Approach","first-page":"279","article-title":"A method for translating relational schema into conceptual schemas","author":"Johannesson","year":"1989"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB35","series-title":"Proc. Third Int. Conf. on Advanced Information Systems Engineering","first-page":"393","article-title":"Implementation and critique of an algorithm which maps a relational database to a conceptual model","author":"Kalman","year":"1991"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB36","doi-asserted-by":"crossref","first-page":"591","DOI":"10.1002\/int.4550070703","article-title":"Discovering functional and inclusion dependencies in relational databases","volume":"7","author":"Kantola","year":"1992","journal-title":"Int. J. of Intell. Syst."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB37","series-title":"Proc. Fourth Int. Conf. on Database Theory, ICDT92","first-page":"86","article-title":"Approximate dependency inference from relations","author":"Kivinen","year":"1992"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB38","series-title":"Proc. Sixth British National Conf. on Databases","first-page":"161","article-title":"From database systems to multidatabase systems: Why and how","author":"Litwin","year":"1988"},{"year":"1992","author":"Mannila","series-title":"The Design of Relational Databases","key":"10.1016\/S0169-023X(96)00022-5_BIB39"},{"issue":"8","key":"10.1016\/S0169-023X(96)00022-5_BIB40","doi-asserted-by":"crossref","first-page":"777","DOI":"10.1109\/32.57618","article-title":"Identifying Extended Entity-Relationship object structures in relational schemas","volume":"16","author":"Markowitz","year":"1990","journal-title":"IEEE Trans. Software Engrg."},{"issue":"9","key":"10.1016\/S0169-023X(96)00022-5_BIB41","doi-asserted-by":"crossref","first-page":"112","DOI":"10.1145\/130994.131001","article-title":"Evolution of data modeling for databases","volume":"35","author":"Navathe","year":"1992","journal-title":"Commun. ACM"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB42","series-title":"Entity-Relationship Approach","first-page":"305","article-title":"Abstracting relational and hierarchical data with a semantic data model","author":"Navathe","year":"1988"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB43","doi-asserted-by":"crossref","first-page":"147","DOI":"10.1016\/0020-0255(89)90026-1","article-title":"A temporal relational model and a query language","volume":"49","author":"Navathe","year":"1989","journal-title":"Information Sci."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB44","doi-asserted-by":"crossref","first-page":"51","DOI":"10.1109\/64.54673","article-title":"Validating expert systems","author":"O'Leary","year":"1990","journal-title":"IEEE Expert"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB45","series-title":"Entity-Relationship Approach\u2014ER'94: Business Modelling and Re-Engineering","first-page":"369","article-title":"Using queries to improve database reverse engineering","author":"Petit","year":"1994"},{"year":"1991","author":"Piatetsky-Shapiro","series-title":"Knowledge Discovery in Databases","key":"10.1016\/S0169-023X(96)00022-5_BIB46"},{"issue":"5","key":"10.1016\/S0169-023X(96)00022-5_BIB47","doi-asserted-by":"crossref","first-page":"42","DOI":"10.1145\/175290.175293","article-title":"An approach for reverse engineering of relational databases","volume":"37","author":"Premerlani","year":"1994","journal-title":"Commun. ACM"},{"year":"1991","author":"Rumbaugh","series-title":"Object-Oriented Modeling and Design","key":"10.1016\/S0169-023X(96)00022-5_BIB48"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB49","series-title":"Proc. IEEE Working Conf. on Reverse Engineering","first-page":"144","article-title":"Challenges to the field of reverse engineering","author":"Selfridge","year":"1993"},{"issue":"3","key":"10.1016\/S0169-023X(96)00022-5_BIB50","doi-asserted-by":"crossref","first-page":"293","DOI":"10.1016\/0169-023X(93)90033-L","article-title":"Database reverse engineering: from the relational to the binary relationship model","volume":"10","author":"Shoval","year":"1993","journal-title":"Data Knowledge Eng."},{"key":"10.1016\/S0169-023X(96)00022-5_BIB51","series-title":"Proc. IEEE Third Workshop on Program Comprehension","first-page":"128","article-title":"Using procedural patterns in abstracting relational schemata","author":"Signore","year":"1994"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB52","series-title":"Entity-Relationship Approach\u2014ER'94: Business Modelling and Re-Engineering","first-page":"387","article-title":"Reconstruction of ER schema from database applications: A cognitive approach","author":"Signore","year":"1994"},{"issue":"9","key":"10.1016\/S0169-023X(96)00022-5_BIB53","doi-asserted-by":"crossref","first-page":"35","DOI":"10.1109\/MC.1986.1663327","article-title":"Temporal databases","volume":"19","author":"Snodgrass","year":"1986","journal-title":"IEEE Computer"},{"key":"10.1016\/S0169-023X(96)00022-5_BIB54","series-title":"Proc. Int. Conf. on Databases, Parallel and Their Applications","first-page":"438","article-title":"Reverse engineering of ER-designed relational schemas","author":"Springstell","year":"1990"},{"issue":"2","key":"10.1016\/S0169-023X(96)00022-5_BIB55","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 Surveys"},{"issue":"4","key":"10.1016\/S0169-023X(96)00022-5_BIB56","doi-asserted-by":"crossref","first-page":"623","DOI":"10.1109\/69.404034","article-title":"A framework for analysis of data quality research","volume":"7","author":"Wang","year":"1995","journal-title":"IEEE Trans. Knowledge Data Eng."},{"issue":"4","key":"10.1016\/S0169-023X(96)00022-5_BIB57","doi-asserted-by":"crossref","first-page":"5","DOI":"10.1080\/07421222.1996.11518099","article-title":"Beyond accuracy: What data quality means to data consumers","volume":"12","author":"Wang","year":"1996","journal-title":"J. Management Information Syst."}],"container-title":["Data &amp; Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X96000225?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0169023X96000225?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2025,9,30]],"date-time":"2025-09-30T00:16:00Z","timestamp":1759191360000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0169023X96000225"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1996,12]]},"references-count":57,"journal-issue":{"issue":"1","published-print":{"date-parts":[[1996,12]]}},"alternative-id":["S0169023X96000225"],"URL":"https:\/\/doi.org\/10.1016\/s0169-023x(96)00022-5","relation":{},"ISSN":["0169-023X"],"issn-type":[{"type":"print","value":"0169-023X"}],"subject":[],"published":{"date-parts":[[1996,12]]},"assertion":[{"value":"Elsevier","name":"publisher","label":"This article is maintained by"},{"value":"A framework for the design and evaluation of reverse engineering methods for relational databases","name":"articletitle","label":"Article Title"},{"value":"Data & Knowledge Engineering","name":"journaltitle","label":"Journal Title"},{"value":"https:\/\/doi.org\/10.1016\/S0169-023X(96)00022-5","name":"articlelink","label":"CrossRef DOI link to publisher maintained version"},{"value":"converted-article","name":"content_type","label":"Content Type"},{"value":"Copyright \u00a9 1997 Published by Elsevier B.V.","name":"copyright","label":"Copyright"}]}}