SYSTEMS AND METHODS FOR AUTOMATICALLY COLLECTION OF PERFORMANCE DATA IN A MULTI-TENANT DATABASE SYSTEM ENVIRONMENT

• US 20110295728A1
• Filed: 01/03/2011
• Published: 12/01/2011
• 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
• Granted Patent: US 9,311,664 B2
• Time in Patent Office: Days
• US Class Current: 705/34
• 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 multiple sources in a multi-tenant system, comprising:

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.

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

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

4. The method of claim 2, further comprising associated a tier with the obtained data based upon the content type associated with the obtained data.

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

6. The method of claim 1, further comprising obtaining data corresponding to a plurality of tenants from a third source.

7. The method of claim 6, wherein the first source is an origin application server, the second source is a content delivery network and the third source is a proxy server.

8. The method of claim 1, further comprising aggregating the obtained data into a separate database associated with each tenant of the multi-tenant system.

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

10. A method for collecting billing data from multiple sources in a multi-tenant system, comprising:

obtaining page view entries corresponding to a plurality of tenants from a plurality of sources at a first predetermined frequency;

obtaining bandwidth value entries corresponding to a plurality of tenants from the plurality of sources at a second predetermined frequency; and

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

11. The method of claim 10, wherein the plurality of sources include at least one server that dynamically creates virtual applications based upon data from a common database that is shared between the plurality of tenants and at least one content delivery network.

12. The method of claim 10, wherein the aggregating further comprises associating a corresponding tenant for each of the page view entries and bandwidth value entries.

13. The method of claim 12, further comprising:

obtaining request time value entries corresponding to the plurality of tenants from the plurality of sources at a third predetermined frequency;

aggregating the page view entries, bandwidth value entries and request time value entries obtained from plurality of sources into the single database; and

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

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

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

16. A system for collecting performance data in a multi-tenant database system, comprising:

a memory; and

a server communicatively connected to the memory and communicatively connected to a plurality of sources, the server configured to;

collect page view entries corresponding to a plurality of tenants from the plurality of sources at a first predetermined frequency;

collect bandwidth entries data corresponding to a plurality of tenants from the plurality of sources 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.

17. The system of claim 16, wherein the plurality of sources include at least one server that dynamically creates virtual applications based upon data from a common database that is shared between the plurality of tenants and at least one content delivery network.

18. The system of claim 16, wherein the server is further configured to associate a corresponding tenant for each of the page view entries and bandwidth value entries.

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

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