Introducing Ingres Star

This guide describes how to implement and use Ingres® Star and its related facilities.

Next Topic

Ingres Star

Ingres Ingres Star (formerly Ingres Distributed Option) is a distributed data manager that adds to Ingres a distributed relational database management system capability, which includes distributed access, storage, and processing. You can include multiple hardware and operating systems (mainframe, mid-range, and desktop) and database management systems in this distributed system.

With Ingres Star, you can combine many separate databases into a single view of your data, which you can access just as you would any single, local database. If you install Ingres Net and the Enterprise Access products along with Ingres Star, you get transparent, simultaneous access across multiple nodes, hardware platforms, and software configurations by means of multiple network communication protocols.

Next Topic

Audience

This guide is addressed to two levels of Ingres users:

Next Topic

Query Languages

This guide uses the industry standard query language, SQL. QUEL is not supported in Ingres Star.

Next Topic

Installation Considerations

The type and location of the databases you wish to access determine which Ingres products you must install.

Next Topic

Setup for Remote Database Access

To work with an Ingres database stored on another computer, the computer on which you are entering commands and the computer that contains the database must be connected by a network. (The computer on which you are entering commands is called the local node and the computer that contains the database is called the remote node.)

To work on an Ingres database on a remote node, the following setup is required:

For additional details, see Define User Authorization to Nodes on the Network.

Next Topic

Command Syntax for Accessing a Distributed Database

The syntax for accessing a distributed database by means of Ingres Star is:

IngresCommand [vnode::]distdbname/server_class

Next Topic

Examples: Accessing Distributed Databases

To open the Ingres Menu and access a distributed database on your local node, type the following command:

ingmenu distdbname/star

The /star parameter signifies the Star server class.

To open the Ingres Menu and access a distributed database on a remote node whose vnode name is paris, type the following command:

ingmenu paris::distdbname/star

In this case, you must specify both the vnode name of the remote node and the Star server class.

Whether the distributed database is on your local node or on a remote node, once you have accessed the database by means of Ingres Star, you can work on the database as if it were a collection of tables in a single Ingres database.


© 2007 Ingres Corporation. All rights reserved.