DevCon 2015: Data Modeling Using One-to-One Relationships - Mark Richman

Document created by communitymanager on May 27, 2015Last modified by mark_baum on Sep 3, 2015
Version 8Show Document
  • View in full screen mode

Mark Richman (Skeleton Key)

Session Description

Historically many of us have been trained to use one-to-many or many-to-many relationships for almost all of our data modeling needs. Along the way we’ve forgotten about a third, but no less important option – the one-to-one relationship. One-to-one relationships provide developers with a useful tool that can have a dramatic impact on how a solution is built, secured, and performs. We’ll discuss how this tool can impact solutions at scale, across different networks and in assorted use cases. This session will aim to show attendees how one-to-one relationships work, why they are useful, where they can be employed, and how to implement them. We’ll also review how they can impact other aspects of a solution.

What you should know

To get the most out of this session, an attendee should already be familiar with basic database relationship concepts, such as the difference between primary and foreign keys, and one-to-many relationships.

Products & Technologies

  • FileMaker Pro
  • FileMaker Pro Advanced
  • FileMaker Go
  • FileMaker WebDirect

What You Will Learn

  • Where one-to-one relationships fit in the data modeling toolkit and why they are useful
  • Several real-world scenarios for using one-to-one relationships
  • How to design and implement reliable one-to-one relationships
  • How to address practical secondary issues, such as importing, exporting, and reporting

 

View Session Recording


keep-space

Attachments

Outcomes