会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 43. 发明申请
    • IMPLEMENTING COMPOSITE CUSTOM INDICES IN A MULTI-TENANT DATABASE
    • 在多重数据库中实现复合自定义指标
    • US20110246449A1
    • 2011-10-06
    • US12897265
    • 2010-10-04
    • Jesse CollinsCraig Weissman
    • Jesse CollinsCraig Weissman
    • G06F17/30
    • G06F17/30463G06F17/30442G06F17/30536
    • Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving, at a network interface of a server computer in a multi-tenant database system, an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes a first two-column custom index. Metadata associated with the data accessible by the tenant is retrieved, using a processor of the server computer, wherein at least a portion of the data accessible by the tenant is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined, using the processor, wherein determining comprises analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. Finally, using the processor, an improved query is generated using the query syntax, wherein the improved query is based at least in part upon the original query and data stored in the first two-column custom index.
    • 提供了多租户数据库系统查询优化的方法和系统。 一些实施例包括在多租户数据库系统中的服务器计算机的网络接口处接收由与租户相关联的用户发送到多承租人数据库系统的原始查询,其中原始查询与可访问的数据相关联 所述租户,并且其中所述多租户数据库系统包括第一两列自定义索引。 使用服务器计算机的处理器检索与租户可访问的数据相关联的元数据,其中租户可访问的数据的至少一部分被存储在多租户数据库系统内的公用表中。 使用所述处理器来确定租户选择性查询语法,其中确定包括分析从关于租户的信息生成的元数据中的至少一个或由租户可访问的数据生成的元数据。 最后,使用处理器,使用查询语法生成改进的查询,其中改进的查询至少部分地基于存储在前两列自定义索引中的原始查询和数据。
    • 45. 发明申请
    • QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE SYSTEM
    • 多重数据库系统中的QUERY优化
    • US20100191719A1
    • 2010-07-29
    • US12752098
    • 2010-03-31
    • Craig WeissmanDave MoellenhoffSimon WongPaul Nakada
    • Craig WeissmanDave MoellenhoffSimon WongPaul Nakada
    • G06F17/30
    • G06F21/6218G06F17/30442G06F17/30536Y10S707/99932Y10S707/99933Y10S707/99934Y10S707/99935Y10S707/99938Y10S707/99939
    • The present invention provides techniques for managing a multi-tenant database system. In one embodiment the method includes providing access to data stored in a multi-tenant data structure that is implemented by storing data for multiple tenants on a pool of computer servers defining the multi-tenant data structure that having a plurality of data columns and one or more index columns. The one or more index columns define a first data field for a first tenant of the multi-tenant data structure and a second data field for a second tenant of the multi-tenant data structure. The first field indicates a first data type and the second field indicates a second data type, wherein the second data type is different than the first data type. Once created, records having data values in the first and second fields are stored to a single column in the data structure. The single column includes data values having different data types for different tenants in the multi-tenant data structure. Operations are monitored so that one or more requests to access the multi-tenant data structure among are distributing the pool of computer servers to maintain load balancing among the servers of the pool.
    • 本发明提供了用于管理多租户数据库系统的技术。 在一个实施例中,该方法包括提供对存储在多租户数据结构中的数据的访问,该数据通过在定义多租户数据结构的计算机服务器池上存储多个租户的数据来实现,所述多租户数据结构池具有多个数据列, 更多索引列。 所述一个或多个索引列为多承租人数据结构的第一承租人定义第一数据字段,并为多租户数据结构的第二租户定义第二数据字段。 第一字段指示第一数据类型,第二字段指示第二数据类型,其中第二数据类型不同于第一数据类型。 一旦创建,在第一和第二字段中具有数据值的记录被存储到数据结构中的单个列。 单列包括具有不同数据类型的数据值,用于多租户数据结构中的不同租户。 监视操作,以便访问多承租人数据结构的一个或多个请求是分发计算机服务器池以在池的服务器之间维持负载平衡。
    • 50. 发明申请
    • METHODS AND SYSTEMS FOR UPGRADING AND INSTALLING APPLICATION PACKAGES TO AN APPLICATION PLATFORM
    • 用于将应用程序包升级和安装到应用程序平台的方法和系统
    • US20080201701A1
    • 2008-08-21
    • US11866911
    • 2007-10-03
    • Lars HofhanslNathan Jensen-HorneScott HansmaSteven TammCraig Weissman
    • Lars HofhanslNathan Jensen-HorneScott HansmaSteven TammCraig Weissman
    • G06F9/44
    • G06F8/61G06F8/60G06F8/65G06F8/71G06F21/563G06F2221/033
    • Systems and methods for installing and upgrading application packages to an application platform. The systems and methods are particularly useful in an on-demand database service. Application packages may be uploaded to a directory by developing users (developers) for installation by subscribing users (subscribers). Alternatively, a developer may send identification information to a subscribing user to allow that user to access and install that application package created by the developer. Application packages may also be upgraded. If a developer changes the original source package, a subscriber can choose to pull into their organization the change(s) made by the publisher while preserving any data rows the subscriber had created since first importing the package. One or more flags may be set in the package definition to determine whether and to what extent customizations to a package may be made and upgraded by the subscriber and/or developer. A “manageable” field is provided to identify whether customizations to a particular object are subject to upgrade; if the package or an object in the package is marked as managed, a user is allowed to customize the package or the object, and these customizations will not be altered upon upgrading of the package. A “control” field is provided to identify whether an object may be modified by the developer and/or the subscriber. An “immutable” field is provided to identify whether an object can or cannot be altered by anyone.
    • 将应用程序包安装和升级到应用程序平台的系统和方法。 系统和方法在按需数据库服务中特别有用。 应用程序包可以通过开发用户(开发人员)上传到目录,以供订阅用户(订阅者)安装。 或者,开发者可以向订阅用户发送标识信息,以允许该用户访问并安装由开发者创建的该应用包。 应用程序包也可以升级。 如果开发人员改变原始的源码包,订阅者可以选择将发布者所做的更改拉入其组织,同时保留订阅者自从首次导入包以来创建的任何数据行。 可以在包定义中设置一个或多个标志,以确定订阅者和/或开发者是否以及在多大程度上自定义包装可以进行和升级。 提供“可管理”字段以识别对特定对象的定制是否可以升级; 如果软件包或软件包中的对象被标记为托管,则允许用户自定义软件包或对象,并且在升级软件包时不会更改这些定制。 提供“控制”字段以识别对象是否可以被开发者和/或订户修改。 提供了一个“不可变的”字段来标识对象是否可以被任何人改变。