2.7.3. Database schema

In the following paragraph, the tables of the relational schema are displayed graphically and described in detail. The description is based on the remarks on UML charts in Section 2.6. Focus is put on situations where the conversion into tables leads to changes in the model.

• 2.7.3.1. Metadata Model
• 2.7.3.2. Core Model
• 2.7.3.3. Tables for geometry representation
• 2.7.3.4. Appearance Model
• 2.7.3.5. Building Model
• 2.7.3.6. Bridge Model
• 2.7.3.7. CityFurniture Model
• 2.7.3.8. Generic Objects and Attributes
• 2.7.3.9. LandUse Model
• 2.7.3.10. Digital Terrain Model
• 2.7.3.11. Transportation Model
• 2.7.3.12. Tunnel Model
• 2.7.3.13. Vegetation Model
• 2.7.3.14. WaterBody Model
• 2.7.3.15. Sequences

The figures are taken from Oracle JDeveloper, which allows to design different diagrams and reuse already defined tables. JDeveloper (v12.2.1) was used to design the database schema and extract SQL DDL scripts automatically for Oracle databases. It is a freeware IDE by Oracle and can be downloaded at: http://www.oracle.com/technetwork/developer-tools/jdev.

For PostgreSQL databases the Open Source tool pgModeler (v0.8.2) has been used to maintain the schema. Packed installers can be purchased at http://pgmodeler.com.br/ or the user compiles the software from the source code available at GitHub (https://github.com/pgmodeler/pgmodeler).

Starting from version 3.0.0 of the 3DCityDB the corresponding schema modelling projects are shipped with the release and can be edited by the user to create customized SQL scripts. However, the 3DCityDB Import/Export tool only supports the default schema, unless it is not reprogrammed against the user’s new database schema.