公开(公告)号：US20060253471A1

公开(公告)日：2006-11-09

申请号：US11121631

申请日：2005-05-03

Applicant: Theodore Wasserman ,  Haider Rizvi ,  Thomas Martin ,  David Skillicorn

Inventor： Theodore Wasserman ,  Haider Rizvi ,  Thomas Martin ,  David Skillicorn

IPC: G06F7/00

CPC classification number: G06F17/30306

Abstract: A workload characterization system characterizes an exemplary business intelligence workload for use in sizing a hardware configuration required by a new database system running a similar business intelligence workload. The workload characterization system uses performance-oriented measurements to characterize an exemplary workload in terms of resource usage and performance metrics. The workload characterization system applies unsupervised data mining techniques to group individual business intelligence queries into general classes of queries based on system resource usage, providing insight into the resource demands of queries typical of a business intelligence workload. The general classes of queries are used to define an anticipated workload for a planned database system and to help identify the hardware required for the planned database system.

Abstract translation: 工作负载表征系统表征了用于规模运行类似商业智能工作负荷的新数据库系统所需的硬件配置的示例性业务智能工作负载。 工作负载表征系统使用基于性能的测量来表征在资源使用和性能指标方面的示例性工作负载。 工作负载表征系统采用无监督的数据挖掘技术，根据系统资源使用情况，将各种商业智能查询分组为一般查询类别，从而深入了解商业智能工作负载中典型查询的资源需求。 一般查询类用于定义计划数据库系统的预期工作负载，并帮助识别计划数据库系统所需的硬件。