Workflow management for ETL development

The management of data, including collection, control, movement, transformation and storage, has moved from a background consideration to the forefront of maintaining and increasing a business' competitive edge. Accordingly, the processes, technologies, activities, stakeholders and governance a...

Full description

Saved in:
Bibliographic Details
Published in:Journal of decision systems 2013-01, Vol.22 (4), p.319-331
Main Authors: Smith, Aaron W., Rahman, Nayem, Schmitt, Jacob J.
Format: Article
Language:English
Subjects:
Applied sciences
Automation
Computer science
control theory
systems
Cost control
Costs
data warehouse
Data warehouses
Efficiency
ETL
Exact sciences and technology
Firm modelling
Information systems. Data bases
Information technology
Memory organisation. Data processing
Operational research and scientific management
Operational research. Management science
Process controls
project life cycle
Reliability theory. Replacement problems
Software
Success
workflow
workflow management
Workflow software
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:The management of data, including collection, control, movement, transformation and storage, has moved from a background consideration to the forefront of maintaining and increasing a business' competitive edge. Accordingly, the processes, technologies, activities, stakeholders and governance around developing Extract, Transform and Load (ETL) applications have increased in number and complexity. To ensure ETL solutions can be delivered at the speed of business while maintaining quality, availability and stability of the live environment, these constraints must be dealt with as efficiently as possible. Simply removing steps is often not possible due to separation of duty, legal or business/project/information technology (IT) process best-practices requirements. Therefore, taking action to improve and then manage the process touch-points, workflows and inputs/outputs becomes critical to success. This article proposes a Project Lifecycle Integration Tool (PLIT) which centralizes processes and information, manages and automates workflow, and logs information necessary to monitor and improve quality of processes and output in support of an ETL development environment.
ISSN:1246-0125
2116-7052
DOI:10.1080/12460125.2013.829961