Analysis services database synchronization

• US 20050278458A1
• Filed: 06/09/2004
• Published: 12/15/2005
• Est. Priority Date: 06/09/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Berger, Alexander, Melomed, Edward, Gringauze, Sergei
• Application Number:
  US10/864,745
• Publication Number:
  US 20050278458A1
• Time in Patent Office: Days
• US Class Current: 709/248
• 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: 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]

Abstract

Systems and methodologies are provided for synchronizing a state of a target serve with that of a source server. During such synchronization process users that interact with the target server can still query data therefrom, with no interruption of service, and are switched to a new state of database upon completion of the synchronization process. Additionally, a transaction consistency is maintained and system administrators are enabled to change location of the data caches, and distribute data and/or applications among a plurality of server configurations by the synchronization process.

Claims

1. A synchronization system comprising:

a transactional component that synchronizes a state of a target server and a source server, without an interruption of query processing to a plurality of clients serviced by the target server.

2. The synchronization system of claim 1 further comprising a partition designator component that reconfigures location of data to be synchronized on the target server during the synchronization process.

3. The synchronization system of claim 1 further comprising a differentiator component that determines a difference between a state of the target server and the source server.

4. The synchronization system of claim 1, the source server and the target server interact with relational databases.

5. The synchronization system of claim 1, the source server and the target server operate in a multidimensional environment.

6. The synchronization system of claim 5, the multidimensional environment comprises OLAP objects.

7. The synchronization system of claim 6, the multidimensional environment further comprising an analysis component with a Unified Dimensional Mode.

8. The synchronization system of claim 2 further comprising a registry partition system that provide access to stored information.

9. The synchronization system of claim 1, the state of the target server is updated via a partial synchronization performed between the target server and the source server.

10. The synchronization system of claim 1, the state of the target server is updated via a total synchronization performed between the target server and the source server.

11. The synchronization system of claim 1, the state of the target server and the source serer is synchronized by issuance of a single command.

12. The synchronization system of claim 1, the target server pulls data from the source server as part of a synchronization process.

13. The synchronization system of claim 3, the differentiator component operates on a log record provided by the target server.

14. A computer implemented method for synchronizing a state between a source server and a target server comprising:

restoring a target server that serves a plurality of clients to a state of a source server; and

maintaining a query processing service between the target server and the plurality of clients during the restoring act.

15. The method of claim 14 further comprising, sending a log record containing contents of the target server to the source server.

16. The method of claim 15 further comprising comparing the log record with contents of the source server.

17. The method of claim 16 further comprising determining a difference between the content of the target server with the content of the source server, and sending the difference to the target server.

18. The method of claim 14 further comprising building cache configurations on the target server that are different form the source server for data to be synchronized.

19. The method of claim 14 further comprising preserving a state of the data on the target server during the restoring act.

20. The method of claim 18 further comprising sending the difference in a compressed format to the source server.

21. A computer implemented method for synchronizing a target server with a source server comprising:

sending an image of a target server to a source server;

the target server processing queries of a plurality of clients;

restoring portions of a target server to a state of a source server; and

maintaining query processing between the target server and the plurality of clients during the restoring act.

22. The method of claim 21 further comprising restoring all contents of the target server to a state of the source server.

23. The method of claim 21 further comprising synchronizing the target server with designated partitions of the source server.

24. The method of claim 23 further comprising pulling data from the source server by the target server.

25. The method of claim 23 further comprising distributing data from the source among a plurality of target server configurations.

26. A computer-based synchronization system comprising:

a transactional component that restores a state of a target server with that of a source server in a data mining environment, the target server maintains query processing to a plurality of clients serviced thereby during restoration period; and

a partition designator component that reconfigures location of data on the target server during the synchronization process.

27. The synchronization system of claim 26 further comprising a differentiator component that determines a difference between a state of the target server and the source server.

28. The synchronization system of claim 26, the data mining environment includes an OLAP server.

29. The synchronization system of claim 28, further comprising an analytic server that schedules and invokes a data mining algorithm to analyze retrieved data.

30. A computer-implemented method for synchronizing a target server with a source server comprising:

receiving a synchronization command by the source server form a target server that services a plurality of clients;

comparing a state of the target server with the source server;

performing a back up of the source server on the target server while the target server maintains query processing with the plurality of clients.

31. The method of claim 30 further comprising receiving a log record by the source server, the log record indicating contents of the target server.

32. The method of claim 30 further comprising determining a difference between the target server and the source server.

33. The method of claim 30 further comprising processing OLAP objects by the source server.

34. A system for synchronizing a target server with a source server comprising:

means for maintaining query processing to a plurality of clients of the target server during a synchronization process of the target server; and

means for restoring the target server with a state of the source server.

35. The system of claim 34 further comprising means for partitioning the target server based on a user'"'"'s preference during the synchronization process.