System and method to search and generate reports from semi-structured data
View Patent ↗Embodiments of the present 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.
1. A method for searching semistructured data comprising:
determining an object type to be searched;
accessing an object type definition for the object type;
providing a user interface to a user via a display device based on the object type definition for the object type, wherein the object type definition specifies a set of attributes representing metadata for data objects instantiated according to the object type, wherein the user interface allows the user to specify search criteria associated with the metadata;
mapping the user search criteria to a query, wherein the query comprises at least one structured query constraint and at least one unstructured query constraint;
processing the query to search a set of metadata for a set of data objects instantiated based on the object type according to the query, wherein each data object comprises semistructured data; and
returning a set of results to the user over a network connection as a report based on user specified reporting parameters.
2. The method of claim 1 , wherein the set of metadata comprises dynamic metadata that varies between at least two of the data objects in the set of data objects.
3. The method of claim 1 , further comprising indexing the set of data objects for an information retrieval engine.
4. The method of claim 3 , wherein indexing the set of data objects further comprises indexing a piece of metadata from the set of metadata using a token pattern.
5. The method of claim 3 , wherein the query further comprises a structured query constraint and an unstructured query constraint.
6. The method of claim 4 , wherein the at least one unstructured query constraint comprises a query constraint based on a search criterion associated with a piece of metadata.
7. The method of claim 4 , wherein the at least one unstructured query constraint comprises a query constraint based on a full text search criterion.
8. The method of claim 1 , further comprising storing a user specified search as a query search object.
9. The method of claim 1 , further comprising presenting the user with a report interface based on the object type definition that allows the user to specify the reporting parameters.
10. A computer program product for searching semistructured data comprising a set of computer instructions stored on a non-transitory computer readable medium, wherein the set of computer instructions comprise instructions being executable by one or more machines to:
determine an object type selected;
access an object type definition for the object type;
provide a user interface to a user based on the object type definition for the object type, wherein the object type definition comprises attributes representing metadata for data objects instantiated based on the object type, wherein the user interface allows the user to specify search criteria associated with the metadata;
map the user search criteria to a query;
process the query to search a set of metadata for a set of data objects instantiated based on the object type according to the query, wherein each data object comprises semistructured data;
return a set of results to the user; and
generate a report from the set of results based on user specified reporting parameters.
11. The computer program product of claim 10 , wherein the set of metadata comprises dynamic metadata that varies between at least two of the data objects in the set of data objects.
12. The computer program product of claim 10 , wherein the set of computer instructions further comprise instructions executable to index the set of data objects for an information retrieval engine.
13. The computer program product of claim 12 , wherein indexing the set of data objects further comprises indexing a piece of metadata from the set of metadata using a token pattern.
14. The computer program product of claim 10 , wherein the query comprises at least one structured query constraint based on a search criterion associated with a piece of metadata and an unstructured query constraint.
15. The computer program product claim 14 , wherein the unstructured query constraint comprises a query constraint based on a search criterion associated with a piece of metadata.
16. The computer program product of claim 14 , wherein the unstructured query constraint comprises a query constraint based on a full text search criterion.
17. The computer program product of claim 10 , wherein the set of computer instructions further comprise instructions executable to store a user specified search as a query search object.
18. The computer program product of claim 10 , wherein the set of computer instructions further comprises instructions executable to present a report interface that allows the user to specify the reporting parameters.
19. A method for ad hoc searching of semistructured data comprising;
defining an object type using an object type definition that comprises one or more attributes;
instantiating a set of data objects of the object type;
determining that the set of data objects is to be searched;
accessing the object type definition;
providing a user with a search user interface via a display device based on the object type definition, wherein the search user interface allows the user to specify search criteria comprising full text search criteria and search criteria associated with metadata;
mapping the search criteria to a query, wherein the query comprises:
at least one structured search query constraint based on a search criterion associated with a piece of metadata; and
at least one unstructured search constraint;
processing the query to search the set of data objects associated with the object type according to the query;
presenting the user with a report user interface based on the object type definition that allows the user to specify report parameters; and
returning a set of results over a network connection in a report based on the report parameters specified by the user.
20. The method of claim 19 , wherein a set of metadata for a first data object associated with the object type is different than a set of metadata for a second data object associated with the object type.
21. The method of claim 20 , further comprising saving a report definition as a query object and returning the set of results as an ad hoc report based on the report parameters.