Hello,
Please find below.
On Tue, Dec 24, 2024 at 9:08 AM Nikola Smolenski <smolen...@unilib.rs>
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.
It's a challenge for data integration/ETL. Note: Solr and others are doc
DBs implying stored views or data marts.
We build such stored views via denormalizing data for optimizing particular
operations: search, filtering, aggregations.
However, such derived data representation has its own costs for building
and updating.
> Additionally, there could be additional author
> information, such as external identifiers, that needs to be connected to
> the author.
>
Ad-hoc RDBMS joins aren't really available with document DBs (see above),
however there are some similar operations with their own limitations:
{!parent}, {!join}, and something else.
>
> On Mon, Dec 23, 2024 at 11:07 PM Dmitri Maziuk <dmitri.maz...@gmail.com>
> wrote:
>
> > 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 smarter way of doing this? What are the
> best
> > > practices?
> > >
> >
> > A book is a "document" that has a title and authors as separate fields.
> > Documents usually also have a "big search" field, called _text_ in the
> > default config.
> >
> > Copy both author list and title into _text_, search in _text_, facet on
> > authors and/or titles.
> >
> > Dima
> >
> >
>
--
Sincerely yours
Mikhail Khludnev
