Microsoft Technology Licensing, LLC

Jun Fang

Pradeep Madhavarapu

Alexandru C Chirica

Peter Alan Carlin

Srini Acharya

Jose A Blakeley

Rohan Kumar

Michael Warmington

Maciej Plaza

Cristian Diaconu

Ramachandran Venkatesh

Beysim Sezgin

Srinivasmurthy P Acharya

Balaji Rathakrishnan

Vaibhav Kamra

Priyank Porwal

Anders Hejlsberg

Giovanni Moises Della-Libera

Luca Bolognese

Mark A Boulter

Omri Gazitt

Blaine J Dockter

Mark P Ashton

Stefano Stefani

Erik B Christensen

Gopala Krishna R Kakivaya

Yan Valerie Leshinsky

Christopher Wellington Brumme

Stephen James Millet

Nikhil Kothari

Michael M Magruder

Raja Krishnaswamy

David Bau

Brian LaMacchia

Gregory Darrell Fee

Lance Olson

Scott David Guthrie

Henry L Sanders

Ajay Kalhan

David S Ebbo

Julie D Bennett

Travis Muhlestein

Sean Edwin Trowbridge

James S Miller

Jonathan C Hawkins

Krzysztof J Cwalina

Seth Mitchell Demsey

Brian M Grunkemeyer

Stefan Harrington Pharies

Shawn Patrick Burke

Christopher L Anderson

Loren Kohnfelder

Aleksandras Surna

Keith W Ballinger

Yung-Shin Lin

Brian Keith Pepin

Mark T Anders

Anthony J Moore

Erik B Olson

Yann Christensen

Jeffrey M Cooperstein

Fabio A Yeon

Susan M Warren

James H Hogg

Manu Vasandani

Craig T Sinclair

Adam Wade Smith

Robert Michael Howard

Corina Eva Feuerstein

Nicholas M Kramer

Shajan Dasan

Christian Kleinerman

David S Mortenson

Dax H Hawkins

Caleb L Doise

Alan Geoffrey Boshier

Manish S Prabhu

Radu Rares Palanca

Chad W Royal

John I McConnell

Tarun Anand

Suzanne Maurine Cook

Mark W Fussell

Joseph L Roxe

Ramasamy Krishnaswamy

Hany E Ramadan

Jesus Ruiz-Scougall

Sreeram Nivarthi

Joe Dennis Long

Jayanth V Rajan

Daniel Takacs

Shrinivas Ashwin

Nithyalakshmi Sampathkumar

Yixue Zhu

Neetu Rajpal

Daniel Dedu-Constantin

Patrick Eugene O'Neil

Elizabeth Jean O'Neil

William A Adams

Subhag P Oak

A method for managing a binary object in a database system is provided. The method may include receiving a request to store the binary object and determining if a size of the binary object is above a first threshold. If the size is less than the first threshold, the method may include storing the binary object in a database of the database system using a database communication protocol. If the size is above the first threshold, the method may include determining if the size is above a second threshold. To this end, if the size is less than the second threshold, the method may include storing the binary object in a file system of the database system using the database communication protocol. Furthermore, if the size is above the second threshold, the method may include storing the binary object in the file system using a file system communication protocol.

Managing a binary object in a database system

High availability and disaster recovery can be achieved within a database management system by detecting which parts of a file have changed and sending the changed parts to secondary servers, without sending the entire file that has experienced the changes. A log cracker reads data from a transaction log that stores records from a database and a separately maintained file system. The log cracker sends mirror commands with some of the transaction log data to the file system to initiate mirroring of the data from the file system to secondary servers. The log data is then subsequently sent to the secondary servers as well, to enable identification of changed data without having to transfer the entire file that has been changed.

Mirroring file data

A method for mirroring one or more data changes from a first database server to one or more second database servers. The method includes intercepting one or more operations that make one or more changes to one or more data on the first database server. After intercepting these operations, the method merges the operations into one or more chunks, adds one or more log records having the chunks into a database log. The database log includes one or more database log blocks. The method then writes the database log blocks.

Mirroring data changes in a database system

The present invention extends to methods, systems, and computer program products for mirroring file data. Generally, high availability and disaster recovery ('HADRON') is achieved within a database management system by detecting which parts of a file have changed and sending the changed parts to secondaries. Adjacent or partially overlapping parts of a file can coalesce to form larger chunks of changed data. Coalescing reduces the overall number of chunks that are tracked.

Systems and methods that group atomic scalar values recognized by a database such as columns into sets (e.g., column sets). A grouping component associated with the SQL server creates a logical representation for column groupings, which are accessible by a single I/O and can be co-located (e.g., substantially close or compact) in terms of storage location. Interesting column sets (e.g., non-null) can also be selected for a data representation thereof as a single entity to other applications.

Scalar representation for a logical group of columns in relational databases

A method of searching for objects in a second database using a query from a first database includes receiving a first query from the first database where the first query is generated using a collation associated with the first database or user session or explicitly specified by users, where the first database may be the same as the second database. The first query is rewritten to form a second query which includes a superset of the collation and a residue predicate which includes a predicate from the first query. An index plan is adopted which targets an index associated with the a multiple language collation expressed in the rewritten query. The rewritten query is executed accessing the index and corresponding data that align with the residue predicate. The total number of indexes provided can be much less than the number of indexes needed if all possible collations were individually indexed.

Dataset search using reduced collation set

A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

System and method for providing user defined types in a database system

An application program interface (API) provides a set of functions for application developers who build Web applications on Microsoft Corporation's .NET&#x2122; platform.

Computing system and method for allowing plurality of applications written in different programming languages to communicate and request resources or services via a common language runtime layer

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

Any string in any character set with an arbitrary-leveled weight-based comparison system is transformed into a bitstring in such a way that two transformed strings can be compared byte-by-byte. The resulting bit string has the minimum possible maximum length. The transformed bit strings can be inverted&#x2014;meaning the original string can be recovered from the transformed string.

Compressed normalized character comparison with inversion

Growing community of inventors

Sammamish, WA, United States of America

Jun Fang