ARTÍCULO
TITULO

An Overview of Data Warehouse and Data Lake in Modern Enterprise Data Management

Athira Nambiar and Divyansh Mundra    

Resumen

Data is the lifeblood of any organization. In today?s world, organizations recognize the vital role of data in modern business intelligence systems for making meaningful decisions and staying competitive in the field. Efficient and optimal data analytics provides a competitive edge to its performance and services. Major organizations generate, collect and process vast amounts of data, falling under the category of big data. Managing and analyzing the sheer volume and variety of big data is a cumbersome process. At the same time, proper utilization of the vast collection of an organization?s information can generate meaningful insights into business tactics. In this regard, two of the popular data management systems in the area of big data analytics (i.e., data warehouse and data lake) act as platforms to accumulate the big data generated and used by organizations. Although seemingly similar, both of them differ in terms of their characteristics and applications. This article presents a detailed overview of the roles of data warehouses and data lakes in modern enterprise data management. We detail the definitions, characteristics and related works for the respective data management frameworks. Furthermore, we explain the architecture and design considerations of the current state of the art. Finally, we provide a perspective on the challenges and promising research directions for the future.

 Artículos similares

       
 
Sylvain Rodat and Richard Thonig    
Solar energy is not only the most abundant energy on earth but it is also renewable. The use of this energy is expanding very rapidly mainly through photovoltaic technology. However, electricity storage remains a bottleneck in tackling solar resource var... ver más

 
Sana Rasheed and Soulla Louca    
A national population census is instrumental in offering a holistic view of a country?s progress, directly influencing policy formulation and strategic planning. Potential flaws in the census system can have detrimental impacts on national development. O... ver más
Revista: Future Internet

 
Manolis Wallace, Vassilis Poulopoulos, Angeliki Antoniou and Martín López-Nores    

 
Muhammad Tayyab Naqash, Toqeer Ali Syed, Saad Said Alqahtani, Muhammad Shoaib Siddiqui, Ali Alzahrani and Muhammad Nauman    
Sustainable urban water management is essential to handle water scarcity, leakage, and inefficient distribution. This paper covers water management in urban areas, including an introduction, an overview of water management practices, the characteristics ... ver más
Revista: Urban Science

 
Teresa Gonçalves, Rute Veladas, Hua Yang, Renata Vieira, Paulo Quaresma, Paulo Infante, Cátia Sousa Pinto, João Oliveira, Maria Cortes Ferreira, Jéssica Morais, Ana Raquel Pereira, Nuno Fernandes and Carolina Gonçalves    
This paper presents an analysis of the calls made to the Portuguese National Health Contact Center (SNS24) during a three years period. The final goal was to develop a system to help nurse attendants select the appropriate clinical pathway (from 59 optio... ver más
Revista: Future Internet