{"id":"https://openalex.org/W2097684779","doi":"https://doi.org/10.2498/cit.1002310","title":"Reusable Prime Number Labeling Scheme for Hierarchical Data Representation in Relational Databases","display_name":"Reusable Prime Number Labeling Scheme for Hierarchical Data Representation in Relational Databases","publication_year":2014,"publication_date":"2014-01-01","ids":{"openalex":"https://openalex.org/W2097684779","doi":"https://doi.org/10.2498/cit.1002310","mag":"2097684779"},"language":"en","primary_location":{"id":"doi:10.2498/cit.1002310","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002310","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2310/1620","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://cit.fer.hr/index.php/CIT/article/download/2310/1620","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5054775750","display_name":"Serhiy Morozov","orcid":null},"institutions":[{"id":"https://openalex.org/I71792333","display_name":"University of Detroit Mercy","ror":"https://ror.org/0037qsh65","country_code":"US","type":"education","lineage":["https://openalex.org/I71792333"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Serhiy Morozov","raw_affiliation_strings":["University of Detroit Mercy, Detroit MI","Univ. of Detroit Mercy, Detroit, MI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Detroit Mercy, Detroit MI","institution_ids":["https://openalex.org/I71792333"]},{"raw_affiliation_string":"Univ. of Detroit Mercy, Detroit, MI","institution_ids":["https://openalex.org/I71792333"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005161974","display_name":"Hossein Saiedian","orcid":"https://orcid.org/0000-0001-5060-6332"},"institutions":[{"id":"https://openalex.org/I146416000","display_name":"University of Kansas","ror":"https://ror.org/001tmjg57","country_code":"US","type":"education","lineage":["https://openalex.org/I146416000"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hossein Saiedian","raw_affiliation_strings":["Department of EECS \r\nUniversity of Kansas\r\nLawrence, KS 66049 USA","Department of EECS #R##N#University of Kansas#R##N#Lawrence, KS 66049 USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of EECS \r\nUniversity of Kansas\r\nLawrence, KS 66049 USA","institution_ids":["https://openalex.org/I146416000"]},{"raw_affiliation_string":"Department of EECS #R##N#University of Kansas#R##N#Lawrence, KS 66049 USA","institution_ids":["https://openalex.org/I146416000"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5040046281","display_name":"Hanzhang Wang","orcid":"https://orcid.org/0000-0002-7994-2935"},"institutions":[{"id":"https://openalex.org/I71792333","display_name":"University of Detroit Mercy","ror":"https://ror.org/0037qsh65","country_code":"US","type":"education","lineage":["https://openalex.org/I71792333"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hanzhang Wang","raw_affiliation_strings":["University of Detroit Mercy, Detroit MI","Univ. of Detroit Mercy, Detroit, MI"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Detroit Mercy, Detroit MI","institution_ids":["https://openalex.org/I71792333"]},{"raw_affiliation_string":"Univ. of Detroit Mercy, Detroit, MI","institution_ids":["https://openalex.org/I71792333"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":450,"currency":"EUR","value_usd":485},"apc_paid":{"value":450,"currency":"EUR","value_usd":485},"fwci":0.3483,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.68008106,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"22","issue":"1","first_page":"31","last_page":"31"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8885906934738159},{"id":"https://openalex.org/keywords/alphanumeric","display_name":"Alphanumeric","score":0.7004531621932983},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6711366176605225},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6492453217506409},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.6112697720527649},{"id":"https://openalex.org/keywords/prime","display_name":"Prime (order theory)","score":0.5523213744163513},{"id":"https://openalex.org/keywords/hierarchical-database-model","display_name":"Hierarchical database model","score":0.5284785032272339},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49921441078186035},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.49895167350769043},{"id":"https://openalex.org/keywords/reliability","display_name":"Reliability (semiconductor)","score":0.455992192029953},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44950070977211},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4292926788330078},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34963032603263855}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8885906934738159},{"id":"https://openalex.org/C2781003394","wikidata":"https://www.wikidata.org/wiki/Q737372","display_name":"Alphanumeric","level":2,"score":0.7004531621932983},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6711366176605225},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6492453217506409},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.6112697720527649},{"id":"https://openalex.org/C184992742","wikidata":"https://www.wikidata.org/wiki/Q7243229","display_name":"Prime (order theory)","level":2,"score":0.5523213744163513},{"id":"https://openalex.org/C144986985","wikidata":"https://www.wikidata.org/wiki/Q871236","display_name":"Hierarchical database model","level":2,"score":0.5284785032272339},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49921441078186035},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.49895167350769043},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.455992192029953},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44950070977211},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4292926788330078},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34963032603263855},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.2498/cit.1002310","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002310","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2310/1620","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},{"id":"pmh:oai:hrcak.srce.hr:123176","is_oa":true,"landing_page_url":"http://hrcak.srce.hr/123176","pdf_url":null,"source":{"id":"https://openalex.org/S4306400677","display_name":"Hr\u010dak Portal of scientific journals of Croatia (University Computing Centre)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210104502","host_organization_name":"United Nations University","host_organization_lineage":["https://openalex.org/I4210104502"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing and information technology","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.2498/cit.1002310","is_oa":true,"landing_page_url":"https://doi.org/10.2498/cit.1002310","pdf_url":"http://cit.fer.hr/index.php/CIT/article/download/2310/1620","source":{"id":"https://openalex.org/S98565333","display_name":"Journal of Computing and Information Technology","issn_l":"1330-1136","issn":["1330-1136","1846-3908"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310314807","host_organization_name":"Faculty of Electrical Engineering and Computing, University of Zagreb","host_organization_lineage":["https://openalex.org/P4310314807"],"host_organization_lineage_names":["Faculty of Electrical Engineering and Computing, University of Zagreb"],"type":"journal"},"license":"cc-by-nd","license_id":"https://openalex.org/licenses/cc-by-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computing and Information Technology","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2097684779.pdf","grobid_xml":"https://content.openalex.org/works/W2097684779.grobid-xml"},"referenced_works_count":39,"referenced_works":["https://openalex.org/W26976588","https://openalex.org/W69638526","https://openalex.org/W180687025","https://openalex.org/W1493379225","https://openalex.org/W1522658321","https://openalex.org/W1537294165","https://openalex.org/W1588609235","https://openalex.org/W1598660478","https://openalex.org/W1736935108","https://openalex.org/W1952994271","https://openalex.org/W1980556028","https://openalex.org/W1999243999","https://openalex.org/W2011094172","https://openalex.org/W2022860157","https://openalex.org/W2024740153","https://openalex.org/W2024936222","https://openalex.org/W2068618567","https://openalex.org/W2106367761","https://openalex.org/W2109153941","https://openalex.org/W2110459974","https://openalex.org/W2111087864","https://openalex.org/W2119676423","https://openalex.org/W2131445612","https://openalex.org/W2136383162","https://openalex.org/W2139242647","https://openalex.org/W2141776324","https://openalex.org/W2144621469","https://openalex.org/W2162328724","https://openalex.org/W2165286227","https://openalex.org/W2178701490","https://openalex.org/W2527214967","https://openalex.org/W2752061190","https://openalex.org/W2752853835","https://openalex.org/W2808885413","https://openalex.org/W4214515491","https://openalex.org/W4235196446","https://openalex.org/W4237112997","https://openalex.org/W6606250760","https://openalex.org/W6690468241"],"related_works":["https://openalex.org/W2594791258","https://openalex.org/W4385585331","https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W1567213510","https://openalex.org/W2626533837","https://openalex.org/W2375584934","https://openalex.org/W2761120596","https://openalex.org/W1575529579","https://openalex.org/W2525788546"],"abstract_inverted_index":{"Hierarchical":[0],"data":[1,13,25],"structures":[2],"are":[3,21,30,37,99],"important":[4],"for":[5,86],"many":[6,22],"computing":[7],"and":[8,17,41,46,54,75,93,107],"information":[9],"science":[10],"disciplines":[11],"including":[12],"mining,":[14],"terrain":[15],"modeling,":[16],"image":[18],"analysis.":[19],"There":[20],"specialized":[23],"hierarchical":[24,56],"management":[26],"systems,":[27],"but":[28],"they":[29],"not":[31,100],"always":[32],"available.":[33],"Alternatively,":[34],"relational":[35,49],"databases":[36,50],"far":[38],"more":[39,105],"common":[40],"offer":[42],"superior":[43],"reliability,":[44],"scalability,":[45],"performance.":[47],"However,":[48],"cannot":[51],"natively":[52],"store":[53],"manage":[55],"data.":[57],"Labeling":[58],"schemes":[59],"resolve":[60],"this":[61,97,111],"issue":[62],"by":[63],"labeling":[64,88],"all":[65],"nodes":[66],"with":[67],"alphanumeric":[68],"strings":[69],"that":[70],"can":[71],"be":[72],"safely":[73],"stored":[74],"retrieved":[76],"from":[77],"a":[78,104],"database.":[79],"One":[80],"such":[81],"scheme":[82],"uses":[83],"prime":[84],"numbers":[85],"its":[87],"purposes,":[89],"however":[90],"the":[91],"performance":[92],"space":[94],"utilization":[95],"of":[96,110],"method":[98],"optimal.":[101],"We":[102],"propose":[103],"efficient":[106],"compact":[108],"version":[109],"approach.":[112]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}