ECTS credits ECTS credits: 3
ECTS Hours Rules/Memories Hours of tutorials: 4.5 Expository Class: 14 Interactive Classroom: 14 Total: 32.5
Use languages Spanish, Galician
Type: Ordinary subject Master’s Degree RD 1393/2007 - 822/2021
Departments: Electronics and Computing
Areas: Languages and Computer Systems
Center Higher Technical Engineering School
Call: First Semester
Teaching: With teaching
Enrolment: Enrollable | 1st year (Yes)
The main objective of this course is to provide an introduction to the main concepts and technologies related to data management in IoT environments. In the first part of the course the student will become familiar with data management using the SQL language. In the second part of the course, some examples of NoSQL technologies will be presented and the problem of spatial and temporal data management will be introduced.
Theoretical lessons
Relational databases and SQL.
Parallel and distributed databases.
Data warehouses
NoSQL databases: Data modeling and data distribution, consistency and availability.
Spatial and temporal data management.
Practical lessons
Data management with SQL
Spatial and temporal data management with SQL.
Use of NoSQL Documentary databases.
Basic bibliography
Sadalage, Fowler. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison-Wesley, 2012.
Avi Silberschatz, Henry F. Korth, S. Sudarshan, Database System Concepts, Sixth edition, McGraw-Hill, 2010. ISBN 0-07-352332-1
Complementary bibliography
Shashi Shekhar, Sanjay Chawla, Spatial Databases: A tour, Prentice Hall, 2003.
Banker K., Bakkum P., Verch S., Garrett D., Hawkins T., MongoDB in Action. Manning Publications Co, 2016.
The students
- Will know the basic concepts of relational databases and will be able to use a database management system based on SQL.
- Will learn the main challenges and solutions related to distributed and parallel database architectures.
- Will know the basic concepts of data warehouses and the difference between OLAP and OLTP systems.
- Will know the main concepts related to NoSQL databases and will be able to use some of the most relevant technologies.
- Will be able to manage spatial and temporal data efficiently.
The competencies of the degree that will be considered are the following (see degree description document):
CNC10, HBL6, HBL10, HBL12 and CMP9
The methodology that will be used in this subject is based on the following set of activities, which will be carried out in person and remotely.
1.- Master classes: The master classes will provide a brief introduction to the theoretical content. Faculty will make presentations based on material that will be distributed to students.
2.- Interactive classes: In these sessions, teachers will help students follow brief tutorials on each of the selected technologies. In addition, teachers will accompany students in the use of selected technologies to solve small problems.
3.- Evaluation through exams: The exams will be held on the official dates determined in the calendar. These exams will have questions and exercises related to the theoretical and practical content of the course.
4.- Continuous evaluation: Through periodic tests or deliveries. They will mainly evaluate aspects seen in the interactive classes.
5.- Evaluation through supervised work (project): Both aspects of the theoretical and practical classes will be evaluated. Starting from an initial assumption, students must carry out a series of practical tasks that will be documented in a technical report. The evaluation will consider this report and, optionally, may require a presentation by the students.
Ordinary period:
The evaluation of the course will be divided into two parts.
1.- Exam (40%): The exam will evaluate both the theoretical and practical content. The qualification will be individual.
2.- Continuous evaluation (30%): The problems proposed by the teachers will be solved individually by the students. The evaluation may be carried out through tests and/or the delivery of small works.
3.- Supervised work (30%): It will be a work of greater size than any of those of the continuous evaluation, and it may be carried out individually or in a group.
To pass the course it will be necessary to achieve a minimum of 40% of the total score both in the evaluation of the practical work (continuous evaluation and supervised work) and in the exam, also achieving a minimum of 5 out of 10 in the average of the two parts.
Any student who submits a work or takes the exam will be considered presented.
Extraordinary period:
For the extraordinary evaluation, students will have the opportunity to redo the work from the ordinary period. In the case of continuous evaluation, it will be a single test or delivery. The qualification percentages will be identical to those of the regular period. If a student appears for a part, the grade replaces the previous one (if any), and if he does not appear, the previous grade is maintained. Any student who completes the tests or deliveries any of the 3 parts will be considered presented.
Repeating students will have to follow the same evaluation system as the rest of the students, and in no case will grades be maintained between different courses.
The expected time for study and personal work of the students estimated as follows.
Theoretical classes: 8 face-to-face hours.
Practical sessions: 16 face-to-face hours.
Individual tutorials: 8 face-to-face hours.
Personal work: 51 personal work hours.
Personal work hours will be used to prepare the theory using the material provided, and to carry out work or tests related to the rest of the activities.
It is recommended to maintain fluid communication with teachers and a participatory attitude in classes. Constant weekly work related to the activities described in the methodology is also recommended. It is advisable to have a portable personal computer on which the software used in the course can be installed.
All material related to the course will be shared through the Virtual teaching infrastructure of the involved universities. Although the tutorials, in general, will be carried out in person, at the request of the students, specific tutorials on specific topics may be carried out online.
Jose Ramon Rios Viqueira
Coordinador/a- Department
- Electronics and Computing
- Area
- Languages and Computer Systems
- Phone
- 881816463
- jrr.viqueira [at] usc.es
- Category
- Professor: University Lecturer
| Wednesday | |||
|---|---|---|---|
| 17:30-18:30 | Grupo /CLE_01 | Spanish | Aula A10 |
| 18:30-20:30 | Grupo /CLIL_01 | Spanish | Aula A10 |