Database Management of Cartridge Tape Library Of Oil & Gas Development Corporation Limited (OGDCL)

Abstract

OGDCL cartridge/tape library comprises a number of data types in a variety of formats, each available in a network of heterogeneous computing platform ranging from PC's to Mainframe computers. For integrated approach for effective and efficient data management. My project is to implement the integrated data management in ORACLE. Some additional things have been added. In the present project the task of computerizing the cortridge tape library management of OGDCL. The purpose of computerization task was to facilitate the working procedures, utilizing the available facilities in a better and efficient way and to make the better use of available time. The computerization of the system was done in three steps. First of all system \vas studied and analyzed the purpose of which was to design and implement a better system~ for its better functions and dra\vbacks. The existing system of OGDCL cortridge tape library was present in Fox pro and excels sheets. The cortridge tape library maintains thousands of data in its library, the existing system of OGDCL library has many drawbacks of data archiving and security. Our aim was to purpose a system to abolish these draw backs using oracle tool. In the second system the new system was designed keeping in view was the results of study and analysis of existing system. In the third and last step the designed system was implemented within the existing system with the newly design one, and evaluated, with the newly implemented system was tested and results compared with those of old existing system.