Checking date: 30/05/2022


Course: 2022/2023

Data architecture
(19473)
Study: Bachelor in Computer Science and Engineering (218)


Coordinating teacher: MORENO LOPEZ, LOURDES

Department assigned to the subject: Department of Computer Science and Engineering

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Files and databases (2 course / 2 semester)) Programming (Course: 1 / Semester: 1) Data Structures and Algorithms (Course: 1 / Semester: 2) Computer Structure (Curso: 2 / Cuatrimestre: 1)
Skills and learning outcomes
Link to document

Description of contents: programme
Introduction - Data life cycle - Data governance. Metadata management. Data quality management. - Structured and unstructured data storage - Relational and NoSQL databases. ACID and BASE architectures Relational Database Management - Database administrator. Functions. Tools. Cloud services. - Transaction processing. Concurrency control. - Recovery. - Security and Confidentiality. Integrity. Multidimensional data stores - Introduction to data warehouses - The multidimensional model - Multidimensional architectures Distributed storage systems - General concepts of Distributed Information Systems - Distributed architectures. Principles of design. Distributed query processing. - Distributed file systems. HDFS. Hadoop technologies. NoSQL databases - Introduction to NoSQL systems. - Types of NoSQL systems: Key-value Pair Based, Document-oriented, Column-oriented, and Graphs-based. - NoSQL Database Management
Learning activities and methodology
* Lectures: 1 ECTS. The objective is to present theoretical concepts and techniques for designing and managing storage systems and architectures. * Practical/Lab sessions: 1 ECTS. The objective is the development of specific instrumental skills, as well as problem-solving skills and application of knowledge. * Continuous assessment tests (individual work): 1ECTS. The objective is to complete the development of the specific instrumental skills and start the development of the specific attitudinal skills, as well as the transversal skills of problem-solving and application of knowledge. * Projects (in-group): 2.5 ECTS. The objective is to complete and integrate the development of all the specific skills related to the resolution and implementation of practical cases where the problem statement, the choice of resolution method, the results obtained, and their interpretation are well documented. * Tutorials: individualized assistance (individual tutorials) or group (collective tutorials) to students by the teacher. * Final exam: 0.5 ECTS. The objective is the development of specific cognitive and procedural abilities. It especially reflects the use of master classes.
Assessment System
  • % end-of-term-examination 50
  • % of continuous assessment (assigments, laboratory, practicals...) 50
Calendar of Continuous assessment
Basic Bibliography
  • Elmasri, Ramez, Navathe, Sham.. Fundamentals of database systems. Pearson Addison Wesley.. 2017
  • Ramakrishnan, Raghu, Gehrke, Johannes. Database management systems. McGraw-Hill. 2003
Additional Bibliography
  • Andreas Meier & Michael Kaufmann. SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management, . Springer. 2019
  • Bradshaw, S., Brazil, E., & Chodorow, K. . MongoDB: the definitive guide: powerful and scalable data storage. . O'Reilly Media.. 2019
  • Evren Eryurek, Uri Gilad, Valliappa Lakshmanan, Anita Kibunguchy, Jessi Ashdown. Data Governance: The Definitive Guide: People, Processes, and Tools to Operationalize Data Trustworthiness. O'Reilly Media. 2021
  • Ian Robinson, Jim Webber, Emil Eifrem. Graph Databases. 2nd. edition.. O'Reilly Media. 2015
  • Rahimi, S. K., & Haug, F. S.. Distributed database management systems: A Practical Approach. . John Wiley & Sons. 2010
  • Redmond, E. &Wilson. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement. The Pragmatic Bookshelf. 2010
  • Sadalage, P. & Fowler. . NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pearson Education. 2013

The course syllabus may change due academic events or other reasons.