Well you have several ways. Do you want to do it with JAVA oder the ETL 
plugin?

In any case I think it should be

Vertices: Author, Book
Edge: WROTE

WDYT?

Am Montag, 20. Oktober 2014 10:51:03 UTC+2 schrieb Bojan Vukotić:
>
> Hi guys!
>
> The whole discussion here is how to create edges from one table to 
> another, but what to do if we have more complex cases where we have 
> connected 2 (or even more) tables? Example, n:n relation: book and authors, 
> book can have one or more authors and author can work on one or more books.
>
> Tables:
>
> Book {
>        book_id
>        book_name, 
>         ....
> }
>
> Author {
>       author_id,
>       author_name, 
>       ......
> }
>
>
> Author_on_Book {
>        ab_id,
>        book_id,
>        author_id,
>        description // describes what this author did on this book 
> }
>
> How to migrate this case? Should "Author_on_Book" be migrated as a vertex 
> or edge? How to write scripts in this case? (in real life we could have 
> even more foreign keys in "Author_on_Book" table )
>
>
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to