Interval Data Type Creation with Object-Relational Mapping

When processing a large amount of interval-valued data, stored in a relational database, developers cannot use the pre-property provided by the DBMS without dividing a single logical unit into lower and upper boundaries and storing them in different fields of the tables, thus jeopardizing the integrity of the database. The analysis of approaches to the implementation of methods used for storage and manipulating the data containing interval values shows, it is needed to develop a design procedure for the user-defined interval-valued data type used to create application software and design a DBMS. The article describes the implemented approach of creating an interval data type in SQL Server as well as the possibilities of its implementation with object-relational mapping technology that allow to solve the problem. The advantages and disadvantages of this approach and the complexity of its implementation are revealed. Research methods based on the interval arithmetic and interval analysis theory, object-oriented programming, the theory of relational databases designing.