Jump to content

Data warehouse automation

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Adsjaggs (talk | contribs) at 05:32, 25 November 2016 (→Benefits). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Data warehouse automation or DWA refers to the process of accelerating and automating the data warehouse development cycles, while assuring quality and consistency. DWA is believed to provide automation of the entire lifecycle of a data warehouse, from source system analysis to testing to documentation. It helps improve productivity, reduce cost, and improve overall quality.[1]

General

Data warehouse automation primarily focuses on automation of each and every step involved in the lifecycle of a data warehouse, thus reducing the efforts required in managing it.[2] Data warehouse automation works on the principles of design patterns. It comprises a central repository of design patterns, which encapsulate architectural standards as well as best practices for data design, data management, data integration, and data usage.[3] In November 2015, an analyst firm has published a guide Which Data Warehouse Automation Tool is Right for You? covering four of the leading products in the DWA space.[4]

Benefits

Data warehouse automation can provide advantages like source data exploration, warehouse data models, ETL generation, test automation, metadata management, managed deployment, scheduling, change impact analysis and easier maintenance and modification of the data warehouse.[5] More important than the technical features of DWA tools, however, is the ability to deliver projects faster and with less resources.[6]

==References==undefined# http://www.datawarehousemanagement.org/download/free_files/Documents/Whitepaper-Barry-Devlin-Data-warehouse-done-final.pdf; Quipu datawarehouse management Retrieved 12 May 2016

CIO Magazine Award - 20 Most promising productivity tools 'CIO Review', November 10, 2015

See also

  1. ^ "Automate and accelerate your data transformations". www.attunity.com. Attunity. Retrieved 7 December 2015.
  2. ^ "New Buzzword! Data Warehouse Automation". blogs.jetreports.com. jetreports. Retrieved 7 December 2015.
  3. ^ "Data Warehouse Automation - A Decision Guide" (PDF). www.wherescape.com. David L. Wells, Infocentric LLC. Retrieved 7 December 2015.
  4. ^ "Which Data Warehouse Automation Tool is Right for You?". eckerson.com. Wayne Eckerson. Retrieved 9 December 2015.
  5. ^ "Data Warehouse Automation (DWA)?". timextender.com. TimeXtender Software 2015. Retrieved 7 December 2015.
  6. ^ "Deliver Faster". kalido.com. Magnitude Software. Retrieved 9 December 2015.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Data_warehouse_automation&oldid=751366162"