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.

中文翻译：

---

使用主索引识别数据块和元组。

关系数据库仍然经常用作数据存储，甚至用于面向传感器的数据。每个数据元组逻辑上存储在由各个表之间的关系引用的表中。从物理角度来看，数据存储在由表空间分隔的数据文件中。文件是面向块的。检索数据时，必须识别特定的块并将其传输到存储器中以进行评估和处理。本文讨论了存储原理，并提出了自己的方法，以在系统中不存在适合查询的索引时有效地进行数据块定位和识别。因此，可以优化整个系统的性能，并显着降低处理时间和成本。提议的解决方案基于主索引，仅指向具有相关数据的块。因此，不需要顺序块扫描来消耗许多系统资源。本文分析了块大小的影响，这也可能对面向传感器的数据产生重大影响。