Re: Multiply connected data search

2025-01-04 Thread Walter Underwood
more elegant solution. I believe I have found > it, but I haven't checked whether it's faster also. I believe it should be > faster, in principle, since Solr is just doing internally what I have to do > externally anyway. A more elegant solution should also be easier to buil

Re: Multiply connected data search

2025-01-04 Thread Walter Underwood
more elegant solution. I believe I have found > it, but I haven't checked whether it's faster also. I believe it should be > faster, in principle, since Solr is just doing internally what I have to do > externally anyway. A more elegant solution should also be easier to buil

Re: Multiply connected data search

2025-01-04 Thread Nikola Smolenski
lly anyway. A more elegant solution should also be easier to build and improve upon. -Original Message- > From: Nikola Smolenski > Sent: Thursday, December 26, 2024 6:17 AM > To: users@solr.apache.org > Subject: Re: Multiply connected data search > > I agree, solr should no

RE: Multiply connected data search

2024-12-30 Thread Andrew Witt
helps. Andrew Witt Senior Software Engineer II Learning A-Z, a Cambium Learning® Group Company andrew.w...@learninga-z.com -Original Message----- From: Nikola Smolenski Sent: Thursday, December 26, 2024 6:17 AM To: users@solr.apache.org Subject: Re: Multiply connected data search I agree, so

Re: Multiply connected data search

2024-12-26 Thread Nikola Smolenski
I agree, solr should not be used as the primary data store. However, it would still be handy to be able to retrieve as much information in a single query as possible. I am experimenting with a solution where every solr document has "otherids" multivalued field, with books having the ids of all the

Re: Multiply connected data search

2024-12-24 Thread Walter Underwood
Do not use Solr as your primary data store. Solr is not a database. Put your data in a relational database where it is easy to track all those relationships and update them correctly. Extract the needed fields and load them into Solr. This can be a daily full dump and load job. That is what I

Re: Multiply connected data search

2024-12-24 Thread Dmitri Maziuk
On 12/24/24 00:07, Nikola Smolenski wrote: Thank you for the suggestion, but that wouldn't work because there could be multiple authors with the same name, who differ only by ID. If I were to change the name of an author, I wouldn't know which one should I change and which one should stay. Additi

Re: Multiply connected data search

2024-12-23 Thread Mikhail Khludnev
Hello, Please find below. On Tue, Dec 24, 2024 at 9:08 AM Nikola Smolenski wrote: > Thank you for the suggestion, but that wouldn't work because there could be > multiple authors with the same name, who differ only by ID. If I were to > change the name of an author, I wouldn't know which one sho

Re: Multiply connected data search

2024-12-23 Thread Nikola Smolenski
Thank you for the suggestion, but that wouldn't work because there could be multiple authors with the same name, who differ only by ID. If I were to change the name of an author, I wouldn't know which one should I change and which one should stay. Additionally, there could be additional author info

Re: Multiply connected data search

2024-12-23 Thread Dmitri Maziuk
On 12/23/24 15:49, Nikola Smolenski wrote: ... About the only way of doing this I can think of is to perform the search, get all the found books and authors, then perform another query that fetches all the books and authors referenced by any of books or authors in the first query. Is there a smar