Creating a Virtual Data Warehouse for Manufacturing Industry

The IUP Journal of Operations Management, Vol. 10, No. 2, pp. 47-59, May 2011

Posted: 29 Feb 2012

See all articles by Jigeesh Nasina

Jigeesh Nasina

ICFAI Business School (IBS), Hyderabad

Santhi Sree Kondabolu

Institute of Chartered Financial Analysts of India (ICFAI) - The Icfai University (IFHE), Hyderabad

Date Written: February 28, 2012

Abstract

Data warehousing is the best solution to relieve the database management systems from holding the long-standing data which accumulates from day-to-day business transactions. But creating and managing a data warehouse is a complex task, and in addition, data warehouse tools available in the market are very expensive. To make the data warehouse solutions cost-effective, creation of virtual data warehouse is one of the options in the case of applications having limited scope or limited duration. This paper deals with the development of such virtual data warehouse for effective supply chain management for a multinational software development and consultancy company dealing with big semiconductor manufacturing industries. The design and development of the virtual data warehouse is described in detail using the existing database management systems and the existing huge database of the companies. The data warehouse has been created based on the important business requirements, identifying the relevant existing data sources that can be integrated to generate respective dimensional tables and, thereby, the fact tables, and then finally completing the multidimensional models to derive answers to the respective queries. The paper also presents some screen shots of the application interface.

Suggested Citation

Nasina, Jigeesh and Kondabolu, Santhi Sree, Creating a Virtual Data Warehouse for Manufacturing Industry (February 28, 2012). The IUP Journal of Operations Management, Vol. 10, No. 2, pp. 47-59, May 2011, Available at SSRN: https://ssrn.com/abstract=2012959

Jigeesh Nasina (Contact Author)

ICFAI Business School (IBS), Hyderabad ( email )

Survey No. 156/157, Dontanapalli Village
Shankerpalli Mandal, RR District
Hyderabad, Andhra Pradesh 501504
India
08417236657 (Phone)
08417236653 (Fax)

HOME PAGE: http://ibshydindia.org

Santhi Sree Kondabolu

Institute of Chartered Financial Analysts of India (ICFAI) - The Icfai University (IFHE), Hyderabad ( email )

Donthanapally Shankarapalli Road
RAJAWALA ROAD
Hyderabad, RI 501203
India

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Abstract Views
607
PlumX Metrics