Skip to the main content

Original scientific paper

https://doi.org/10.2498/cit.1002310

Reusable Prime Number Labeling Scheme for Hierarchical Data Representation in Relational Databases

Serhiy Morozov ; University of Detroit Mercy, Detroit MI, USA
Hossein Saiedian ; University of Kansas, Lawrence KS, USA
Hanzhang Wang ; University of Detroit Mercy, Detroit MI, USA


Full text: english PDF 477 Kb

page 31-44

downloads: 740

cite


Abstract

Hierarchical data structures are important for many computing and information science disciplines including data mining, terrain modeling, and image analysis. There are many specialized hierarchical data management systems, but they are not always available. Alternatively, relational databases are far more common and offer superior reliability, scalability, and performance. However, relational databases cannot natively store and manage hierarchical data. Labeling schemes resolve this issue by labeling all nodes with alphanumeric strings that can be safely stored and retrieved from a database. One such scheme uses prime numbers for its labeling purposes, however the performance and space utilization of this method are not optimal. We propose a more efficient and compact version of this approach.

Keywords

hierarchical data structures; data labeling schemes; relational database systems; prime number labeling; performance evaluation

Hrčak ID:

123176

URI

https://hrcak.srce.hr/123176

Publication date:

18.6.2014.

Visits: 1.223 *