US 2013/0159960 A1 · INTELLIGENTLY RECOMMENDING SCHEMAS BASED ON USER INPUT

Abstract

The present invention extends to methods, systems, and computer program products for intelligently recommending schemas based on user input that defines a portion of a data structure. An intelligent auto-complete function can identify characteristics of the user input and, based on these characteristics, recommend schemas that are most likely to be selected by the user to complete the data structure or portion of the data structure. The identified characteristics of the user input can be compared to characteristics of defined schemas or of other data structures to identify schemas that are most likely to match the user's intent. These schemas are then recommended to the user. Such schemas can define the recommended shape of the data structure being defined, including data types for a particular column, columns to add to the data structure, or can define additional data structures to be added such as additional tables to a database.

Claims20

Dependent claims

At a computer system including one or more processors and system memory, the computer system including a development tool for defining data structures, a method for recommending schemas to a user during the development of a data structure, the method comprising:

receiving user input at the development tool, the user input defining a portion of a data structure;
identifying one or more characteristics of the user input by analyzing the user input;
based at least on the one or more identified characteristics, recommending one or more schemas, out of a plurality of schemas, to the user, each recommended schema predictive of user intent for defining one or more additional portions of the data structure;
displaying graphical data representing each of the one or more recommended schemas at the development tool, the graphical data displayed for user selection;
receiving a user selection of a selected schema from among the one or more recommended schemas represented in the displayed graphical data;
and
in response to the user selection of the selected schema, defining an additional portion of the data structure in accordance with the selected schema.

4 more elements

At a computer system including one or more processors and system memory, a method for suggesting schemas to a user during the development of a data structure, the method comprising:

receiving input to a development tool, the input defining the name of a column of a database;
comparing at least a portion of the name to names of columns in a plurality of schemas;
identifying one or more schemas, in the plurality of schemas, that each include a column having a name with at least a portion that matches the at least a portion of the name of the column input to the development tool;
determining a data type of the data of each of the one or more identified columns;
determining one or more additional columns that are included in each of the one or more schemas;
displaying the data type of the data of each of the one or more identified columns as recommended data types for the column of the database being defined in the development tool;
and
displaying the one or more additional columns as recommended columns to be included in the database being defined in the development tool.

5 more elements

Dependencies are inferred from the claim text.

Intelligently recommending schemas based on user input

Life of this patent

Intelligently recommending schemas based on user input

Life of this patent

Abstract

Claims20