Connected access control for managed services

    公开(公告)号:US12130905B2

    公开(公告)日:2024-10-29

    申请号:US17301300

    申请日:2021-03-31

    CPC classification number: G06F21/45 G06F16/21 G06F21/44 G06F2221/2141

    Abstract: A system and a method for providing managed services are provided. The system provides a first access control platform and a second access control platform. The first access control platform is configured to receive at least one of a hardware event, an access request event, and a management request event from at least one gateway (e.g., located at a premises). The first access control platform may include at least one of a permissions database (e.g., storing authorized access credentials), a hardware event database (e.g., storing hardware events), and a management database (e.g., storing management request events). The first access control platform may compare received access credentials to the authorized access credentials in the permissions database. The second access control platform may be configured to update at least one of the permissions database (e.g., adding/removing authorized access credentials) and the hardware event database (e.g., adding/removing security devices).

    Management database long-term archiving to a recovery manager

    公开(公告)号:US12124339B2

    公开(公告)日:2024-10-22

    申请号:US18486201

    申请日:2023-10-13

    Inventor: Prasad Nara

    Abstract: A storage manager for an information management system determines whether one or more predetermined conditions have been met for transferring metadata of previously performed backup jobs stored in a first management database. A backup job may correspond to a backup operation of a primary storage device of a first client computing device. In response to a determination that one or more of the predetermined conditions have been met, the storage manager may transfer metadata for a second plurality of backup jobs to a second management database of a recovery manager. The recovery manager may receive a request to restore data to the primary storage device of the first client computing device based on the metadata of the second plurality of backup jobs. A media agent managed by the recovery manager may then restore the requested data to the primary storage device of the first client computing device.

    Problem solving in a database
    5.
    发明授权

    公开(公告)号:US12086135B2

    公开(公告)日:2024-09-10

    申请号:US17477801

    申请日:2021-09-17

    CPC classification number: G06F16/24524 G06F11/1471 G06F11/3409 G06F16/21

    Abstract: A method includes receiving, by a computing device, a Structured Query Language (SQL) query from a user; generating, by the computing device, execution structures from the SQL query; generating, by the computing device, test results by running the SQL query with the execution structures; building, by the computing device, logs which record information of the running of the SQL query; generating, by the computing device, a candidate execution structure using the information from the logs; normalizing, by the computing device, the SQL query using the candidate execution structure; running, by the computing device, the normalized SQL query in a database; and comparing, by the computing device, results of the normalized SQL query to the test results.

    Database Management System for Optimizing Queries via Multiple Optimizers

    公开(公告)号:US20240281438A1

    公开(公告)日:2024-08-22

    申请号:US18645173

    申请日:2024-04-24

    Applicant: Ocient Inc.

    Abstract: A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.

    Resource-efficient row-level security in database systems

    公开(公告)号:US12013961B2

    公开(公告)日:2024-06-18

    申请号:US17747115

    申请日:2022-05-18

    Applicant: SAP SE

    CPC classification number: G06F21/6227 G06F12/1491 G06F16/21 G06F16/284

    Abstract: Methods, systems, and computer-readable storage media for receiving a query request including authorization data and a query, the authorization data indicating a privilege level index, determining a set of row ranges based on the privilege level index and a row range table, the set of row ranges including one or more row ranges having a privilege level associated therewith in the row range table, providing an initial results set including one or more records of a data table that are determined to be responsive, determining a final results set including at least one record of the initial results set, the at least one record being included in the final results set in response to determining that the at least one record is included in a row range of the set of row ranges, and outputting the final results set as at least a portion of a query result.

Patent Agency Ranking