Relational database reverse engineering: Algorithms to extract cardinality constraints

Authors: Christian Soutou

Tags: 1998, conceptual modeling

This paper presents algorithms which build SQL queries to improve the reverse engineering of relational databases. Our process extracts the current cardinality constraints of n-ary relationships through a combination of data dictionary, data schema and data instance analysis. Our results can be applied to semantic data models with cardinalities constraints based either on the ER model or to semantic data models with cardinality constraints on participation constraints (MERISE, ECR, ERC +, OMT, ODMG). The process we propose can also refine conceptual diagrams of commercial tools with reverse-engineering options (AMC*Designer TM, ORACLE TM Designer 2000, etc.). From our algorithms a PRO*C program using dynamic SQL has been implemented.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X00390/1-s2.0-S0169023X98000172/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEI7%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIQDQZikDuEF3kBRa%2FblxaFiS%2FpikxaT1L2JYV9QftzTY6AIgOJUELeKm2UHHcYoqfkcrZFMd272X5kOzr3GmlXX2MqAqvQMIp%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgwwNTkwMDM1NDY4NjUiDD9LXIJUYaL7qhiyDSqRA8WVqV0ugCEj9lnTN8I%2F%2Biml9gbjV01ONFSjJiaLcPLel1QEguTbgIfJdqPru%2BsCYglc0MOMWwQyMVGjroMde9CnZLYNPnSmZGIQhGqt6m36Vdn%2BTJe7u1lFeaEA77QMrXnJDEgNdD%2FowuoAvvjzQMZFhnbGLcyKYUgDmHU5mAI5CmPxx1hr18%2Fyg49f25pqA%2B37chTS3164bOgeDdZCYocxLireuS3iNKspLe93f6a0dHmJlOkLNvxXTrnvAq%2FU%2BBFlyoeym%2FQpuCJZrC4%2BUabZcJwr9fG7e2%2FMGuMdhcq63i4bNBU4KxJp8vmnR3n6nsp%2BGSaf%2F9l3%2FA%2FoKcc1nW%2Bkc1Wnc21nja2MDxN%2FiNYYG7tQnU7nRLP46GVr%2FTPV3MQFGdgeqL3GFGk4NowBRi1uBT4MgfICMXZt2%2FgP4FgZeLNcn3NBJlvLa7V9hd39NcCcZ3j1%2B9%2BhNuGto5OKrowhsWvzDnzIK%2BdhKZG89A0iZW%2BUz1rufy6w31dluTJfiqjBIx8IxcYdycU3AdfWeha5MPybrfsFOusB%2BIcXO%2Bsef0frsYg4d%2B3PQmN%2BdWbHvwM6KFjPAEyO45KRSueO261EHQKitkyCYgpZR%2B8D1dsR%2Bxwxrmf%2B6Q02EKmqYp%2Boub1sDBRuHSq2frX40H4MKQc8hmjqDrDjyGffYxCChVdwGl9nIVbI7FyEVrcAYaQvgT%2BeFNwui3uNOERzVTGEwr8NPlmaP6SD0TEphLBDjFyvD3do%2F1LURr0Qv3SIidAyAx0Ur7iODS7oJtP%2Fn35I1R14EDp7k6OVt9nhxGzHz7wEnq6tAUbOP5dNluyIdduCbidwVKXDg4SWPpJU8YN%2Bhi1DstmUxQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200923T135354Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTY3JLAJFCZ%2F20200923%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=3dacdae7a665c3f8971757dc7bdef97b6b17dcd01719e137d438138cad34b02f&hash=23c3b4bcbd1309542ffb1bb9528353f1bdc96327486c3e8d50f12afa78b8abcf&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=S0169023X98000172&tid=spdf-24fbafe5-4638-48c7-a6bf-a0b69713ddf8&sid=1f5c30f079ceb643ef78a73-06e4b573fde2gxrqa&type=client