The following presentation is a joint work with Giorgio Orsi on Software Refactoring, is one of the intermediate product of the course Argomenti Avanzati in Ingegneria del Software (Advanced Topic of Software Engineering). It is just a summa of the existing approaches, and some of our opinions on how a disciplined Refactoring can help to reduce the gap between Research and Didactic, by help in the integration of student activities (Projects and Thesis) in the main stream of professors research. Refactoring can indeed fill up the gap from the so called student-ware and the final software.
Category: Activities
This category contains small activities in discussed in BLOG like fashion.
NSPACE = CO-NSPACE
For the course ADVANCED TOPICS ON ANALYSIS AND DESIGN OF CRITICAL SYSTEMS i attended in Politecnico di Milano in 2007, I had to study and present the Neil Immerman proof of NSPACE = CO-NSPACE. This is the small presentation i prepared with Simone Campanoni. We present the two available proofs Szelepcsènyi’s and Immerman’s. I hope this will make someone life easier.
Delta Debugging
Delta Debugging is a cool, fascinating debugging method by prof. Andreas Zeller. I wrote a paper [italian] about it with Alessandro Giusti, as homework for a PhD course in Advanced Software Engineering, in Spring 2005; powerpoint slides of presentation. Alessandro also shortly described it for a non technical audience in an article at NewsForge.
Mysql information_schema dump: a nice workaround
A nice workaround of Giuseppe Maxia to dump the mysql
information_schema:
http://www.oreillynet.com/databases/blog/2006/04/dumping_mysql_information_sche_1.html
I’ve personally tested it on a couple of servers and worked smoothly.
DB2: INSTEAD OF TRIGGERS
DDL TRIGGERS: Oracle is the way.
MySQL: no support for DDL triggers yet, they are part of the “remote”
TODOs, we will probable not see them for a long time. ( I tried to
install trigger on the <tt>information_schema</tt> with no results,
since the information_schema is in general a virtual DB.)
DB2: has no direct support for DDL triggers, workaround are possible
using the tracing functionalities http://database.ittoolbox.com/groups/technical-functional/db2-l/ddl-triggers-1147710
. As discussed here also in DB2 triggers on the
<tt>information_schema</tt> are not possible.
Oracle and SQL Server 2005: support DDL triggers.
The server environment we are operating is Linux based, I’ll go for
Oracle.
Here there is a short reference to DDL-triggers in Oracle:
http://www.psoug.org/reference/ddl_trigger.html
Debian sid. I’m going to use to actually install Oracle 11g on Ubuntu
6.06 LTS.
MySQL views: 200 views chain limit?
I’m doing some stress test with MySQL on views…
If someone plans to repeat the test , this is the script for generating the views: