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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Celko, J.: Joe Celko’s Tree and Hierarchies in SQL for Smarties. Morgan Kaufmann, San Francisco (2004)
Eisenberg, A., Melton, J.: SQL:1999, formerly known as SQL3. SIGMOD Record 28(1), 131–138 (1999)
Gregersen, H., Jensen, C.S.: Temporal Entity-Relationship Models—A Survey. IEEE Transactions on Knowledge and Data Engineering 11(3), 464–497 (1999)
Güting, R.H., Schneider, M.: Moving Objects Databases. Morgan Kaufmann, San Francisco (2005)
Jensen, C.S., Snodgrass, R.T.: Temporal Data Management. IEEE Transactions on Knowledge and Data Engineering 11(1), 36–44 (1999)
Johnston, T., Weis, R.: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data. Morgan Kaufmann, Burlington (2010)
Karwin, B.: SQL Antipatterns Avoiding the Pitfalls of Database Programming. Pragmatic Bookshelf (2010)
Kulkarni, K., Michels, J.E.: Temporal features in SQL:2011. SIGMOD Record 41(3), 34–43 (2012)
Snodgrass, R.T.: Developing Time-Oriented Database Application in SQL. Morgan Kaufmann, San Francisco (2000)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)