Building Reports

Patent metadata

Field	Value
Publication number	US-2016179930-A1
Application number	US-201514717633-A
Country	US
Kind code	A1
Filing date	May 20, 2015
Priority date	Dec 18, 2014
Publication date	Jun 23, 2016
Grant date	—

Abstract

Methods, systems, and apparatus, including computer programs encoded on computer storage media, for building reports. One of the methods includes creating a model based on relational structured data, the structured data including data structures, each data structure having data elements, each data element having fields, each field having a name. The method includes generating a hierarchy of objects in model, the hierarchy organizing objects the with respect to a starting object according to relationship fields on the objects. The method includes generating a user interface including elements for one or more of the objects in the hierarchy, wherein the user interface enables a user to create a report and filter the report using the new name. The method includes receiving a user selection of an element from the elements. The method also includes generating a report.

First claim

What is claimed is:

1 . A computer implemented method including:
creating a model based on structured data, the structured data including data structures, each data structure having data elements, each data element having fields, each field having a name, wherein creating the model includes:
creating an object in the model based on a data structure in the structured data;
translating a name of a field in the data structure to a natural language name;
creating a field on the object having the natural language name;
creating a relationship field on the object based on a relationship between data structures in the structured data;
generating a hierarchy of objects in model, the hierarchy organizing the objects with respect to a starting object according to relationship fields on the objects; generating a user interface including elements for one or more of the objects in the hierarchy, wherein the user interface enables a user to create a report and filter the report using the natural language name; receiving a user selection of an element from the elements; generating a report including:
identifying a data structure corresponding to the element;
obtaining data from at least one field in the identified data structure in the data source; and
presenting the data to the user.

2 . The method of claim 1 , wherein translating a name includes translating the name using a look up table.

3 . The method of claim 1 , wherein the relationship field is a reference field representing a relationship between one data element in the data structure to one second data element in a second data structure.

4 . The method of claim 1 , wherein the relationship field is a collection field representing a relationship between one data element in the data structure to second data elements in a second data structure.

5 . The method of claim 4 , wherein the user interface includes aggregation functions that can be used on the collection field.

6 . The method of claim 1 , wherein the relationship field is a parent-child field representing a relationship between one data element in the data structure to a second data element in the data structure.

7 . The method of claim 1 , wherein the structured data is a structured database and the data structure is a table in the structured database.

8 . The method of claim 1 , wherein the structured data is one or more files.

9 . The method of claim 1 , wherein generating the report occurs in response to receiving the user selection.

10 . The method of claim 1 , wherein the user interface enables an interactive creation of reports using a what-you-see-is-what-you-get interface and wherein the user interface provides visual feedback of the report including data values in near-real-time prior to finalizing the report.

11 . The method of claim 1 , wherein generating a user interface further includes receiving a selection of the starting object from a user.

12 . The method of claim 1 , wherein the natural language name includes at least one character in a set of restricted characters for the structured data.

13 . The method of claim 1 , wherein creating a relationship field on the object based on a relationship between data structures in the structured data includes creating a relationship object to represent a primary key—foreign key relationship in the structured data.

14 . A non-transitory computer storage medium encoded with computer program instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:
creating a model based on structured data, the structured data including data structures, each data structure having data elements, each data element having fields, each field having a name, wherein creating the model includes:
creating an object in the model based on a data structure in the structured data;
translating a name of a field in the data structure to a natural language name;
creating a field on the object having the natural language name;
creating a relationship field on the object based on a relationship between data structures in the structured data;
generating a hierarchy of objects in model, the hierarchy organizing the objects with respect to a starting object according to relationship fields on the objects; generating a user interface including elements for one or more of the objects in the hierarchy, wherein the user interface enables a user to create a report and filter the report using the natural language name; receiving a user selection of an element from the elements; generating a report including:
identifying a data structure corresponding to the element;
obtaining data from at least one field in the identified data structure in the data source; and
presenting the data to the user.

15 . The non-transitory computer readable medium of claim 14 , wherein translating a name includes translating the name using a look up table.

16 . The non-transitory computer readable medium of claim 14 , wherein the relationship field is a reference field representing a relationship between one data element in the data structure to one second data element in a second data structure.

17 . The non-transitory computer readable medium of claim 14 , wherein the relationship field is a collection field representing a relationship between one data element in the data structure to second data elements in a second data structure.

18 . The non-transitory computer readable medium of claim 17 , wherein the user interface includes aggregation functions that can be used on the collection field.

19 . The non-transitory computer readable medium of claim 14 , wherein the relationship field is a parent-child field representing a relationship between one data element in the data structure to a second data element in the data structure.

20 . The non-transitory computer readable medium of claim 14 , wherein the structured data is a structured database and the data structure is a table in the structured database.

21 . The non-transitory computer readable medium of claim 14 , wherein the structured data is one or more files.

22 . The non-transitory computer readable medium of claim 14 , wherein generating the report occurs in response to receiving the user selection.

23 . The non-transitory computer readable medium of claim 14 , wherein the user interface enables an interactive creation of reports using a what-you-see-is-what-you-get interface and wherein the user interface provides visual feedback of the report including data values in near-real-time prior to finalizing the report.

24 . The non-transitory computer readable medium of claim 14 , wherein generating a user interface further includes receiving a selection of the starting object from a user.

25 . The non-transitory computer readable medium of claim 14 , wherein the natural language name includes at least one character in a set of restricted characters for the structured data.

26 . The non-transitory computer readable medium of claim 14 , wherein creating a relationship field on the object based on a relationship between data structures in the structured data includes creating a relationship object to represent a primary key—foreign key relationship in the structured data.

27 . A system comprising:
one or more computers and one or more storage devices storing instructions that are operable,

Assignees

• Ab Initio Technology Llc

Inventors

• Radivojevic Dusan
• Moss Peter

Classifications

• G06F16/248

  Presentation of query results · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06Q10/00

  Administration; Management · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title