For the moment we index documents (Word, excel, pdf, ppt, html, xml...) from the filesystem and it works well.

Now, we need to attach some informations on each documents and we must be able to search on these attributes, for instance :

We can index a Word document and we would like some additionnal index informations like :


These informations are stored in a table, the table contains also the path to the documents on the filesystem.

We are able to query a text on the index mixed with a filter on the columns above.

We tought with the solution to store these informations directly in the index, but we don't know if it's a good solution (in term of speed, structure...)

So, Is there any solution to index the documents on the filesystem with extra information at index time ?

Is it possible ? How can we do that ?
What do you think about that ?

Thanks by advance