1. Performance Tuning Guide
  2. Summary of Features of the Siebel ARM Query Tool

Summary of Features of the Siebel ARM Query Tool

Some of the features of the Siebel ARM Query Tool are described as follows:

  • Source data specification. You can specify individual Siebel ARM files or directories as input for the Siebel ARM Query Tool. For more information about the parameters that allow you to specify input data, see Configuring Input for the Siebel ARM Query Tool.

  • Multiple output formats. You can specify that multiple types of output be produced simultaneously. Supported output formats include TXT, XML and CSV. For more information about how to specify the output format, see Configuring Output from the Siebel ARM Query Tool.

  • Data filtering capability. You can specify selection filters that include or exclude data from analysis by the Siebel ARM Query Tool. Selection filters provide many ways to specify the types of records that you are interested in. Filters are generally not mutually exclusive. That is, you do not need to choose just one filter; you can use multiple filters, in any combinations that you require. For more information about using selection filters, see Using Selection Filters with the Siebel ARM Query Tool.

  • Aggregating data. You can specify the order of aggregation for your output. This includes rollup calculations. Aggregation is the grouping of Siebel ARM records that share common attributes and the computing of statistics on the group. For more information about aggregation, see Aggregating Siebel ARM Data with the Siebel ARM Query Tool.

  • Histograms. Histograms are a special type of aggregation. You can use a histogram to aggregate the results that the Siebel ARM Query Tool retrieves when you submit a query on Siebel ARM data that can return too many values if you do not use the histogram. For more information about using histograms, see Generating Histograms with the Siebel ARM Query Tool.

  • Macro language. The Siebel ARM Query Tool supports the use of macros. For more information about using macros, see Using Macros with the Siebel ARM Query Tool.

  • Configurable memory for statistical accuracy. By default, approximately 20 MB of memory is used by the Siebel ARM Query Tool's internal buffer used for statistical calculation. You can increase this amount of memory in order to increase the statistical accuracy of results. For example, increasing the amount of memory for the tool to 500 MB can reduce the statistical error level from 1% to 0.2%. For more information about configuring memory allocation for the Siebel ARM Query Tool, see Configuring the Siebel ARM Query Tool.

For more command-line options for the Siebel ARM Query Tool, see General Commands for the Siebel ARM Query Tool and Configuring the Siebel ARM Query Tool.