公开(公告)号：US20060224563A1

公开(公告)日：2006-10-05

申请号：US11098949

申请日：2005-04-05

Applicant: Eric Hanson ,  Cesar Galindo-Legaria ,  Lubor Kollar ,  Ganapathy Krishnamoorthy ,  Sameer Verkhedkar ,  Evgueni Zabokritski ,  Erik Ismert

Inventor： Eric Hanson ,  Cesar Galindo-Legaria ,  Lubor Kollar ,  Ganapathy Krishnamoorthy ,  Sameer Verkhedkar ,  Evgueni Zabokritski ,  Erik Ismert

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  Y10S707/99932 ,  Y10S707/99934

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.

公开(公告)号：US20050187944A1

公开(公告)日：2005-08-25

申请号：US10776370

申请日：2004-02-10

Applicant: Alazel Acheson ,  Shrinivas Ashwin ,  Jose Blakeley ,  Peter Carlin ,  Erik Ismert ,  Christian Kleinerman ,  Ganapathy Krishnamoorthy ,  Girikumar Nair

Inventor： Alazel Acheson ,  Shrinivas Ashwin ,  Jose Blakeley ,  Peter Carlin ,  Erik Ismert ,  Christian Kleinerman ,  Ganapathy Krishnamoorthy ,  Girikumar Nair

IPC: G06F7/00

CPC classification number: G06F17/30595 ,  G06F17/3041

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.

Abstract translation: 本发明的各种实施例使功能，过程和触发器能够以任何.NET语言编写并由RDBMS执行。 用户代码可以分别使用SQL编程模型和SqlServer或SqlClient实现访问来自本地或其他SQL服务器的数据。 此外，为了改进以前的可扩展性机制，使用一组API（通常称为“进程内提供程序”或“inproc提供程序”）来在运行inproc时提供高效且易于使用的数据访问，数据访问API 这是ADO.net编程模型的实现。

公开(公告)号：US08631039B2

公开(公告)日：2014-01-14

申请号：US12773889

申请日：2010-05-05

Applicant: Aleksandras Surna ,  Erik Ismert ,  Srikumar Rangarajan ,  Nimish S. Khanolkar

Inventor： Aleksandras Surna ,  Erik Ismert ,  Srikumar Rangarajan ,  Nimish S. Khanolkar

IPC: G06F17/30

CPC classification number: G06F17/30303 ,  G06F9/30192 ,  G06F9/3885 ,  G06F15/82 ,  G06F17/30292 ,  G06F17/30315 ,  G06F17/30569

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.

Abstract translation: 这里描述了一种数据归一化系统，其表示以规范化形式在数据库系统中通用的多个数据类型，其可以被均匀地处理以实现对超标量CPU架构的数据的更快处理。 数据归一化系统包括对数据库系统的内部数据表示的更改以及利用高密度独立可执行CPU指令的规范化内部数据表示的功能处理变化。 因为数据库中的大多数数据很小，所以大部分数据可以用归一化格式表示。 因此，数据归一化系统允许在各种常见情况下在数据库系统中进行快速超标量处理，同时保持与现有数据集的兼容性。

公开(公告)号：US07953674B2

公开(公告)日：2011-05-31

申请号：US11750132

申请日：2007-05-17

Applicant: Jiazhen Wu ,  Raul Garcia ,  Craig Alan Gick ,  Erik Ismert ,  Adrian Sorin Baras

Inventor： Jiazhen Wu ,  Raul Garcia ,  Craig Alan Gick ,  Erik Ismert ,  Adrian Sorin Baras

IPC: G06F15/18

CPC classification number: H04L63/1433 ,  G06F21/577

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.

Abstract translation: 在SQL服务器中包含模糊功能的系统和方法，以方便渗透测试。 与SQL服务器相关联的模糊组件提供了访问模糊系统以更新与SQL相关联的显式用户指定参数的入口点，其中服务器关于语言代码的语义（例如，解析方式）的深入知识可被用于 确定其漏洞。

公开(公告)号：US20100293177A1

公开(公告)日：2010-11-18

申请号：US12465656

申请日：2009-05-14

Applicant: Erik Ismert ,  Frank Huber

Inventor： Erik Ismert ,  Frank Huber

IPC: G06F17/30

CPC classification number: G06F17/30424

Abstract: Described is a 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.

Abstract translation: 描述了一种技术，通过该技术，针对数据堆栈执行数据库引擎中的表达式。 表达式的每个指令针对数据堆栈进行评估，直到针对每个数据堆栈完成，例如在执行下一条指令之前通过迭代执行指令通过数据堆栈。 数据可以以各种方式被布置在数据堆栈（在存储器中），例如使每个数据堆栈包含一个数据库行的数据（例如，数据堆栈元素包括列数据），数据可以被分组 将来自不同行的数据放入相同的数据堆栈中。

公开(公告)号：US08458441B2

公开(公告)日：2013-06-04

申请号：US12465656

申请日：2009-05-14

Applicant: Erik Ismert ,  Frank Huber

Inventor： Erik Ismert ,  Frank Huber

IPC: G06F9/00

CPC classification number: G06F17/30424

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.

Abstract translation: 主题公开涉及针对数据库引擎的表达式对数据堆叠执行的技术。 表达式的每个指令针对数据堆栈进行评估，直到针对每个数据堆栈完成，例如在执行下一条指令之前通过迭代执行指令通过数据堆栈。 数据可以以各种方式被布置在数据堆栈（在存储器中），例如使每个数据堆栈包含一个数据库行的数据（例如，数据堆栈元素包括列数据），数据可以被分组 将来自不同行的数据放入相同的数据堆栈中。

公开(公告)号：US07933894B2

公开(公告)日：2011-04-26

申请号：US11763490

申请日：2007-06-15

Applicant: Marc T. Friedman ,  Cesar A. Galindo-Legaria ,  Erik Ismert ,  Milind Madhukar Joshi ,  Naveen Prakash

Inventor： Marc T. Friedman ,  Cesar A. Galindo-Legaria ,  Erik Ismert ,  Milind Madhukar Joshi ,  Naveen Prakash

IPC: G06F17/30

CPC classification number: G06F17/30463

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.

Abstract translation: 生成用于编译SQL查询的专门计划的系统和方法。 计划生成器组件扫描参数敏感谓词的查询表达式，并根据参数值分别评估每个谓词。 因此，不仅可以基于它们的结构，而且还可以基于它们的参数条件来识别查询。 特定计划对于特定值更有效，其中采用这些值的查询被最佳地执行。

公开(公告)号：US20080313131A1

公开(公告)日：2008-12-18

申请号：US11763490

申请日：2007-06-15

Applicant: Marc T. Friedman ,  Cesar A. Galindo-Legaria ,  Erik Ismert ,  Milind Madhukar Joshi ,  Naveen Prakash

Inventor： Marc T. Friedman ,  Cesar A. Galindo-Legaria ,  Erik Ismert ,  Milind Madhukar Joshi ,  Naveen Prakash

IPC: G06F17/30

CPC classification number: G06F17/30463

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.

Abstract translation: 生成用于编译SQL查询的专门计划的系统和方法。 计划生成器组件扫描参数敏感谓词的查询表达式，并根据参数值分别评估每个谓词。 因此，不仅可以基于它们的结构，而且还可以基于它们的参数条件来识别查询。 特定计划对于特定值更有效，其中采用这些值的查询被最佳地执行。

公开(公告)号：US08112383B2

公开(公告)日：2012-02-07

申请号：US10776370

申请日：2004-02-10

Applicant: Alazel Acheson ,  Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Erik Ismert ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Girkumar Nair

Inventor： Alazel Acheson ,  Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Erik Ismert ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Girkumar Nair

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30595 ,  G06F17/3041

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.

Abstract translation: 本发明的各种实施例使功能，过程和触发器能够以任何.NET语言编写并由RDBMS执行。 用户代码可以分别使用SQL编程模型和SqlServer或SqlClient实现访问来自本地或其他SQL服务器的数据。 此外，为了改进以前的可扩展性机制，使用一组API（通常称为“进程内提供程序”或“inproc提供程序”）来提供高效且易于使用的数据访问，同时运行inproc，数据访问API 这是ADO.net编程模型的实现。

公开(公告)号：US20110276607A1

公开(公告)日：2011-11-10

申请号：US12773889

申请日：2010-05-05

Applicant: Aleksandras Surna ,  Erik Ismert ,  Srikumar Rangarajan ,  Nimish S. Khanolkar

Inventor： Aleksandras Surna ,  Erik Ismert ,  Srikumar Rangarajan ,  Nimish S. Khanolkar

IPC: G06F17/30

CPC classification number: G06F17/30303 ,  G06F9/30192 ,  G06F9/3885 ,  G06F15/82 ,  G06F17/30292 ,  G06F17/30315 ,  G06F17/30569

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.

Abstract translation: 这里描述了一种数据归一化系统，其表示以规范化形式在数据库系统中通用的多个数据类型，其可以被均匀地处理以实现对超标量CPU架构的数据的更快处理。 数据归一化系统包括对数据库系统的内部数据表示的更改以及利用高密度独立可执行CPU指令的规范化内部数据表示的功能处理变化。 因为数据库中的大多数数据很小，所以大部分数据可以用归一化格式表示。 因此，数据归一化系统允许在各种常见情况下在数据库系统中进行快速超标量处理，同时保持与现有数据集的兼容性。