Course MI202 · Year II · Autumn 2019-2020

Advanced database storage and exploitation techniques

Compulsory course in Advanced programming and databases, taught by Maria Loredana Oroian Boca.

This course page is from 2019-2020 and is archived.
See this course for the current academic year

Overview

Lecturer
Maria Loredana Oroian Boca
Seminar tutor
Maria Loredana Oroian Boca
Type of course
Compulsory
Language of instruction
English
Erasmus language
English
Domain
Computer Science - Masters
Field of study
Advanced programming and databases
Form of education
Full-time
Form of instruction
Lecture
Credit awarded by
Grade
Teaching methods
lectures, examples, exercises
Entry requirements
-database, programming, data annalist

Aims

Solving concrete practical problems that include elements of data structures and algorithms, programming

Development of programs in a general and / or specific programming language, starting from the specification of the requirements and until the execution, debugging and interpretation of the results

Use of techniques for conceptual modeling of data;

Acquiring knowledge of the types of models and modeling tools used in software application development

Course contents

1. Database systems architectures; 2. SQL Advanced. SQL Union, Blind, Injection; 3. Object based database and XML; 4. Unified Modelling Language (UML). Transaction management; 5. Big data analysis; 6. Hadoop architecture and implementation; 7. MapReduce flow design. 8. SQL interaction with MapReduce;

Learning outcomes

a) systematic knowledge about the methodologies for making software products b) familiarization with modern concepts and concerns in writing the application software c) knowledge of the types of models and modeling tools used in the development of software applications d) the necessary motivation regarding the importance of the documentation of the soft products, in all the phases of the life cycle

Assessment

project developing

Recommended reading

A Brief Guide to the Standard Object Modeling Language
Fowler, M., Scott, K.: UML Distilled
Addison-Wesley, 2nd ed, 2012
Software Engineering - A Practitioners Approach
Pressman, R.S
McGraw-Hill, 6rd ed, 2009
Agile Modeling Homepage
-
http://www.agilemodeling.com, -, 2019
Big data overview -Tools and Techniques, Discoveries and Pitfalls
-
https://web.stanford.edu/class/cs102/lecturenotes/Overview102.pdf, 2019