Database virtual partitioning
    1.
    发明授权

    公开(公告)号:US12086142B2

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

    申请号:US17162815

    申请日:2021-01-29

    Inventor: Simon Y. Wong

    CPC classification number: G06F16/24554 G06F16/24552 G06F16/256 G06F16/288

    Abstract: A database with virtual partitioning. A computer system used to implement the database receives a request for a database operation to be performed on data stored in a portion of the database, where the data has a group of logical partitions (e.g., tenants of a multi-tenant database), and where the portion of the database is not further physically partitioned. The computer system identifies a virtual partitioning scheme for the database operation, the virtual partitioning scheme defining sub-groups of the group of logical partitions. The computer system then performs the database operation for the sub-groups defined by the virtual partitioning scheme. Multiple virtual partitioning schemes can be active at the same time, and virtual partitioning schemes can be created dynamically in some instances.

    Updating a multi-tenant database concurrent with tenant cloning

    公开(公告)号:US11748329B2

    公开(公告)日:2023-09-05

    申请号:US16779321

    申请日:2020-01-31

    CPC classification number: G06F16/2343 G06F11/1451 G06F2201/80

    Abstract: The present disclosure is directed to updating a multi-tenant database concurrent with tenant cloning. In some embodiments, a computer system receives a request to perform an update operation on a multi-tenant database. The update operation includes updating database entries for a plurality of tenants. Responsive to receiving the request, the update operation is initiated. Performing the update operation includes accessing a list identifying database entries awaiting the updating. During the accessing of the list, the update operation holds a lock. When the lock becomes available for acquisition, a clone process is permitted to create, during performance of the update operation, a clone of a tenant's data within the database.

    DATABASE VIRTUAL PARTITIONING
    3.
    发明申请

    公开(公告)号:US20220121667A1

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

    申请号:US17162815

    申请日:2021-01-29

    Inventor: Simon Y. Wong

    Abstract: A database with virtual partitioning. A computer system used to implement the database receives a request for a database operation to be performed on data stored in a portion of the database, where the data has a group of logical partitions (e.g., tenants of a multi-tenant database), and where the portion of the database is not further physically partitioned. The computer system identifies a virtual partitioning scheme for the database operation, the virtual partitioning scheme defining sub-groups of the group of logical partitions. The computer system then performs the database operation for the sub-groups defined by the virtual partitioning scheme. Multiple virtual partitioning schemes can be active at the same time, and virtual partitioning schemes can be created dynamically in some instances.

    System and method for geo-location data type searching in an on demand environment
    4.
    发明授权
    System and method for geo-location data type searching in an on demand environment 有权
    在按需环境中进行地理位置数据类型搜索的系统和方法

    公开(公告)号:US09110959B2

    公开(公告)日:2015-08-18

    申请号:US13843473

    申请日:2013-03-15

    Abstract: Methods and systems are provided for retrieving, from a database containing a list of records, a subset of the list of records located within a user defined distance from a target point, each record in the list of records having a compound geo-location data type including a first data field and a second data field. The method involves generating a circle around the target point; identifying records having a geo-location within the circle; including the identified records in a result set; and presenting the result set to a user on a display screen. The method further includes treating the first data field and the second data field as a single data element.

    Abstract translation: 提供了方法和系统,用于从包含记录列表的数据库检索位于与目标点之间的用户定义距离内的记录列表的子集,记录列表中的每个记录具有复合地理位置数据类型 包括第一数据字段和第二数据字段。 该方法包括围绕目标点产生一个圆; 识别在圆内具有地理位置的记录; 包括结果集中确定的记录; 并在显示屏幕上将结果集呈现给用户。 该方法还包括将第一数据字段和第二数据字段作为单个数据元素进行处理。

    Updating a Multi-Tenant Database Concurrent with Tenant Cloning

    公开(公告)号:US20210240689A1

    公开(公告)日:2021-08-05

    申请号:US16779321

    申请日:2020-01-31

    Abstract: The present disclosure is directed to updating a multi-tenant database concurrent with tenant cloning. In some embodiments, a computer system receives a request to perform an update operation on a multi-tenant database. The update operation includes updating database entries for a plurality of tenants. Responsive to receiving the request, the update operation is initiated. Performing the update operation includes accessing a list identifying database entries awaiting the updating. During the accessing of the list, the update operation holds a lock. When the lock becomes available for acquisition, a clone process is permitted to create, during performance of the update operation, a clone of a tenant's data within the database.

    SYSTEMS, METHODS, AND APPARATUSES FOR IMPLEMENTING CROSS ORGANIZATIONAL DATA SHARING
    7.
    发明申请
    SYSTEMS, METHODS, AND APPARATUSES FOR IMPLEMENTING CROSS ORGANIZATIONAL DATA SHARING 有权
    用于实施跨组织数据共享的系统,方法和装置

    公开(公告)号:US20160063273A1

    公开(公告)日:2016-03-03

    申请号:US14937698

    申请日:2015-11-10

    CPC classification number: G06F21/6218 G06F17/30864 H04L63/0281 H04L63/10

    Abstract: In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for implementing cross organizational data sharing including, for example, means for storing customer organization data in a database of the host organization; allocating at least a sub-set of the customer organization data to be shared as shared data; configuring a hub to expose the shared data to a proxy user and configuring the proxy user at the hub with access rights to the shared data; configuring one or more spokes with access rights to the shared data of the hub via the proxy user; receiving a request from one of the hubs for access to the shared data of the customer organization via the proxy user at the hub; and returning a response to the hub having made the request. Other related embodiments are disclosed.

    Abstract translation: 根据所公开的实施例,提供了用于实现跨组织数据共享的方法,系统和装置,包括例如用于将客户组织数据存储在主机组织的数据库中的装置; 至少分配要共享的客户组织数据的子集作为共享数据; 配置集线器以将共享数据公开给代理用户,并在集线器上配置代理用户对共享数据的访问权限; 经由所述代理用户配置具有对所述集线器的所述共享数据的访问权限的一个或多个轮辐; 从所述集线器中的一个接收经由所述集线器上的代理用户访问所述客户组织的所述共享数据的请求; 并向已发出请求的集线器返回响应。 公开了其他相关实施例。

    SYSTEM AND METHOD FOR GEO-LOCATION DATA TYPE SEARCHING IN AN ON DEMAND ENVIRONMENT
    8.
    发明申请
    SYSTEM AND METHOD FOR GEO-LOCATION DATA TYPE SEARCHING IN AN ON DEMAND ENVIRONMENT 有权
    用于在需求环境中进行地理数据类型搜索的系统和方法

    公开(公告)号:US20140032533A1

    公开(公告)日:2014-01-30

    申请号:US13843473

    申请日:2013-03-15

    Abstract: Methods and systems are provided for retrieving, from a database containing a list of records, a subset of the list of records located within a user defined distance from a target point, each record in the list of records having a compound geo-location data type including a first data field and a second data field. The method involves generating a circle around the target point; identifying records having a geo-location within the circle; including the identified records in a result set; and presenting the result set to a user on a display screen. The method further includes treating the first data field and the second data field as a single data element.

    Abstract translation: 提供了方法和系统,用于从包含记录列表的数据库检索位于与目标点之间的用户定义距离内的记录列表的子集,记录列表中的每个记录具有复合地理位置数据类型 包括第一数据字段和第二数据字段。 该方法包括围绕目标点产生一个圆; 识别在圆内具有地理位置的记录; 包括结果集中确定的记录; 并在显示屏幕上将结果集呈现给用户。 该方法还包括将第一数据字段和第二数据字段作为单个数据元素进行处理。

    Systems, methods, and apparatuses for implementing cross-organizational data sharing

    公开(公告)号:US10089488B2

    公开(公告)日:2018-10-02

    申请号:US15585881

    申请日:2017-05-03

    Abstract: In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for implementing cross organizational data sharing including, for example, means for storing customer organization data in a database of the host organization; allocating at least a sub-set of the customer organization data to be shared as shared data; configuring a hub to expose the shared data to a proxy user and configuring the proxy user at the hub with access rights to the shared data; configuring one or more spokes with access rights to the shared data of the hub via the proxy user; receiving a request from one of the hubs for access to the shared data of the customer organization via the proxy user at the hub; and returning a response to the hub having made the request. Other related embodiments are disclosed.

Patent Agency Ranking