Microsoft Technology Licensing, LLC

Clifford T Dibble

Alexandre Olegovich Verbitski

Tanmoy Dutta

Ajay Kalhan

Tomas Talius

Conor J Cunningham

Girish Chander

Santeri Olavi Voutilainen

Ziquan Li

Yixue Zhu

Jeffrey A East

Steven Richard Gott

Embodiments are directed to providing distributed database service upgrades of database server instances in a computer cluster using multiple database server instances and to monitoring and maintaining a distributed database service during upgrade. In an embodiment, each computer system in a computer cluster instantiates at least two different database server instances on each of the nodes in the cluster. The first database server instances are configured to operate using a current distributed database version and the second instances are configured to operate using a new, updated distributed database service version. The computer system receives an indication that the distributed database service is to be upgraded. Then, based on the received indication, the computer system migrates database replicas from the first database server instances to the second database server instances which operate the new, updated service version, substantially without user-visible downtime.

Seamless upgrades in a distributed database system

Provided are systems and methods that facilitate providing permission to entities of a database. A system includes a component that authorizes a principal of a containing entity to grant a permission to that entity, and a component that grants the permission to the containing entity, the grantee of the permission inherits a set of permissions to one or more entities contained by the containing entity. When a permission is granted to a parent in a hierarchy of a relational database, the permission is inherited by the child nodes. Also provided is a method for transferring ownership of entities in a relational database. The method includes a two-part handshake that can be audited to avoid repudiation issues.

Specification of a hierarchical authorization model for a DBMS&#x2014;SQL language extensions

Growing community of inventors

Bellevue, WA, United States of America

Clifford T Dibble