[rules-users] processing a database with many to many Relationships

[Dave Potts]

Most of the drools examples that I seen, will for have an example that 
process address, look for address with a given post/zip code etc on a 
data source that is already loaded in the knowledge session, but it 
include no description of how the data was loaded in the knowledge session.

I have a reference database of trading containers , the database 
describes the source, destination, contents etc, relationships between 
for example a container may have have many sources and many 
destinations.  Destinations and sources may be shared between different 
containers.

The database is normalised to keep source/destination information as a 
single place table, with link tables to define the relationship between 
the different containers and places

Q. What is the best way of loading my information in to a knowledge 
session?

Expand all the many to many relationship in to a  single pojo objects 
with multiple references to other pojos or is there a better way?

source                                                 destination
eg Container foo                      England,                        
England
                                                  England               
                     France
                                                  England               
                     Scotland
                                                  France                 
                     England
                       bar                      England                 
                 Germany
                                                  England               
                     France

regards


Dave.

/*
*/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20140408/32512ea5/attachment.html