?
Использование индексов в реляционных СУБД
С. 42–45.
Вендин А. С.
In this paper, we consider a solution that helps increase the speed of searching and retrieving data in relational DBMSs, such as Oracle and MySQL. This solution is called an index. We consider the types of indexes that are unique only for a particular DBMS, and indexes that are used in almost all databases. A test database for experiments has been created. The analysis is carried out for certain types of requests, the same for all investigated databases. Based on the results of the queries, a number of recommendations have been made on the use of indexes in specific DBMS and for specific types of query, as well as a number of general recommendations for writing relational queries
In book
Уфа: Общество с ограниченной ответственностью "Аэтерна", 2017.
Karpova I. P., Вендин А. С., [б.и.], 2025.
The laboratory works are devoted to the study of SQL, the query language for databases. His work includes the study of relational algebra operations, data definition language, data manipulation language, simple and complex data queries, and representations. For students of the II-IV courses of technical faculties studying automated information systems and database systems. ...
Added: April 2, 2025
Karpova I. P., М.: МИЭМ НИУ ВШЭ, 2024.
The laboratory work is devoted to the study of the rules for creating and using indexes to speed up the execution of queries in SQL. The work can be performed under Oracle or PostgreSQL DBMS management.
For students of the II-IV courses of technical faculties studying automated information systems and database systems. ...
Added: January 20, 2024
Rodriges Zalipynis R. A., St. Petersburg: Naukoemkie Technologii, 2023.
Experts estimate that location (spatial) components are part of about 80% of all data in the world. Spatial Data are crucial for Urban, Forest, and Water Management, Rapid Response to Emergencies, Air Quality Control, Food Security, Environmental Monitoring, and myriads of other practical tasks.
The Course Syllabus (Curriculum) proposes to acquire fundamental knowledge and skills in ...
Added: January 19, 2024
Krayushkin O., Смирнов М., Чернобай Ю., В кн.: 1st conference on Software Engineering and Information Management (SEIM-2016).: СПб.: [б.и.], 2016.
в работе были выявлены основные особенности организации сборки, хранения и предобработки датасета для формирования обучающей выборки multi-label классификатора текстов на естественном русском языке ...
Added: November 4, 2021
Shershakov Sergey A., , in: Tools and Methods of Program Analysis. 5th International Conference, TMPA 2019, Tbilisi, Georgia, November 7–9, 2019, Revised Selected PapersVol. 1288: CCIS.: Springer, 2021. P. 68–80.
Added: October 28, 2019
A.M. Rigin, S.A. Shershakov, Proceedings of the Institute for System Programming of the RAS 2019 Vol. 31 No. 3 P. 203–216
Multiway trees are one of the most popular solutions for the big data indexing. The most commonly used kind of the multiway trees is the B-tree. There exist different modifications of the B-trees, including B+-trees, B*-trees and B*+-trees considered in this work. However, these modifications are not supported by the popular open-source relational DBMS SQLite. ...
Added: September 15, 2019
Alexandrov D., Uddin M. S., , in: Intelligent Systems and ApplicationsVol. 2.: Cham: Springer, 2019. P. 1–19.
Day by day data volumes are increasing, and most of the data are stored in the databases after manual transformations and derivations. The behavior of those stored data is unpredictable. Furthermore, the data are collected from various sources such as physical, geological, environmental, chemical, and biological. A relational database management system (RDBMS) provides a high ...
Added: August 29, 2018
С.Д. Кузнецов, Труды Института системного программирования РАН 2017 Т. 29 № 2 С. 117–160
In October 2013, the eighth meeting of researchers in the field of databases was held. The first such meeting took place in February 1988, so that 25 years passed between them. After each meeting, a report was published containing an overview of the current state of the field and a research program for the nearest ...
Added: February 12, 2018
Сергей Кузнецов, Посконин А. В., Открытые системы. СУБД 2013 № 9 С. 38–41
Many different data management systems are available nowadays, ranging from familiar SQL-based solutions to completely new systems designed from scratch. Wide range of available options made it possible to choose one that optimally suits application requirements. However, one can benefit even more from using different solutions within a single application for particular tasks. This paper ...
Added: January 30, 2018
Kuznetsov S. D., Открытые системы. СУБД 2013 № 2 С. 48–51
The issues of Big Data begin to touch upon transactional systems despite the fact that they contain orders of magnitude less data than some others do. Yet, today they process vast amount of information and transactions requiring approaches that ensure robust scalability. Let’s consider the types of scalability suitable for transactional domain, the issues specific ...
Added: January 30, 2018
С.Д. Кузнецов, Труды Института системного программирования РАН 2015 Т. 27 № 1 С. 173–192
In 2005, I wrote an article in which I discussed the most important features of the standards ODMG 3.0 (ODMG object model) and the SQL:2003 (SQL data model) and convincingly (as it seemed to me) argued that the similarity between the object model and object extensions to SQL is purely external, that close in mind ...
Added: January 23, 2018
Вендин А. С., В кн.: Интеллектуальный и научный потенциал XXI века: сборник статей Международной научно-практической конференции: в 4 частях. 2017Ч. 3.: Уфа: Общество с ограниченной ответственностью "ОМЕГА САЙНС", 2017. С. 13–16.
In this paper, we consider a solution that helps increase the search speed and data fetching in relational databases such as Oracle and MySQL. This solution is called an index. We consider types of indices, which are unique only for specific DBMS, and indexes, which are used in almost all databases. Created by test database ...
Added: December 12, 2017
Вендин А. С., В кн.: Инновационные технологии научного развития: сборник статей международной научно-практической конференции: в 5 частях. 2017.: Уфа: Общество с ограниченной ответственностью "Аэтерна", 2017. С. 40–42.
When working with relational databases, the main time is loading, searching, update and unload data. When the amount of data is increased, the time to perform these operations is significantly increased, since in fact, all available records, and this reduces the performance and processing speed of the data. One possible way to increase productivity and ...
Added: December 12, 2017