NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The IMSMA staging area is a '''flattened''' and '''read-only''' version of the {{IMSMANG}} operational database. In terms of content, the data is an exact copy of the '''approved''' information in the {{IMSMANG}} database, but the structure is much less complex and therefore easier to query. While in the operational {{IMSMANG}} database the core object item data (e.g. the ID , status and name of a Land) is stored in one table (e.g. in and other information about the ''hazard'' table) and descriptive attributes Land (such as single- and multi-select standard and custom defined fields) are stored in separate tables, . Furthermore in the {{IMSMANG}} information are also stored with enumeration values and as links between objects. In the staging area all this information is available flattened in one single tablefor each item. Therefore, there is no lesser need to write complex queries to get to all the retrieve 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]]such as Excel or ArcGIS.
{{NavBox Business Intelligence}}
[[Category:VIE]]