# US 2017/0286492 A1 · Query result flow control in a network switch

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

- Number: US 2017/0286492 A1
- Document ID: US20170286492A1
- Status: Published application
- Kind: A1
- Application number: 15/273,922
- Filed: 2016-09-23
- Published: 2017-10-05
- Earliest claimed: 2016-04-01
- Assignees: Arista Networks, Inc.
- Applicants: Arista Networks, Inc.
- Inventors: Michael Greenwald; Stephen Schleimer
- Web page: https://patentgrep.com/patent/US20170286492A1

## CPC

- G06F 16/24568: {Data stream processing; Continuous queries}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F 16/24565: {Triggers; Constraints}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A network device includes a standing query instance (SQI) and a database. The SQI is programmed to generate an output stored in a low resource storage table of a database. The database is programmed to monitor a storage capacity of the low resource storage table based on at least, in part, the output stored in the low resource storage table; determine, based on the monitoring, when the storage capacity reaches a predetermined amount; and disable an upstream element in response to the determination.

## Claims

### Claim 1

A network device, comprising:
a standing query instance (SQI) programmed to generate an output stored in a low resource storage table of a database;
the database programmed to:
monitor a storage capacity of the low resource storage table based on at least, in part, the output stored in the low resource storage table;
determine, based on the monitoring, when the storage capacity reaches a predetermined amount; and
disable an upstream element in response to the determination.

### Claim 2 (depends on 1)

The network device of claim 1,
wherein the upstream element is a compiled query of the SQI, and
wherein disabling the compiled query halts generation of the output.

### Claim 3 (depends on 1)

The network device of claim 1, wherein the storage capacity is a ratio of an available storage capacity of the low resource storage table to a total storage capacity of the low resource storage table.

### Claim 4 (depends on 3)

The network device of claim 3, wherein the predetermined amount is zero.

### Claim 5 (depends on 3)

The network device of claim 3, wherein the predetermined amount is less than 0.1.

### Claim 6 (depends on 1)

The network device of claim 1, further comprising:
an observer programmed to notify the upstream element of a change to an entry of the database,
wherein the upstream element generates the output in response to the notification by the observer.

### Claim 7 (depends on 6)

The network device of claim 6, wherein the upstream element is the observer,
wherein disabling the observer prevents the observer from notifying the upstream source element.

### Claim 8 (depends on 1)

The network device of claim 1, further comprising:
an observer programmed to notify the upstream element of a change to an entry of the database,
a modifier programmed to store a previously generated output of the SQI in the low resource storage table,
wherein the upstream element generates the output in response to the notification by the observer after the modifier stores the previously generated output.

### Claim 9 (depends on 8)

The network device of claim 8, wherein the upstream element is the modifier,
wherein disabling the modifier prevents the modifier from storing the previously generated output.

### Claim 10 (depends on 1)

The network device of claim 1, further comprising:
a downstream entity programmed to read entries of the low resource storage table,
wherein the database is further programmed to delete read entries of the low resource storage table.

### Claim 11 (depends on 10)

The network device of claim 10, wherein the database is further programmed to:
accelerate a read rate of the downstream entity in response to the determination,
wherein the read rate is a rate at which the downstream entity reads entries of the low resource storage table.

### Claim 12 (depends on 11)

The network device of claim 11, wherein the database is programmed to accelerate the read rate by notifying the downstream entity of the determination.

### Claim 13 (depends on 10)

The network device of claim 10, wherein the network device further comprises:
an observer programmed to notify the downstream entity of a change to an entry of the low resource storage table,
wherein the downstream entity reads the entry of the low resource storage table in response to the notification by the observer.

### Claim 14 (depends on 13)

The network device of claim 13, wherein the downstream entity is an agent.

### Claim 15 (depends on 13)

The network device of claim 13, wherein the downstream entity is a second SQI.

### Claim 16 (depends on 15)

The network device of claim 15,
wherein the second SQI comprises a compiled query that generates a second output, and
wherein the second output is stored in a materialized table of the database.

### Claim 17 (depends on 15)

The network device of claim 15,
wherein the second SQI comprises a compiled query that generates a second output,
wherein the second output is stored in a low resource storage table of the database.

### Claim 18 (depends on 1)

The network device of claim 1, wherein the network device is one network device selected from the group of network devices consisting of a switch, a router, and a multilevel switch.

### Claim 19 (depends on 1)

The network device of claim 1, wherein the low resource storage table is a non-materialized table.

### Claim 20

A method of operating a network device, comprising:
obtaining, by a database of the network device, an output generated by a standing query instance (SQI);
storing, by the database, the output in a low resource storage table of the database in response to obtaining the output;
making a first determination, by the database, that a storage capacity of the low resource storage table has reached a predetermined amount; and
preventing, by the database, the SQI from generating a second output, to be stored in the low resource storage table, in response to the first determination.

### Claim 21 (depends on 19)

The method of claim 19, wherein the database prevents the second output from being stored in the low resource storage table by disabling a compiled query of the SQI that generates the second output.

### Claim 22 (depends on 19)

The method of claim 19, wherein the database prevents the second output from being stored in the temporary storage by disabling an observer that triggers an execution of a compiled query of the SQI that generates the second output when executed,
wherein the observer triggers the execution by notifying the compiled query of a change to an entry of the database.
