People in society are producing data in an explosive manner. Various organizations use this data for decision support and to construct data-intensive products and services. A purpose of network management tool is to manage network devices within the data centers of an enterprise that is spread across the globe. Any organization’s Decision Support Network Automation is the Business Intelligence (BI) system built for advance and custom reporting on the stored data by performing Extract, Transform and Load (ETL) operations using On-line Transaction Processing (OLTP) Database. Similarly ETL tool is a process in database usage and especially in data warehousing.  This extracts data from homogeneous or heterogeneous data sources, transforms the data for storing it in proper format or structure for querying and analysis purpose and finally loads it into the final target (database, more specifically, operational data store, data mart, or data warehouse). In this tool usually all the three phases execute in parallel as the data extraction process requires time. This paper provides an advance solution to existing database tools.

©2016 International Journal of Computer Science and Applications 

Published by Research Publications, India