QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM
    11.
    发明申请
    QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM 审中-公开
    多重数据库系统中的QUERY优化

    公开(公告)号:US20130246471A1

    公开(公告)日:2013-09-19

    申请号:US13874422

    申请日:2013-04-30

    Abstract: The present invention provides techniques for managing process space on a multi-tenant database system that features a method that provides to multiple users of two or more organizations, over a network, access to information stored in a database repository shared by the two or more organizations. The database repository implements security protocols to restrict a set of first users to a first sub-portion of the information. The set of first users belongs to one of the two or more organizations. The first sub-portion of the information is different from a second sub-portion accessible by users from another organization. Access of the information by the multiple users is monitored. A first processing space for the set of first users is generated in response to the access of the database repository. The first processing space is distinct from a second processing space for the users from the other organization.

    Abstract translation: 本发明提供了一种用于管理多租户数据库系统上的过程空间的技术,其特征在于,通过网络向两个或更多个组织的多个用户提供对存储在由两个或更多个组织共享的数据库中的信息的访问的方法 。 数据库存储库实现安全协议,以将一组第一用户限制到信息的第一个子部分。 第一批用户属于两个或多个组织之一。 信息的第一子部分不同于来自另一组织的用户可访问的第二子部分。 对多个用户的信息进行监控。 响应于数据库存储库的访问而产生用于第一用户组的第一处理空间。 第一处理空间不同于来自另一个组织的用户的第二处理空间。

    Systems, methods, and apparatuses for implementing a by partition command term within a multi-tenant aware structured query language

    公开(公告)号:US10803062B2

    公开(公告)日:2020-10-13

    申请号:US15421063

    申请日:2017-01-31

    Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY PARTITION command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; maintaining a plurality of tables within the multi-tenant database system to store the customer data, in which one or more of the tables is partitioned into a plurality of table partitions; receiving a database query specifying a command term to restrict a specified table accessed pursuant to execution of the database query by a partition_id parameter; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the specified table within the multi-tenant database system to be restricted by the partition_id parameter; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement accesses only a sub-portion of the specified table corresponding to exactly one table partition of the specified table having a partition ID matching the partition_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

    Systems, methods, and apparatuses for implementing dynamic macros within a multi-tenant aware structured query language

    公开(公告)号:US10776349B2

    公开(公告)日:2020-09-15

    申请号:US15421076

    申请日:2017-01-31

    Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing dynamic macros within a multi-tenant aware structured query language operable within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a dynamic macro function call to be executed at runtime and replaced with a string within a new structured query language statement to be executed against the multi-tenant database system; parsing the database query to identify the dynamic macro function call specified; parsing the database query to identify a functional expression to be evaluated at runtime as passed with the dynamic macro function call specified; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes the string in place of the dynamic macro function call or a functional call executable by the multi-tenant database system at runtime to be resolved to the string by the multi-tenant database during execution of the new structured query language statement; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

    Systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language

    公开(公告)号:US10649987B2

    公开(公告)日:2020-05-12

    申请号:US15421092

    申请日:2017-01-31

    Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a command term to conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation resolves to true and to omit from execution the sub-portion of the database query when the Boolean evaluation resolves to false; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.

Patent Agency Ranking