The Research Of Accessing To Heterogenous Database In Data Center Of Agriculture

Currently, in data center of CAAS, the quantity of existing databases has reach to 65. It is found that for the reason of heterogeneity of database in the aspect of different data structure, there exists some difficulties to access to agricultural data. To supply with support of theory and strategy for resolving the problem of accessing to heterogenous database in data center, the paper is studied to construct a basic framework theoretically.Based on the methods of management information system (MIS), this paper uses database technology and information technology. First, the condition of data center of agricultural science of CAAS is analyzed in detail, through analyzing the environment of heterogenous database and the shortcoming of the mode of accessing to heterogenous database, the development of technology of middleware in native and foreign countries is studied, the design of adopting the technology of middleware to access to heterogenous database transparently is brought forward. Next, by contrast, the middleware technology and current emphasis on study of the integration to access to data in native and foreign countries is studied, the different modes of accessing to heterogenous database are contrasted, and a scheme of middleware of accessing to heterogenous database based on the technology of XML and JAVA is set forth, the design and the realization process of every module are discussed respectively. Last, according to practical example, the scheme is validated.The scheme shields the heterogeneity between the different DBMS and data structure, protecting resource of users at the most, it comes to access to heterogenous data transparently.The study supplies the basic of analyzing problem scientifically for building the system of sharing scientific data and relevant system, in the field of agriculture, the reference of scheme is supplied to resolve the problem of accessing to heterogenous database transparently, for programming and managing data center and its system, the study is found that it has important reference value and meaning of realism.