ADMiRe: An algebraic data mining approach to system performance analysis

    Authors

    N. Jiang; R. Villafane; K. A. Hua; A. Sawant;K. Prabhakara

    Comments

    Authors: contact us about adding a copy of your work at STARS@ucf.edu

    Abbreviated Journal Title

    IEEE Trans. Knowl. Data Eng.

    Keywords

    data mining; performance of systems; algorithms for data and knowledge; management; KNOWLEDGE; Computer Science, Artificial Intelligence; Computer Science, Information; Systems; Engineering, Electrical & Electronic

    Abstract

    Performance analysis of computing systems is an increasingly difficult task due to growing system complexity. Traditional tools rely on ad hoc procedures. With these, determining which of the manifold system and workload parameters to examine is often a lengthy and highly speculative process. The analysis is often incomplete and, therefore, prone to revealing faulty conclusions and not uncovering useful tuning knowledge. We address this problem by introducing a data mining approach called ADMiRe ( Analyzer for Data Mining Results). In this scheme, regression analysis is first applied to performance data to discover correlations between various system and workload parameters. The results of this analysis are summarized in sets of regression rules. The user can then formulate intuitive algebraic expressions to manipulate these sets of rules to capture critical information. To demonstrate this approach, we use ADMiRe to analyze an Oracle database system running the TPC- C ( Transaction Processing Performance Council) benchmark. The results generated by ADMiRe were confirmed by Oracle experts. We also show that by applying ADMiRe to Microsoft Internet Information Server performance data, we can improve system performance by 20 percent.

    Journal Title

    Ieee Transactions on Knowledge and Data Engineering

    Volume

    17

    Issue/Number

    7

    Publication Date

    1-1-2005

    Document Type

    Article

    Language

    English

    First Page

    888

    Last Page

    901

    WOS Identifier

    WOS:000229074800002

    ISSN

    1041-4347

    Share

    COinS