Dynamically creating and routing network records for dispatch prior to session timeout

Patent metadata

Field	Value
Publication number	US-9967155-B1
Application number	US-201514806495-A
Country	US
Kind code	B1
Filing date	Jul 22, 2015
Priority date	Jul 22, 2015
Publication date	May 8, 2018
Grant date	May 8, 2018

Abstract

A method for dynamically creating and routing custom network records with a server system on a service provider network before session timeout is disclosed according to an embodiment. The server system assembles a custom mapping from a mapping data store, determines that a request corresponds with a quantity of event instances in a network record that exceeds a calculated threshold, and creates the custom mapping within each event instance of a network record while the network record is stored in a records data store. The method includes the server system generating the hierarchy within the custom mapping created at each event instance of the network record, initiating a plurality of threads, and determining, using the plurality of threads, a plurality of event instances based on the request and hierarchy generated. A plurality of custom network records are generated in a staging table stored outside of the records data store.

First claim

What is claimed is:

1. A method for dynamically creating and routing custom network records on a service provider network before session timeout, each step in the method performed by a server system, the method comprising:
receiving a request from a customer via a communication session;
assembling a custom mapping from a mapping data store based on a client identifier included in the request, wherein the custom mapping non-uniformly defines a hierarchy data structure that is unique to the client identifier;
determining that the request corresponds with a quantity of event instances in a network record that exceeds a calculated threshold;
creating the custom mapping within each event instance of the network record while the network record is stored in a records data store;
generating the hierarchy within the custom mapping created at each event instance of the network record;
initiating a plurality of threads in response to determination of the calculated threshold being exceeded;
determining using the plurality of threads, a plurality of event instances based on the request and the hierarchy generated;
pulling the plurality of event instances into a staging table that is stored outside of the records data store;
isolating at least one column in the staging table and creating at least one new column in the staging table;
concatenating at least some fields of the plurality of event instances in the staging table to generate information within fields of the at least one new column at one or more rows in the staging table;
querying the staging table including the concatenated fields of the at least one new column based on the request;
creating a plurality of custom network records in the staging table based on the querying and responsive to determining the plurality of event instances; and
providing one or more of the plurality of custom network records to the customer before the communication session expires.

2. The method of claim 1 , further comprising:
routing each of the plurality of custom network records to a web portal associated with the request, wherein each of the plurality of custom network records comprises information associated with usage of the service provider network.

3. The method of claim 1 , the method further comprising:
determining levels of the hierarchy associated with query parameters included in the request;
for at least one thread initiated, identifying duplicate event instances based on the query parameters and the levels at each event instance; and
responsive to the identification of duplicates by the at least one thread initiated, selecting one event instance from the duplicates that corresponds with a higher level determined from the query parameters.

4. The method of claim 1 , wherein each event instance comprises a header having information correlating to at least one level of the data structure, and wherein generating the hierarchy at each event instance is based on the header.

5. The method of claim 4 , further comprising:
compressing the plurality of custom network records by a back-end server of the server system at the service provider network; and
providing, to a web server, at least one of the plurality of custom network records that are compressed from the back-end server, wherein the web server decompresses the at least one of the plurality of compressed custom network records and provides the at least one of the plurality of custom network records to a client associated with the customer.

6. The method of claim 1 , wherein the calculated threshold is calculated based on session timeout associated with the communication session.

7. A system for dynamically creating and routing custom network records on a service provider network before session timeout, the system comprising:
a server system, at the service provider network, comprising a processor communicatively coupled to a non-transitory memory storing an application that, upon execution by the processor, configures at least the server system to:
receiving a request from a customer via a communication session,
assemble a custom mapping from a mapping data store based on a client identifier included in the request, wherein the custom mapping non-uniformly defines a hierarchy data structure,
determine that the request corresponds with a quantity of event instances in a network record that exceeds a calculated threshold, wherein the calculated threshold is related to the communication session length,
create the custom mapping within each event instance of the network record while the network record is stored in a records data store,
generate the hierarchy within the custom mapping at each event instance of the network record,
in response to the determination of the calculated threshold being exceeded, determine a plurality of event instances based on the hierarchy generated and the request,
pull the plurality of event instances into a staging table that is stored outside of the records data store,
isolate at least one column in the staging table and creating at least one new column in the staging table,
concatenate at least some fields of the plurality of event instances in the staging table to generate information within fields of the at least one new column at one or more rows in the staging table,
query the staging table including the concatenated fields of the at least one new column based on the request,
create a custom network record in the staging table based on the querying, and
provide the custom network record to the customer before the communication session expires.

8. The system of claim 7 , wherein the records data store stores a plurality of network records that are associated with usage of the service provider network by client systems corresponding to a client subscription, and wherein the client subscription is stored in the non-transitory memory coupled to the server system and is associated with a plurality of telecommunications services provided on the service provider network.

9. The system of claim 7 , wherein each event instance includes a row in a data structure of the network record, and wherein each event instance is generated on the service provider network without reference to the custom mapping associated with the client identifier.

10. The system of claim 7 , wherein each event instance corresponds with a plurality of levels of the hierarchy, and wherein generation of the hierarchy instantiates levels of the hierarchy within the custom mapping created at each event instance.

11. The system of claim 10 , wherein the server system further configures at least the processor to:
parse query parameters included in the request,
determine levels of the hierarchy associated with the query parameters,
identify duplicate event instances based on the query parameters and the levels at each event instance, and
responsive to the identification of duplicates, flag one event instance from the duplicates that corresponds with a higher level determined from the query parameters.

12. The system of claim 7 , wherein the server system further configures a processor to:
route, via the service provider network, the custom network record to a web portal that is accessed by executing a client.

13. A method for dynamically creating and routing custom network records on a service provider network before session timeout, each step in the method performed by a server system, the method comprising:
receiving a request from a customer via a communication session;
assembling a custom mapping from a mapping data store based on a client identifier included in the request, wherein the custom mapping non-uniformly defines a

Assignees

• Sprint Communications Co Lp

Inventors

• Earl Bryson
• Jadunandan Kevin V
• Lumpkins Robert Dennis
• Lushear Brian D
• Shinholster Jr P A
• Szymanski Todd M

Classifications

• H04L41/5003 Primary

  Managing SLA; Interaction between SLA and QoS · CPC title

• H04L41/5029

  Service quality level-based billing, e.g. dependent on measured service level customer is charged more or less · CPC title

• H04L41/5032

  Generating service level reports · CPC title

• H04L41/50

  Network service management, e.g. ensuring proper service fulfilment according to agreements · CPC title

• H04L41/5064

  Customer relationship management · CPC title