Hierarchical Data Model Choosing in the Information Systems Design in Relational DBMS

Working with hierarchical data is one of the typical tasks in the industrial information systems development. As a repository of this data, relational databases are usually used. The performance and operability of the designed application depend on the correct choice of storage structure and hierarchical data processing mechanisms. To select the most suitable structure, it is necessary to formulate requirements for operations with nodes, on the basis of which a comparative assessment of the various mechanisms operation will be performed. In the future, taking into account the results and specific features, models can be chosen in favor of a particular technology.