Fondamenti di Basi di Dati – Databases Essentials – DBMS Internals

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.

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 9/2021)

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.

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.

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.

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 2/2021)

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).