STATISTICS MANAGEMENT FOR DATABASE QUERYING
    1.
    发明申请
    STATISTICS MANAGEMENT FOR DATABASE QUERYING 有权
    用于数据库查询的统计管理

    公开(公告)号:US20140040235A1

    公开(公告)日:2014-02-06

    申请号:US14044657

    申请日:2013-10-02

    CPC classification number: G06F17/30463 G06F17/30442 G06F17/30477

    Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.

    Abstract translation: 提供了方法和系统来查询数据库。 从支持一个或多个租户的点播数据库获取数据的一个示例性方法包括基于租户的预期利用信息获取模型数据库统计信息,并将该模型数据库统计信息提供给按需数据库。 按需数据库利用模型数据库统计信息生成查询计划,并执行查询计划以从模型数据库统计信息中获取数据。

    Statistics mechanisms in multitenant database environments
    2.
    发明授权
    Statistics mechanisms in multitenant database environments 有权
    多租户数据库环境中的统计机制

    公开(公告)号:US09286343B2

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

    申请号:US13925064

    申请日:2013-06-24

    Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.

    Abstract translation: 多租户数据库环境中的统计机制。 在多租户数据库系统中维护主统计信息文件。 主统计信息文件具有与多租户数据库系统中的多个租户对应的统计信息。 生成多租户数据库系统中选定表的统计信息。 所选择的表对应于多租户数据库系统的选定租户。 主统计信息文件根据所选表格的生成统计信息进行更新。

    Statistics management for database querying
    3.
    发明授权
    Statistics management for database querying 有权
    统计管理数据库查询

    公开(公告)号:US09189521B2

    公开(公告)日:2015-11-17

    申请号:US14044657

    申请日:2013-10-02

    CPC classification number: G06F17/30463 G06F17/30442 G06F17/30477

    Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.

    Abstract translation: 提供了方法和系统来查询数据库。 从支持一个或多个租户的点播数据库获取数据的一个示例性方法包括基于租户的预期利用信息获取模型数据库统计信息,并将该模型数据库统计信息提供给按需数据库。 按需数据库利用模型数据库统计信息生成查询计划,并执行查询计划以从模型数据库统计信息中获取数据。

    Techniques for optimization of inner queries

    公开(公告)号:US10152511B2

    公开(公告)日:2018-12-11

    申请号:US14028316

    申请日:2013-09-16

    Abstract: In an on demand database system, a query engine applies a custom index for inner queries. The query engine receives a query and determines that the query has an inner query nested within the primary query. The query engine identifies that a custom index exists for a client associated with the query, and applies the custom index to filter results for the query. The custom index includes a subset of information of a table that includes accounts for multiple different clients. By using the custom index, the query engine can filter the results more efficiently that if solely using the multiple client table.

    STATISTICS MECHANISMS IN MULTITENANT DATABASE ENVIRONMENTS
    7.
    发明申请
    STATISTICS MECHANISMS IN MULTITENANT DATABASE ENVIRONMENTS 有权
    多媒体数据库环境中的统计机制

    公开(公告)号:US20160162536A1

    公开(公告)日:2016-06-09

    申请号:US15046338

    申请日:2016-02-17

    Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.

    Abstract translation: 多租户数据库环境中的统计机制。 在多租户数据库系统中维护主统计信息文件。 主统计信息文件具有与多租户数据库系统中的多个租户对应的统计信息。 生成多租户数据库系统中选定表的统计信息。 所选择的表对应于多租户数据库系统的选定租户。 主统计信息文件根据所选表格的生成统计信息进行更新。

Patent Agency Ranking