Hi,

i have a data base with 5 “tables”( collection) in access and i want to make the same data base in tamino, i have relations between the 5 tables …

i have to do a new collection with a schema who contents 5 doctypes or 5 collections with 5 schemas …???


and to have relations in tamino, how have to do???



thanks !!!

#webMethods
#Tamino
#API-Management

Hi,

I believe, you slightly misunderstand these things.

Compared to a relational database, compare these:

• database <=> database
  
• collection <=> schema
  
• schema <=> No equivalence, think of it
  as a set of tables
  
• document type <=> table
  

Note the hierarchy!

In other words: If your “tables” are related (most probably they are!), it is quite likely,
that you want to have them in the same collection. It is, of course, possible, to
combine documents from various collections into
a single query. However, it is a little bit
more complex and possibly also slower, because
of the additional overhead.

#webMethods
#Tamino
#API-Management

Hi

thanks for you response …

but i have an another problem …

i have a schema with 5 doctypes, who are my 5 tables access, and i want to related them … but i try with the nodeRef but that’s make an error …

i have a

schema cinetheque_schema
doctype film, dvd, type, client, commande

and i want to related : film/id with dvd/film …



Thanks

#webMethods
#API-Management
#Tamino

Hi

using nodeRef is possible, but using XQuery-based join functionality is much more flexible and should be the preferred way of solving such an issue.

Best regards
Uli

#webMethods
#Tamino
#API-Management