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

1. 发明授权

US09483525B2 Reducing update conflicts when maintaining views 有权
标题翻译：维护视图时减少更新冲突
公开(公告)号：US09483525B2
公开(公告)日：2016-11-01
申请号：US11796865
申请日：2007-04-30
申请人： Tengiz Kharatishvili , Wei Xiao , Stefano Stefani
发明人： Tengiz Kharatishvili , Wei Xiao , Stefano Stefani
IPC分类号： G06F17/30
CPC分类号： G06F17/30377 , G06F17/30339 , G06F17/30371 , G06F17/30457 , G06F17/30477
摘要： Aspects of the subject matter described herein relate to reducing update conflicts when maintaining views. In aspects, a transaction in snapshot isolation may update a materialized view. Instead of being able to view the update within the transaction, the update is hidden to prevent the transaction from obtaining inconsistent data. When a transaction is not supposed to see an update to a materialized view that occurs within the transaction, additional information associated with the materialized view may indicate this. When a query of the materialized view is made within the transaction, the query engine may use the additional information to exclude data from the update in the result.
摘要翻译：本文描述的主题的方面涉及在维护视图时减少更新冲突。在方面，快照隔离中的事务可能会更新物化视图。而不是能够在事务中查看更新，所以更新被隐藏，以防止事务获得不一致的数据。当事务不应该看到事务中发生的实例化视图的更新时，与实例化视图相关联的附加信息可能指示这一点。当在事务中进行物化视图的查询时，查询引擎可以使用附加信息来从结果中的更新中排除数据。

2. 发明申请

US20080270489A1 Reducing update conflicts when maintaining views 有权
标题翻译：维护视图时减少更新冲突
公开(公告)号：US20080270489A1
公开(公告)日：2008-10-30
申请号：US11796865
申请日：2007-04-30
申请人： Tengiz Kharatishvili , Wei Xiao , Stefano Stefani
发明人： Tengiz Kharatishvili , Wei Xiao , Stefano Stefani
IPC分类号： G06F17/30
CPC分类号： G06F17/30377 , G06F17/30339 , G06F17/30371 , G06F17/30457 , G06F17/30477
摘要： Aspects of the subject matter described herein relate to reducing update conflicts when maintaining views. In aspects, a transaction in snapshot isolation may update a materialized view. Instead of being able to view the update within the transaction, the update is hidden to prevent the transaction from obtaining inconsistent data. When a transaction is not supposed to see an update to a materialized view that occurs within the transaction, additional information associated with the materialized view may indicate this. When a query of the materialized view is made within the transaction, the query engine may use the additional information to exclude data from the update in the result.
摘要翻译：本文描述的主题的方面涉及在维护视图时减少更新冲突。在方面，快照隔离中的事务可能会更新物化视图。而不是能够在事务中查看更新，所以更新被隐藏，以防止事务获得不一致的数据。当事务不应该看到事务中发生的实例化视图的更新时，与实例化视图相关联的附加信息可能指示这一点。当在事务中进行物化视图的查询时，查询引擎可以使用附加信息来从结果中的更新中排除数据。

3. 发明授权

US07653665B1 Systems and methods for avoiding database anomalies when maintaining constraints and indexes in presence of snapshot isolation 有权
标题翻译：在存在快照隔离的情况下维护约束和索引时避免数据库异常的系统和方法
公开(公告)号：US07653665B1
公开(公告)日：2010-01-26
申请号：US10940891
申请日：2004-09-13
申请人： Stefano Stefani , Wei Xiao
发明人： Stefano Stefani , Wei Xiao
IPC分类号： G06F12/00
CPC分类号： G06F17/30362 , G06F17/30371
摘要： A system and method avoids anomalies in presence of data manipulation language (DML) plans maintaining dependent objects and snapshot isolation. An anomaly due to using a snapshot isolation level within the transaction is detected within a database transaction and the transaction is aborted based upon that detection. Involved in making the anomaly detection is determining whether a view of particular data accessed during the transaction under a snapshot isolation view to ensure read consistency differs from a view of the data under another isolation level, such as the read committed isolation level. Then a detection is made that an anomaly may occur if it is determined that the view of the data accessed during the transaction under the snapshot isolation differs from the view of the data under the other isolation level. Such anomaly avoidance prevents an indexed view being maintained nor a referential integrity constraint validated based on incorrect data.
摘要翻译：一种系统和方法可以避免在存在数据操作语言（DML）计划的情况下维护依赖对象和快照隔离。在数据库事务中检测到由于在事务中使用快照隔离级别引起的异常，并且基于该检测中止事务。涉及使异常检测是确定在快照隔离视图下的事务期间访问的特定数据的视图，以确保读取一致性与另一个隔离级别（例如读提交的隔离级别）下的数据视图不同。然后，如果确定在快照隔离期间的事务期间访问的数据的视图与另一隔离级别下的数据的视图不同，则检测到可能发生异常。这种异常避免会阻止索引视图被维护，也不会根据不正确的数据验证引用完整性约束。

4. 发明授权

US09052831B1 System and method for performing live partitioning in a data store 有权
标题翻译：在数据存储中执行实时分区的系统和方法
公开(公告)号：US09052831B1
公开(公告)日：2015-06-09
申请号：US13174295
申请日：2011-06-30
申请人： Stefano Stefani , Timothy Andrew Rath , Chiranjeeb Buragahain , Yan V. Leshinsky , David A. Lutz , Jakub Kulesza , Wei Xiao , Jai Vasanth
发明人： Stefano Stefani , Timothy Andrew Rath , Chiranjeeb Buragahain , Yan V. Leshinsky , David A. Lutz , Jakub Kulesza , Wei Xiao , Jai Vasanth
IPC分类号： G06F12/06 , G06F3/06
CPC分类号： G06F3/0619 , G06F3/0644 , G06F3/065 , G06F3/067 , G06F17/30584
摘要： A system that implements a scalable data storage service may maintain tables in a data store on behalf of storage service clients. The service may maintain table data in multiple replicas of partitions that are stored on respective computing nodes in the system. In response to detecting an anomaly in the system, detecting a change in data volume on a partition or service request traffic directed to a partition, or receiving a service request from a client to split a partition, the data storage service may create additional copies of a partition replica using a physical copy mechanism. The data storage service may issue a split command defined in an API for the data store to divide the original and additional replicas into multiple replica groups, and to configure each replica group to maintain a respective portion of the table data that was stored in the partition before the split.
摘要翻译：实现可扩展数据存储服务的系统可以代表存储服务客户端来维护数据存储中的表。该服务可以在存储在系统中的相应计算节点上的分区的多个副本中维护表数据。响应于检测到系统中的异常，检测指向分区的分区或服务请求流量上的数据量的变化，或者从客户端接收分割分区的服务请求，数据存储服务可以创建附加副本使用物理复制机制的分区副本。数据存储服务可以发布在数据存储的API中定义的分割命令，以将原始和附加副本划分为多个副本组，并配置每个副本组以维护存储在分区中的表数据的相应部分分裂之前。

5. 发明授权

US08732517B1 System and method for performing replica copying using a physical copy mechanism 有权
标题翻译：使用物理复制机制执行副本复制的系统和方法
公开(公告)号：US08732517B1
公开(公告)日：2014-05-20
申请号：US13174275
申请日：2011-06-30
申请人： Stefano Stefani , Timothy Andrew Rath , Jakub Kulesza , Wei Xiao
发明人： Stefano Stefani , Timothy Andrew Rath , Jakub Kulesza , Wei Xiao
IPC分类号： G06F11/00
CPC分类号： G06F17/30584 , G06F11/1471 , G06F11/2023 , G06F11/2094
摘要： A system that implements a data storage service may maintain tables in a data store on behalf of clients. The service may maintain table data in multiple replicas of partitions of the data that are stored on respective computing nodes in the system. In response to detecting a failure or fault condition, or receiving a service request from a client to move or copy a partition replica, the data store may copy a partition replica to another computing node using a physical copy mechanism. The physical copy mechanism may copy table data from physical storage locations in which it is stored to physical storage locations allocated to a destination replica on the other computing node. During copying, service requests to modify table data may be logged and applied to the replica being copied. A catch-up operation may be performed to apply modification requests received during copying to the destination replica.
摘要翻译：实现数据存储服务的系统可以代表客户端在数据存储中维护表。该服务可以在存储在系统中的相应计算节点上的数据的分区的多个副本中维护表数据。响应于检测到故障或故障状况，或者从客户端接收到移动或复制分区副本的服务请求，数据存储可以使用物理复制机制将分区副本复制到另一个计算节点。物理复制机制可以将表数据从其存储的物理存储位置复制到分配给另一个计算节点上的目标副本的物理存储位置。在复制期间，可能会记录修改表数据的服务请求并将其应用于复制副本。可以执行追赶操作以将复制期间接收的修改请求应用于目的地复本。

6. 发明授权

US08572091B1 System and method for partitioning and indexing table data using a composite primary key 有权
标题翻译：使用复合主键分区和索引表数据的系统和方法
公开(公告)号：US08572091B1
公开(公告)日：2013-10-29
申请号：US13169990
申请日：2011-06-27
申请人： Swaminathan Sivasubramanian , Stefano Stefani , Chiranjeeb Buragohain , Rande A. Blackman , Timothy Andrew Rath , Grant A. M. McAlister , Jakub Kulesza , Wei Xiao , Raymond S. Bradford
发明人： Swaminathan Sivasubramanian , Stefano Stefani , Chiranjeeb Buragohain , Rande A. Blackman , Timothy Andrew Rath , Grant A. M. McAlister , Jakub Kulesza , Wei Xiao , Raymond S. Bradford
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/3033 , G06F17/30584 , G06F17/30628 , G06F17/30949 , Y10S707/968 , Y10S707/972
摘要： A system that implements a scaleable data storage service may maintain tables in a non-relational data store on behalf of service clients. Each table may include multiple items. Each item may include one or more attributes, each containing a name-value pair. The system may provide an API through which clients can query tables maintained by the service. Items may be partitioned and indexed in a table according to a simple or composite primary key contained in all items in the table. A composite primary key may include a hash key attribute, and a range key attribute. The range key attribute may be usable to order items having the same hash key attribute value, and to partition them dependent on a range of range key attribute values. A query request may specify a logical or mathematical expression dependent on range key attribute values and may be directed to multiple partitions.
摘要翻译：实现可扩展数据存储服务的系统可以代表服务客户端在非关系数据存储中维护表。每个表可以包括多个项目。每个项目可以包括一个或多个属性，每个属性包含名称 - 值对。该系统可以提供一种API，通过该API，客户端可以查询由服务维护的表。项目可以根据表中所有项目中包含的简单或复合主键在表中进行分区和索引。复合主键可以包括散列键属性和范围键属性。范围键属性可以用于对具有相同散列键属性值的项进行排序，并且根据范围键属性值的范围对它们进行分区。查询请求可以指定取决于范围键属性值的逻辑或数学表达式，并且可以被引导到多个分区。

7. 发明授权

US10877669B1 System and method for providing a committed throughput level in a data store 有权
公开(公告)号：US10877669B1
公开(公告)日：2020-12-29
申请号：US13174189
申请日：2011-06-30
申请人： Swaminathan Sivasubramanian , Stefano Stefani , Wei Xiao , Timothy Andrew Rath , Rande A. Blackman , Grant A. M. McAlister , Raymond S. Bradford
发明人： Swaminathan Sivasubramanian , Stefano Stefani , Wei Xiao , Timothy Andrew Rath , Rande A. Blackman , Grant A. M. McAlister , Raymond S. Bradford
IPC分类号： G06F3/06 , H04L29/08
CPC分类号： G06F3/0613 , G06F3/0631 , G06F3/0683 , G06F3/0608 , H04L67/1097
摘要： A system that implements a scaleable data storage service may maintain tables in a data store on behalf of storage service clients. The service may maintain data in partitions stored on respective computing nodes in the system. The service may support multiple throughput models, including a committed throughput model and a best effort throughput model. A service request to create a table may specify that requests directed to the table should be serviced under a committed throughput model and may specify the committed throughput level in terms of logical service request units. The service may reserve low-latency storage and other resources sufficient to meet the specified committed throughput level. A client/user may request a modification to the committed throughput level in anticipation of workload changes, such as an increase or decrease in traffic or data volume. In response, the system may increase or decrease the resources reserved for the table.

8. 发明授权

US08601000B1 System and method for conditionally updating an item with attribute granularity 有权
标题翻译：用于有条件地更新属性粒度的项目的系统和方法
公开(公告)号：US08601000B1
公开(公告)日：2013-12-03
申请号：US13169995
申请日：2011-06-27
申请人： Stefano Stefani , Chiranjeeb Buragohain , Jai Vasanth , Wei Xiao
发明人： Stefano Stefani , Chiranjeeb Buragohain , Jai Vasanth , Wei Xiao
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30371 , G06F17/30002 , G06F17/30345 , G06F17/30365 , G06F17/30584
摘要： A system that implements a scaleable data storage service may maintain tables in a non-relational data store on behalf of clients. Each table may include multiple items. Each item may include one or more attributes, each containing a name-value pair. Attribute values may be scalars or sets of numbers or strings. The system may provide an API usable to request that values of one or more of an item's attributes be updated. An update request may be conditional on expected values of one or more item attributes (e.g., the same or different item attributes). In response to a request to update the values of one or more item attributes, the previous values and/or updated values may be optionally returned for the updated item attributes or for all attributes of an item targeted by an update request. Items stored in tables may be indexed using a simple or composite primary key.
摘要翻译：实现可扩展数据存储服务的系统可以代表客户端在非关系数据存储中维护表。每个表可以包括多个项目。每个项目可以包括一个或多个属性，每个属性包含名称 - 值对。属性值可以是标量或数字或字符串集合。系统可以提供可用于请求更新项目属性中的一个或多个的值的API。更新请求可以以一个或多个项目属性（例如，相同或不同的项目属性）的预期值为条件。响应于更新一个或多个项目属性的值的请求，可以可选地为更新的项目属性或由更新请求定向的项目的所有属性返回先前值和/或更新的值。存储在表中的项目可以使用简单或复合主键进行索引。

9. 发明授权

US08637527B2 Imidazolo-, oxazolo-, and thiazolopyrimidine modulators of TRPV1 有权
标题翻译： TRPV1的咪唑并，唑嗪和噻唑并嘧啶调节剂
公开(公告)号：US08637527B2
公开(公告)日：2014-01-28
申请号：US13611936
申请日：2012-09-12
申请人： Bryan James Branstetter , J. Guy Breitenbucher , Alec D. Lebsack , Jing Liu , Jason C Rech , Wei Xiao
发明人： Bryan James Branstetter , J. Guy Breitenbucher , Alec D. Lebsack , Jing Liu , Jason C Rech , Wei Xiao
IPC分类号： C07D487/04 , A61K31/519 , A61K31/397 , A61K31/496 , A61K31/497 , A61P25/02 , A61P29/00 , A61P19/02 , C07D473/34 , C07D473/28 , C07D473/32 , A61K31/52
CPC分类号： C07D513/04 , A61K31/497 , A61K31/519 , A61K31/5377 , C07D473/16 , C07D473/18 , C07D473/24 , C07D473/34 , C07D498/04
摘要： Certain TRPV1-modulating imidazolo-, oxazolo-, and thiazolopyrimdine compounds are described. The compounds may be used in pharmaceutical compositions and methods for treating disease states, disorders, and conditions mediated by TRPV1 activity, such as pain, arthritis, itch, cough, asthma, or inflammatory bowel disease.
摘要翻译：描述了一些TRPV1调节的咪唑并，恶唑并噻唑并噻吩并嘧啶化合物。所述化合物可用于治疗由TRPV1活性介导的疾病状态，病症和状况的药物组合物和方法，例如疼痛，关节炎，瘙痒，咳嗽，哮喘或炎症性肠病。

10. 发明授权

US08614201B2 Heterocyclic amides as modulators of TRPA1 有权
标题翻译：杂环酰胺作为TRPA1的调节剂
公开(公告)号：US08614201B2
公开(公告)日：2013-12-24
申请号：US13375833
申请日：2010-06-04
申请人： Didier Jean-Calude Berthelot , Henricus Jacobus Maria Gijsen , Mirko Zaja , Jason Rech , Alec Lebsack , Bryan Branstetter , Wei Xiao , J. Guy Breitenbucher
发明人： Didier Jean-Calude Berthelot , Henricus Jacobus Maria Gijsen , Mirko Zaja , Jason Rech , Alec Lebsack , Bryan Branstetter , Wei Xiao , J. Guy Breitenbucher
IPC分类号： A01N57/00 , A61K31/66 , A01N43/36 , A61K31/40 , A01N43/66 , A61K31/53 , A01N43/40 , A61K31/435 , A01N43/54 , C07D239/42 , C07D401/04 , C07D239/00 , C07D239/02 , C07D213/00 , C07C303/00 , C07C307/00 , C07C309/00 , C07C311/00
CPC分类号： C07D403/14 , C07D207/48 , C07D401/12 , C07D401/14 , C07D403/12 , C07D405/14 , C07D409/12 , C07D409/14
摘要： Certain heterocyclic amide compounds are described. The compounds may be used in pharmaceutical compositions and methods for treating disease states, disorders, and conditions mediated by TRPA1 activity, such as pain, arthritis, itch, cough, asthma, or inflammatory bowel disease.
摘要翻译：描述了某些杂环酰胺化合物。所述化合物可用于治疗由TRPA1活性介导的疾病状态，病症和状况的药物组合物和方法，例如疼痛，关节炎，瘙痒，咳嗽，哮喘或炎症性肠病。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式