Optimization of the efficiency of search operations in the relational database of radio electronic systems

Bronisław Wajszczyk; Konrad Biernacki

doi:10.1117/12.2317741

19 April 2018 Optimization of the efficiency of search operations in the relational database of radio electronic systems

Bronisław Wajszczyk, Konrad Biernacki

Author Affiliations +

Proceedings Volume 10715, 2017 Radioelectronic Systems Conference; 107150H (2018) https://doi.org/10.1117/12.2317741
Event: Radioelectronics Systems Conference, 2017, Jachranka, Poland

Abstract

The increase of interoperability of radio electronic systems used in the Armed Forces requires the processing of very large amounts of data. Requirements for the integration of information from many systems and sensors, including radar recognition, electronic and optical recognition, force to look for more efficient methods to support information retrieval in even-larger database resources. This paper presents the results of research on methods of improving the efficiency of databases using various types of indexes. The data structure indexing technique is a solution used in RDBMS systems (relational database management system). However, the analysis of the performance of indices, the description of potential applications, and in particular the presentation of a specific scale of performance growth for individual indices are limited to few studies in this field. This paper contains analysis of methods affecting the work efficiency of a relational database management system. As a result of the research, a significant increase in the efficiency of operations on data was achieved through the strategy of indexing data structures. The presentation of the research topic discussed in this paper mainly consists of testing the operation of various indexes against the background of different queries and data structures. The conclusions from the conducted experiments allow to assess the effectiveness of the solutions proposed and applied in the research. The results of the research indicate the existence of a real increase in the performance of operations on data using indexation of data structures. In addition, the level of this growth is presented, broken down by index types.

Citation Download Citation

Bronisław Wajszczyk and Konrad Biernacki "Optimization of the efficiency of search operations in the relational database of radio electronic systems ", Proc. SPIE 10715, 2017 Radioelectronic Systems Conference, 107150H (19 April 2018); https://doi.org/10.1117/12.2317741

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available