[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Europe-Swas-Artificial-Intelligence |
|
| Moderator: | HERON::BUCHANAN |
|
| Created: | Fri Jun 03 1988 |
| Last Modified: | Thu Aug 04 1994 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 442 |
| Total number of notes: | 1429 |
134.0. "RdbExpert!!~!!" by HERON::ROACH (TANSTAAFL !) Mon Sep 18 1989 01:37
Ran across this and thought that you might find it as interesting as I
did.
Pat
8888888888888888888888888888888888888888888888888888888888888888888888
<<< SELECT::LIB$1:[NOTES$LIBRARY]EMBEDDED_AI.NOTE;2 >>>
-< EMBEDDED AI >-
================================================================================
Note 4.0 RdbExpert No replies
KORAL::TURNER "MALLET::TURNER or DTN 768-5411" 867 lines 5-SEP-1989 10:06
--------------------------------------------------------------------------------
From Mike O'Connell via Richard Stow (of DEC UK):
..................................................
Here is the preliminary SPD for DEC RdbExpert. Please mail me with any
questions. We will be going into field test with it in October and shipping
next spring.
Regards,
Mike
SOFTWARE PRODUCT DESCRIPTION
PRODUCT NAME: DEC RdbExpert Version 1.0 SPD: <xx.xx.xx>
DESCRIPTION
DEC RdbExpert is a DECwindows based expert database design tool which produces
optimal VAX Rdb/VMS and VAX DBMS physical storage designs. It is intended for
use by Database Designers and Administrators during the design and redesign
phase of database development.
DEC RdbExpert bases its design recommendations on the logical schema as found
in the database root file and on transaction workload information. The
workload information can be provided via the DECwindows user interface, the
command line interface, or, in an automated fashion, through the use of
DECcollector. VAX DBMS V4.1 and VAX Rdb/VMS V3.1 have the ability, using
DECcollector, to log transaction workload data to be captured for subsequent
import into the DEC RdbExpert design process.
DEC RdbExpert supports all the physical DDL features of VAX Rdb/VMS V3.1 and
VAX DBMS V4.1. It produces SQL output for VAX Rdb/VMS and the Schema and
Storage Schema for VAX DBMS, along with creation parameters for both database
products. DEC RdbExpert has knowledge of the VAX Rdb/VMS runtime optmizer
heuristics and provides recommendations which result in the greatest runtime
performance.
FEATURES
Using DEC RdbExpert a database designer/administrator can:
^ Reverse engineer VAX Rdb/VMS and VAX DBMS database schemas into the DEC
RdbExpert design database.
^ Enter the database transaction workload information by one of the following
methods:
o Manually, through a text file containing the SQL like Workload
Definition Language (WDL).
o Automatically, using workload information captured by DECcollector.
^ Enter the database volume and occurrence information by one of the
following methods:
o Manually, via the DECwindows interface.
o Automatically via a DBO/ANALYZE.
^ View and edit the workload information applying qualifiers such as
importance and certainty.
^ Define hardware constraints for the target database environment.
^ Provide a graphical directory to maintain multiple designs, each with one or
more physical design associated with it.
^ Generate the design report which presents the reasons for the recommended
parameters and database designs.
^ Create optimal VAX Rdb/VMS physical designs consisting of SQL DDL and
creation and run time parameters.
o Hash and index key fields
o Index node size
o B-tree size predictions
o Record placement
o Record clustering
o Storage area
o Area allocation
o Storage map
o Page format
o Page size
o Buffer size
o Record area assignment
o Area allocation
o Area device allocation
o Area expansion
o Space managment
o Thresholds
o Buffer size
o Number of buffers
o Adjustable locking
o Snapshot file allocation
o Snapshot file device allocation
o Snapshot enable/disable
o Snapshot immediate/deferred
o Snapshot file extension
^ Create optimal VAX DBMS physical designs consisting of the modified Schema,
Storage Schema, and creation and run time parameters. The VAX DBMS
recommendations include:
o Set mode
o Index node size
o B-tree size
o Set order
o Record placement
o Record clustering
o OCCURS clause
o DYNAMIC items
o UNIQUE clause
o Record area assignments
o Area allocation
o Area device allocation
o Page size
o Area expansion parameters
o Space managment pages
o Threshold values
o Buffer size
o Number of buffers
o Adjustable locking
o Duplicates positioning
o Set insertion
o Snapshot file allocation
o Snapshot file device allocation
o Snapshot enable/disable
o Snapshot file extension
^ Create load sequence information to optimize the loading of data into the
redesigned databases.
HARDWARE REQUIREMENTS
VAX, MicroVAX, or VAXstation configuration as specified in the System Support
Addendum (SSA <xx.xx.xx>-X).
SOFTWARE REQUIREMENTS
[Remove references to DECwindows if necessary. Include prerequisite layered
products for each environment if applicable.]
For Systems Using Terminals (No DECwindows Interface):
^ VMS Operating System or MicroVMS Operating System
^ <prerequisite layered product(s)>
For Workstations Running VWS:
^ VMS Operating System or MicroVMS Operating System
^ VMS Workstation Software
^ <prerequisite layered product(s)>
For Workstations Running DECwindows:
^ VMS Operating System (and necessary components of VMS DECwindows)
^ <prerequisite layered product(s)>
Refer to the System Support Addendum (SSA <xx.xx.xx>-X) for availability and
required versions of prerequisite software and for information regarding
components of VMS DECwindows.
COUNTRY COMPONENT SOFTWARE
[Include section only if product has country component software that modified
the base product for a specific country.]
For information on country-specific modifications to this product, refer to the
System Software Addendum.
ORDERING INFORMATION
[Below replace <xxx> with the UPID of the product.]
Software Licenses: QL-<xxx>A*-**
Software Media: QA-<xxx>A*-**
Software Documentation: QA-<xxx>AA-GZ
Software Product Services: QT-<xxx>A*-**
* Denotes variant fields. For additional information on available licenses,
services and media refer to the appropriate price book.
SOFTWARE LICENSING
[Product-specific licensing information, if any, should be inserted here.]
This software is furnished under the licensing provisions of DIGITAL's
Standard Terms and Conditions. For more information about DIGITAL's licensing
terms and policies, contact your local DIGITAL office.
License Management Facility Support
This layered product supports the VMS License Management Facility.
[Select one of the following four statements.]
License units for this product are allocated on a CPU-capacity basis.
[or]
License units for this product are allocated on a User/Activity basis.
[or]
License units for this product are allocated on a CPU-capacity plus
User/Activity basis.
[or]
License units for this product are allocated on a per-CPU basis and are not
dependent on CPU-capacity or User/Activity.
For more information on the License Management Facility, refer to the VMS
Operating System Software Product Description (SPD 25.01.xx) or the License
Management Facility manual of the VMS Operating System documentation set.
For more information about DIGITAL's licensing terms and policies, contact your
local DIGITAL office.
SOFTWARE PRODUCT SERVICES
[Product-specific services information, if any, should be inserted here.]
A variety of service options are available from DIGITAL. For more information,
contact your local DIGITAL office.
SOFTWARE WARRANTY
[Product-specific warranty information, if any, should be inserted here.]
Warranty for this software product is provided by DIGITAL with the purchase of
a license for the product as defined in the Software Warranty Addendum of this
SPD.
<month> <year>
SYSTEM SUPPORT ADDENDUM
PRODUCT NAME: <>, Version <x.x> SSA: <xx.xx.xx-A>
HARDWARE REQUIREMENTS
Processors Supported:
VAX :
VAX 6210, VAX 6220, VAX 6230, VAX 6240, VAX 6310, VAX 6312, VAX 6320, VAX 6330,
VAX 6333, VAX 6340, VAX 6350, VAX 6360, VAX 8200, VAX 8250, VAX 8300, VAX 8350,
VAX 8500, VAX 8530, VAX 8550, VAX 8600, VAX 8650, VAX 8700, VAX 8800, VAX 8810,
VAX 8820, VAX 8830, VAX 8840, VAX 8842, VAX 8974, VAX 8978
VAX-11/730, VAX-11/750, VAX-11/780, VAX-11/785
MicroVAX :
MicroVAX II, MicroVAX 2000, MicroVAX 3300, MicroVAX 3400, MicroVAX 3500,
MicroVAX 3600, MicroVAX 3800, MicroVAX 3900
VAXstation :
VAXstation II, VAXstation 2000, VAXstation 3100, VAXstation 3200,
VAXstation 3500, VAXstation 3520, VAXstation 3540, VAXstation 8000
VAXserver :
VAXserver 3300, VAXserver 3400, VAXserver 3500, VAXserver 3600, VAXserver 3602,
VAXserver 3800, VAXserver 3900, VAXserver 6210, VAXserver 6220, VAXserver 6310,
VAXserver 6320
Processors Not Supported:
[Cut-and-Paste any processors from above that your product does not support
into this section.]
Processor Restrictions
[This section is optional as applicable.]
Other Hardware Required
[This section is optional as needed.]
Block Space Requirements (Block Cluster Size = 1):
Disk space required for installation: <> blocks ( <> bytes)
Disk space required for use (permanent): <> blocks ( <> bytes)
These counts refer to the disk space required on the system disk. The
sizes are approximate; actual sizes may vary depending on the user's system
environment, configuration, and software options.
Memory Requirements for DECwindows Support
The minimum supported memory for this application running in a
standalone DECwindows environment with both the client and server
executing on that same system is <> mb.
[The following optional statement should be included if the product
may require more or less memory depending upon the configuration.]
The performance and memory usage of DECwindows applications are
particularly sensitive to system configuration. Less memory may be
required on the client system (the system where the software is
installed and executed) if the server (the component that displays the
application) resides on another system. More memory may be required
on a system with several applications running or may be desirable to
improve the performance of an application.
[The following optional statement should be used if there is a
significant difference between the minimum supported memory and the
memory recommended for good performance.]
The minimum memory supported is <> mb. However, the use of this
software in conjunction with increased memory capability improves
performance [or some other attributes--fill in if desired]. The
memory size suggested for most typical hardware configurations is at
lease <> mb.
OPTIONAL HARDWARE
[This section is optional as needed.]
CLUSTER ENVIRONMENT
This layered product is fully supported when installed on any valid and
licensed VAXcluster* configuration without restrictions. The MINIMUM HARDWARE
REQUIREMENTS sections of this product's Software Product Description and System
Support Addendum detail any special hardware required by this product.
* V5.x VAXcluster configurations are fully described in the VAXcluster
Software Product Description (29.78.xx) and include CI, Ethernet and Mixed
Interconnect configurations.
SOFTWARE REQUIREMENTS
[Remove reference to DECwindows if necessary. Include prerequisite layered
products for each environment.]
For Systems Using Terminals (No DECwindows Interface):
^ VMS Operating System <Vx.x - Vx.x> or
^ MicroVMS Operating System <Vx.x - Vx.x>
^ <prerequisite layered product(s) and supported version(s)>
For Workstations Running VWS:
^ VMS Operating System <Vx.x - Vx.x> or
^ MicroVMS Operating System <Vx.x - Vx.x>
^ VMS Workstation Software <Vx.x - Vx.x>
^ <prerequisite layered product(s) and supported version(s)>
For Workstations Running DECwindows:
^ VMS Operating System <Vx.x> (and necessary components of VMS DECwindows)
^ <prerequisite layered product(s) and supported version(s)>
This product may run in either of the following ways:
^ Stand-alone execution--running the X11 display server and the client
application on the same machine.
^ Remote execution--running the X11 display server and the client
application on different machines.
VMS DECwindows is part of the VMS Operating System but must be
installed separately. Installation of VMS DECwindows gives you the
option to install any or all of the following three components:
^ VMS DECwindows Compute Server (Base kit; includes runtime support)
^ VMS DECwindows Device Support
^ VMS DECwindows Programming Support
For stand-alone execution, the following DECwindows components must be
installed on the machine:
[Edit this list as appropriate.]
^ VMS DECwindows Compute Server
^ VMS DECwindows Device Support
^ VMS DECwindows Programming Support
For remote execution, the following DECwindows components must be
installed on the machine:
[Edit these lists as appropriate.]
Server Machine Client Machine
^ VMS DECwindows Compute Server ^ VMS DECwindows Compute Server
^ VMS DECwindows Device Support ^ VMS DECwindows Device Support
^ VMS DECwindows Programming Support ^ VMS DECwindows Programming Support
VMS Tailoring
For VMS V5.x systems, the following VMS classes are
required for full functionality of this layered product:
[Edit this list as appropriate.]
^ VMS Required Saveset
^ Network Support
^ Programming Support
^ System Programming Support
^ Secure User's Environment
^ Utilities
^ RMS Journaling Files
^ Micellaneous Files
^ BLISS Require Files
^ Example Files
^ Use Environment Test Package
^ VMS Workstation Support
For more information on VMS classes and tailoring, refer to the VMS
Operating System Software Product Description (SPD 25.01.xx).
MicroVMS Tailoring
[Remove this section if your product does not support MicroVMS V4.x.]
For MicroVMS V4.x systems, the following components of MicroVMS are required
for full functionality of this layered product.
[Edit this list as appropriate.]
^ Base System
^ Common Utilities
^ Secure User Environment
^ Program Development
^ System Programming
OPTIONAL SOFTWARE
[This section is optional as needed. Be sure to include specific version
support for any products listed.]
<optional software product(s) and supported version(s)>
GROWTH CONSIDERATIONS
The minimum hardware/software requirements for any future version of this
product may be different from the minimum requirements for the current version.
DISTRIBUTION MEDIA
[Edit as appropriate.]
Disk : RX33 Floppy Diskette
Tape : 9-track 1600 BPI Magtape (PE), TK50 Streaming Tape
This product is also available as part of the VMS Consolidated
Software Distribution on CDROM.
ORDERING INFORMATION
[Below replace <xxx> with the UPID of the product.]
Software Licenses: QL-<xxx>A*-**
Software Media: QA-<xxx>A*-**
Software Documentation: QA-<xxx>AA-GZ
Software Product Services: QT-<xxx>A*-**
* Denotes variant fields. For additional information on available licenses,
services and media refer to the appropriate price book.
The above information is valid at time of release. Please contact your
local DIGITAL office for the most up-to-date information.
<month> <year>
@@
REMOTE DATABASE ACCESS
VAXCLUSTER/LOCAL AREA VAXCLUSTER
DISTRIBUTED DATABASE ENVIRONMENT
LIMITS and PARAMETERS
SOFTWARE WARRANTY
Warranty for this software product is provided by DIGITAL with the purchase
of a license for the product as defined in the Software Warranty Addendum.
SOFTWARE LICENSING
Product-Specific Licensing Information
Full Development Option
The VAX Rdb/VMS Full Development Option includes the base database software,
including SQL/Services server, all available language precompilers (SQL/Pre,
Rdb/Pre, RDML) and compilers (SQL Module Language), SQL/Services client API
libraries, and full database definition and administration facilities
(Interactive SQL, RDO, RMU).
The Full Development Option is the standard license, described above.
Interactive Option
An Interactive Option of VAX Rdb/VMS is available. The Interactive Option has
all the facilities of the development version of VAX Rdb/VMS except the
language precompilers and SQL module compiler. In addition to supporting
execution of previously developed applications on a target machine, the
Interactive option also provides the ability to perform database definition
and interactive query at the target machine using either interactive RDO
and/or Interactive SQL.
Program development is not supported under the Interactive Option.
Run-Time Option
A Run-Time Option of VAX Rdb/VMS is available. The right-to-use license for
the Rdb/VMS Run-Time Option is included in the VAX/VMS license.
In addition to the base database software, the Run-Time Option includes
the dynamic SQL engine, SQL/Services server process, the database maintenance
utility, and a sub-set of the RDO Interactive Utility. The purpose
of the Run-Time Only version is to support the execution of previously
developed applications on a target machine.
Program development is not supported under the Run-Time Option.
RUNTIME INTERACTIVE DEVELOPMENT
Base database software X X X
Dynamic SQL engine X X X
SQL/Services server X X X
RMU Maintenance Utility X X X
RDO Utility X (*) X X
Interactive SQL Utility X X
SQL Module Language Compiler X
SQL/Services Client API's X
SQL, RDML, Rdb/Pre Pre-compilers X
(*) Only a subset of RDO commands (data manipulation only) are available
in the Run-Time option.
This software is furnished under the licensing provisions of DIGITAL's
Standard Terms and Conditions. For more information about
DIGITAL's licensing terms and policies, contact your local DIGITAL
office.
LICENSING MANAGEMENT FACILITY
This layered product supports the VMS License Management Facility.
License units for this product are allocated on a CPU capacity basis.
For more information on the License Management Facility, refer to the VMS
Operating System Software Product Description (SPD 25.01.xx) or the VMS
Operating System documentation set.
For more information on DIGITAL's licensing policies, contact your local
DIGITAL office.
SOFTWARE PRODUCT SERVICES
A variety of service options are available from DIGITAL. For more
information contact your local DIGITAL office.
July 1989
AE-DA11J-TE
--------------------------------------------------------------------------
SYSTEM SUPPORT ADDENDUM
PRODUCT NAME: VAX Rdb/VMS, Version 3.1 SSA 25.59.09-A
Relational Database Management System
HARDWARE REQUIREMENTS
Processor Support
VAX: VAX 6210, VAX 6220, VAX 6230, VAX 6240, VAX 8200, VAX 8250, VAX 8300,
VAX 8350, VAX 8500, VAX 8530, VAX 8550, VAX 8600, VAX 8650, VAX 8700,
VAX 8800, VAX 8810, VAX 8820, VAX 8830, VAX 8840, VAX 8842, VAX 8974,
VAX 8978
VAX-11/730, VAX-11/750, VAX-11/780, VAX-11/782, VAX-11/785
MicroVAX: MicroVAX II, MicroVAX 2000, MicroVAX 3500, MicroVAX 3600
VAXstation: VAXstation II, VAXstation 2000, VAXstation 3200,
VAXstation 3500, Vaxstation 8000
VAXserver: VAXserver 3500, VAXserver 3600, VAXserver 3602
Not Supported
MicroVAX: MicroVAX I, MicroVAX 3100, MicroVAX 3300, MicroVAX 3400
VAXstation: VAXstation I, VAXstation 3100, VAXstation 3520, VAXstation 3540
VAXserver: VAXserver 3300, VAXserver 3400, VAXserver 6210, VAXserver 6220
VAX: VAX-11/725
Processor Restrictions
^ All processors require mass storage units to backup and restore
established databases
^ All processors require a specified minimum memory (see chart below)
^ All processors require a device for installation of the software
(see chart below). (Magnetic tape = One 9-track 1600 BPI magnetic tape)
^ Certain processors have other requirements (see chart below)
Minimum memory Installation Other
(megabytes) Device requirements
-----------------------------------------------------------------------------
For VAX-11/730 Systems: 3 Magnetic tape
-----------------------------------------------------------------------------
For VAX-11/750 Systems: 4 Magnetic tape ECO level 3 or later
-----------------------------------------------------------------------------
For VAX-11/780, 4 Magnetic tape ECO level 4 or later
VAX-11/782, or (VAX-11/780)
VAX-11/785 Systems: WCS microcode version
123 or later
-----------------------------------------------------------------------------
For VAX 82xx Systems: 4 Magnetic tape
-----------------------------------------------------------------------------
For VAX 83xx Systems: 4 Magnetic tape
-----------------------------------------------------------------------------
For VAX 8974 and 4 Magnetic tape
VAX 8978 Systems: (per processor)
-----------------------------------------------------------------------------
All other supported 4 Magnetic tape or
VAX Systems: TK50 tape drive
-----------------------------------------------------------------------------
Block Space Requirements (Block Cluster Size = 1):
Disk space required for installation of VAX Rdb/VMS:
Development Option: XXXXX blocks
(XXXM bytes)
Interactive Option: XXXXX blocks
(XXXM bytes)
Run-Time Only Option: XXXXX blocks
(XXXM bytes)
Disk space required for use (permanent):
Development Option: XXXXX blocks
(XXXM bytes)
Interactive Option: XXXXX blocks
(XXXM bytes)
Run-Time Only Option: XXXXX blocks
(XXXM bytes)
These counts refer to the disk space required on the system disk. The
sizes are approximate; actual sizes may vary depending on the user's
system environment, configuration, and software options.
OPTIONAL HARDWARE
For SQL/Services client software:
^ IBM-PC/AT or equivalent
CLUSTER ENVIRONMENT
This layered product is fully supported when installed on any valid and
licensed VAXcluster * configuration without restrictions. The HARDWARE
REQUIREMENTS sections of this product's Software Product Description
and System Support Addendum detail any special hardware required by
this product.
* V5.x VAXcluster configurations are fully described in the VAXcluster
Software Product Description (29.78.xx) and include CI, Ethernet and
Mixed Interconnect configurations.
SOFTWARE REQUIREMENTS
VMS Operating System V5.0 - V5.1
VMS Workstation Software V3.3 - V4.0
MS-DOS Operating System (for SQL/Services MS-DOS platform)
DECnet/DOS (for SQL/Services MS-DOS platform)
Ultrix V2.2 (3.0??)
VMS Tailoring
For VMS V5.x systems, the following VMS classes are required
for full functionality of this layered product.
^ VMS Required Saveset
^ Network Support
^ Programming Support
^ Secure Users Environment
^ Utilities
For more information on VMS classes and tailoring, refer to
VMS Operating System (SPD 25.01.xx).
OPTIONAL SOFTWARE
Certain versions of these products depend upon a specific
version of the Operating System. Please see the System Software
Addendum of the product in question to determine which version
you need.
VAX ACMS V3.0
VAX Ada V1.5
VAX BASIC V3.3
VAX BLISS V4.5
VAX C V2.4
VAX COBOL V4.2
VAX COBOL Generator V1.2
VAX CDD/Plus V4.0
VAX DATA DISTRIBUTOR V2.1
VAX DATATRIEVE V4.2
DECnet-VAX V5.0 - V5.1
VAX DIBOL V4.0
VAX FORTRAN V5.1
VAX PASCAL V3.8
VAX PL/I V3.2
VAX RALLY V2.0
VAX RPG II V2.1
VAX TEAMDATA V1.3
VIDA with IDMS/R (tm) V2.1
VIDA with DB2 (tm) V1.0
TM IDMS/R is a trademark of Cullinet Software, Inc.
TM DB2 is a trademark of IBM, Inc.
GROWTH CONSIDERATIONS
The minimum hardware requirements for any future version of this product
may be different than the minimum hardware requirements for the current
version.
DISTRIBUTION MEDIA
Tape: 9-track 1600 BPI Magtape (PE), TK50 Streaming Tape
ORDERING INFORMATION
Software Licenses: QL-VD2A*-** (Full Development Option)
Software Media: QA-VDAA*-**
Software Documentation: QA-VDAAA-GZ
Software Product Services: QT-VDAA*-**
* Denotes variant fields. For additional information on licenses,
services and media, refer to the appropriate price book.
VD2 VAX Rdb/VMS Full Development Option
VCL VAX Rdb/VMS Interactive Option
358 VAX Rdb/VMS Run-time Only Option (Note: The license for the Run-Time
option is included with VMS).
The above information is valid at time of release. Please contact your
local DIGITAL office for the most up-to-date information.
July 1989
AE-LT08B-TE
| T.R | Title | User | Personal
Name | Date | Lines
|
|---|