It’s asher backwards, yo!

SaaS database design

design11

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.

design2

12/02/2009 - Posted by | Work stuff | , , ,

1 Comment »

  1. [...] 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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.