I recommend that we look into building Oracle data marts using Oracle Data Mart Builder (for the individual departments that can eventually be amalgamated into a company-wide data warehouse (˘Oracle Data Mart Suites÷). We would need to purchase the Oracle Data Mart Suite (Stevens) and do an Access-to-Oracle conversion (˘Access-to-Oracle÷) on the MS Access databases, but the end result would be a company where all the data is formatted for the same database and has excellent visibility. Figures 1 through 4 (Stevens) show Data Mart Diagrammer, a sample star schema, Data Mart Builder Time Generation Transform, and Data Mart Builder with Transforms, respectively. I believe this solution would resolve the issues identified above and streamline ITĂs operation¨as well as the help deskĂs¨considerably.
The multiple databases and platforms used by the company pose problems in terms of data visibility and maintainability. All of the companyĂs data, with the possible exception of the secure Human Resources data, should be kept on the same system. Although there may be many individual databases, they should all be accessible from anywhere in the com