Information Technology Data

Search

Information Technology Data

Each functional department 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 but has his own database for recording information about the vendors and his contacts with them. This creates a lack of visibility where only he has access to that information, and the company suffered a serious loss one year because someone in upper management made a financial decision 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 resolving 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 means complete. Help desk technicians complain that many of their calls are difficult to resolve because the solutions are not generally known. They often have to ask several other technicians before finding someone who can help. Their call-trac

VIEW THE REST OF THIS ESSAY!

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

775

VIEW THIS ESSAY

SAVE PAPER


		Some topics in this essay

		Report Manager \| Human Resources \| Retrieved June \| Social Security \| Builder Transforms \| MS Access \| Mart Builder \| data mart \| Data Mart \| Microsoft Access \| help desk \| data resides \| oracle data \| Mart Diagrammer \| oracle data mart \| june 15 2005 \| june 15 \| raw data \| 15 2005 \| retrieved june \| human resources \| retrieved june 15 \| data mart builder \| secure server \| able access data \|