# US 2017/0286469 A1 · External data source linking to queries in memory

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

- Number: US 2017/0286469 A1
- Document ID: US20170286469A1
- Status: Published application
- Kind: A1
- Application number: 15/274,143
- 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/US20170286469A1

## CPC

- G06F 16/2315: {Optimistic concurrency control}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A network device includes a database that includes database entries, an external data that includes external data entries, an interpreter, and a standing query instance (SQI). The interpreter is programmed to convert an external data entry into a temporary database entry and provide the temporary database entry to the database. The SQI is programmed to obtain a database entry and the temporary database entry from the database and generate an output based on the database entry and the temporary database entry.

## Claims

### Claim 1

A network device, comprising:
a database comprising database entries;
an external data comprising external data entries;
an interpreter programmed to:
convert an external data entry into a temporary database entry;
provide the temporary database entry to the database;
a standing query instance (SQI) programmed to:
obtain a database entry and the temporary database entry from the database; and
generate an output based on the database entry and the temporary database entry.

### Claim 2 (depends on 1)

The network device of claim 1, wherein the temporary database entry is not stored in the database.

### Claim 3 (depends on 1)

The network device of claim 1,
wherein the database entry has a first format,
wherein the external entry has a second format,
wherein the first format and the second format are different.

### Claim 4 (depends on 3)

The network device of claim 3, wherein the temporary database entry has a third format,
wherein the second format and the third format are different.

### Claim 5 (depends on 3)

The network device of claim 3, wherein the temporary database entry has a third format,
wherein the third format and the first format are the same.

### Claim 6 (depends on 1)

The network device of claim 1, further comprising:
an observer programmed to notify the SQI of a change to the database entry.

### Claim 7 (depends on 6)

The network device of claim 6, wherein the SQI generates the output in response to the notification of the change to the database entry.

### Claim 8 (depends on 1)

The network device of claim 1, further comprising:
an observer programmed to notify a second SQI of a change to the database entry;
a second observer programmed to notify the second SQI of a change to a second database entry;
the second SQI programmed to:
generate a second output in response to the notification from one selected from the group consisting of the observer and the second observer.

### Claim 9 (depends on 8)

The network device of claim 8, wherein the output of the second SQI is based on the temporary database entry and the database entry when the second SQI is notified by the observer.

### Claim 10 (depends on 9)

The network device of claim 9, wherein the output of the second SQI is based on the temporary database entry and the second database entry when the second SQI is notified by the second observer.

### Claim 11 (depends on 1)

The network device of claim 1, further comprising:
a standing query service manager (SQSM) programmed to:
obtain a new SQI request;
generate a new SQI based on the new SQI request.

### Claim 12 (depends on 11)

The network device of claim 11, wherein the new SQI request specifies:
an input table comprising a second database entry and an external data entry.

### Claim 13 (depends on 12)

The network device of claim 12, wherein the SQSM is further programmed to:
generate a new observer that notifies the new SQI of a change to the second database entry; and
generate a link between the new SQI and the first external data entry.

### Claim 14 (depends on 13)

The network device of claim 13, wherein the new SQI is programmed to:
obtain the second database entry and the external data entry; and
generate a second output based on the second database entry and the external data entry,
wherein the link is a second temporary database entry that is based on the external data entry.

### Claim 15

A method of operating a network device, comprising:
obtaining, by a standing query service manager (SQSM) of the network device, a first standing query instance (SQI) request specifying an input table, wherein the input table comprises a database entry of a database and an external data entry of an external data;
generating, by the SQSM, a SQI comprising:
a SQI input table,
a compiled query that, when executed, produces an output based on the SQI input table;
making a first determination, by the SQSM, that the SQI input table includes the database entry in response to generating the SQI;
generating, by the SQSM, an observer programmed to notify the SQI of a change to the database entry in response to the first determination; and
generating, by the SQS manager, a link between the SQI input table and the external data entry in response to the first determination.

### Claim 16 (depends on 15)

The method of claim 15,
wherein the database entry has a first format,
wherein the external data entry has a second format, and
wherein the first format and second format are different.

### Claim 17 (depends on 15)

The method of claim 15, wherein the link is a temporary database entry of the database that is based on the external data entry.

### Claim 18

A method of operating a network device, comprising:
obtaining, by a standing query instance (SQI), a database entry and a temporary database entry from a database, wherein the temporary database entry is based on an external data entry of an external data; and
generating, by a compiled query of a SQI, an output based on the database entry and the temporary database entry.

### Claim 19 (depends on 18)

The method of claim 18,
wherein the temporary database entry is not stored in the database, and
wherein the external data is not stored in the database.

### Claim 20 (depends on 18)

The method of claim 18,
wherein the database entry has a first format,
wherein the external data entry has a second format, and
wherein the first format and the second format are different.

### Claim 21 (depends on 20)

The method of claim 20,
wherein the temporary database entry has a third format, and
wherein the second format and the third format are different.
