会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 5. 发明授权
    • Lazy updates to indexes in a database
    • 对数据库中的索引进行懒惰更新
    • US07779045B2
    • 2010-08-17
    • US11862716
    • 2007-09-27
    • Ahmed MohamedSukhdeep Singh SodhiMatthew Jim Lee
    • Ahmed MohamedSukhdeep Singh SodhiMatthew Jim Lee
    • G06F17/30
    • G06F17/30339
    • System(s) and method(s) facilitate improved performance for insert/update query requests in a database. A lazy updating based on delaying updates of newly inserted records combined with a master-staging partitioning scheme avoid deterioration of performance arising from updating indexes related to new records inserted in a database. Table partitioning as well as partitioning of indexes associated with the table allow new records to reside in manageable sections of memory for pre-configured periods of times prior to being updated. To avoid deterioration of performance associated with increasing size of table/index partitions, the size is maintained below specific thresholds that can be determined based on query workload and other historical data. Deployment of partitions among file systems and design of update delay times can further increase performance of lazy updating.
    • 系统和方法有助于提高数据库中插入/更新查询请求的性能。 基于延迟新插入记录的更新结合主分级分区方案的延迟更新避免了由于更新与插入到数据库中的新记录有关的索引而导致的性能恶化。 表分区以及与表相关联的索引的分区允许新记录驻留在内存的可管理部分中,以便在更新之前进行预配置的时间段。 为了避免与增加表/索引分区大小相关联的性能恶化,该大小保持在可以基于查询工作负载和其他历史数据确定的特定阈值以下。 在文件系统中部署分区和设计更新延迟时间可以进一步提高延迟更新的性能。
    • 9. 发明申请
    • LAZY UPDATES TO INDEXES IN A DATABASE
    • LAZY更新数据库中的索引
    • US20090089334A1
    • 2009-04-02
    • US11862716
    • 2007-09-27
    • Ahmed MohamedSukhdeep Singh SodhiMatthew Jim Lee
    • Ahmed MohamedSukhdeep Singh SodhiMatthew Jim Lee
    • G06F17/30
    • G06F17/30339
    • System(s) and method(s) facilitate improved performance for insert/update query requests in a database. A lazy updating based on delaying updates of newly inserted records combined with a master-staging partitioning scheme avoid deterioration of performance arising from updating indexes related to new records inserted in a database. Table partitioning as well as partitioning of indexes associated with the table allow new records to reside in manageable sections of memory for pre-configured periods of times prior to being updated. To avoid deterioration of performance associated with increasing size of table/index partitions, the size is maintained below specific thresholds that can be determined based on query workload and other historical data. Deployment of partitions among file systems and design of update delay times can further increase performance of lazy updating.
    • 系统和方法有助于提高数据库中插入/更新查询请求的性能。 基于延迟新插入记录的更新结合主分级分区方案的延迟更新避免了由于更新与插入到数据库中的新记录有关的索引而导致的性能恶化。 表分区以及与表相关联的索引的分区允许新记录驻留在内存的可管理部分中,以便在更新之前进行预配置的时间段。 为了避免与增加表/索引分区大小相关联的性能恶化,该大小保持在可以基于查询工作负载和其他历史数据确定的特定阈值以下。 在文件系统中部署分区和设计更新延迟时间可以进一步提高延迟更新的性能。