title: Using Lucene like a relational database
body: <p>I am just wondering if we could achieve some RDBMS capabilities in lucene.</p>
  
  <p>Example:
  1) I have 10,000 project documents (pdf files) which have to be indexed with their content to make them available for search.
  2) Every document is related to a SINGLE PROJECT. The project can contain details like project name, number, start date, end date, location, type etc.</p>
  
  <p>I have to search in the contents of the pdf files for a given keyword, but while displaying the results I want to display the project meta data as mentioned in point (2).</p>
  
  <p>My idea is to associate a field called projectId with each pdf file while indexing. Once we get that, we will fire search again for getting project meta data.</p>
  
  <p>This way we could avoid duplicated data. Also, if we want to update the project meta data we will end up updating at a SINGLE PLACE only. Otherwise if we store this meta data with all the pdf doument indexes, we will end up updating all of the documents, which is not the way I am looking for.</p>
  
  <p>please advise.</p>