In recent days healthcare domains need a efficient storage and retrieval systems to provide a effective medical services to the health seekers. But there is a vocabulary gap in understanding the medical terminologies due to ambiguity. So, the existing systems need a intelligent medical storage using some natural language processing. Users post their queries in free text so it will result in complexity for analyzing and providing instant answers. The main aim of this paper is to develop an intelligent medical data warehousing and mining system. This system can be performed by assigning corpus-aware terminologies to the medical records. This system provides efficient answers to the health seekers by extracting the information related to their queries. © 2017 IEEE.