Data element visualization interface

Patent metadata

Field	Value
Publication number	US-11216479-B2
Application number	US-201715801434-A
Country	US
Kind code	B2
Filing date	Nov 2, 2017
Priority date	Jan 21, 2017
Publication date	Jan 4, 2022
Grant date	Jan 4, 2022

Abstract

Techniques for visualizing data elements are disclosed. A system presents a first data element profile comprising: a first data element; a second data element; and a first formula used to calculate a value of the first data element using a value of the second data element. The system detects user input selecting the second data element. Based on detecting the user input, the system presents a second data element profile comprising: the second data element; a third data element; and a second formula used to calculate a value of the second data element using a value of the third data element. The system detects user input selecting the third data element. Based on detecting the user input, the system presents a third data element profile comprising the third data element.

First claim

What is claimed is:

1. A non-transitory computer readable medium comprising instructions which, when executed by one or more hardware processors, cause performance of operations comprising:
presenting a first data element profile at least by:
presenting a first data element as a first component of a plurality of components in the first data element profile, the first data element being one of a plurality of data elements used by an application,
presenting a second data element as a second component of the plurality of component in the first data element profile, the second data element being another one of the plurality of data elements, and
presenting a first formula as another component of the plurality of components in the first data element profile, wherein the application is configured to calculate, based on the first formula, at least one value of the first data element using at least one value of the second data element;

detecting a first user input selecting the second data element in the first data element profile;
presenting, based on detecting the first user input, a second data element profile at least by:
presenting the second data element as a first component of a plurality of components in the second data element profile, the second data element being one of a plurality of data elements used by an application,
presenting a third data element as a second component of the plurality of component in the second data element profile, the third data element being another one of the plurality of data elements, and
presenting a second formula as another component of the plurality of components in the second data element profile, wherein the application is further configured to calculate, based on the second formula, at least one value of the second data element using at least one value of the third data element;

detecting a second user input selecting the third data element in the second data element profile; and
presenting, based on detecting the second user input, a third data element profile comprising the third data element.

2. The medium of claim 1 , wherein presenting the first data element profile further comprises:
presenting a fourth data element as a third component of the plurality of components in the first data element profile of the plurality of data elements used by the application, and
wherein the application is further configured to calculate, based on a third formula, at least one value of the fourth data element using at least one value of the first data element.

3. The medium of claim 2 , wherein the operations further comprise:
detecting a third user input selecting the fourth data element in the first data element profile; and
presenting, based on detecting the third user input, a fourth data element profile comprising:
the first data element,
the fourth data element, and
the third formula.

4. The medium of claim 3 , wherein the first data element is selectable in the fourth data element profile to present the first data element profile.

5. The medium of claim 1 , wherein the operations further comprise:
presenting a dependency graph comprising:
a first visual representation of the first data element,
a second visual representation of the second data element,
a third visual representation of the third data element,
a first connector, based on the first formula, indicating a first dependency of the first data element on the second data element, and
a second connector, based on the second formula, indicating a second dependency of the second data element on the third data element.

6. The medium of claim 1 , wherein the first user input comprises a click on a hyperlink representing the second data element.

7. The medium of claim 1 , wherein the application is a payroll administration application.

8. The medium of claim 1 , wherein at least two data elements in the plurality of data elements have different data element types.

9. The medium of claim 1 , wherein the operations further comprise:
receiving a search term;
applying the search term to the plurality of data elements to obtain a search result comprising the first data element; and
detecting a third user input selecting the first data element in the search result, wherein presenting the first data element profile is performed responsive to detecting the third user input.

10. The medium of claim 9 , wherein the search result further comprises a different data element having a different data element type than the first data element.

11. The medium of claim 1 , wherein the presenting the first formula comprises presenting editable code.

12. The medium of claim 1 , wherein the third data element profile further comprises a data element viewing history, the data element viewing history being selectable in a first location to present the first data element profile and selectable in a second location to present the second data element profile.

13. The medium of claim 1 , wherein the second data element profile further comprises historical data associated with a plurality of instances of calculating at least one value of the first data element using at least one value of the second data element.

14. A system comprising:
one or more hardware processors; and
one or more one or more non-transitory computer-readable media storing instructions, which when executed by the one or more hardware processors, cause execution of operations comprising:
presenting a first data element profile at least by:
presenting a first data element as a first component of a plurality of components in the first data element profile, the first data element being one of a plurality of data elements used by an application,
presenting a second data element as a second component of the plurality of component in the first data element profile, the second data element being another one of the plurality of data elements, and
presenting a first formula as another component of the plurality of components in the first data element profile, wherein the application is configured to calculate, based on the first formula, at least one value of the first data element using at least one value of the second data element;
detecting a first user input selecting the second data element in the first data element profile;

presenting, based on detecting the first user input, a second data element profile at least by:
presenting the second data element as a first component of a plurality of components in the second data element profile, the second data element being one of a plurality of data elements used by an application,
presenting a third data element as a second component of the plurality of component in the second data element profile, the third data element being another one of the plurality of data elements, and
presenting a second formula as another component of the plurality of components in the second data element profile, wherein the application is further configured to calculate, based on the second formula, at least one value of the second data element using at least one value of the third data element;

detecting a second user input selecting the third data element in the second data element profile; and
presenting, based on detecting the second user input, a third data element profile comprising the third data element.

15. A non-transitory computer readable medium comprising instructions which, when executed by one or more hardware processors, cause performance of operations comprising:
determining that an application is configured to calculate, based on a first formula, at least one value of a first data element of a p

Assignees

• Oracle Int Corp

Inventors

• Mukherjee Prasun
• John Jeevan Selvan Job
• Bhagat Pravas Sudhakar Naik
• Ramachandra Srilakshmi
• Kumar Tarun
• Duell Walter

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/26

  Visual data mining; Browsing structured data · CPC title