Generation and use of table links in a provider-tenant environment

• US 20070156901A1
• Filed: 12/30/2005
• Published: 07/05/2007
• Est. Priority Date: 12/30/2005
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Gruener, Alex, Becker, Wolfgang
• Application Number:
  US11/320,749
• Publication Number:
  US 20070156901A1
• Time in Patent Office: Days
• US Class Current: 709/226
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: H04L 63/102 Entity profiles
• CPC Class Codes: H04L 67/306 User profiles

Abstract

Exemplary methods and systems may allow for a first tenant of a plurality of tenants to access a data structure at a provider database, wherein each of the plurality of tenants has common access to the data structure. By receiving, from the first tenant, a data request identifying the data structure, and querying, based on the data request, a tenant database associated with the first tenant for the identified data structure a determination may be made, based on the data request, that the identified data structure is located at the provider database. A tenant may redirect the data request to the provider database based on a data structure link reflecting a logical connection to an address of the identified data structure. With this capability a tenant may easily access data structures at a provider database.

Claims

1. A method for a first tenant of a plurality of tenants to access a data structure at a provider database, wherein each of the plurality of tenants has common access to the data structure, the method comprising:

receiving, from the first tenant, a data request identifying the data structure;

querying, based on the data request, a tenant database associated with the first tenant for the identified data structure;

determining, based on the data request, that the identified data structure is located at the provider database; and

redirecting the data request to the provider database based on a data structure link reflecting a logical connection to an address of the identified data structure.

2. The method of claim 1, wherein the data structure link includes an alternate identifier for the identified data structure.

3. The method of claim 2, wherein the alternate identifier is the name of the identified data structure

7. The method of claim 1, wherein redirecting the query to the provider database further includes:

querying, in response to the query, the tenant database for the shared data structure.

8. The method of claim 1, wherein the provider database stores a plurality of shared data structures, and wherein the redirecting the query to the provider database further includes:

determining, based on the redirected query, which of the plurality of shared data structures corresponds to the data structure link.

9. The method of claim 1, further including:

sending the data structure link from the provider database to the first tenant for use in redirecting a query for the shared data structure.

10. The method of claim 1, wherein the data structure link further reflects an alternative name for the shared data structure.

11. The method of claim 1, wherein the logical connection comprises:

a database universal resource locator.

12. The method of claim 1, wherein the shared data structure is determined to be independent from the plurality of tenants.

4. A method of querying a provider database having a data structure shared by a plurality of tenants, the method comprising:

executing, at a first tenant of the plurality of tenants, a query of a tenant database associated with the first tenant, wherein the query reflects a request for data of the shared data structure;

redirecting, at the first tenant, the query to the provider database based on a data structure link reflecting a logical connection to the shared data structure; and

sending, in response to the redirected query, the requested data of the shared data structure to the first tenant.

5. The method of claim 4, wherein the query includes an alternate identifier for the identified data structure.

6. The method of claim 5., wherein the alternate identifier is the name of the identified data structure

13. A system for a first tenant of a plurality of tenants to access a data structure at a provider database, wherein each of the plurality of tenants has common access to the data structure, the system comprising:

means for receiving, from the first tenant, a data request identifying the data structure;

means for querying, based on the data request, a tenant database associated with the first tenant for the identified data structure;

means for determining, based on the data request, that the identified data structure is located at the provider database; and

means for redirecting the data request to the provider database based on a data structure link reflecting a logical connection to an address of the identified data structure.

14. The system of claim 13, wherein redirecting the query to the provider database further includes:

means for querying, in response to the query, the tenant database for the shared data structure.

15. The system of claim 13, wherein the provider database stores a plurality of shared data structures, and wherein the means for redirecting the query to the provider database further includes:

means for determining, based on the redirected query, which of the plurality of shared data structures corresponds to the data structure link.

16. The system of claim 13, further including:

means for sending the data structure link from the provider database to the first tenant for use in redirecting a query for the shared data structure.

17. The system of claim 13, wherein the data structure link further reflects an alternative name for the shared data structure.

18. The system of claim 13, wherein the logical connection comprises:

a database universal resource locator.

19. The system of claim 13, wherein the shared data structure is determined to be independent from the plurality of tenants.