Patent ID: 7546312

Claim:
A method of modeling a storage area network online database for report queries comprising: identifying a plurality of tables in an object model; enumerating tables for transformation, the tables having attributes operable to store values; selecting a subset of fields from the storage area network online database corresponding to multiple fact tables expected to be queried in a report database, wherein the expected queries comprise SAN activity reports; extracting the enumerated tables from the online database; filtering, for each of the tables, unqueried fields to identify a transformation set of tables, the transformation set indicative of queryable values responsive to user queries; transforming, via a set of views and tables, the queryable values of the transformation set; for each attribute, classifying the attribute as a dimension or a fact assigning, if the attribute is a fact, the attribute to a central metrics table; and assigning, if the attribute corresponds to a dimension, the attribute to a dimension table having an association to the central metrics table; and loading the transformed values into the corresponding tables in a report database, the report database strongly indexed on the attributes of the fact table, and having fewer records in the dimension tables than corresponding values in the online database.