NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{TOC right}}
==What is the IMSMA Staging Area?==__NOEDITSECTION__
The IMSMA staging area is a '''flattened''' and '''read-only''' version of the IMSMA {{IMSMANG}} operational database. In terms of content, the data is an exact copy of the IMSMA '''approved''' information in the {{IMSMANG}} database, but the structure is much less complex and therefore easier to query. While in the operational IMSMA {{IMSMANG}} database the core object data (e.g. the ID and name of a Land) is stored in one table (e.g. in the HAZARD ''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 all the attributes of an object. Ultimately, reporting and data analysis tools can easily be connected to the staging area.<br />
A staging area can be created out of an {{IMSMANG}} v 6.0 (and higher) database. It is typically used as a '''reporting database''', via [[lightMINT]], [[MINT]] or any other [[External Reporting Tools|reporting/analysis tool]].
==Structure of the IMSMA Staging Area==__NOEDITSECTION__
===Flattening principles===__NOEDITSECTION__
{{Note | This section requires basic knowledge of the {{IMSMANG}} database table structure.}}
{| class="wikitable" width="1000"
===Database model===__NOEDITSECTION__
A simplified staging area database model for the Land (Hazard) object is depicted below. For all the other main objects, the model looks very similar.
[[Image:Staging_Area_Model_Hazard.png|center|800px700px]]
===Special table===__NOEDITSECTION__
==Geographical data in the staging area==__NOEDITSECTION__
{{Under construction| This section is under construction}}
{{NavBox Business Intelligence}}
[[Category:VIE]]
