Research Commons
      • Browse 
        • Communities & Collections
        • Titles
        • Authors
        • By Issue Date
        • Subjects
        • Types
        • Series
      • Help 
        • About
        • Collection Policy
        • OA Mandate Guidelines
        • Guidelines FAQ
        • Contact Us
      • My Account 
        • Sign In
        • Register
      View Item 
      •   Research Commons
      • University of Waikato Research
      • Management
      • Management Papers
      • View Item
      •   Research Commons
      • University of Waikato Research
      • Management
      • Management Papers
      • View Item
      JavaScript is disabled for your browser. Some features of this site may not work without it.

      Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation

      Golfarelli, Matteo; Lechtenborger, Jens; Rizzi, Stefano; Vossen, Gottfried
      DOI
       10.1016/j.datak.2005.09.004
      Link
       www.sciencedirect.com
      Find in your library  
      Citation
      Export citation
      Golfarelli, M., Lechtenborger, J., Rizzi, S., Vossen, G. (2006). Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation. Data & Knowledge Engineering, 59(2), 435-459.
      Permanent Research Commons link: https://hdl.handle.net/10289/1884
      Abstract
      As several mature implementations of data warehousing systems are fully operational, a crucial role in preserving their up-to-dateness is played by the ability to manage the changes that the data warehouse (DW) schema undergoes over time in response to evolving business requirements. In this paper we propose an approach to schema versioning in DWs, where the designer may decide to undertake some actions on old data aimed at increasing the flexibility in formulating cross-version queries, i.e., queries spanning multiple schema versions. First, we introduce a representation of DW schemata as graphs of simple functional dependencies, and discuss its properties. Then, after defining an algebra of schema graph modification operations aimed at creating new schema versions, we discuss how augmented schemata can be introduced to increase flexibility in cross-version querying. Next, we show how a history of versions for DW schemata is managed and discuss the relationship between the temporal horizon spanned by a query and the schema on which it can consistently be formulated.
      Date
      2006
      Type
      Journal Article
      Publisher
      Elsevier
      Collections
      • Management Papers [1125]
      Show full item record  

      Usage

       
       
       

      Usage Statistics

      For this itemFor all of Research Commons

      The University of Waikato - Te Whare Wānanga o WaikatoFeedback and RequestsCopyright and Legal Statement