Tenant Data Comparison for a Multi-Tenant Identity Cloud Service

• US 20190306237A1
• Filed: 10/30/2018
• Published: 10/03/2019
• Est. Priority Date: 04/02/2018
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: SRINIVASAN, Sudhir Kumar, BALU, Balakumar, MEDAM, Venkateswara Reddy, SHIH, Kuang-Yu
• Granted Patent: US 10,798,165 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/184 implemented as replicated file system
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2255 Hash tables
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/83 Querying
• CPC Class Codes: G06F 9/45533 Hypervisors; Virtual machine monitors
• CPC Class Codes: H04L 63/12 Applying verification of the received information cryptographic mechanisms or cryptographic arrangements for data integrity or data verification H04L9/32
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: H04W 12/10 Integrity

Abstract

Embodiments replicate resources in a multi-tenant cloud system. Embodiments receive a master resource, associated with a master account of the cloud system to be replicated, where the master resource includes a master JavaScript Object Notation (“JSON”) object and includes a plurality of master attributes. Embodiments generate a master resource metadata JSON by calculating hash values for each of the master attributes to generate master attribute level hashes and by calculating an aggregate of all of the hash values to generate a master resource level hash. Embodiments store each master attribute of the master JSON object in a separate column of a master database table associated with the master account and store the master resource metadata JSON is in a separate hash column of the master database table. Embodiments replicate the master JSON object to create a replicated JSON object including a plurality of replicated attributes.

Claims

1. A method of replicating resources in a multi-tenant cloud system, the comprising:

receiving a master resource, associated with a master account of the cloud system to be replicated, wherein the master resource comprises a master JavaScript Object Notation (JSON) object and comprises a plurality of master attributes;

generating a master resource metadata JSON by calculating hash values for each of the master attributes to generate master attribute level hashes and by calculating an aggregate of all of the hash values to generate a master resource level hash;

storing each master attribute of the master JSON object in a separate column of a master database table associated with the master account and store the master resource metadata JSON is in a separate hash column of the master database table;

replicating the master JSON object to create a replicated JSON object comprising a plurality of replicated attributes;

generating a replicated resource metadata JSON by calculating the hash values for each of the replicated attributes to generate replicated attribute level hashes and by calculating an aggregate of all of the hash values to generate a replicated resource level hash; and

storing each replicated attribute of the replicated JSON object in a separate column of a replicated database table associated with a replicated account of the cloud system and store the replicated resource metadata JSON in a separate hash column of the replicated database table.

2. The method of claim 1, further comprising:

comparing the master resource level hash with the replicated resource level hash;

wherein when there is a match, the master JSON object is determined to be equivalent to the replicated JSON object.

3. The method of claim 2, further comprising:

when there is not the match, comparing the master attribute level hashes with the replicated attribute level hashes.

4. The method of claim 1, further comprising:

storing in the separate column of the master database table a master time stamp value for each of the plurality of master attributes, the time stamp value indicating a last time the corresponding master attribute was modified; and

storing in the separate column of the replicated database table a replicated time stamp value for each of the plurality of replicated attributes, the replicated time stamp value indicating a last time the corresponding replicated attribute was modified.

5. The method of claim 1, wherein the separate hash column of the master database table and the separate hash column of the replicated database table are native JSON columns.

6. The method of claim 1, further comprising:

when the master JSON object is changed, updating the master attribute level hashes.

7. The method of claim 3, further comprising reconciling data for each master attribute level hash that does not match with the corresponding replicated attribute level hash.

8. A non-transitory computer-readable medium storing instructions which, when executed by one or more processors, cause the processors to replicate resources in a multi-tenant cloud system, the replicating comprising:

receiving a master resource, associated with a master account of the cloud system to be replicated, wherein the master resource comprises a master JavaScript Object Notation (JSON) object and comprises a plurality of master attributes;

generating a master resource metadata JSON by calculating hash values for each of the master attributes to generate master attribute level hashes and by calculating an aggregate of all of the hash values to generate a master resource level hash;

storing each master attribute of the master JSON object in a separate column of a master database table associated with the master account and store the master resource metadata JSON is in a separate hash column of the master database table;

replicating the master JSON object to create a replicated JSON object comprising a plurality of replicated attributes;

generating a replicated resource metadata JSON by calculating the hash values for each of the replicated attributes to generate replicated attribute level hashes and by calculating an aggregate of all of the hash values to generate a replicated resource level hash; and

storing each replicated attribute of the replicated JSON object in a separate column of a replicated database table associated with a replicated account of the cloud system and store the replicated resource metadata JSON in a separate hash column of the replicated database table.

9. The computer-readable medium of claim 8, the replicating further comprising:

comparing the master resource level hash with the replicated resource level hash;

wherein when there is a match, the master JSON object is determined to be equivalent to the replicated JSON object.

10. The computer-readable medium of claim 9, the replicating further comprising when there is not the match, comparing the master attribute level hashes with the replicated attribute level hashes.

11. The computer-readable medium of claim 8, the replicating further comprising:

storing in the separate column of the master database table a master time stamp value for each of the plurality of master attributes, the time stamp value indicating a last time the corresponding master attribute was modified; and

storing in the separate column of the replicated database table a replicated time stamp value for each of the plurality of replicated attributes, the replicated time stamp value indicating a last time the corresponding replicated attribute was modified.

12. The computer-readable medium of claim 8, wherein the separate column of the master database table and the separate column of the replicated database table are native JSON columns.

13. The computer-readable medium of claim 8, the replicating further comprising:

when the master JSON object is changed, updating the master attribute level hashes.

14. The computer-readable medium of claim 10, the replicating further comprising reconciling data for each master attribute level hash that does not match with the corresponding replicated attribute level hash.

15. A multi-tenant cloud system comprising:

a master database table and first processor associated with a master account of the cloud system; and

a replicated database table and second processor associated with a replicated account of the cloud system;

the first processor configured to receive a master resource, associated with the master account, wherein the master resource comprises a master JavaScript Object Notation (JSON) object and comprises a plurality of master attributes, and generate a master resource metadata JSON by calculating hash values for each of the master attributes to generate master attribute level hashes and by calculating an aggregate of all of the hash values to generate a master resource level hash;

the first processor further configured to store each master attribute of the master JSON object in a separate column of the master database table and store the master resource metadata JSON is in a separate hash column of the master database table;

one or both of the first processor or the second processor configured to replicate the master JSON object to create a replicated JSON object comprising a plurality of replicated attributes;

the second processor configured to generate a replicated resource metadata JSON by calculating the hash values for each of the replicated attributes to generate replicated attribute level hashes and by calculating an aggregate of all of the hash values to generate a replicated resource level hash, and store each replicated attribute of the replicated JSON object in a separate column of the replicated database table and store the replicated resource metadata JSON in a separate hash column of the replicated database table.

16. The multi-tenant cloud system of claim 15, the second processor further configured to compare the master resource level hash with the replicated resource level hash;

wherein when there is a match, the master JSON object is determined to be equivalent to the replicated JSON object.

17. The multi-tenant cloud system of claim 16, the second processor further configured to, when there is not the match, compare the master attribute level hashes with the replicated attribute level hashes.

18. The multi-tenant cloud system of claim 16, one or both of the first processor or the second processor configured to:

store in the separate column of the master database table a master time stamp value for each of the plurality of master attributes, the time stamp value indicating a last time the corresponding master attribute was modified; and

store in the separate column of the replicated database table a replicated time stamp value for each of the plurality of replicated attributes, the replicated time stamp value indicating a last time the corresponding replicated attribute was modified.

19. The multi-tenant cloud system of claim 16, wherein the separate column of the master database table and the separate column of the replicated database table are native JSON columns.

20. The multi-tenant cloud system of claim 16, the first processor further configured to, when the master JSON object is changed, update the master attribute level hashes.