This document describes the database schema that Cisco Prime Optical uses to store information in a Structured Query Language (SQL) database such as the Oracle database. The document is designed for users who need to create their own reports without using Prime Optical.
Note The Prime Optical schema is subject to change.
Various schema objects (tables, views, and functions) form the schema for Prime Optical in the Oracle database. The following information is stored in the Oracle database:
•Network element (NE) information
•Gateway network element (GNE) information
•Performance monitoring (PM) data
•SONET and SDH PM data
•Active alarm information
•Alarm and event logs
•Administrative job and task information
•NE service-related configuration information
This document contains the following information:
•Chapter 1 "Database Schema Tables"
•Chapter 2 "Database Schema Views"
–Descriptions of the database views created and used by Prime Optical.
•Chapter 3 "Database Schema Functions"
–Functions defined in Prime Optical tables.
•"Oracle Built-In Data Types"
–List of Oracle data types.
The primary audience for this guide includes network operations personnel and system administrators. This guide assumes the reader is familiar with the following products and topics:
•Basic internetworking terminology and concepts
•Network topology and protocols
•Microsoft Windows 7, Windows Vista, Windows 2000 Professional, Windows XP Professional, and Windows Server 2003 Terminal Server
•Sun Microsystems Solaris or Linux Red Hat administration
•Oracle database administration
This document uses the conventions listed in .
Table 1 Document Conventions
Commands and keywords
Variables for which you supply values
Displayed session and system information
Information you enter
boldface screen font
Variables you enter
italic screen font
Menu items and button names
Selecting a menu item
Option > Network Preferences
Note Means reader take note. Notes contain helpful suggestions or references to material not covered in the publication.
reader be careful. In this situation, you might do something that could result in equipment damage or loss of data.
Tip Means the following information will help you solve a problem.
Note You can access the most current Prime Optical documentation online at http://www.cisco.com/en/US/products/ps11670/tsd_products_support_series_home.html.
The Prime Optical documentation set comprises the following guides:
•Release Notes for Cisco Prime Optical 9.5—Describes the caveats for Prime Optical.
•Cisco Prime Optical 9.5 Installation Guide—Explains how to install Prime Optical and how to upgrade from previous releases.
•Cisco Prime Optical 9.5 User Guide—Describes how to use the Prime Optical software, which consists of user applications and tools for network discovery, network configuration, connection management, fault management, system administration, and security management.
•Cisco Prime Optical 9.5 GateWay/CORBA User Guide and Programmer Manual—Describes the GateWay/CORBA northbound interface product that is available for Prime Optical. This document serves as a reference for developers of OSS applications that work with the GateWay/CORBA interface.
•Cisco Prime Optical 9.5 Database Schema—This guide.
•Cisco Prime Optical 9.5 High Availability Installation Guide—Explains how to install Prime Optical in a high availability (HA) environment.
Note To obtain the Cisco Prime Optical 9.5 High Availability Installation Guide, contact your Cisco account representative.
•Cisco Prime Optical 9.5 ML Provisioning Methodology—Describes the methodology that Prime Optical uses to provision ML-series cards.
•Cisco Prime Optical 9.5 Basic External Authentication—Describes how Prime Optical supports basic external authentication.
•Migration Matrix for Service Pack Releases—Describes the migration matrix for service pack releases.
Obtaining Documentation and Submitting a Service Request
For information on obtaining documentation, submitting a service request, and gathering additional information, see the monthly What's New in Cisco Product Documentation, which also lists all new and revised Cisco technical documentation, at:
Subscribe to the What's New in Cisco Product Documentation as a Really Simple Syndication (RSS) feed and set content to be delivered directly to your desktop using a reader application. The RSS feeds are a free service and Cisco currently supports RSS version 2.0.