GENERATION OF AN APPLICATION FROM DATA

• US 20170357487A1
• Filed: 05/27/2017
• Published: 12/14/2017
• Est. Priority Date: 11/09/2015
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Balasubramanian, Barath, Cohen, Evan Bjorn-Thomas, Gruian, Radu Bogdan, Benmouffok, Mohammed Amine, Colle, Olivier, Lindhorst, Gregory S., Sathsahayaraman, Muralidhar, Dani, Unnati J., Dobin, Alexander J.
• Granted Patent: US 10,466,971 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 8/30 Creation or generation of source code
• CPC Class Codes: G06F 8/38 for implementing user interfaces

Abstract

Examples of the disclosure provide for receiving a data set at a design surface from a data source, and inferring a first data type from the data set. A first control type is generated for the inferred first data type. A second data type is inferred from the data set and a second control type is generated for the inferred second data type, with the first control type and the second control type being different. A layout is generated for an application document that includes the first control type and the second control type.

Claims

1-20. -20. (canceled)

21. A computer-implemented method for generating an application from data, the method comprising:

identifying a plurality of subsets of data from source data;

inferring a first data type from an identified first subset of data;

identifying a default control type from the inferred first data type;

generating a first control type for the identified first subset of data based on the identified default control type;

inferring a second data type from an identified second subset of data;

generating a second control type for the identified second subset of data based on the inferred second data type, wherein the first control type and the second control type are different; and

automatically generating an application document that includes the first control type and the second control type.

22. The method of claim 21, wherein at least one of the inferred first data type and the inferred second data type is inferred based on user profile data.

23. The method of claim 21, wherein at least one of the inferred first data type and the inferred second data type is inferred based on telemetry data.

24. The method of claim 21, further comprising:

associating a layout with the application document based on the first control type and the second control type;

receiving a selection of a third control type for the second data type, the third control type being different from the second control type; and

re-generating the layout associated with the application document to include the first control type and the third control type.

25. The method of claim 21, wherein the application document includes at least three forms.

26. The method of claim 25, wherein the at least three forms comprise a browsing form, a detail form, and an edit form.

27. The method of claim 21, wherein at least one of the inferred first data type and the inferred second data type is inferred based on a source data type within the source data.

28. The method of claim 27, wherein the data source is a spreadsheet, and wherein the inferred first data type is inferred based on one or more values in a first column of the spreadsheet.

29. The method of claim 21, wherein at least one of the inferred first data type and the inferred second data type is inferred based on metadata provided by a connection provider of the source data.

30. A system for generating an application from data, the system comprising:

a developer environment, implemented on a processor, configured to receive source data;

a data inference mechanism, coupled to the developer environment, configured to identify a plurality of subsets of data from the source data and infer a first data type from a first subset of data and a second data type from a second subset of data;

a control generator configured to identify a default control type from the inferred first data type and generate a first control type for the first subset of data based on the identified default control type, and generate a second control type for the second subset of data based on the inferred second data type, wherein the first control type and the second control type are different; and

a layout generator configured to automatically generate an application document using the generated first control type, the generated second control type, and the identified plurality of subsets of data.

31. The system of claim 30, further comprising:

a data connection mechanism configured to obtain one or more data sources as a connection list for the developer environment.

32. The system of claim 30, further comprising:

a theme manager, coupled to the developer environment, configured to apply a selected theme from a provided list of themes to the generated application document.

33. The system of claim 30, further comprising:

a data control table configured to provide a mapping between one or more data types and one or more control types.

34. The system of claim 30, wherein the source data is a spreadsheet.

35. The system of claim 30, wherein the source data is a number of tables.

36. The system of claim 30, wherein the generated application document is a modifiable template.

37. One or more computer readable memories having computer-executable instructions stored thereon for generating an application from data, which, on execution by a computer, cause the computer to perform operations comprising:

identifying a plurality of subsets of data from source data;

inferring a first data type from an identified first subset of data;

identifying a default control type from the inferred first data type;

generating a first control for the first subset of data based on the identified default control type;

inferring a second data type from an identified second subset of data; and

generating a second control for the second subset of data based on the inferred second data type, wherein the first control and the second control are different control types.

38. The one or more computer readable memories of claim 37, having further computer-executable instructions stored thereon, which, on execution by a computer, cause the computer to perform operations comprising:

determining whether the first subset of data comprises yes/no values; and

responsive to determining that the first subset of data comprises yes/no values, inferring a Boolean data type.

39. The one or more computer readable memories of claim 37, having further computer-executable instructions stored thereon, which, on execution by a computer, cause the computer to perform operations comprising:

determining whether the first subset of data comprises three or more values; and

responsive to determining that the first subset of data comprises three or more values, inferring a list data type.

40. The one or more computer readable memories of claim 37, having further computer-executable instructions stored thereon, which, on execution by a computer, cause the computer to perform operations comprising:

determining whether the first subset of data comprises numerical values; and

responsive to determining that the first subset of data comprises the numerical values, inferring a date data type.