Object Migration Tool for Data Warehouses

Nayem Rahman, Peter W. Burkhardt and Kevin W. Hibray
Additional contact information
Nayem Rahman: Intel Corporation, USA
Peter W. Burkhardt: Intel Corporation, USA
Kevin W. Hibray: Intel Corporation, USA

International Journal of Strategic Information Technology and Applications (IJSITA), 2010, vol. 1, issue 4, 55-73

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.

Date: 2010
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/jsita.2010100104 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jsita0:v:1:y:2010:i:4:p:55-73

Access Statistics for this article

International Journal of Strategic Information Technology and Applications (IJSITA) is currently edited by Mehdi Khosrow-Pour

More articles in International Journal of Strategic Information Technology and Applications (IJSITA) from IGI Global
Bibliographic data for series maintained by Journal Editor ().