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

Level: Introductory

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

08 Oct 2007

	View the demo.

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

• Read about DB2 V9's XML capabilities in this developerWorks article, "What's new in DB2 Viper, XML to the core".
  
  
• Discover DB2 family of products .
  
  
• Get started with IBM Software as a Service programs for business partners. Link to case studies, research documents, and current events.
  
  
• Explore how the capabilities of IBM DB2 address the issues of data architecture and data security in this developerWorks article, "Build a multi-tenant data tier with access control and security".
  
  
• Browse the technology bookstore for books on these and other technical topics.
  
  

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

• Check out developerWorks blogs and get involved in the developerWorks community.
  
  

About the author

		Mary 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.

Rate this content

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top