[teiid-issues] [JBoss JIRA] (TEIID-2456) Create quick start to demonstrate using persisted costing information from a repository

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12771025#comment-12771025 ] 

Van Halbert commented on TEIID-2456:
------------------------------------

Here's the quick start overview of what will be performed:

-  Use default H2 database and setup JNDI reference
-  run DDL to create the table to persist stats:
-  extend the default MetadataRepository logic, so that the stats will be pulled from the H2 database, above.
-  deploy a vdb that fronts the H2 database
-  use the Hibernate quick start as an example of providing CRUD access to H2 database

This would demonstrate the how the Metadata Repository can be extended to persist the stats, and provide the Teiid runtime engine access to up-to-date stats.

The demo would allow the person to enter the stats, run a sql test and see the cardinality was being used, by viewing the QueryPlan.

The next step on this would be to add a mechanism for reading the stats from a datasource and updating the stats table.   And then providing a scheduler to update the stats on an ongoing basis. 


                
> Create quick start to demonstrate using persisted costing information from a repository
> ---------------------------------------------------------------------------------------
>
>                 Key: TEIID-2456
>                 URL: https://issues.jboss.org/browse/TEIID-2456
>             Project: Teiid
>          Issue Type: Task
>          Components: Build/Kits
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>
> Create a quick start that will demonstrate Teiid obtaining costing information at runtime from a repository.

--
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