Andrew R Peters

US Patent:

8595175, Nov 26, 2013

Filed:

Jul 11, 2011

Appl. No.:

13/179601

Inventors:

Arthur John Cerdic Vickers - Redmond WA, US
Diego Bernardo Vega - Sammamish WA, US
Rowan Miller - Kirkland WA, US
Andrew John Peters - Sammamish WA, US
Jeffrey Michael Derstadt - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/00
G06N 5/02

US Classification:

706 50

Abstract:

Fluent API Patterns promote balance in managing object persistence. Code which obtains an object-relational mapper session contains API Patterns that manipulate persistence ignorant objects using calls to a fluent interface. When the developer's code executes, it may manipulate an object state, a property state, and/or a persistent relationship of the persistence ignorant object. The code may implement API Patterns such as find-change-save, current-value-original-value, nested-property, incremental-graph-load, incremental-graph-filtered-load, property-modification, dictionary, and/or other API Patterns. Additional examples of API Patterns include an API Pattern to read current, original, and database values for all properties of an entity; an API Pattern to set current and/or original values from another object; and an API Pattern to create a cloned object containing current, original, and/or database values. In any or all of these situations, the API Pattern calls to the fluent interface may be written in a strongly typed language.

US Patent:

8600925, Dec 3, 2013

Filed:

Jul 11, 2011

Appl. No.:

13/179598

Inventors:

Arthur John Cerdic Vickers - Redmond WA, US
Diego Bernardo Vega - Sammamish WA, US
Rowan Miller - Kirkland WA, US
Andrew John Peters - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/00
G06N 5/02

US Classification:

706 50

Abstract:

A balance is provided between automation of repetitive database creation and configuration efforts, on the one hand, and flexibility to depart from prior configurations, on the other hand, to assist developers with aspects of database initialization. An application domain includes data context instances, database connections, object models mapped by an object-relational mapper, and database initializers. Upon the first attempted runtime use of a particular database connection—data context instance—object model combination, a database initializer is invoked. Initializers may check to see if the database exists, (re)generate a database and schema based on the object model, determine whether the database is compatible with the current object model, delete the database and its schema, seed data, modify database indexes, and/or migrate an existing database, for example. A custom initializer can run developer-supplied code as desired to place the database in a known state for use by the application.

US Patent:

20120330878, Dec 27, 2012

Filed:

Jun 23, 2011

Appl. No.:

13/166825

Inventors:

Arthur VICKERS - Redmond WA, US
Diego Vega - Sammamish WA, US
Rowan Miller - Kirkland WA, US
Andrew Peters - Sammamish WA, US
Jeff Derstadt - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06N 5/02

US Classification:

706 50

Abstract:

A programming environment may use a set of conventions that may infer database objects from memory objects or memory objects from database objects. The inferred objects may be referenced and used in the programming environment after being created by the set of conventions. The set of conventions may be added to or modified to create different results that are inferred by the conventions. Some conventions may be dependent on other conventions, and the dependencies may be modified by reordering the conventions or otherwise redefining the dependencies. In some embodiments, a versioning system may manage different versions of the convention sets for various upgrade scenarios.

US Patent:

20130018902, Jan 17, 2013

Filed:

Jul 11, 2011

Appl. No.:

13/179914

Inventors:

Arthur John Cerdic Vickers - Redmond WA, US
Diego Bernardo Vega - Sammamish WA, US
Rowan Laurence Miller - Kirkland WA, US
Andrew John Peters - Sammamish WA, US
Timothy A. Laverty - Seattle WA, US
Jeffrey Michael Derstadt - Sammamish WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/30

US Classification:

707756, 707E17005

Abstract:

Techniques are described herein that are capable of translating programming language patterns into database schema patterns. Examples of a programming language pattern include but are not limited to a source code pattern, an intermediate language code pattern, metadata associated with a source code pattern, metadata associated with an intermediate language code pattern, or any combination thereof. The programming language patterns may define objects that are included in an object model. Database schema patterns that define a database are automatically (e.g., inferentially) created based on respective programming language patterns that define objects of an object model. The programming language patterns are automatically mapped to the respective database schema patterns.

US Patent:

20130019225, Jan 17, 2013

Filed:

Jul 11, 2011

Appl. No.:

13/179629

Inventors:

Andrew PETERS - Sammamish WA, US
Arthur VICKERS - Redmond WA, US
Diego VEGA - Sammamish WA, US
Rowan MILLER - Kirkland WA, US
Jeff DERSTADT - Sammamish WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 9/44
G06F 17/30

US Classification:

717106, 717121

Abstract:

An application programming interface may alter the inferences made by a set of conventions that may infer database objects from memory objects in an application. The changes or overrides to the inferences may be applied when the application is executed and may cause the database objects to be created or organized in a different manner than when the original inferences were used. A configuration database may store the inferences and overrides, and may be referenced when the conventions are applied. The configuration database may be incrementally updated so that any changes or overrides are persisted to the next version of an application.

US Patent:

20180260400, Sep 13, 2018

Filed:

May 14, 2018

Appl. No.:

15/979274

Inventors:

- Redmond WA, US
Diego Bernardo Vega - Sammamish WA, US
Rowan Laurence Miller - Kirkland WA, US
Andrew John Peters - Sammamish WA, US
Timothy A. Laverty - Seattle WA, US
Jeffrey Michael Derstadt - Sammamish WA, US

International Classification:

G06F 17/30
G06F 8/51

Abstract:

Techniques are described herein that are capable of translating programming language patterns into database schema patterns. Examples of a programming language pattern include but are not limited to a source code pattern, an intermediate language code pattern, metadata associated with a source code pattern, metadata associated with an intermediate language code pattern, or any combination thereof. The programming language patterns may define objects that are included in an object model. Database schema patterns that define a database are automatically (e.g., inferentially) created based on respective programming language patterns that define objects of an object model. The programming language patterns are automatically mapped to the respective database schema patterns.

US Patent:

20160132510, May 12, 2016

Filed:

Jan 18, 2016

Appl. No.:

15/000020

Inventors:

- Redmond WA, US
Diego Bernardo Vega - Sammamish WA, US
Rowan Laurence Miller - Kirkland WA, US
Andrew John Peters - Sammamish WA, US
Timothy A. Laverty - Seattle WA, US
Jeffrey Michael Derstadt - Sammamish WA, US

International Classification:

G06F 17/30

Abstract:

Techniques are described herein that are capable of translating programming language patterns into database schema patterns. Examples of a programming language pattern include but are not limited to a source code pattern, an intermediate language code pattern, metadata associated with a source code pattern, metadata associated with an intermediate language code pattern, or any combination thereof. The programming language patterns may define objects that are included in an object model. Database schema patterns that define a database are automatically (e.g., inferentially) created based on respective programming language patterns that define objects of an object model. The programming language patterns are automatically mapped to the respective database schema patterns.