Fondamenti
di Basi di Dati

A. Albano, G. Ghelli, R. Orsini

Il libro, dal 1997 al 2018 disponibile in forma stampata, pubblicato dall’Editore Zanichelli, e da gennaio 2019 disponibile gratuitamente on-line in una versione aggiornata nei contenuti e nella grafica. In questo sito, oltre al testo, si trovano soluzioni agli esercizi, approfondimenti, materiale di supporto al corso per il docente e per lo studente, collegamenti utili, ecc.


Copyright 2019-2021 A. Albano, G. Ghelli, R. Orsini

Si concede il diritto di riprodurre gratuitamente questo materiale con qualsiasi mezzo o formato, in parte o nella sua interezza, per uso personale o per uso didattico alle seguenti condizioni: le copie non sono fatte per profitto o a scopo commerciale; la prima pagina di ogni copia deve riportare questa nota e la citazione completa, incluso il titolo e gli autori. Altri usi di questo materiale inclusa la
ripubblicazione, anche di versioni modificate o derivate, la diffusione su server o su liste di posta, richiedono un permesso esplicito preventivo dai detentori del copyright.


Scarica il libro (versione 3/2024)

Scarica la soluzione degli esercizi (versione 9/2021)

Databases
Essentials

A. Albano

This little book presents the principal topics in the database area that every computer scientist and information systems professional should be familiar with: (a) Information modeling and Databases Conceptual Design with an Object Data Model; (b) Information modeling and Databases Logical Design with the Relational Data Model; (c) Operations on a relational database with Relational Algebra and the SQL language;  (d) Architecture of a Data Base Management System (DBMS) and SQL query processing.


Copyright 2015-2021 A. Albano

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that the first page of each copy bears this notice and the full citation including title and author. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission from the copyright owner.


Download the book (version 12/2020)

Download the solution of the exercises (version 12/2020)

DBMS Internals

A. Albano, G. Ghelli

The book presents the basic concepts of classical centralized DBMS implementation. Database systems occupy a central position in our information-based society, and computer scientist and database application designers should have a good knowledge about  both the theoretical and the engineering concepts that underline these systems to ensure the desired application performance. The book starts with an analysis of relational DBMS architecture and then presents the main structures and algorithms to implement the modules for the management of permanent memory, the buffer, the storage structures, the access methods, the transactions and recovery, the concurrency, the cost-based query optimization. Finally, an overview of physical database design and tuning is presented.


Copyright 2015-2021 A. Albano, G.Ghelli

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that the first page of each copy bears this notice and the full citation including title and author. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission from the copyright owner.


Download the book (version 11/2021)

Download the solution of the exercises (version 11/2021)

Decision Support Databases Essentials

A. Albano, S. Ruggieri

In our information-based society one of the most important applications for computers is information storage and management with a DBMS  to support organizations both in performing the business and in bringing the business  to the Web to allow new routes to market. It is also well known that information overload is a huge challenge for businesses, but it is also an enormous opportunity in making smarter decisions based mainly on  data  analysis to improve productivity. Consequently, starting from  the 1990s another important application of information storage and management  to support organizations  is analyzing the business  with data-driven Decision Support Systems  designed for summarizing  large amounts of data into a form that is useful and easily interpretable to help managers to analyze  the performance of key business processes, worthy of improvement.


Copyright 2015-2021 A. Albano, S. Ruggieri

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that the first page of each copy bears this notice and the full citation including title and author. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission from the copyright owner.


Download the book (version 12/2023)

Software

Questo sito contiene anche due sistemi didattici, che possono essere scaricati e usati liberamente: il JRS, (un sistema relazionale per esercitarsi con SQL, ottimizzazione delle query, piani logici e fisici), e il Normalizzatore Relazionale Web (per esercitarsi con dipendenze funzionali e schemi relazionali).

This site also contains two didactic systems, which can freely downloaded: the JRS,  (a relational system to practice with SQL, query optimization, logical and physical plans), and the Web Relational Normalizer, (to practice with functional dependencies and relational database schema normalization).