Curtin University Homepage
  • Library
  • Help
    • Admin

    espace - Curtin’s institutional repository

    JavaScript is disabled for your browser. Some features of this site may not work without it.
    View Item 
    • espace Home
    • espace
    • Curtin Research Publications
    • View Item
    • espace Home
    • espace
    • Curtin Research Publications
    • View Item

    Managing schema evolution in a federated spatial database system

    Access Status
    Fulltext not available
    Authors
    Wu, Xiaoying
    Xia, Jianhong (Cecilia)
    West, Geoffrey
    Arnold, L.
    Veenendaal, Bert
    Date
    2012
    Type
    Book Chapter
    
    Metadata
    Show full item record
    Citation
    Wu, Xiaoying and Xia, Jianhong (Cecilia) and West, Geoff and Arnold, Lesley and Veenendaal, Bert. 2012. Managing schema evolution in a federated spatial database system, in Diaz, L. and Granell, C. and Huerta, J. (ed), Discovery of geospatial resources: Methodologies, technologies, and emergent applications. pp. 56-77. Hershey, Pa: IGI Global.
    Source Title
    Discovery of Geospatial Resources
    DOI
    10.4018/978-1-4666-0945-7.ch004
    ISBN
    9781466609457
    URI
    http://hdl.handle.net/20.500.11937/47434
    Collection
    • Curtin Research Publications
    Abstract

    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.

    Related items

    Showing items related by title, author, creator and subject.

    • An architecture for managing schema evolution in a federated spatial database system
      Wu, Xiaoying; Xia, Jianhong (Cecilia); West, Geoffrey; Arnold, L.; Veenendaal, Bert (2011)
      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 ...
    • Automating government spatial transactions
      Varadharajulu, P.; West, Geoff; McMeekin, David; Moncrieff, Simon; Arnold, L. (2016)
      Copyright © 2016 by SCITEPRESS - Science and Technology Publications, Lda. All rights reserved.The land development approval process between local authorities and government land and planning departments is manual, time ...
    • Managing Schema Evolution in a federated spatial database system
      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 ...
    Advanced search

    Browse

    Communities & CollectionsIssue DateAuthorTitleSubjectDocument TypeThis CollectionIssue DateAuthorTitleSubjectDocument Type

    My Account

    Admin

    Statistics

    Most Popular ItemsStatistics by CountryMost Popular Authors

    Follow Curtin

    • 
    • 
    • 
    • 
    • 

    CRICOS Provider Code: 00301JABN: 99 143 842 569TEQSA: PRV12158

    Copyright | Disclaimer | Privacy statement | Accessibility

    Curtin would like to pay respect to the Aboriginal and Torres Strait Islander members of our community by acknowledging the traditional owners of the land on which the Perth campus is located, the Whadjuk people of the Nyungar Nation; and on our Kalgoorlie campus, the Wongutha people of the North-Eastern Goldfields.