Managing schema evolution in a federated spatial database system
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 non-spatial datasets are integrated, especially those across a number of independe...
| Main Authors: | , , , , |
|---|---|
| Other Authors: | |
| Format: | Book Chapter |
| Published: |
IGI Global
2012
|
| Online Access: | http://hdl.handle.net/20.500.11937/47434 |
| _version_ | 1848757831759560704 |
|---|---|
| author | Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert |
| author2 | Laura Diaz |
| author_facet | Laura Diaz Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert |
| author_sort | Wu, Xiaoying |
| building | Curtin Institutional Repository |
| collection | Online Access |
| description | 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 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 invalidate applications built against this local schema, but also applications built against the global schema. The research is motivated by developments in the Shared Land Information Platform, built by Landgate in Western Australia as a Spatial Data Infrastructure enabler that has been running since 2007. The more than 350 datasets in SLIP are from and controlled by 20 organisations with queries built over the different datasets. Changes in the various databases require schema updating to be streamlined. In this chapter, an Automatic Schema Evolution Framework is explored and developed to more effectively manage schema evolution in a FSDBS. This framework provides a Schema Element Dependency Meta-Model, a set of Schema Change Templates, and incorporates view generation, view rewriting, and query rewriting as solutions. These developed methods ensure applications can accommodate schema changes and hence remain valid. |
| first_indexed | 2025-11-14T09:34:21Z |
| format | Book Chapter |
| id | curtin-20.500.11937-47434 |
| institution | Curtin University Malaysia |
| institution_category | Local University |
| last_indexed | 2025-11-14T09:34:21Z |
| publishDate | 2012 |
| publisher | IGI Global |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | curtin-20.500.11937-474342023-02-07T08:01:22Z Managing schema evolution in a federated spatial database system Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert Laura Diaz Carlos Granell Joaquin Huerta 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 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 invalidate applications built against this local schema, but also applications built against the global schema. The research is motivated by developments in the Shared Land Information Platform, built by Landgate in Western Australia as a Spatial Data Infrastructure enabler that has been running since 2007. The more than 350 datasets in SLIP are from and controlled by 20 organisations with queries built over the different datasets. Changes in the various databases require schema updating to be streamlined. In this chapter, an Automatic Schema Evolution Framework is explored and developed to more effectively manage schema evolution in a FSDBS. This framework provides a Schema Element Dependency Meta-Model, a set of Schema Change Templates, and incorporates view generation, view rewriting, and query rewriting as solutions. These developed methods ensure applications can accommodate schema changes and hence remain valid. 2012 Book Chapter http://hdl.handle.net/20.500.11937/47434 10.4018/978-1-4666-0945-7.ch004 IGI Global restricted |
| spellingShingle | Wu, Xiaoying Xia, Jianhong (Cecilia) West, Geoffrey Arnold, L. Veenendaal, Bert Managing schema evolution in a federated spatial database system |
| title | Managing schema evolution in a federated spatial database system |
| title_full | Managing schema evolution in a federated spatial database system |
| title_fullStr | Managing schema evolution in a federated spatial database system |
| title_full_unstemmed | Managing schema evolution in a federated spatial database system |
| title_short | Managing schema evolution in a federated spatial database system |
| title_sort | managing schema evolution in a federated spatial database system |
| url | http://hdl.handle.net/20.500.11937/47434 |