{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,21]],"date-time":"2026-02-21T18:41:25Z","timestamp":1771699285571,"version":"3.50.1"},"reference-count":9,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2005,6,1]],"date-time":"2005-06-01T00:00:00Z","timestamp":1117584000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2005,6]]},"abstract":"<jats:p>Nested Intervals generalize Nested Sets. They are immune to hierarchy reorganization problem. They allow answering ancestor path hierarchical queries algorithmically - without accessing the stored hierarchy relation.<\/jats:p>","DOI":"10.1145\/1083784.1083793","type":"journal-article","created":{"date-parts":[[2005,11,9]],"date-time":"2005-11-09T22:23:27Z","timestamp":1131575007000},"page":"47-52","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["Nested intervals tree encoding in SQL"],"prefix":"10.1145","volume":"34","author":[{"given":"Vadim","family":"Tropashko","sequence":"first","affiliation":[{"name":"Oracle Corp."}]}],"member":"320","published-online":{"date-parts":[[2005,6]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"D. Aioanei A. Malinaru. General trees persisted in relational databases. http:\/\/www.codeproject.com\/cs\/database\/persisting trees.asp?print=true  D. Aioanei A. Malinaru. General trees persisted in relational databases. http:\/\/www.codeproject.com\/cs\/database\/persisting trees.asp?print=true"},{"key":"e_1_2_1_2_1","unstructured":"J. Celko. Joe Celko's Trees and Hierarchies in SQL for Smarties. Morgan Kaufmann.   J. Celko. Joe Celko's Trees and Hierarchies in SQL for Smarties. Morgan Kaufmann."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4379(89)90038-0"},{"key":"e_1_2_1_4_1","volume-title":"On Numbers and Games","author":"Conway J.","unstructured":"J. Conway . On Numbers and Games . New York : Academic Press , Inc. J. Conway. On Numbers and Games. New York: Academic Press, Inc."},{"key":"e_1_2_1_5_1","unstructured":"J. Roy. 2003. Using the Node Data Type to Solve Problems with Hierarchies in DB2 Universal Database http:\/\/www106.ibm.com\/developerworks\/db2\/library\/techarticle\/0302roy\/0302roy.html  J. Roy. 2003. Using the Node Data Type to Solve Problems with Hierarchies in DB2 Universal Database http:\/\/www106.ibm.com\/developerworks\/db2\/library\/techarticle\/0302roy\/0302roy.html"},{"key":"e_1_2_1_6_1","unstructured":"V. Tropashko. Trees in SQL: Nested Sets and Materialized Path. http:\/\/www.dbazine.com\/tropashko4.shtml  V. Tropashko. Trees in SQL: Nested Sets and Materialized Path. http:\/\/www.dbazine.com\/tropashko4.shtml"},{"key":"e_1_2_1_7_1","unstructured":"V. Tropashko. Nested Intervals with Farey Fractions. http:\/\/arxiv.org\/html\/cs.DB\/0401014  V. Tropashko. Nested Intervals with Farey Fractions. http:\/\/arxiv.org\/html\/cs.DB\/0401014"},{"key":"e_1_2_1_8_1","unstructured":"V. Tropashko. Nested Intervals Tree Encoding with Continued Fractions. http:\/\/arxiv.org\/pdf\/cs.DB\/0402051  V. Tropashko. Nested Intervals Tree Encoding with Continued Fractions. http:\/\/arxiv.org\/pdf\/cs.DB\/0402051"},{"key":"e_1_2_1_9_1","unstructured":"L. Vepstas. The Minkowski Question Mark and the Modular Group SL(2 Z). http:\/\/www.linas.org\/math\/chapminkowski\/chap-minkowski.html  L. Vepstas. The Minkowski Question Mark and the Modular Group SL(2 Z). http:\/\/www.linas.org\/math\/chapminkowski\/chap-minkowski.html"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1083784.1083793","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1083784.1083793","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T16:08:23Z","timestamp":1750262903000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1083784.1083793"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005,6]]},"references-count":9,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2005,6]]}},"alternative-id":["10.1145\/1083784.1083793"],"URL":"https:\/\/doi.org\/10.1145\/1083784.1083793","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2005,6]]},"assertion":[{"value":"2005-06-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}