Re: A Query about Distributed Database

On Thu, 17 Mar 2005 02:33:31 -0800, Sameer wrote:

> Hello,
> This is an assignment related to Distributed Databases.
>
> Create a global conceptual schema Emp(Eno;Ename;Address;Email;Salary)
> and insert 10 records.
> Divide Emp into vertical fragments Emp1(Eno;Ename;Address) and
> Emp2(Eno;Email;Salary) on two different nodes and fire a query, find
> the salary of an employee where employee number is known.
>
> Please explain me the terms vertical fragments and nodes.
> Do we need two different Oracle Servers for this?
> Please give the general steps for the same.
> -Sameer

There is a wonderful document called the Oracle Concepts manual at http://tahiti.oracle.com that provides background info. (Hint - check the index) Received on Thu Mar 17 2005 - 06:18:06 CST