Data warehouse automation: Difference between revisions
Content deleted Content added
No edit summary Tags: Mobile edit Mobile web edit Advanced mobile edit |
m →External links: Task 24: elink template removal following a TFD |
||
| (16 intermediate revisions by 10 users not shown) | |||
| Line 1: | Line 1: | ||
'''Data warehouse automation''' ('''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 |
'''Data warehouse automation''' ('''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 [[Systems analysis|system analysis]] to [[Software testing|testing]] to [[documentation]]. It helps improve productivity, reduce cost, and improve overall quality.<ref>{{cite web|title=Automate and accelerate your data transformations|url=http://www.attunity.com/products/prepare-data-compose|website=www.attunity.com|publisher=Attunity|accessdate=7 December 2015}}</ref> |
||
It helps improve productivity, reduce cost, and improving overall quality.<ref>{{cite web|title=Automate and accelerate your data transformations|url=http://www.attunity.com/products/prepare-data-compose|website=www.attunity.com|publisher=Attunity|accessdate=7 December 2015}}</ref> |
|||
==General== |
==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.<ref>{{cite web|title=New Buzzword! Data Warehouse Automation|url=http://blogs.jetreports.com/2015/03/05/new-buzzword-data-warehouse-automation/|website=blogs.jetreports.com|publisher=jetreports|accessdate=7 December 2015}}</ref> |
Data warehouse automation primarily focuses on automation of each and every step involved in the [[Information lifecycle management|lifecycle]] of a data warehouse, thus reducing the efforts required in managing it.<ref>{{cite web|title=New Buzzword! Data Warehouse Automation|url=http://blogs.jetreports.com/2015/03/05/new-buzzword-data-warehouse-automation/|website=blogs.jetreports.com|publisher=jetreports|accessdate=7 December 2015}}</ref> |
||
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.<ref>{{cite web|url=https://www.wherescape.com/media/1988/data-warehouse-automation-decision-guide.pdf|title=Data Warehouse Automation - A Decision Guide|website=www.wherescape.com|publisher=David L. Wells, Infocentric LLC|accessdate=7 December 2015}}</ref> |
Data warehouse automation works on the principles of [[Software design pattern|design patterns]]. It comprises a central repository of design patterns, which encapsulate architectural standards as well as best practices for [[Database design|data design]], [[data management]], [[data integration]], and data usage.<ref>{{cite web|url=https://www.wherescape.com/media/1988/data-warehouse-automation-decision-guide.pdf|title=Data Warehouse Automation - A Decision Guide|website=www.wherescape.com|publisher=David L. Wells, Infocentric LLC|accessdate=7 December 2015}}</ref> |
||
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.<ref>{{cite web|title=Which Data Warehouse Automation Tool is Right for You?|url=http://eckerson.com/register?content=which-data-warehouse-automation-tool-is-right-for-you|website=eckerson.com|publisher= Wayne Eckerson|accessdate=9 December 2015}}</ref> In November 2015, an international software and technology services company engaged in developing |
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.<ref>{{cite web|title=Which Data Warehouse Automation Tool is Right for You?|url=http://eckerson.com/register?content=which-data-warehouse-automation-tool-is-right-for-you|website=eckerson.com|publisher= Wayne Eckerson|accessdate=9 December 2015}}</ref> In November 2015, an international software and technology services company engaged in developing ‘[[Agile software development|agile]] tools’ for the data integration industry, was named by CIO Review as one of the 20 most promising productivity tools solution providers 2015.<ref>{{cite web|title=CIO Magazine Award - 20 Most promising productivity tools|url=http://analytixds.com/latest_news/analytix-data-services-wins-cio-reviews-2015/|website=www.analtyixds.com|publisher=AnalytiX DS|accessdate=25 November 2016}}</ref> |
||
==Benefits== |
==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.<ref>{{cite web|title=Data Warehouse Automation (DWA)?|url=http://www.timextender.com/software/data-warehouse-automation/business-value/|website=timextender.com|publisher=TimeXtender Software 2015|accessdate=7 December 2015}}</ref> |
Data warehouse automation can provide advantages like source [[data exploration]], warehouse data models, [[Extract, transform, load|ETL]] generation, [[test automation]], [[metadata management]], [[Deployment management|managed deployment]], scheduling, change impact analysis and easier maintenance and modification of the data warehouse.<ref>{{cite web|title=Data Warehouse Automation (DWA)?|url=http://www.timextender.com/software/data-warehouse-automation/business-value/|website=timextender.com|publisher=TimeXtender Software 2015|accessdate=7 December 2015}}</ref> More important than the technical features of data warehouse automation tools, however, is the ability to deliver projects faster and with less resources.<ref>{{cite web|title=Deliver Faster|url=http://kalido.com/products/kalido-information-engine/deliver-faster/|website=kalido.com|publisher=Magnitude Software|accessdate=9 December 2015}}</ref> |
||
More important than the technical features of DWA tools, however, is the ability to deliver projects faster and with less resources.<ref>{{cite web|title=Deliver Faster|url=http://kalido.com/products/kalido-information-engine/deliver-faster/|website=kalido.com|publisher=Magnitude Software|accessdate=9 December 2015}}</ref> |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
*[[WhereScape]] |
|||
==References== |
==References== |
||
| Line 16: | Line 20: | ||
==External links== |
==External links== |
||
* {{Dmoz|Computers/Software/Databases/Data_Warehousing/Data_Warehouse_Automation|Data Warehouse Automation}} |
|||
* [http://analytixds.com/wp-content/uploads/2016/07/analytix-data-services-top-20-cio-review.pdf CIO Magazine Award - 20 Most promising productivity tools 'CIO Review', November 10, 2015] |
* [http://analytixds.com/wp-content/uploads/2016/07/analytix-data-services-top-20-cio-review.pdf CIO Magazine Award - 20 Most promising productivity tools 'CIO Review', November 10, 2015] |
||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
{{Data_warehouse}} |
{{Data_warehouse}} |
||
Latest revision as of 07:47, 19 October 2024
Data warehouse automation (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
[edit]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] In November 2015, an international software and technology services company engaged in developing ‘agile tools’ for the data integration industry, was named by CIO Review as one of the 20 most promising productivity tools solution providers 2015.[5]
Benefits
[edit]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.[6] More important than the technical features of data warehouse automation tools, however, is the ability to deliver projects faster and with less resources.[7]
See also
[edit]References
[edit]- ^ "Automate and accelerate your data transformations". www.attunity.com. Attunity. Retrieved 7 December 2015.
- ^ "New Buzzword! Data Warehouse Automation". blogs.jetreports.com. jetreports. Retrieved 7 December 2015.
- ^ "Data Warehouse Automation - A Decision Guide" (PDF). www.wherescape.com. David L. Wells, Infocentric LLC. Retrieved 7 December 2015.
- ^ "Which Data Warehouse Automation Tool is Right for You?". eckerson.com. Wayne Eckerson. Retrieved 9 December 2015.
- ^ "CIO Magazine Award - 20 Most promising productivity tools". www.analtyixds.com. AnalytiX DS. Retrieved 25 November 2016.
- ^ "Data Warehouse Automation (DWA)?". timextender.com. TimeXtender Software 2015. Retrieved 7 December 2015.
- ^ "Deliver Faster". kalido.com. Magnitude Software. Retrieved 9 December 2015.