Software as a Service: Designing a multi-tenant data architecture using DB2 V9

Designing a multi-tenant data architecture requires a decision on the degree of database and schema sharing. This demo focuses on a shared schema architecture and shows how the XML capabilities of DB2 V9 simplify tenant data configuration.

Mary Taylor (marytaylor@us.ibm.com), Senior IT Architect, IBM

Author Photo: Mary TaylorMary Taylor is a senior software engineer. She is working in the Strategic Technology Architecture and Incubation team, and she is currently working on an SOA CBS pilot. Her interests include DB2 and DataStage.



08 October 2007

Designing a multi-tenant data architecture requires a decision on the degree of database and schema sharing. This demo focuses on a shared schema architecture and will show how the XML capabilities of DB2® V9 simplify tenant data configuration.

System requirements

You'll need JavaScript™ enabled in your browser.

Transcript

Get the demo transcript (2MB).

Sample implementation artifact for building SaaS solutions on IBM middleware

Download this XSD file containing the DB2 V9 XML column schema for the CustomerProfile column used in the CustomerProfile table in the sample banking application : CustomerProfile.xsd (3KB).

Duration

Less than 10 minutes.

Resources

Learn

Get products and technologies

  • Download IBM product evaluation versions and get your hands on application development tools and middleware products from DB2®, Lotus®, Rational®, Tivoli®, and WebSphere®.

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=324600
SummaryTitle=Software as a Service: Designing a multi-tenant data architecture using DB2 V9
publish-date=10082007