SYSTEMS AND METHODS FOR QUERY AND INDEX OPTIMIZATION FOR RETRIEVING DATA IN INSTANCES OF A FORMULATION DATA STRUCTURE FROM A DATABASE

Systems and methods are provided for query and index optimization for retrieving data in instances of a formulation data structure from a database. The methods include presenting an information source for searching for the presence of formulations and generating formulation data from field entries. The formulation data is associated with found formulations. The methods include generating an instance of a formulation data structure. The instance of the formulation data structure associates the information source with the found formulations. The methods include creating optimized index data from retrieved data in the instance of the formulation data structure. The optimized index data includes a mapping between potential search-field terms and the formulation data, and is grouped based on a predicted access pattern. The methods include running a search query across the optimized index data and providing information associated with an information source associated with retrieved data in an instance of a formulation data structure.