Design and implementation of Proposed Drawer Model Based Data Warehouse Architecture incorporating DNA Translation cryptographic algorithm for security enhancement

Data warehouse is a set of incorporated databases deliberated to protract decision-making and problem solving, espousing highly condensed data. Data warehouse happens to be increasingly accepted subject for contemporary researchers with respect to contemporary proclivity of industry and organizational purview. The focal point of the proposed work stressed on delivering an improved and an innovative model based on the existing ETL Data Warehouse model mechanism with the intent of improving security measures, which at times have been found to be reasonably undemanding and posing peril to amassed information of utmost significance. A novel algorithm was engendered based on genetic coding, keeping in mind the diverse security provisions imposed on the modified model. The formulation of the novel algorithm proposed to ensure that there would be substantial diminution of access time, keeping in mind the apposite reclamation of all requisite data from the data vaults. The relevant appliance of the proposed model might be in its employment in an assortment of organisations where accumulation of secured data is of utmost significance. The assortment of organizations might include academic/educational organisations like schools, colleges, universities, etc., corporate bigwigs, medical treatment establishments like clinics, hospitals, nursing homes, etc., private establishments and so on and so forth.