System and method for efficient management of a search database for retrieving context-based information

A method of retrieving context-based information relating to a search query, wherein the method is implemented using a database, the database comprising:

• a 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 the nodes, and
• a search database configured to store an inverted index of the plurality of documents in the columnar database, wherein the inverted index stores, corresponding to a given document, a 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;
• wherein the method comprises
• receiving the search query;
• identifying at least one concept relating to the search query, using the ontological database;
• and
• identifying at least one document, from the columnar database, relating to the search query based on the at least one concept relating to the search query.