公开(公告)号：US11301485B2

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

申请号：US16564516

申请日：2019-09-09

Applicant: salesforce.com, inc.

Inventor： Martin Mario Almaraz ,  Valliappan Annamalai Natarajan ,  Jan Asita Fernando ,  Matthew Davidchuk

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/27

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.

公开(公告)号：US20210073240A1

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

申请号：US16564516

申请日：2019-09-09

Applicant: salesforce.com, inc.

Inventor： Martin Mario Almaraz ,  Valliappan Annamalai Natarajan ,  Jan Asita Fernando ,  Matthew Davidchuk

IPC: G06F16/25 ,  G06F16/27 ,  G06F16/21

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.

公开(公告)号：US11294866B2

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

申请号：US16564581

申请日：2019-09-09

Applicant: salesforce.com, inc.

Inventor： Martin Mario Almaraz ,  Valliappan Annamalai Natarajan

IPC: G06F16/176 ,  G06F16/17 ,  G06F16/25 ,  G06F16/11

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.

公开(公告)号：US20210073184A1

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

申请号：US16564581

申请日：2019-09-09

Applicant: Salesforce.com, Inc.

Inventor： Martin Mario Almaraz ,  Valliappan Annamalai Natarajan

IPC: G06F16/176 ,  G06F16/17 ,  G06F16/11 ,  G06F16/25

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.