Hello again
The problem is that the software is used in different fields. The table
schema for hospital software is not the same as in the industrie sectors.
Customers usually create their own schema. The worst case scenary that we
know is that there are four tables connected.
Table patient --> visit --> study --> image
So if a patient has 10 visits each visit has 10 studies and each study has
40 images then we would need to update 4000 documents just because some
values changed in the patient row.
Example queries are quite difficult because the change from customer to
customer. But a normal query would look like.
query:q=(patient___idpatient__:"55" AND ((image_user__:*admin*) AND
((image_double_:{* TO 0.1} OR image_double_:{99.1 TO *})) AND
(image_text:*fiji*)))
But basicly our customers can define their searchfields on their own.
I already tried out the JOIN capability but I couldn't find out how to join
over more then 1 table. I think denormalizing is the better solution then
try to join the tables durning the query.
What I had in my mind was some kind of reference fields or somethig.
So that in a image document you could refer to the connected patient fields.
But I don't know if something exists.
What i am now trying is to reduce the update fields. This will speed up the
delta import time but i am not sure if this is the "best practice"
Regards Sandro
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-Near-Realtime-with-denormalized-Data-tp4022072p4022351.html
Sent from the Solr - User mailing list archive at Nabble.com.
