{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,3,29]],"date-time":"2022-03-29T11:20:29Z","timestamp":1648552829178},"reference-count":12,"publisher":"Elsevier BV","issue":"1-3","license":[{"start":{"date-parts":[[1991,6,1]],"date-time":"1991-06-01T00:00:00Z","timestamp":675734400000},"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 Sciences"],"published-print":{"date-parts":[[1991,6]]},"DOI":"10.1016\/0020-0255(91)90005-f","type":"journal-article","created":{"date-parts":[[2003,6,30]],"date-time":"2003-06-30T17:28:37Z","timestamp":1056994117000},"page":"49-67","source":"Crossref","is-referenced-by-count":1,"title":["Usage refinement for ER-to-relation design transformations"],"prefix":"10.1016","volume":"55","author":[{"given":"Toby J.","family":"Teorey","sequence":"first","affiliation":[]},{"given":"Yang","family":"Dongqing","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/0020-0255(91)90005-F_BIB1","series-title":"Methodology and Tools for Data Base Design","first-page":"85","article-title":"Logical design in CODASYL and relational environments","author":"Bertaina","year":"1983"},{"issue":"1","key":"10.1016\/0020-0255(91)90005-F_BIB2","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1145\/320434.320440","article-title":"The entity-relationship model\u2014Toward a unified view of data","volume":"1","author":"Chen","year":"1976","journal-title":"ACM Trans. Database System"},{"key":"10.1016\/0020-0255(91)90005-F_BIB3","volume":"Vol. 1","author":"Date","year":"1986"},{"key":"10.1016\/0020-0255(91)90005-F_BIB4","series-title":"Database Analysis and Design","author":"Hawryszkiewycz","year":"1984"},{"key":"10.1016\/0020-0255(91)90005-F_BIB5","series-title":"Data Analysis and Data Base Design","author":"Howe","year":"1983"},{"issue":"1","key":"10.1016\/0020-0255(91)90005-F_BIB6","first-page":"34","article-title":"Optimizing performance with denormalization","volume":"1","author":"Inmon","year":"1987","journal-title":"Database Programming and Design"},{"issue":"2","key":"10.1016\/0020-0255(91)90005-F_BIB7","doi-asserted-by":"crossref","first-page":"120","DOI":"10.1145\/358024.358054","article-title":"A simple guide to five normal forms in relational database theory","volume":"26","author":"Kent","year":"1983","journal-title":"Comm. ACM"},{"key":"10.1016\/0020-0255(91)90005-F_BIB8","series-title":"Theory of Relational Databases","author":"Maier","year":"1983"},{"key":"10.1016\/0020-0255(91)90005-F_BIB9","series-title":"Proceedings of the AICA 1980 Congress","first-page":"363","article-title":"DENORMALIZATION: A performance oriented database design technique","author":"Schkolnick","year":"1980"},{"key":"10.1016\/0020-0255(91)90005-F_BIB10","series-title":"Design of Database Structures","author":"Teorey","year":"1982"},{"issue":"2","key":"10.1016\/0020-0255(91)90005-F_BIB11","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"},{"key":"10.1016\/0020-0255(91)90005-F_BIB12","first-page":"431","article-title":"Query by example","volume":"Vol. 44","author":"Zloof","year":"1975"}],"container-title":["Information Sciences"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:002002559190005F?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:002002559190005F?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,18]],"date-time":"2019-03-18T13:23:51Z","timestamp":1552915431000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/002002559190005F"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1991,6]]},"references-count":12,"journal-issue":{"issue":"1-3","published-print":{"date-parts":[[1991,6]]}},"alternative-id":["002002559190005F"],"URL":"https:\/\/doi.org\/10.1016\/0020-0255(91)90005-f","relation":{},"ISSN":["0020-0255"],"issn-type":[{"value":"0020-0255","type":"print"}],"subject":[],"published":{"date-parts":[[1991,6]]}}}