公开(公告)号：US20100070528A1

公开(公告)日：2010-03-18

申请号：US12584955

申请日：2009-09-14

申请人： Jesse Collins ,  Andrea Wildt ,  Philippe Debaty ,  Simon Y. Wong ,  Bing Yang

发明人： Jesse Collins ,  Andrea Wildt ,  Philippe Debaty ,  Simon Y. Wong ,  Bing Yang

IPC分类号： G06F7/10 ,  G06F17/30

CPC分类号： G06F17/30017 ,  G06F17/30997 ,  G06Q30/02

摘要： In accordance with embodiments, there are provided mechanisms and methods for providing apportioning of opportunity among campaigns in an on-demand service in a database system. These mechanisms and methods for providing apportioning of opportunity among campaigns can enable embodiments to automatically determine which campaigns are related to an opportunity and provide a filtered set of campaigns that are related to at least one opportunity. The ability of embodiments to apportion opportunity among campaigns can provide marketing information that accurately reflects the true relationship between an opportunity and a plurality of campaigns.

摘要翻译： 根据实施例，提供了用于在数据库系统中的按需服务中的活动之间提供机会分配的机制和方法。 用于在活动之间提供机会分配的这些机制和方法可使实施例能够自动确定哪些活动与机会相关，并且提供与至少一个机会相关的已过滤的一组活动。 实施例在活动之间分配机会的能力可以提供准确地反映机会和多个活动之间的真实关系的营销信息。

公开(公告)号：US08577918B2

公开(公告)日：2013-11-05

申请号：US12584955

申请日：2009-09-14

申请人： Jesse Collins ,  Andrea P. Wildt ,  Philippe Debaty ,  Simon Y. Wong ,  Bing Yang

发明人： Jesse Collins ,  Andrea P. Wildt ,  Philippe Debaty ,  Simon Y. Wong ,  Bing Yang

IPC分类号： G06F17/30

CPC分类号： G06F17/30017 ,  G06F17/30997 ,  G06Q30/02

摘要： In accordance with embodiments, there are provided mechanisms and methods for providing apportioning of opportunity among campaigns in an on-demand service in a database system. These mechanisms and methods for providing apportioning of opportunity among campaigns can enable embodiments to automatically determine which campaigns are related to an opportunity and provide a filtered set of campaigns that are related to at least one opportunity. The ability of embodiments to apportion opportunity among campaigns can provide marketing information that accurately reflects the true relationship between an opportunity and a plurality of campaigns.

摘要翻译： 根据实施例，提供了用于在数据库系统中的按需服务中的活动之间提供机会分配的机制和方法。 用于在活动之间提供机会分配的这些机制和方法可使实施例能够自动确定哪些活动与机会相关，并且提供与至少一个机会相关的已过滤的一组活动。 实施例在活动之间分配机会的能力可以提供准确地反映机会和多个活动之间的真实关系的营销信息。

公开(公告)号：US20110289091A1

公开(公告)日：2011-11-24

申请号：US12897276

申请日：2010-10-04

申请人： Jesse Collins ,  Simon Y. Wong ,  Jaikumar Bathija ,  John F. O'Brien

发明人： Jesse Collins ,  Simon Y. Wong ,  Jaikumar Bathija ,  John F. O'Brien

IPC分类号： G06F17/30

CPC分类号： G06Q10/10 ,  G06F16/2228

摘要： In accordance with embodiments, there are provided methods and systems for providing multiple column custom indexes in a multi-tenant database environment. A method embodiment provides defining a multi-tenant data structure having a plurality of data columns data fields and a plurality of rows for each of multiple tenants, each row including a data column for a tenant identifier, defining a first data field for a tenant, the first data field having a first data type, defining a second data field for the tenant, the second field having a second data type, and defining an index table including a tenant identifier for the tenant, a copy of data from the first data field and the second data field, and a key to the corresponding rows of the multi-tenant data structure.

摘要翻译： 根据实施例，提供了用于在多租户数据库环境中提供多个列自定义索引的方法和系统。 方法实施例提供了一种多租户数据结构，其具有多个数据列数据字段和多个租户中的每一个的多个行，每行包括为租户定义第一数据字段的租户标识符的数据列， 所述第一数据字段具有第一数据类型，为所述租户定义第二数据字段，所述第二字段具有第二数据类型，并且定义包括所述租户的租户标识符的索引表，来自所述第一数据字段的数据副本 和第二数据字段，以及多租户数据结构的相应行的密钥。

公开(公告)号：US10417611B2

公开(公告)日：2019-09-17

申请号：US12897276

申请日：2010-10-04

申请人： Jesse Collins ,  Simon Y Wong ,  Jaikumar Bathija ,  John F O'Brien

发明人： Jesse Collins ,  Simon Y Wong ,  Jaikumar Bathija ,  John F O'Brien

IPC分类号： G06F7/00 ,  G06Q10/10 ,  G06F16/22

摘要： In accordance with embodiments, there are provided methods and systems for providing multiple column custom indexes in a multi-tenant database environment. A method embodiment provides defining a multi-tenant data structure having a plurality of data columns data fields and a plurality of rows for each of multiple tenants, each row including a data column for a tenant identifier, defining a first data field for a tenant, the first data field having a first data type, defining a second data field for the tenant, the second field having a second data type, and defining an index table including a tenant identifier for the tenant, a copy of data from the first data field and the second data field, and a key to the corresponding rows of the multi-tenant data structure.

公开(公告)号：US08402045B2

公开(公告)日：2013-03-19

申请号：US13363305

申请日：2012-01-31

申请人： Mary Scotton ,  Walter Macklem ,  Eric Bezar ,  Jesse Collins

发明人： Mary Scotton ,  Walter Macklem ,  Eric Bezar ,  Jesse Collins

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30398 ,  G06F17/30554

摘要： In accordance with embodiments, there are provided mechanisms and methods for storing a formula having first and second object fields. These mechanisms and methods for storing a formula having first and second object fields can allow access to data from related object types other than the object type being currently accessed. The ability of embodiments to provide such access may allow access to additional contents of a database for performing validations, calculations, etc.

摘要翻译： 根据实施例，提供了用于存储具有第一和第二对象字段的公式的机制和方法。 用于存储具有第一和第二对象字段的公式的这些机制和方法可以允许访问除当前访问的对象类型之外的相关对象类型的数据。 实施例提供这种访问的能力可以允许访问用于执行验证，计算等的数据库的附加内容。

公开(公告)号：US08244714B1

公开(公告)日：2012-08-14

申请号：US12358027

申请日：2009-01-22

申请人： Jesse Collins ,  Thomas Kim ,  Thomas Tobin ,  Simon Wong

发明人： Jesse Collins ,  Thomas Kim ,  Thomas Tobin ,  Simon Wong

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30522

摘要： In accordance with embodiments, there are provided mechanisms and methods for generating a custom report using outer joins in the context of 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.

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

公开(公告)号：US20110320435A1

公开(公告)日：2011-12-29

申请号：US13167498

申请日：2011-06-23

申请人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

发明人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30442 ,  G06F17/30536

摘要： In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.

摘要翻译： 在一些实施例中，提供了一种用于调整多承租人数据库系统的查询的计算机实现的方法。 处理器检索与存储在多租户数据库系统中的一个或多个服务器上的数据相关联的实际统计信息。 数据可以与多租户数据库系统的一个或多个租户相关联。 选择实际统计的子集，其中实际统计的子集与具有针对优化的数据特征的租户相关。 处理器根据实际统计的子集确定合成统计。 在多租户数据库系统处接收原始查询，其中原始查询根据与具有针对优化的数据特征的租户相关联的数据进行操作。 处理器根据原始查询和综合统计信息确定最优查询计划。 最后，处理器根据最优查询计划执行原始查询。

公开(公告)号：US10108648B2

公开(公告)日：2018-10-23

申请号：US13549306

申请日：2012-07-13

申请人： Chirag Rajan ,  Arup Dutta ,  John O'Brien ,  Jaikumar Bathija ,  Greg Salmon ,  Dan Soble ,  RamaLinga R. Penmetsa ,  Hoon Kim ,  Yanan Jiang ,  Karthik Rajan ,  Jesse Collins

发明人： Chirag Rajan ,  Arup Dutta ,  John O'Brien ,  Jaikumar Bathija ,  Greg Salmon ,  Dan Soble ,  RamaLinga R. Penmetsa ,  Hoon Kim ,  Yanan Jiang ,  Karthik Rajan ,  Jesse Collins

IPC分类号： G06F17/30

摘要： Methods and systems are described for creating a custom index in a multi-tenant database environment. In one embodiment, a method includes obtaining query for a multi-tenant database that is recommended as a candidate for creating an additional filter, evaluating the query against criteria to determine whether to select the query for creating the additional filter, and creating the additional filter for the query, if the query is selected.

公开(公告)号：US20140012817A1

公开(公告)日：2014-01-09

申请号：US13925064

申请日：2013-06-24

申请人： Hoon Kim ,  Jesse Collins ,  Chirag Rajan

发明人： Hoon Kim ,  Jesse Collins ,  Chirag Rajan

IPC分类号： G06F17/30

CPC分类号： G06F17/30371 ,  G06F17/30115 ,  G06F17/30327 ,  G06F17/30339 ,  G06F17/30598

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

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

公开(公告)号：US08577870B2

公开(公告)日：2013-11-05

申请号：US13525124

申请日：2012-06-15

申请人： Chirag Rajan ,  Jesse Collins ,  Seung-Yeoul Yang ,  Hoon Kim

发明人： Chirag Rajan ,  Jesse Collins ,  Seung-Yeoul Yang ,  Hoon Kim

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30442 ,  G06F17/30477

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