wiki:db/Views
Last modified 6 years ago Last modified on 03/22/2013 10:09:33 AM

Views

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

Use cases: use a view to...

  • hide columns
  • join similarly partitioned tables (eg Source x Object)
  • join small dimensions tables (star schema)
  • join a table that has been split into several tables, eg Object_core, Object_extras, Object_photoZ etc

Only power users will be able to define new views in production.

Notes:

  • views are not very portable between different RDBMSes!