Trafodion DDL will be able to invalidate objects from affected caches.

Registered by Mike Hanlon on 2014-11-06

The Trafodion compiler and SQL runtime cache definitions of Trafodion tables, compiled queries using those tables, and HTableClient objects for them. This blueprint covers a new feature to invalidate these cached objects when certain DDL operations are performed on the corresponding Trafodion tables, indexes, constraints, views, etc.

The following DDL operations are covered:
    drop table
    alter table add column
    alter table add check constraint
    alter table add unique constraint
    alter table add primary key
    alter table add foreign key (RI)
    create index
    drop column
    drop check constraint
    drop unique constraint
    drop primary key
    drop foreign key (RI)
    drop index

These DDL operations not yet covered, but may be in version 1.0.
    drop view
    alter view
    drop schema cascade
    drop synonym
    sequence generator
    drop volatile tables
    others???
These DDL operations are assumed to not need QI:
    create table
    create view
    drop schema (not cascade)
    ???
These DDL operations that are not supported
    Non-trafodion objects (e.g., native HBase tables).
    Materialized Views
    Triggers
Cache affected by QI:
   - NATable cache. This is directly visible with the NATableCacheEntries internal stored procedure, but only if not using the embedded compiler
   - Query cache, including text cache and hybrid query cache. This also is directly visible, using the QueryCacheEntries internal stored procedure, but only if not using the embedded compiler
   - Prepared, but not executing, queries Visible with the CQD AUTO_QUERY_RETRY_WARNINGS 'ON'
    - HTable cache (still to be done).

Blueprint information

Status:
Complete
Approver:
None
Priority:
Medium
Drafter:
Mike Hanlon
Direction:
Approved
Assignee:
Mike Hanlon
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
None
Started by
Suresh Subbiah on 2014-11-19
Completed by
Suresh Subbiah on 2014-11-19

Whiteboard

Gerrit topic: https://review.trafodion.org/#q,topic:bp/ddl-query-invalidation,n,z

Addressed by: https://review.trafodion.org/693
    Query Invalidation triggered by DDL, phase 1

Addressed by: https://review.trafodion.org/696
    Query Invalidation triggered by DDL, phase 2

Addressed by: https://review.trafodion.org/722
    Query Invalidation triggered by DDL, phase 3

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.