Data logical models and the organization of data storage in database systems (DBS) continue to evolve to meet current data processing requirements. Due to a highly developed mathematical foundation (relational algebra (E. F. Codd, 1970)), the relational model is still used for many use cases. However, in addition to the relational model, a variety of other models have emerged, including those that use multidimensional, object-relational, and hierarchical data, such as XML (Extended Markup Language) and the JSON (JavaScript Object Notation) data format.
Multidimensional DBS is the foundation of data analytics systems. Object-relational DBS introduced complex data objects and efficient data processing programs in DBS. Hierarchical DBS with XML and JSON enables document storage and management. In the study course, students will learn the most common DBS of the aforementioned logical data models, their structures, data storage structures, data input and modification capabilities, data query languages, and programming on a database server to implement the concept of "data processing in a database system" proposed by leading companies such as Oracle, SAS, and IBM.
Great attention will be paid to the evaluation of the positive and negative features of the DBS studied, as well as to the analysis of their suitability for the most common industry requirements.