Table Of Contents
Preface
Objectives
Organization
Audience
Conventions
Related Documentation
Obtaining Documentation and Submitting a Service Request
Preface
Objectives
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
•Topology information
•Interface tables
•Performance monitoring (PM) data
•SONET and SDH PM data
•Active alarm information
•Alarm and event logs
•Log tables
•Administrative job and task information
•Port status
•NE service-related configuration information
Organization
This document contains the following information:
•Chapter 1, "Database Schema Tables"
–Table descriptions.
•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.
•Appendix A, "Oracle Built-In Data Types"
–List of Oracle data types.
•Appendix B, "Config_Table Parameters"
–Configuration information.
Audience
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
Conventions
This document uses the conventions listed in .
Table 1 Document Conventions
Item
|
Convention
|
Commands and keywords
|
boldface font
|
Variables for which you supply values
|
italic font
|
Displayed session and system information
|
screen font
|
Information you enter
|
boldface screen font
|
Variables you enter
|
italic screen font
|
Menu items and button names
|
boldface font
|
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.
Caution Means
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.
Related Documentation
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.3—Describes the caveats for Prime Optical.
•Cisco Prime Optical 9.3 Installation Guide—Explains how to install Prime Optical and how to upgrade from previous releases.
•Cisco Prime Optical 9.3 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.3 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.3 Database Schema—This guide.
•Cisco Prime Optical 9.3 High Availability Installation Guide—Explains how to install Prime Optical in a high availability (HA) environment.
Note To obtain the Cisco Prime Optical 9.3 High Availability Installation Guide, contact your Cisco account representative.
•Cisco Prime Optical 9.3 ML Provisioning Methodology—Describes the methodology that Prime Optical uses to provision ML-series cards.
•Cisco Prime Optical 9.3 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:
http://www.cisco.com/en/US/docs/general/whatsnew/whatsnew.html
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.
Feedback
