Distributed data warehouses: An other way to get exceptional performance from data warehouses
Keywords:
Distributed data warehouse,, high performance, data architecture, latency reductionAbstract
Conventional data warehouses clearly show the flaws as companies rely more & more on data-driven decision-making. Distribution of data warehouses offers a convincing answers for the problems with scalability, performance & adaptability. Unlike conventional systems that may struggle with significant data volumes & complex the searches, distributed data warehouses employ a distributed architecture to spread data processing among numerous nodes. As data needs rise, this approach not only guarantees the smooth scalability but also increases the efficiency via parallel query processing. Furthermore, distributed data warehouses can handle many types & the sources, which makes them ideal for companies dealing with varied information in actual time. This flexibility helps companies to respond quickly to changes in the market and insights by allowing comprehensive analytics and rapid reporting. Apart from improving performance, distributed data warehouses reduce single points of failure, therefore ensuring data availability during system failures.
References
1. Aji, A., Wang, F., Vo, H., Lee, R., Liu, Q., Zhang, X., & Saltz, J. (2013, August). Hadoop-GIS: A high-performance spatial data warehousing system over MapReduce. In Proceedings of the VLDB endowment international conference on very large data bases (Vol. 6, No. 11). NIH Public Access.
2. Inmon, W. H. (2005). Building the data warehouse. John wiley & sons.
3. Dageville, B., Cruanes, T., Zukowski, M., Antonov, V., Avanes, A., Bock, J., ... & Unterbrunner, P. (2016, June). The snowflake elastic data warehouse. In Proceedings of the 2016 International Conference on Management of Data (pp. 215-226).
4. March, S. T., & Hevner, A. R. (2007). Integrated decision support systems: A datawarehousing perspective. Decision support systems, 43(3), 1031-1043.
5. Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM Sigmod record, 26(1), 65-74.
6. Inmon, W. H., Strauss, D., & Neushloss, G. (2010). DW 2.0: The architecture for the next generation of data warehousing. Elsevier.
7. Kimball, R., & Caserta, J. (2004). The data warehouse ETL toolkit. John Wiley & Sons.
8. Cooper, B. L., Watson, H. J., Wixom, B. H., & Goodhue, D. L. (2000). Data warehousing supports corporate strategy at First American Corporation. MIS quarterly, 547-567.
9. Nelson, R. R., Todd, P. A., & Wixom, B. H. (2005). Antecedents of information and system quality: an empirical examination within the context of data warehousing. Journal of management information systems, 21(4), 199-235.
10.Thusoo, A., Shao, Z., Anthony, S., Borthakur, D., Jain, N., Sen Sarma, J., ... & Liu, H. (2010, June). Data warehousing and analytics infrastructure at facebook. In Proceedings of the 2010 ACM SIGMOD International Conference on Management of data (pp. 1013-1020).
11. Rainardi, V. (2008). Building a data warehouse: with examples in SQL Server. John Wiley & Sons.
12. Bȩbel, B., Eder, J., Koncilia, C., Morzy, T., & Wrembel, R. (2004, March). Creation and management of versions in multiversion data warehouse. In Proceedings of the 2004 ACM symposium on Applied computing (pp. 717-723).
13. Krishnan, K. (2013). Data Warehousing in the Age of Big Data. Morgan Kaufmann.
14. Collier, K. (2012). Agile analytics: A value-driven approach to business intelligence and data warehousing. Addison-Wesley.
15. Ghezzi, C. (Ed.). (2001). Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology (TOSEM), 10(4), 452-483
16. Gade, K. R. (2018). Real-Time Analytics: Challenges and Opportunities. Innovative Computer Sciences Journal, 4(1).
17. Gade, K. R. (2017). Migrations: Challenges and Best Practices for Migrating Legacy Systems to Cloud-Based Platforms. Innovative Computer Sciences Journal, 3(1).
18. Komandla, V. Transforming Financial Interactions: Best Practices for Mobile Banking App Design and Functionality to Boost User Engagement and Satisfaction.
19. Gade, K. R. (2017). Integrations: ETL/ELT, Data Integration Challenges, Integration Patterns. Innovative Computer Sciences Journal, 3(1).
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
