Method and system for facilitating migration of a computing environment

• US 8,234,314 B2
• Filed: 01/28/2010
• Issued: 07/31/2012
• Est. Priority Date: 05/23/2003
• Status: Expired due to Term

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Open TEXT SA (Open Text Corporation)
• Inventors: Tulkoff, Michael C., Collins, Jeffrey M.
• Primary Examiner(s): Saeed, Usmaan
• Application Number:
  US12/695,797
• Publication Number:
  US 20100131572A1
• Time in Patent Office: 915 Days
• Field of Search: None
• US Class Current: 707/803
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Systems and methods are described which facilitate the integration of data into a content management system. Legacy data is inspected, and content types are generated based on a data model. From these content types, content type objects may be generated. The data may then be examined to acquire a key set, and a content instance object generated for each datum found which matches a content type. This content instance object can then be associated with the datum using one or more key values, saved, and subsequently used to manage the data. These methods and systems allow data to be migrated to a content management system without any modification to the existing data repository or its associated structures.

Claims

1. A method for integrating legacy data into a content management system computer, comprising:

analyzing a set of legacy data residing in a legacy data repository on a persistent data source computer connected to said content management system computer over a network, wherein the analyzing includes gathering requirements for content types to be generated, the content types being representative of the set of legacy data;

generating a set of content types to represent the set of legacy data in the content management system based on the analysis of the set of legacy data, wherein at least one of said set of content types is defined by a user through a graphical user interface of a client computer connected to said content management system computer over the network;

generating a set of content type objects corresponding to the set of content types, wherein a content type object is an instantiation of a content type embodied in the content management system;

generating a set of content instance objects from the content type objects, wherein each content instance object is an instantiation of a content instance and is associated with a content type object;

associating each of the set of legacy data with at least one of the content instance objects; and

managing the set of legacy data residing in the legacy data repository on said persistent data source computer using the content instance objects generated by the content management system computer.

2. The method of claim 1, wherein generating the set of content types comprises specifying attributes associated with each of the set of content types.

3. The method of claim 1, wherein the set of content type obects are generated using a content modeler presented by the graphical user interface of the client computer.

4. The method of claim 1, comprising analyzing the set of legacy data to generate a set of keys associated with the set of legacy data.

5. The method of claim 4, comprising generating values for the set of keys for each of the content instance objects and associating the values with the content instance object.

6. The method of claim 5, wherein the values are acquired by querying the legacy data repository.

7. The method of claim 1, wherein each of the set of content types comprises a structured definition of a corresponding content type object.

8. The method of claim 7, wherein each of the content type objects comprises an XML document.

9. The method of claim 7, wherein each of the set of content types has associated access controls or policies.

10. The method of claim 1, comprising managing the set of legacy data using workflows, access control or policies associated with each of the set of content types.

11. The method of claim 1, wherein the content instance objects are stored at a location remote from the legacy data repository.

12. The method according to claim 1, further comprising:

setting key values of said content instance object to match or represent key values of a corresponding piece of legacy data residing in said legacy data repository.

13. The method according to claim 1, wherein said legacy data repository comprises a legacy database.

14. The method according to claim 1, further comprising:

enabling said user to perform policy annotation in defining said at least one of said set of content types through said graphical user interface of said client computer connected to said content management system computer over said network.

15. A computer program product comprising one or more non-transitory computer readable storage media storing computer instructions translatable by a processor to perform:

analyzing a set of legacy data residing in a legacy data repository connected to a content management system computer over a network, wherein the analyzing includes gathering requirements for content types to be generated, the content types being representative of the set of legacy data;

generating a set of content types to represent the set of legacy data in the content management system based on the analysis of the set of legacy data, wherein at least one of said set of content types is defined by a user through a graphical user interface of a client computer connected to said content management system computer over the network;

saving the set of content types in a memory of said content management system computer;

generating a set of content type objects corresponding to the set of content types, wherein a content type object is an instantiation of a content type embodied in the content management system;

generating a set of content instance objects from the content type objects, wherein each content instance object is an instantiation of a content instance and is associated with a content type object or a content type;

associating each of the set of legacy data with at least one of the content instance objects; and

managing the set of legacy data residing in the legacy data repository on said persistent data source computer using the content instance objects generated by the content management system computer.

16. The computer program product of claim 15, wherein the set of content type objects are generated using a content modeler presented by the graphical user interface of the client computer.

17. The computer program product of claim 15, wherein the computer instructions are further translatable by the processor to perform:

analyzing the set of legacy data to generate a set of keys associated with the set of legacy data.

18. The computer program product of claim 17, wherein the computer instructions are further translatable by the processor to perform:

generating values for the set of keys for each of the content instance objects and associating the values with the content instance object.

19. The computer program product of claim 18, wherein the values are acquired by querying the legacy data repository.

20. The computer program product of claim 15, wherein each of the set of content types has associated access controls or policies.

21. The computer program product of claim 15, wherein the computer instructions are further translatable by the processor to perform:

managing the set of legacy data using workflows, access controls or policies associated with each of the set of content types.

22. The computer program product of claim 15, wherein the computer instructions are further translatable by the processor to perform:

setting key values of said content instance object to match or represent key values of a corresponding piece of legacy data residing in said legacy data repository.

23. The computer program product of claim 15, wherein the computer instructions are further translatable by the processor to perform:

enabling said user to perform policy annotation in defining said at least one of said set of content types through said graphical user interface of said client computer connected to said content management system computer over said network.

24. A system, comprising:

a legacy data repository storing legacy data;

a content management system connected to the legacy data repository over a network; and

one or more client computers connected to the content management system, wherein the content management system embodies a computer program product comprising one or more computer readable storage media storing computer instructions translatable by a processor to perform;

analyzing a set of legacy data residing in the legacy data repository, wherein the analyzing includes gathering requirements for content types to be generated, the content types being representative of the set of legacy data;

generating a set of content types to represent the set of legacy data in the content management system based on the analysis of the set of legacy data, wherein at least one of said set of content types is defined by a user through a graphical user interface of a client computer connected to said content management system computer;

generating a set of content type objects corresponding to the set of content types, wherein a content type object is an instantiation of a content type embodied in the content management system;

generating a set of content instance objects from the content type objects, wherein each content instance object is an instantiation of a content instance and is associated with a content type object or a content type;

associating each of the set of legacy data with at least one of the content instance objects; and

managing the set of legacy data residing in the legacy data repository on said persistent data source computer using the content instance objects generated by the content management system computer.

25. The system of claim 24, wherein the set of content type objects are generated using a content modeler presented by the graphical user interface of the client computer.

26. The system of claim 24, wherein the computer instructions are further translatable by the processor to perform:

analyzing the set of legacy data to generate a set of keys associated with the set of legacy data.

27. The system of claim 26, wherein the computer instructions are further translatable by the processor to perform:

generating values for the set of keys for each of the content instance objects and associating the values with the content instance object.

28. The system of claim 27, wherein the values are acquired by querying the legacy data repository.

29. The system of claim 24, wherein each of the set of content types has associated access controls or policies.

30. The system of claim 24, wherein the computer instructions are further translatable by the processor to perform:

managing the set of legacy data using workflows, access controls or policies associated with each of the set of content types.

31. The system of claim 24, wherein the computer instructions are further translatable by the processor to perform:

setting key values of said content instance object to match or represent key values of a corresponding piece of legacy data residing in said legacy data repository.

32. The system of claim 24, wherein the computer instructions are further translatable by the processor to perform:

enabling said user to perform policy annotation in defining said at least one of said set of content types through said graphical user interface of said client computer connected to said content management system computer over said network.