• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • A
  • A
  • A
  • A
  • A
Обычная версия сайта
  • RU
  • EN
  • HSE University
  • Publications
  • Book chapter
  • Использование индексов в реляционных СУБД
  • RU
  • EN
Расширенный поиск
Высшая школа экономики
Национальный исследовательский университет
Priority areas
  • business informatics
  • economics
  • engineering science
  • humanitarian
  • IT and mathematics
  • law
  • management
  • mathematics
  • sociology
  • state and public administration
by year
  • 2028
  • 2027
  • 2026
  • 2025
  • 2024
  • 2023
  • 2022
  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003
  • 2002
  • 2001
  • 2000
  • 1999
  • 1998
  • 1997
  • 1996
  • 1995
  • 1994
  • 1993
  • 1992
  • 1991
  • 1990
  • 1989
  • 1988
  • 1987
  • 1986
  • 1985
  • 1984
  • 1983
  • 1982
  • 1981
  • 1980
  • 1979
  • 1978
  • 1977
  • 1976
  • 1975
  • 1974
  • 1973
  • 1972
  • 1971
  • 1970
  • 1969
  • 1968
  • 1967
  • 1966
  • 1965
  • 1964
  • 1963
  • 1958
  • More
Subject
News
September 22, 2026
Personal Interest in Doctoral Thesis Topic Most Important for Confidence in Successful Defence
A researcher at HSE University analysed data on 1,539 doctoral students from 161 Russian universities to identify which features of a thesis topic are associated with academic success and engagement. The most important factor was found to be personal interest in the research topic, which was associated with almost all key aspects of doctoral programme experience—from engaging with the academic supervisor to research activity and confidence about successfully defending the thesis. The findings have been published in Higher Education.
September 21, 2026
Researchers Develop Methodology to Assess the Quality of Legal Representation in Criminal Proceedings
Having a good defence attorney in criminal proceedings can largely determine whether a defendant retains their freedom, health and good name. Researchers at HSE University propose a method for predicting an attorney’s performance based on the outcomes of their previous cases. The methodology takes into account the severity of the charges, the complexity of the cases, and the most likely outcome, drawing on judicial statistics.
September 21, 2026
Algebra, Geometry, and AI: Russian and Vietnamese Mathematicians Discuss Current Research
A delegation of scientists from Hanoi visited the HSE Faculty of Computer Science and then took part in a Russian-Vietnamese conference in St Petersburg. The events were part of the three-year project ‘Flexibility and Computational Methods.’ Over the course of the project, the researchers have prepared joint publications and obtained new mathematical results.

 

Have you spotted a typo?
Highlight it, click Ctrl+Enter and send us a message. Thank you for your help!

Publications
  • Books
  • Articles
  • Chapters of books
  • Working papers
  • Report a publication
  • Research at HSE

?

Использование индексов в реляционных СУБД

С. 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

Language: Russian
Full text
Text on another site
Keywords: MySQLOracleMySQLOracleSQLСУБДSQLRDBMS

In book

Инновационные технологии научного развития: сборник статей международной научно-практической конференции: в 5 частях. 2017
Уфа: Общество с ограниченной ответственностью "Аэтерна", 2017.
Similar publications
Изучение основ языка SQL
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
Создание и использование индексов в реляционных базах данных: Методические указания к лабораторной работе №5 по курсу "Базы данных"
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
Spatial Data Management
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
Сборка, хранение и предобработка коллекции документов для обучения multi-label классификатора текстов на естественном русском языке
Krayushkin O., Смирнов М., Чернобай Ю., В кн.: 1st conference on Software Engineering and Information Management (SEIM-2016).: СПб.: [б.и.], 2016.
в работе были выявлены основные особенности организации сборки, хранения и предобработки датасета для формирования обучающей выборки multi-label классификатора текстов на естественном русском языке ...
Added: November 4, 2021
Multi-Perspective Process Mining with Embedding Configurations into DB-based Event Logs
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
SQLite RDBMS Extension for Data Indexing Using B-tree Modifications
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
A Query Inversion Technique for Detection of Unexpected Values in Relational Databases
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
Управление данными: 25 лет прогнозов
С.Д. Кузнецов, Труды Института системного программирования РАН 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
Возможно ли сотрудничество SQL и NoSQL?
Сергей Кузнецов, Посконин А. В., Открытые системы. СУБД 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
Объектные модели ODMG и SQL десять лет спустя: нет противоречий
С.Д. Кузнецов, Труды Института системного программирования РАН 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
  • About
  • About
  • Key Figures & Facts
  • Sustainability at HSE University
  • Faculties & Departments
  • International Partnerships
  • Faculty & Staff
  • HSE Buildings
  • HSE University for Persons with Disabilities
  • Public Enquiries
  • Studies
  • Admissions
  • Programme Catalogue
  • Undergraduate
  • Graduate
  • Exchange Programmes
  • Summer University
  • Summer Schools
  • Semester in Moscow
  • Business Internship
  • Research
  • International Laboratories
  • Research Centres
  • Research Projects
  • Monitoring Studies
  • Conferences & Seminars
  • Academic Jobs
  • Yasin (April) International Academic Conference on Economic and Social Development
  • Media & Resources
  • Publications by staff
  • HSE Journals
  • Publishing House
  • iq.hse.ru: commentary by HSE experts
  • Library
  • Economic & Social Data Archive
  • Video
  • HSE Repository of Socio-Economic Information
  • HSE1993–2026
  • Contacts
  • Copyright
  • Privacy Policy
  • Site Map
Edit