Microsoft Technology Licensing, LLC

Sumit Chauhan

Michael J McCormack

Andrew Robert Miller

Scott Timothy Gardner

Jason A Bould

Daniel J Cole

Suraj T Poozhiyil

Richard Lee Dickinson

Timothy E Getsch

David Jon Conger

Vijay Mital

Steven Miles Greenberg

Clinton Dee Covington

Shen Wang

Todd Haugen

Neil Warren Black

Eric W Patterson

Peter Alan Carlin

Su-Piao Bill Wu

Brian Eugene Kihneman

Robert Wayne Coffen

Robert Coggins

Pavel Kouznetsov

Matthew C Pohle

Vitore Selca

Ryan Christopher McMinn

Richard Shawn McDowell

Michael Hopkins Smith

Vijayalakshmi Ramkumar

Gloria Monroe Godfrey

Alexander Alexandrovich Spiridonov

Gregory L Chan

Abigail Elisabeth Short

Michael Allen Brotherton

Xiaohui Pan

Russell Sinclair

Michael J Eatough

Tobias Joakim Bertil Ternström

Ritu Singh

David Michael Jade

Christopher Todd Seitzinger

David M Vierzba

Paul A Hafner

Larry Tseng

Robert E Coggins

Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

Database data type creation and reuse

Creating web application using cloud-based friction-free databases without web hosting knowledge. User credentials are received at a web application service for initiating a web application task via client software. The user credentials are analyzed to determine whether to grant the user permission to initiate the requested web application task. The web application task is initiated when the permission is granted. Data associated with the initiated web application task is received at the web application service for analysis of the data to host and render a web application based solely on received data provided without basis of web hosting knowledge.

Creating web applications using cloud-based friction-free databases without requiring web hosting knowledge

A customized form is provided for entering parameters associated with a query. A user may desire to modify a report resulting from a query to a database. To enter the parameters for modification, a customized form is displayed to the user. The customized form allows for entry of the parameters according to prompts that are related by their presentation to the form being generated.

Customizable parameter user interface

Computer software applications may be separated into components and distilled into functional and identifying attributes, which may then be used to regenerate the computer software application on a different system. A component of a computer software program is received. From the component, one or more functional attributes describing the operation of the component on a first operating platform are distilled from which the component can be generated to operate on one or more operating platforms. Attributes identifying the component are identified. The functional attributes and the identifying attributes of the component are stored in a distillation store. From the distillation store, using information about a selected operating platform on which the computer software program is to be executed, components of the computer software program may be generated to execute on the selected operating platform.

Application dehydration, synchronization, and rehydration

Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.

Database part table junctioning

Methods, systems, and computer-readable media implementing various aspects of complex data in a conceptual table are disclosed which enable complex data in the form of tables to be added to a conceptual table. The complex data can map to scalar values in a plurality of data tables. Complex data may be entered via data modeling methods, accessed via cursoring methods, and queried via query expansion methods.

Complex data access

Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.

Database part creation, merge and reuse

Embodiments are provided to calculate and provide information based in part on a defined expression. In an embodiment, a database system can be configured to include a number of calculated columns as part of a database table structure. The database system can be configured to present a calculated result based in part on a determined result type. In one embodiment, a database system can be configured to enable calculated columns to be defined on a table of a database, wherein a component can be used to evaluate an expression associated with a column calculation to determine a proper result type. The proper result type can be stored and used when presenting a result of the calculation. Other embodiments are available.

Calculating and storing data structures including using calculated columns associated with a database system

Methods, systems and computer products are provided for allowing bi-directional communication between a database application and a remote data source and for allowing updating of data on a remote data source with data edited or created at a client site remote from the remote data source during an offline data editing or entry session via a client database application.

Offline multi-table data editing and storage

Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.

Data source write back and offline data editing and storage in a spreadsheet

Growing community of inventors

Sammamish, WA, United States of America

Sumit Chauhan