|
|
||||
|
Unrestricted Use of Command Language on Relations (e.g. SQL) | -> | Controlled Access to Relations | -> | Uncontrolled Access to Objects | -> | Secure and Controlled Access to Object Views |
Low | <--- | Increasing Degree of Application Support An Application Continuum | ---> | High |
Insert | Modify(key) | Delete | |
---|---|---|---|
M-M | Create at least one child | Change matching keys of all children | Delete all children OR reassign all children |
M-O | OK | Change matching keys of all children | Delete all children OR Reassign all children |
O-M | Insert new child OR Appropriate child exists | Change key of at least one child OR Appropriate child exists | OK |
O-O | OK | OK | OK |
Insert | Modify(key) | Delete | |
---|---|---|---|
M-M | Parent Exists OR Create parent | Parent with new value exists (or create one) AND Sibling exists | Sibling exists |
M-O | Parent Exists OR Create parent | Parent with new value exists OR Create parent | OK |
O-M | OK | Sibling exists | Sibling exists |
O-O | OK | OK | OK |