Materialized views management technology based on work schedule of organizations

Authors

  • Oleksii Kungurtsev Odessa National Polytechnic University 65044 , Odessa, Shevchenko Avenue , 1, Ukraine
  • Yuri Vozovikov Odessa National Polytechnic University 65044 , Odessa, Shevchenko Avenue , 1, Ukraine
  • Olena Kungurtseva Odessa National Maritime University 65029 , Odessa, Str. Mechnikov, 34, Ukraine

DOI:

https://doi.org/10.15587/1729-4061.2013.19120

Keywords:

information systems, the performance of the information system, query language, materialized views, request

Abstract

There are various software methods of increasing the productivity of informational systems based on using of relational data bases. One of them anticipates using of materialized views. Materialized views stores result of certain request to the data base and at following entry of this request to the informational systems allows getting answer very fast. However the practical use of materialized views in separate informational systems is impossible without preliminary study of this informational system. As materialized views is a result of request which uses number of data bases tables the refreshing of certain data in those tables leads to necessity of refreshing materialized views too. At frequent refreshing of data the using of materialized views could not increase but decrease the effectiveness of informational systems.

In this book the periodical connection and disconnection of materialized views is offered. The basis for this is an evident periodicity in resolving of different tasks for the most of organizations.

Author Biographies

Oleksii Kungurtsev, Odessa National Polytechnic University 65044 , Odessa, Shevchenko Avenue , 1

Professor, Candidate of Technical Sciences

Department of the system software

Yuri Vozovikov, Odessa National Polytechnic University 65044 , Odessa, Shevchenko Avenue , 1

Graduate student

Department of the system software

Olena Kungurtseva, Odessa National Maritime University 65029 , Odessa, Str. Mechnikov, 34

Senior Lecturer

Department of Engineering Cybernetics

References

  1. Advenced Information Systems. Oracle 8. User cyclopedia: tr. from eng. [Текст] / Advenced Information Systems // “DiaSoft” publishing. Kyiv, 1998. – P. 864.
  2. Viera, R. Programming of Microsoft SQL Server 2005 data bases. Basics.: tr. from eng. [Текст] / Robert Viera // “Dialektica” publishing. Moscow, 2007, - P. 832.
  3. Vishnevsky, A. Microsoft SQL Server. Efficient work [Текст] / Alexey Vishnevsky // “Piter Press” LLC. St. Piterburg, 2009. - P. 541.
  4. Agrawal, S. Automated Selection of Materialized Views and Indexes in SQL Databases [Текст] / S. Agrawal, S. Chaudhuri, V. R. Narasayya // In: Proceedings Of VLDB, Framingham, MA, 2000, - P. 496-505.
  5. Bello, R.G. Materialized Views in Oracle [Текст] / R.G. Bello, K. Dias, J. Feenan, J. Finnerty, W.D. Norcott, H. Sun, A. Witkowski, M. Ziauddin // Proc. of the 24th VLDB Conf., New York, 1998, - P. 659 - 664.
  6. Chang, J. Query Reformulation Using Materialized Views in Data Warehousing Environment [Текст] / J. Chang, S. Lee // In: ACM Int. Workshop on Data Warehousing and OLAP. “Microsoft”, Redmond, 1998. - P. 54 - 59.
  7. Gupta, H. Incremental maintenance of aggregate and outerjoin expression [Текст] / H. Gupta, I. S. Mumick // Information Systems. Bethesda, Maryland, 2006. - № 31(6) . - P. 435–464.
  8. Kungurtsev,А.B. Search of regularities in distribution of requests for management of materialized views [Текст] / А.B. Kungurtsev, U.N. Vozovikov // Odessa National Polytechnic University. Odessa, 2008. - №2(30). - P. 135 - 140.
  9. Kungurtsev, А.B. Analysis of possibility of MV implementation in IS [Текст] / А.B. Kungurtsev, Kuok Vin Nguen Chan // Odessa National Polytechnic University. Odessa, 2004. - №2(20). - P. 102-106.
  10. Kungurtsev, А. B. Management of materialized views in nformational systems [Текст] / А. B. Kungurtsev, U. N. Vozovilov // Eastern-European Journal of Eneterprise Technologies. - 2010. - №1/4 (43). - P. 18 - 21.
  11. Advenced Information Systems. (1998). Oracle 8. User cyclopedia: tr. from eng. Advenced Information Systems. “DiaSoft” publishing, Kyiv, 864.
  12. Viera, R. (2007). Programming of Microsoft SQL Server 2005 data bases. Basics.: tr. from eng. “Dialektica” publishing, Moscow, 832.
  13. Vishnevsky, A. (2009). Microsoft SQL Server. Efficient work. “Piter Press” LLC. publishing, St. Piterburg, 541.
  14. Agrawal, S., Chaudhuri, S., Narasayya, V. R. (2000). Automated Selection of Materialized Views and Indexes in SQL Databases. “VLDB” publishing, Framingham, MA, 496-505.
  15. Bello, R.G., Dias, K., Feenan, J., Finnerty, J., Norcott, W.D., Sun, H., Witkowski, A., Ziauddin, M. (1998). Materialized Views in Oracle. “VLDB” publishing, New York, 659-664.
  16. Chang, J., Lee, S. (1998). Query Reformulation Using Materialized Views in Data Warehousing Environment. In: ACM Int. Workshop on Data Warehousing and OLAP. «Microsoft» publishing, Redmond, 54-59.
  17. Gupta, H. (2006). Incremental maintenance of aggregate and outerjoin expression. Information Systems. Bethesda, Maryland, 31(6), 435-464.
  18. Kungurtsev, А.B., Vozovikov, U.N. (2008). Search of regularities in distribution of requests for management of materialized views. Odessa National Polytechnic University publishing, Odessa, 2(30), 135-140.
  19. Kungurtsev, А.B. , Kuok Vin Nguen Chan. (2004). Analysis of possibility of MV implementation in IS. Odessa National Polytechnic University publishing, Odessa, 2(20), 102-106.
  20. Kungurtsev, А. B., Vozovilov, U. N. (2010). Management of materialized views in іnformational systems. Eastern-European Journal of Eneterprise Technologies, 1(4(43)), 18 - 21.

Downloads

Published

2013-12-18

How to Cite

Kungurtsev, O., Vozovikov, Y., & Kungurtseva, O. (2013). Materialized views management technology based on work schedule of organizations. Eastern-European Journal of Enterprise Technologies, 6(3(66), 11–14. https://doi.org/10.15587/1729-4061.2013.19120

Issue

Vol. 6 No. 3(66) (2013): Control processec

Section

Control processes

License

Copyright (c) 2014 Oleksii Kungurtsev, Yuri Vozovikov, Olena Kungurtseva

Creative Commons License

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

The consolidation and conditions for the transfer of copyright (identification of authorship) is carried out in the License Agreement. In particular, the authors reserve the right to the authorship of their manuscript and transfer the first publication of this work to the journal under the terms of the Creative Commons CC BY license. At the same time, they have the right to conclude on their own additional agreements concerning the non-exclusive distribution of the work in the form in which it was published by this journal, but provided that the link to the first publication of the article in this journal is preserved.

A license agreement is a document in which the author warrants that he/she owns all copyright for the work (manuscript, article, etc.).
The authors, signing the License Agreement with TECHNOLOGY CENTER PC, have all rights to the further use of their work, provided that they link to our edition in which the work was published.
According to the terms of the License Agreement, the Publisher TECHNOLOGY CENTER PC does not take away your copyrights and receives permission from the authors to use and dissemination of the publication through the world's scientific resources (own electronic resources, scientometric databases, repositories, libraries, etc.).
In the absence of a signed License Agreement or in the absence of this agreement of identifiers allowing to identify the identity of the author, the editors have no right to work with the manuscript.
It is important to remember that there is another type of agreement between authors and publishers – when copyright is transferred from the authors to the publisher. In this case, the authors lose ownership of their work and may not use it in any way.