IP Library Granted Patent US 10,198,465
Granted Patent B2
US 10,198,465 · App. 15/154,984 · Granted Feb 5, 2019

Computer data system current row position query language construct and array processing query language constructs

Inventors: David R. Kent, IV (Colorado Springs, CO); Ryan Caudy (New York, NY); Charles Wright (Cortlandt Manor, NY); Mark Zeldis (Randolph, NJ); Radu Teodorescu (New York, NY)
Assignee: Deephaven Data Labs LLC
G06F17/30368G06F3/0481G06F3/0482G06F3/0483G06F3/0485G06F3/04847G06F3/04895G06F3/0605G06F3/067G06F3/0656G06F8/30G06F8/41G06F8/427G06F8/60G06F11/1451G06F11/1464G06F11/1469G06F12/0261G06F12/084G06F12/1483G06F15/17331G06F17/2235G06F17/24G06F17/245G06F17/246G06F17/276G06F17/2715G06F17/30117G06F17/30283G06F17/30303G06F17/30312G06F17/30315G06F17/30321G06F17/30324G06F17/30327G06F17/30333G06F17/30336G06F17/30339G06F17/30345G06F17/30371G06F17/30374G06F17/30377G06F17/30398G06F17/30424G06F17/30448G06F17/30451G06F17/30454G06F17/30457G06F17/30477G06F17/30483G06F17/30498G06F17/30522G06F17/30528G06F17/30554G06F17/30563G06F17/30584G06F17/30598G06F17/30864G06F17/30867G06F17/30887G06F17/30902G06F17/30958G06F17/30997G06F21/00G06F21/6209H04L12/18H04L51/046H04L51/12H04L61/2069H04L63/101H04L63/102H04L67/1002H04L67/141H04L67/28H04L67/2833H04L67/2842H04L67/34H04L67/42H04L69/16G06F17/30342G06F17/40G06F2201/805G06F2201/84G06F2212/1052G06F2212/154G06F2212/163G06F2212/60H04L67/2847
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,198,465
App. No.
15/154,984
Granted
Feb 5, 2019
Kind
B2
Abstract

Described are methods, systems and computer readable media for providing a current row position query language construct and array processing query language constructs and associated processing.

Claims (16)

1. A system comprising:

one or more hardware processors;

an electronic computer readable data storage device coupled to the one or more hardware processors, the electronic computer readable data storage device having stored thereon software instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform operations including:

accessing, at the one or more hardware processors, computer data system query language code stored in the electronic computer readable data storage device, the computer data system query language code including a current row position reference query language construct associated with a data object, wherein the current row position reference query language construct is defined by a computer data system query language and includes a source code language construct that references a logical row position of a most recently added row of a dynamically updating data source that the data object depends on to define a column of the data object, the dynamically updating data source being periodically updated;

parsing, at the one or more hardware processors, the computer data system query language code, including the source code language construct, into a parsed query language structure;

generating, at the one or more hardware processors, computer programming language code based on the parsed query language structure, the computer programming language code including a portion of computer programming language code corresponding to the current row position reference query language construct associated with the data object;

executing, at the one or more hardware processors, the computer programming language code, including the portion of computer programming language code corresponding to the current row position reference query language construct associated with the data object;

determining, at the one or more hardware processors, based on execution of the computer programming language code, a return value from the portion of computer programming language code corresponding to the current row position reference query language construct associated with the data object, the return value representing a current row position of the data object at a time of execution of the computer programming language code;

when one or more data sources that the data object depends on are updated, subsequently executing, at the one or more hardware processors, the computer programming language code, including the portion of computer programming language code corresponding to the current row position reference query language construct associated with the data object to evaluate an expression including the current row position reference query language construct based on the one or more data sources that have been updated, wherein when evaluating the expression including the current row position reference query language construct, an updated current row position is determined from computer programming language code corresponding to the current row position reference query language construct;

determining, at the one or more hardware processors, based on the subsequent execution of the computer programming language code, a new return value from the portion of computer programming language code corresponding to the current row position reference query construct associated with the data object, the new return value representing an updated current row position of the data object at a subsequent time of execution of the computer programming language code; and

updating, at the one or more hardware processors, based on the new return value, a value of the column of the data object defined by the expression including the current row position reference query language construct.

2. The system of claim 1 , wherein the updated current row position includes an incremented value from a previous current row position resulting from an added row.

3. The system of claim 1 , wherein the updated current row position includes a decremented value from a previous current row position resulting from a deleted row.

4. The system of claim 1 , wherein a current row position value of the data object is updated once data sources providing data for the data object have been updated.

5. The system of claim 1 , wherein the operations further include providing an index mapping a current row position to a storage location within a data source providing data for the data object.

6. The system of claim 1 , wherein the computer data system query language code includes code retrieving data from one or more data object positions other than the current row position in order to compute a time series operation.

Assignments (3)
CHANGE OF NAME Recorded Sep 5, 2018
From: ILLUMON LLC
To: DEEPHAVEN DATA LABS LLC
Reel/Frame 047017/0500 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 30, 2017
From: RIES, BRIAN; FERRETTI-SMYTHE, JUAN CRISTIAN; WRIGHT, CHARLES; VYDROV, OLEG; CAUDY, RYAN; KENT, DAVID R., IV; DORFMAN, NATHANIEL J.; TEODORESCU, RADU; ZELDIS, MARK; BRONNIMANN, HERVE; BASRALIAN, RAFFI
To: ILLUMON LLC
Reel/Frame 044557/0029 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 28, 2017
From: WALLEYE SOFTWARE, LLC
To: ILLUMON LLC
Reel/Frame 043722/0092 →
Continuity (2)
Provisional Application 62161813 · May 14, 2015
Related Publication 20160335281A1 · Nov 17, 2016