Multi-tenant in-memory database (MUTED) system and method

• US 8,886,671 B1
• Filed: 08/14/2013
• Issued: 11/11/2014
• Est. Priority Date: 08/14/2013
• Status: Active Grant

• Current Assignee: Advent Software Incorporated (SS&C Technologies Holdings Incorporated)
• Original Assignee: Advent Software Incorporated (SS&C Technologies Holdings Incorporated)
• Inventors: Ro, Kwang T., Gido, James M., Andersen, Brian L., Villena, Claudia
• Primary Examiner(s): Uddin, Mohammed R
• Application Number:
  US13/966,575
• Time in Patent Office: 454 Days
• Field of Search: 707/792, 707/688, 707/812, 707/693, 707/700
• US Class Current: 707/781
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

In various embodiments, systems and methods for Multi-Tenant In-Memory Database access to an application program accessing an object-oriented database (OODB) are disclosed. Embodiments may include: connecting, by a processor, the application program to a data repository for a database; generating, by the processor, a first Firm for a first tenant; placing, by the processor, an address of a first object of the first Firm into a knowledge base pointer associated with the first tenant; placing, by the processor, an address of a main database object of the database into a pointer in an object of the first Firm; and accessing, by the processor, the first Firm through the knowledge base pointer and the database through the pointer object of the first Firm.

Claims

1. An integrated computer system for providing Multi-Tenant In-Memory Database access to an application program accessing an object-oriented database (OODB), the integrated computer system comprising:

1) a processor; and

2) a non-transitory computer readable medium in communication with the processor, wherein the non-transitory computer readable medium is configured to store computer program instructions that when executed by the processor are operable to cause the processor to;

(a) connect the application program to a data repository for a database;

(b) generate a first firm for a first tenant, wherein the first firm comprises a sub-set of the database;

(c) place an address of a first object of the first firm into a knowledge base pointer associated with the first tenant;

(d) place an address of a main database object of the database into a pointer in an object of the first firm;

(e) access the first firm through the knowledge base pointer and the database through the pointer object of the first firm;

(f) generate a second firm for a second tenant, wherein the second firm comprises a sub-set of the database;

(g) place an address of a first object of the second firm into a knowledge base pointer associated with the second tenant;

(h) place an address of the main database object of the database into a pointer in an object of the second firm;

(i) add one or more tenant objects to the first firm;

(j) link one or more node objects of the first firm to the one or more tenant objects;

(k) search the first firm and the database for a data object, wherein the search is executed by accessing the knowledge base pointer and searching each of the tenant objects prior to searching the database;

(l) generate a first tenant version of a database object;

(m) add the tenant version to the first firm;

(n) create a firm table in the database object, wherein the firm table comprises an address of the first tenant version of the database object;

(o) generate a second tenant version of the database object;

(p) add the second tenant version to the second firm; and

(q) insert an address of the second tenant version into the firm table in the object in the database.

2. A method for providing Multi-Tenant In-Memory Database access to an application program accessing an object-oriented database (OODB), the method comprising:

(a) connecting, by a processor, the application program to a data repository for a database;

(b) generating, by the processor, a first firm for a first tenant;

(c) placing, by the processor, an address of a first object of the first firm into a knowledge base pointer associated with the first tenant;

(d) placing, by the processor, an address of a main database object of the database into a pointer in an object of the first firm; and

(e) accessing, by the processor, the first firm through the knowledge base pointer and the database through the pointer object of the first firm;

(f) generating, by the processor, a second firm for a second tenant;

(g) placing, by the processor, an address of a first object of the second firm into a knowledge base pointer associated with the second tenant;

(h) placing, by the processor, the address of a main database object of the database into a pointer in an object of the second firm object;

(i) adding, by the processor, one or more tenant objects to the first firm; and

(j) linking, by the processor, one or more node objects of the first firm to the one or more tenant objects.

3. The method of claim 2, further comprising:

(a) searching, by the processor, the first firm and the database for a data object, wherein the search is executed by accessing the knowledge base pointer and searching each of the tenant objects prior to searching the database.

4. The method of claim 2, further comprising:

(a) generating, by the processor, a tenant version of an object in the database;

(b) adding, by the processor, the tenant version to the first firm; and

(c) creating, by the processor, a firm table in the object in the database, wherein the firm table comprises an address of the tenant version of the object in the database.

5. The method of claim 4, further comprising:

(a) generating, by the processor, a second tenant version of the object in the database;

(b) adding, by the processor, the second tenant version to the second firm; and

(c) inserting, by the processor, an address of the second tenant version into the firm table in the object in the database.

6. The method of claim 5, further comprising doubling, by the processor, a portion of memory allocated to the firm table, wherein the portion of memory is doubled when the firm table is three-quarters full.

7. The method of claim 4, further comprising:

(a) accessing, by the processor, the object in the database;

(b) checking, by the processor, for the tenant version of the object in the database;

(c) returning, by the processor, the tenant version of the object in the first firm.

8. An integrated computer system for providing Multi-Tenant In-Memory Database access to an application program accessing an object-oriented database (OODB), the integrated computer system comprising:

1) a processor; and

2) a non-transitory computer readable medium in communication with the processor, wherein the non-transitory computer readable medium is configured to store computer program instructions that when executed by the processor are operable to cause the processor to;

(a) connect the application program to a data repository for a database;

(b) generate a first firm for a first tenant;

(c) place an address of a first object of the first firm into a knowledge base pointer associated with the first tenant;

(d) place an address of a main database object of the database into a pointer in an object of the first firm; and

(e) access the first firm through the knowledge base pointer and the database through the pointer object of the first firm;

(f) generate a second firm for a second tenant;

(g) place an address of a first object of the second firm into a knowledge base pointer associated with the second tenant;

(h) place the address of a main database object of the database into a pointer in an object of the second firm;

(i) add one or more tenant objects to the first firm; and

(j) link one or more node objects of the first firm to the one or more tenant objects.

9. The integrated computer system of claim 8, the processor further operable to:

(a) search the first firm and the database for a data object, wherein the search is executed by accessing the knowledge base pointer and searching each of the tenant objects prior to searching the database.

10. The integrated computer system of claim 8, the processor further operable to:

(a) generate a first tenant version of a database object;

(b) add the first tenant version to the first firm; and

(c) create a firm table in the database object, wherein the firm table comprises an address of the first tenant version of the database object in the database.

11. The integrated computer system of claim 10, the processor further operable to:

(a) generate a second tenant version of the database object;

(b) add the second tenant version to a second firm; and

(c) insert an address of the second tenant version into the firm table in the object in the database.

12. The integrated computer system of claim 11, the processor further operable to double, by the processor, a portion of memory allocated to the firm table, wherein the portion of memory is doubled when the firm table is three-quarters full.

13. The integrated computer system of claim 10, the processor further operable to:

(a) access the object in the database;

(b) cheek for the tenant version of the object in the database; and

(c) return the tenant version of the object in the first firm.

14. A non-transitory machine readable memory medium encoded with a plurality of processor-executable instructions for:

(a) connecting an application program to a data repository for a database;

(b) generating a first Firm for a first tenant;

(c) placing an address of a first object of the first firm into a knowledge base pointer associated with the first tenant;

(d) placing an address of a main database object of the database into a pointer in an object of the first firm;

(e) accessing the first firm through the knowledge base pointer and the database through the pointer object of the first firm;

(f) generating a second firm for a second tenant;

(g) placing an address of a first object of the second firm into a knowledge base pointer associated with the second tenant; and

(h) placing the address of a main database object of the database into a pointer in an object of the second firm;

(i) adding one or more tenant objects to the first Firm;

(j) linking one or more node object of the first Firm to the one or more tenant objects;

(k) generating a tenant version of an object in the database;

(l) adding the tenant version to the first Firm; and

(m) creating a firm table in the object in the database, wherein the firm table comprises an address of the tenant version of the object in the database.

15. The non-transitory machine readable memory medium of claim 14, further encoded with a plurality of processor-executable instructions for:

(a) generating a second tenant version of the object in the database;

(b) adding the second tenant version to the second firm; and

(c) inserting an address of the second tenant version into the firm table in the object in the database.