-
公开(公告)号: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.
-
公开(公告)号:US11068448B2
公开(公告)日:2021-07-20
申请号:US16241810
申请日:2019-01-07
Applicant: salesforce.com, inc.
Inventor: Jan Asita Fernando , Samarpan Jain , Matthew Davidchuk , Valliappan Annamalai Natarajan , Alexey Syomichev , Cody Marcel , Seshank Kalvala , Sahil Ramrakhyani , Alexandre Hersans
Abstract: A method is provided for processing a query. In some embodiments, the method includes creating a historical schema defining an ordered set of fields based on a current schema of an object and a field modification of the current schema. The method includes inserting, based on the field modification, a new field at an end of the historical schema and archiving records into a second storage device. The method includes receiving a query, which includes a command specifying a subset of fields and which indicates a non-current field. The method includes searching in the second storage device for archive records having a second schema including the subset of fields and the non-current field. The first and second schemas follow the field order in accordance with the historical schema. The method further includes accessing the subset of fields and the non-current field in accordance with the command.
-
公开(公告)号: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.
-
公开(公告)号:US10146915B2
公开(公告)日:2018-12-04
申请号:US15078430
申请日:2016-03-23
Applicant: salesforce.com, inc.
Inventor: Miko Arnab Bose , Robert J. Snell , Mark Francis Movida , Valliappan Annamalai Natarajan , Adam Thielemann Wegel , Matthew Charles Hagenian , Durgesh Singh
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.
-
公开(公告)号:US11960577B2
公开(公告)日:2024-04-16
申请号:US18179579
申请日:2023-03-07
Applicant: salesforce.com, inc.
Inventor: Miko Arnab Bose , Robert J. Snell , Mark Francis Movida , Valliappan Annamalai Natarajan , Adam Thielemann Wegel , Matthew Charles Hagenian , Durgesh Singh
CPC classification number: G06F21/00 , G06F21/6245
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.
-
公开(公告)号:US20230315814A1
公开(公告)日:2023-10-05
申请号:US18179579
申请日:2023-03-07
Applicant: salesforce.com, inc.
Inventor: Miko Arnab Bose , Robert J. Snell , Mark Francis Movida , Valliappan Annamalai Natarajan , Adam Thielemann Wegel , Matthew Charles Hagenian , Durgesh Singh
CPC classification number: G06F21/00 , G06F21/6245
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.
-
17.
公开(公告)号:US20230195799A1
公开(公告)日:2023-06-22
申请号:US17552424
申请日:2021-12-16
Applicant: salesforce.com, inc.
IPC: G06F16/903
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.
-
公开(公告)号:US20230195738A1
公开(公告)日:2023-06-22
申请号:US17552628
申请日:2021-12-16
Applicant: salesforce.com, inc.
Inventor: Venkatesan Chandrasekaran , Valliappan Annamalai Natarajan , Sidarth Srinivas Conjeevaram , Vijayanth Devadhar , Zeyu Zheng
IPC: G06F16/2458 , G06F16/27 , G06F16/25 , G06F11/34
CPC classification number: G06F16/2471 , G06F16/27 , G06F16/256 , G06F11/3409
Abstract: Systems and methods are provided for receiving a request at a database system that includes a primary node and one or more standby nodes. When the request is determined to be a read-only request and the previous transaction has been replicated to the standby node, the request may be transmitted to one of the one or more standby nodes to perform the read-only operation to retrieve data of the request and transmitting the retrieved data. When the request is determined to be a read-only request and the previous transaction has not been replicated to the standby node, the read-only operation is performed to retrieve data of the request from the primary node and transmitting the retrieved data.
-
公开(公告)号:US11301485B2
公开(公告)日:2022-04-12
申请号:US16564516
申请日:2019-09-09
Applicant: salesforce.com, inc.
Inventor: Martin Mario Almaraz , Valliappan Annamalai Natarajan , Jan Asita Fernando , Matthew Davidchuk
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.
-
公开(公告)号:US20210326409A1
公开(公告)日:2021-10-21
申请号:US17313564
申请日:2021-05-06
Applicant: salesforce.com, inc.
Inventor: Miko Arnab Bose , Robert J. Snell , Mark Francis Movida , Valliappan Annamalai Natarajan , Adam Thielemann Wegel , Matthew Charles Hagenian , Durgesh Singh
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.
-
-
-
-
-
-
-
-
-