Query optimization in a multi-tenant database system
    92.
    发明授权
    Query optimization in a multi-tenant database system 有权
    多租户数据库系统中的查询优化

    公开(公告)号:US08620954B2

    公开(公告)日:2013-12-31

    申请号:US12762247

    申请日:2010-04-16

    IPC分类号: G06F17/30

    摘要: 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.

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

    Methods and systems for providing fault recovery to side effects occurring during data processing
    93.
    发明授权
    Methods and systems for providing fault recovery to side effects occurring during data processing 有权
    为数据处理过程中发生的副作用提供故障恢复的方法和系统

    公开(公告)号:US08548952B2

    公开(公告)日:2013-10-01

    申请号:US13415403

    申请日:2012-03-08

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F11/1474

    摘要: Embodiments may recover from faults by forming a new set of rows by removing rows associated with faulting save operations and repeating the saving and forming operations using the new set of rows until a set of rows that can be saved from the known start state without fault is determined. When the subset of successful rows is found, embodiments are able to provide assurance that no side effects (i.e., code or operations triggered by saving of a data to a particular location) have been executed on behalf of any of the failed rows (side effects from custom PL/SOQL code included) by deferring execution of triggers until an entire set of rows can be saved and committed.

    摘要翻译: 实施例可以通过移除与故障保存操作相关联的行来形成新的一组行来重新从故障中恢复,并且使用新的一组行重复保存和形成操作,直到可以从已知的没有故障的起始状态保存的一组行为 决心。 当发现成功行的子集时,实施例能够提供对代表任何失败的行(副作用)执行副作用(即,通过保存数据到特定位置触发的代码或操作)的保证 从定制PL / SOQL代码)通过延迟触发器的执行,直到可以保存和提交整个行的整个行。

    SYSTEM AND METHODS OF IMPROVING A MULTI-TENANT DATABASE QUERY USING CONTEXTUAL KNOWLEDGE ABOUT NON-HOMOGENEOUSLY DISTRIBUTED TENANT DATA
    94.
    发明申请
    SYSTEM AND METHODS OF IMPROVING A MULTI-TENANT DATABASE QUERY USING CONTEXTUAL KNOWLEDGE ABOUT NON-HOMOGENEOUSLY DISTRIBUTED TENANT DATA 审中-公开
    使用关于非均质分布式数据的相关知识来改进多重数据库查询的系统和方法

    公开(公告)号:US20130060792A1

    公开(公告)日:2013-03-07

    申请号:US13620067

    申请日:2012-09-14

    IPC分类号: G06F17/30

    摘要: In embodiments, methods and systems for improving a query in a database system are provided. These method and system embodiments can enable greater contextual knowledge about the types and use of data in tables underlying a relational database to be employed to improve query efficiency. By employing contextual information, embodiments can provide improved queries and/or make recommendations to a query optimizer of a database system to improve its operation based upon knowledge of the data and/or application gathered. Embodiments can be useful in improving query performance in multi-tenant database systems.

    摘要翻译: 在实施例中,提供了用于改进数据库系统中的查询的方法和系统。 这些方法和系统实施例可以实现关于要用于提高查询效率的关系数据库下表中的数据的类型和使用的更大的上下文知识。 通过使用上下文信息,实施例可以提供改进的查询和/或向数据库系统的查询优化器提出建议,以便基于所收集的数据和/或应用的知识来改进其操作。 实施例可以用于改善多租户数据库系统中的查询性能。

    CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM
    95.
    发明申请
    CUSTOM ENTITIES AND FIELDS IN A MULTI-TENANT DATABASE SYSTEM 有权
    多重数据库系统中的自定义实体和字段

    公开(公告)号:US20120310989A1

    公开(公告)日:2012-12-06

    申请号:US13589020

    申请日:2012-08-17

    IPC分类号: G06F17/30

    摘要: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant,

    摘要翻译: 用于托管变量模式数据的系统和方法,例如固定物理数据库模式中的动态表和列。 标准对象,如表格,供多租户或多租户数据库系统中的组织使用。 每个组织可以添加或定义自定义字段以包含在标准对象中。 多个租户的自定义字段存储在对象数据结构中的自定义数据列中,并且此单个自定义数据列可能包含每个租户的不同数据类型,

    On-demand database service system, method and computer program product for generating a custom report
    97.
    发明授权
    On-demand database service system, method and computer program product for generating a custom report 有权
    按需数据库服务系统,方法和计算机程序产品,用于生成自定义报告

    公开(公告)号:US08266138B1

    公开(公告)日:2012-09-11

    申请号:US12175997

    申请日:2008-07-18

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30289

    摘要: In accordance with embodiments, there are provided mechanisms and methods for generating a custom report using an on-demand database service. These mechanisms and methods for generating an on-demand database service custom report can enable embodiments to generate reports that reflect a relationship between at least two different objects. The ability of embodiments to provide such additional insight into database contents may lead to more efficient and effective reporting.

    摘要翻译: 根据实施例,提供了使用按需数据库服务来生成定制报告的机制和方法。 用于生成按需数据库服务自定义报告的这些机制和方法可使实施例能够生成反映至少两个不同对象之间的关系的报告。 实施例提供对数据库内容的这种额外洞察的能力可以导致更有效和更有效的报告。

    SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR CREATING AN OBJECT WITHIN A SYSTEM, UTILIZING A TEMPLATE
    100.
    发明申请
    SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR CREATING AN OBJECT WITHIN A SYSTEM, UTILIZING A TEMPLATE 有权
    用于在系统中创建对象的系统,方法和计算机程序产品,使用模板

    公开(公告)号:US20110238707A1

    公开(公告)日:2011-09-29

    申请号:US13072631

    申请日:2011-03-25

    IPC分类号: G06F17/30

    CPC分类号: G06F17/248

    摘要: In accordance with embodiments, there are provided mechanisms and methods for creating an object within a system, utilizing a template. These mechanisms and methods for creating an object within a system, utilizing a template can enable increased efficiency, resource and time savings, more intuitive object creation, etc.

    摘要翻译: 根据实施例,提供了利用模板在系统内创建对象的机制和方法。 利用模板在系统中创建对象的这些机制和方法可以提高效率,资源和时间节省,更直观的对象创建等。