会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 34. 发明申请
    • SYSTEMS, METHODS, AND APPARATUSES FOR IMPLEMENTING DYNAMIC MACROS WITHIN A MULTI-TENANT AWARE STRUCTURED QUERY LANGUAGE
    • US20180218031A1
    • 2018-08-02
    • US15421076
    • 2017-01-31
    • salesforce.com. Inc.
    • Simon WongGary Baker
    • G06F17/30
    • In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing dynamic macros within a multi-tenant aware structured query language operable within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; receiving a database query specifying a dynamic macro function call to be executed at runtime and replaced with a string within a new structured query language statement to be executed against the multi-tenant database system; parsing the database query to identify the dynamic macro function call specified; parsing the database query to identify a functional expression to be evaluated at runtime as passed with the dynamic macro function call specified; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment of the database query received, in which the new structured query language statement includes the string in place of the dynamic macro function call or a functional call executable by the multi-tenant database system at runtime to be resolved to the string by the multi-tenant database during execution of the new structured query language statement; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.
    • 36. 发明授权
    • Truncating data associated with objects in a multi-tenant database
    • 截断与多租户数据库中的对象相关联的数据
    • US09558218B2
    • 2017-01-31
    • US14714968
    • 2015-05-18
    • salesforce.com, inc.
    • Arup DuttaSimon WongDan SobleNathanael BlackWalter Macklem
    • G06F17/30
    • G06F17/30303G06F17/30117G06F17/30165G06F17/30997
    • 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.
    • 提供了多租户数据库系统的示例性实施例。 该系统包括多租户数据库,实体定义表和数据处理引擎。 数据库具有多个租户的数据库对象,包括指定租户的现有对象。 现有对象中的每个条目都有相应的实体标识符。 定义表具有数据库对象的元数据条目,包括现有对象的元数据条目。 该元数据条目具有用于指定承租人的租户标识符,现有对象的实体名称和用于现有对象的旧密钥前缀。 现有对象的每个实体标识符都以旧的密钥前缀开始。 引擎通过更新元数据条目来对现有对象执行数据截断操作,以用新的密钥前缀替换旧的密钥前缀。 这导致由新的密钥前缀和租户标识符标识的更新的对象。
    • 38. 发明授权
    • Testing data silo
    • 测试数据仓
    • US09367431B2
    • 2016-06-14
    • US13627402
    • 2012-09-26
    • Salesforce.com, Inc.
    • Richard UngerSimon Wong
    • G06F7/00G06F17/00G06F17/30G06F11/36
    • G06F11/3672
    • In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for creating a data silo and testing with a data silo including, for example, initiating a test sequence against a production database within the host organization, in which the test sequence specifies: a) new data for insertion into the production database during the test sequence, and b) one or more test queries against the production database during the test sequence; performing a database transaction to insert the new data into the production database without committing the new data to the production database; recording names of one or more objects corresponding to the inserted new data, the one or more objects created as part of the transaction to insert the new data into the production database within a transaction entity object map; modifying the one or more test queries specified by the test sequence to no longer query against the production database by substituting the one or more test queries with references to the names of the one or more objects in operating memory separate from information stored within the production database; and executing the one or more modified test queries. Other related embodiments are disclosed.
    • 根据所公开的实施例,提供了用于创建数据仓库和使用数据仓库进行测试的方法,系统和装置,包括例如针对主机组织内的生产数据库发起测试序列,其中测试序列指定 :a)在测试序列期间插入生产数据库的新数据,以及b)在测试序列期间针对生产数据库的一个或多个测试查询; 执行数据库事务以将新数据插入到生产数据库中,而不将新数据提交给生产数据库; 记录与所插入的新数据相对应的一个或多个对象的名称,所述一个或多个对象被创建为事务的一部分以将新数据插入到事务实体对象映射内的生产数据库中; 修改由测试序列指定的一个或多个测试查询,以不再针对生产数据库查询,替换一个或多个测试查询,引用操作存储器中与存储在生产数据库中的信息分离的操作存储器中的一个或多个对象的名称 ; 并执行一个或多个修改的测试查询。 公开了其他相关实施例。