Reporting engine for object relational networks

• US 20080086683A1
• Filed: 10/03/2007
• Published: 04/10/2008
• Est. Priority Date: 10/06/2006
• Status: Abandoned Application

• Current Assignee: Dassault Systemes Americas Corp. (Dassault Systemes SA)
• Original Assignee: Dassault Systemes Americas Corp. (Dassault Systemes SA)
• Inventors: Rich, William, Resio, James, Narayanasamy, Subramaniam, Rickus, Stephen
• Application Number:
  US11/906,618
• Publication Number:
  US 20080086683A1
• Time in Patent Office: Days
• US Class Current: 715/239
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 9/45512 Command shells

Abstract

A reporting engine for searching data in relational databases enables data retrieval through simple user input objects while respecting the business logic and security logic of the relational database. The reporting engine includes a template that expands user-input objects to search an exposed object network that is located in an application layer of the relational database. The reporting engine also displays the search results in output report format.

Claims

1. A method for searching a relational database and generating reports comprising the steps of:

selecting input objects on a user interface,

identifying a template to use for processing, the template including a scripting language,

expanding the template to an object network exposed by an application layer of the relational database, the object network composed of related objects, wherein the scripting language identifies requested objects by the objects Type or supertype,

placing the requested objects in an intermediate structure format,

transforming the intermediate structure format to a report output format, and

respecting a security logic of the application layer such that only authorized objects are reported.

2. The method of claim 1, wherein the scripting language uses substantially the same syntax as xsl script.

3. The method of claim 1, wherein the template is customizable.

4. The method of claim 1, wherein the objects in the object network further include ancestor types.

5. The method of claim 1, wherein the intermediate structure format is XML.

6. The method of claim 1, wherein the intermediate structure format is converted in the transforming step with xsl.

7. The method of claim 1, wherein the scripting language searches one or a multiplicity of objects in the application layer.

8. The method of claim 1, wherein a Type of a first object is used to query a second object.

9. The method of claim 1, wherein one criteria of the scripting language searches is a filter criteria, wherein only certain types of objects are kept.

10. A method for searching a relational database and generating reports comprising the steps employing search criteria, navigating an application layer infrastructure of a relational database, the relational database spanning multiple applications, searching external systems mapped into the relational database, and reporting on objects found in the application layer and external systems of the relational database based that meet the search criteria.

11. The method of claim 10, wherein additional navigation is triggered by expanding a named relationship on a found object such that the output of a search is used as the input to a next search.

12. A reporting engine system comprising:

a graphical user interface,

a template containing processing instructions in a scripting language,

an application layer having exposing objects in an object network, wherein each object in the object network includes a type, and each Type includes a set of attribute values, the template operably associated with the application layer to search the object network in accordance with the processing instructions, and

a transformation script operably associated with the template, the transformation script permitting transformation of found objects to a report output format.

13. The system of claim 12, wherein the scripting language uses substantially the same syntax as used in a web server navigation of the relational database.

14. The system of claim 12, wherein the template is customizable.

15. The system of claim 12, wherein one or a multiplicity of types further include supertypes.

16. The system of claim 12, wherein the scripting language searches one or a multiplicity of objects in the object network of the application layer.

17. The system of claim 16, wherein a Type of a first object is used to query a second object.

18. A reporting engine system comprising:

a graphical user interface,

a template containing processing instructions in a scripting language, the template selectable in the graphical user interface, the processing instruction enabling navigation of an application layer having exposing objects in an object network to find objects, and

a transformation script operably associated with the template, the transformation script permitting transformation of found objects to a report output format.

19. The system of claim 18, wherein the scripting language searches one or a multiplicity of objects in the object network of the application layer.

20. The system of claim 19, wherein one criteria of the scripting language is based on correlation criteria, wherein a Type of a first object is used to query a second object.