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

[Claudius T. <cla...@gm...>]

Dear Dr. Vandana Jha,

Maybe would be helpful to have in eXist-DB some master files, arranged in
what hierarchy you might consider as being adequate, and these master files
to contain the information to be indexed by eXist-DB and path(s) to the
PostgreSQL repository/

You can generate these master files by using one or more XQuery scripts,
and you can keep them synchronized with the PostgreSQL repository's files
by running the XQuery script(s) periodically.

Best regards,
Claudius Teodorescu

On Tue, 26 Mar 2024 at 11:42, 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... <van...@ki...>
> http://www.scc.kit.edu
>
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open
>


-- 
Cu stimă,
Claudius Teodorescu