Description

This course will train students in the competencies necessary to design and configure analytical databases, evaluating the different possible alternatives in the context of their company. Concepts of generic relational databases (applicable to decision-making environments for data storage) are dealt with, in order to further study non-relational alternatives, also known as NOSQL managers, most appropriate for Big Data environments. First, data warehouse concepts and then key-value and columnars and architectures (distributed and in memory) will be presented alternatives to relational databases in certain scenarios. An introduction to the design and configuration of non-relational databases is also included, emphasizing the configuration in analytical environments and, including massive data processing in functional style environments. The knowledge given is essential to face the tasks of the data engineer.