METHODS AND SYSTEMS FOR APPENDING DATA TO LARGE DATA VOLUMES IN A MULTI-TENANT STORE

• US 20110258242A1
• Filed: 12/07/2010
• Published: 10/20/2011
• Est. Priority Date: 04/16/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Eidson, Bill C., Fell, Simon Z.
• Granted Patent: US 10,198,463 B2
• Time in Patent Office: Days
• US Class Current: 707/825
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof

Abstract

In accordance with embodiments, there are provided mechanisms and methods for appending data to large data volumes in a multi-tenant store. These mechanisms and methods for appending data to large data volumes can enable embodiments to provide more reliable and faster maintenance of changing data. In an embodiment and by way of example, a method for appending data to large data volumes is provided. The method embodiment includes receiving new data for a database. The new data is written to a temporary log. The size of the log is compared to a threshold. Then the log is written to a data store, if the size of the log is greater than the threshold.

Claims

1. A method comprising:

receiving new data for a database;

writing the new data to a temporary log;

comparing the size of the log to a threshold;

writing the log to a data store, if the size of the log is greater than the threshold.

2. The method of claim 1, wherein receiving new data comprises receiving the new data with a sequence number of the current status of the temporary log.

3. The method of claim 2, further comprising comparing the received sequence number to a sequence number of the temporary log and if the received sequence number is higher, then requesting an update to the temporary log.

4. The method of claim 1, wherein writing the new data comprises writing the data to an unstructured field.

5. The method of claim 4, wherein the unstructured field comprises a BLOB.

6. The method of claim 1, wherein comparing comprises comparing each time writing the new data is performed.

7. The method of claim 1, wherein writing the new data further comprises writing in the database a pointer to the new data in the temporary log.

8. The method of claim 1, wherein writing the log further comprises writing in the database a pointer to the log.

9. The method of claim 1, further comprising reformatting the log before writing the log to the data store.

10. The method of claim 1, wherein the database is a multi-tenant database including separate data for multiple tenants as a single table and wherein writing the new data comprises writing the new data to a temporary log separately for each tenant.

11. A machine-readable medium carrying one or more sequences of instructions for validating queries in a multi-tenant database system, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving new data for a database;

writing the new data to a temporary log;

comparing the size of the log to a threshold;

writing the log to a data store, if the size of the log is greater than the threshold.

12. The medium of claim 11, wherein receiving new data comprises receiving the new data with a sequence number of the current status of the temporary log.

13. The medium of claim 11, wherein writing the new data comprises writing the data to an unstructured field.

14. The medium of claim 13, wherein the unstructured field comprises a BLOB.

15. An apparatus for validating queries in a multi-tenant database, the apparatus comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

receiving new data for a database;

writing the new data to a temporary log;

comparing the size of the log to a threshold;

writing the log to a data store, if the size of the log is greater than the threshold.

16. The apparatus of claim 15, wherein receiving new data comprises receiving the new data with a sequence number of the current status of the temporary log, the processor further carrying out the steps of comparing the received sequence number to a sequence number of the temporary log and if the received sequence number is higher, then requesting an update to the temporary log.

17. The apparatus of claim 15, wherein comparing comprises comparing each time writing the new data is performed.

18. The apparatus of claim 15, wherein writing the new data further comprises writing in the database a pointer to the new data in the temporary log.

19. The apparatus of claim 15, wherein writing the log further comprises writing in the database a pointer to the log.

20. The apparatus of claim 15, wherein the database is a multi-tenant database including separate data for multiple tenants as a single table and wherein writing the new data comprises writing the new data to a temporary log separately for each tenant.