How to add relationships between custom post types?

Let’s say i have a sample post called “avatar” in “movie”, “trailer”, “review” and “details” custom post types.

How can i display in the “movie” custom post type the content + links to “trailer”, “review” and “details” custom post types ?

Ideally, you’d want to cast your vote into adding the infamous post2post relationship, which is still missing:

http://core.trac.wordpress.org/ticket/14513

In the meanwhile, the workarounds are three:

1. Map your posts to specially crafted taxonomies. (slow)
2. Store relationships in postmeta. (very slow if you ever need to use that in a join statement)
3. Create your own post2post table.