[teiid-issues] [JBoss JIRA] (TEIID-2584) Add management features to materialization

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2584.
---------------------------------

        Labels: Beta3  (was: )
    Resolution: Done


1) If an view is configured for external materilization, if it needs to be
managed by the Teiid scheduler for loading the below properties need to be
defined
2) The view is expected to be populated with following properties
teiid_rel:ALLOW_MATVIEW_MANAGEMENT = allow the auto management
teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT = script for loading the mat view table
teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT = script to run before load; like truncate tables
teiid_rel:MATVIEW_LOAD_SCRIPT = script to run after load; like swap/rename tables
teiid_rel:MATVIEW_STATUS_TABLE = name of the status table.
MATERIALIZED_TABLE = materialized table
3) The above properties expects the status table to be in the format
CREATE TABLE status
(
vdbname varchar(50) not null,
vdbversion integer not null,
schemaname varchar(50) not null,
name varchar(256) not null,
targetschemaname varchar(50),
targetname varchar(256) not null,
valid boolean not null,
loadstate varchar(25) not null,
cardinality integer,
updated timestamp not null,
primary key (vdbname, vdbversion, schemaname, name)
);
4) A SYSADMIN.loadMatView and SYSADMIN.matviewStatus procedures are provided
that will load the materialization results and manage the status of the load
in the status table defined above.
5) During the VDB deployment a timer sevice is started to run the above
load procedure at defined CacheHint intervals defined by the original View.
                
> Add management features to materialization
> ------------------------------------------
>
>                 Key: TEIID-2584
>                 URL: https://issues.jboss.org/browse/TEIID-2584
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: Beta3
>             Fix For: 8.5
>
>
> Currently Teiid supports internal and external materialization features. The internal is managed completely by the Teiid query engine along with the infinispan cache. 
> External materialization is completely unmanaged and left out to the user to manage it externally. This goals for this feature are unify the materialization logic for internal and external, such that both are managed similarly irrespective of the type of materialization chosen. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira