Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a SIMPLE distributed database?

Status
Not open for further replies.

oracle70

MIS
Sep 12, 2003
15
LK
Hi,

I would be very grateful if anyone could help me with the following. I want to create a SIMPLE distributed database. It is as follows

There is a institution which has branches all over the country offering various courses.
I want to horizontally fragment the following table and place each fragment in each branch.

COURSE (cno, branch, cname, lecturer)

I have 2 databases, one in Windows NT and the Other in HP-UX. How do I created the GLOBAL schema? How do I create the LOCAL schema?

Also if I want to replicate the cno and name in each branch for improvement of queries, how can I achive this?

Thanks & Regards,
Francis.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top