Skip Headers

Oracle9i Database Installation Guide
Release 2 (9.2.0.1.0) for Windows

Part Number A95493-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

A
Individual Components Available for Installation

This appendix identifies higher-level components available with each installation type. The Custom installation type is not listed for any of the three top-level components since it enables installation of all components in the current category.

Specific topics discussed are:

Oracle9i Database Components

Table A-1 alphabetically lists the components available with each installation type of the Oracle9i Database top-level component.

Table A-1 Oracle9i Database Components Availability  
Component

Enterprise Edition

Standard Edition

Personal Edition

Advanced Queueing API

Yes

Yes

Yes

Advanced ReplicationFoot 1

YesFoot 2

Yes

Yes

Database Configuration Assistant

Yes

Yes

Yes

Generic Connectivity

Yes

Yes

Yes

iSQL*Plus

Yes

Yes

Yes

Object Type Translator

Yes

Yes

Yes

Oracle Administration Assistant for Windows NT

Yes

Yes

Yes

Oracle Advanced Security, includes:

Yes

No

Yes

  • Authentication Support, includes:

Yes

No

Yes

    DCE (with SSO support)

Yes

No

Yes

    Entrust

Yes

No

Yes

    Kerberos (with SSO support)

Yes

No

Yes

    RADIUS (for Smart Cards, Token Cards, and Biometrics)

Yes

No

Yes

  • Encryption and Integrity Support, includes:

Yes

No

Yes

    DES40 Encryption

Yes

No

Yes

    DES56 Encryption

Yes

No

Yes

    3DES_112 Encryption (2-key option)

Yes

No

Yes

    3DES_168 Integrity (3-key option)

Yes

No

Yes

    MD5 Integrity

Yes

No

Yes

    RC4_40 Encryption

Yes

No

Yes

    RC4_56 Encryption

Yes

No

Yes

    RC4_128 Encryption

Yes

No

Yes

    RC4_256 Encryption

Yes

No

Yes

    SHA-1 Integrity

Yes

No

Yes

  • Enterprise User Security, includes:

Yes

No

Yes

    Oracle Enterprise Login Assistant

Yes

No

Yes

    Oracle Enterprise Security Manager (available as an Oracle Enterprise Manager Integrated Application)

Yes

No

Yes

    Oracle Wallet Manager

Yes

No

Yes

  • Thin JDBC Java-based Encryption Support

Yes

No

Yes

Oracle C++ Call Interface

Yes

Yes

Yes

Oracle Call Interface

Yes

Yes

Yes

Oracle COM Automation Feature

Yes

Yes

Yes

Oracle Connection Manager

No

No

No

Oracle Data Mining

Yes

No

Yes

Oracle Database Upgrade Assistant

Yes

Yes

Yes

Oracle Database Utilities

Yes

Yes

Yes

Oracle Dynamic Services

Yes

Yes

Yes

Oracle Enterprise Manager Configuration Assistant

Yes

Yes

Yes

Oracle Enterprise Manager, includes:

Yes

Yes

Yes

  • Oracle Enterprise Manager Client, includes:

Yes

Yes

Yes

    Oracle Enterprise Manager Console

Yes

Yes

Yes

  • Oracle Enterprise Manager Integrated Applications, includes:

Yes

Yes

Yes

    Oracle Data Guard Manager

Yes

Yes

Yes

    Oracle Directory Manager

Yes

Yes

Yes

    Oracle Enterprise Security Manager

Yes

Yes

Yes

    Oracle Forms Server Manager

Yes

Yes

Yes

    Oracle LogMiner Viewer

Yes

Yes

Yes

    Oracle Policy Manager

Yes

Yes

Yes

    Oracle Spatial Index Advisor

Yes

Yes

Yes

    Oracle Text Manager

Yes

Yes

Yes

    SQL*Plus Worksheet

Yes

Yes

Yes

  • Oracle Enterprise Manager Management Packs, include:

Yes

No

No

    Oracle Change Management Pack

Yes

No

No

    Oracle Diagnostics Pack

Yes

No

No

    Oracle Management Pack for Oracle Applications

Yes

No

No

    Oracle Standard Management Pack

No

Yes

No

    Oracle Tuning Pack

Yes

No

No

  • Oracle Enterprise Manager Paging Server

Yes

Yes

Yes

  • Oracle Enterprise Manager Quick Tours

Yes

Yes

Yes

  • Oracle Enterprise Manager Web SiteFoot 3

Yes

Yes

Yes

  • Oracle Intelligent Agent (includes data collection services)

Yes

Yes

Yes

  • Oracle Management ServerFoot 4

Yes

Yes

Yes

Oracle HTTP Server, includes:

Yes

Yes

Yes

  • Apache Configuration for Oracle Java Server Pages

Yes

Yes

Yes

  • Apache Configuration for Oracle XML Developer's Kit

Yes

Yes

Yes

  • Apache JServ, includes:

Yes

Yes

Yes

    JSDK

Yes

Yes

Yes

    Sun JDK

Yes

Yes

Yes

  • Apache Web Server Files

Yes

Yes

Yes

  • Business Components for Java (BC4J) Runtime

Yes

Yes

Yes

  • Oracle Mod PL/SQL Gateway

Yes

Yes

Yes

  • Oracle Perl Interpreter

Yes

Yes

Yes

Oracle interMedia, includes:

Yes

Yes

Yes

  • Oracle interMedia Annotator

Yes

Yes

Yes

  • Oracle interMedia Audio

Yes

Yes

Yes

  • Oracle interMedia Client Option

Yes

Yes

Yes

  • Oracle interMedia Java Client

Yes

Yes

Yes

  • Oracle interMedia Image

Yes

Yes

Yes

  • Oracle interMedia Locator

Yes

Yes

Yes

  • Oracle interMedia Video

Yes

Yes

Yes

  • Oracle interMedia Web Client

Yes

Yes

Yes

Oracle Internet Directory Client

Yes

Yes

Yes

Oracle JDBC Drivers

Yes

Yes

Yes

Oracle Migration Workbench

No

No

No

Oracle Label Security

No

No

No

Oracle Names

No

No

No

Oracle Objects for OLE

Yes

Yes

Yes

Oracle ODBC Driver

Yes

Yes

Yes

Oracle OLAP

Yes

No

No

Oracle OLAP API

Yes

No

Yes

Oracle Programmer

Yes

Yes

Yes

Oracle Net ServicesFoot 5

Yes

Yes

Yes

Oracle Partitioning

Yes

No

Yes

Oracle Performance Monitor for Windows NT

No

No

No

Oracle Provider for OLE DB

Yes

Yes

Yes

Oracle Procedural Gateway for APPC

No

No

No

Oracle Procedural Gateways for IBM MQSeries

No

No

No

Oracle Real Application ClustersFoot 6

Yes

No

No

Oracle Remote Configuration Agent

Yes

Yes

Yes

Oracle Services for Microsoft Transaction Server

Yes

Yes

Yes

Oracle SNMP Agent

Yes

Yes

Yes

Oracle SOAP Client

Yes

Yes

Yes

Oracle SOAP for JServ

Yes

Yes

Yes

Oracle SOAP Server

Yes

Yes

Yes

Oracle Spatial

Yes

Yes

Yes

Oracle SQLJ

Yes

Yes

Yes

Oracle Text

Yes

Yes

Yes

Oracle Trace

Yes

Yes

Yes

Oracle Transparent Gateway for IBM DRDA

No

No

No

Oracle Transparent Gateway for Microsoft SQL Server

No

No

No

Oracle Transparent Gateway for Sybase

No

No

No

Oracle Transparent Gateway for Teradata

No

No

No

Oracle Universal Installer

Yes

Yes

Yes

Oracle Ultra Search Middle Tier

Yes

Yes

Yes

Oracle Ultra Search Server

Yes

Yes

Yes

Oracle Workflow Manager

Yes

Yes

Yes

Oracle Workspace Manager

Yes

Yes

Yes

Oracle XML Developer's Kit

Yes

Yes

Yes

Oracle XML SQL Utility

Yes

Yes

Yes

Oracle JVM, includes:

Yes

Yes

Yes

  • Java Virtual Machine

Yes

Yes

Yes

  • Oracle Java Tools

Yes

Yes

Yes

  • Oracle JVM Accelerator

Yes

Yes

Yes

Oracle9i Development Kit

Yes

Yes

Yes

Oracle9i Globalization Support

Yes

Yes

Yes

Oracle9i Server (the Oracle9i database), includes:

Yes

Yes

Yes

  • Oracle Database Demos

Yes

Yes

Yes

  • PL/SQL

Yes

Yes

Yes

  • PL/SQL Embedded Gateway

Yes

Yes

Yes

Oracle9i Syndication Server

Yes

Yes

Yes

Oracle9i Windows Documentation (release documentation, such as installation guide and release notes)

Yes

Yes

Yes

PL/SQL

Yes

Yes

Yes

Pro*C/C++

Yes

No

Yes

Pro*COBOL

Yes

No

Yes

Replication Management API

Yes

Yes

Yes

Sample Schema Demos

Yes

Yes

Yes

SQL*Plus

Yes

Yes

Yes

1 Updatable materialized views can be created in any edition of the database.

2 Multimaster replication is available only in Enterprise Edition.

3 Oracle Enterprise Manager Web Site includes a preconfigured Oracle HTTP Server as the Web listener for browser-based Oracle Enterprise Manager.

4 Oracle Management Server includes a preconfigured Oracle HTTP Server as the Web listener for browser-based Enterprise Manager as well as the central Enterprise Manager Reporting Web site.

5 When Oracle Net Services is installed through the Oracle9i database installation type, Oracle Protocol Support is automatically installed for the networking protocols detected.

6 Oracle Real Application Clusters is installed only if a cluster is detected.

See Also:

"Component Descriptions" for descriptions and release numbers of these components

Oracle9i Client Components

Table A-2 alphabetically lists the components available with each installation type of the Oracle9i Client top-level component.

Table A-2 Oracle9i Client Components Availability  
Component

Administrator

Runtime

Advanced Queueing API

Yes

No

Object Type Translator

Yes

No

Oracle Administrative Assistant for Windows NT

Yes

No

Oracle Advanced Security, includes:

Yes

No

  • Authentication Support, includes:

No

No

    CyberSafe (with SSO support)

No

No

    DCE (with SSO support)

No

No

    Entrust

No

No

    Kerberos (with SSO support)

No

No

    RADIUS (for Smart Cards, Token Cards, and Biometrics)

No

No

  • Encryption and Integrity Support, includes:

Yes

No

    3DES_112 Encryption (2-key option)

Yes

No

    3DES_168 Integrity (3-key option)

Yes

No

    DES40 Encryption

Yes

No

    DES56 Encryption

Yes

No

    MD5 Integrity

Yes

No

    RC4_40 Encryption

Yes

No

    RC4_56 Encryption

Yes

No

    RC4_128 Encryption

Yes

No

    RC4_256 Encryption

Yes

No

    SHA-1 Integrity

Yes

No

  • Enterprise User Security, includes:

Yes

No

    Oracle Enterprise Login Assistant

Yes

No

    Oracle Enterprise Security Manager (available as an Oracle Enterprise Manager Integrated Application)

Yes

No

    Oracle Wallet Manager

Yes

No

  • Thin JDBC Java-based Encryption Support

Yes

No

Oracle Call Interface

Yes

No

Oracle Enterprise Manager, includes:

Yes

No

  • Oracle Enterprise Manager Client, includes:

Yes

No

  • Oracle Enterprise Manager Console

Yes

No

  • Oracle Enterprise Manager Integrated Applications, includes:

Yes

No

    Oracle Data Guard Manager

Yes

No

    Oracle Directory Manager

Yes

No

    Oracle Enterprise Security Manager

Yes

No

    Oracle Forms Server Manager

Yes

No

    Oracle LogMiner Viewer

Yes

No

    Oracle Policy Manager

Yes

No

    Oracle Spatial Index Advisor

Yes

No

    Oracle Text Manager

Yes

No

    SQL*Plus Worksheet

Yes

No

  • Oracle Enterprise Manager Management Packs, include:

Yes

No

    Oracle Change Management Pack

Yes

No

    Oracle Diagnostics Pack

Yes

No

    Oracle Management Pack for Oracle Applications

Yes

No

    Oracle Standard Management Pack

No

No

    Oracle Tuning Pack

Yes

No

Oracle HTTP ServerFoot 1

No

No

Oracle interMedia Annotator

Yes

No

Oracle interMedia Client Option

Yes

No

Oracle interMedia Java Client

Yes

No

Oracle interMedia Web Client

Yes

No

Oracle Internet Directory Client

Yes

No

Oracle Java Tools

Yes

No

Oracle JDBC Drivers

Yes

Yes

Oracle Migration Workbench

No

No

Oracle Net Services

Yes

No

Oracle Objects for OLE

Yes

No

Oracle ODBC Driver

Yes

No

Oracle Programmer

Yes

No

Oracle Provider for OLE DB

Yes

No

Oracle Services for Microsoft Transaction Server

Yes

No

Oracle SQLJ

Yes

No

Oracle Syndication Server

Yes

No

Oracle Ultra Search Middle Tier

Yes

No

Oracle Universal Installer

Yes

No

Oracle Utilities

Yes

No

Oracle Workflow Builder

Yes

No

Oracle Workflow Mailer

Yes

No

Oracle XML Developer's Kit

Yes

No

Oracle XML SQL Utility

Yes

No

Oracle9i Globalization Support

Yes

Yes

Oracle9i Windows Documentation (release documentation, such as installation guide and release notes)

Yes

No

PL/SQL

Yes

No

Pro*C/C++

Yes

No

Pro*COBOL

Yes

No

Remote Configuration Agent

Yes

Yes

Replication Management API

Yes

No

SQL*Plus

Yes

Yes

1 See "Oracle HTTP Server" for a list of subcomponents installed with Oracle HTTP Server.

See Also:

"Component Descriptions" for descriptions and release numbers of these components

Oracle9i Management and Integration Components

Table A-3 alphabetically lists the components available with each installation type of the Oracle9i Management and Integration top-level component.


Note:

This table lists all the components that are installed with the Oracle Internet Directory installation types if an Oracle9i database is not currently installed.


Table A-3 Oracle9i Management and Integration Components Availability  
Component

Oracle Management Server

Oracle Internet Directory

Advanced Queueing API

Yes

Yes

Advanced Replication Management API

No

Yes

Database Configuration Assistant

No

Yes

Generic Connectivity

No

Yes

Object Type Translator

No

Yes

Oracle Advanced Security, includes:

Yes

Yes

  • Oracle Enterprise Login Assistant

Yes

Yes

  • Oracle Enterprise Security Manager (an Oracle Enterprise Manager Integrated Application)

Yes

No

  • Oracle Wallet Manager

Yes

Yes

Oracle Call Interface

No

Yes

Oracle Connection Manager

No

No

Oracle Database Upgrade Assistant

No

Yes

Oracle Dynamic Services Server

No

Yes

Oracle Enterprise Manager, includes:

Yes

No

  • Oracle Enterprise Manager Client, includes:

Yes

No

    Oracle Enterprise Manager Console

Yes

No

  • Oracle Enterprise Manager Integrated Applications, includes:

Yes

No

    OLAP Instance Manager

Yes

No

    Oracle Data Guard Manager

Yes

No

    Oracle Directory Manager

Yes

Yes

    Oracle Enterprise Security Manager

Yes

No

    Oracle Forms Server Manager

Yes

No

    Oracle LogMiner Viewer

Yes

No

    Oracle Policy Manager

Yes

No

    Oracle Spatial Index Advisor

Yes

No

    Oracle Text Manager

Yes

No

    SQL*Plus Worksheet

Yes

No

Oracle Enterprise Manager Management Packs, include:

Yes

No

    Oracle Change Management Pack

Yes

No

    Oracle Diagnostics Pack

Yes

No

    Oracle Management Pack for Oracle Applications

Yes

No

    Oracle Standard Management Pack

No

No

    Oracle Tuning Pack

Yes

No

  • Oracle Enterprise Manager Paging Server

Yes

No

  • Oracle Enterprise Manager Quick Tours

Yes

No

  • Oracle Management ServerFoot 1

Yes

No

  • Oracle Enterprise Manager Web Site1

Yes

No

  • Oracle Intelligent Agent

Yes

Yes

Oracle HTTP ServerFoot 2

Yes

Yes

  • Apache Configuration for Oracle Java Server Pages

Yes

Yes

  • Apache Configuration for Oracle XML Developer's Kit

Yes

Yes

  • Apache JServ, includes:

Yes

Yes

    JSDK

Yes

Yes

    Sun JDK

Yes

Yes

  • Apache Web Server Files

Yes

Yes

  • Oracle Mod PL/SQL Gateway

Yes

Yes

  • Oracle Perl Interpreter

Yes

Yes

Oracle interMedia, includes:

Yes

Yes

  • interMedia Audio

Yes

Yes

  • interMedia Annotator

Yes

Yes

  • interMedia Client Option

No

Yes

  • interMedia Image

Yes

Yes

  • interMedia Java Client

Yes

Yes

  • interMedia Locator

Yes

Yes

  • interMedia Video

Yes

Yes

Oracle Internet Directory Client

No

Yes

Oracle Internet Directory Client Toolset

No

Yes

Oracle Internet Directory Configuration Assistant

No

Yes

Oracle Internet Directory Server

No

Yes

Oracle JDBC Drivers

Yes

Yes

Oracle Names

No

No

Oracle Net Services

Yes

Yes

Oracle Objects for OLE

No

No

Oracle ODBC Driver

No

No

Oracle Partitioning

No

No

Oracle Provider for OLE DB

No

No

Oracle Remote Configuration Agent

No

Yes

Oracle SNMP Agent

Yes

No

Oracle SOAP Client

Yes

Yes

Oracle SOAP for JServ

Yes

Yes

Oracle SOAP Server

Yes

Yes

Oracle SQLJ

Yes

No

  • SQLJ Translator

No

No

Oracle Syndication Server

No

Yes

Oracle Text

Yes

No

Oracle Trace

No

Yes

Oracle Ultra Search Middle Tier

No

Yes

Oracle Ultra Search Server

No

Yes

Oracle Universal Installer

Yes

Yes

Oracle Utilities

No

Yes

Oracle Workflow

No

No

Oracle Workflow Manager

Yes

No

Oracle Workspace Manager

No

Yes

Oracle XML Developer's KitFoot 3

Yes

Yes

Oracle XML SQL Utility

Yes

Yes

Oracle JVM, includes:

No

Yes

  • Java Virtual Machine

No

Yes

  • Oracle JVM Accelerator

No

Yes

  • Oracle Java Tools

Yes

Yes

Oracle9i Globalization Support

Yes

Yes

Oracle9i Server (the Oracle9i database), includes:

No

Yes

  • Oracle Database Demos

No

Yes

  • PL/SQL

No

Yes

  • PL/SQL Embedded Gateway

No

Yes

Oracle9i Windows Documentation (release documentation, such as installation guide and release notes)

Yes

Yes

Pro*C/C++

No

No

Pro*COBOL

No

No

Replication Management API

No

Yes

SQL*Plus

Yes

Yes

1 Oracle Management Server includes a preconfigured Oracle HTTP Server as a Web listener for the central Enterprise Manager Reporting Web Site and for browser-based Enterprise Manager.

2 See "Oracle HTTP Server" for a list of subcomponents installed with Oracle HTTP Server.

3 A subset of the Oracle XML Developer's Kit is installed with Oracle Internet Directory. See the installation log in the SYSTEM_DRIVE:\Program Files\Oracle\Inventory\logs directory for a specific list.

Component Descriptions

Table A-4 provides descriptions and release numbers of individual components available for installation with the three top-level components. References are made to documentation that more fully describes these components. Some components described in Table A-1 are automatically installed with other components.


Note:

Components that require a separate license are identified in their descriptions in this appendix.


Table A-4 Component Descriptions  
Component Release Description See Also...

Advanced Queueing API

9.2

A component that provides the functionality to support the Advanced Queueing application programming interface (API).

Oracle9i Application Developer's Guide - Advanced Queuing

Advanced Replication

9.2

A component that provides the functionality to support the Advanced Replication Management API.

The API is a tool that enables you to build customized scripts for replication administration.

  • Oracle9i Advanced Replication

  • Oracle9i Replication Management API Reference

Assistant Common Files

(installed with Oracle assistants, such as Database Configuration Assistant and Oracle Net Configuration Assistant)

9.2

A collection of automatically installed files required by Oracle assistants. These files include:

  • BaliShare 1.1.17 (compressed)

  • DBUI 2.2.11

  • EWT 3.4.13 (compressed)

  • ICE Browser 5.06.8 (compressed)

  • Java Swing Components 1.1.1 (compressed)

  • JEWT 4.1.10

  • JLE 2.0.1

  • Kodiak 1.2.1

  • Oracle Help for Java 3.2.13 - EWT (compressed)

  • Oracle Help for Java 4.1.13 - JEWT (compressed)

Not applicable

Database Configuration Assistant

9.2

A tool that automates the process of creating, modifying, and deleting an Oracle9i database. You can create an Oracle9i database that is customized to the needs of your environment.

  • Oracle9i Database Administrator's Guide

  • "Postinstallation Database Creation" of Oracle9i Database Administrator's Guide for Windows

Generic Connectivity

9.2

Also known as Heterogeneous Services, this feature implements an extensibility framework for accessing non-Oracle systems. This feature integrates the core of Oracle's gateway technology directly into the database server by extending the Oracle SQL engine to optimize and rewrite SQL for non-Oracle data stores.

Oracle9i Heterogeneous Connectivity Administrator's Guide

iSQL*Plus

9.2

iSQL*Plus is a browser-based interface to SQL*Plus. This interface allows SQL, PL/SQL and SQL*Plus commands to run through a Web browser.

  • SQL*Plus Getting Started for Windows

  • iSQL*Plus Online Help

Java Runtime Environment

(versions used by Oracle)

1.1.8.18

1.3.1.2

Java Runtime Environment (JRE) is required for running Java applications, such as Oracle Universal Installer.

Not applicable

LogMiner Viewer

(an Oracle Enterprise Manager Integrated Application)

9.2

A tool that enables you to query redo log files to help analyze past database modification activity.

  • Oracle Enterprise Manager Concepts Guide

  • Oracle9i Database Administrator's Guide

Object Type Translator (OTT)

9.2

OTT is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C-structs.

Includes Oracle INTYPE File Assistant.

Oracle Call Interface Programmer's Guide

Oracle Administration Assistant for Windows NT

9.2

A tool that enables you to start and stop the database service, automatically start Oracle services, view Oracle background process information, and configure database users to be authenticated by Windows NT.

"Authenticating Database Users with Windows" of Oracle9i Security and Network Integration Guide

Oracle Advanced Security

9.2

Oracle Advanced Security provides the following comprehensive suite of security services for Oracle9i. All database editions include Secure Socket Layer (with X.509 version 3 and SSO support).

This multicomponent product requires a separate license.

Oracle Advanced Security Administrator's Guide

  • Authentication support

Strong authentication support is provided.

Oracle Advanced Security Administrator's Guide

  • Authorization support

Authorization solutions are provided with the distributed computing environment (DCE), and with the enterprise role management functionality in Oracle Advanced Security.

Oracle Advanced Security Administrator's Guide

  • Encryption and Integrity support

Data confidentiality is ensured using the encryption and data integrity types.

Note: Recent changes in United States Export Administration Regulations (EAR) make it possible for Oracle Corporation to ship one edition of Oracle Advanced Security worldwide. Oracle Advanced Security includes strong encryption for protocols into the Oracle9i database that were previously available only to the U.S. and Canadian markets.

Oracle Advanced Security Administrator's Guide

  • Enterprise User Security support

Integration with Lightweight Directory Access Protocol (LDAP) v3-compliant directory services is provided, such as Oracle Internet Directory, for centralized enterprise user management, enterprise role management, and single sign-on.

Oracle Advanced Security Administrator's Guide

  • Single Sign On support

Single sign on is provided (users authenticate once). Strong authentication then occurs transparently in subsequent connections. Kerberos, CyberSafe, DCE, and secure socket layer (SSL)-based single sign on are supported.

Oracle Advanced Security Administrator's Guide

Oracle Call Interface (OCI)

9.2

An API for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.

  • Oracle Call Interface Programmer's Guide

  • Oracle Call Interface Getting Started for Windows

Oracle Change Management Pack

(an optional Oracle Enterprise Manager Management Pack)

9.2

The Oracle Change Management Pack is a group of integrated applications used to track and make changes to database object definitions. You can use the pack to track metadata changes in databases, eliminate errors and loss of data when upgrading databases to support new applications, analyze the impact and complex dependencies associated with metadata change, and automatically perform upgrades