知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

8 records (took 0.014 seconds)

    Background processing to provide automated database query tuning
    1.
    发明授权
    Background processing to provide automated database query tuning 有权

    公开(公告)号：US11232102B2

    公开(公告)日：2022-01-25

    申请号：US15295319

    申请日：2016-10-17

    Applicant: salesforce.com, inc.

    Inventor： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

    IPC: G06F16/2453 ,  G06F16/21

    Abstract: A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.

    TRUNCATING DATA ASSOCIATED WITH OBJECTS IN A MULTI-TENANT DATABASE
    3.
    发明申请
    TRUNCATING DATA ASSOCIATED WITH OBJECTS IN A MULTI-TENANT DATABASE 有权
    与多个数据库中的对象相关的数据传输

    公开(公告)号：US20150254286A1

    公开(公告)日：2015-09-10

    申请号：US14714968

    申请日：2015-05-18

    Applicant: salesforce.com, inc.

    Inventor： Arup Dutta ,  Simon Wong ,  Dan Soble ,  Nathanael Black ,  Walter Macklem

    IPC: G06F17/30

    CPC classification number: G06F17/30303 ,  G06F17/30117 ,  G06F17/30165 ,  G06F17/30997

    Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

    Abstract translation: 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库，实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象，包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目，包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符，现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作，以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。

    PROTECTED HANDLING OF DATABASE QUERIES
    4.
    发明申请
    PROTECTED HANDLING OF DATABASE QUERIES 审中-公开
    数据库查询的保护处理

    公开(公告)号：US20150127680A1

    公开(公告)日：2015-05-07

    申请号：US14530559

    申请日：2014-10-31

    Applicant: salesforce.com, inc.

    Inventor： Arup Dutta ,  Prem Veeramani ,  Jesse Yarbro Collins

    IPC: G06F17/30 ,  G06F21/62

    CPC classification number: G06F17/30424 ,  G06F21/6218 ,  G06F21/85

    Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.

    Abstract translation: 实施例涉及对数据库查询的保护处理。 用于查询数据库系统视图和表的方法的实施例包括：从用户接收用户查询，所述用户查询被定向到数据库的视图和表格中的一个或两个，其中所述用户不是数据库管理员; 用查询解析器解析所述用户查询以识别所述用户查询的元素，解析所述查询，包括确定所述查询是否满足某些数据库访问准则; 基于用户查询的解析自动生成数据库查询，生成数据库查询，包括生成受数据库访问条件限制的数据库查询; 使用所生成的数据库查询来访问所述视图和所述表中的一个或两个，其中所述访问被限制为只读访问; 并且获得视图和表中的一个或两者的访问结果。

    Truncating data associated with objects in a multi-tenant database
    6.
    发明授权
    Truncating data associated with objects in a multi-tenant database 有权
    截断与多租户数据库中的对象相关联的数据

    公开(公告)号：US09558218B2

    公开(公告)日：2017-01-31

    申请号：US14714968

    申请日：2015-05-18

    Applicant: salesforce.com, inc.

    Inventor： Arup Dutta ,  Simon Wong ,  Dan Soble ,  Nathanael Black ,  Walter Macklem

    IPC: G06F17/30

    CPC classification number: G06F17/30303 ,  G06F17/30117 ,  G06F17/30165 ,  G06F17/30997

    Abstract: An exemplary embodiment of a multi-tenant database system is provided. The system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has database objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has metadata entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.

    Abstract translation: 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库，实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象，包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目，包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符，现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作，以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。

    Protected handling of database queries
    8.
    发明授权
    Protected handling of database queries 有权

    公开(公告)号：US10268721B2

    公开(公告)日：2019-04-23

    申请号：US14530559

    申请日：2014-10-31

    Applicant: salesforce.com, inc.

    Inventor： Arup Dutta ,  Prem Veeramani ,  Jesse Yarbro Collins

    IPC: G06F17/00 ,  G06F17/30 ,  G06F21/62 ,  G06F21/85

    Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.

Patent Agency Ranking