• 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
June 4, 2026
Machine Learning Models Can Help Reduce Volatility and Boost Stock Market Returns
The use of machine learning models makes it possible to achieve greater accuracy in predicting risks in the Russian stock market compared to classical econometric approaches. The predictive power of these models increases by 23%, while the average investor’s return can reach up to 13% per annum. These conclusions were drawn by Nikita Lysenok from the Department of Financial Market Infrastructure at the HSE Faculty of Economic Sciences. The paper has been published in Fundamental and Applied Mathematics.
June 3, 2026
Pocket Money, Personal Interest, and Family Practices: What Shapes Students Economic Literacy?
University students' economic literacy depends not only on their field of study but also on their interest in economics, the learning environment, and family financial practices. For example, students who received pocket money irregularly tend to perform better on economic literacy tests than their peers who received financial support on a regular basis. These findings come from a study conducted by HSE University involving more than 1,100 students from five Russian universities. The findings have been published in Cakrawala Pendidikan.
June 3, 2026
Creative Work as a Remedy for Burnout
The creative, supportive atmosphere and innovative methods at the Centre for Sociocultural Research make it appealing to early-career scholars. Over years of working at HSE University, they grow into researchers and lecturers recognised both in Russia and abroad. Chief Research Fellow Zarina Lepshokova and Leading Research Fellow Ekaterina Bushina spoke about their journey at the centre and at HSE, their research, and the role of mentors in their academic success.

 

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