Ingres 2006 - Distributed Option User Guide

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Ingres 2006 - Distributed Option User Guide
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Ingres 2006 - Distributed Option User Guide
     Copyright © Ingres Corporation



Chapter 1: Introducing Distributed Option

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

Distributed Option

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 Distributed Option, 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 Distributed Option, you get transparent, simultaneous access across multiple nodes, hardware platforms, and software configurations by means of multiple network communication protocols.

Audience

This guide is addressed to two levels of Ingres users:
  • For end users, this guide explains the concepts of distributed database processing and how Distributed Option provides access to data in multiple local Ingres databases, and to non-Ingres databases through the use of Enterprise Access products.
  • For the system administrator and the database administrator, this guide details how to use and maintain Distributed Option and the catalogs. Individual product guides address installation and maintenance of the Enterprise Access products.

Query Languages

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

Installation Considerations

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

For local data access:
Ingres by itself works with one database at a time on your own computer. Therefore, to access a single database on a single computer, just install Ingres on your local computer.

For remote data access:
When your computer is part of a network, Ingres Net allows you to access a single database stored on another computer from your local computer. Therefore, to access a database on a remote computer, you must install Ingres Net both on your local computer and the remote computer.
For information, see the System Administrator Guide. For information about using Ingres Net with Distributed Option, see Setup for Remote Database Access (see page 11).

For heterogeneous data access:
The Enterprise Access products allow you to access data stored in non-Ingres databases. Therefore, to access a non-Ingres database, install the appropriate Enterprise Access for that database type. See the guides that are specific to that Enterprise Access.

Note: If the non-Ingres database is on a remote computer, you must also install Ingres Net.

For distributed data access:
Distributed Option gives you access to multiple databases simultaneously. You need not even know where the data you need resides. The other databases and their configurations are invisible to you. You work transparently with Distributed Option distributed database as if it were a single local Ingres database on your own computer.

Combining Distributed Option with Ingres Net gives you access to remote as well as local databases, no matter where those databases are stored on your network.

Combining Distributed Option with Enterprise Access products allows you to access both non-Ingres and Ingres databases, or even several different types of non-Ingres databases. For example, you can create a distributed database that contains Ingres, DB2, and IMS data. By joining them together in a single distributed database, you can perform complex operations such as joins and subselects between DB2 and IMS data that would be very difficult without the use of the Distributed Option.

Combining Distributed Option with Ingres Net and Enterprise Access or EDBC products allows you to access both Ingres and non-Ingres databases simultaneously, anywhere on your network.

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:
  • Ingres Net must be installed on your local node and on each remote node.
  • Either you or the system administrator must use the netutil or ingnet utility to define each remote node that contains a database that you want to access. Defining a remote node gives it a vnode (virtual) name. From then on, you need only specify the vnode name of the remote node and the name of the database. Net handles the details of gaining access to the remote node.
  • Distributed Option users must be authorized on the local node as well as each remote node they wish to access, unless installation passwords are used. This authorization is also done through the netutil or ingnet utility. Use netutil or ingnet on your local node to define your login authorization to your account on the remote node. (Alternatively, the system administrator must define your access to a public guest account on that remote node).
Note: You need to define authorization to your account on a remote node only once. Your authorization remains until you delete it.
If installation passwords are used, the installation password of a remote node must be entered with netutil or ingnet.