Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!apple!oliveb!amdahl!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: Re: question about ingres star
Message-ID: <3185@rtech.rtech.com>
Date: 13 Jul 89 13:17:43 GMT
References: <25638@shemp.CS.UCLA.EDU>
Sender: news@rtech.rtech.com
Reply-To: robf@squid.UUCP (Robert Fair)
Distribution: usa
Organization: Relational Technology, Inc.
Lines: 36

[User has problem createing a Star database on multiple sites]

Setting  up a multiple-site database should be pretty simple  if you
remember that a Star database links together multiple local databases.
The following procedure should work:

1: Create local databases on each of your remote sites
2: Create a STAR database on your coordinator node
3: Create tables. This can be done in one of  two ways:
   - Globally, through STAR
   - Locally, then create a link in STAR

To create tables globally in Star:
- Go into the Star database
- CREATE the  table, specifying node & database:

	CREATE TABLE mytbl (...)
	WITH NODE=ipswich, DATABASE=mydbname

If you leave  off the NODE/DATABASE Star will create the table in the
coordinator database, which sounds like the problem the user had.

To create tables locally and link in Star:
- Access each local database through INGRES/NET
- CREATE the table (or for a gateway IMPORT/REGISTER the table)
- Go into the Star database
- CREATE a LINK to the local table [or in INGRES 6.2 terminology REGISTER
  the table as a link].

The global method is simpler when the local DBMS is INGRES, while
the local CREATE + LINK provides more flexibility for gateways and 
non-relational systems. 

Robert Fair
Technical Support
Relational Technology, Inc