Method and system for morphing object types in enterprise content management systems

• US 10,108,914 B2
• Filed: 05/31/2017
• Issued: 10/23/2018
• Est. Priority Date: 03/14/2013
• Status: Active Grant

• Current Assignee: Open Text Corporation
• Original Assignee: Open Text Corporation
• Inventors: Mohen, Michael T., Dyde, Christopher
• Primary Examiner(s): Yesildag, Mehmet
• Application Number:
  US15/610,063
• Publication Number:
  US 20170262777A1
• Time in Patent Office: 510 Days
• Field of Search: None
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations

Abstract

Morphing object types in enterprise content management systems is described. A text properties file is created that maps properties associated with an object type to properties associated with a new object type. A database associated with an enterprise content management system is queried to retrieve objects based on the object type. The objects are stored in a staging database. The objects are deleted from the database. Property tables are created in the database based on the new object type. The objects are migrated from the staging database to the newly created property tables based on the text properties file.

Claims

1. A system for morphing object types in enterprise content management systems, the system comprising:

at least one processor;

a non-transitory computer readable medium storing a plurality of instructions, which when executed by the at least one processor, cause the at least one processor to;

create a text properties file that maps properties associated with a first object type to properties associated with a second object type, the first object type being different than the second object type;

query an enterprise content management database for a plurality of objects of the first object type by executing a remote procedure call to the enterprise content management database to directly interact with the enterprise content management database at a level of the enterprise content management database among several levels of an enterprise content management system;

retrieve the plurality of objects of the first object type from the enterprise content management database, wherein the properties associated with the first object type have been mapped to the properties associated with the second object type in the text properties file;

store the retrieved plurality of objects in a staging database;

delete the plurality of objects of the first object type from the enterprise content management database in response to the retrieved plurality of objects being stored in the staging database;

create at least one property table in the enterprise content management database for the second object type;

migrate the plurality of objects of the first object type from the staging database to the at least one property table created in the enterprise content management database for the second object type based on the mapping of the first object type with the second object type in the text properties file wherein the plurality of objects of the first object type are stored as objects of the second object type in the at least one property table; and

selectively retain only a portion of metadata of objects of the plurality of objects whose object type is changed.

2. The system of claim 1, wherein at least one of the properties associated with the first object type comprise at least some of the properties associated with the second object type, the properties associated with the second object type correspond to at least some of the properties associated with the first object type, and the properties associated with the second object type comprise properties absent from the properties associated with the first object type.

3. The system of claim 1, wherein the plurality of objects comprises a plurality of schemas and a plurality of metadata associated with the plurality of objects.

4. The system of claim 1, wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a NoSQL non-relational database hosted in a staging environment.

5. The system of claim 4, wherein migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL non-relational database.

6. The system of claim 1, wherein the non-transitory computer readable medium stores further instructions, which when executed by the at least one processor, cause the at least one processor to select the text properties file, and load the selected text properties file by specifying a path to the text properties file.

7. A computer-implemented method for morphing object types in enterprise content management systems, the method comprising:

creating a text properties file that maps properties associated with a first object type to properties associated with a second object type, the first object type being different than the second object type;

querying an enterprise content management database for a plurality of objects of the first object type by executing a remote procedure call to the enterprise content management database, wherein executing the remote procedure call enables a direct interaction with the enterprise content management database at a level of the enterprise content management database among several levels of an enterprise content management system;

retrieving the plurality of objects of the first object type from the enterprise content management database, wherein the properties associated with the first object type have been mapped to the properties associated with the second object type in the text properties file;

storing the retrieved plurality of objects in a staging database;

deleting the plurality of objects of the first object type from the enterprise content management database in response to the retrieved plurality of objects being stored in the staging database;

creating at least one property table in the enterprise content management database for the second object type;

migrating the plurality of objects of the first object type from the staging database to the at least one property table created in the enterprise content management database for the second object type based on the mapping of the first object type with the second object type in the text properties file wherein the plurality of objects of the first object type are stored as objects of the second object type in the at least one property table; and

selectively retaining only a portion of metadata of objects of the plurality of objects whose object type is changed.

8. The computer-implemented method of claim 7, wherein at least one of the properties associated with the first object type comprise at least some of the properties associated with the second object type, the properties associated with the second object type correspond to at least some of the properties associated with the first object type, and the properties associated with the second object type comprise properties absent from the properties associated with the first object type.

9. The computer-implemented method of claim 7, wherein the plurality of objects comprises a plurality of schemas and a plurality of metadata associated with the plurality of objects.

10. The computer-implemented method of claim 7, wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a NoSQL non- relational database hosted in a staging environment.

11. The computer-implemented method of claim 10, wherein migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL non-relational database.

12. The computer-implemented method of claim 7, wherein the method further comprises selecting the text properties file, and loading the selected text properties file by specifying a path to the text properties file.

13. A computer program product, comprising a non-transitory computer readable medium having a computer-readable program code embodied therein, the computer readable program code adapted to be executed by one or more processors to implement a method for morphing object types in enterprise content management systems, the method comprising:

creating a text properties file that maps properties associated with a first object type to properties associated with a second object type, the first object type being different than the second object type;

querying an enterprise content management database for a plurality of objects of the first object type by executing a remote procedure call to the enterprise content management database, wherein executing the remote procedure call enables a direct interaction with the enterprise content management database at a level of the enterprise content management database among several levels of an enterprise content management system;

retrieving the plurality of objects of the first object type from the enterprise content management database, wherein the properties associated with the first object type have been mapped to the properties associated with the second object type in the text properties file;

storing the retrieved plurality of objects in a staging database;

deleting the plurality of objects of the first object type from the enterprise content management database in response to the retrieved plurality of objects being stored in the staging database;

creating at least one property table in the enterprise content management database for the second object type;

migrating the plurality of objects of the first object type from the staging database to the at least one property table created in the enterprise content management database for the second object type based on the mapping of the first object type with the second object type in the text properties file wherein the plurality of objects of the first object type are stored as objects of the second object type in the at least one property table; and

selectively retaining only a portion of metadata of objects of the plurality of objects whose object type is changed.

14. The computer program product of claim 13, wherein at least one of the properties associated with the first object type comprise at least some of the properties associated with the second object type, the properties associated with the second object type correspond to at least some of the properties associated with the first object type, and the properties associated with the second object type comprise properties absent from the properties associated with the first object type.

15. The computer program product of claim 13, wherein the plurality of objects comprises a plurality of schemas and a plurality of metadata associated with the plurality of objects.

16. The computer program product of claim 13, wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a NoSQL non- relational database hosted in a staging environment.

17. The computer program product of claim 16, wherein migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL non- relational database.

18. The computer program product of claim 13, wherein the method further comprises selecting the text properties file, and loading the selected text properties file by specifying a path to the text properties file.