Problem definition - databases

Aim

To review the use of databases in the context of model definition.

Learning
Outcome

Ability to make ready ESP-r's standard databases and access their contents to assist the model definition process.

 

Task

Instructions

1. Edit the materials database for constructional elements.

The default materials database is a standard database which you have permission to access but not to modify. If you require a personal version you will need to firstly copy it into your own directory. The command to do this is 'cp /usr/esru/esp-r/databases/constr.db1 myconstr.db1'.

From the Project Manager menu you can then enter the Database maintenance facility and select the Materials item giving the name as myconstr.db1. You may now add, delete and edit materials in this database without affecting other users.

2. Edit the composite constructions database.

Again you must either copy the standard composite constructions database to your directory or you can create a new database and populate it as you wish. For this exercise do the former by issuing the command 'cp /usr/esru/esp-r/databases/multicon.db1 mymulticon.db1'.

You can then specify mymulticon.db1 within the databases list and edit an existing construction or create a new one by referring to the entries of the materials database. Save your modified database.

3. Browse ESP-r's optical database.

Copy the standard database so that it may be modified: 'cp /usr/esru/esp-r/databases/optics.db1 myoptics.db1'. Then specify myoptics.db1 within the databases list and browse the database. Examine how the optical properties are displayed and can be edited.

4. Edit the event profiles database.

This database contains operational schedules that may be used to define zone heat gains. Copy profiles.db1 from the usual place to myprofiles.db1 in your directory and then modify a profile and save the database.

 

next exercise        exercises menu