Modeling with Document Databases: 5 Key Patterns
Share this Session:
  Dan Sullivan   Dan Sullivan
DS Applied Technologies LLC


Wednesday, April 1, 2015
10:45 AM - 11:30 AM

Level:  Technical (may include code)

Document databases are more flexible in many ways than relational databases and this presents both opportunities and challenges. Poorly designed document structures adversely affect performance, increase maintenance overhead, and lead to unnecessarily complex application code. This presentation describes 5 commonly used design patters in document databases: one-to-many, many-to-many, simple table inheritance, trees and lookup patterns. Each pattern is described in sufficient detail so attendees will understand their purpose, advantages, disadvantages and when to use them. Examples are drawn from multiple application areas. The talk will also include comparison to relational database patterns for the benefit of relational modelers who are beginning to work with NoSQL databases.


  1. How to take advantage of document databases support for polymorphic schemas without introducing complex application code.
  2. How to map common relational design patterns to document databases without losing the performance benefits of a document database.
  3. How patterns are applied to document databases from multiple application areas.
  4. How to design document collections to optimize performance.
  5. When to use the 5 design patterns and when to avoid them.

Dan Sullivan is an independent data management consultant and a enterprise architect. Dan has experience in business intelligence, machine learning, data mining, text mining, data science, big data, data modeling and application design. Dan’s project work has ranged from analyzing complex data sets to designing and implementing numerous database applications. His most recent work has focused on data analysis, NoSQL database modeling, cloud computing, texting mining, application integration, and data integration in life sciences. Dan has extensive experience in relational database design and works regularly with NoSQL databases. Dan has presented and written extensively on cloud computing, analytics, data warehousing, business intelligence, NoSQL as well as other enterprise information management topics. He has worked in several industries, including: life sciences, financial services, oil and gas, manufacturing, government (military and n

Close Window