Materialized Views store the results of a MySQL query in a table. When data in the database changes, Flexviews materialized views can be updated efficiently using the row change information that has been captured, instead of building the whole view again. The row change information is captured using FlexCDC, a change data capture tool for MySQL. Since the contents of the view are stored in tables, indexes can be added to the views and they can be accessed in milliseconds instead of potentially minutes or hours to run the SQL statement that underlies the views.

Flexviews is part of Swanhart-Tools and includes both the change data capture utility, and a small SQL API for creating and maintaining the views.

This talk will introduce Flexviews, the SQL API and FlexCDC.