Database Reference
In-Depth Information
DATA
VIEW-1
DATA
VIEW-2
DATA
VIEW-3
PARTIAL
DATA
MODEL-1
PARTIAL
DATA
MODEL-2
PARTIAL
DATA
MODEL-3
Method 2: Integrate
Partial Data Models
FINAL
DATA
MODEL
MERGED
DATA
VIEWS
Method 1: Merge Individual User Views
Figure 5-14
View integration: two approaches.
Savings Acct
Data View
CustName
CustAddr
CustPhone
SavingsAcctNo
SavBalance
InterestRate
Merged
Data Views
CustName
CustAddr
CustPhone
SavingsAcctNo
SavBalance
InterestRate
ChkAcctNo
ChkBalance
Overdraft
Checking Acct
Data View
CustName
CustAddr
CustPhone
ChkAcctNo
ChkBalance
Overdraft
CustAddr
CustPhone
CustName
CUSTOMER
CHECKING
ACCOUNT
AcctNo
ChkBalance
SAVINGS
ACCOUNT
AcctNo
SavBalance
Overdraft
InterestRate
FINAL MODEL
Figure 5-15
Merging individual user views.
8. Indicate how an instance of each object will be uniquely identified.
9. Create complete or global data model from the complete set of objects and
relationships.
Figure 5-15 describes the approach of merging individual user views for a banking
example. Notice how each task is indicated and how the tasks work together to
produce the final, global data model.
Search WWH ::
Custom Search