Nguyen T. The increase of efficiency of application of the materialized views in the automated computer systems with relational databases

Українська версія

Thesis for the degree of Candidate of Sciences (CSc)

State registration number

0406U000576

Applicant for

Specialization

  • 05.13.06 - Інформаційні технології

19-01-2006

Specialized Academic Board

Д 41.052.01

Odessa National Polytechnic University

Essay

Object are the automated computer systems (ACS) using relational DBMS; a purpose is the increase of the ACS productivity with relational DBMS by the improvement of technology of application of the materialized views (MV); methods are the methods of statistical analysis and theory of chances, set theory, discrete mathematics, relational algebra; novelty - – the method of the ACS analysis with minimization of amount of selections, foreseeing forming of groups of queries with the purpose of reduction of amount of served to MV, simplification of structure and volume of relational database is developed; – the mathematical model of presentation and method of comparison and count of queries is developed. – classification of information is offered in ACS from point of requirements to their actuality and a method of asynchronous update of MV is developed; - the algorithm of incremental update of MV is improved, based on the meter of doublets of records of MV of the type Select-Project-Join.

Files

Similar theses