Group of semi structured protein data bank files are read and the data warehouse is created , Unified data structure is defined. The system itself finds the data type of the tables, and the data were inserted. Meta-data is created, to know what are all the protein data banks were available in the data warehouse. The system can able to give user specification in an easy way because of the unified structure.