Patent ID: 7401321
Filing Date: 2008-07-15
Classification: G06F

Abstract:
1. An apparatus including a program storage medium readable by a computer for processing data relating to software defects, the apparatus operative within an associated on-line analytical processing environment that includes at least an on-line analytical processing presentation tool for presenting results of on-line analytical processing, the apparatus comprising: an on-line analytical processing cube model builder for building a plurality of interrelated tables with on-line analytical processing cube model metadata, the on-line analytical processing cube model metadata defining a cube model that represents a structural relationship between said plurality of interrelated tables, and the metadata including at least one on-line analytical processing metadata object defining a measurement entity operative in conjunction with a dimensional context, the measurement entity including at least one of a defect count measure defined in eXtensible Markup Language (XML) and a defect count average measure defined in XML, the tables including at least a defect facts table containing software defects entries corresponding to said data relating to software defects and a plurality of dimension tables, the defect facts table being interrelated with the plurality of dimension tables by a facts and dimensions table builder, the cube model including the software defects entries being configured to be processed by the associated on-line analytical processing presentation tool by means of an on-line analytical processing cube generated from said software defects entries in said cube model based on selected metadata in the plurality of dimension tables, said metadata categorizing at least one set of related attributes that together describe an aspect of at least one dimension measure corresponding to said software defects entries; and a data extraction tool communicating with a defect tracking database containing said data relating to software defects, the data extraction tool extracting said data from the defect tracking database, transforming the extracted data into the software defect entries, and loading the software defect entries into the defect facts table.