公开(公告)号：US09336251B2

公开(公告)日：2016-05-10

申请号：US13683849

申请日：2012-11-21

Applicant: NEC Laboratories America, Inc.

Inventor： Hatem Abdelghani Mahmoud ,  Hyun Jin Moon ,  Yun Chi ,  Vahit Hakan Hacigumus

IPC: G06F17/30

CPC classification number: G06F17/30306

Abstract: Systems and methods for consolidating workload on one or more computing devices, comprising: generating tenant performance profiles for at least one of a buffer memory size and a buffer warmness; assigning one or more tenants to a database management system (DBMS) instance; configuring the one or more tenants to minimize a total server count needed to host the one or more tenants; and reducing the total server count by adjusting of buffer sizes while satisfying Service Level Agreement (SLA) requirements.

Abstract translation: 一种用于在一个或多个计算设备上整合工作负载的系统和方法，包括：为缓冲存储器大小和缓冲器温度中的至少一个生成租户性能配置文件; 将一个或多个租户分配给数据库管理系统（DBMS）实例; 配置一个或多个租户以最小化托管一个或多个租户所需的总服务器数量; 并通过调整缓冲区大小减少服务器总数，同时满足服务级别协议（SLA）要求。

公开(公告)号：US20130085742A1

公开(公告)日：2013-04-04

申请号：US13645112

申请日：2012-10-04

Applicant: NEC Laboratories America, Inc.

Inventor： Sean Barker ,  Yun Chi ,  Hyun Jin Moon ,  Vahit Hakan Hacigumus

IPC: G06F9/455

CPC classification number: G06F9/455 ,  G06F9/5088 ,  G06F16/214

Abstract: A method for migration from a multitenant database is shown that includes building an analytical model for each of a set of migration methods based on database characteristics; predicting performance of the set of migration methods using the respective analytical model with respect to tenant service level agreements (SLAs) and current and predicted tenant workloads, where the prediction includes a migration speed and an SLA violation severity; and selecting a best migration method from the set of migration methods according to the respective predicted migration speeds and SLA violation severities.

Abstract translation: 显示了从多租户数据库迁移的方法，其中包括基于数据库特征构建一组迁移方法中的每一个的分析模型; 使用关于租户服务水平协议（SLA）的相应分析模型以及当前和预计的租户工作负载预测该组迁移方法的性能，其中预测包括迁移速度和SLA违规严重性; 并根据各自的预测迁移速度和SLA违规严重程度从该组迁移方法中选择最佳迁移方法。

公开(公告)号：US20130085998A1

公开(公告)日：2013-04-04

申请号：US13645103

申请日：2012-10-04

Applicant: NEC Laboratories America, Inc.

Inventor： Sean Barker ,  Yun Chi ,  Hyun Jin Moon ,  Vahit Hakan Hacigumus

IPC: G06F17/30 ,  G06F12/16

CPC classification number: G06F9/455 ,  G06F9/5088 ,  G06F17/303

Abstract: Methods and systems for database migration from a multitenant database include taking a snapshot of an original database to be migrated with a hot backup process, such that the database is still capable of answering queries during the hot backup process; maintaining a query log of all queries to the tenant database after the hot backup process begins; initializing a new database at a target server using the snapshot; replaying the query log synchronize the new database with the original database; and answering new queries with the new database and not the original database.

Abstract translation: 从多租户数据库进行数据库迁移的方法和系统包括：使用热备份流程来迁移原始数据库的快照，以使得数据库仍然能够在热备份过程中回答查询; 在热备份过程开始之后，将所有查询的查询日志保存到租户数据库; 使用快照在目标服务器上初始化新数据库; 重播查询日志将新数据库与原始数据库同步; 并使用新的数据库而不是原始数据库来回答新的查询。

公开(公告)号：US08880477B2

公开(公告)日：2014-11-04

申请号：US13645103

申请日：2012-10-04

Applicant: NEC Laboratories America, Inc.

Inventor： Sean Barker ,  Yun Chi ,  Hyun Jin Moon ,  Vahit Hakan Hacigumus

IPC: G06F17/30 ,  G06F9/455 ,  G06F9/50

CPC classification number: G06F9/455 ,  G06F9/5088 ,  G06F17/303

Abstract: Methods and systems for database migration from a multitenant database include taking a snapshot of an original database to be migrated with a hot backup process, such that the database is still capable of answering queries during the hot backup process; maintaining a query log of all queries to the tenant database after the hot backup process begins; initializing a new database at a target server using the snapshot; replaying the query log synchronize the new database with the original database; and answering new queries with the new database and not the original database.

Abstract translation: 从多租户数据库进行数据库迁移的方法和系统包括：使用热备份流程来迁移原始数据库的快照，以使得数据库仍然能够在热备份过程中回答查询; 在热备份过程开始之后，将所有查询的查询日志保存到租户数据库; 使用快照在目标服务器上初始化新数据库; 重播查询日志将新数据库与原始数据库同步; 并使用新的数据库而不是原始数据库来回答新的查询。

公开(公告)号：US20130212064A1

公开(公告)日：2013-08-15

申请号：US13683849

申请日：2012-11-21

Applicant: NEC Laboratories America, Inc.

Inventor： Hatem Abdelghani Mahmoud ,  Hyun Jin Moon ,  Yun Chi ,  Vahit Hakan Hacigumus

IPC: G06F17/30

CPC classification number: G06F17/30306

Abstract: Systems and methods for consolidating workload on one or more computing devices, comprising: generating tenant performance profiles for at least one of a buffer memory size and a buffer warmness; assigning one or more tenants to a database management system (DBMS) instance; configuring the one or more tenants to minimize a total server count needed to host the one or more tenants; and reducing the total server count by adjusting of buffer sizes while satisfying Service Level Agreement (SLA) requirements.

Abstract translation: 一种用于在一个或多个计算设备上整合工作负载的系统和方法，包括：为缓冲存储器大小和缓冲器温度中的至少一个生成租户性能配置文件; 将一个或多个租户分配给数据库管理系统（DBMS）实例; 配置一个或多个租户以最小化托管一个或多个租户所需的总服务器数量; 并通过调整缓冲区大小减少服务器总数，同时满足服务级别协议（SLA）要求。