Scholarly record
EVALUATING THE EFFECTIVENESS OF DATABASE NORMALIZATION CONSTRAINTS IN MEDIA STREAM PROCESSING APPLICATIONS
Abstract
The paper deals with the inefficiency of data normalization in media stream processing applications. In the classical approaches, while building a relational database architecture, developers strive to maximize the normalization of the database and bring the business logic of the system to external applications. Normalization and business logic separation have reached their apogee in object-relational mapping systems. Telecommunication systems have their own specifics. Due to the requirements for the quality of service, it is precisely to ensure the speed of requests for the moment of switching of media flows. Using simulation and computational models, a study was conducted of the effect of normalization provided by common means on the stability of an application. System performance is evaluated at normal and maximum load levels. Conclusions about the main ways to improve the quality of service in telecommunication systems while maintaining the organization of data storage in the form of a relational database management system. Recommendations on the transformation of the base structure in the direction of the data model subject schema are proposed.
Publication Impact Profile
Publication details
References4
Date C.J., Database Design and Relational Theory: Normal Forms and All That Jazz, O’Reilly, 2012, pp 29-36;
Gulyaev P.A., Kalinin I.V., Muravyeva-Vitkovskaya L.A. Statistical analysis of query processing in a distributed information system // International Multidisciplinary Scientific GeoConference-SGEM: 16th International Multidisciplinary Scientific Geoconference SGEM 2016 - 2016, pp. 397-404;
Muravyeva-Vitkovskaya L.A., Kalinin I.V., Tkeshelashvili N.M. Mapping strategies for role-oriented structures and relational databases in extracting semantically homogeneous essentials tasks // 18th International Multidisciplinary Scientific GeoConference Surveying Geology and Mining Ecology Management, SGEM-2018 - 2018, Vol. 18, No. 2.1, pp. 531-536.
Borshev A. The Big Book of Simulation Modeling. Multimethod Modeling with AnyLogic, AnyLogic Publ., 2013.
View or Download full articleAccess options
SWS access login
Login as SWS Scientific CommitteeLogin as SWS Scientific PartnerLogin as SWS AuthorAuthors and approved SWS contributors will read and export their own linked papers after identity matching by SWS profile, email and SGEM GlobalID.
For librarian assistance: [email protected]
Purchase Instant Access
- Article can be downloaded after successful payment.
- Article may be used according to SWS library access terms.
- Article cannot be redistributed.
