wiki:db/Views

Version 1 (modified by jbecla, 6 years ago) (diff)

--

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 rename columns
  • use a view to hide columns
  • use a view to to provide a one-table view of a group of tables which are really one logical table

Notes:

  • views are not very portable between different RDBMSes!