Using views as a data interface between modules in a database
- by Stefan
Hello, I am working on the database layout of a straighforward small database in Mysql.
We want to modularize this system in order to have more flexiblity for different implementations we are going to make. Now, the idea was to have one module in the database (simple a group of tables with constraints between them) pass its data to the next module via views. In this way, changes in one module would not affect the other ones, as we can make sure in the view that the right data is present there at any time, although the underlying structure of tables might be different.
The structure of the App handling the database would likewise be modularized.
Is this something that is sometimes done?
On a technical side, as I understand views can't have primary keys - how would I then adress such a view?
What other issues should be considered?