-
公开(公告)号：US20090182746A1
公开(公告)日：2009-07-16
申请号：US12014764
申请日：2008-01-15
IPC分类号： G06F17/00
CPC分类号： G06F17/30362
摘要： Described is a technology by which a database management system more efficiently processes read requests than write requests for a read-mostly database table, which is a database table that is generally read far more often than written. A lock partitioning mechanism may be implemented to provide a read lock for each CPU of a plurality of CPUs, in which only one read lock is acquired to process a read request. A database table state changing mechanism may be implemented that more efficiently processes read requests relative to write requests by maintaining the database table in a read-only state until a write request is processed. When a write request is received, the database table is changed to a read-write state to process the write request. The database table is then reset back to a read-only state, such as by running a background thread.
摘要翻译： 描述了一种数据库管理系统通过该技术更有效地处理读请求而不是对主要为大多数的数据库表的写入请求，该数据库表是通常比写入更多的数据库表。 可以实现锁定分隔机构以为多个CPU中的每个CPU提供读锁定，其中仅获取一个读取锁来处理读取请求。 可以实现数据库表状态改变机制，其通过将数据库表保持在只读状态来更有效地处理相对于写请求的读请求，直到写请求被处理。 当接收到写请求时，将数据库表更改为读写状态以处理写请求。 然后将数据库表重新设置为只读状态，例如通过运行后台线程。
-
公开(公告)号：US07908257B2
公开(公告)日：2011-03-15
申请号：US12014764
申请日：2008-01-15
IPC分类号： G06F17/30
CPC分类号： G06F17/30362
摘要： Described is a technology by which a database management system more efficiently processes read requests than write requests for a read-mostly database table, which is a database table that is generally read far more often than written. A lock partitioning mechanism may be implemented to provide a read lock for each CPU of a plurality of CPUs, in which only one read lock is acquired to process a read request. A database table state changing mechanism may be implemented that more efficiently processes read requests relative to write requests by maintaining the database table in a read-only state until a write request is processed. When a write request is received, the database table is changed to a read-write state to process the write request. The database table is then reset back to a read-only state, such as by running a background thread.
摘要翻译： 描述了一种数据库管理系统通过该技术更有效地处理读请求而不是对主要为大多数的数据库表的写入请求，该数据库表是通常比写入更多的数据库表。 可以实现锁定分隔机构以为多个CPU中的每个CPU提供读锁定，其中仅获取一个读取锁来处理读取请求。 可以实现数据库表状态改变机制，其通过将数据库表保持在只读状态来更有效地处理相对于写请求的读请求，直到写请求被处理。 当接收到写请求时，数据库表被改变为读写状态以处理写请求。 然后将数据库表重新设置为只读状态，例如通过运行后台线程。
-
公开(公告)号：US08103638B2
公开(公告)日：2012-01-24
申请号：US12436805
申请日：2009-05-07
CPC分类号： G06F17/30486
摘要： Methods, systems, and computer-readable media are disclosed for partitioning contended synchronization objects. A particular method determines a contention-free value of a performance metric associated with a synchronization object of a data structure. A contended value of the performance metric is measured, and the synchronization object is partitioned when the contended value of the performance metric exceeds a multiple of the contention-free value of the performance metric.
摘要翻译： 公开了用于划分竞争的同步对象的方法，系统和计算机可读介质。 特定方法确定与数据结构的同步对象相关联的性能度量的无争用值。 测量性能度量的竞争值，并且当性能度量的竞争值超过性能度量的无争用值的倍数时，同步对象被分区。
-
公开(公告)号：US20100287203A1
公开(公告)日：2010-11-11
申请号：US12436805
申请日：2009-05-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30486
摘要： Methods, systems, and computer-readable media are disclosed for partitioning contended synchronization objects. A particular method determines a contention-free value of a performance metric associated with a synchronization object of a data structure. A contended value of the performance metric is measured, and the synchronization object is partitioned when the contended value of the performance metric exceeds a multiple of the contention-free value of the performance metric.
摘要翻译： 公开了用于划分竞争的同步对象的方法，系统和计算机可读介质。 特定方法确定与数据结构的同步对象相关联的性能度量的无争用值。 测量性能度量的竞争值，并且当性能度量的竞争值超过性能度量的无争用值的倍数时，同步对象被分区。
-
公开(公告)号：US08176021B2
公开(公告)日：2012-05-08
申请号：US12131906
申请日：2008-06-02
CPC分类号： G06F17/30327
摘要： Aspects of the subject matter described herein relate to optimized reverse key indexes. In aspects, a dispersion function disperses index values such that they are distributed across multiple pages of an index. The dispersion function utilizes a dispersion factor that indicates to what extent the index values are dispersed. Because the index values are dispersed, contention regarding inserts may be reduced or eliminated and other advantages realized.
摘要翻译： 本文描述的主题的方面涉及优化的反向关键指标。 在一些方面，色散函数分散索引值，使得它们分布在索引的多个页面上。 色散函数利用分散因子，指示指数值在多大程度上分散。 由于索引值分散，可能会减少或消除与插入有关的争用，从而实现了其他优点。
-
公开(公告)号：US20090300013A1
公开(公告)日：2009-12-03
申请号：US12131906
申请日：2008-06-02
IPC分类号： G06F17/30
CPC分类号： G06F17/30327
摘要： Aspects of the subject matter described herein relate to optimized reverse key indexes. In aspects, a dispersion function disperses index values such that they are distributed across multiple pages of an index. The dispersion function utilizes a dispersion factor that indicates to what extent the index values are dispersed. Because the index values are dispersed, contention regarding inserts may be reduced or eliminated and other advantages realized.
摘要翻译： 本文描述的主题的方面涉及优化的反向关键指标。 在一些方面，色散函数分散索引值，使得它们分布在索引的多个页面上。 色散函数利用分散因子，指示指数值在多大程度上分散。 由于索引值分散，可能会减少或消除与插入有关的争用，从而实现其他优点。
-
-
-
-
-
搜索结果
6 条记录 (耗时 0.022 秒)
