SIMULATION MODEL FOR STUDYING THE EFFICIENCY OF DENORMALIZATION OF A RELATIONAL DATABASE IN AN INFORMATION SYSTEM

Authors

  • A. B. Kungurtsev Odessa National Polytechnic University, Ukraine
  • S. L. Zinovatnaya Odessa National Polytechnic University, Ukraine

DOI:

https://doi.org/10.15588/1607-3274-2008-1-13

Abstract

It is recommended to execute denormalization of relations scheme after the careful testing of the information system  productivity. A simulation model for testing of the system conduct in the conditions of application of different denormalization variants is offered. On the basis of this model a program instrument is realized to allow to probe databases, created with the use of the different database management systems.

Author Biographies

A. B. Kungurtsev, Odessa National Polytechnic University

Candidate of Technical Sciences, Professor

S. L. Zinovatnaya, Odessa National Polytechnic University

Senior Lecturer

References

Prinyatiye resheniya o denormalizatsii. – Rezhim dostupa: http://lavsoft.webhost.ru/oracle/book/dezdb/04/ 04.html. – Nazvaniye s ekrana.

Kungurtsev A. B. Analiz tselesoobraznosti restrukturizatsii bazy dannykh metodom vvedeniya niskhodyashchey denormalizatsii / Kungurtsev A. B., Zinovatnaya S. L. – Tr. Odessk. politekhn. un-ta. Odessa, 2006. – 1(25). – S. 104–108.

M. F. Garsia. Spravochnik administrator Microsoft SQL Server 2000. 2-ye izd. / Per s angl. / M. F. Garsia, Dzh. Reding, E. Uolen, S. A. DeLyuk. – M.: Izdatel'stvo «SP EKOM», 2004. – 976 s.

Zinovatnaya S. L. Analiz informatsionnoy sistemy dlya prinyatiya resheniya o vypolnenii voskhodyashchey denormalizatsii // Kholodil'naya tekhnika i tekhnologii. Sbornik nauchnykh trudov IV seminara «Informatsionnyye sistemy i tekhnologii». – Odessa, 2006. – S. 14–18.

Kungurtsev A. B. Model' restrukturizatsii relyatsionnoy bazy dannykh putem denormalizatsii skhemy / Kungurtsev A. B., Zinovatnaya S. L. – Tr. Odessk. politekhn. un-ta. – Odessa, 2006. – 2(26). – S. 105–111.

Downloads

Published

2024-11-04

How to Cite

Kungurtsev, A. B., & Zinovatnaya, S. L. (2024). SIMULATION MODEL FOR STUDYING THE EFFICIENCY OF DENORMALIZATION OF A RELATIONAL DATABASE IN AN INFORMATION SYSTEM. Radio Electronics, Computer Science, Control, (1), 60. https://doi.org/10.15588/1607-3274-2008-1-13

Issue

No. 1 (2008): Radio Electronics, Computer Science, Control

Section

Mathematical and computer modelling

License

Copyright (c) 2014 A. B. Kungurtsev, S. L. Zinovatnaya

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Creative Commons Licensing Notifications in the Copyright Notices

The journal allows the authors to hold the copyright without restrictions and to retain publishing rights without restrictions.

The journal allows readers to read, download, copy, distribute, print, search, or link to the full texts of its articles.

The journal allows to reuse and remixing of its content, in accordance with a Creative Commons license СС BY -SA.

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License CC BY-SA that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.