Information Systems

18h L / 6h R / 3 ECTS credits / SINF

Véronique Alanou et Marie-Aude Aufaure (Gif), Cédric Cocquebert (Gif), Bernard Jouga (Rennes), Patrick Mercier (Metz), Stéphane Vialle (Gif)


The information system is a critical resource for every enterprise.This course presents the common architectures and concepts of the two main components: communication networks and data bases.


An introduction to distributed data and processing Disadvantages of centralized schemes, assets of distributed and parallel architectures: example, the client-server model. Generic services: file sharing, directories, mail, Web. The new Peer-to-Peer paradigm. Data portability. Applications architecture: two tiers, 3 to N tiers, transaction-oriented, ORB, OTM. Problems raised by a distributed approach: information consistency, critical paths, global time synchronisation. Communication systems architecture Network architectures and layered models: components (access networks, transport networks, network controlers, circuit and message switching, routing); functions (addressing, multiplexing, segmentation, error and flow control, real time requirements); OSI model (services, connectionless and connection-oriented modes), protocols, PDU, gateways, example of the TCP/IP protocol stack. Applications examples: C/S, Web (HTML encoding and HTTP protocol). Network communication interfaces: sockets, RPC, CORBA. TCP and IP protocols. Ethernet local area networks. The public telephonic switched network PTSN. Data bases General overview: history, DBMS components, data model and data base schema notions, the main data base systems (relational, OO, RO). Relational model and relational algebra. Data base design: from UML to the relational model, standardization. A short introduction to SQL: specification, management and query language. Request optimisation. Queries consistency and concurrent access. Client/Server and distributed DBMS. An introduction to Data Warehouse and Data Mining.


Glossary

CORBA: Common Object Request Broker Architecture, C/S: Client-Server, HTML: Hypertext Markup Language, DBMS: Data Base Management System, HTTP: HyperText Transfer Protocol, IP: Internet Protocol, OO: Object Oriented, ORB: Object Request Broker, OTM: Object Transaction Monitor, PDU: Protocol Data Unit, RO: Relation Oriented, RPC: Remote Procedure Call, SQL: Structured Query Language, TCP: Transmission Control Protocol, UML: Unified Modelling Language Bibliography G. Gardarin, «Bases de données», Ed. Eyrolles, 2001. G. et O. Gardarin, «Le Client-Serveur», Ed. Eyrolles, 1996. G. Pujolle, «Les réseaux», Ed. Eyrolles, 2002. A. Tanenbaum, «Réseaux», Ed. Dunod, 2000.

 


Dernière modification : 07/04/2011