SQLstream provides an elegant and high-performance solution for Real-Time Rating, the activity that calculates actual service charges by applying pricing plan rules to service detail (usage) records. Software that performs the rating function is known as a Rating Engine.

Modern Rating Engine Practices and Requirements

The heart of any rating engine is a classification and aggregation process to satisfy the following requirements:

• Match each service detail record against rating plans, such as 700 minutes per month nationwide, plan XYZ

• Classify each service detail record by usage type, such as “off-peak weekend call”)

• Aggregate the records into tiers of usage, such as “first 700 minutes flat rate, thereafter $0.25 per minute"

• Allow for particular per-plan discounts linked to combinations of service usage, such as “once the user has ordered and downloaded three games within a given time period, we will give them the fourth game for free”

Rating operations with SQLstream

Rating operations are a natural application for SQLstream, since SQL's grouping, filtering and routing capabilities can, through SQLstream, be done in real-time with superb throughput. For traditional RDBMS, the transaction load would prohibit doing the operations in real-time.

The benefits of SQLstream's Real-Time Rating solution go beyond high-performance, since RAMMS enables integration of the rating process across many integrated services and applications. For example, the same relational queries that perform rating of customer records can also directly feed revenue forecasting queries, or simultaneously feed fraud detection systems, and so on.