Back to results
US 12,613,925 B2Granted
Composite index on hierarchical nodes in the hierarchical data model within case model
AssigneeOpen Text Corporation
InventorsJeroen M. van Rotterdam, Satyapal P. Reddy, Xiaoting Tang, Muneer Ahmed
Life of this patent
Estimating the term…
Abstract
Case management systems and techniques are disclosed. In various embodiments, searching case instances is facilitated. An indication to create a composite index across hierarchical case nodes comprising a case model is received. Case instance data associated with the case model is used to generate the composite index. The composite index is made available to be used to optimize searches of a plurality of case instances with which the case instance data is associated.
Claims21
A computer-implemented method of facilitating searching case instances, comprising:
- receiving, by a processor, an indication to create a composite index across hierarchical case nodes comprising a case model;
- analyzing programmatically a case model definition associated with the case model to determine two or more attributes associated with two or more case nodes with respect to which a criteria to generate the composite index is satisfied, the two or more case nodes comprising case nodes from at least two different levels of the hierarchy of case nodes;
- generating, by the processor, the composite index using case instance data for a plurality of case instances associated with the case model, generating the composite index comprising accessing a database storing the case instance data and storing attribute values from a plurality of database schema elements to the composite index, each of the two or more case nodes having an associated schema element from the plurality of database schema elements, wherein the composite index comprises:
- a combination of attribute values for the two or more attributes;
- and
- an indication of which of the plurality of case instances has the combination of attribute values;
- and
- deploying the composite index in an electronic case management system to facilitate searching the plurality of case instances using search criteria across multiple case nodes.
5 more elements
A computer program product to facilitate searching case instances, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
- receiving, by an electronic case management system, an indication to create a composite index across hierarchical case nodes comprising a case model;
- analyzing programmatically a case model definition associated with the case model to determine two or more attributes associated with two or more case nodes with respect to which a criteria to generate the composite index is satisfied, the two or more case nodes comprising case nodes from at least two different levels of the hierarchy of case nodes;
- and
- generating, by the electronic case management system, a composite index using case instance data for a plurality of case instances associated with the case model, wherein generating the composite index comprises accessing a database storing the case instance data and storing attribute values from a plurality of database schema elements to the composite index, each of the two or more case nodes having an associated schema element from the plurality of database schema elements, wherein the composite index comprises:
- a combination of attribute values for the two or more attributes;
- and
- an indication of which of the plurality of case instances has the combination of attribute values;
- and
- deploying the composite index in the electronic case management system to facilitate searching the plurality of case instances using search criteria across multiple case nodes.
6 more elements
An electronic case management system, comprising:
- a storage device configured to store a case model;
- a database storing database storing case instance data for a plurality of case instances associated with the case model, the case instance data stored across a plurality of database schema elements, and
- a processor coupled to the storage device and configured to:
- receive an indication to create a composite index across hierarchical case nodes comprising the case model;
- analyze programmatically a case model definition associated with the case model to determine two or more attributes associated with two or more case nodes with respect to which a criteria to generate the composite index is satisfied, the two or more case nodes comprising case nodes from at least two different levels of the hierarchy of case nodes;
- and
- using the case instance data to generate the composite index, wherein generating the composite index comprises storing attribute values from the plurality of database schema elements to the composite index, each of the two or more case nodes having an associated schema element from the plurality of database schema elements, wherein the composite index comprises:
- a combination of attribute values for the two or more attributes;
- and
- an indication of which of the plurality of case instances has the combination of attribute values;
- and
- deploying the composite index to facilitate searching the plurality of case instances using search criteria across multiple case nodes.
9 more elements
Dependencies are inferred from the claim text.