Resource efficient data warehouse optimization

The amount of data increases exponentially every year, the nomenclature of data is expanded; unstructured data reaches so largely that traditional methods and approaches of data processing cannot be used. Challenges are that it is necessary to ensure the preservation and management of a huge amount of data in order to be able to efficiently analysis for solving business tasks, but also to analyze and extract valuable value from it. Today it is important to upgrade existing Data Warehouses, which will help to effectively use unstructured data. The proposed data storage reengineering methods are based on two expert rules approaches: indexing (to avoid viewing very large volumes of data) and sorting (storing data in the required order to speed up the most common queries). These methods are a partial and intermediate solution on the way to modern data processing technologies because the current technology for Big Data allows organizations to dramatically improve return on investment from their existing data warehouse environment.