公开(公告)号：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编程模型的实现。

公开(公告)号：US20090077253A1

公开(公告)日：2009-03-19

申请号：US11969335

申请日：2008-01-04

Applicant: Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

Inventor： Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

IPC: G06F15/16

CPC classification number: G06F17/3056 ,  Y10S707/99934 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Systems and methodologies are provided as part of a computing environment that implements an enhanced tabular data stream (TDS) protocol. Such enhanced TDS protocol can mitigate synchronization inconsistencies between client and servers, improve robustness of the data transfer, facilitate password specification as part of login procedures, and reduce administration overhead. Various headers are provided as part of the data stream protocol, and a versioning scheme is established that facilitates proper communication between servers and clients having different release dates and versions of the TDS protocol.

Abstract translation: 提供系统和方法作为实现增强的表格数据流（TDS）协议的计算环境的一部分。 这种增强的TDS协议可以减轻客户端和服务器之间的同步不一致性，提高数据传输的鲁棒性，便于作为登录过程一部分的密码规范，并减少管理开销。 提供了各种头部作为数据流协议的一部分，并且建立了一种版本控制方案，其促进具有不同发布日期和版本的TDS协议的服务器和客户端之间的正确通信。

公开(公告)号：US08370511B2

公开(公告)日：2013-02-05

申请号：US11969335

申请日：2008-01-04

Applicant: Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

Inventor： Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

IPC: G06F17/30

CPC classification number: G06F17/3056 ,  Y10S707/99934 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Systems and methodologies are provided as part of a computing environment that implements an enhanced tabular data stream (TDS) protocol. Such enhanced TDS protocol can mitigate synchronization inconsistencies between client and servers, improve robustness of the data transfer, facilitate password specification as part of login procedures, and reduce administration overhead. Various headers are provided as part of the data stream protocol, and a versioning scheme is established that facilitates proper communication between servers and clients having different release dates and versions of the TDS protocol.

Abstract translation: 提供系统和方法作为实现增强的表格数据流（TDS）协议的计算环境的一部分。 这种增强的TDS协议可以减轻客户端和服务器之间的同步不一致性，提高数据传输的鲁棒性，便于作为登录过程一部分的密码规范，并减少管理开销。 提供了各种头部作为数据流协议的一部分，并且建立了一种版本控制方案，其促进具有不同发布日期和版本的TDS协议的服务器和客户端之间的正确通信。

公开(公告)号：US07548901B2

公开(公告)日：2009-06-16

申请号：US10879326

申请日：2004-06-29

Applicant: Shrinivas Ashwin ,  Christian Kleinerman ,  Eugene Zabokritski ,  Ganapathy Krishnamoorthy ,  Giri Nair

Inventor： Shrinivas Ashwin ,  Christian Kleinerman ,  Eugene Zabokritski ,  Ganapathy Krishnamoorthy ,  Giri Nair

IPC: G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30492 ,  Y10S707/99932 ,  Y10S707/99934

Abstract: A number of members of a user defined type may be designated as delayable members. During an initial fetch of the type, the type may be returned from the database without the delayable members, thereby preserving valuable bandwidth and reducing the amount of time required to perform the initial fetch. Upon request, selected delayable members may be re-fetched from the database at a later time without returning the other members provided during the initial fetch.

Abstract translation: 用户定义类型的多个成员可以被指定为可延迟的成员。 在类型的初始提取期间，可以从数据库返回类型，而不需要可延迟的成员，从而保留有价值的带宽并减少执行初始提取所需的时间量。 根据请求，可以在稍后时间从数据库重新获取所选择的可延迟成员，而不返回在初始提取期间提供的其他成员。

公开(公告)号：US07437346B2

公开(公告)日：2008-10-14

申请号：US10776664

申请日：2004-02-10

Applicant: Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Jun Fang ,  Ajay Kalhan ,  Christian Kleinerman ,  Stefano Stefani ,  Aleksandras Surna ,  Honggang Zhang

Inventor： Shrinivas Ashwin ,  Jose A. Blakeley ,  Peter Carlin ,  Jun Fang ,  Ajay Kalhan ,  Christian Kleinerman ,  Stefano Stefani ,  Aleksandras Surna ,  Honggang Zhang

IPC: G06F7/00

CPC classification number: G06F17/30504 ,  Y10S707/99931 ,  Y10S707/99936 ,  Y10S707/99943

Abstract: Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) which are an internal representation of a large value. BHs are immutable and stateless references to a large data object. The structure of a BH contains enough information to return an ILockBytes interface in order to provide access to the corresponding large data block, and a BH can also return information regarding its own lifetime description. A BH can be completely described using (a) a pointer to the beginning of BH data and (b) the byte-length of the BH.

Abstract translation: 本发明的各种实施例直接利用作为大值的内部表示的Blob句柄（BH）。 BH是不可变的和无状态的引用大型数据对象。 BH的结构包含足够的信息来返回ILockBytes接口，以便提供对相应的大数据块的访问，并且BH还可以返回关于其自身寿命描述的信息。 可以使用（a）指向BH数据的开始的指针和（b）BH的字节长度来完全描述BH。

公开(公告)号：US07318075B2

公开(公告)日：2008-01-08

申请号：US10773724

申请日：2004-02-06

Applicant: Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

Inventor： Shrinivas Ashwin ,  Christian Kleinerman ,  Ganapathy Subramaniam Krishnamoorthy ,  Joel M. Soderberg

IPC: G06F17/30

CPC classification number: G06F17/3056 ,  Y10S707/99934 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Systems and methodologies are provided as part of a computing environment that implements an enhanced tabular data stream (TDS) protocol. Such enhanced TDS protocol can mitigate synchronization inconsistencies between client and servers, improve robustness of the data transfer, facilitate password specification as part of login procedures, and reduce administration overhead. Various headers are provided as part of the data stream protocol, and a versioning scheme is established that facilitates proper communication between servers and clients having different release dates and versions of the TDS protocol.

Abstract translation: 提供系统和方法作为实现增强的表格数据流（TDS）协议的计算环境的一部分。 这种增强的TDS协议可以减轻客户端和服务器之间的同步不一致性，提高数据传输的鲁棒性，便于作为登录过程一部分的密码规范，并减少管理开销。 提供了各种头部作为数据流协议的一部分，并且建立了一种版本控制方案，其促进具有不同发布日期和版本的TDS协议的服务器和客户端之间的正确通信。

公开(公告)号：US20050289160A1

公开(公告)日：2005-12-29

申请号：US10879326

申请日：2004-06-29

Applicant: Shrinivas Ashwin ,  Christian Kleinerman ,  Eugene Zabokritski ,  Ganapathy Krishnamoorthy ,  Giri Nair

Inventor： Shrinivas Ashwin ,  Christian Kleinerman ,  Eugene Zabokritski ,  Ganapathy Krishnamoorthy ,  Giri Nair

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30471 ,  G06F17/30492 ,  Y10S707/99932 ,  Y10S707/99934

Abstract: A number of members of a user defined type may be designated as delayable members. During an initial fetch of the type, the type may be returned from the database without the delayable members, thereby preserving valuable bandwidth and reducing the amount of time required to perform the initial fetch. Upon request, selected delayable members may be re-fetched from the database at a later time without returning the other members provided during the initial fetch.

Abstract translation: 用户定义类型的多个成员可以被指定为可延迟的成员。 在类型的初始提取期间，可以从数据库返回类型，而不需要可延迟的成员，从而保留有价值的带宽并减少执行初始提取所需的时间量。 根据请求，可以在稍后时间从数据库重新获取所选择的可延迟成员，而不返回在初始提取期间提供的其他成员。

公开(公告)号：US07890508B2

公开(公告)日：2011-02-15

申请号：US11207482

申请日：2005-08-19

Applicant: Robert H. Gerber ,  Balan Sethu Raman ,  James R. Hamilton ,  John F. Ludeman ,  Murali M. Krishna ,  Samuel H. Smith ,  Shrinivas Ashwin

Inventor： Robert H. Gerber ,  Balan Sethu Raman ,  James R. Hamilton ,  John F. Ludeman ,  Murali M. Krishna ,  Samuel H. Smith ,  Shrinivas Ashwin

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30362 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80

Abstract: Mechanisms and techniques for database fragment cloning and management are provided. A database object, such as a table, rowset or index, is divided into fragments. Each fragment is cloned to create cloned fragments, which operationally are substantially identical to one another. One or more of the cloned fragments may be designated as a primary cloned fragment for performing database operations or as a secondary cloned fragment for serving as backup. Updates to each fragment are implemented on the primary cloned fragment and are then propagated from the primary cloned fragment to the corresponding secondary cloned fragments. A cloned fragment can go offline, becoming unavailable to be updated. When the cloned fragment returns online, the cloned fragment is refreshed with data included in the primary cloned fragment. While being refreshed, the cloned fragment may continue to be updated. The cloned fragment is eligible to be designated as a primary cloned fragment when the refreshing process has been completed.

Abstract translation: 提供了数据库片段克隆和管理的机制和技术。 数据库对象（如表，行集或索引）被划分成片段。 克隆每个片段以产生克隆的片段，其在操作上基本上彼此相同。 可以将一个或多个克隆的片段指定为用于执行数据库操作的主要克隆片段或用作备份的辅助克隆片段。 对每个片段的更新在主要克隆片段上实现，然后从主要克隆片段扩增到相应的次级克隆片段。 克隆片段可以脱机，不可更新。 当克隆片段返回联机时，克隆片段将使用包含在主克隆片段中的数据进行刷新。 刷新时，克隆片段可能会继续更新。 当刷新过程完成时，克隆片段有资格被指定为主要的克隆片段。

公开(公告)号：US20070043749A1

公开(公告)日：2007-02-22

申请号：US11207482

申请日：2005-08-19

Applicant: Robert Gerber ,  Balan Raman ,  James Hamilton ,  John Ludeman ,  Murali Krishna ,  Samuel Smith ,  Shrinivas Ashwin

Inventor： Robert Gerber ,  Balan Raman ,  James Hamilton ,  John Ludeman ,  Murali Krishna ,  Samuel Smith ,  Shrinivas Ashwin

IPC: G06F7/00

CPC classification number: G06F17/30362 ,  G06F11/2094 ,  G06F11/2097 ,  G06F2201/80

Abstract: Mechanisms and techniques for database fragment cloning and management are provided. A database object, such as a table, rowset or index, is divided into fragments. Each fragment is cloned to create cloned fragments, which operationally are substantially identical to one another. One or more of the cloned fragments may be designated as a primary cloned fragment for performing database operations or as a secondary cloned fragment for serving as backup. Updates to each fragment are implemented on the primary cloned fragment and are then propagated from the primary cloned fragment to the corresponding secondary cloned fragments. A cloned fragment can go offline, becoming unavailable to be updated. When the cloned fragment returns online, the cloned fragment is refreshed with data included in the primary cloned fragment. While being refreshed, the cloned fragment may continue to be updated. The cloned fragment is eligible to be designated as a primary cloned fragment when the refreshing process has been completed.

Abstract translation: 提供了数据库片段克隆和管理的机制和技术。 数据库对象（如表，行集或索引）被划分成片段。 克隆每个片段以产生克隆的片段，其在操作上基本上彼此相同。 可以将一个或多个克隆的片段指定为用于执行数据库操作的主要克隆片段或用作备份的辅助克隆片段。 对每个片段的更新在主要克隆片段上实现，然后从主要克隆片段扩增到相应的次级克隆片段。 克隆的片段可以脱机，不可更新。 当克隆片段返回联机时，克隆片段将使用包含在主克隆片段中的数据进行刷新。 刷新时，克隆片段可能会继续更新。 当刷新过程完成时，克隆片段有资格被指定为主要的克隆片段。

公开(公告)号：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编程模型的实现。