With the increase of data information on oil exploration and development, some departments have set up databases.

Nevertheless, as exploration and development belong to different branches, two isolated big information islands have come into

being. Therefore, a solution must be put forward which combines the exploration with development. This plan can not only

implement the data share but also provide technical support for the application and research. Through an analysis of database and

a study of data mining technology, the authors put forward a designing scheme based on the exploration and development of data

warehouse, which is in connection with the requirement of production flow. A typical software has been designed, which is based

on the model. The result obtained shows that the incorporated data warehouse is feasible and reasonable.