-
公开(公告)号:US20240419676A1
公开(公告)日:2024-12-19
申请号:US18820079
申请日:2024-08-29
Applicant: salesforce.com, Inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , Ian Varley
IPC: G06F16/2458 , G06F16/18 , G06F16/20 , G06F16/21 , G06F16/245 , G06F16/25 , G06F16/27 , G06F16/28
Abstract: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.
-
公开(公告)号:US10664487B2
公开(公告)日:2020-05-26
申请号:US16112538
申请日:2018-08-24
Applicant: salesforce.com, inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , James Taylor
IPC: G06F16/00 , G06F16/2458 , G06F16/25 , G06F16/27 , G06F16/245 , G06F16/28 , G06F16/20 , G06F16/21 , G06F16/18
Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.
-
公开(公告)号:US20230084317A1
公开(公告)日:2023-03-16
申请号:US18049117
申请日:2022-10-24
Applicant: salesforce.com, inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , Ian Varley
IPC: G06F16/2458 , G06F16/25 , G06F16/27 , G06F16/245 , G06F16/28 , G06F16/20
Abstract: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.
-
4.
公开(公告)号:US20180365299A1
公开(公告)日:2018-12-20
申请号:US16112538
申请日:2018-08-24
Applicant: salesforce.com, inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , James Taylor
IPC: G06F17/30
Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.
-
公开(公告)号:US20240411769A1
公开(公告)日:2024-12-12
申请号:US18753970
申请日:2024-06-25
Applicant: Salesforce.com, Inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , Ian Varley
IPC: G06F16/2458 , G06F16/18 , G06F16/20 , G06F16/21 , G06F16/245 , G06F16/25 , G06F16/27 , G06F16/28
Abstract: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.
-
公开(公告)号:US11615105B2
公开(公告)日:2023-03-28
申请号:US16442409
申请日:2019-06-14
Applicant: salesforce.com, inc.
Inventor: Eli Levine , Jonathan Bruce
IPC: G06F16/00 , G06F16/2458 , G06F16/25 , G06F16/27 , G06F16/245 , G06F16/28 , G06F16/20 , G06F16/21 , G06F16/18
Abstract: Techniques and systems for completing a database query. A time to complete a synchronous query in response to receiving an original database query is estimated by a database management system provided by one or more computing devices. A synchronous database query corresponding to the original database query is performed with the database management system if the estimated time to complete the synchronous query is less than a pre-selected threshold time. One or more asynchronous queries corresponding to the original database query are performed with the database management system if the estimated time to complete the synchronous query is greater than the pre-selected threshold time. A result, whether from a synchronous query or one or more asynchronous queries, is stored in an object within a non-relational database system.
-
公开(公告)号:US11507589B2
公开(公告)日:2022-11-22
申请号:US16853572
申请日:2020-04-20
Applicant: salesforce.com, inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , Ian Varley
IPC: G06F16/18 , G06F16/20 , G06F16/21 , G06F16/24 , G06F16/25 , G06F16/27 , G06F16/28 , G06F16/2458 , G06F16/245
Abstract: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.
-
公开(公告)号:US20210011911A1
公开(公告)日:2021-01-14
申请号:US16883810
申请日:2020-05-26
Applicant: salesforce.com, inc.
Inventor: Jonathan Bruce , Eli Levine , Simon Toens , James Taylor
IPC: G06F16/2458 , G06F16/25 , G06F16/27 , G06F16/245 , G06F16/28 , G06F16/20
Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.
-
-
-
-
-
-
-