• 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
  • 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
August 13, 2026
‘Working with AI Solves a Wide Range of Engineering Problems
Artificial intelligence is a working tool based on a balanced combination of algorithms and engineering. Experts and doctoral students from the HSE Moscow Institute of Electronics and Mathematics explain how AI technologies can improve an application, device, or system, and what engineering tasks are solved in the process.
August 12, 2026
‘I Would Like My Research to Help Make the World a Calmer and Better Place
Whatever task Saraa Ali, Junior Research Fellow at the Laboratory of Methods for Big Data Analysis (LAMBDA) of the AI and Digital Science Institute (HSE Faculty of Computer Science), is working on, she thinks about how it can benefit people. She told the Young Scientists of HSE University project about her large family, diagnosing three-phase motors, and her dream of building a children’s home in her native country.
August 11, 2026
‘The Peak of Stupidity and ‘The Valley of Despair: HSE Economists Propose an Explanation for the Dunning–Kruger Effect
The Dunning–Kruger effect, which describes a sharp surge in self-confidence among beginners followed by an equally rapid decline as they gain experience, can be explained by the nature of the learning process and the acquisition of new knowledge. This conclusion was reached by Andrey Vorchik of the HSE Faculty of Economic Sciences together with independent researcher Murat Mamyshev. They developed a mathematical model of learning and demonstrated how subjective confidence is formed and changes as knowledge accumulates, as well as how teachers can reduce the ‘valley of despair’ experienced by learners.

 

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