{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,8]],"date-time":"2026-07-08T22:37:29Z","timestamp":1783550249585,"version":"3.55.0"},"reference-count":29,"publisher":"MDPI AG","issue":"7","license":[{"start":{"date-parts":[[2020,3,26]],"date-time":"2020-03-26T00:00:00Z","timestamp":1585180800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Sensors"],"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.3390\/s20071848","type":"journal-article","created":{"date-parts":[[2020,4,1]],"date-time":"2020-04-01T03:44:13Z","timestamp":1585712653000},"page":"1848","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":8,"title":["Data Block and Tuple Identification Using Master Index"],"prefix":"10.3390","volume":"20","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-3937-7473","authenticated-orcid":false,"given":"Michal","family":"Kvet","sequence":"first","affiliation":[{"name":"Faculty of Management Science and Informatics, University of Zilina, 010 26 Zilina, Slovakia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Karol","family":"Matiasko","sequence":"additional","affiliation":[{"name":"Faculty of Management Science and Informatics, University of Zilina, 010 26 Zilina, Slovakia"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1968","published-online":{"date-parts":[[2020,3,26]]},"reference":[{"key":"ref_1","unstructured":"Bryla, B. (2013). Oracle Database 12c the Complete Reference, Oracle Press."},{"key":"ref_2","unstructured":"Date, C.J. (2015). SQL and Relational Theory\u2014How to Write Accurate SQL Code, O\u2019Reilly Media."},{"key":"ref_3","unstructured":"Feuerstein, S. (2007). Oracle PL\/SQL Best Practices\u2014Write the Best PL\/SQL Code of Your Life, O\u2019Reilly Media."},{"key":"ref_4","unstructured":"Burleson, D.K. (2001). Oracle High-Performance SQL Tuning, Oracle Press."},{"key":"ref_5","first-page":"e60038","article-title":"Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering","volume":"22","author":"Ochs","year":"2019","journal-title":"J. Vis. Exp."},{"key":"ref_6","doi-asserted-by":"crossref","unstructured":"Lan, L., Shi, R., Wang, B., Zhang, L., and Shi, J. (2020). A Lightweight Time Series Main-Memory Database for IoT Real-Time Services. Lecture Notes in Computer Science, Springer.","DOI":"10.1007\/978-3-030-38651-1_19"},{"key":"ref_7","doi-asserted-by":"crossref","unstructured":"Delplanque, J., Etien, A., Anquetil, N., and Auverlot, O. (2018, January 23\u201329). Relational database schema evolution: An industrial case study. Proceedings of the IEEE International Conference on Software Maintenance and Evolution, ICSME 2018, Madrid, Spain.","DOI":"10.1109\/ICSME.2018.00073"},{"key":"ref_8","unstructured":"He, D. (2018, January 25\u201327). Research on distributed database access technology based on Net. Proceedings of the International Conference on Big Data Engineering and Technology, BDET 2018, Chengdu, China."},{"key":"ref_9","doi-asserted-by":"crossref","unstructured":"Vinayakumar, R., Soman, K., and Menon, P. (2018, January 10\u201312). DB-Learn: Studying Relational Algebra Concepts by Snapping Blocks. Proceedings of the Communication and Networking Technologies, ICCCNT 2018, Bangalore, India.","DOI":"10.1109\/ICCCNT.2018.8494181"},{"key":"ref_10","doi-asserted-by":"crossref","unstructured":"Alwehaibi, A., and Atay, M. (2017, January 10\u201312). A rule-based relational xml access control model in the presence of authorization conflicts. Proceedings of the 14th International Conference on Information Technology\u2014New Generations, ITNG 2017, Las Vegas, NV, USA.","DOI":"10.1007\/978-3-319-54978-1_43"},{"key":"ref_11","doi-asserted-by":"crossref","unstructured":"Smolinski, M. (2018, January 17\u201322). Impact of storage space configuration on transaction processing performance for relational database in PostgreSQL. Proceedings of the 14th International Conference on Beyond Databases, Architectures and Structures, BDAS, Poznan, Poland.","DOI":"10.1007\/978-3-319-99987-6_12"},{"key":"ref_12","doi-asserted-by":"crossref","unstructured":"Eisa, I., Salem, R., and Abdelkader, H. (2018, January 18\u201319). A fragmentation algorithm for storage management in cloud database environment. Proceedings of the ICCES 2017 12th International Conference on Computer Engineering and Systems, Cairo, Egypt.","DOI":"10.1109\/ICCES.2017.8275293"},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"255","DOI":"10.1134\/S1995080216030136","article-title":"Join decomposition based on fragmented column indices","volume":"37","author":"Ivanova","year":"2016","journal-title":"Lobachevskii J. Math."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"427","DOI":"10.1016\/j.chb.2013.04.025","article-title":"A synchronized design technique for efficient data distribution","volume":"30","author":"Abdalla","year":"2014","journal-title":"Comput. Hum. Hevaior"},{"key":"ref_15","doi-asserted-by":"crossref","unstructured":"Abdalla, H.I., and Amer, A.A. (2012, January 24\u201326). Dynamic horizontal fragmentation, replication and allocation model in DDBSs. Proceedings of the International Conference on Information Technology and e-Services, ICITeS 2012, Sousse, Tunisia.","DOI":"10.1109\/ICITeS.2012.6216603"},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Kvet, M., and Matia\u0161ko, K. (2017). Concept of dynamic index management in temporal approach using intelligent transport systems. Recent Advances in Information Systems and Technologies, Springer.","DOI":"10.1007\/978-3-319-56535-4_56"},{"key":"ref_17","doi-asserted-by":"crossref","unstructured":"Dan, T., Luo, C., Li, Y., Zheng, B., and Li, G. (2019). Spatial temporal trajectory similarity join. Lecture Notes in Computer Science, Springer.","DOI":"10.1007\/978-3-030-26075-0_19"},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"17","DOI":"10.1016\/j.is.2019.07.004","article-title":"Temporal data exchange","volume":"87","author":"Golshanara","year":"2020","journal-title":"Inf. Syst."},{"key":"ref_19","unstructured":"Moreira, J., Duarte, J., and Dias, P. (2019, January 9\u201313). Modeling and representing real-world spatio-temporal data in databases. Proceedings of the Leibniz International Proceedings in Informatics, LIPIcs, Regensburg, Germany."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"563","DOI":"10.1109\/69.536250","article-title":"Extending Existing Dependency Theory to Temporal Databases","volume":"8","author":"Jensen","year":"1996","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"ref_21","doi-asserted-by":"crossref","unstructured":"Mat\u00e9, J. (2011, January 5\u20136). Transformation of Relational Databases to Transaction-Time Temporal Databases. Proceedings of the 2011 Second Eastern European Regional Conference on the Engineering of Computer Based Systems, Bratislava, Slovakia.","DOI":"10.1109\/ECBS-EERC.2011.14"},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"275","DOI":"10.1016\/j.ssci.2019.03.014","article-title":"Temporal topic modeling applied to aviation safety reports: A subject matter expert review","volume":"116","author":"Robinson","year":"2019","journal-title":"Saf. Sci."},{"key":"ref_23","doi-asserted-by":"crossref","unstructured":"Kvet, M., and Matia\u0161ko, K. (2018, January 23\u201325). Analysis of temporal data management in the intelligent transport system. Proceedings of the DISA 2018: IEEE World Symposium on Digital Intelligence for Systems and Machines, Ko\u0161ice, Slovakia.","DOI":"10.1109\/DISA.2018.8490524"},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Kvet, M., and Matia\u0161ko, K. (2018, January 18\u201320). Temporal flower index eliminating impact of high water mark. Proceedings of the Innovations for Community Services, Zilina, Slovakia.","DOI":"10.1007\/978-3-319-93408-2_7"},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"1","DOI":"10.3233\/AIC-190619","article-title":"Dealing with temporal indeterminacy in relational databases: An AI methodology","volume":"32","author":"Anselma","year":"2019","journal-title":"AI Commun."},{"key":"ref_26","first-page":"473","article-title":"Compact representations of temporal databases","volume":"28","author":"Bronselaer","year":"2019","journal-title":"VLBD J."},{"key":"ref_27","doi-asserted-by":"crossref","first-page":"430","DOI":"10.1080\/15481603.2018.1509463","article-title":"Data-enriched interpolation for temporally consistent population compositions","volume":"56","author":"Zoraghein","year":"2019","journal-title":"GISci. Remote Sens."},{"key":"ref_28","doi-asserted-by":"crossref","unstructured":"Kvet, M., Kr\u0161\u00e1k, E., and Matia\u0161ko, K. (2018, January 15\u201318). Temporal database architecture enhancements. Proceedings of the 22nd Conference of Open Innovations Association (FRUCT), Jyvaskyla, Finland.","DOI":"10.23919\/FRUCT.2018.8468305"},{"key":"ref_29","first-page":"647","article-title":"Temporal based multimedia data archive","volume":"7","author":"Saany","year":"2019","journal-title":"Int. J. Recent Technol. Eng."}],"container-title":["Sensors"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/1424-8220\/20\/7\/1848\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T09:12:05Z","timestamp":1760173925000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/1424-8220\/20\/7\/1848"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,3,26]]},"references-count":29,"journal-issue":{"issue":"7","published-online":{"date-parts":[[2020,4]]}},"alternative-id":["s20071848"],"URL":"https:\/\/doi.org\/10.3390\/s20071848","relation":{},"ISSN":["1424-8220"],"issn-type":[{"value":"1424-8220","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,3,26]]}}}