Graphical result set representation and manipulation
AssigneeApple Inc.
InventorsAndrew Paulsen, Christopher Crim, Ryan Griggs
Life of this patent
Estimating the term…
Abstract
A graphical user interface in a database application includes a control for manipulating a result set of a query. The control is operable to display multiple graphical representations of a result ratio between a total number of rows in a database table returned in response to the query and a total number of rows of the database table. By interacting with the control, the user can switch (e.g., toggle) between graphical representations of the result ratio. The toggling can be achieved by automatically creating supplemental queries to the database. The graphical representations can be a pie chart, bar chart, eye chart or any other graphical representation that is suitable for displaying the result ratio.
Claims45
A computer-implemented method of viewing result sets from a database query, comprising:
- receiving a result set and a total number of rows from a database in response to a database query;
- providing a control displaying a first graphical representation of a result ratio between a row count of the result set and the total number of rows;
- receiving input in response to user interaction with the control;
- and
- responsive to the input, providing the control displaying a second graphical representation of the result ratio on a display device.
A computer-readable medium storing a computer program which, when executed by a computer processor, causes the computer processor to perform operations for compiling source code into object code, the operations comprising:
- receiving a result set and a total number of rows from a database in response to a database query;
- providing a control displaying a first graphical representation of a result ratio between a row count of the result set and the total number of rows;
- receiving input in response to user interaction with the control;
- and
- responsive to the input, providing the control displaying a second graphical representation of the result ratio on a display device.
A system comprising:
- a processor;
- memory coupled to the processor and operable for storing instructions, which, when executed by the processor, causes the processor to perform operations for compiling source code into object code, the operations comprising:
- receiving a result set and a total number of rows from a database in response to a database query;
- providing a control displaying a first graphical representation of a result ratio between a row count of the result set and the total number of rows;
- receiving input in response to user interaction with the control;
- and
- responsive to the input, providing the control displaying a second graphical representation of the result ratio on a display device.
Dependencies are inferred from the claim text.