# US 2006/0242120 A1 · Sorted Rowset

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

- Number: US 2006/0242120 A1
- Document ID: US20060242120A1
- Status: Published application
- Kind: A1
- Application number: 11/110,214
- Filed: 2005-04-20
- Published: 2006-10-26
- Earliest claimed: 2005-04-20
- Assignees: BEA Systems, Inc.
- Inventors: Fei Luo
- Web page: https://patentgrep.com/patent/US20060242120A1

## CPC

- G06F 7/24: Sorting, i.e. extracting data from one or more carriers, rearranging the data in numerical or other ordered sequence, and rerecording the sorted data on the original carrier or on a different carrier or set of carriers {sorting methods in general}(G06F7/36 takes precedence)
- G06F 16/2448: {for particular applications; for extensibility, e.g. user defined types}
- G06F 16/24554: {Unary operations; Data partitioning operations}
- Y10S 707/99931: Database or file accessing
- Y10S 707/99932: Access augmentation or optimizing
- Y10S 707/99943: Generating database or data structure, e.g. via user interface
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

A Rowset can sort the order of rows of without requiring resorted data be obtained from the database.

## Claims

### Claim 1

A system comprising:
a rowset populated with rows of data from a database; and
an associated sorter adapted to sort the rows of data in the rowset, without accessing the database, such that operations accessing the rowset use the new sorted order.

### Claim 2 (depends on 1)

The system of claim 1, wherein operations include curser-based operations.

### Claim 3 (depends on 1)

The system of claim 1, wherein the operations include displays of row data.

### Claim 4 (depends on 1)

The system of claim 1, wherein the new sorted order can be filtered with a filter function.

### Claim 5 (depends on 1)

The system of claim 1, wherein the sorting includes creating a table of sorted pointers to rows in the rowset.

### Claim 6 (depends on 1)

The system of claim 1, wherein the sorter can be associated with the rowset using a Shared Rowset object such that operations accesssing the rowset data through the Shared Rowset object will use the new sorted order.

### Claim 7 (depends on 6)

The system of claim 6, wherein operations accessing the rowset data through another Shared Rowset object will not use the new sorted order

### Claim 8 (depends on 1)

The system of claim 1, wherein the rowset is a Cached rowset.

### Claim 9 (depends on 1)

The system of claim 1, wherein when the sorter is input a column name, the sorter sorts by the values of the column name.

### Claim 10 (depends on 1)

The system of claim 1, wherein the rowset has an sorter interface for interacting with the sorter.

### Claim 11

A sorter associated with a rowset, the sorter adapted to sort the rows of data in the rowset, without accessing the database, such that operations accessing the rowset use the new sorted order.

### Claim 12 (depends on 11)

The sorter of claim 11, wherein operations include curser-based operations.

### Claim 13 (depends on 11)

The sorter of claim 11, wherein the operations include displays of row data.

### Claim 14 (depends on 11)

The sorter of claim 11, wherein the new sorted order can be filtered with a filter function.

### Claim 15 (depends on 11)

The sorter of claim 11, wherein the sorting includes creating a table of sorted pointers to rows in the rowset.

### Claim 16 (depends on 11)

The sorter of claim 11, wherein the sorter can be associated with rowset using a Shared Rowset object such that operations accesssing the rowset data through the Shared Rowset object will use the new sorted order.

### Claim 17 (depends on 16)

The sorter of claim 16, wherein operations accessing the rowset data through another Shared Rowset object will not use the new sorted order

### Claim 18 (depends on 11)

The sorter of claim 11, wherein the rowset is a Cached rowset.

### Claim 19 (depends on 11)

The sorter of claim 11, wherein when the sorter is input a column name, the sorter sorts by the values of the column name.

### Claim 20 (depends on 11)

The sorter of claim 11, wherein the sorter interacts with a sorter interface on the rowset.
