公开(公告)号：US20220382892A1

公开(公告)日：2022-12-01

申请号：US17401165

申请日：2021-08-12

Applicant: Microsoft Technology Licensing, LLC

Inventor： Yueren WANG ,  Elnata DEGEFA ,  Andreas WOLTER ,  Steven Richard GOTT ,  Nitish GUPTA ,  Raghav KAUSHIK ,  Rakesh KHANDUJA ,  Shafi AHMAD ,  Dilli Dorai Minnal ARUMUGAM ,  Pankaj Prabhakar NAIK ,  Nikolas Christopher OGG

IPC: G06F21/62 ,  G06F12/0875 ,  G06F15/173 ,  G06F16/957

Abstract: Methods for centralized access control for cloud relational database management system resources are performed by systems and devices. The methods utilize a central policy storage, managed externally to database servers, which stores external policies for access to internal database resources at up to fine granularity. Database servers in the processing system each receive external access policies that correspond to users of the system by push or pull operations from the central policy storage, and store the external access policies in a cache of the database servers for databases. For resource access, access conditions are determined via policy engines of database servers based on an external access policy in the cache that corresponds to a user, responsive to a resource access request from a device of the user specifying the internal resource. Data associated with the resource is provided to the user based on the access condition being met.

公开(公告)号：US20250156400A1

公开(公告)日：2025-05-15

申请号：US18428887

申请日：2024-01-31

Applicant: Microsoft Technology Licensing, LLC

Inventor： Noah Amin AL-SHIHABI ,  Panagiotis ANTONOPOULOS ,  Hanumantha Rao KODAVALLA ,  Nikolas Christopher OGG ,  Divyesh Rameshchandra TIKMANI ,  Wonseok KIM ,  Alexander Wai-man SWANSON ,  Rajat JAIN

IPC: G06F16/23 ,  G06F16/2453

Abstract: Relational database systems are disclosed that are enabled to operate with versioned metadata. The relational database system includes a lock manager, a transaction manager and a version aware metadata storage and cache configured to store to store and manage versions of metadata, to determine which of such versions should be visible at any given point in time, and to enable creation of the proper versions of metadata. In an aspect, the transaction manager manages transaction identifiers and their associated start times, abort times and/or commit times. Such data enables determination of transaction visibility, and consequently the metadata version visibility, for any point in time. In an aspect, such metadata versioning support enables snapshot isolation of metadata transactions.

公开(公告)号：US20240241980A1

公开(公告)日：2024-07-18

申请号：US18428402

申请日：2024-01-31

Applicant: Microsoft Technology Licensing, LLC

Inventor： Yueren WANG ,  Elnata DEGEFA ,  Andreas WOLTER ,  Steven Richard GOTT ,  Nitish GUPTA ,  Raghav KAUSHIK ,  Rakesh KHANDUJA ,  Shafi AHMAD ,  Dilli Dorai Minnal ARUMUGAM ,  Pankaj Prabhakar NAIK ,  Nikolas Christopher OGG

IPC: G06F21/62 ,  G06F12/0875 ,  G06F15/173 ,  G06F16/957

CPC classification number: G06F21/6218 ,  G06F12/0875 ,  G06F15/17331 ,  G06F16/9574 ,  G06F2212/45

Abstract: Methods for centralized access control for cloud relational database management system resources are performed by systems and devices. The methods utilize a central policy storage, managed externally to database servers, which stores external policies for access to internal database resources at up to fine granularity. Database servers in the processing system each receive external access policies that correspond to users of the system by push or pull operations from the central policy storage, and store the external access policies in a cache of the database servers for databases. For resource access, access conditions are determined via policy engines of database servers based on an external access policy in the cache that corresponds to a user, responsive to a resource access request from a device of the user specifying the internal resource. Data associated with the resource is provided to the user based on the access condition being met.