Building Data Warehouses Using Automation

Abstract

Software development is a complex endeavor. While significant benefits can be achieved, the process is often laborious, time consuming and error prone requiring multiple iterations in order to achieve the desired result. Issues arise for numerous reasons – coding defects, unclear requirements, migration challenges, lack of convention, and inadequate testing to name a few. When convention and automation are introduced into the software development lifecycle there are significantly fewer opportunities for failure. Automation also allows for shorter development windows. Generally there are fewer errors throughout testing, with the bulk of those being found in unit and functional testing, far before the users get involved in systems acceptance testing. A data warehouse consists of multiple subject areas in which many tasks are common and should be automated for the sake of efficiency and enforcing convention. This article discusses a set of tools that can be used to automate writing data warehouse objects. The article also provides statistics of time saved using automation.

Research on Digital Power Grid Information Integration Solution

“…At the same time, the information communication of digital power grid has hierarchical characteristics. [3][4] Power grid information is acquired from the power grid through the acquisition device, mainly through the power dispatching data network and the like transmission to the dispatching control center. Power dispatching data network uses power fiber and microwave to establish broadband and High-performance network platform.…”