Premium
Locating and accessing large datasets using Flower Index Approach
Author(s) -
Kvet Michal,
Krsak Emil,
Matiasko Karol
Publication year - 2019
Publication title -
concurrency and computation: practice and experience
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.309
H-Index - 67
eISSN - 1532-0634
pISSN - 1532-0626
DOI - 10.1002/cpe.5209
Subject(s) - computer science , tuple , data mining , database , cache , table (database) , index (typography) , block (permutation group theory) , process (computing) , reliability (semiconductor) , data structure , access method , information retrieval , parallel computing , power (physics) , physics , geometry , mathematics , discrete mathematics , quantum mechanics , world wide web , programming language , operating system
Summary Information system core part is just the data stored in the database. Over the decades, the number and structure of the data have been changed. Nowadays, data must reflect not only current valid data but also historical and future images as well. Each data tuple is therefore delimited by the validity timeframe forming a temporal paradigm. Several temporal models have been developed with an emphasis on the data structure, the frequency of changes, and synchronization processes. Although the system stores time delimited data during the object lifecycle, it is not efficient, even useful to store data in the main system indefinitely. Reliability is another significant aspect of the processing covered by the purging processes. Query processing is based on the accessing data in the memory buffer cache of the database instance preceded by the loading process from the physical database. This paper proposes a Flower Index Approach as the main contribution. It removes the impact of the High Water Mark, removes useless block loading with no relevant data, and provides effective data access stream using a specific index. Full Table Scan is then not used and data are accessed directly using index ROWID locators.