Microsoft Technology Licensing, LLC

Shrinivas Ashwin

Christian Kleinerman

Ganapathy Subramaniam Krishnamoorthy

Joel Mathew Soderberg

Jose A Blakeley

Peter Alan Carlin

Stefano Stefani

James Robert Hamilton

Balan Sethu Raman

Ajay Kalhan

Alazel Acheson

Aleksandras Surna

Jun Fang

Robert H Gerber

Erik Ismert

John F Ludeman

Samuel H Smith

Murali M Krishna

Eugene Zabokritski

Giri Nair

Honggang Zhang

Girkumar Nair

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.

Enhanced tabular data stream protocol

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.

Systems and methods for a database engine in-process data provider

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.

Database fragment cloning and management

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.

System and method for delayed fetching of designated members of a user defined type

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.

Systems and methods for a large object infrastructure in a database system

Growing community of inventors

Sammamish, WA, United States of America

Shrinivas Ashwin