Abstract: 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.

Abstract: 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.

Abstract: A system and method of regularizing data between a data source and a data destination, wherein the given data category includes with specific data fields. The system includes a data processing arrangement that includes a data fetching module operable to fetch data from the data source. Furthermore, the data processing arrangement includes a data transformation module that is operable to receive pre-defined data formats for a specific data category, compare data formats of the fetched data with pre-defined data formats, determine a deviation therein, and thereafter transform the data format. Additionally, the data processing arrangement includes a data validation module operable that is to receive the transformed data or the fetched data, confirm if data formats of a received data are same as corresponding pre-defined data formats, identify from the received data regularized data, and transmit the regularized data to the data destination implemented as database arrangement.

Abstract: Disclosed is system for optimizing search query to retrieve set of documents, system comprising client device configured to receive search query and provide set of documents; lexical database comprising plurality of concepts, and conceptual synonyms of plurality of concepts; structured database communicably coupled to lexical database, wherein structured database is developed by: extracting plurality of documents; analyzing plurality of documents to determine concept corresponding to plurality of documents; and indexing plurality of documents, wherein given document is indexed based on concept corresponding to given document, and conceptual synonyms of concept; and server arrangement communicably coupled to client device, lexical database and structured database, wherein server arrangement is configured to: receive search query, from client device; segment search query into query segments; analyze query segments to determine concepts; identify, conceptual synonyms of concepts; and retrieve set of documents ba