Supporting multi-tenancy in a federated data management system

• US 10,970,300 B2
• Filed: 07/31/2012
• Issued: 04/06/2021
• Est. Priority Date: 07/31/2012
• Status: Active Grant

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: Micro Focus LLC (Open Text Corporation)
• Inventors: Lotan, Yalon, Tzadikevitch, Gil, Avraham, Hadas
• Primary Examiner(s): Mahmoudi, Tony
• Assistant Examiner(s): Dewan, Kamal K
• Application Number:
  US14/396,131
• Publication Number:
  US 20150088806A1
• Time in Patent Office: 3,171 Days
• Field of Search: 707602, 707661, 707706, 707713, 707769, 707770, 707783, 707802, 707E17014
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

A system and method for supporting multi-tenancy in a federated data management system are provided herein. The method includes receiving a query from a client at a data management server, wherein the query includes a tenant property condition corresponding to the client. The method also includes identifying an external data store including data specified by the query and determining whether the external data store is multi-tenant enabled. The method further includes removing the tenant property condition and executing the query to retrieve the specified data if the external data store is not multi-tenant enabled.

Claims

1. A method comprising:

receiving a query from a client at a data management server comprising a processor, wherein the query comprises a tenant property condition corresponding to the client;

identifying, by the data management server, an external data store comprising data specified by the query comprising the tenant property condition;

determining, by the data management server, whether the external data store is multi-tenant enabled or non-multi-tenant enabled; and

in response to determining that the external data store is non-multi-tenant enabled;

determining whether a default tenant defined for the non-multi-tenant enabled external data store matches the tenant property condition specified by the query;

in response to determining that the default tenant defined for the non-multi-tenant enabled external data store matches the tenant property condition specified by the query, removing, by the data management server, the tenant property condition from the query, executing the query, with the tenant property condition removed from the query, on the non-multi-tenant enabled external data store to retrieve the data specified by the query, and adding tenant information of the default tenant to the data specified by the query that is returned to the client; and

in response to determining that the default tenant defined for the non-multi-tenant enabled external data store does not match the tenant property condition specified by the query, returning an empty result for the query to the client.

2. The method of claim 1, comprising providing the data specified by the query retrieved from the non-multi-tenant enabled external data store to the client.

3. The method of claim 1, comprising, in response to determining that the external data store is multi-tenant enabled, providing the query with the tenant property condition to the multi-tenant enabled external data store, wherein the multi-tenant enabled external data store is configured to execute the query and return only data corresponding to the tenant property condition to the data management server.

4. The method of claim 1, wherein executing the query, with the tenant property condition removed, on the non-multi-tenant enabled external data store to retrieve the data specified by the query comprises:

providing the query, with the tenant property condition removed, to the non-multi-tenant enabled external data store, wherein the non-multi-tenant enabled external data store is configured to execute the query, with the tenant property condition removed, and return the data specified by the query, with the tenant property condition removed, to the data management server.

5. The method of claim 1, comprising:

identifying a plurality of external data stores, wherein each external data store of the plurality of external data stores comprises a portion of the data specified by the query, and wherein each external data store is configured to execute the query to retrieve the portion of the data;

combining, by the data management server, the portions of the data retrieved from the plurality of external data stores to obtain a result for the query; and

providing the result to the client.

6. The method of claim 1, comprising:

retrieving a portion of the data specified by the query from a data management database that is communicatively coupled to the data management server; and

providing the portion of the data retrieved from the data management database to the client.

11. The method of claim 3, wherein the data corresponding to the tenant property condition comprises data corresponding to a tenant that matches the tenant property condition.

12. The method of claim 1, wherein the tenant property condition specifies a tenant corresponding to the client.

13. The method of claim 1, further comprising:

using the data specified by the query retrieved from the non-multi-tenant enabled external data store to manage an information technology service.

7. A computing system for supporting multi-tenancy, comprising:

a processor;

a federation code executable on the processor to;

determine an external data store comprising data specified by a topology query language (TQL) query received from a client, wherein the TQL query comprises a tenant property condition; and

determine whether the external data store is a multi-tenant enabled external data store or a non-multi-tenant enabled external data store; and

a TQL code executable on the processor to;

in response to determining that the external data store is a multi-tenant enabled external data store, direct retrieval of data specified by the TQL query from the external data store based on the tenant property condition specified by the TQL query; and

in response to determining that the external data store is a non-multi-tenant enabled external data store;

determine whether a default tenant defined for the non-multi-tenant enabled external data store matches the tenant property condition specified by the TQL query;

in response to determining that the default tenant defined for the non-multi-tenant enabled external data store does not match the tenant property condition specified by the TQL query, return an empty result for the TQL query to the client; and

in response to determining that the default tenant defined for the non-multi-tenant enabled external data store matches the tenant property condition specified by the TQL query, remove the tenant property condition from the TQL query, and execute the TQL query, with the tenant property condition removed from the TQL query, on the external data store.

8. The computing system of claim 7, wherein the federation code is executable on the processor to:

add information relating to the default tenant to result data retrieved from the non-multi-tenant enabled external data store responsive to executing the TQL query, with the tenant property condition removed from the TQL query, on the external data store.

15. The computing system of claim 7, wherein the TQL code is executable on the processor to:

add tenant information of the default tenant to data retrieved from the non-multi-tenant enable external data store in response to the TQL query with the tenant property condition removed; and

return the data retrieved from the non-multi-tenant enable external data store with the added tenant information of the default tenant to the client.

17. The computing system of claim 7, wherein the computing system comprises a configuration management database (CMDB) server within a federated configuration data management system, and wherein the data specified by the TQL query comprises configuration data.

18. The computing system of claim 7, wherein the directing of retrieval of the data specified by the TQL query from the multi-tenant enabled external data store comprises providing the TQL query with the tenant property condition to the multi-tenant enabled external data store, and wherein the multi-tenant enabled external data store is configured to execute the query and return only data corresponding to a tenant matching the tenant property condition to the computing system.

19. The computing system of claim 17, wherein the configuration data is related to management of an information technology service.

9. A non-transitory, computer-readable medium comprising code that upon execution causes a computing system to:

receive a query from a client, wherein the query comprises a tenant property condition;

determine an external data store comprising data specified by the query;

determine whether the external data store comprises a multi-tenant enabled external data store or a non-multi-tenant enabled external data store;

in response to determining that the external data store is a multi-tenant enabled external data store, retrieve only data corresponding to the tenant property condition from the multi-tenant enabled external data store;

in response to determining that the external data store is a non-multi-tenant enabled external data store;

determine whether a default tenant defined for the non-multi-tenant enabled external data store matches the tenant property condition specified by the query; and

in response to determining that the default tenant matches the tenant property condition, retrieve the data specified by the query from the non-multi-tenant enabled external data store based on executing the query, with the tenant property condition removed, on the non-multi-tenant enabled external data store; and

provide the data specified by the query retrieved from the external data store to the client.

10. The non-transitory, computer-readable medium of claim 9, wherein the code upon execution causes the computing system to, in response to determining that the default tenant defined for the non-multi-tenant enabled external data store does not match the tenant property condition specified by the query, return an empty result for the query to the client.

14. The non-transitory, computer-readable medium of claim 9, wherein the code upon execution causes the computing system to use the data specified by the query retrieved from the non-multi-tenant enabled external data store to manage an information technology service.

16. The non-transitory, computer-readable medium of claim 9, wherein the code upon execution causes the computing system to:

add tenant information of the default tenant to data retrieved from the non-multi-tenant enabled external data store in response to the query with the tenant property condition removed; and

return the data retrieved from the non-multi-tenant enable external data store with the added tenant information of the default tenant to the client.