Method and system for morphing object types in enterprise content management systems
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.
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;
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;
wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a non-Structured Query Language (NoSQL), non-relational database hosted in a staging environment;
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;
wherein the 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 and improves efficiency of the morphing the object types in the enterprise content management system by reducing a number of audit trail objects created;
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 such that 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;
wherein the migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL non-relational database hosted in a staging environment;
wherein the storing the plurality of objects in the NoSQL, non-relational database and retrieving the metadata tables from the NoSQL, non-relational database improve efficiency of the morphing the object types in the enterprise content management system by reducing a time required for the morphing the object types in the enterprise content management system.
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 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.
5. 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 the database for a plurality of objects of the first object type by executing a remote procedure call to the enterprise content management database;
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;
wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a non-Structured Query Language (NoSQL), non-relational database hosted in a staging environment;
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;
wherein the 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 and improves efficiency of the morphing the object types in the enterprise content management system by reducing a number of audit trail objects created;
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 such that 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;
wherein the migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL, non-relational database hosted in a staging environment;
wherein the storing the plurality of objects in the NoSQL, non-relational database and retrieving the metadata tables from the NoSQL, non-relational database improve efficiency of the morphing the object types in the enterprise content management systems by reducing a time required for the morphing the object types in the enterprise content management system.
6. The computer-implemented method of claim 5 , 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.
7. The computer-implemented method of claim 5 , wherein the plurality of objects comprise a plurality of schemas and a plurality of metadata associated with the plurality of objects.
8. The computer-implemented method of claim 5 , 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.
9. 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 to 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;
storing the retrieved plurality of objects in a staging database;
wherein storing the plurality of objects in the staging database comprises storing the plurality of objects in a non-Structured Query Language (NoSQL), non-relational database hosted in a staging environment;
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;
wherein the executing the remote procedure call enables a direct interaction with the enterprise content management database at a level of an enterprise content management system among several levels of an enterprise content management system and improves efficiency of the morphing the object types in the enterprise content management system by reducing a number of audit trail objects created;
creating at least one property table in the enterprise content management database for the second object type, and
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 such that 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;
wherein the migrating the plurality of objects from the staging database comprises retrieving metadata tables from the NoSQL, non-relational database hosted in a staging environment;
wherein the storing the plurality of objects in the NoSQL, non-relational database and retrieving the metadata tables from the NoSQL, non-relational database improve efficiency of the morphing the object types in the enterprise content management system by reducing a time required for the morphing the object types in the enterprise content management system.
10. The computer program product of claim 9 , 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.
11. The computer program product of claim 9 , wherein the plurality of objects comprise a plurality of schemas and a plurality of metadata associated with the plurality of objects.
12. The computer program product of claim 9 , 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.