ZEMCH 2015 - International Conference Proceedings | Page 277

The database consists of the following tables:
• profili (id, nome, descrizione, spessore_up, spessore_fc);
• profili_vetri(id, nodo_sigla, id_tipologia, id_profilo, id_vetro, ue, uf, ufc, nodo_img, nodo_img_
base, nodo_img_flusso);
• regioni(id, regione);
• tipologie(id, nome, img_tipologia, numero_sezioni);
• vetri(id, nome, descrizione, spessore, tipo, gas, ug);
• zone_climatiche(id, codice_regione, codice_provincia, codice_comune, sigla_provincia, comune, altitudine_slm, gradi-giorni, zona_climatica, uw);

Figure 7: Profiles_glasses table data stored in the database (SQLite file)
The class DBManager then manages the connections and queries to the SQLite database file.
When you start the program the method initDatiTabelle instantiates DBManager to call the get
methods needed populate the tables displayed in the main GUI StartJFrame. Tables are populated
in the following order: “Climatic Zones”, “Regions”, “Type of the frame”, “Frame profiles”, “Glazing”.
It is also populated the table “Nodes”, not visible in the GUI, containing the data of the sections of
interest for the combination calculation is currently selected. Table rows “Nodes” are obtained by
querying the frames_glasses table stored in the SQLite file.
At startup it will already be selected all the elements needed to define a complete combination
of calculation: climate data, type and size of the fixture, type of frame profile, glazing. A check is
made to see whether the selected combination is allowable.
This check is also made during the selection phase of the elements (eg. glass selected may have a
thickness greater than that allowed by the profile).
If the combination is possible, it is retrieved the list of the sections of interest in relation to the
selected fixture type.
Each list item is associated with a pair of images: an image with the elements seen in cross-section
and an image showing the evolution of heat flow.
This element is represented by an object from the class NodoInfisso. This is characterized by the
attributes related to the constituent components of the selected combination.

Software for the heat flow evaluation of the nearly-zero houses

275