The Invisible Database

UPDATE (Recording now available): On Tuesday, November 24, I delivered a webcast on Multi-Tenant Architectures based on the multi-tenant ideas I’ve discussed in this blog. If you are interested, you can access a recording of the webcast here.
Here is the official description for the webcast:
Cloud and Multi-Tenant Architectures with SQL [...]

[Read more →]

Previous posts (Part 1, Part 2, Part 3, and Part 4) in this series outlined the factors to consider and 4 architectures to consider when implementing a multi-tenant database system. Each of the previously described architectures kept one tenant’s data isolated from other tenants, either by storing it in completely separate databases, or [...]

[Read more →]

In the previous posts (Part 1, Part 2, and Part 3), I outlined the factors to consider, and 3 possible architectures for implementing a multi-tenant database system. The 3 models used independent database files for each tenant. In this fourth post, I will outline a model where the isolation provided by [...]

[Read more →]

In a very informative post today, my colleague Eric Farrar introduced a cool new component in the SQL Anywhere family: UltraLiteWeb
UltraLiteWeb is a browser plug-in that allows the development of robust, secure, data rich browser-based applications, and provides the ability to synchronize the data to a wide variety of enterprise systems.
UPDATE: March 3, 2010
The UltraLite [...]

[Read more →]

In my first post on Multi-Tenant Database Architectures, I outlined the various factors that must be considered when choosing a multi-tenant architecture. In my second post I examined the “Separate server” and “Shared server, separate database server process” architectures. In this third post, I will outline the “Shared database server process, Separate [...]

[Read more →]

In my last post, I outlined the various factors that must be considered when choosing a multi-tenant architecture. In this post I’ll examine the “Separate server” and “Shared server, separate database server process” architectures, and highlight the factors mentioned previously. Remember, there is no “one-size-fits-all” approach to implementing a multi-tenant database, [...]

[Read more →]

At the recent TechWave Symposium in Washington, DC, I spoke about Multi-tenant architectures with SQL Anywhere. In my talk, I outlined some of the different architectural approaches to serving up data for several customers or “tenants”.
The need for an ability to serve data for many customers usually shows up in hosted environments. This [...]

[Read more →]