Cisco Systems Version 1.1 manual AppendixB Data Schema Dataset Schema

Page 102

AppendixB Data Schema

Dataset Schema

ALTER TABLE Carriers_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1 (RuleKey) DEFERRABLE;

ALTER TABLE Carriers_1 ADD FOREIGN KEY (ListKey)REFERENCES Lists_1 (ListKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2 (RuleKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (ListKey)REFERENCES Lists_2 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_1 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ContactKey)REFERENCES Contacts_1 (ContactKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_2 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ContactKey)REFERENCES Contacts_2 (ContactKey) DEFERRABLE;

ALTER TABLE Routes_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1 (RuleKey) DEFERRABLE;

ALTER TABLE Routes_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2 (RuleKey) DEFERRABLE;

ALTER TABLE MatchPatterns_1 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_1 (RouteKey) DEFERRABLE;

ALTER TABLE MatchPatterns_2 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_2 (RouteKey) DEFERRABLE;

ALTER TABLE Rules_1 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE Rules_2 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_2 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (ListKey)

REFERENCES Lists_1 (ListKey) DEFERRABLE;

Cisco Carrier Sensitive Routing User Guide

B-12

Page 101 Page 103
Image 102
Page 101 Page 103
Contents Cisco Carrier Sensitive Routing User Guide Cisco Carrier Sensitive Routing User Guide CSR GUI Activating CSR Creating Rules Logging A-1 Overview Who Should Use This GuideDocument Organization Document ConventionsWorld Wide Web Related Documentation and ReferencesObtaining Documentation Documentation CD-ROMCisco.com Obtaining Technical AssistanceDocumentation Feedback Technical Assistance CenterCisco TAC Web Site Cisco TAC Escalation CenterXii Overview of Cisco Carrier Sensitive Routing PrerequisitesCSR Components CSR BasicsPostgreSQL Database CSR ApplicationIngress Rejection Rules Egress Rejection RulesSelection Rules CSR Limitations CSR Limitations Carrier Sensitive Routing User Guide PostgreSQL Database Operations Functionalities Database OperationsActivating the Database Exiting the Database Reactivating the DatabaseExporting a Database Reintializing a DatabaseDatabase Functionalities Database TablesDefault Allow Null Default Type Null Allow Name Type Null Allow Null Default Constraints Comments Dataset Tables True SelectPreferr edCarrier rule is used = 0 and = = 0 and = 5 = 0 and = SelectPreferredCarrier Integer SelectPercentageEgress Lists Table Text Integer Time Integer integer Allow Name Type Null Default PostgreSQL Database Command Summary Single Instance Cisco Carrier Sensitive Routing Application OperationsActivating CSR CSR as a DaemonMultiple Instances CSR as a User ProcessLogin Dialog Box Deactivating CSRClick Shutdown CSR CSR GUI Functionalities Activating the GUIConfiguring CSR with the GUI Changing Configuration SettingsConfiguration Management Tab in CSR Window Changing Log LevelsChanging Connection Port Saving Configuration SettingsChanging App Priority Enabling Test Routes AccountingAdding, Modifying, and Removing Gatekeepers Adding GatekeepersRegistered Messages and Filters Checkbox Filters Pop-up Menu 10 Delete Filter Display Modifying Gatekeepers 11 Current Gatekeepers Area in CSR WindowThis section describes how to remove an existing gatekeeper Removing GatekeepersSetting Threads for Processing Calls and Call Queue Size 13 Delete Gatekeeper MessageUpdating Active Datasets Swapping DatasetsCreating, Modifying, and Deleting Carriers 16 Active Dataset Tab in CSR WindowCreating Carriers 17 Carrier Selection Box in Active DatasetModifying Carriers 18 Dialog Box for New Carrier in Active DatasetDeleting Carriers 19 Dialog Box for an Existing Carrier in Active DatasetCreating, Modifying, and Deleting Contacts Creating ContactsModifying Contacts Deleting ContactsCreating, Modifying, and Deleting Contact Lists Creating Contact ListsModifying Contact Lists Change the information accordinglyCreating, Modifying, and Deleting Egress Route Attributes Deleting Contact ListsCreating Egress Route Attributes CSR GUI Functionalities Updating Active Datasets Modifying Egress Route Attributes 26 List of Egress Route Attribute Names in Active Dataset Deleting Egress Route Attributes Creating, Modifying, and Deleting Ingress Route Attributes Creating Ingress Route AttributesCSR GUI Functionalities Updating Active Datasets Modifying Ingress Route Attributes Deleting Ingress Route Attributes Creating, Modifying, and Deleting Match Patterns Creating Match PatternsModifying Match Patterns Deleting Match PatternsCreating, Modifying, and Deleting Routes Creating RoutesModifying Routes 33 QoS Relationships Dialog Box in Active DatasetDeleting Routes 34 Dialog Box for an Existing Route in Active DatasetCreating, Modifying, and Deleting Rules Creating RulesCSR GUI Functionalities Updating Active Datasets Modifying Rules Deleting Rules 36 Dialog Box for Existing Rule in Active DatasetUpdating Inactive Datasets Verifying DatasetsDestroying Inactive Datasets 37 Inactive Dataset Tab in CSR WindowCSR Commands Activating Inactive Datasets39 CSR Commands Tab in CSR Window 40 Test Results Generated by the CSR Commands Tab Updating Logging Level Loading the Active DatasetResetting Call Accounting Cleaning Test ResultsUpdating Gatekeepers Checking CSR Version Multiple GUI OperationConfiguring Syslog LoggingViewing Logs ExamplesSample logs Page Data Schema Configuration Data SchemaNot Null Default Not Null Primary KEY ADD Foreign KEY Gkid Dataset Schema ConstraintNot Null Default 0 Constraint SelectBestQoS = 0 SelectSameCarrier integer ContactKey Integer Inherits Commit Begin Work Commit Begin Work AppendixB Data Schema Dataset Schema Routes1 RouteKey Page Error Conditions and Recoveries Database Connectivity LossGatekeeper Connectivity Loss O S S a R Y GL-4 D E IN-6

Version 1.1 specifications

Cisco Systems Version 1.1 introduced significant advancements in network technology, setting a new standard for performance, security, and management in the ever-evolving landscape of enterprise networking. This version is characterized by a robust architecture that supports a wide array of devices and applications, ensuring seamless connectivity and efficiency for businesses of all sizes.

One of the standout features of Cisco Systems Version 1.1 is its enhanced routing capabilities. The introduction of advanced routing protocols enables more efficient data handling and traffic management. This improvement translates into reduced latency and optimized bandwidth utilization, which are crucial for organizations relying on real-time applications like VoIP and video conferencing.

Another notable technology integrated into Version 1.1 is the expanded support for Software-Defined Networking (SDN). This allows network administrators to manage their network resources more flexibly and dynamically, adapting quickly to changing demands. With SDN, Cisco provides a centralized control plane that enables automated provisioning and orchestration of network services, ultimately leading to reduced operational costs and improved service quality.

Security improvements are also a hallmark of Cisco Systems Version 1.1. The incorporation of advanced intrusion detection and prevention systems (IDPS) enhances the overall security posture of networks. Additionally, built-in encryption protocols ensure that data is transmitted securely, safeguarding sensitive information from potential cyber threats.

Furthermore, Version 1.1 emphasizes user experience with its intuitive management interface. Network monitoring and troubleshooting tools have been redesigned to be more user-friendly, allowing IT teams to quickly identify and resolve issues, thereby minimizing downtime and improving overall network reliability.

Scalability is another critical characteristic of this version, designed to accommodate the growth of companies. Whether an organization is expanding its physical infrastructure or transitioning to cloud-based services, Cisco Systems Version 1.1 provides the flexibility necessary to scale operations without sacrificing performance.

In summary, Cisco Systems Version 1.1 is a comprehensive networking solution that integrates advanced routing capabilities, SDN support, enhanced security features, and a user-friendly management interface. Its scalability ensures that it can meet the growing demands of modern enterprises, making it a pivotal choice for businesses looking to optimize their networking infrastructure. As companies continue to embrace digital transformation, Cisco Systems Version 1.1 stands out as a reliable foundation for future growth and innovation.
Top Page Image Contents