Systems and methods for automatically collection of performance data in a multi-tenant database system environment

• US 9,311,664 B2
• Filed: 01/03/2011
• Issued: 04/12/2016
• Est. Priority Date: 05/25/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Bulumulla, Irandi U., Guest, Ryan
• Primary Examiner(s): Gart, Matthew
• Assistant Examiner(s): PARIKH, HARSHAD R
• Application Number:
  US12/983,387
• Publication Number:
  US 20110295728A1
• Time in Patent Office: 1,926 Days
• Field of Search: 705/34, 705/8
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3438 monitoring of user actions tracking the activity of the user H04L67/535
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 11/3495 for systems
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 20/102 Bill distribution or payments
• CPC Class Codes: G06Q 20/145 Payments according to the detected use or quantity
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
• CPC Class Codes: G06Q 40/10 Tax strategies
• CPC Class Codes: G06Q 50/188 Electronic negotiation
• CPC Class Codes: H04L 41/0604 using filtering, e.g. reduction of information by using priority, element types, position or time
• CPC Class Codes: H04L 47/70 Admission control; Resource allocation
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54

Abstract

A method of collecting data from multiple sources in a multi-tenant system is provided. The method includes obtaining data corresponding to a first tenant in the multi-tenant system and a second tenant in the multi-tenant system from a first source, obtaining data corresponding to the first tenant in the multi-tenant system and the second tenant in the multi-tenant system from a second source, and aggregating the data obtained from the first and second sources into a single database and associating each entry of the obtained data with at least one of the tenants of the multi-tenant system.

Claims

1. A method of collecting data from at least one origin application server and at least one content delivery network forming a multi-tenant system, comprising:

obtaining, by a processor, usage data corresponding to a first tenant and a second tenant in the multi-tenant system from the at least one origin application server, the at least one origin application server dynamically creating virtual applications based upon data from a common database that is shared between the first tenant and the second tenant and hosting the virtual applications for the first tenant and the second tenant;

obtaining, by the processor, usage data from the at least one content delivery network corresponding to usage of the at least one content delivery network by the first tenant and the second tenant in the multi-tenant system; and

aggregating, by the processor, the usage data obtained from the origin application server and the content delivery network into a single database and associating each entry of the aggregated usage data with one of the first tenant and the second tenant of the multi-tenant system.

2. The method of claim 1, further comprising filtering, by the processor, the aggregated usage data based upon a content type associated with the aggregated usage data.

3. The method of claim 2, wherein the filtering further comprising parsing, by the processor, a uniform resource locator associated with the aggregated usage data to determine the content type associated with the aggregated usage data.

4. The method of claim 2, further comprising associating, by the processor, a tier with the aggregated usage data based upon the content type associated with the aggregated usage data.

5. The method of claim 4, further comprising generating, by the processor, a bill for the first tenant and the second tenant based upon the aggregated usage data.

6. The method of claim 1, further comprising obtaining, by the processor, usage data corresponding to the first tenant and the second tenant from a third source different from the origin application server and the content delivery network.

7. The method of claim 6, wherein the third source is a proxy server.

8. The method of claim 1, further comprising aggregating, by the processor, the aggregated usage data into a separate database, each separate database associated with one of the first tenant and the second tenant of the multi-tenant system.

9. The method of claim 1, wherein the aggregated usage data includes page view data and bandwidth value data.

10. A method for collecting billing data from at least one origin application server and at least one content delivery network forming a multi-tenant system, comprising:

obtaining, by a processor, page view entries corresponding to a plurality of tenants from the at least one origin application server and the at least one content delivery network at a first predetermined frequency;

obtaining, by the processor, bandwidth value entries corresponding to the plurality of tenants from the at least one origin application server and the at least one content delivery network at a second predetermined frequency; and

aggregating, by the processor, the page view entries and the bandwidth value entries obtained from the at least one origin application server and the at least one content delivery network into a single database,

wherein the at least one origin application server dynamically creates virtual applications based upon data from a common database that is shared between the plurality of tenants and hosts the virtual applications for the plurality of tenants.

11. The method of claim 10, wherein the aggregating further comprises associating, by the processor, a corresponding one of the plurality of tenants with each of the aggregated page view entries and the aggregated bandwidth value entries.

12. The method of claim 11, further comprising:

obtaining, by the processor, request time value entries corresponding to the plurality of tenants from the at least one origin application server and the at least one content delivery network at a third predetermined frequency;

aggregating, by the processor, the page view entries, the bandwidth value entries and the request time value entries obtained from the at least one origin application server and the at least one content delivery network into the single database; and

associating, by the processor, a tier with each of the aggregated page view entries, the aggregated bandwidth value entries and the aggregated request time value entries.

13. The method of claim 12, further comprising calculating, by the processor, a bill for each tenant of the plurality of tenants based upon the aggregated page view entries and the aggregated bandwidth values associated with each tenant and the tier associated with each aggregated page view entry and aggregated bandwidth value entry.

14. The method of claim 10, wherein a time period over which the page view entries are obtained is longer than a time period of the first predetermined frequency.

15. A system for collecting performance data in a multi-tenant database system comprising at least one origin application server and at least one content delivery network, the system comprising:

a memory; and

a server communicatively connected to the memory and communicatively connected to the at least one origin application server and the at least one content delivery network, the server configured to;

collect page view entries corresponding to a plurality of tenants from the at least one origin application server and the at least one content delivery network at a first predetermined frequency;

collect bandwidth entries data corresponding to a plurality of tenants from the at least one origin application server and the at least one content delivery network at a second predetermined frequency;

aggregate the page view entries and bandwidth value entries obtained from plurality of sources into a single database; and

storing the single database in the memory,

wherein the at least one origin application server dynamically creates virtual applications based upon data from a common database that is shared between the plurality of tenants and hosts the virtual applications for the plurality of tenants.

16. The system of claim 15, wherein the server is further configured to associate a corresponding one tenant of the plurality of tenants with each of the aggregated page view entries and aggregated bandwidth value entries.

17. The system of claim 15, wherein the server is further configured to associate a tier with each of the aggregated page view entries and the aggregated bandwidth value entries.

18. The system of claim 17 wherein the server is further configured to calculate a bill for each tenant of the plurality of tenants based upon the aggregated page view entries and the aggregated bandwidth values associated with each tenant and the tier associated with each aggregated page view entry and each aggregated bandwidth value entry.