INTELLIGENTLY RECOMMENDING SCHEMAS BASED ON USER INPUT

• US 20130159960A1
• Filed: 12/15/2011
• Published: 06/20/2013
• Est. Priority Date: 12/15/2011
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Sivaramakrishnan, Hariharan, Bice, Anthony Nino, Mancini, David
• Granted Patent: US 9,038,014 B2
• Time in Patent Office: Days
• US Class Current: 717/100
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06F 8/33 Intelligent editors

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.

Claims

1. 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.

2. The method of claim 1, wherein the portion of the data structure defined by the input is a name of a column of the data structure.

3. The method of claim 2, wherein the data structure is one of a database or a spreadsheet.

4. The method of claim 2, wherein identifying one or more characteristics of the input comprises matching at least a portion of the name of the column to at least a portion of the name of one or more other columns used in the one or more recommended schemas.

5. The method of claim 1, wherein at least one of the plurality of schemas is stored in a dataset in a cloud of computing systems, the method further comprising accessing the dataset in the cloud of computer systems to analyze the at least one of the plurality of schemas to identify whether to recommend the at least one of the plurality of schemas.

6. The method of claim 1, further comprising analyzing one or more characteristics of previous input that define other portions of the data structure;

and

wherein recommending one or more schemas comprises recommending the one or more schemas based on one or more characteristics identified from previous user input.

7. The method of claim 6, wherein the previous user input comprises the name of another column of the data structure.

8. The method of claim 1, wherein adding an additional portion of the data structure as defined within the selected schema comprises adding a definition of a data type of data that is to be stored within the additional portion of the data structure.

9. The method of claim 1, wherein adding an additional portion of the data structure as defined within the selected schema comprises adding one or more constraints on data that is to be stored within the additional portion of the data structure.

10. The method of claim 1, wherein adding an additional portion of the data structure as defined within the selected schema comprises adding input that defines one or more additional columns of the data structure.

11. The method of claim 1, further comprising prior to recommending the one or more schemas:

analyzing a store of schemas to determine common characteristics of schemas in the store; and

based on the common characteristics, generating the plurality of schemas.

12. The method of claim 1, wherein at least one of the recommended one or more schemas is associated with a policy, the method further comprising:

in response to user selection of the selected schema, generating telemetry information that identifies the selected schema from among the one or more recommended schemas including identifying whether the user selected the at least one schema that is associated with the policy; and

using the telemetry information to refine the identification of recommended schemas during the creation of subsequent data structures and to determine whether the policy is being implemented.

13. At a computer system including one or more processors and system memory, a method for suggesting intelligent auto-completion to a user during the development of a data structure, the method comprising:

receiving input at a development tool, the input defining a name of a column of a database;

based on one or more portions of the name, recommending one or more data types for the data of the column, wherein the recommendation is based on matching the one or more portions of the name of the column to one or more portions of the name of other columns defined in other schemas; and

upon receiving input that selects one of the one or more recommended data types, adding input to the development tool that defines the selected data type as the data type for the data of the column.

14. The method of claim 13, further comprising based on the one or more portions of the name, recommending one or more additional columns to be included in the database, the one or more additional columns including a name and a data type.

15. The method of claim 13, further comprising based on the one or more portions of the name, recommending one or more constraints on data that is to be stored in the column.

16. The method of claim 13, wherein the recommendation is further based on one or more other columns that are already defined for the database.

17. 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.

18. The method of claim 17, wherein the database is defined in the development tool to include one or more other columns, and wherein 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 further comprises:

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, and that each include at least one of the one or more other columns of the database defined in the development tool.

19. The method of claim 17, further comprising:

displaying the one or more schemas as recommended schemas for the database; and

upon the user selecting one of the one or more schemas, adding input to the development tool that defines the database to conform to the selected schema.

20. The method of claim 19, wherein the schema includes a name and data type for each of a plurality of columns of one or more tables of the database and one or more of the following:

one or more stored procedures;

one or more triggers;

or

one or more constraints.