Basi Di Dati Atzeni Ceri Paraboschi Torlone Pdf Writer
Funzioni disponibili Risorse bibliografiche Risorsa bibliografica obbligatoria Risorsa bibliografica facoltativa Scheda Riassuntiva Anno Accademico 2016/2017 Scuola Scuola di Ingegneria Industriale e dell'Informazione Insegnamento 089183 - DATA BASES 2 Docente Cfu 5.00 Tipo insegnamento Monodisciplinare Corso di Studi Codice Piano di Studio preventivamente approvato Da (compreso) A (escluso) Insegnamento Ing Ind - Inf (Mag.)(ord. 270) - MI (474) TELECOMMUNICATION ENGINEERING - INGEGNERIA DELLE TELECOMUNICAZIONI * M ZZZZ 089183 - DATA BASES 2 Ing Ind - Inf (Mag.)(ord. 270) - MI (481) COMPUTER SCIENCE AND ENGINEERING - INGEGNERIA INFORMATICA * M ZZZZ 089183 - DATA BASES 2 Programma dettagliato e risultati di apprendimento attesi Transactional Systems. Why transactional systems are relevant. Examples of transactional systems: financial applications, banks, online order-entry (e-commerce), online booking, 'wall-street applications'. Notion of 'transaction'.
Distributed Databases: Principles and Systems. By Carol Batini, Shamkant B. Navathe, Stefano Ceri. By Paolo Atzeni, Riccardo Torlone, Stefano Ceri, Stefano Paraboschi. Database Systems - Concepts, Languages and Architectures Paolo Atzeni, Stefano Ceri, Stefano Paraboschi and Riccardo Torlone. [4] XML 1.0: W3C Recommendation (Third Edition), 04 February 2004 [5] P.Atzeni, S.Ceri, P.Fraternali, S.Paraboschi, R.Torlone, 'Basi di Dati - Architetture e linee di evoluzione', The McGraw-Hill Companies srl, Milano, 2003. Paragrafo 4.5. [6] Unicode Home Page: http://www.unicode.org/.
ACID properties: atomicity, consistency, isolation, durability. Concurrency control theory. Histories (or schedules), serializability, various notions of equivalence, complexity of testing. View-serializability, conflict-serializability.
Two phase locking. Hierarchical locking. Deadlock analysis and resolution. Timestamp-based concurrency control. Multi-version concurrency control. Implementation of locking in commercial systems. Sandy Denny Box Set Rar Password there. Reliability control theory.
Notion of: stable storage, logging, checkpointing, write-ahead log rule, commit rule. Recovery protocols: warm restart, cold restart. Implementation of reliability control in commercial systems. Commit protocols, theory of two-phase-commit, presumed-abort and read-only optimisations, non-blocking protocols (3 and 4 phase commit protocols). Implementation of commit protocols with heterogeneous DB servers in the X-open standard. Database architectures.