Matthew S Carroll

US Patent:

7870540, Jan 11, 2011

Filed:

Jan 11, 2005

Appl. No.:

11/032960

Inventors:

Robert B. Zare - Issaquah WA, US
Andriy Garbuzov - Redmond WA, US
Adrian Dumitrascu - Bellevue WA, US
Matthew E. Carroll - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 9/44

US Classification:

717126, 717109, 717112, 717125

Abstract:

A system that facilitates validating an object in a software design tool comprises a component that receives input relating to development of an object. A validating component, prior to compile, automatically determines whether the object is associated with an error upon receipt of the input. An alarm component can generate an alarm upon the validating component determining that the object is associated with an error.

US Patent:

7885978, Feb 8, 2011

Filed:

Mar 1, 2005

Appl. No.:

11/069480

Inventors:

Adrian Dumitrascu - Bellevue WA, US
Cristian Petculescu - Redmond WA, US
Matthew E. Carroll - Seattle WA, US
Paul J. Sanders - Seattle WA, US
Thomas P. Conlon - Redmond WA, US
Amir Netz - Bellevue WA, US
Oleg Lvovitch - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707802

Abstract:

The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data modeling system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components. An extension component operates with the protocol component to support the data transactions, where the extension component supplies various commands above standard network and database protocols. An object model is provided as a wrapper to the extensions in order to support various online and offline database development applications.

US Patent:

8028225, Sep 27, 2011

Filed:

Nov 21, 2007

Appl. No.:

11/943601

Inventors:

Robert B. Zare - Issaquah WA, US
Adrian Dumitrascu - Redmond WA, US
Aleksandar Juric - Redmond WA, US
Maria Potapova - Kenmore WA, US
Matthew E. Carroll - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/00

US Classification:

715200

Abstract:

Various technologies and techniques are disclosed for creating and managing a visual representation of OLAP attributes and relationships for a dimension. A visual representation is generated that contains an arrangement of shapes with connections between shapes. One or more sub-elements are contained within at least some of the shapes. Connections between the shapes represent relationships between attributes in an OLAP dimension. The containment of a respective sub-element within a respective shape represents a relationship between an attribute being represented by the respective sub-element and an attribute being represented by the respective shape. Shapes representing OLAP attributes and relationships can be programmatically grouped and ungrouped. When an attribute does not have any outgoing relationships, when an attribute only has one incoming relationship, and when the attribute is not a level in a user-defined hierarchy, a grouping process is performed to put the attribute in an expandable shape belonging to another attribute.

US Patent:

20090006455, Jan 1, 2009

Filed:

Jun 30, 2007

Appl. No.:

11/824719

Inventors:

Matthew Carroll - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/00

US Classification:

707102, 707103 R, 707E17005

Abstract:

An arrangement for deducing descriptive metadata from data contained in a column of a relational table and associated existing metadata (e.g., that which identifies column data type and/or column name) is provided by a metadata deduction engine in a set of OLAP tools which operates in conjunction with an analysis services server. The metadata deduction engine applies one or more criteria that are configured to evaluate column data in order to deduce metadata that provides additional contextual meaning to the column data beyond that given by the existing metadata. The metadata deduction engine maps the column data to a metadata tag that is passed to the analysis services server to enable it to create an OLAP cube using the deduced metadata.

US Patent:

20090132574, May 21, 2009

Filed:

Nov 19, 2007

Appl. No.:

11/941989

Inventors:

Adrian Dumitrascu - Redmond WA, US
Matthew E. Carroll - Seattle WA, US
Robert B. Zare - Issaquah WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/00

US Classification:

707102, 707E17005

Abstract:

Various technologies and techniques are disclosed for integrating best design practices with a database. Rules for best design practices are integrated into an object model of a database. As the database design changes, violations to the rules are detected. Notifications are output for the violations of the rules. The system detects when a change to the database design that is made in a development environment causes a violation to a best design practice. The violation to the best design practice is indicated to the user. A database can be validated upon request to detect any violations of best design practices. A request is received to validate a selected database for best design practices. A best design practices check is performed against the selected database to identify if any violations are present. Any violations are output that were identified while performing the best design practices check.

US Patent:

20110295865, Dec 1, 2011

Filed:

May 27, 2010

Appl. No.:

12/788310

Inventors:

Matthew Carroll - Seattle WA, US
David Noor - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707756, 707802, 707769, 707E17044, 707E17014

Abstract:

A system and method for extracting data from an input source, transforming the data, and loading the transformed data to an output destination. A schema contract including constraints is used to validate a set of input data column types and translate them into a set of actual types. Mapping data in the schema contract enable mapping input data columns to data columns used by data integration components. The constraints and mapping data provide flexibility in transforming sets of data having different sets of input data column types, while providing a fixed set of types for use during dataflow executions. Flexibility may enable optional columns, sets of one or more columns, varying arrangements of columns, and variations in type definitions of each column.

US Patent:

20110307866, Dec 15, 2011

Filed:

Jun 15, 2010

Appl. No.:

12/816378

Inventors:

Bekim Demiroski - Shanghai, CN
David Noor - Redmond WA, US
Jeffrey Bernhardt - Woodinville WA, US
Matthew Carroll - Seattle WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 9/44

US Classification:

717124

Abstract:

A system and method for facilitating execution of one or more data integration projects in multiple environments or an environment that undergoes changes. Each project has a set of project parameters, which are bound to environment variables. Each environment has a corresponding environment representation with environment variables and corresponding values. Each project is mapped to an environment representation. Values of environment variables are provided to projects with corresponding parameters. When one or more projects are changed to a different environment with a different corresponding environment representation, the environment variable values of the new environment representation are provided to the projects. When an environment change is reflected in the environment representation, the changed variable values are provided to mapped projects.

US Patent:

20120254259, Oct 4, 2012

Filed:

Mar 28, 2011

Appl. No.:

13/073212

Inventors:

Kevin Thomas Edward McGuire - Seattle WA, US
Sergio Silveira Clemente Filho - Kirkland WA, US
Matthew Carroll - Seattle WA, US
Cimarron S. Ryan - Bellevue WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 7/00

US Classification:

707804, 707E17044

Abstract:

A method includes connecting an integration process to a first set of inputs. The first set of inputs may include one or more inputs. The integration process includes one or more data transformation operations using the inputs. The method further includes receiving metadata about one or more of the inputs in the first set of inputs. The metadata about one or more of the inputs in the first set of inputs is cached. The integration process is then connected to a second set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.