Passer au contenu de cette vue

From data base to big data UCA

L'inscription à ce cours se fait sur invitation seulement

About This Course

Many data systems exist today. The primary objective of the course is to have a conceptual grid of the different data systems by deepening the main standards.

A multidisciplinary introduction allows learners to have a strategic vision of the future of information systems around the concepts of "mobiquity and BIG DATA". Then, we present the fundamental concepts of databases and BIG DATA with their paradigms and properties in support: TIPS / ACID, RICE, WHAT / BASE and Google CABS. The Top Down and Bottom Up approaches to data integration then make it possible to explore the different paradigms of data systems.

This course is a fundamental prerequisite for all computer science students (IUT, License, Master) wishing to do a Master in new technologies like the MBDS (Mobiquity, Databases and Systems Integration) from the University of Nice Sophia Antipolis. It is also intended for IT manufacturers who want a clarification of the concepts of databases and Big Data.

This is a weekly course over 7 weeks. Each week, 4 to 9 short video sequences will be offered to participants. These sequences will be accompanied by questions and practical work, as well as discussion forums. MCQs will evaluate the knowledge at the end of each week. The teaching team will speak once a week to answer the most frequent questions of the forum through an online conference.

The weekly MCQs and the peer-reviewed practical work will be used to successfully issue the follow-up certificate.

This course is organized into 7 weekly modules :

C1 : « Spiralist innovation on Big Data systems » This module is a strategic multidisciplinary introduction around big data systems with definitions of key concepts (data paradigm, data lake, etc.) and disruptive supporting technologies which will be useful during this course.

C2 : « Data paradigms and Codd’s relational data model » There exists a plethora of big data management systems. In the first part of the course, we propose a classification of these systems using data paradigms we illustrate with SQL standard (TIPS, ACID and RICE properties). The second part concerns Codd’s relational data model which represents a formal unifying foundation and reference for big data management systems.

C3 : « SQL2 introduction » This course is devoted to SQL standard presentation (including the Transaction concept) which will be the Esperanto for big data systems with a focus here on relational structured data model.

C4 : « Third Date’s manifesto (underlying object-relational data models) » Date’s manifesto is the neutral symmetric of Codd’s model for SQL2 for hybrid object-orient data bases. We clarify the concepts of objects (OID, VALUE) which will be useful for N.O.SQL systems.

C5 « Introduction to ODMG » Object-oriented data models based upon Bancilhon’s manifesto was proposed for object programmers. ODMG is a data base extension of OMG (Object Management Group) proposed on top of Java, C++ and Smalltalk.

C6 : «Introduction to SQL3 » SQL3 is the fusion of Date’s and Stonebraker’s manifesto whose salient features are presented and discussed in this module.

C7 : « Overview of N.O. SQL and NEWS SQL » In this module we introduce N.O.SQL systems around KEY-VALUE (Hadoop, BLOB, Json Document, attributes) and GRAPHS and NEW SQL systems and identify the expected functionalities of a BIG SQL.

Requirements

MOOC level IUT, License and Master in Computer Science

Apart from a multidisciplinary strategic introduction to Information Systems of the Future, this MOOC is aimed at all computer science students (IUT, Bachelor or Mastere) or computer scientists looking for an upgrade to the standards that underlie database and big data management. The only prerequisites are from a theoretical point of view the mathematical bases of set theory and first order logic and basic knowledge of system architecture and administration of Oracle SQL databases.

Course Staff

Serge MIRANDA

Professor of University of Nice Sophia-Antipolis

Fonder of Master MBDS, innovative through its contractualized industrial partnerships that make it a real "innovation laboratory on information services of the future".

Terms of use

of the course :

Licence Creative Commons BY NC ND : the user must mention the author's name, he may exploit the work except in a commercial context, he can not create a work derived from the original work.

of the content produced by users :

Restrictive license : your production is your intellectual property and can not be reused.