Challenges in Transitioning from Traditional Data Warehousing to Modern Data Architectures
International Journal of Science and Research (IJSR)

International Journal of Science and Research (IJSR)
Call for Papers | Fully Refereed | Open Access | Double Blind Peer Reviewed

ISSN: 2319-7064


Downloads: 3 | Views: 115 | Weekly Hits: ⮙3 | Monthly Hits: ⮙3

Research Paper | Computer Science and Information Technology | United States of America | Volume 13 Issue 12, December 2024 | Popularity: 5.4 / 10


     

Challenges in Transitioning from Traditional Data Warehousing to Modern Data Architectures

Aneehika Nellutla


Abstract: The transition from traditional data warehouses, such as SQL Server, to modern data architectures like the Medallion architecture, has introduced a paradigm shift in data management and processing. This paper explores the challenges faced during this transition, particularly focusing on differences in scalability, schema design, data partitioning, and query optimization. It also examines the implications of adopting distributed systems and new technologies, highlighting the practices that need adaptation. By addressing these challenges, organizations can fully realize the potential of modern data platforms.


Keywords: Modern Data Warehouse, Traditional Data Warehouse, Medallion Architecture, MPP Systems, Scalability, Data Partitioning, Query Optimization, Schema-on-Read, Real-Time Processing, Distributed Systems


Edition: Volume 13 Issue 12, December 2024


Pages: 1320 - 1322


DOI: https://www.doi.org/10.21275/SR241215083913



Make Sure to Disable the Pop-Up Blocker of Web Browser


Text copied to Clipboard!
Aneehika Nellutla, "Challenges in Transitioning from Traditional Data Warehousing to Modern Data Architectures", International Journal of Science and Research (IJSR), Volume 13 Issue 12, December 2024, pp. 1320-1322, https://www.ijsr.net/getabstract.php?paperid=SR241215083913, DOI: https://www.doi.org/10.21275/SR241215083913