# US 2021/0011900 A1 · Keyed row selection

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2021/0011900 A1
- Document ID: US20210011900A1
- Status: Published application
- Kind: A1
- Application number: 17/038,388
- Filed: 2020-09-30
- Published: 2021-01-14
- Earliest claimed: 2017-08-24
- Assignees: Deephaven Data Labs LLC
- Applicants: Deephaven Data Labs LLC
- Inventors: Charles Wright; Ryan Caudy; David R. Kent, IV; Andrew Louis Baranek; Mark Zeldis; Radu Teodorescu
- Web page: https://patentgrep.com/patent/US20210011900A1

## CPC

- G06F 16/90335: {Query processing}
- G06F 3/0481: based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F 16/128: {Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion (error detection or correction of the data by redundancy in operations or in hardware G06F11/14, G06F11/16)}
- G06F 16/21: Design, administration or maintenance of databases
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/23: Updating
- G06F 16/235: {Update request formulation}
- G06F 16/2358: {Change logging, detection, and notification (replication G06F16/27)}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/2372: {Updates performed during offline database operations}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/289: {Object oriented databases}
- G06F 16/532: Query formulation, e.g. graphical querying
- G06F 16/901: Indexing; Data structures therefor; Storage structures (for retrieval from the web G06F16/951)
- G06F 16/9024: {Graphs; Linked lists (G06F16/9027 takes precedence)}
- G06F 16/9038: Presentation of query results
- G06F 16/904: Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957)
- G06T 11/26: Drawing of charts or graphs
- G06F 12/0253: {Garbage collection, i.e. reclamation of unreferenced memory}
- G06F 16/489: {using time information}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06T: IMAGE DATA PROCESSING OR GENERATION, IN GENERAL

## Abstract

Described are methods, systems and computer readable media for keyed row data selection and processing.

## Claims

### Claim at position 1

1-20. (canceled)

### Claim 21

A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more processors, cause the processors to perform operations including:
receiving, at a processor, a selection of one or more keyed rows of the computer data system data object, the selection being received from a graphical user interface that is displaying at least a portion of data from the computer data system data object;
in response to receiving the selection, when the computer data system data object is keyed on a given key field, automatically selecting other rows in the computer data system data object having a key field that is within a predetermined threshold value of the given key field of the one or more keyed rows in the received selection;
adding, using the processor, one or more key values corresponding to the selection to a selected key values set stored in a computer readable medium coupled to the processor;
receiving, at the processor, an indication of an operation that utilizes data corresponding to the one or more key values;
determining, at the processor, whether the data corresponding to the one or more key values is stored within a local data store;
when the data corresponding to the one or more key values is stored within the local data store:
retrieving, using the processor, the data corresponding to the one or more key values from the local data store,
providing, using the processor, data retrieved from the local data store to an application;
determining, at the processor, whether a portion of the data corresponding to the one or more key values is not stored in the local data store and is stored in a remote data store;
when a portion of the data corresponding to the one or more key values is not stored in the local data store and is stored in the remote data store:
requesting, using the processor, data from the remote data store,
receiving, at the processor, at least a portion of requested data from the remote data store, and
providing, using the processor, data received from the remote data store to the application; and
persisting selected key values as selected based on the selection within the graphical user interface when the selection is no longer visible within a viewable area of the graphical user interface.

### Claim 22 (depends on 21)

The nontransitory computer readable medium of claim 21, the operations further comprising updating the graphical user interface based on the selection.

### Claim 23 (depends on 21)

The nontransitory computer readable medium of claim 21, wherein the one or more key values are one or more of a single value or a composite of several values that specifically define the one or more keyed rows.

### Claim 24 (depends on 21)

The nontransitory computer readable medium of claim 21, wherein providing data received from the local data store to the application and providing data received from the remote data store to the application include storing received data in a temporary working data store.

### Claim 25 (depends on 21)

The nontransitory computer readable medium of claim 21, the operations further comprising:
receiving an update to the computer data system data object, wherein the update includes a change to the selection; and
performing an update on the selection based on the update to the computer data system data object.

### Claim 26 (depends on 21)

The nontransitory computer readable medium of claim 21, wherein the data returned from the remote data store includes indexes for accessing data stored on remote data store.

### Claim 27 (depends on 21)

The nontransitory computer readable medium of claim 21, the operations further comprising:
receiving, at the processor, an indication that a new row has been added to the computer data system data object;
determining, using the processor, whether the new row is within the selection based on the selected key values set; and
if the new row is part of the selection:
updating, using the processor, the graphical user interface to indicate the new row is within the selection, and
providing, from the processor, the new row to the application.

### Claim 28 (depends on 21)

The nontransitory computer readable medium of claim 21, the operations further comprising resetting the selected key values set when a new selection is received.

### Claim 29 (depends on 21)

The nontransitory computer readable medium of claim 21, wherein at least part of the data corresponding to the one or more key values is not displayed within the graphical user interface.

### Claim 30

A system for dynamically updating a remote computer data system data object, the system comprising:
a processor coupled to a nontransitory computer readable medium having stored thereon software instructions that, when executed by the processor, cause the processor to perform operations including:
receiving a selection of one or more keyed rows of the computer data system data object, the selection being received from a graphical user interface that is displaying at least a portion of data from the computer data system data object;
in response to receiving the selection, when the computer data system data object is keyed on a given key field, automatically selecting other rows in the computer data system data object having a key field that is within a predetermined threshold value of the given key field of the one or more keyed rows in the received selection;
adding one or more key values corresponding to the selection to a selected key values set stored in a computer readable medium coupled to the processor;
receiving an indication of an operation that utilizes data corresponding to the one or more key values;
retrieving the data corresponding to the one or more key values from one or more data stores including a local data store and/or a remote data store;
providing data retrieved from the one of more data stores to an application; and
persisting selected key values as selected based on the selection within the graphical user interface when the selection is no longer visible within a viewable area of the graphical user interface.

### Claim 31 (depends on 30)

The system of claim 30, wherein the operations further include updating the graphical user interface based on the selection.

### Claim 32 (depends on 30)

The system of claim 30, wherein the one or more key values are one or more of a single value or a composite of several values that specifically define the one or more keyed rows.

### Claim 33 (depends on 30)

The system of claim 30, wherein providing data received from the one or more data stores to the application includes storing received data in a temporary working data store.

### Claim 34 (depends on 30)

The system of claim 30, wherein the operations further include:
receiving an update to the computer data system data object, wherein the update includes a change to the selection; and
performing an update on the selection based on the update to the computer data system data object.

### Claim 35 (depends on 30)

The system of claim 30, wherein the data retrieved from the one or more data stores includes data retrieved from the remote data store, and wherein the data retrieved from the remote data store includes indexes for accessing data stored on the remote data store.

### Claim 36 (depends on 30)

The system of claim 30, wherein the operations further include:
receiving an indication that a new row has been added to the computer data system data object;
determining whether the new row is within the selection based on the selected key values set; and
if the new row is part of the selection:
updating the graphical user interface to indicate the new row is within the selection, and
providing the new row to an application.

### Claim 37 (depends on 30)

The system of claim 30, further comprising resetting the selected key values set when a new selection is received from the graphical user interface including adding to the selected key values set one or more new key values corresponding to the new selection received from the graphical user interface.

### Claim 38 (depends on 30)

The system of claim 30, wherein at least part of the data corresponding to the one or more key values is not displayed within the graphical user interface.

### Claim 39

A computer-implemented method for processing keyed row selection of a computer data system data object, the method comprising:
receiving, at a processor, a selection of one or more keyed rows of the computer data system data object, the selection being received from a graphical user interface that is displaying at least a portion of data from the computer data system data object;
in response to receiving the selection, when the computer data system data object is keyed on a given key field, automatically selecting other rows in the computer data system data object having a key field that is within a predetermined threshold value of the given key field of the one or more keyed rows in the received selection;
adding, using the processor, one or more key values corresponding to the selection to a selected key values set stored in a computer readable medium coupled to the processor;
receiving, at the processor, an indication of an operation that utilizes data corresponding to the one or more key values;
retrieving, using the processor, the data corresponding to the one or more key values from one or more data stores including a local data store and/or a remote data store;
providing, using the processor, data retrieved from the one or more data stores to an application; and
persisting selected key values as selected based on the selection within the graphical user interface when the selection is no longer visible within a viewable area of the graphical user interface.

### Claim 40 (depends on 39)

The computer-implemented method of claim 39, further comprising updating the graphical user interface based on the selection, wherein the graphical user interface is updated in one of: according to a graphical user interface refresh rate or when processing allows for the update.

### Claim 41 (depends on 39)

The computer-implemented method of claim 39, further comprising:
receiving an update to the computer data system data object, wherein the update includes a change to the selection; and
performing an update on the selection based on the update to the computer data system data object.

### Claim 42 (depends on 39)

The computer-implemented method of claim 39, wherein the one or more key values is a composite of several values that specifically correspond to the one or more keyed rows.

### Claim 43 (depends on 39)

The computer-implemented method of claim 39, wherein one or more changes to data corresponding to the selection does not change the one or more key values until the selected key values set is cleared.

### Claim 44 (depends on 39)

The computer-implemented method of claim 39, wherein the data retrieved from the one or more data stores includes data retrieved from the remote data store, and wherein the data retrieved from the remote data store includes indexes for accessing data stored on the remote data store.

### Claim 45 (depends on 39)

The computer-implemented method of claim 39, further comprising:
receiving, at the processor, an indication that a new row has been added to the computer data system data object;
determining, using the processor, whether the new row is within the selection based on the selected key values set; and
if the new row is part of the selection:
updating, using the processor, the graphical user interface to indicate the new row is within the selection, and
providing, from the processor, the new row to the application.

### Claim 46 (depends on 39)

The computer-implemented method of claim 39, further comprising resetting the selected key values set when a new selection is received from the graphical user interface including adding to the selected key values set one or more new key values corresponding to the new selection received from the graphical user interface.

### Claim 47 (depends on 39)

The computer-implemented method of claim 39, wherein at least part of the data corresponding to the one or more key values is not displayed within the graphical user interface.
