wiki:db/Views

Version 2 (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...

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