An architecture for managing schema evolution in a federated spatial database system
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 numb...
| Main Authors: | , , , , |
|---|---|
| Other Authors: | |
| Format: | Conference Paper |
| Published: |
WALIS
2011
|
| Online Access: | http://www.walis.wa.gov.au/isde7/peer-reviewed-papers/an-architecture-for-managing-schema-evolution-in-a-federated-spatial-database-system-x-wu.pdf/view http://hdl.handle.net/20.500.11937/5852 |
| _version_ | 1848744911656976384 |
|---|---|
| author | Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert |
| author2 | D. Shepher |
| author_facet | D. Shepher Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert |
| author_sort | Wu, Xiaoying |
| building | Curtin Institutional Repository |
| collection | Online Access |
| description | 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. |
| first_indexed | 2025-11-14T06:08:59Z |
| format | Conference Paper |
| id | curtin-20.500.11937-5852 |
| institution | Curtin University Malaysia |
| institution_category | Local University |
| last_indexed | 2025-11-14T06:08:59Z |
| publishDate | 2011 |
| publisher | WALIS |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | curtin-20.500.11937-58522023-01-18T08:46:46Z An architecture for managing schema evolution in a federated spatial database system Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert D. Shepher G. West M. Johnston 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. 2011 Conference Paper http://hdl.handle.net/20.500.11937/5852 http://www.walis.wa.gov.au/isde7/peer-reviewed-papers/an-architecture-for-managing-schema-evolution-in-a-federated-spatial-database-system-x-wu.pdf/view WALIS restricted |
| spellingShingle | Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert An architecture for managing schema evolution in a federated spatial database system |
| title | An architecture for managing schema evolution in a federated spatial database system |
| title_full | An architecture for managing schema evolution in a federated spatial database system |
| title_fullStr | An architecture for managing schema evolution in a federated spatial database system |
| title_full_unstemmed | An architecture for managing schema evolution in a federated spatial database system |
| title_short | An architecture for managing schema evolution in a federated spatial database system |
| title_sort | architecture for managing schema evolution in a federated spatial database system |
| url | http://www.walis.wa.gov.au/isde7/peer-reviewed-papers/an-architecture-for-managing-schema-evolution-in-a-federated-spatial-database-system-x-wu.pdf/view http://hdl.handle.net/20.500.11937/5852 |