Useful data sources are on the rise and business users are continuously demanding faster access to data due to the increased pace of change in data warehouse design. Data warehouses are no longer static or simplistic in design, but with automation the building and maintenance of a new data warehouse becomes easier than ever before.
In today’s business and technology landscape, if something can be automated, it probably should be automated...In our view, WhereScape RED excels at delivering value in data at the speed that business needs it...
– Robin Bloor, Chief Analyst, The Bloor Group
The Immediacy of the Data Warehouse
The data warehouse (DW) is a fixture of enterprise computing, whose importance is increasing. Not so long ago, a data warehouse was designed to remain fairly static with a slow pace of change. Businesses reluctantly accepted the wait time associated with requests for new reports and specialized data marts. Data analysis was often performed on data that was days – if not weeks or months – old. Data warehouse maintenance and tuning were hand coded. In many cases, the business had no choice but to employ their own IT staff who were invested heavily in the design process.
Those days are over or rapidly coming to an end. Big Data has seen to that. The data warehouse is no longer a static creature. New data sources are added or created on a regular basis, sometimes daily. Business rules and requirements have become a prominent driver in how data gets modeled and delivered. All of this places a strain on the once-simple data warehouse design and makes maintenance far more difficult than it once was.
To read more please download the full White Paper below.