NoPublic, bureaucrat, administrator
1,068
edits
Changes
Created page with "{{TOC right}} ==What's the IMSMA Staging Area?== The IMSMA staging area is a ''flattened'' version of the IMSMA operational database. In terms of content, the data is an exac..."
{{TOC right}}
==What's the IMSMA Staging Area?==
The IMSMA staging area is a ''flattened'' version of the IMSMA operational database. In terms of content, the data is an exact copy of the IMSMA database, but the structure is much less complex and therefore easier to query. While in the operational IMSMA database the core object data (e.g. the ID and name of a Land) is stored in one table (e.g. in the HAZARD table) and descriptive attributes (such as single- and multi-select standard and custom defined fields) are stored in separate tables, in the staging area all this information is available in one single table. Therefore, there is no need to write complex queries to get to the core information. Ultimately, reporting and data analysis tools can easily be connected to the staging area.
==Structure of the IMSMA Staging Area==
===Main object tables===
===Other tables===
===Geographical data===
===Database diagrams===
==The IMSMA Staging Area Generator==
==What's the IMSMA Staging Area?==
The IMSMA staging area is a ''flattened'' version of the IMSMA operational database. In terms of content, the data is an exact copy of the IMSMA database, but the structure is much less complex and therefore easier to query. While in the operational IMSMA database the core object data (e.g. the ID and name of a Land) is stored in one table (e.g. in the HAZARD table) and descriptive attributes (such as single- and multi-select standard and custom defined fields) are stored in separate tables, in the staging area all this information is available in one single table. Therefore, there is no need to write complex queries to get to the core information. Ultimately, reporting and data analysis tools can easily be connected to the staging area.
==Structure of the IMSMA Staging Area==
===Main object tables===
===Other tables===
===Geographical data===
===Database diagrams===
==The IMSMA Staging Area Generator==
