Abstract: The disclosed technology teaches automating evaluation of QoE for data communication services in a wireless network—accessing performance indicators, mappings for the performance indicators to SKQIs in a SKQI parameters table, and mappings for SKQIs to KQIs in an SKQI-to-KQI mapping table. The disclosed method includes configuring first and second functions that, respectively, roll up performance indicators into SKQIs based on parameters stored in the SKQI parameters table to calculate SKQI scores and weights, and roll up SKQIs into KQIs and QoE based on parameters stored in SKQI-to-KQI and SKQI-to-QoE mapping tables, to calculate KQI and QoE scores. Also disclosed is generating first SQL statements that invoke the first function to calculate the SKQIs and second SQL statements that invoke the second function to calculate KQIs and QoE, storing generated first and second SQL statements in non-volatile storage and calculating KQIs and QoE using the automatically generated SQL statements.

Abstract: An SQL interceptor inserted as a proxy between a database client and the corresponding database server intercepts a constrained application-generated SQL query and composes a new data request. Parameter values in the SQL query determine whether the new data request is sent to a database server or a web service provider. A reserved table name specified in the SQL query triggers a rewrite of the data request. Parameter values in the query are used to select among a plurality of executable modules to use for rewriting the data request. Special data encoding and formats need to be used based on the source of data that will receive and respond to the rewritten data request. For example, communication between a database client and server may use a vendor-specific, non-standard binary encoding, and XML and JSON response data must be reformatted as an SQL response for processing by the database client.

Abstract: The disclosed technology teaches automating evaluation of QoE for data communication services in a wireless network—accessing performance indicators, mappings for the performance indicators to SKQIs in a SKQI parameters table, and mappings for SKQIs to KQIs in an SKQI-to-KQI mapping table. The disclosed method includes configuring first and second functions that, respectively, roll up performance indicators into SKQIs based on parameters stored in the SKQI parameters table to calculate SKQI scores and weights, and roll up SKQIs into KQIs and QoE based on parameters stored in SKQI-to-KQI and SKQI-to-QoE mapping tables, to calculate KQI and QoE scores. Also disclosed is generating first SQL statements that invoke the first function to calculate the SKQIs and second SQL statements that invoke the second function to calculate KQIs and QoE, storing generated first and second SQL statements in non-volatile storage and calculating KQIs and QoE using the automatically generated SQL statements.

Abstract: The disclosed technology teaches alerting a network operator to deteriorated wireless network conditions with granularity and reduced false alerts, including receiving tracked performance indicators (KPIs) for multiple components of voice, data and messaging and accessing a mapping for combining the performance indicators into quality sub-indicators for individual users and into key quality indicators (KQI) for the individual users. This includes smoothing the current KQI measures of performance over time to reduce the impact of brief transitory events, accessing a weekly profile of KQIs, and comparing KQIs for a current time window to past KQIs for a corresponding time window for the individual users operating mobile devices in part of the cellular network that is a focus of interest. Based on the comparing, the disclosed technology includes generating alerts that report out-of-range current KQIs within the focus of interest that are persistently out-of-range for longer than a configurable time.

Abstract: The disclosed technology teaches alerting a network operator to deteriorated wireless network conditions with granularity and reduced false alerts, including receiving tracked performance indicators (KPIs) for multiple components of voice, data and messaging and accessing a mapping for combining the performance indicators into quality sub-indicators for individual users and into key quality indicators (KQI) for the individual users. This includes smoothing the current KQI measures of performance over time to reduce the impact of brief transitory events, accessing a weekly profile of KQIs, and comparing KQIs for a current time window to past KQIs for a corresponding time window for the individual users operating mobile devices in part of the cellular network that is a focus of interest. Based on the comparing, the disclosed technology includes generating alerts that report out-of-range current KQIs within the focus of interest that are persistently out-of-range for longer than a configurable time.

Abstract: An SQL interceptor inserted as a proxy between a database client and the corresponding database server intercepts a constrained application-generated SQL query and composes a new data request. Parameter values in the SQL query determine whether the new data request is sent to a database server or a web service provider. A reserved table name specified in the SQL query triggers a rewrite of the data request. Parameter values in the query are used to select among a plurality of executable modules to use for rewriting the data request. Special data encoding and formats need to be used based on the source of data that will receive and respond to the rewritten data request. For example, communication between a database client and server may use a vendor-specific, non-standard binary encoding, and XML and JSON response data must be reformatted as an SQL response for processing by the database client.

Abstract: An SQL interceptor inserted as a proxy between a database client and the corresponding database server intercepts a constrained application-generated SQL query and composes a new data request. Parameter values in the SQL query determine whether the new data request is sent to a database server or a web service provider. A reserved table name specified in the SQL query triggers a rewrite of the data request. Parameter values in the query are used to select among a plurality of executable modules to use for rewriting the data request. Special data encoding and formats need to be used based on the source of data that will receive and respond to the rewritten data request. For example, communication between a database client and server may use a vendor-specific, non-standard binary encoding, and XML and JSON response data must be reformatted as an SQL response for processing by the database client.

Abstract: An SQL interceptor inserted as a proxy between a database client and the corresponding database server intercepts a constrained application-generated SQL query and composes a new data request. Parameter values in the SQL query determine whether the new data request is sent to a database server or a web service provider. A reserved table name specified in the SQL query triggers a rewrite of the data request. Parameter values in the query are used to select among a plurality of executable modules to use for rewriting the data request. Special data encoding and formats need to be used based on the source of data that will receive and respond to the rewritten data request. For example, communication between a database client and server may use a vendor-specific, non-standard binary encoding, and XML and JSON response data must be reformatted as an SQL response for processing by the database client.