US 2017/0193398 A1 · SYSTEM AND METHOD FOR AUTO-QUERY GENERATION

Abstract

Various systems and methods provide an intuitive user interface that enables automatic specification of queries and constraints for analysis by ML component. Various implementations provide methodologies for automatically formulating machine learning (“ML”) and optimization queries. The automatic generation of ML and/or optimization queries can be configured to use examples to facilitate formulation of ML and optimization queries. One example method includes accepting input data specifying variables and data values associated with the variables. Within the input data any unspecified data records are identified, and a relationship between the variables specified in the input data and a variable associated with the at least one unspecified data record is automatically determined. The relationship can be automatically determined based on training data contained within the input data. Once a relationship is established a ML problem can be automatically generated.

Claims21

Dependent claims

1-46. (canceled)

A method, comprising:

accessing, by a computer system, input data comprising:
training data comprising a first plurality of data records, each of the first plurality of data records having numeric data values at least for first and second variables in a plurality of variables;
and
a second plurality of data records comprising at least a first not fully specified data record that does not include a first numeric data value for the first variable in the plurality of variables;
generating, by the computer system and using the training data, a representation of a relationship between the first variable and at least the second variable in the plurality of variables;
and
obtaining, by the computer system and using the generated representation, at least the first numeric data value for the first variable in the first not fully specified data record.

4 more elements

A system, comprising:

using at least one hardware processor to perform:
accessing input data comprising:
training data comprising a first plurality of data records, each of the first plurality of data records having numeric data values at least for first and second variables in a plurality of variables;
and
a second plurality of data records comprising at least a first not fully specified data record that does not include a first numeric data value for the first variable in the plurality of variables;
generating, using the training data, a representation of a relationship between the first variable and at least the second variable in the plurality of variables;
and
obtaining, by the computer system and using the generated representation, at least the first numeric data value for the first variable in the first not fully specified data record.

5 more elements

Dependencies are inferred from the claim text.

Facts

Application

15/351,002Filed 14 Nov 2016

Priority

31 Aug 2012

Published

6 Jul 2017

Term ends

Not estimatedThe source records don’t support an estimate.

Classification7 codes

G06N 20/00
Machine learning
G06F 16/2428
Query formulation: query predicate definition using graphical user interfaces, including menus and forms
G06F 16/2453
Query processing: query optimisation
G06F 40/18
Of tables; using ruled lines: of spreadsheets

Family

Application61/695,637Us provisional application · filed 31 Aug 2012

Application61/695,660Us provisional application · filed 31 Aug 2012

Application61/779,451Us provisional application · filed 13 Mar 2013

Application14/016,287Continuation in part · filed 3 Sep 2013

Application14/016,300Continuation in part · filed 3 Sep 2013

Application14/202,780Continuation · filed 10 Mar 2014

Application15/351,002Continuation

Application14/202,780Continuation in part

US 10,102,483 B2Related patent

US 10,366,335 B2Related patent

US 2014/0074829 A1Published application