Patent ID: 8688686
Filing Date: 2014-04-01
Classification: G06F

Abstract:
1. A computer implemented method for optimizing queries for a Simple Network Management Protocol Management Information Base, the computer implemented method comprising: a Simple Network Management Protocol client receiving a source query defined in structured query language to access data stored in one or more Management Information Base tables; parsing the source query into one or more queries and sub-queries; applying sets of optimization rules and heuristics to the parsed source query to generate a query execution plan for each set of optimization rules and heuristics applied to the parsed source query to form a plurality of generated query execution plans for a given network element; selecting an optimal query execution plan from the plurality of generated query execution plans; the Simple Network Management Protocol client rewriting the parsed source query into a Simple Network Management Protocol construct using the optimization rules and heuristics specified in the optimal query execution plan to form a Simple Network Management Protocol-based query; and the Simple Network Management Protocol client using the Simple Network Management Protocol-based query to retrieve the data requested by the source query without performing a full scan of the one or more Management Information Base tables to locate the data.