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

Video created by mark_baum on Sep 3, 2015

    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 Materials