User interface indicating operation progress in a scrollbar

Patent metadata

Field	Value
Publication number	US-10956018-B2
Application number	US-201715479152-A
Country	US
Kind code	B2
Filing date	Apr 4, 2017
Priority date	Aug 5, 2014
Publication date	Mar 23, 2021
Grant date	Mar 23, 2021

Abstract

Methods and systems for providing status and progress information on a scrollbar are described. A user opens a software application to perform operations or view items. The application includes a scrollbar in its graphical user interface. The user may perform a plurality of operations. The application determines a position on the scrollbar corresponding to a location of the operation or item. The application determines a status representation corresponding to a status of the operation or item. The application determines a height of a scrollbar segment corresponding to a length of the operation or item. The application displays the status representation in the scrollbar segment at the position. The application may also display changes in the status representation to provide progress information.

First claim

What is claimed is:

1. A system, comprising:
a memory;
and one or more processors in communication with the memory and configured to:
present a first type of scrollbar in a graphical user interface (GUI) of an application, the first type of scrollbar having an adjustable first width and displaying a first type of information that relates to a first operation and a second operation in the application, the first operation comprising a first query receipt and the second operation comprising a second query receipt;
detect a first user interaction changing the adjustable first width to an adjustable second width; and
in response to detecting the first user interaction, present a second type of scrollbar, the second type of scrollbar having the adjustable second width and displaying a second type of information different from the first type of information that relates to the first operation and the second operation, the displaying the second type of information comprising:
determining a first position on the scrollbar corresponding to a first location of the first operation and a second position on the scrollbar corresponding to a second location of the second operation in the application;
determining first status information of the first operation corresponding to a status of the first operation, the first status information comprising a first segment of a first size;
determining second status information of the second operation corresponding to a second status of the second operation, the second status information comprising a second segment of a second size, the second size different than the first size, the first size and the second size being based at least in part on a first number of query objects included in the first query receipt and a second number of query objects included in the second query receipt; and
displaying the first status information within the first segment of the first size, indicating a first progress of executing the first query receipt on a database, at the first position on the scrollbar and the second status information within the second segment of the second size, indicating a second progress of executing the second query receipt on the database, at the second position on the scrollbar to present the second type of the scrollbar.

2. The system of claim 1 , wherein the one or more processors are further configured to:
determine a particular position on the first type of scrollbar corresponding to a particular location of the first operation; and
display the first type of information at the particular position.

3. The system of claim 1 , wherein the one or more processors are further configured to:
display progress information by dynamically updating or refreshing the first status information corresponding to the first operation.

4. The system of claim 3 , wherein the progress information is displayed by a movement of a line or a bar on the first status information.

5. The system of claim 1 , wherein the one or more processors are further configured to:
detect a second user interaction changing the adjustable second width to an adjustable third width; and
in response to detecting the second user interaction, display a third type of scrollbar, wherein the third type of scrollbar has the adjustable third width and displays a third type of information different from the first type of information and the second type of information that relates to the first operation.

6. The system of claim 5 , wherein the third type of information comprises a smaller representation of content of the application.

7. The system of claim 1 , wherein the first status information comprises one or more of: a distinctive icon, a color, a color scheme, a shape, a design, and an image, and the first status information further includes a label indicating that the first query receipt is completed, in progress, cued, stopped with errors, or completed with errors.

8. The system of claim 1 , wherein the first query receipt comprises a first group of database query statements that are executed together, and the second query receipt comprises a second group of database query statements that are executed together.

9. The system of claim 1 , wherein displaying the first status information, indicating a first progress of executing the first query receipt, at the first position on the scrollbar and the second status information, indicating a second progress of executing the second query receipt, at the second position on the scrollbar further comprises:
updating the first status information within the first segment of the first size to reflect the first progress during the executing of a first plurality of query statements from the first query receipt; and
updating the second status information within the second segment of the second size to reflect the second progress during the executing of a second plurality of query statements from the second query receipt.

10. The system of claim 1 , wherein the first size and the second size are further based at least in part on a length of a script or database query, or a character count including returns and breaks.

11. The system of claim 1 , wherein the first status information within the first segment of the first size and the second status information within the second segment of the second size are displayed substantially adjacent with the first segment of the first size being displayed above the second segment of the second size in a vertical arrangement.

12. A method, comprising:
presenting a first type of scrollbar having an adjustable first width, the first type of scrollbar displaying a first type of information of a first operation and a second operation of an application, the first operation comprising a first query receipt and the second operation comprising a second query receipt;
detecting a first user interaction changing the adjustable first width to an adjustable second width; and
in response to the detecting, presenting a second type of scrollbar, the second type of scrollbar having the adjustable second width and displaying a second type of information different from the first type of the information that relates to the first operation and the second operation, the displaying the second type of information comprising:
determining a first position on the scrollbar corresponding to a first location of the first operation and a second position on the scrollbar corresponding to a second location of the second operation in the application;
determining first status information of the first operation corresponding to a status of the first operation, the first status information comprising a first segment of a first size;
determining second status information of the second operation corresponding to a second status of the second operation, the second status information comprising a second segment of a second size, the second size different than the first size, the first size and the second size being based at least in part on a first number of query objects included in the first query receipt and a second number of query objects included in the second query receipt; and
displaying the first status information within the first segment of the first size, indicating a first progress of executing the first query receipt on a database, at the first position on the scrollbar and the second status information within the second segment of the second size, indicating a second progress of executing the second query receipt on the database, at the second position on the scrollbar to present the second type of the scrollbar.

13. The method of claim 12 , further comprising updating the first status information of t

Assignees

• Snowflake Inc

Inventors

• Schulz Egan

Classifications

• G06F3/04855 Primary

  Interaction with scrollbars · CPC title

• G06F3/04817

  using icons (graphical or visual programming using iconic symbols G06F8/34) · CPC title

• G06F9/451

  Execution arrangements for user interfaces · CPC title

• G06F3/0482

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