公开(公告)号：US09710505B1

公开(公告)日：2017-07-18

申请号：US14805262

申请日：2015-07-21

Applicant: Amazon Technologies, Inc.

Inventor： Grant Alexander Macdonald McAlister ,  Chelsea C. Krueger ,  Dallas L. Willett ,  Michael J. Russo ,  Ramnath R. Iyer

IPC: G06F17/30

CPC classification number: G06F17/30321 ,  G06F17/30091 ,  G06F17/30097 ,  G06F17/30138 ,  G06F17/30327 ,  G06F17/30339 ,  G06F17/30575 ,  G06F17/30595 ,  G06F17/30876

Abstract: Described herein are system and methods for mitigating index contention issues in databases. The database server may generate additional storage locations to prevent overloading one or more current storage locations. A variety of database conditions may be used to trigger an increase or decrease in storage locations. In one embodiment, more storage locations may be generated when the amount of data records waiting to be written at a storage location exceeds or equals a threshold amount. Likewise, the database server may reduce the amount of current storage locations when the amount of data records is less than a threshold amount. The record identifiers may incorporate a location reference for their designated storage location. The reference may be a string that includes numbers, letters, or a combination thereof.

公开(公告)号：US09122741B1

公开(公告)日：2015-09-01

申请号：US13626663

申请日：2012-09-25

Applicant: Amazon Technologies, Inc.

Inventor： Grant Alexander Macdonald McAlister ,  Chelsea C. Krueger ,  Dallas L. Willett ,  Michael J. Russo ,  Ramnath R. Iyer

IPC: G06F17/30

CPC classification number: G06F17/30321 ,  G06F17/30091 ,  G06F17/30097 ,  G06F17/30138 ,  G06F17/30327 ,  G06F17/30339 ,  G06F17/30575 ,  G06F17/30595 ,  G06F17/30876

Abstract: Described herein are system and methods for mitigating index contention issues in databases. The database server may generate additional storage locations to prevent overloading one or more current storage locations. A variety of database conditions may be used to trigger an increase or decrease in storage locations. In one embodiment, more storage locations may be generated when the amount of data records waiting to be written at a storage location exceeds or equals a threshold amount. Likewise, the database server may reduce the amount of current storage locations when the amount of data records is less than a threshold amount. The record identifiers may incorporate a location reference for their designated storage location. The reference may be a string that includes numbers, letters, or a combination thereof.

Abstract translation: 这里描述了用于减轻数据库中的索引争用问题的系统和方法。 数据库服务器可以生成额外的存储位置，以防止过载一个或多个当前存储位置。 可以使用各种数据库条件来触发存储位置的增加或减少。 在一个实施例中，当等待被写入存储位置的数据记录量超过或等于阈值时，可以产生更多的存储位置。 同样地，当数据记录量小于阈值时，数据库服务器可以减少当前存储位置的数量。 记录标识符可以包含其指定的存储位置的位置参考。 引用可以是包括数字，字母或其组合的字符串。