On the design and maintenance of optimized relational representations of entity-relationship schemas

0
133

Authors: Alberto H. F. Laender, Luiz Tucherman, Marco A. Casanova

Tags: 1993, conceptual modeling

A method for obtaining optimized relational representations of database conceptual schemas in an extended entity-relationship model is first proposed. The method incorporates and generalizes a familiar heuristics to obtain good relational representations and also produces, for each relational structure, an explanation indicating which concepts it represents. Then, a redesign method that, given changes to the conceptual schema, generates a plan to modify the original representation and to organize the database state is described.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X01073/1-s2.0-0169023X9390043O/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIBA6xKSJQcm0B93A1Vhb62mnXeK8GiweRKnMDNgUc2uLAiEAyicA3joD%2BQ%2BphSZV81%2BRUuDamxwWwamy3DnMFFpPEJAqvQMI9P%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgwwNTkwMDM1NDY4NjUiDLPlIvgnhABEtn%2BR%2FiqRA7z01FRUw%2BzMqqLeT4S9cGQyPX2gbuQX7BCDMYbQOYBbnyiaF%2F18eX%2Fef6atVwndCfkDu%2Ft2%2FYTcyYdgOn9MKSoovma6wKbdxXqv0zakwyCLF51BTT4hm5hlgGFlfyRvfGLcChwilaz41w39ad%2FpiWgzm63SXUAEAPaCWfKxyuHB7zndD2IFUVBz2PmH8pEcG7LWtXQlphHlJMDsCTUZM7qzSKt%2Bp8uYK4ogv4DaIAqs2T4vWUhNQubOyvP%2Bc22DFicbfB0g6ZGIt1%2BMSdGW8UfEqFArWcMde68eew3RK0WshsPXE3WYKfExnDO2Z6qo1KeTJtTz3QBXBgqL0RjqjYuNqKelkrFoRKB13xOEfjmFu3I4D3%2FhiBnoo1xzSCcHKBk2Q1fwYfwI12yLJu8b2HFrVguZyqrA9ijWYIsu2rTG3p2s%2FXHpEGSFmAp%2BQUgmB4Ud1PWqvvgcRHROT6um2hb8BAcBC%2BQNJfuHc6tEHYoJBDardLxYxfns2uCAMgxNV42ErA2IKQamkI6gN1QJI5t7MNfw8vsFOusB51UWt%2B3CZoWJWvPzp73egsAqYnEj0iVNLDprMwBarSFpIYlZt%2F2s9%2BVF6DUzvdxtWpoCPbFABjnLBF3hQ52%2Bi0gP6behoupbS7fRfeWPO2420akCcmIzuN0PvV6z21CplJz4Pnptjkis%2BTbUKojUxuG9xOkdolrpGG0ie1Mw219bETszInjHZLgD0N2VwqPMBImEnY1KUKCBMjQAUjvHNw7s25qQplz8cPQezahrL6WdPhVqc1WTn6KDb6KKyqZj%2B9jX7oc845729WVPeOGVKvnT1wgLRTzQ5%2FF554EEs3psIvNH0eWUj6FBjQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T191541Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYSU6LDHUX%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=f8ae325d4273a03ae2a170ebffdb45ccb0752eaa765950fdd8b5e2ced737595c&hash=bcfa4853937261e348f5f1602a5098ca7a2d0f207afc00227527bbf6fda54a17&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X9390043O&tid=spdf-3c419183-9f42-4aa2-90f6-10c9ecb4731b&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client