DOI - Vydavatelství Mendelovy univerzity v Brně

Identifikátory DOI

DOI: 10.11118/ecos2026_036

TREESTORAGE: HIERARCHICAL STORAGE WITH VERSIONING AND INHERITED ACCESS CONTROL IN A UNIVERSITY INFORMATION SYSTEM

Petr Straka1, Oldrich Trenz1
1 Department of Informatics, Faculty of Business and Economics, Mendel University in Brno, Zemědělská 1, 613 00 Brno, Czech Republic

Large information systems accumulate knowledge that is often transferred informally rather than stored in the system itself. This article describes the design and working prototype of Treestorage, a reusable hierarchical storage component for INET, the economic and personnel information system of Masaryk University. Treestorage is intended to organise agenda-related HTML notes, references to binary documents and parameterised SQL reports in a tree structure, with read and edit rights inherited from parent nodes and version history stored for edited nodes. Before implementing the component, available alternatives at the university were assessed, especially Google Drive, OneDrive and git-based services such as GitHub/GitLab; these options were not selected because they would either keep data and authentication outside INET or fail key requirements such as fine-grained folder-level read access. The implemented data model uses an adjacency list, reads nodes as a flat list and rebuilds the tree in the front end, while inherited rights are resolved through a PostgreSQL materialised view based on a recursive query. The result is a functional prototype that can be tested internally and further integrated after related INET 2.0 components are completed.

Klíčová slova: information systems, hierarchical storage, access control, versioning, materialized view, adjacency list

stránky: 330-337, online: 2026



Reference

  1. ATLASSIAN. n.d. Confluence - Atlassian. Atlassian. https://www.atlassian.com/software/confluence
  2. GITHUB. n.d. GitHub Acceptable Use Policies. GitHub. https://docs.github.com/en/site-policy/acceptable-use-policies/github-acceptable-use-policies
  3. GOOGLE. 2026. Google Drive API release notes. Google for Developers. https://developers.google.com/workspace/drive/release-notes
  4. MĚCHÁČEK, J., KOHOUTKOVÁ, J. 2000. Intranetový server Informačního systému MU [in Czech]. Zpravodaj ÚVT MU. XI(1), 4-7. https://webserver.ics.muni.cz/zpravodaj/articles/194.html
  5. MICROSOFT. 2025. Avoid getting throttled or blocked in SharePoint Online. Microsoft Learn. https://learn.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online
  6. MONGODB. n.d. Model Tree Structures. MongoDB. https://www.mongodb.com/docs/manual/applications/data-models-tree-structures/
  7. MOZILLA. n.d. JavaScript. MDN Web Docs. https://developer.mozilla.org/en-US/docs/Web/JavaScript
  8. NEO4J. n.d. Neo4j documentation. https://neo4j.com/docs/
  9. ORACLE. n.d. What is Java technology and why do I need it? java.com. https://www.java.com/en/download/help/whatis_java.html
  10. OUTLINE. n.d. Outline. https://www.getoutline.com
  11. POSTGRESQL. n.d. PostgreSQL Contributor Profiles. The PostgreSQL Global Development Group. https://www.postgresql.org/community/contributors/
  12. RICHARDS, R. 2025. 2025 Google Workspace for Education Pricing and Licensing Updates. Trafera. https://www.trafera.com/blog/2025-google-workspace-for-education-pricing-and-licensing-updates/
  13. SAMOILENKO, S. 2025. Part 1: Nested sets. Medium. https://medium.com/@serhiisamoilenko/part-1-nested-sets-239e70f59beb
  14. SEYBOLT, B. 2025. Major Google for Education Licensing and Price Changes. Cumulus Global. https://www.cumulusglobal.com/major-google-for-education-licensing-and-price-changes/
  15. STRAKA, P. 2026. Treestorage - hierarchical storage with versioning and access control [in Czech]. Master's thesis, head: Trenz, O. Brno: Mendel University in Brno.
Návrat zpět