SaaS database design

This was my initial design for the database, but according to one of my colleagues this design isn’t ideal as far as performance requirements go…
I implemented a data type lookup table, but this approach would require the application to cast the varchar “values” into the respective data type.
Instead, this approach seems more suited. My objection to it was that it includes a lot of null values.

1 Comment »
Leave a Reply
-
Archives
- February 2009 (5)
-
Categories
-
RSS
Entries RSS
Comments RSS

[...] Dos formás de llevar a cabo la arquitectura multitenancy.- El multitenancy es uno de los pilares clave del software como servicio que genera economías de escala derivadas de la optimación de recursos físicos y humanos. Este blog dibuja dos esquemas de base de datos para poder llevarlo a cabo. [...]
Pingback by Semanario - Semana 7/2009 | Saasmania | Software como servicio - SaaS | 16/02/2009