Patent ID: 8768878

Claim:
A method for characterizing workloads in a data warehouse system, the method comprising: executing with a processor on an information processing system the following: collecting a set of accounting data associated with a data warehouse system comprising at least one database; determining, based on the set of accounting data, a set of query concurrency information associated with the database, the set of query concurrency information identifying, for a plurality of queries and for each of a plurality of time units over a period of time, a number of queries executed on the database simultaneously and a duration of execution of such queries, wherein the set of query concurrency information is determined based on at least comparing a start and end time of each query in the plurality of queries against each a start and end time of each remaining query in the plurality of queries; determining, based on the set of accounting data, a set of processor utilization distribution information associated with the plurality of queries; determining, based on the set of accounting data, a set of data access information indicating a quantity of data accessed by each query in the plurality of queries; and generating a workload profile associated with the database based on the set of query concurrency information, the set of processor utilization distribution information, and the set of data access information.