SYSTEM AND METHOD FOR EFFICIENT MANAGEMENT OF A SEARCH DATABASE FOR RETRIEVING CONTEXT-BASED INFORMATION

A system and method for efficient management of a search database for retrieving context-based information, system including a database and processor, wherein the database includes columnar database for storing a plurality of documents, an ontological database configured to represent a plurality of concepts as nodes in a network and relationships between the concepts as edges between nodes and the search database configured to store an inverted index of the plurality of documents in the columnar database. Herein, the processor is configured to identify, using the ontological database, a set of concepts in each of the plurality of documents and store, in the search database, corresponding to a given document the set of concepts identified in the given document, and secondary concepts relating to the given document, wherein a secondary concept has a direct relationship in the network with at least one of the concepts in the set.