专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08112414B2 Apparatus and system for reducing locking in materialized query tables 失效
标题翻译：用于减少物化查询表中锁定的装置和系统
公开(公告)号：US08112414B2
公开(公告)日：2012-02-07
申请号：US12200674
申请日：2008-08-28
申请人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
发明人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30362 , G06F17/30377
摘要： Disclosed is an apparatus and system for reducing locking in materialized query tables (MQT) for distributive functions. The apparatus includes an insert module that inserts into an MQT table a child record when a new record is inserted into a base table associated with the MQT. The child record includes values associated with the insert operation. Also included is a delete module that inserts into the MQT a child record that includes measure values that are the negative of the measure values in the base table row that is the subject of the delete operation. An update module inserts two child rows into the MQT, one negating the affected record and the other adding the values of the update operation. Each inserted child row includes a unique identifier that relates the inserted row to a parent row. An execution module generates responses using the values indicated by the cumulative records in a family.
摘要翻译：公开了用于减少用于分配功能的物化查询表（MQT）中的锁定的装置和系统。该装置包括插入模块，当将新记录插入到与MQT相关联的基表中时，插入到MQT表中的子记录。子记录包括与插入操作相关联的值。还包括一个删除模块，将删除模块插入到包含测量值的子记录中，该测量值是作为删除操作主题的基表行中度量值的负值。更新模块将两个子行插入到MQT中，一个对待受影响的记录，另一个添加更新操作的值。每个插入的子行包含将插入的行与父行相关联的唯一标识符。执行模块使用家庭中累积记录指示的值生成响应。

2. 发明申请

US20100057670A1 APPARATUS AND SYSTEM FOR REDUCING LOCKING IN MATERIALIZED QUERY TABLES 失效
标题翻译：用于减少材料查询表中的锁定的装置和系统
公开(公告)号：US20100057670A1
公开(公告)日：2010-03-04
申请号：US12200674
申请日：2008-08-28
申请人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
发明人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30362 , G06F17/30377
摘要： Disclosed is an apparatus and system for reducing locking in materialized query tables (MQT) for distributive functions. The apparatus includes an insert module that inserts into an MQT table a child record when a new record is inserted into a base table associated with the MQT. The child record includes values associated with the insert operation. Also included is a delete module that inserts into the MQT a child record that includes measure values that are the negative of the measure values in the base table row that is the subject of the delete operation. An update module inserts two child rows into the MQT, one negating the affected record and the other adding the values of the update operation. Each inserted child row includes a unique identifier that relates the inserted row to a parent row. An execution module generates responses using the values indicated by the cumulative records in a family.
摘要翻译：公开了用于减少用于分配功能的物化查询表（MQT）中的锁定的装置和系统。该装置包括插入模块，当将新记录插入到与MQT相关联的基表中时，插入到MQT表中的子记录。子记录包括与插入操作相关联的值。还包括一个删除模块，将删除模块插入到包含测量值的子记录中，该测量值是作为删除操作主题的基表行中度量值的负值。更新模块将两个子行插入到MQT中，一个对待受影响的记录，另一个添加更新操作的值。每个插入的子行包含将插入的行与父行相关联的唯一标识符。执行模块使用家庭中累积记录指示的值生成响应。

3. 外观设计

USD633521S1 Portion of a display screen with an icon 有权
公开(公告)号：USD633521S1
公开(公告)日：2011-03-01
申请号：US29352700
申请日：2009-12-23
申请人： Lindsey Renee Barcheck , Howard Kroehl, IV , Jeffrey Neil Braunstein , Jonathan Sloan , Kieran Phelan
设计人： Lindsey Renee Barcheck , Howard Kroehl, IV , Jeffrey Neil Braunstein , Jonathan Sloan , Kieran Phelan

4. 外观设计

USD642197S1 Portion of a display screen with an icon 有权
标题翻译：带有图标的显示屏部分
公开(公告)号：USD642197S1
公开(公告)日：2011-07-26
申请号：US29386360
申请日：2011-02-28
申请人： Lindsey Renee Barcheck , Howard Kroehl, IV , Jeffrey Neil Braunstein , Jonathan Sloan , Kieran Phelan
设计人： Lindsey Renee Barcheck , Howard Kroehl, IV , Jeffrey Neil Braunstein , Jonathan Sloan , Kieran Phelan

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式