This document explains how to create an application from an existing relational database.

Step 1 - Reverse from database

This tutorial shows you how to build a sustainable application. Almost all the available features in Sustainable IDE are demonstrated, from reverse engineering (to start from an existing project) to the reports development based on BIRT.

Step 2 - Design

Step 2.1 Design Question

This tutorial shows how to adapt class diagram with Sustainable IDE (SIDE) when get from an existing database.

Step 2.2 Design Result

This tutorial shows how to adapt the class diagram (Result part) get through the reverse engineering of the existing application.

Step 3 - Generate and use

This tutorial shows how to generate the resulting application from class diagram.

Step 4 - Add view on classes

This tutorial shows how to define views on classes to give a name to content nodes.

Step 5 - Add new view

This tutorial shows how to define views on classes to display data, for example, in dhtml grid with filtering, dynamic scrolling and sorting features already included. This view is different from the previous one which only defines the content name.

Step 6 - SQL for Alfresco and BIRT Report

This tutorial shows how to design BIRT reports on the true relational data model, automatically generated from the class diagram. In contrast with the Alfresco data model that is content oriented, the SIDE data model is highly structured data oriented and contains a table for each content type, which makes writing SQL model a piece of cake.

Step 7 - Portal Diagram Design

This tutorial shows how to design a portal diagram to structure content and link it with views defined in class diagram.