Code: S1934, ECTS: 3
The aim of this course is to pass on know-how that is useful to any engineer:
- designing structured and coherent information systems;
- executing them in a practical fashion and exploiting them to advantage.
knowledge of data structures, such as those acquired through basic comprehension of the first-year course on algorithms, would be useful. Even if the course contains very little programming, a reasonable interest in computer science is indispensable.
- introduction to databases: motivations, 3-tier server-customer architectures, transactions, data models, commercial and free markets for database software (Oracle, Sybase, DB2, Acces, SQL Server, Postgres, MySQL, etc.), integration within the web context, presentation of I.S. careers;
- modelling of data with the Entité-Association model: entities, attributes, associations, keys;
- the relational model: definitions, normal forms, integrity constraints, redundancy, etc., and its mathematical bases, relational algebra: relational and assembly operators. Creation, interrogation and manipulation of data with the SQL language (relational layout, selection, insertion, updating, junction, involvement);
- safety, security and performance: views, indexing, administration, duplication, request optimization. Interfacing with a programming language: example of JDBC for Java. XML format exchanges of data;
- illustrations and applications with case studies: Geographical Information Systems, financial decision-making systems, identification systems (fingerprint bases), scaling of complex information systems;
- the course comprises at least 50% practical work. Visits and/or lectures may take place.
Pierre GUILLOU ; Claire MEDRALA|
Graduate 1st year
|Nb. of hours
|Nb. of lessons
09 Jun 2016 08:59 by f.coelho