US 12,450,541 B2
Systems and methods for providing tiered subscription data storage in a multi-tenant system
Nathan Creswell, Redwood City, CA (US); and Lei Jin, Redwood City, CA (US)
Assigned to Zuora, Inc., Redwood City, CA (US)
Filed by Zuora, Inc., San Mateo, CA (US)
Filed on Jun. 4, 2019, as Appl. No. 16/431,665.
Claims priority of provisional application 62/680,581, filed on Jun. 4, 2018.
Prior Publication US 2019/0370720 A1, Dec. 5, 2019
Int. Cl. G06Q 10/0639 (2023.01); G06F 16/22 (2019.01); G06F 16/28 (2019.01)
CPC G06Q 10/06393 (2013.01) [G06F 16/22 (2019.01); G06F 16/289 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A multi-tenant computing system for storing tenant data as multi-tiered data objects for supporting reduced computer demands during future report generation, the system comprising:
one or more processors; and
memory storing instructions that, when executed by the one or more processors, cause the computing system to perform:
receiving an order associated with a subscription plan of a customer account of a particular tenant of multiple tenants of the multi-tenant computing system, the order being associated with one or more associated order actions, the order including a start date and one of an end date or an open-end date, the order capable of including the open-end date;
in response to the order,
using a data storage model to generate, by a metric-generating service, based on the order and/or the one or more associated order actions, one or more associated order metrics associated with the order, the one or more associated order metrics including key performance indicators derived from the order and/or the one or more associated order actions, the one or more associated order metrics associated with the start date and the one of the end date or the open-end date;
using the data storage model to generate for the order a multi-tiered subscription data object in a common format, the multi-tiered subscription data object containing a first tier, a second tier and a third tier, the first tier including the order, the second tier including the one or more associated order actions, and the third tier including the one or more associated order metrics; and
storing the multi-tiered subscription data object in a data storage device in the common format in accordance with the data storage model;
receiving a first request for a first report involving the order and one or more first other orders;
after the receiving the first request for the first report,
requesting by a report generating service the multi-tiered subscription data object and one or more first other multi-tiered subscription data objects associated with the one or more first other orders from the data storage device;
transmitting the multi-tiered subscription data object and the one or more first other multi-tiered subscription data objects to the report generating service;
receiving by the report generating service the multi-tiered subscription data object and the one or more first other multi-tiered subscription data objects from the data storage device; and
generating by the report generating service the first report, based on the one or more associated order metrics of the multi-tiered subscription data object and on one or more first other associated order metrics of the one or more first other multi-tiered subscription data objects, wherein because the one or more associated order metrics and the one or more first other associated order metrics were stored respectively as part of the multi-tiered subscription data object and the one or more first other multi-tiered subscription data objects the report generating service need not generate the one or more associated order metrics and the one or more first other associated order metrics for generating the first report;
receiving a second request for a second report involving the order and one or more second other orders; and
after the receiving the second request for the second report,
requesting by the report generating service the multi-tiered subscription data object and one or more second other multi-tiered subscription data objects associated with the one or more second other orders from the data storage device;
transmitting the multi-tiered subscription data object and the one or more second other multi-tiered subscription data objects to the report generating service;
receiving by the report generating service the multi-tiered subscription data object and the one or more second other multi-tiered subscription data objects from the data storage device; and
generating by the report generating service the second report, based on the one or more associated order metrics of the multi-tiered subscription data object and on one or more second other associated order metrics of the one or more second other multi-tiered subscription data objects, wherein because the one or more associated order metrics and the one or more second other associated order metrics were stored respectively as part of the multi-tiered subscription data object and the one or more second other multi-tiered subscription data objects the report generating service need not generate the one or more associated order metrics and the one or more second other associated order metrics for generating the second report.