System and method to search and generate reports from semi-structured data including dynamic metadata

• US 9,721,016 B2
• Filed: 11/10/2014
• Issued: 08/01/2017
• Est. Priority Date: 03/05/2004
• Status: Active Grant

• Current Assignee: OT IP SUB, LLC
• Original Assignee: Open Text Sa Ulc (Open Text Corporation)
• Inventors: Gruber, Thomas Robert
• Primary Examiner(s): Truong, Dennis
• Application Number:
  US14/537,572
• Publication Number:
  US 20150066891A1
• Time in Patent Office: 995 Days
• Field of Search: 707708, 707718, 707770, 715968
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/316 Indexing structures
• CPC Class Codes: G06F 16/332 Query formulation
• CPC Class Codes: G06F 16/83 Querying
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

Embodiments of the invention provide a system and method for searching and reporting on semistructured data that can include dynamic metadata. One embodiment can comprise providing a user interface to a user based on an object type definition for an object type that allows the user to specify search criteria associated with a set of metadata, mapping the user search criteria to a query that comprises at least one structured query constraint and at least one unstructured query constraint, processing the query to search a set of data objects containing semistructured data associated with the object type according to the query and returning a set of results to the user. The search results can be returned to a user based on user-specified reporting parameters. Additionally, the reporting definition can be saved as an object for future execution.

Claims

1. A method for providing searching on semistructured data, comprising:

generating a user interface based on an object type definition for an object type, the generating performed by a computer having at least one processor and non-transitory computer memory storing instructions translatable by the at least one processor, wherein the object type is defined with the object type definition, wherein the object type definition has at least one attribute, wherein each data object instantiated and associated with the object type has a set of metadata corresponding to the at least one attribute in the object type definition

presenting the user interface through a web browser running on a client device communicatively connected to the computer, wherein the user interface includes full text search criteria and search criteria associated with the set of metadata for which associated values are user-specifiable;

receiving user specified search criteria via the user interface, wherein the user specified search criteria comprise one or more of the full text search criteria, one or more of the search criteria associated with the set of metadata, or a combination thereof;

mapping, by an information retrieval engine embodied on non-transitory computer memory, the user specified search criteria to a query in a query language supported by the information retrieval engine;

the information retrieval engine processing the query, the processing including searching a set of data objects associated with the object type according to the query, the searching resulting in a listing of data objects meeting the user specified search criteria; and

returning the listing of data objects to the user interface.

2. The method according to claim 1, further comprising:

changing the user interface based on a change to the object type definition.

3. The method according to claim 2, wherein the object type definition comprises a set of attributes corresponding to the metadata in the instantiations of the object type and wherein the change to the object type definition is associated with an attribute of the set of attributes.

4. The method according to claim 1, further comprising:

responsive to a user request, saving the user specified search criteria as a query object.

5. The method according to claim 1, wherein the mapping comprises:

for a search criterion associated with metadata indexed as a field, mapping the search criterion to a structured query.

6. The method according to claim 1, wherein the mapping comprises:

for a search criterion associated with metadata not indexed as a field, mapping the search criterion to an unstructured pattern matching query.

7. The method according to claim 1, wherein the mapping comprises:

for a full text search criterion, mapping the full text search criterion to an unstructured query.

8. A system for providing searching on semistructured data, comprising:

at least one processor;

non-transitory computer memory; and

stored instructions translatable by the at least one processor to perform;

generating a user interface based on an object type definition for an object type, wherein the object type is defined with the object type definition, wherein the object type definition has at least one attribute, wherein each data object instantiated and associated with the object type has a set of metadata corresponding to the at least one attribute in the object type definition;

presenting the user interface through a web browser running on a client device, wherein the user interface includes full text search criteria and search criteria associated with the set of metadata for which associated values are user-specifiable;

receiving user specified search criteria via the user interface, wherein the user specified search criteria comprise one or more of the full text search criteria, one or more of the search criteria associated with the set of metadata, or a combination thereof;

mapping the user specified search criteria to a query;

processing the query, the processing including searching a set of data objects associated with the object type according to the query, the searching resulting in a listing of data objects meeting the user specified search criteria; and

returning the listing of data objects to the user interface.

9. The system of claim 8, wherein the stored instructions are further translatable by the at least one processor to perform:

changing the user interface based on a change to the object type definition.

10. The system of claim 9, wherein the object type definition comprises a set of attributes corresponding to the metadata in the instantiations of the object type and wherein the change to the object type definition is associated with an attribute of the set of attributes.

11. The system of claim 8, wherein the stored instructions are further translatable by the at least one processor to perform:

responsive to a user request, saving the user specified search criteria as a query object.

12. The system of claim 8, wherein the mapping comprises:

for a search criterion associated with metadata indexed as a field, mapping the search criterion to a structured query.

13. The system of claim 8, wherein the mapping comprises:

for a search criterion associated with metadata not indexed as a field, mapping the search criterion to an unstructured pattern matching query.

14. The system of claim 8, wherein the mapping comprises:

for a full text search criterion, mapping the full text search criterion to an unstructured query.

15. A computer program product for providing searching on semistructured data, the computer program product comprising at least one non-transitory computer readable medium storing computer instructions translatable by at least one processor to perform:

generating a user interface based on an object type definition for an object type, wherein the object type is defined with the object type definition, wherein the object type definition has at least one attribute, wherein each data object instantiated and associated with the object type has a set of metadata corresponding to the at least one attribute in the object type definition;

presenting the user interface through a web browser running on a client device, wherein the user interface includes full text search criteria and search criteria associated with the set of metadata for which associated values are user-specifiable;

receiving user specified search criteria via the user interface, wherein the user specified search criteria comprise one or more of the full text search criteria, one or more of the search criteria associated with the set of metadata, or a combination thereof;

mapping the user specified search criteria to a query;

processing the query, the processing including searching a set of data objects associated with the object type according to the query, the searching resulting in a listing of data objects meeting the user specified search criteria; and

returning the listing of data objects to the user interface.

16. The computer program product of claim 15, wherein the computer instructions are further translatable by the at least one processor to perform:

changing the user interface based on a change to the object type definition.

17. The computer program product of claim 16, wherein the object type definition comprises a set of attributes corresponding to the metadata in the instantiations of the object type and wherein the change to the object type definition is associated with an attribute of the set of attributes.

18. The computer program product of claim 15, wherein the stored instructions are further translatable by the at least one processor to perform:

responsive to a user request, saving the user specified search criteria as a query object.

19. The computer program product of claim 15, wherein the mapping comprises:

for a search criterion associated with metadata indexed as a field, mapping the search criterion to a structured query.

20. The computer program product of claim 15, wherein the mapping comprises:

for a search criterion associated with metadata not indexed as a field, mapping the search criterion to an unstructured pattern matching query.

21. The computer program product of claim 15, wherein the mapping comprises:

for a full text search criterion, mapping the full text search criterion to an unstructured query.