Automating evaluation of QoE for wireless communication services

    公开(公告)号:US11658885B2

    公开(公告)日:2023-05-23

    申请号:US16148835

    申请日:2018-10-01

    CPC classification number: H04L41/5032 G06F16/2423 H04L43/55

    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.

    SQL interceptor for use with third party data analytics packages

    公开(公告)号:US10380139B2

    公开(公告)日:2019-08-13

    申请号:US15352550

    申请日:2016-11-15

    Inventor: Marius Adamut

    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.

    SQL interceptor for use with third party data analytics packages

    公开(公告)号:US11176160B2

    公开(公告)日:2021-11-16

    申请号:US16525463

    申请日:2019-07-29

    Inventor: Marius Adamut

    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.

    Predicting subscriber experience based on QoE

    公开(公告)号:US10581664B1

    公开(公告)日:2020-03-03

    申请号:US16137442

    申请日:2018-09-20

    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.

    SQL INTERCEPTOR FOR USE WITH THIRD PARTY DATA ANALYTICS PACKAGES

    公开(公告)号:US20180137184A1

    公开(公告)日:2018-05-17

    申请号:US15352550

    申请日:2016-11-15

    Inventor: Marius Adamut

    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.

Patent Agency Ranking