Information Technology Reference
In-Depth Information
Method class
Method_
Name
Class_
name
Parameter
Seq_no
Condition
Action
Description
Delete_X
X
@A 1 , @
A 2 , @A 3
Delete from Z
where A 3 = @A 3
Delete from Y
where A 2 = @A 2
Delete from X
where A 1 = @A 1
Insert_X
X
@A 1 , @
A 2 , @A 3
If ((Select * from
Y where A 2 = @
A 2 ) < > Null)
AND ((Select
* from Z
where A 3 = @
A 3 ) < > Null)
Insert X (@A 1 ,
@A 2 , @A 3 )
7.4
Case Study of Object-Relational Schemas Integration
In a bank, there are existing databases with different schemas: one for the local
mortgage customers, another for overseas banking customers, and one for local
car loan customers. They are used by various applications in the bank. However,
there is a need to integrate them for an international banking loan system. Assume
the schema integration has to be done in both the relational representation as well
as the OO representation. The following are the input schemas and final integrated
schema for both models followed by the one frame model metadata representing the
integrated schema of both models (Figs. 7.21 and 7.22 ).
7.4.1
Frame Model Metadata
Header class
Class name
Parents
Primary key
Operation
Class type
Customer
0
Cust_ID
Call Del_Cust
Static
Local Customer
Customer
Cust_ID
Call Ins_Local,
Del_Local
Active
Oversea Customer
Customer
Cust_ID
Call Ins_Overseas
Static
Car Loan Customer
Local Customer
Cust_ID
Active
Home Loan Customer
Local Customer
Cust_ID
Active
Car Loan
Loan_Contract #
0
Static
Mortgage
Loan_Contract #
0
Static
 
Search WWH ::




Custom Search