Sometimes, we may want to shift some data logic from an application to the database. In order to do this, we can use two important features called views and virtual columns. These are objects that can be seen as tables or columns that are automatically populated with the data calculated by MariaDB. These features can also be used to add security to our database, or to solve some performance problems.
This chapter will cover the following topics:
Views
VIRTUALcolumnsPERSISTENTcolumns