Skip to main content

Version Management of Hierarchical Data in Relational Database

  • Conference paper
  • 725 Accesses

Part of the Advances in Intelligent Systems and Computing book series (AISC,volume 361)

Abstract

Hierarchical data structure is organized into a tree-like structure represented by parent- child relationship. The parent can have many children but each child has only one parent. It is also known as one-to-many relationship. There are many types of data can be represented by hierarchical data structure such as organization structures and programs in academies. In some applications, there is necessary to keep historical data or version that need to be used. Temporal data management is used to handle historical data but cause high data space usage by storing every version data which decrease database efficiency. In this paper, we propose logical design to manage versions of hierarchical data in relational database that that may change overtime but historical data is still needed by reusing duplicated records. This conceptual design can avoid data redundancy and increase database efficiency.

Keywords

  • hierarchical data structure
  • relational database
  • version management
  • temporal data management

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-3-319-19024-2_28
  • Chapter length: 10 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   139.00
Price excludes VAT (USA)
  • ISBN: 978-3-319-19024-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   179.99
Price excludes VAT (USA)

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Celko, J.: Joe Celko’s Tree and Hierarchies in SQL for Smarties. Morgan Kaufmann, San Francisco (2004)

    Google Scholar 

  2. Eisenberg, A., Melton, J.: SQL:1999, formerly known as SQL3. SIGMOD Record 28(1), 131–138 (1999)

    CrossRef  Google Scholar 

  3. Gregersen, H., Jensen, C.S.: Temporal Entity-Relationship Models—A Survey. IEEE Transactions on Knowledge and Data Engineering 11(3), 464–497 (1999)

    CrossRef  Google Scholar 

  4. Güting, R.H., Schneider, M.: Moving Objects Databases. Morgan Kaufmann, San Francisco (2005)

    Google Scholar 

  5. Jensen, C.S., Snodgrass, R.T.: Temporal Data Management. IEEE Transactions on Knowledge and Data Engineering 11(1), 36–44 (1999)

    CrossRef  Google Scholar 

  6. Johnston, T., Weis, R.: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data. Morgan Kaufmann, Burlington (2010)

    Google Scholar 

  7. Karwin, B.: SQL Antipatterns Avoiding the Pitfalls of Database Programming. Pragmatic Bookshelf (2010)

    Google Scholar 

  8. Kulkarni, K., Michels, J.E.: Temporal features in SQL:2011. SIGMOD Record 41(3), 34–43 (2012)

    CrossRef  Google Scholar 

  9. Snodgrass, R.T.: Developing Time-Oriented Database Application in SQL. Morgan Kaufmann, San Francisco (2000)

    Google Scholar 

  10. Zikopoulos, P., Baklarz, G., Huras, M., Rjaibi, W., McInnis, D., Nicola, M., Katsnelson, L.: Warp Speed, Time Travel, Big Data, and More; DB2 For Linux, UNIX, and Windows New Feature. McGraw-Hill (2012)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Chawarnwan Jomphrom .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Jomphrom, C., Porkaew, K. (2015). Version Management of Hierarchical Data in Relational Database. In: Unger, H., Meesad, P., Boonkrong, S. (eds) Recent Advances in Information and Communication Technology 2015. Advances in Intelligent Systems and Computing, vol 361. Springer, Cham. https://doi.org/10.1007/978-3-319-19024-2_28

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-19024-2_28

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-19023-5

  • Online ISBN: 978-3-319-19024-2

  • eBook Packages: EngineeringEngineering (R0)