TOUCH OPTIMIZED PIVOT TABLE

• US 20130024803A1
• Filed: 07/18/2011
• Published: 01/24/2013
• 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
• Granted Patent: US 8,719,725 B2
• Time in Patent Office: Days
• 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 and each of the plurality of hierarchal levels included corresponding data;

mapping each of the plurality of hierarchal levels to each of a plurality of corresponding regions on the touch screen, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level;

displaying on the touch screen the corresponding data for each of the plurality of hierarchal levels in each of the mapped plurality of regions;

receiving at the touch screen input to manipulate at least one of the plurality of 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.

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 3, 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 5, wherein each of the plurality of regions is configured to be manipulated independently from each other region.

7. 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.

8. A 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 and each of the plurality of hierarchal levels includes corresponding data;

map each of the plurality of hierarchal levels to each of a plurality of corresponding regions on the touch screen, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level;

display on the touch screen the corresponding data for each of the plurality of hierarchal levels in each of the mapped plurality of regions;

receive input at the touch screen to manipulate at least one of the plurality of regions on the touch screen; and

in response to the received input, cause each subordinate region to the at least one manipulated region to update the corresponding data displayed in each of the subordinate regions.

9. The machine-readable storage medium as in claim 8, 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.

10. The machine-readable storage medium as in claim 8, 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.

11. The machine-readable storage medium as in claim 8, wherein the touch screen comprises a multi-touch screen.

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

13. The machine-readable storage medium as in claim 12, wherein each of the plurality of regions is configured to be manipulated independently from each other region.

14. The machine-readable storage medium as in claim 8, 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.

15. 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 the multi-touch screen, wherein the hierarchal table includes a plurality of hierarchal levels and each of the plurality of hierarchal levels includes corresponding data,

map each of the plurality of hierarchal levels to each of a plurality of corresponding regions on the multi-touch screen, and wherein each region'"'"'s view displays the corresponding data for the mapped hierarchal level,

display on the multi-touch screen the corresponding data for each of the plurality of hierarchal levels in each of the mapped plurality of regions,

receive input at the multi-touch screen to manipulate at least one of the plurality of regions on the touch screen, and

in response to the received input, cause each subordinate region to the at least one manipulated region to update the corresponding data displayed in each of the subordinate regions on the multi-touch screen.

16. The device as in claim 15, 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.

17. The device as in claim 15, 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.

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

19. The device as in claim 18, wherein each of the plurality of regions is configured to be manipulated independently from each other region.

20. The device as in claim 15, 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.