An architecture for managing schema evolution in a federated spatial database system
MetadataShow full item record
A Federated Spatial Database System (FSDBS) is the integration of multiple spatial data sources and the realisation of effective spatial data sharing. FSDBS environments are becoming increasingly popular as more and more spatial and non-spatial datasets are integrated, especially those across a number of independent organisations. However, in a FSDBS environment, database schemas are subject to change and the management of these changes is complex and inefficient. This is because schema changes in one local database will affect or invalidate not only applications built against this local schema, but also applications built against the global schema. In this research, a Schema Element Dependency Meta-model and a set of Schema Change Templates which incorporates view generation, view rewriting and query rewriting have been developed as the solution in managing schema evolution in a FSDBS. This paper focuses on the architecture of Automatic Schema Evolution that includes a schema element dependency tool, a schema mapping tool and a view rewriting tool. These tools are embedded with the developed methods will assist in effective management of schema evolution in a FSDBS and engendering collaboration and interoperability between data custodians and application developers and users.
Showing items related by title, author, creator and subject.
Wu, Xiaoying; Xia, Jianhong (Cecilia); West, Geoffrey; Arnold, L.; Veenendaal, Bert (2012)A Federal Spatial Database System (FSDBS) is the integration of multiple spatial data sources and the realisation of effective spatial data sharing. These are becoming increasingly popular as more and more spatial and ...
Wu, Xiaoying (2014)In a FSDBS environment, database schemas are subject to changes and the management of these changes is complex and inefficient. In this research, an Automatic Schema Evolution (ASE) Framework has been developed in order ...
Williams, Richard Malcolm (2006)Suppliers of wheat must ensure that their products have the required quality profile demanded by customers and consistently deliver that quality in order to be competitive. Australia’s wheat industry is highly exposed to ...