Welcome to the InfoSci Platform
Reference Hub7
Object Migration Tool for Data Warehouses

Object Migration Tool for Data Warehouses

Nayem Rahman, Peter W. Burkhardt, Kevin W. Hibray
Copyright: © 2010 |Volume: 1 |Issue: 4 |Pages: 19
ISSN: 1947-3095|EISSN: 1947-3109|EISBN13: 9781613502143|DOI: 10.4018/jsita.2010100104
Cite Article Cite Article

MLA

Rahman, Nayem, et al. "Object Migration Tool for Data Warehouses." IJSITA vol.1, no.4 2010: pp.55-73. http://doi.org/10.4018/jsita.2010100104

APA

Rahman, N., Burkhardt, P. W., & Hibray, K. W. (2010). Object Migration Tool for Data Warehouses. International Journal of Strategic Information Technology and Applications (IJSITA), 1(4), 55-73. http://doi.org/10.4018/jsita.2010100104

Chicago

Rahman, Nayem, Peter W. Burkhardt, and Kevin W. Hibray. "Object Migration Tool for Data Warehouses," International Journal of Strategic Information Technology and Applications (IJSITA) 1, no.4: 55-73. http://doi.org/10.4018/jsita.2010100104

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Data warehouses contain numerous software applications and thousands of objects that make those applications work. Many companies maintain multiple data warehouses depending on business requirements for example development, testing and production. Installing objects and keeping them synchronized across all environments can be a challenging task due to the sheer number of objects and complexity. Software objects stored in a Source Control system must be installed on target warehouse environments. Manual copy procedures are possible but very inefficient. Developers spend much time preparing installation and migration scripts that are prone to syntax errors. This paper proposes an Object Migration and Apply Tool (OMAT) that automates software installation across all warehouses for anyone using manual procedures. An automated tool can help eliminate error prone manual procedures, increase flawless object installation and reduce installation time. The OMAT tool is easy to use through a web browser and includes many useful features that support the development life cycle, the Sarbanes-Oxley (SOX) Act requirements and enforce numerous business requirements. OMAT is designed to support the construction and maintenance of an enterprise-wide, strategic data warehouse faster and better.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.