Next Article in Journal
A Quantum Cascade Laser-Based Multi-Gas Sensor for Ambient Air Monitoring
Previous Article in Journal
Multi-objective Informative Frequency Band Selection Based on Negentropy-induced Grey Wolf Optimizer for Fault Diagnosis of Rolling Element Bearings
Open AccessArticle

Data Block and Tuple Identification Using Master Index

Faculty of Management Science and Informatics, University of Zilina, 010 26 Zilina, Slovakia
*
Authors to whom correspondence should be addressed.
Sensors 2020, 20(7), 1848; https://doi.org/10.3390/s20071848
Received: 28 January 2020 / Revised: 9 March 2020 / Accepted: 23 March 2020 / Published: 26 March 2020
(This article belongs to the Section Sensor Networks)
Relational databases are still very often used as a data storage, even for the sensor oriented data. Each data tuple is logically stored in the table referenced by relationships between individual tables. From the physical point of view, data are stored in the data files delimited by the tablespaces. Files are block-oriented. When retrieving data, particular blocks must be identified and transferred into the memory for the evaluation and processing. This paper deals with storage principles and proposes own methods for effective data block location and identification if no suitable index for the query is present in the system. Thanks to that, the performance of the whole system is optimized, and the processing time and costs are significantly lowered. The proposed solution is based on the master index, which points just to the blocks with relevant data. Thus, no sequential block scanning is necessary for consuming many system resources. The paper analyzes the impact of block size, which can have a significant impact on sensor oriented data, as well. View Full-Text
Keywords: data tuple; relational database; index; block; query optimization data tuple; relational database; index; block; query optimization
Show Figures

Figure 1

MDPI and ACS Style

Kvet, M.; Matiasko, K. Data Block and Tuple Identification Using Master Index. Sensors 2020, 20, 1848.

Show more citation formats Show less citations formats
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Access Map by Country/Region

1
Back to TopTop