Trends in Data Warehousing Techniques

Financial data volumes are increasing, and this appears to be a long-term trend, implying that data management development will be crucial over the next few decades. Because financial data is sometimes real-time data, it is constantly generated, resulting in a massive amount of financial data produced in a short period of time. The volume, diversity, and velocity of Big Financial Data are highlighting the significant limitations of traditional Data Warehouses (DWs). Their rigid relational model, high scalability costs, and sometimes inefficient performance pave the way for new methods and technologies. The majority of the technologies used in background processing and storage research were previously the subject of research in their early stages. The Apache Foundation and Google are the two most important initiatives. For dealing with large financial data, three techniques outperform relational databases and traditional ETL processing: NoSQL and NewSQL storage, and MapReduce processing