SILO-AWARE DATABASES

• US 20140280367A1
• Filed: 03/14/2013
• Published: 09/18/2014
• Est. Priority Date: 03/14/2013
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Rau, Stefan, Bloching, Uwe
• Application Number:
  US13/804,939
• Publication Number:
  US 20140280367A1
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof

Abstract

A system receives a request from an application to access a database. The system forms a database table proxy for a logical database. One or more database silos are assigned to the database table proxy. A default database silo from the one or more database silos is defined for the database table proxy. A database silo of the database table proxy corresponding to an application requesting access to the logical database is accessed with a database engine.

Claims

1. A computer-implemented method comprising:

forming a database table proxy for a logical database;

assigning one or more database silos to the database table proxy;

defining a default database silo from the one or more database silos for the database table proxy; and

accessing, using at least one processor, a database silo of the database table proxy corresponding to an application requesting access to the logical database at a database engine.

2. The computer-implemented method of claim 1, further comprising:

storing a relationship between the one or more database silos and the database table proxy in a database table proxy metadata repository.

3. The computer-implemented method of claim 1, further comprising:

assigning the database silo to the application requesting access to the logical database in a database table proxy session information table.

4. The computer-implemented method of claim 1, further comprising:

accessing the default database silo when the application requesting access to the logical database does not specify any database silo.

5. The computer-implemented method of claim 1, further comprising:

receiving a request to access the logical database from the application;

identifying a database silo from the request; and

accessing the identified database silo from the request for the application.

6. The computer-implemented method of claim 1, further comprising:

receiving a request to access the logical database from the application;

determining whether the request identifies a database silo; and

identifying the database silo corresponding to the request using a database table proxy session information table when the request does not identify the database silo.

7. The computer-implemented method of claim 1, further comprising:

manipulating data in the database silo in response to a request of the application without affecting data in other database silos of the database table proxy.

8. The computer-implemented method of claim 1, wherein the database silo is stored in a permanent storage device or a non-permanent storage device.

9. The computer-implemented method of claim 1, further comprising:

defining a database silo with a database silo name, whether data stored in the database silo is to be stored permanently, and whether the database silo can be shared between applications.

10. The computer-implemented method of claim 9, further comprising:

deleting a content of the database silo after the application terminates when the database silo accessed indicates that the data is to not to be stored permanently.

11. A system comprising:

a storage device configured to store a logical database; and

a processing device comprising a database engine configured to form a database table proxy as the logical database, assign one or more database silos to the database table proxy, define a default database silo from the one or more database silos for the database table proxy, and access a database silo of the database table proxy corresponding to an application requesting access to the logical database.

12. The system of claim 11, wherein the database engine is further configured to store a relationship between the one or more database silos and the database table proxy in a database table proxy metadata repository.

13. The system of claim 11, wherein the database engine is further configured to assign the database silo to the application requesting access to the logical database in a database table proxy session information table.

14. The system of claim 11, wherein the database engine is further configured to access the default database silo when the application requesting access to the logical database does not specify any database silo.

15. The system of claim 11, wherein the database engine is further configured to receive a request to access the logical database from the application, to identify a database silo from the request, to access the identified database silo from the request for the application.

16. The system of claim 11, wherein the database engine is further configured to receive a request to access the logical database from the application, to determine whether the request identifies a database silo, and identify the database silo corresponding to the request using a database table proxy session information table when the request does not identify the database silo.

17. The system of claim 11, wherein the database engine is further configured to manipulate data in the database silo in response to a request of the application without affecting data in the other database silos of the database table proxy.

18. The system of claim 11, wherein the database engine is further configured to define a database silo with a database silo name, whether data stored in the database silo is to be stored permanently, and whether the database silo can be shared between applications.

19. The system of claim 11, wherein the database engine is further configured to delete a content of the database silo after the application terminates when the database silo accessed indicates that the content is to not to be stored permanently.

20. A non-transitory machine-readable storage medium storing instructions which, when executed by at least one processor, performs operations comprising:

forming a database table proxy as a logical database;

assigning one or more database silos to the database table proxy;

defining a default database silo from the one or more database silos for the database table proxy; and

accessing a database silo of the database table proxy corresponding to an application requesting access to the logical database at a database engine.