SYNCHRONIZATION OF TRANSACTIONAL DATA AND ANALYTICAL DATA BETWEEN DATA CENTERS

• US 20140258227A1
• Filed: 03/08/2013
• Published: 09/11/2014
• Est. Priority Date: 03/08/2013
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Apigee Corporation (Alphabet Inc.)
• Inventors: Muguda, Naveenkumar
• Granted Patent: US 9,443,087 B2
• Time in Patent Office: Days
• US Class Current: 707/624
• CPC Class Codes: G06F 17/40 Data acquisition and logging for input to computer G06F3/00
• CPC Class Codes: G06F 21/60 Protecting data
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 2221/2101 Auditing as a secondary aspect
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management

Abstract

Synchronization of transactional data and analytical data between data centers. Metadata is received by a transactional system from a user interface included in a customer data center. The metadata is then forwarded from the customer data center to an analytical system in a master data center. Data is forwarded from the customer data center to the master data center, the data being encrypted with a key uniquely associated with a customer. Role creation calls to create roles for one or more users associated with the customer data center are subsequently detected. The role creation calls crossing a data center boundary are further masqueraded.

Claims

1. A method of synchronizing transactional data and analytical data between data centers, the method comprising:

receiving metadata by a transactional system from a user interface comprised in a customer data center;

forwarding the metadata from the customer data center to an analytical system in a master data center;

forwarding data from the customer data center to the master data center, wherein the data is encrypted with a key uniquely associated with a customer;

detecting role creation calls to create roles for one or more users associated with the customer data center; and

masquerading the role creation calls crossing a data center boundary.

2. The method as claimed in claim 1, wherein forwarding the metadata comprises:

storing the metadata in the master data center.

3. The method as claimed in claim 1, wherein forwarding the data comprises:

storing the data in the customer data center.

4. The method as claimed in claim 1, wherein masquerading the role creation calls comprises:

authenticating one or more metadata calls in the customer data center.

5. The method of claim 1 and further comprising

managing user credentials of the one or more users associated with the customer data center.

6. The method of claim 5 and further comprising

enabling remote resetting of the user credentials of the one or more users by the master data center.

7. A multi data center system for synchronizing transactional data and analytical data, the multi data center system comprising:

a customer data center comprising;

a transactional system;

a user interface unit that receives metadata;

a transactional sniffer unit that detects the metadata;

a first ephemeral data storage unit that receives data from the transactional system;

a data forwarder unit that forwards the data to a master data center;

a metadata store that stores the metadata and the data;

a role masquerader unit that masquerades role creation calls crossing a data center boundary;

an analytical proxy unit that routes traffic from the customer data center to the master data center;

a first user management unit that manages user credentials of one or more users associated with the customer data center; and

a user management sniffer unit that detects role creation calls to create roles for the one or more users associated with the customer data center; and

the master data center comprising;

an analytical system;

a metadata receiver that receives the metadata from the transactional sniffer unit;

a metadata storage unit that stores the metadata;

a data receiver unit that receives the data from the data forwarder unit;

a second ephemeral data storage unit that receives data from the transactional system;

a credential management interface unit that enables remote resetting of the user credentials; and

a second user management unit that manages the one or more users.

8. The multi data center system as claimed in claim 7, wherein the user interface unit further initiates queries that need to be serviced by the analytical system and the data forwarder unit.

9. The multi data center system as claimed in claim 7, wherein the first ephemeral data storage unit encrypts the data with a key uniquely associated with a customer.

10. The multi data center system as claimed in claim 7, wherein the role masquerader unit masquerades the role creation calls on authentication of one or more metadata calls in the customer data center.

11. A computer program product stored on a non-transitory computer-readable medium that when executed by a processor, performs a method of synchronizing transactional data and analytical data between data centers, comprising:

receiving metadata by a transactional system from a user interface comprised in a customer data center;

forwarding the metadata from the customer data center to an analytical system in a master data center;

forwarding data from the customer data center to the master data center, wherein the data is encrypted with a key uniquely associated with a customer;

detecting role creation calls to create roles for one or more users associated with the customer data center; and

masquerading the role creation calls crossing a data center boundary.

12. The computer program product as claimed in claim 11, wherein forwarding the metadata comprises:

storing the metadata in the master data center.

13. The computer program product as claimed in claim 11, wherein forwarding the data comprises:

storing the data in the customer data center.

14. The computer program product as claimed in claim 11, wherein masquerading the role creation calls comprises:

authenticating one or more metadata calls in the customer data center.

15. The computer program product of claim 11 and further comprising

managing user credentials of the one or more users associated with the customer data center.

16. The computer program product of claim 15 and further comprising

enabling remote resetting of the user credentials of the one or more users by the master data center.