Lazy optimistic concurrency control

    公开(公告)号:US11294866B2

    公开(公告)日:2022-04-05

    申请号:US16564581

    申请日:2019-09-09

    Abstract: Methods, systems, and devices supporting data storage are described. A database system may implement lazy optimistic concurrency control (LOCC). LOCC may support an efficient use of database connections for a data archiving process. The data archiving process may involve a first worker thread at an application server copying data records from a primary database and writing the data records to a secondary database. A second worker thread may operate concurrent to the first worker thread to monitor the primary database for changes (e.g., using a shared database connection), as the primary database may not lock the copied data records during the archiving process. Data records that are altered in the primary database during the archiving process may be logged for error handling by an administrator. The data records that are copied from the primary database and not altered during the archiving process may be deleted from the primary database.

    LAZY OPTIMISTIC CONCURRENCY CONTROL

    公开(公告)号:US20210073184A1

    公开(公告)日:2021-03-11

    申请号:US16564581

    申请日:2019-09-09

    Abstract: Methods, systems, and devices supporting data storage are described. A database system may implement lazy optimistic concurrency control (LOCC). LOCC may support an efficient use of database connections for a data archiving process. The data archiving process may involve a first worker thread at an application server copying data records from a primary database and writing the data records to a secondary database. A second worker thread may operate concurrent to the first worker thread to monitor the primary database for changes (e.g., using a shared database connection), as the primary database may not lock the copied data records during the archiving process. Data records that are altered in the primary database during the archiving process may be logged for error handling by an administrator. The data records that are copied from the primary database and not altered during the archiving process may be deleted from the primary database.

    SYSTEMS AND METHODS OF PROGRAMMATIC CONTROL OF SCALING READ REQUESTS TO A DATABASE SYSTEM

    公开(公告)号:US20230195799A1

    公开(公告)日:2023-06-22

    申请号:US17552424

    申请日:2021-12-16

    CPC classification number: G06F16/90335

    Abstract: System and methods are provided for modifying, at a server that is communicatively coupled to a database system that includes a primary node and one or more standby nodes, a class of an application program to route a request that is a read-only request to the database system to the one or more standby nodes of the database system. The application program may receive an input that executes an operation of the modified class of the application program. A read-only request may be transmitted to the database system for data to complete executing the operation of the modified class. The read-only request may be routed to one of the standby nodes to handle the read-only request for the data. The standby node may transmit the retrieved data to the server for the operation of the modified class to complete the execution of the operation for the application program.

    Offloading data to a cold storage database

    公开(公告)号:US11301485B2

    公开(公告)日:2022-04-12

    申请号:US16564516

    申请日:2019-09-09

    Abstract: Methods, systems, and devices supporting data archiving are described. A device (e.g., an application server) may identify a set of archiving jobs for a first database (e.g., a relational database), where each archiving job indicates a set of data records for archiving. The device may receive a data record of the set of data records from the first database, where the data record is filtered by an abstraction layer (e.g., removing some information from the data record such that the filtered data record corresponds to a user's view of the data record). For example, the filtered data record may include a subset of the total information for the stored data record. The device may transform this received, filtered data record from a first format to a second format supported by a second database. The device may then send the transformed data record to the second database for storage.

    PUBLICATION OF COLLABORATIVE FlLE TO LlBRARY

    公开(公告)号:US20210326409A1

    公开(公告)日:2021-10-21

    申请号:US17313564

    申请日:2021-05-06

    Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for sharing and publishing files. In one aspect, the database system can maintain a user database, a file database and a library. The database system can receive a first request initiated by a first user to share a first file with one or more second users and, responsive to the first request, enable a second set of one or more permissions for each of the second users. The database system also can receive a second request initiated by the first user to publish the first file to the library and, responsive to the second request, publish the first file to the library. The database system additionally can restrict access to the published file based on permissions associated with the library.

Patent Agency Ranking