Data warehousing is the collection of data from a range of sources, over the course of several years. This method is ideal for the collection of Big Data because a data warehouse enables the storage of a large volume of information.
Data warehousing combines data from several sources, although the information should be imputed consistently to ensure the ease of extraction and comparison. Data warehousing can have a specific focus or a more generalised purpose, depending on the reason it serves for the business.
The data stored must be safe, reliable and easy to manage and examine. The information collected is used for analysis, where patterns, trends and abnormalities are identified; these findings assist organisations with their decision making. Data warehouses can also be used when two systems are required to merge or function together, as it can create a common view while leaving the separate systems untouched.
Jobs that utilise data warehouses include: