Using views as a data interface between modules in a database

Posted by Stefan on Stack Overflow See other posts from Stack Overflow or by Stefan
Published on 2010-06-10T19:01:10Z Indexed on 2010/06/10 19:53 UTC
Read the original article Hit count: 318

Filed under:
|
|
|

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?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database