Erik E Ismert

US Patent:

7933894, Apr 26, 2011

Filed:

Jun 15, 2007

Appl. No.:

11/763490

Inventors:

Marc T. Friedman - Seattle WA, US
Cesar A. Galindo-Legaria - Redmond WA, US
Erik Ismert - Shoreline WA, US
Milind Madhukar Joshi - Redmond WA, US
Naveen Prakash - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707718, 707637, 707713, 707714, 707715, 707716, 707717, 707719, 707720, 707721, 707600

Abstract:

Systems and methods that generate specialized plans for compiling SQL queries. A plan generator component scans the query representation for parameter sensitive predicates and evaluates each predicate individually based on the parameter values. Accordingly, queries can be identified not only based on their structures, but also based on their parameter conditions. The specialized plans are more efficient for particular values, wherein queries that employ such values are optimally executed.

US Patent:

7953674, May 31, 2011

Filed:

May 17, 2007

Appl. No.:

11/750132

Inventors:

Jiazhen Wu - Sammamish WA, US
Raul Garcia - Kirkland WA, US
Craig Alan Gick - Woodinville WA, US
Erik Ismert - Shoreline WA, US
Adrian Sorin Baras - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 15/18

US Classification:

706 1

Abstract:

Systems and methods that incorporate fuzzing capabilities within an SQL server to facilitate penetration testing. A fuzzing component associated with the SQL server provides an entry point for accessing the fuzzing system to update explicit user specified parameters associated with SQL, wherein the server's in depth knowledge regarding semantics of the language code (e. g. , manner of parsing) can be employed to determine vulnerabilities thereof.

US Patent:

8112383, Feb 7, 2012

Filed:

Feb 10, 2004

Appl. No.:

10/776370

Inventors:

Alazel Acheson - Redmond WA, US
Shrinivas Ashwin - Sammamish WA, US
Jose A. Blakeley - Redmond WA, US
Peter Carlin - Seattle WA, US
Erik Ismert - Shoreline WA, US
Christian Kleinerman - Bellevue WA, US
Ganapathy Subramaniam Krishnamoorthy - Issaquah WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707102, 707718

Abstract:

Various embodiments of the present invention enable functions, procedures, and triggers to be written in any of the. NET languages and executed by the RDBMS. User code can access data from the local or other SQL servers using the SQL Programming Model and both the SqlServer or SqlClient implementations respectively. Moreover, to improve upon the previous extensibility mechanism, a set of APIs (commonly known as “the in-process provider” or “inproc provider”) is utilized to provide efficient and easy to use data access while running inproc, a data access API that is an implementation of the ADO. net programming model.

US Patent:

8458441, Jun 4, 2013

Filed:

May 14, 2009

Appl. No.:

12/465656

Inventors:

Erik Ismert - Shoreline WA, US
Frank Huber - Berlin, DE

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 9/00

US Classification:

712202

Abstract:

The subject disclosure is directed towards technology by which an expression in a database engine is executed against stacks of data. Each instruction of the expression is evaluated against the data stacks until completed against each data stack, such as by iterating to execute an instruction through the data stacks before executing the next instruction. The data may be arranged in the data stacks (in memory) in various ways, such as to have each data stack contain the data of one database row, (e. g. , with the data stack elements comprising column data. Data may be grouped, such as to put the data from different rows into the same data stack.

US Patent:

8631039, Jan 14, 2014

Filed:

May 5, 2010

Appl. No.:

12/773889

Inventors:

Aleksandras Surna - Redmond WA, US
Erik Ismert - Shoreline WA, US
Srikumar Rangarajan - Sammamish WA, US
Nimish S. Khanolkar - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707790, 707812

Abstract:

A data normalization system is described herein that represents multiple data types that are common within database systems in a normalized form that can be processed uniformly to achieve faster processing of data on superscalar CPU architectures. The data normalization system includes changes to internal data representations of a database system as well as functional processing changes that leverage normalized internal data representations for a high density of independently executable CPU instructions. Because most data in a database is small, a majority of data can be represented by the normalized format. Thus, the data normalization system allows for fast superscalar processing in a database system in a variety of common cases, while maintaining compatibility with existing data sets.

US Patent:

20060224563, Oct 5, 2006

Filed:

Apr 5, 2005

Appl. No.:

11/098949

Inventors:

Eric Hanson - Bellevue WA, US
Cesar Galindo-Legaria - Redmond WA, US
Lubor Kollar - Redmond WA, US
Ganapathy Krishnamoorthy - Issaquah WA, US
Sameer Verkhedkar - Issaquah WA, US
Evgueni Zabokritski - Redmond WA, US
Erik Ismert - Shoreline WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707002000

Abstract:

A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.

US Patent:

20180307721, Oct 25, 2018

Filed:

Jun 22, 2018

Appl. No.:

16/016029

Inventors:

- Redmond WA, US
Milos Andelkovic - Smederevo, RS
Marko Zivanovic - Sopot, RS
Craig Steven Freedman - Sammamish WA, US
Erik Ismert - Shoreline WA, US

International Classification:

G06F 17/30

Abstract:

A data system in which a parent transaction that has multiple nested transactions has isolation between the nested transactions. Each of at least some of the plurality of operations are included within a nested transaction within the parent transaction. For each of at least some of the nested transactions, a begin transaction identifier is assigned to the nested transaction; and on or around completion of the nested transaction, a completion transaction identifier is assigned as a statement identifier at least one object version operated upon by the nested transaction. Visibility of a particular version of an object to an active nested transaction may be verified by comparing the begin transaction identifier of the active nested transaction to the statement identifier of the particular version of the object. The comparison is done such that visibility achieves the proper isolation between nested transactions.

US Patent:

20170124125, May 4, 2017

Filed:

Jan 18, 2017

Appl. No.:

15/409138

Inventors:

- Redmond WA, US
Erik Ismert - Shoreline WA, US
Srikumar Rangarajan - Sammamish WA, US
Nimish Khanolkar - Redmond WA, US

International Classification:

G06F 17/30
G06F 9/38

Abstract:

A data normalization system is described herein that represents multiple data types that are common within database systems in a normalized form that can be processed uniformly to achieve faster processing of data on superscalar CPU architectures. The data normalization system includes changes to internal data representations of a database system as well as functional processing changes that leverage normalized internal data representations for a high density of independently executable CPU instructions. Because most data in a database is small, a majority of data can be represented by the normalized format. Thus, the data normalization system allows for fast superscalar processing in a database system in a variety of common cases, while maintaining compatibility with existing data sets.