ARCHIVING SOLUSION FOR TRAVELBOX

Abstract

Codegen International (Pvt) Limited is a leading global technology innovation Services provider and it has grown beyond being an efficient provider of product and application development Services to being the partner of choice in creating competitive advantage for its clients using technology Solutions. Travel Box covers all travel industry related Services which optimizes more demanding options with its wide ranged technologies. From a flight/hotel reservation to supplier payments, Travel Box assists throughout the back office infrastructure setups to internet booking engines. For the maximum utilization of the tour reservation software, making way to maintain a closer customer relationship management with clients and suppliers! Travel Box technology which is one of the software products in Codegen, is the innovation for the global travel and tourism industry and a foremost product that accommodates tomorrow's travel software Solutions. But there were some problems relevant to database growth with infrequently access data (Historical Data). Software performance degradation was encountered and had to spend more money for the storages. To overeome these problems,Archiving Tool was created. First the requirement analysis was carried out by having discussion with team members and problem owners. Then Graphical User Interface (GUI) was created according to the requirements using JBuilder. After that separated database schema was created by generating with existing database tables using Case Studio database modeling tool and utility table’s data were pumped to above created schema’s tables. Information Lifecycle Management (ILM) was used to implement the system using Java technologies with Generics and JIDEA 6.0 was used as java compilen The component was tested individually and finally the integrated system was tested. Accelerating data growth in the databases could be managed by the Archiving Solution for Travel Box by relocating closed business transactions and other infrequently accessed data to an online. So archive database could easily be accessed. And the size of the production system was reduced as well as performance of the application was improved. So at the end of the development process, the main objective of the project was achieved and the Codegen International (Pvt) Limited was satisfied with the functionalities, usability, security and reliability of the system.