Information Technology Data

Each running(a) plane section also has people with their own private databases that reside on their PCs. For example, the sales manager uses the sales system for functional applications scarcely has his own database for recording information about the vendors and his contacts with them. This creates a insufficiency of visibility where only he has access to that information, and the fraternity suffered a serious loss one year because someone in upper management made a financial close without knowing that the vendor involved was a poor risk. The functional data also resides in Oracle on the main server.

At the help desk, most of the data is either call-related or reference-type data that help desk technicians access to assist callers in settlement their technical problems with the functional systems. This data is only accessible by the help desk and is not updated very frequently, nor is it by any delegacy complete. Help desk technicians complain that many of their calls are difficult to fragmentize because the resultant roles are not generally known. They often have to lease several other technicians before finding someone who terminate help. Their call-trac

I recommend that we cheek into building Oracle data marts using Oracle data market Builder (for the individual departments that can eventually be amalgamated into a company-wide data warehouse ("Oracle information Mart Suites").

We would need to purchase the Oracle Data Mart Suite (Stevens) and do an rise to power-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 by means of 4 (Stevens) show Data Mart Diagrammer, a exemplification star schema, Data Mart Builder Time coevals 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 anyplace in the c
Ordercustompaper.com is a professional essay writing service at which you can buy essays on any topics and disciplines! All custom essays are written by professional writers!