Modeling relationships in object-relational databases

0
126

Authors: Christian Soutou

Tags: 2001, conceptual modeling

We propose an approach for designing an object-relational database. We inspect each case of semantic relationships (one-to-one, one-to-many, many-to-many and n-ary). For each of these cases we list the di€erent solutions for implementation and propose some solutions. We also make a comparison with the relational data model. Our results can be applied to current RDBMS including object extensions (Oracle8, DB2-IBM, Informix…).

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X00559/1-s2.0-S0169023X00000355/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEI%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJGMEQCIDoePtyplb%2F%2FAm9IDp1iO2eSsLlRrvhVs%2BLN8CT6vJmEAiAxTh34CPzEjGhj8UR%2BnPZUv1fHke23LWwHqtnK%2F3iFAiq9Awio%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDA1OTAwMzU0Njg2NSIMnzhuyZwGQAsbCH4hKpEDxQUivEIQcPmhmW3VMNOnZ%2BbowwdPrZHxLcVlCwWvCRnmTLWJDx9coqPkFusJDQIprRUMo9sunjzkrucqgDVVypH2sw0NyaQVjELQIcwASAhV8h4nP8I5GV%2Bs3Fv2Rh6efrPyOXMTGEQb3rGXbtHF9vCxUXZT90o%2BSAk%2F2R8oGUBziipU3%2F%2Facv0egIt1Mps7YeACDGqZ5gdKTyJo4TjAo4Su%2FzQMlVO68xaSvQkssoSP1aoeJ9KRbKmnsfWOL%2Boz4magWMqLOfsDwFsbkqaIucMPV6z1gE8CWD4BGGu7yvbQTfAjbto9JtC%2B5XtcbfxLS3aMBXN7X4i3tPiTDDSoyNDsaKafwAzLzBI4lh2QY5cvpRMIV0XKUI5A0fXC8jKtnXX4dL9XP3x1HJcj7gCbh7PHLNtMbNHhQcpwvKzoSO%2FoeLQHYbIBJB2rgaFjlAuwFpSOO6rUkX%2FbJbOIbDf172seUJwuiDfNLu9dEDnoDh0hL%2BXeaD6kBicuZPINLLqQIqS5MoEC1QtTb3PsM8icd74wjsSt%2BwU67AE56qOhn0QDfjP7BgTAi7Dx1HAkZbddTf1CLlReO%2Bh7mbaGRCvkHwxrggEy%2BR5WHipZFH9NWq5inminqmO9V4PMBunqrB2VRqmyg6Y5yHwkZumNWULfegkhCP9xXg%2BlTpbffNk%2FI%2FZIHmbgkasdR1GjHyDNa0j9%2BB4tEf3lndYge080yN0saCArypaJM9PVXj%2FVZqW2p12bx4XS8yy2X752QCJQDiRk99c%2FZ8ZJe4AZLFlt0Mb9S5bG%2Bwnw7UX2UOwBRelFT4h5nJ%2BRK64sHVkYCkk9YglXadAQiAy3Yc3AfgKbBlQIGlvMDe1v%2Fw%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200923T151223Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYWIUNCMXT%2F20200923%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=eb23cf1623f416b582cd6bf3f5979018963ebdbfa3109b94ca9d53174081c211&hash=45e8bcd3b2e6a355a385eb2e34b27b37c144200e91a50998b7a0c365b09c1f0b&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=S0169023X00000355&tid=spdf-a7767bbf-3306-4843-be9e-8fb0cd8bb319&sid=1f5c30f079ceb643ef78a73-06e4b573fde2gxrqa&type=client