Changes between Version 1 and Version 2 of db/Views


Ignore:
Timestamp:
03/22/2013 05:09:33 PM (6 years ago)
Author:
jbecla
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • db/Views

    v1 v2  
    33It is probably inevitable qserv will need to deal with views. The information about views sufficient for qserv to handle it appropriately can be kept in the qserv metadata. 
    44 
    5 Use cases: 
    6  * use a view to rename columns 
    7  * use a view to hide columns 
    8  * use a view to to provide a one-table view of a group of tables which are really one logical table 
     5Use cases: use a view to... 
     6 * hide columns 
     7 * join similarly partitioned tables (eg Source x Object) 
     8 * join small dimensions tables (star schema) 
     9 * join a table that has been split into several tables, eg Object_core, Object_extras, Object_photoZ etc  
     10 
     11Only power users will be able to define new views in production. 
    912 
    1013Notes: 
    1114 * views are not very portable between different RDBMSes! 
    12