Touch optimized pivot table

• US 8,719,725 B2
• Filed: 07/18/2011
• Issued: 05/06/2014
• Est. Priority Date: 07/18/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Workman, Dan, Watanabe, Andrew, Lotia, Samar, Dong, Guohong
• Primary Examiner(s): Vu, Kieu
• Assistant Examiner(s): Zhang, Shangao
• Application Number:
  US13/185,286
• Publication Number:
  US 20130024803A1
• Time in Patent Office: 1,023 Days
• Field of Search: 715/781, 715212-214, 715/227, 715/243, 715/780, 715782-788, 715/764, 715/792, 715/853, 715/854, 715/864
• US Class Current: 715/781
• CPC Class Codes: G06F 2203/04808 Several contacts: gestures triggering a specific function, e.g. scrolling, zooming, right-click, when the user establishes several contacts with the surface simultaneously; e.g. using several fingers or a combination of fingers and pen
• CPC Class Codes: G06F 3/04886 by partitioning the display area of the touch-screen or the surface of the digitising tablet into independently controllable areas, e.g. virtual keyboards or menus
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Embodiments of the invention include a method of implementing a touch screen optimized pivot table. The method includes providing a view of a hierarchal table on a touch screen. The hierarchal table includes hierarchal levels and each of hierarchal levels includes corresponding data. The method further includes mapping each of the hierarchal levels to each of a corresponding region on the touch screen. Each region'"'"'s view displays the corresponding data for the mapped hierarchal level. The method further includes displaying on the touch screen the corresponding data for each of the hierarchal levels in each of the mapped regions, receiving at the touch screen input to manipulate at least one of the regions on the touch screen, and in response to the received input, causing each subordinate region to the at least one manipulated region to update the corresponding data displayed in each of the subordinate regions.

Claims

1. A method of implementing a touch screen optimized pivot table, the method comprising:

providing a view of a hierarchal table on a touch screen, wherein the hierarchal table includes a plurality of hierarchal levels in a hierarchal structure and each of the plurality of hierarchal levels included corresponding data, and further includes columns and rows;

mapping each of the plurality of hierarchal levels to each of a plurality of corresponding regions, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level, wherein the plurality of corresponding regions include at least two levels including one or more parent nodes and at least one child node, and wherein a region that is a subordinate region is smaller than or equal to at least one region and is configured to be able to contain one or more sub-regions;

displaying on the touch screen the corresponding data from a subset of the plurality of regions which includes less than the entire plurality of hierarchal levels of the hierarchal structure;

receiving at the touch screen input to scroll at least one of the plurality of regions on the touch screen, wherein as at least one of the plurality of regions is spun the corresponding data for each of the plurality of remaining regions are updated according to the hierarchical structure, and wherein each of the plurality of hierarchal levels are represented by a distinct region of the plurality of regions on the touch screen display, wherein if there is more data to be displayed or the touch screen cannot include all of the data, then display is spun to the subsequent region; and

in response to the received input, causing each subordinate region to the at least one manipulated region to update the display of the corresponding data in each of the subordinate regions to allow independent scrolling of the columns and the rows within the hierarchal table, wherein each of the columns in one region are displayed and then all the columns and rows inside a region are scrolled together while all other regions remain the same, and the lowest level in the hierarchal structure is still able to be scrolled.

2. The method of implementing the touch screen optimized pivot table as in claim 1, further comprising in response to receiving the input to manipulate the at least one of the plurality of regions on the touch screen, causing the at least one of the plurality of regions to spin through the corresponding data in the direction of the manipulation.

3. The method of implementing the touch screen optimized pivot table as in claim 1, wherein each of the plurality of hierarchal levels has a one-to-one mapping to each of the plurality of corresponding regions on the touch screen.

4. The method of implementing the touch screen optimized pivot table as in claim 1, wherein the touch screen comprises a multi-touch screen.

5. The method of implementing the touch screen optimized pivot table as in claim 4, wherein more than one of the plurality of regions are configured to be manipulated simultaneously.

6. The method of implementing the touch screen optimized pivot table as in claim 1, further comprising orienting the plurality of regions to maximize font size of the corresponding data displayed for each region and maximize the number of levels of the hierarchy simultaneously displayed on the touch screen.

7. A non-transitory machine-readable storage medium having sets of instructions stored thereon which, when executed by a machine, cause the machine to:

provide a view of a hierarchal table on a touch screen, wherein the hierarchal table includes a plurality of hierarchal levels in a hierarchal structure and each of the plurality of hierarchal levels included corresponding data, and further includes columns and rows;

map each of the plurality of hierarchal levels to each of a plurality of corresponding regions, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level, wherein the plurality of corresponding regions include at least two levels including one or more parent nodes and at least one child node, and wherein a region that is a subordinate region is smaller than or equal to at least one region and is configured to be able to contain one or more sub-regions;

display on the touch screen the corresponding data from a subset of the plurality of regions which includes less than the entire plurality of hierarchal levels of the hierarchal structure;

receive at the touch screen input to scroll at least one of the plurality of regions on the touch screen, wherein as at least one of the plurality of regions is spun the corresponding data for each of the plurality of remaining regions are updated according to the hierarchical structure, and wherein each of the plurality of hierarchal levels are represented by a distinct region of the plurality of regions on the touch screen display, wherein if there is more data to be displayed or the touch screen cannot include all of the data, then display is spun to the subsequent region; and

in response to the received input, cause each subordinate region to the at least one manipulated region to update the display of the corresponding data in each of the subordinate regions to allow independent scrolling of the columns and the rows within the hierarchal table, wherein each of the columns in one region are displayed and then all the columns and rows inside a region are scrolled together while all other regions remain the same, and the lowest level in the hierarchal structure is still able to be scrolled.

8. The non-transitory machine-readable storage medium as in claim 7, wherein the sets of instruction when further executed by the machine, cause the machine to in response to receiving the input to manipulate the at least one of the plurality of regions on the touch screen, cause the at least one of the plurality of regions to spin through the corresponding data in the direction of the manipulation.

9. The non-transitory machine-readable storage medium as in claim 7, wherein each of the plurality of hierarchal levels has a one-to-one mapping to each of the plurality of corresponding regions on the touch screen.

10. The non-transitory machine-readable storage medium as in claim 7, wherein the touch screen comprises a multi-touch screen.

11. The non-transitory machine-readable storage medium as in claim 10, wherein more than one of the plurality of regions are configured to be manipulated simultaneously.

12. The non-transitory machine-readable storage medium as in claim 7, wherein the sets of instruction when further executed by the machine, cause the machine to orient the plurality of regions to maximize space for the corresponding data to be displayed for each region and maximize the number of levels of the hierarchy simultaneously displayed on the touch screen.

13. A device comprising:

a multi-touch screen;

a memory; and

a processor coupled with the memory and the multi-touch screen, wherein the memory includes sets of instructions stored thereon which, when executed by the processor, cause the processor to;

provide a view of a hierarchal table on a touch screen, wherein the hierarchal table includes a plurality of hierarchal levels in a hierarchal structure and each of the plurality of hierarchal levels included corresponding data, and further includes columns and rows;

map each of the plurality of hierarchal levels to each of a plurality of corresponding regions, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level, wherein the plurality of corresponding regions include at least two levels including one or more parent nodes and at least one child node, and wherein a region that is a subordinate region is smaller than or equal to at least one region and is configured to be able to contain one or more sub-regions;

display on the touch screen the corresponding data from a subset of the plurality of regions which includes less than the entire plurality of hierarchal levels of the hierarchal structure;

receive at the touch screen input to scroll at least one of the plurality of regions on the touch screen, wherein as at least one of the plurality of regions is spun the corresponding data for each of the plurality of remaining regions are updated according to the hierarchical structure, and wherein each of the plurality of hierarchal levels are represented by a distinct region of the plurality of regions on the touch screen display, wherein if there is more data to be displayed or the touch screen cannot include all of the data, then display is spun to the subsequent region; and

in response to the received input, cause each subordinate region to the at least one manipulated region to update the display of the corresponding data in each of the subordinate regions to allow independent scrolling of the columns and the rows within the hierarchal table, wherein each of the columns in one region are displayed and then all the columns and rows inside a region are scrolled together while all other regions remain the same, and the lowest level in the hierarchal structure is still able to be scrolled.

14. The device as in claim 13, wherein the sets of instruction when further executed by the processor, cause the processor to in response to receiving the input to manipulate the at least one of the plurality of regions on the touch screen, cause the at least one of the plurality of regions to spin through the corresponding data in the direction of the manipulation.

15. The device as in claim 13, wherein each of the plurality of hierarchal levels has a one-to-one mapping to each of the plurality of corresponding regions on the touch screen.

16. The device as in claim 13, wherein more than one of the plurality of regions are configured to be manipulated simultaneously.

17. The device as in claim 13, wherein the sets of instruction when further executed by the processor, cause the processor to orient the plurality of regions to maximize font size of the corresponding data displayed for each region and maximize the number of levels of the hierarchy simultaneously displayed on the touch screen.