Re: [Exist-open] How to index the files without uploading them in eXist DB

[Dr. V. J. <vjv...@gm...>]

Dear Craig,

As the files which I am storing are XML files, I need an XML database to
retrieve the contents. My requirements are not only full text search but it
might be required to retrieve some parts of XML in XML structure with some
predefined conditions. Right now, my data is stored in PostgreSQL, which is
getting indexed by ElasticSearch and later I have some GUI in java,
javascript and Springboot. ElasticSearch is not sufficient for some cases
so I am looking for XML database and may be get it working for all my
requirements and remove ElasticSearch requirement.

But thanks for bringing this up and posting me the helpful link.
Thanks & Regards,
Dr. Vandana Jha

Data Exploitation Methods (DEM),
Scientific Computing Center (SCC),
Karlsruhe Institute of Technology (KIT)

Hermann-von-Helmholtz-Platz 1
76344 Eggenstein-Leopoldshafen
Karlsruhe, Germany.
E-mail: van...@ki...
http://www.scc.kit.edu

On Tue, Mar 26, 2024 at 1:51 PM Craig Berry <cra...@ma...> wrote:

> Do your PostgreSQL tables have those line and chapter numbers?  If so, why
> not query them directly using full text search:
>
> https://www.postgresql.org/docs/current/textsearch.html
>
> and avoid eXist altogether?
>
> That assumes that word search is the only feature of eXist you're
> interested in, which may not be the case.
>
> > On Mar 26, 2024, at 4:41 AM, Dr. VANDANA JHA <vjv...@gm...>
> wrote:
> >
> > Dear Support Team,
> >
> > I have a repository of TEI-XML files stored in PostgreSQL and my
> requirement is to index this file so that it can be queried for the line
> number and chapter number of a particular word in the document.
> >
> > I guess, I can populate that same repository contents in eXist-DB and
> then index it. But as this PostgreSQL repository is a small part of a big
> project and due to other more important requirement, I have to keep this
> repository.
> >
> > So my question is,
> > Is it possible to set somewhere path to this PostgreSQL repository in
> eXist-DB and then use these stored file and directory structure in eXist-DB
> to index/work with them? So here I want to skip the process of storing
> these files again in eXist-DB. This will serve two purpose for me. First
> the data will not be duplicated at two places so it will save the effort in
> data consistency. Second, this data will be updated may be later and always
> I want the data to be read from my postgreSQL and eXist DB should be doing
> read only task and not write into these files so it will be perfect for me,
> if by setting path, it reads from the original repository itself.
> >
> > Any help in this regard, will be really appreciated.
> >
> > Thanks & Regards,Dr. Vandana Jha
> >  Data Exploitation Methods (DEM),
> > Scientific Computing Center (SCC),
> > Karlsruhe Institute of Technology (KIT)
> >
> > Hermann-von-Helmholtz-Platz 1
> > 76344 Eggenstein-Leopoldshafen
> > Karlsruhe, Germany.
> > E-mail: van...@ki...
> > http://www.scc.kit.edu
> >
> > _______________________________________________
> > Exist-open mailing list
> > Exi...@li...
> > https://lists.sourceforge.net/lists/listinfo/exist-open
>
> ________________________________________
> Craig A. Berry
>
> "... getting out of a sonnet is much more
>  difficult than getting in."
>                  Brad Leithauser
>
>