Methods, systems, and computer program products for detecting and restoring missing or corrupted data in a distributed, scalable, redundant measurement platform database

A system for detecting and restoring missing or corrupted data in a distributed, scalable, redundant measurement platform database, the system comprising:

• a routing node for routing signaling messages, the routing node including a plurality of interface modules for generating peg counts based on signaling messages received by the routing node that satisfy predetermined criteria;
• the routing node including a measurement collection platform (MCP) configured to collect, maintain, and report operational parameters, to receive the peg counts from the interface modules, and to distribute the peg counts across a plurality of measurement collection processor modules (MCPMs) in the routing node;
• and
• wherein the plurality of measurement collection processor modules are controlled by the MCP, and wherein the plurality of MCPMs includes a local database storing the peg counts in a plurality of local database entries and a redundant remote database that includes a plurality of redundant remote database entries, wherein the redundant remote database is stored in a memory that is separate from a memory that stores the local database and wherein the redundant remote database is managed by an MCPM that is separate from the MCPM that manages the local database and wherein the MCPM that manages the local database is configured to:
• audit the local database including a plurality of local database entries to identify suspect local database entries having at least one of a missing or corrupted peg count;
• cross-compare the local database with at least one of the redundant remote databases that is a peer of the local database and that includes a plurality of redundant remote database entries, wherein the plurality of redundant remote database entries are associated with the plurality of local database entries, to identify local database entries that are inconsistent with the redundant remote database entries, wherein the local and remote database entries store peg counts;
• and
• for each local database entry identified as suspect and inconsistent with the corresponding redundant remote database entry, replace the local database entry with the redundant remote database entry.

A computer program product comprising computer-executable instructions embodied in a computer-readable medium for performing steps comprising:

• at each of a plurality of interface modules in a routing node, generating peg counts, which are counts of signaling messages received by the routing node that satisfy predetermined criteria;
• distributing the peg counts generated by the interface modules across a plurality of databases in the routing node, wherein the plurality of databases includes a local database and a redundant remote database, wherein the redundant remote database is stored in a memory that is separate from a memory that stores the local database and wherein the redundant remote database is managed by a measurement collection processor module (MCPM) that is separate from an MCPM that manages the local database;
• using the MCPM that manages the local database by:
• auditing the local database including a plurality of local database entries to identify suspect local database entries having at least one of a missing or corrupted peg count;
• cross-comparing the local database with the redundant remote database that is a peer of the local database and that includes a plurality of redundant remote database entries, wherein the plurality of redundant remote database entries is associated with the plurality of local database entries, to identify local database entries that are suspect and inconsistent with the redundant remote database entries, wherein the local and remote database entries store peg counts;
• and
• for each local database entry identified as suspect and inconsistent with the corresponding redundant remote database entry, replacing the local database entry with the redundant remote database entry.