Data mapping, matching and loading using grid services

With the proliferation of international standards for grid-enabled databases, the need for data loading and mapping is identified. It is required in a large integrated environment encompassing heterogeneous databases. This research study proposes an intermediate staging facility in order to upload and integrate data from various small to large size data repositories. The proposed facility has been employed to temporarily store and process the data before it is validated. This research expands the integration notion of a database management system (DBMS) to include the data loading, data matching and transformation processes in traditional and grid distributed environments. The data mapping is employed in the form of value correspondences by using a staging DBMS. A service-based generic strategy grid staging catalogue service (GSCATS) is introduced. It consolidates distinct catalogue schemas of federated databases to access information seamlessly. It involves data mapping and matching of structure objects of federated databases.