Data warehouses have a long history. From the 1970s to the 1990s, more data warehousing tools and methods were developed and, by the 2000s, data warehouses were a real success. A lot of books and articles were written; many organizations invested a lot of money in data warehouses and solutions from Oracle, Microsoft, and other software vendors.
Some organizations believed that data warehouses were the only solution for a complex data integration problem. However, some of them faced challenges. Let's look at a use case that will show us some typical challenges and concerns.
The Republic of Prudonia as any other country has law enforcement and justice organizations. The crime level in this county is very low, and the government once even suggested converting all police forces to forestry workers, but it never happened. As of 2014, Prudonia has 15 police departments, courts, and a gaol. Each police...