Related links:
- Configuration Persistency Service Project Proposal (Oct 25 2019)
- https://wiki.onap.org/display/DW/Interfacing+with+ONAP-SQL-DB+via+DMaaP
CCSDK/SDNC/SDN-R/OOF-SON
Sandeep Shah Feel free to update this chapter
CCSDK/SDNC/SDN-R/WirelessTechnologies
As requested by Joanne Liu Rudel, this chapter will include a couple of dashboard views an their database representations. Please note that there are several discussion about moving some the data to other databases or at least align them with other databases (e.g. logging, A&AI).
Indices
The following figure shows the different indices and shards in a 3-node database cluster outside of CCSDK/SDNC.
Connect
Connection information of expected devices (required network elements) are stored in a database. Read more...
Dashboard | Database |
---|---|
Fault
As a kind of service for the dashboard the current network alarms and the alarm logs are maintained and stored in a database. Read more ....
Dashboard | Database |
---|---|
Maintenance Mode
SDN-R has the capability to suppress notifications northbound of the controller. Such configuration are stored and updated in a database. Read more ...
Dashboard | Database |
---|---|
Config
The actual device configuration data for wireless technology devices data are currently stored only in the devices (read more ...), according to the concept "network as a database".
The discussion around ConfigDB will change or add more functions to this concept.
Dashboard | Database |
---|---|
The database is in the device. | |
The database is in the device. The navigation to device data is derived from the management and control interface specifications. |
Inventory
All the inventory data, which are not modeled in A&AI are stored separately in a database. Read more ...
Dashboard | Database |
---|---|
ElasticSearch schema
Elite soft json viewer | ||||||
---|---|---|---|---|---|---|
| ||||||
{"mediator-server":{"mappings":{"mediator-server":{"properties":{"id":{"type":"long"},"name":{"type":"keyword"},"url":{"type":"keyword"}}}}},"inventoryequipment":{"mappings":{"inventoryequipment":{"properties":{"containedHolder":{"type":"keyword"},"date":{"type":"keyword"},"description":{"type":"keyword"},"manufacturerIdentifier":{"type":"keyword"},"modelIdentifier":{"type":"keyword"},"mountpoint":{"type":"keyword"},"parentUuid":{"type":"keyword"},"partTypeId":{"type":"keyword"},"serial":{"type":"keyword"},"treeLevel":{"type":"long"},"typeName":{"type":"keyword"},"uuid":{"type":"keyword"},"version":{"type":"keyword"}}}}},"faultcurrent":{"mappings":{"faultcurrent":{"properties":{"faultCurrent":{"properties":{"counter":{"type":"keyword"},"nodeName":{"type":"keyword"},"objectId":{"type":"keyword"},"problem":{"type":"keyword"},"severity":{"type":"keyword"},"timeStamp":{"type":"keyword"},"type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}}}},"faultlog":{"mappings":{"faultlog":{"properties":{"fault":{"properties":{"counter":{"type":"keyword"},"nodeName":{"type":"keyword"},"objectId":{"type":"keyword"},"problem":{"type":"keyword"},"severity":{"type":"keyword"},"timeStamp":{"type":"keyword"},"type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}}}},"maintenancemode":{"mappings":{"maintenancemode":{"date_detection":false,"properties":{"active":{"type":"boolean"},"filter":{"properties":{"definition":{"properties":{"object-id-ref":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"problem":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"description":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"end":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"start":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"node":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}},"historicalperformance15min":{"mappings":{"historicalperformance15min":{"properties":{"granularity-period":{"type":"keyword"},"layer-protocol-name":{"type":"keyword"},"node-name":{"type":"keyword"},"performance-data":{"properties":{"cses":{"type":"long"},"defect-blocks-sum":{"type":"long"},"es":{"type":"long"},"rf-temp-avg":{"type":"long"},"rf-temp-max":{"type":"long"},"rf-temp-min":{"type":"long"},"rx-level-avg":{"type":"long"},"rx-level-max":{"type":"long"},"rx-level-min":{"type":"long"},"ses":{"type":"long"},"snir-avg":{"type":"long"},"snir-max":{"type":"long"},"snir-min":{"type":"long"},"time-period":{"type":"long"},"time1024-states":{"type":"long"},"time1024-states-l":{"type":"long"},"time128-states":{"type":"long"},"time16-states":{"type":"long"},"time16-states-s":{"type":"long"},"time2-states":{"type":"long"},"time2048-states":{"type":"long"},"time2048-states-l":{"type":"long"},"time256-states":{"type":"long"},"time32-states":{"type":"long"},"time4-states":{"type":"long"},"time4-states-s":{"type":"long"},"time4096-states":{"type":"long"},"time4096-states-l":{"type":"long"},"time512-states":{"type":"long"},"time512-states-l":{"type":"long"},"time64-states":{"type":"long"},"time8-states":{"type":"long"},"time8192-states":{"type":"long"},"time8192-states-l":{"type":"long"},"tx-level-avg":{"type":"long"},"tx-level-max":{"type":"long"},"tx-level-min":{"type":"long"},"unavailability":{"type":"long"},"xpd-avg":{"type":"long"},"xpd-max":{"type":"long"},"xpd-min":{"type":"long"}}},"radio-signal-id":{"type":"keyword"},"scanner-id":{"type":"keyword"},"suspect-interval-flag":{"type":"boolean"},"time-stamp":{"type":"keyword"},"uuid-interface":{"type":"keyword"}}}}},"eventlog":{"mappings":{"eventlog":{"properties":{"event":{"properties":{"attributeName":{"type":"keyword"},"counter":{"type":"keyword"},"newValue":{"type":"keyword"},"nodeName":{"type":"keyword"},"objectId":{"type":"keyword"},"timeStamp":{"type":"keyword"},"type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}}}},"historicalperformance24h":{"mappings":{"historicalperformance24h":{"properties":{"granularity-period":{"type":"keyword"},"layer-protocol-name":{"type":"keyword"},"node-name":{"type":"keyword"},"performance-data":{"properties":{"cses":{"type":"long"},"defect-blocks-sum":{"type":"long"},"es":{"type":"long"},"rf-temp-avg":{"type":"long"},"rf-temp-max":{"type":"long"},"rf-temp-min":{"type":"long"},"rx-level-avg":{"type":"long"},"rx-level-max":{"type":"long"},"rx-level-min":{"type":"long"},"ses":{"type":"long"},"snir-avg":{"type":"long"},"snir-max":{"type":"long"},"snir-min":{"type":"long"},"time-period":{"type":"long"},"time1024-states":{"type":"long"},"time1024-states-l":{"type":"long"},"time128-states":{"type":"long"},"time16-states":{"type":"long"},"time16-states-s":{"type":"long"},"time2-states":{"type":"long"},"time2048-states":{"type":"long"},"time2048-states-l":{"type":"long"},"time256-states":{"type":"long"},"time32-states":{"type":"long"},"time4-states":{"type":"long"},"time4-states-s":{"type":"long"},"time4096-states":{"type":"long"},"time4096-states-l":{"type":"long"},"time512-states":{"type":"long"},"time512-states-l":{"type":"long"},"time64-states":{"type":"long"},"time8-states":{"type":"long"},"time8192-states":{"type":"long"},"time8192-states-l":{"type":"long"},"tx-level-avg":{"type":"long"},"tx-level-max":{"type":"long"},"tx-level-min":{"type":"long"},"unavailability":{"type":"long"},"xpd-avg":{"type":"long"},"xpd-max":{"type":"long"},"xpd-min":{"type":"long"}}},"radio-signal-id":{"type":"keyword"},"scanner-id":{"type":"keyword"},"suspect-interval-flag":{"type":"boolean"},"time-stamp":{"type":"keyword"},"uuid-interface":{"type":"keyword"}}}}},"inventorytoplevel":{"mappings":{"inventorytoplevel":{"properties":{"mountpoint":{"type":"keyword"},"uuidList":{"type":"keyword"}}}}},"required-networkelement":{"mappings":{"required-networkelement":{"date_detection":false,"properties":{"host":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"mountId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"password":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"port":{"type":"long"},"username":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}}} |