Content management system that retrieves data from an external data source and creates one or more objects in the repository
View Patent ↗A content management system (CMS) provides a way to include data from an external source as an object in the repository managed by the CMS. The CMS includes an external data mechanism that processes a document with a query to a data source external to the repository. The external data mechanism executes the query, and creates one or more objects in the repository according to the type of data returned as defined by classification rules. Each object containing data returned from the query is linked to that query via a formal relationship in the CMS. When an object that has a formal relationship with a query is checked out of the repository, the query corresponding to the object may be executed, and the data returned from the query may be stored in the object. In the alternative, the data may be used directly if a corresponding lifecycle policy indicates the corresponding query should not be executed.
1. A computer-implemented method for a content management system that manages a plurality of objects in a repository to reference a data source external to the repository, the method comprising the steps of:
when checking into the repository an XML document that contains a query, performing the steps of:
executing the query;
evaluating data returned from the query to determine whether the data satisfies classification rules;
if the data satisfies the classification rules, performing the steps of:
creating a returned data object in the repository containing the data;
creating a query object in the repository containing the query;
replacing the query in the XML document with a link to the retuned data object;
creating a link between the query object and the returned data object;
configuring a lifecycle policy corresponding to the query object that determines when the query in the query object is executed;
if the data does not satisfy the classification rules, performing the step of:
importing the data directly into the XML document;
when checking the returned data object out of the repository, performing the steps of:
determine from the lifecycle policy corresponding to the query object whether the query in the query object should be executed;
if the query in the query object should be executed, performing the step of updating the returned data object with results of executing the query within the query object with the link to the returned data object; and
if the query in the query object should not be executed, performing the step of breaking the link between the query object and the returned data object.