Abstract
The development of the interval analysis theory and its applications in solving applied problems led to the need to collect, store and extract efficiently interval-significant data in relational databases. Modern relational database management systems (DBMS) either allow to work with built-in data types which however are not friendly for use or provide the ability to create your own user-defined data types in several ways. The article describes the creation of a user-defined data type iInterval, functions and aggregates to work with interval data in MS SQL Server using the Common Language Runtime (CLR).
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.