Automatically making changes in a document in a content management system based on a change by a user to other content in the document

• US 8,655,903 B2
• Filed: 02/15/2013
• Issued: 02/18/2014
• Est. Priority Date: 09/21/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cragun, Brian J., Petri, John E.
• Primary Examiner(s): Pulliam, Christyann
• Assistant Examiner(s): HOLLAND, SHERYL L
• Application Number:
  US13/768,381
• Publication Number:
  US 20130159342A1
• Time in Patent Office: 368 Days
• Field of Search: 707/765, 707/775
• US Class Current: 707/765
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

A content management system detects a change to one part of a document, and to generate a corresponding change in a different part of the same document. Dynamic inclusion rules define conditions that, when satisfied, allow automatically changing a link in a document to a new link when corresponding data in the document is added or changed. If a change corresponds to a defined dynamic inclusion rule, a corresponding query in the rule is evaluated according to the changes in the document. When there is enough information to run the query, the query is automatically executed in a background process. If there is a single link that satisfies the query, the document may be updated with the new link. If multiple links satisfy the query, the top ranked query result may be automatically selected, or the user may select which link should be included in the document.

Claims

1. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor;

a repository residing in the memory that includes a document that includes a plurality of elements; and

a content management system residing in the memory and executed by the at least one processor, the content management system comprising;

a dynamic inclusion rule that specifies at least one relationship between a data source in the document and a data target in the document and that specifies a corresponding query to the repository to execute when the data source in the document changes; and

a dynamic inclusion mechanism that monitors the document for changes to the data source specified in the dynamic inclusion rule, and when the data source in the document is changed, and when all parameters for the query are available to execute the query, the dynamic inclusion mechanism automatically executes the query in a background process, wherein the query includes at least one parameter corresponding to the changed data source, the query returning a query result and the dynamic inclusion mechanism automatically inserts a link to the query result at the data target in the document, and when the data source in the document is changed, and when not all parameters for the query are available to execute the query, the dynamic inclusion mechanism determines from a successful query database that stores successful queries for elements in the repository a plurality of related queries and presents a list of the related queries to a user who selects one of the related queries for execution, wherein the dynamic inclusion mechanism executes the selected query and automatically inserts into the document a link to results of executing the selected query at the data target in the document.

2. The apparatus of claim 1 further comprising a query monitor mechanism that stores successful queries for elements in the repository in a successful query database.

3. The apparatus of claim 2 wherein if the query returns a plurality of query results, ranking the query results using data in the successful query database, and selecting the top ranked query result for insertion into the document.

4. The apparatus of claim 1 wherein if the query returns a plurality of query results, notifying a user to select which query result is inserted into the document at the data target.

5. An article of manufacture comprising:

(A) a content management system comprising;

a dynamic inclusion rule that specifies at least one relationship between a data source in a document stored in a repository managed by the content management system and a data target in the document and that specifies a corresponding query to the repository to execute when the data source in the document changes; and

a dynamic inclusion mechanism that monitors the document for changes to the data source specified in the dynamic inclusion rule, and when the data source in the document is changed, and when all parameters for the query are available to execute the query, the dynamic inclusion mechanism automatically executes the query in a background process, wherein the query includes at least one parameter corresponding to the changed data source, the query returning a query result and the dynamic inclusion mechanism automatically inserting a link to the query result at the data target in the document, and when not all parameters for the query are available to execute the query, the dynamic inclusion mechanism determines from a successful query database that stores successful queries for elements in the repository a plurality of related queries and presents a list of the related queries to a user who selects one of the related queries for execution, wherein the dynamic inclusion mechanism executes the selected query and automatically inserts into the document a link to the results of executing the selected query at the data target in the document; and

(B) non-transitory computer-readable media bearing the content management system.

6. The article of manufacture of claim 5 further comprising a query monitor mechanism that stores successful queries for elements in the repository in a successful query database.

7. The article of manufacture of claim 6 wherein if the query returns a plurality of query results, ranking the query results using data in the successful query database, and selecting the top ranked query result for insertion into the document.

8. The article of manufacture of claim 5 wherein if the query returns a plurality of query results, notifying a user to select which query result is inserted into the document at the data target.

9. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor;

a repository residing in the memory that includes a document that includes a plurality of elements; and

a content management system residing in the memory and executed by the at least one processor, the content management system comprising;

a dynamic inclusion rule that specifies at least one relationship between a data source in the document and a data target in the document and that specifies a corresponding query to the repository to execute when the data source in the document changes; and

a dynamic inclusion mechanism that performs the steps of;

detecting a change by a user to a data source in the document referenced in a selected one of the dynamic inclusion rules;

in response to detecting the change by the user, performing the steps of;

populating the query in the selected dynamic inclusion rule, wherein the query includes at least one parameter corresponding to the changed data source;

when the populated query is sufficiently populated to allow execution of the populated query, performing the steps of;

 

executing the populated query;

 

when executing the populated query returns only a first query result, inserting at the data target in the document a link to the first query result;

 

when executing the populated query returns a plurality of query results, performing the steps of;

 

presenting a list of multiple query results to the user;

 

allowing the user to select a second query result from the list; and

 

inserting at the data target in the document a link to the second query result;

when the populated query is not sufficiently populated to allow execution of the populated query, performing the steps of;

 

searching a successful query database for similar successful queries;

 

ranking the similar successful queries based on frequency of use of each successful query in the successful query database;

 

populating the similar successful queries with parameters from document elements;

 

presenting a list of populated successful queries to the user;

 

the user selecting from the list a selected query to execute;

 

executing the selected query to return a third query result; and

 

inserting at the data target in the document a link to the third query result.