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