Top

Published in:

2021 | OriginalPaper | Chapter

9. Hierarchical Databases

Authors : Konstantinos Domdouzis, Peter Lake, Paul Crowther

Published in: Concise Guide to Databases

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config

AI-assisted search

Off

Abstract

What the reader will learn:

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

über 102.000 Bücher
über 537 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Finance + Banking
Management + Führung
Marketing + Vertrieb
Maschinenbau + Werkstoffe
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 390 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Maschinenbau + Werkstoffe

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 340 Zeitschriften

aus folgenden Fachgebieten:

Bauwesen + Immobilien
Business IT + Informatik
Finance + Banking
Management + Führung
Marketing + Vertrieb
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

previous chapter In-Memory Databases

next chapter Distributed Databases

Ballard C, Farrell DM, Gupta A, Mazuela C, Vohnik S (2006) Dimensional Modeling. In: A business intelligence environment. IBM Redbooks [online]. Available at: https://www.redbooks.ibm.com/redbooks/pdfs/sg247138.pdf. Accessed 05 Nov 2019

Bird S, Chen Yi, Davidson SB, Lee H, Zheng Y (2006) “Designing and Evaluating an XPath Dialect for Linguistic Queries”. In: 22nd International Conference on Data Engineering (ICDE’06), 2006, pp 52–52. https://doi.org/10.1109/ICDE.2006.48

Celko J (2012) Chapter 15—Hierarchical Database Systems (IMS). In: Celko’s J (ed) Trees and Hierarchies in SQL for Smarties, 2nd edn. Morgan Kaufmann, pp 255–270

Celko J (2014) Chapter 13—Hierarchical and Network Database Systems. In: Celko’s J (ed) Complete Guide to NoSQL, Morgan Kaufmann, pp 185–201

David MM (2010) ‘SQL's optimized hierarchical data processing driven by its data structure’. Database J [online]. Available at: https://www.databasejournal.com/sqletc/article.php/3877281/SQLs-Optimized-Hierarchical-Data-Processing-Driven-by-its-Data-Structure.htm. Accessed 01 Dec 2019

Deng J, Dong W, Socher R, Li, L-J, Li K, Fei-Fei L (2009) ImageNet: a large-scale hierarchical image database. In: Proceedings/CVPR, IEEE computer society conference on computer vision and pattern recognition. IEEE Computer Society Conference on Computer Vision and Pattern Recognition

Educba (2020) Hierarchical Database Model’. [online]. Available at: https://www.educba.com/hierarchical-database-model/. Accessed 05 Dec 2019

Fellbaum C (1998) WordNet: an electronic lexical database. Bradford Books

Harris DR, Henderson DW, Kavuluru R, Stromberg AJ, Johnson TR (2014) Using Common Table Expressions to Build a Scalable Boolean Query Generator for Clinical Data Warehouses. IEEE J Biomed Health Inf 18(5):1607–1613

IBM Knowledge Center (2020a) ‘Comparison of hierarchical and relational databases’. [online]. Available at: https://www.ibm.com/support/knowledgecenter/en/SSEPH2_15.1.0/com.ibm.ims15.doc.apg/ims_comparehierandreldbs.htm. Accessed 12 Dec 2019

IBM Knowledge Center (2020b) ‘IMS applications’. [online]. Available at: https://www.ibm.com/support/knowledgecenter/SSTLXK_8.0.0/com.ibm.wbpm.mon.doc/intro/intro_ims.html. Accessed 05 Oct 2019

Internet with a Brain (2014) WordNet and ImageNet’. [online]. Available at: https://www.web3.lu/wordnet-imagenet/. Accessed 06 Dec 2019

Jindal G, Bali S (2012) Hierarchical model leads to the evolution of relational model. Int J Eng Manag Res 2:11–14

Lai C, Bird S (2005) LPath+: a first-order complete language for linguistic tree query. In: Proceedings of the 19th Pacific Asia conference on language, information and computation. Taipei, Taiwan, pp 1–12. https://www.aclweb.org/anthology/Y05-1001.pdf, https://www.aclweb.org/anthology/volumes/Y05-1/

Lo Conte L, Ailey B, Hubbard TJP, Brenner SE, Murzin AG, Chothia C (2000) SCOP: a structural classification of proteins database. Nucleic Acids Res 28(1):257–259

Maher Jr HD (2019) Introduction into geoscience database design. [online]. Available at: https://maps.unomaha.edu/Maher/GEOL2300/week8/database.html. Accessed:10 Dec 2019

Microsoft (2020a) Hierarchical Data (SQL Server). [online]. Available at: https://docs.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sqlserver?view=sql-server-2017. Accessed 01 Dec 2019

Microsoft (2020b) Structure of the Registry. [online]. Available at: https://docs.microsoft.com/en-us/windows/win32/sysinfo/structure-of-the-registry. Accessed 06 Oct 2019

O’Kane KC (2017) Introduction to the Mumps Language. [PowerPoint presentation]. Available at: https://www.cs.uni.edu/~okane/source/MUMPS-MDH/MumpsTutorial.pdf. Accessed 05 Oct 2019

Oracle (2002) 1 Data Warehousing Concepts. [online]. Available at: https://docs.oracle.com/cd/B10500_01/server.920/a96520/concept.htm. Accessed 10 June 2019

Oracle Help Center (2020) Database SQL Reference—Hierarchical Queries’. [online]. Available at: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm. Accessed 15 Nov 2019

Pinto Y (2009) A framework for systematic database denormalization. Global J Comput Sci Technol 44–52

Rozeva A (2007) Dimensional hierarchies—implementation in data warehouse logical scheme design. In: International conference on computer systems and technologies - CompSysTech’07, pp IIIA.24–1–IIIA.24–6

Silberschatz A, Korth HF, Sudarshan S (2010) Appendix E—Hierarchical Models. In: Database System concepts, 6th edn. McGraw-Hill

SQLite (2020) SQL As Understood By SQLite. [online]. Available at: https://www.sqlite.org/lang_with.html. Accessed 14 Nov 2019

Sybase (2009) Sybase IQ 15.1 > Performance and Tuning Guide Sybase IQ 15.1 > Managing System Resources > Managing database size and structure. [online]. Available at: https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00169.1510/html/iqperf/iqperf128.htm. Accessed 20 Dec 2019

Van Tulder G (2003) Storing Hierarchical Data in a Database. [online]. Available at: https://www.sitepoint.com/hierarchical-data-database/. Accessed 19 Dec 2019

Zaker M, Phon-Amnuaisuk S, Haw S-C (2009) Hierarchical denormalizing: a possibility to optimize the data warehouse design. Int J Comput 3(1)

Title: Hierarchical Databases
Authors: Konstantinos Domdouzis
Peter Lake
Paul Crowther
Publisher: Springer International Publishing
Book: Concise Guide to Databases
Print ISBN: 978-3-030-42223-3

Electronic ISBN: 978-3-030-42224-0

Copyright Year: 2021
DOI: https://doi.org/10.1007/978-3-030-42224-0_9

Springer Professional

Abstract

Please log in to get access to your license.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Springer Professional "Technik"

Springer Professional "Wirtschaft"

Premium Partner