GPRS Siemens BSS BR8 Neutral Functional Specification

Data Export Date: 24 May 2007

• 1. Change History
• 2. Document References
• 3. Outstanding Issues
• 4. Network Model
• 4.1 Network Objects
• 4.2 Reference Objects
• 5. Busy Hours
• 6. Constants
• 7. Performance Indicators
• 8. Database Schema
• 8.1 NC Tables
• 8.2 Raw Tables
• 8.3 Views
• 9. Performance Alarms
• 10. Reports
• 11. Data Availability

This section describes the network objects (logical and physical) that are referenced in this technology pack's data model.

Bearer

Frame Relay bearers, used between a PCU and an SGSN in a GPRS network.

Cell

The Cell handles the radio interface to the mobile station. The Cell is the radio equipment (transceivers and antennas) needed to service each cell in the network. A group of Cells is controlled by a BSC.

This section describes the reference objects that are used only as lookups for compound-keyed raw data.

Not applicable to this tech pack.

This section lists the busy hours that are defined in this technology pack, grouped by the network object to which they relate, as follows:

• Cell

This section lists all constants that are defined in this technology pack, and which may be referenced in KPI expressions.

This section lists the performance indicators (both one-to-one counter mappings, and complex KPIs) that are defined in this technology pack, grouped by the network object to which they relate, as follows:

• Cell

Note that all KPIs will have total, average, minimum and maximum values calculated for daily, weekly, and monthly summaries. Individual groups of KPIs may have additional summary types (including busy hours) applied to them, and these are listed against the respective KPIs in the tables below.

Cell.Neutral.GPRS.PDCH

Cell.Neutral.GPRS.RLC

This section lists the hierarchy ("NC") tables that are included in this technology pack's database schema.

nc_bearer

nc_cell

nc_cell_gprs_ext

nc_cell_umts_ext

nc_bearer_sec

nc_cell_sec

This section lists the performance tables that are included in this technology pack's database schema, grouped by the network object to which they relate, as follows:

• Cell

cell_pdch_raw

cell_rlc_1_raw

cell_rlc_2_raw

This section lists the views that are included in this technology pack's database schema.

nc_bearer_bsc_v

SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "bsc";

nc_bearer_pcu_v

SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "pcu";

nc_bearer_sgsn_v

SELECT nc_id,
bearer_id,
pcu_id,
sgsn_id,
node_id,
region_id,
network_id,
timestamp,
vendor_id,
bearer_name,
technology,
cir,
node_name,
node_type
FROM nc_bearer
WHERE LOWER(node_type) = "sgsn";

This section shows details of the performance alarms that are defined in this technology pack:

None.

This section shows details of the reports that are defined in this technology pack:

Radio Voice & Packet Traffic Overview

This graph shows a glimpse of the key performance data for a single cell on selected days.

Overview

Report Parameters

Report Components

This section lists the data availability definitions for the network objects previously described.

None.