Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
filereference:dbssystem [2014/11/05 20:04] enviadminfilereference:dbssystem [2022/12/06 21:53] (current) – [System Database and User/Project Database: Basic Concept] enviadmin
Line 6: Line 6:
  
 To link the information stored in the Area input files with the different database information, ENVI-met uses a [[wp> relational database]]:   To link the information stored in the Area input files with the different database information, ENVI-met uses a [[wp> relational database]]:  
-Each database entry is defined by a unique key, which has to be a **two-sign alphanumerical ID** in ENVI-met (e.g. "''a0''"). Any reference to a database entry, may it be in an Area Input file or some other table of the database  is given by using this ID. For example, if you have defined a plant "''a0''" in your plant database, you can place it on a grid by setting the ID "''a0''" to this grid point. +Each database entry is defined by a unique key, which has to be a **six-sign alphanumerical ID** in ENVI-met. Any reference to a database entry, may it be in an Area Input file or some other table of the database  is given by using this ID. For example, if you have defined a plant "''0000a0''" in your plant database, you can place it on a grid by setting the ID "''0000a0''" to this grid point. 
  
-The ENVI-met database system is a global system which is used for each simulation and all ENVI-met applications. You can define your own, individual data for single project in order to keep the whole database manageable+The ENVI-met database system is a global system which is used for each simulation and all ENVI-met applications. 
  
  
Line 14: Line 14:
 ===== Database Design ===== ===== Database Design =====
  
-[{{ :filereference:dbdesign_small.png?nolink 600 |Design of the ENVI-met database system in V4}}]+{{ :filereference:dbdesign_tables.png?nolink  |Design of the ENVI-met database system}}
  
 ==== System Database and User/Project Database: Basic Concept ==== ==== System Database and User/Project Database: Basic Concept ====
  
-ENVI-met uses two levels of databases, the **System Database** and the **User/Project Database(s)**. The two levels and the databases are identical in their structure and format, but only the User/Project Database(s) can be edited by the user. The resulting set of Database items availanle in the simulation is a merge between the items defined in the System Database and thosecoming from the User/ Project database+ENVI-met uses two levels of databases, the **System Database** and the **User/Project Database(s)**. The two levels and the databases are identical in their structure and format, but only the User/Project Database(s) can be edited by the user. The resulting set of Database items available in the simulation is a merge between the items defined in the System DB and those coming from the User/ Project DB
  
-If they all use different IDs, the resulting set will be the sum of the items in both databases. However, if you used the same ID in both the System DB and the User/Project DB, the user content in the User/Project DB will overwrite the System DB item. +If they all use different IDs, the resulting set will be simply the sum of the items in both databases with all items available. However, if you use the same ID for items in both the System DB and the User/Project DB, the user content in the User/Project DB will overwriten the System DB item. 
  
-In the example below, the System DBintroduces element: ''AA'', ''BB'' and ''CC''. In the User DB, the elements ''BB'' and ''DD'' are defined (here in red to mark their orign).  The final result of elements will be ''AA'',''BB'', ''CC'' and ''DD'' in which ''BB'' and 'DD' are the itmes defined in the User DB. The item 'BB' in the System DB will be overwritten and is not available until the item of the same ID will be removed from the User DB.+In the example below, the System DB introduces elements: ''0000AA'', ''0000BB'' and ''0000CC'' (Let's skip the first four signs for readability). In the User DB, the elements ''BB'' and ''DD'' are defined (here in red to mark their orign).  The final result of elements will be ''AA'', ''BB'', ''CC'' and ''DD'' in which ''BB'' and ''DD'' are the items defined in the User DB. The item ''BB'' in the System DB will be overwritten and is not available until the item of the same ID will be removed from the User DB.
  
-[{{ :filereference:dblogic_small.png?nolink 500 |Logic of merging database items}}+{{ :filereference:dbdesign_envimet.png?nolink 500 |Logic of merging database items}}
  
  
 +Projects using an own Project DB are display with a black folder symbol while those acessing the global User DB are shown with a white folder in the different controls of the ENVI-met applications.
  
 === System Database === === System Database ===
Line 32: Line 33:
  
 === User Database === === User Database ===
 +
 The **//User Database//** is the place where you can place all **your** personal data and settings. ENVI-met will not touch this database, even not when updating the software. However, you are responsible for the content of this database. If you add information that doesn't make sense e.g non-physical material properties, you will probably crash your simulation. The User Database is used for all projects unless you specifiy an individual project-centered database (see next paragraph). The **//User Database//** is the place where you can place all **your** personal data and settings. ENVI-met will not touch this database, even not when updating the software. However, you are responsible for the content of this database. If you add information that doesn't make sense e.g non-physical material properties, you will probably crash your simulation. The User Database is used for all projects unless you specifiy an individual project-centered database (see next paragraph).
 +
 +By default, the User Database is stored in the ENVI-met program folder under **sys.userdata**. Starting with ENVI-met 5, you can also specifiy a different location for the User Database e.g. on a netwwork drive or in the cloud. 
 +
 +Do do so, change the path options (1) in the Workspace Manager in the ENVI-met Settings tab (see below)
 +
 +{{ :apps:workspaces:workspace_changeuserdb.png?nolink 600 |Change location of the User Database}}
 +
  
 === Project Database === === Project Database ===
Line 38: Line 47:
 However, if you have a lot of different projects or very specific projects, it might not be the best idea to store all the user-defined items in one big database. Especially if you want to adjust certian properties of items, e.g. soil materials, for certain simulations or projects, it might be undesirable that these material changes will effect all other simulations as well - which will be the case if edited in the global User Database. However, if you have a lot of different projects or very specific projects, it might not be the best idea to store all the user-defined items in one big database. Especially if you want to adjust certian properties of items, e.g. soil materials, for certain simulations or projects, it might be undesirable that these material changes will effect all other simulations as well - which will be the case if edited in the global User Database.
  
-For an easier handling of data, ENVI-met gives the option to specify an individual **//Project Database//** for each project. This Project database is structured in the same way as the User Database (and the System Database), but it will only be used in simulations within the assigned project. The usage of a Project Database is optional. If no Project Database is specified, the global User Database will be used. :!: Not implemented in the Preview Versions so far+For an easier handling of data, ENVI-met gives the option to specify an individual **//Project Database//** for each project. This Project database is structured in the same way as the User Database (and the System Database), but it will only be used in simulations within the assigned project. The usage of a Project Database is optional. If no Project Database is specified, the global User Database will be used.  
  
  
Line 69: Line 79:
 ===== The Database Manager ===== ===== The Database Manager =====
  
-Although the database files follow the XML-standard, we recommend that you use our tool, the [[apps:dbmanager|Database Manager]], to organize the ENVI-met database.  +Although the database files follow the XML-standard, we highly recommend that you use our tool, the [[apps:dbmanager:start|Database Manager]], to organize the ENVI-met database. 
- +
- +
-===== Database tables ===== +
- +
-Each ENVI-met database, system or user, holds the following tables:  +
- +
-  * [[Soils]]: Properties of different natural and artificial soils +
-  * [[Soil Profiles]]:Different soil types as vertical sandwiches of soils +
-  * [[Materials]]: Basic collection of different materials that can be use in walls  +
-  * [[Walls]]: Sets of building walls and roof composed out of 3 layers of different materials +
-  * [[Single Walls]]: Sets of single and thin walls consisting of one material +
-  * [[Plants1D]]: Simple 1D plants.  +
-  * [[Sources]]: Emission profiles for different pollutant sources.+