Cloud Billing Data Streaming via Metric-Static Database Split

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The complexity of managing and processing voluminous detailed billing data from third-party networks for enterprises, which can be cumbersome due to incremental time-based metering and tracking, makes it difficult for enterprises to efficiently understand and optimize their resource usage.

Innovation Solution

A system and method for streaming billing data from third-party networks to a remote network management platform, utilizing a metric-base database and static records database, where time-series data and static information are stored in formats suitable for analysis, enabling efficient storage and processing of billing data.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If detailed billing data are recorded and made available from the third-party network provider, then billing transparency and accuracy are improved, but the volume and format of the data make it inconvenient and difficult for the enterprise customer to obtain, process, and examine

Engineering Contradiction:
Improvebilling data accessibilityVSAvoiddata processing convenience
Core Design Contradiction:
Loss of informationVSEase of operation

Solution Approach 1:

The patent introduces an intermediary system that acts as a mediator between the third-party network provider and the enterprise customer. This intermediary automatically obtains, processes, and stores billing data in a convenient format, eliminating the manual effort required for customers to handle raw billing data while maintaining full access to detailed information.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system performs preliminary actions by automatically obtaining and processing billing data before the customer needs to examine it. The data is pre-fetched, pre-processed, and stored in an accessible format, so when customers need to review billing information, it is already prepared and ready for analysis without requiring manual data collection or formatting efforts.

Inventive Principle:
Principle #10Preliminary action

2Measurement precision

If hourly (or other incremental interval) metering and tracking are implemented, then billing precision and resource monitoring accuracy are improved, but the expansive ranges and volumes of billing data are generated, making them difficult to manage

Engineering Contradiction:
Improveresource usage measurement accuracyVSAvoiddata management complexity
Core Design Contradiction:
Measurement precisionVSDevice complexity

Solution Approach 1:

The system implements self-service by automatically handling the collection, processing, and storage of high-volume billing data. The automated processes manage the data lifecycle without requiring manual intervention, allowing the system to handle expansive data volumes efficiently while maintaining precise hourly metering and tracking capabilities.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The patent creates organized copies of billing data in structured formats that are easier to manage and analyze. Instead of dealing with raw expansive data volumes, the system generates processed copies that maintain the precision of hourly metering while being organized for efficient storage, retrieval, and analysis, thereby reducing management complexity.

Inventive Principle:
Principle #26Copying

3Productivity

If enterprises want to carefully scrutinize billing usage data for verification and optimization purposes, then resource optimization capability is improved, but the volume and format of billing data make it inconvenient to obtain and process

Engineering Contradiction:
Improveresource optimization efficiencyVSAvoiddata acquisition and processing time
Core Design Contradiction:
ProductivityVSLoss of time

Solution Approach 1:

The system performs preliminary data preparation by automatically obtaining, validating, and organizing billing data before customers need to analyze it. This pre-processing eliminates the time-consuming manual data collection and formatting steps, allowing enterprises to immediately begin scrutiny and optimization activities with ready-to-analyze data in convenient formats.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS10938882B2Preprocessing and storage of cloud service usage reports
Publication Date: 2021.03.02 SERVICENOW INC
  • US10938882B2 patent drawing
  • US10938882B2 patent drawing
  • US10938882B2 patent drawing

AI summary

Systems and methods for streaming billing data associated with third-party network resources consumed by a managed network to a remote network management platform are disclosed. Streaming of billing usage data associated with third-party resources may use resource identifiers to associate resources with line items in a service bill generated by the third-party network. A proxy server in the managed network may intermediate streaming from the third-party network to a remote server in a computational instance of the remote network management platform. Billing data may be recorded partly in a metric-base database configured for storing time series data corresponding to usage quantities of third-party resources consumed by the managed network per unit time, and partly in a static records database configured for storing database records associated with the time series data, and including data for identifying the third-party resources and for recording static information relating to billing for the third-party resources.