Articles & Content

Archives

How to Design a Hybrid XML/Relational Database Schema

Topic: DB2 for LUW

Subtopic: 2012



While traditional relational columns in DB2 hold atomic data values, XML columns can store documents that represent complex business objects, such as financial trades, insurance contracts, tax returns, or medical records. Since DB2 Version 9, Database and application designers can choose a mix of relational and XML columns to represent and store their data. However, traditional database design concepts, such as normalization, are insufficient to design databases that combine XML and relational data. This session presents trade-offs and guidelines for designing a hybrid XML/relational database schema. We also review two real DB2 pureXML applications and describe the design considerations that have led to their respective hybrid schema. Learn how to decide which data should be in relational columns vs. XML columns, and how to balance performance vs. flexibility in a hybrid database design.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.