Showing results for 
Search instead for 
Do you mean 

GeoMedia G/Technology Interface - Flattened Views or Materialized Views

by Technical Evangelist on ‎03-09-2016 05:07 AM - edited on ‎04-06-2016 12:07 PM by Moderator (357 Views)


In the GeoMedia/G/Technology Interface workflow, are Flattened Views the same as Materialized Views?


To serve up the G/Technology attribution contained in the various nongraphic tables and views that make up the complex feature model of G/Technology, you need to create flattened views (or tables) containing the required attributes. These flattened views consist of a join between the graphic component table/view that was used to publish the DDC file and any other attribute tables/views that have some relation to the features contained in the DDC recordset.

Flattened views are strictly a G/Technology Interface nomenclature,.  Flattened views are just views.


Materialized views are really tables that contain the results of the view and are refreshed according to a schedule or when the base tables are updated.  They are treated as views but have the characteristics and performance of a table, They are  generally read-only.