The NCPOLLDATA database

The NCPOLLDATA database stores a data that is used by the Polling engine to administer polling and to administer storage and pruning of historical poll data. It also stores raw collected by the pollers and historical poll data that is derived from the raw data.

The NCPOLLDATA database tables fall into the following categories:
  • Tables indicating which entities to poll.
  • Tables indicating how to poll.
  • Tables containing raw and historical poll data.
  • Tables containing information on how to prune raw and historical poll data.
  • Tables that are used by the Apache Storm real-time computation system when it is managing the aggregation of raw poll data into historical poll data.
  • Views that are used by the Top Performers GUI to support the visualization of raw and historical poll data.

Tables indicating which entities to poll

The following tables contain subsets of data from the NCIM topology database. The Polling engine, ncp_poller, uses data from these tables to determine which entities to poll.
  • domainMgr
  • monitoredEntity
  • monitoredChassis
  • monitoredInterface

Tables indicating how to poll

The following tables contain subsets of data from the NCMONITOR database. The Polling engine, ncp_poller, uses data from these tables to determine how to poll.
  • poller
  • template
  • policy
  • poll
  • monitoredInstance
  • pollInstance
  • monitoredObject

Tables containing raw and historical poll data

The following tables store raw and historical poll data.
  • pollData
  • pdEwmaForDay
  • pdEwmaForWeek
  • pdEwmaForMonth
  • pdEwmaForYear
Note: The pollBatch table is related to the pollData table and contains identifiers used in the pollData table records.

Tables containing partition information

The following tables contain data on partitioning. The NCPOLLDATA tables that contain raw and historical poll data are partitioned to enable data pruning. These partitioning tables are used by the Polling engine, ncp_poller to manage the partitioning of raw and historical poll data tables.
  • pollDataPartitions
  • detachedPartitions
  • partitionSizes
  • partitionLog

Tables used by Apache Storm

The following tables are used by the Apache Storm real-time computation system to manage the aggregation of raw poll data into historical poll data.
  • getPollDataLog
  • master
  • mastershipAuditTrail
  • mastershipCheck

Views used by the GUI

The following views are used by the Top Performers GUI to support the visualization of raw and historical poll data.
  • KNP_POLL_DATA_COLLECTION
  • pollItemView
  • PERFORMANCE_DATA
  • PERFORMANCE_DATA_DAILY
  • PERFORMANCE_DATA_WEEKLY
  • PERFORMANCE_DATA_MONTHLY
  • PERFORMANCE_DATA_YEARLY
  • CHASSIS_PERFORMANCE_DATA
  • NETWORK_VIEW_PERF_DATA
  • NETWORK_VIEW_PERF_DATA_DAILY
  • NETWORK_VIEW_PERF_DATA_WEEKLY
  • NETWORK_VIEW_PERF_DATA_MONTHLY
  • NETWORK_VIEW_PERF_DATA_YEARLY
  • POLICIES_PER_NETWORK_VIEW