A Virtual Data Warehouse for Manufacturing Industry

16 Pages Posted: 30 Jan 2010

See all articles by Santhi Sree Kondabolu

Santhi Sree Kondabolu

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

Jigeesh Nasina

ICFAI Business School (IBS), Hyderabad

Date Written: January 30, 2010


Data warehousing is the best solution to relieve the database management systems to hold the long standing data which will go on mounting from day to day business transactions. But creating and managing a data warehouse are complex tasks 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 option 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 multi-national 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 together to generate respective dimensional tables and thereby the fact tables and then finally completing the multi-dimensional models to derive answers to the respective queries. The paper also presents some screen shots of the application interface.

Keywords: IT Management, Other Computer Software, Production Management, Computer Services

JEL Classification: M15, C88, M11, L86

Suggested Citation

Kondabolu, Santhi Sree and Nasina, Jigeesh, A Virtual Data Warehouse for Manufacturing Industry (January 30, 2010). Available at SSRN: https://ssrn.com/abstract=1544806 or http://dx.doi.org/10.2139/ssrn.1544806

Santhi Sree Kondabolu

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

Donthanapally Shankarapalli Road
Hyderabad, RI 501203

Jigeesh Nasina (Contact Author)

ICFAI Business School (IBS), Hyderabad ( email )

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

HOME PAGE: http://ibshydindia.org

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

Paper statistics

Abstract Views
PlumX Metrics