Concept of Dynamic Index Management in Temporal Approach Using Intelligent Transport Systems

Kvet, Michal

doi:10.1007/978-3-319-56535-4_56

Cited by 11 publications

(6 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Moreover, it uses the specific object identifier, as well. Thus, based on the definition, the ROWID value is unique for the standalone database [16].…”

Section: Index Structures and Access Methodsmentioning

confidence: 99%

“…In the database systems, various index structures and approaches can be used. The most often used is just the B-tree and B+tree [16], whereas it maintains the complex efficiency despite frequent changes of records. It does not degrade over time and remains balanced.…”

Section: Index Structures and Access Methodsmentioning

confidence: 99%

“…B+tree index approach is an extension on the leaf layer, where individual nodes are chained together, forming a linked list. Thus, such a layer holds sorted data based on the attributes, which are there indexed [16,17]. B+tree index approach is an extension on the leaf layer, where individual nodes are chained together, forming a linked list.…”

Section: Index Structures and Access Methodsmentioning

confidence: 99%

“…Other index techniques mostly arise from this category and improve either modeled data group or data shapes to be processed, like inverted B+tree key, its unique version, table, or cluster index. Different structural approaches are based on a bitmap or hash indexes, which cannot be, however, universally used due to specific requirements and limitations [16][17][18].…”

Section: Index Structures and Access Methodsmentioning

confidence: 99%

See 3 more Smart Citations

Data Block and Tuple Identification Using Master Index

Kvet

2020

Sensors

Self Cite

View full text Add to dashboard Cite

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.

show abstract

“…Moreover, it uses the specific object identifier, as well. Thus, based on the definition, the ROWID value is unique for the standalone database [16].…”

Section: Index Structures and Access Methodsmentioning

confidence: 99%

Section: Index Structures and Access Methodsmentioning

confidence: 99%

Section: Index Structures and Access Methodsmentioning

confidence: 99%

Section: Index Structures and Access Methodsmentioning

confidence: 99%

See 2 more Smart Citations

Data Block and Tuple Identification Using Master Index

Kvet

2020

Sensors

Self Cite

View full text Add to dashboard Cite

show abstract

“…Performance of each service system depends on reliability of the associated transportation network [4,[8][9][10]. In a real transportation network, various random events may occur, which can considerably elongate the time necessary to traverse the affected arc [7]. The effect of individual arc collapse was studied in [4,9,10], and some measures such as "Network robustness index" and "Network trip robustness" were also suggested.…”

Section: Introductionmentioning

confidence: 99%

Characteristic of a Critical Network Arc in a Service System

Janáček¹,

Kvet²

2018

Transport Problems

View full text Add to dashboard Cite

Vulnerability of a transportation network influences, importantly, the function of public service systems constituted on the network. To be able to study the importance of an individual network arc for proper functionality of the system, we suggested a characteristic function of the arc transit time elongation together with its upper and lower estimations. We also suggested and verified an algorithm that enables the determination of parameters of the characteristic estimation, and we provide a reader with a computational study performed with real road networks.

show abstract

Managing, Locating and Evaluating Undefined Values in Relational Databases

Kvet

2021

Advances in Intelligent Systems and Computing

View full text Add to dashboard Cite

Concept of Dynamic Index Management in Temporal Approach Using Intelligent Transport Systems

Cited by 11 publications

References 4 publications

Data Block and Tuple Identification Using Master Index

Data Block and Tuple Identification Using Master Index

Characteristic of a Critical Network Arc in a Service System

Managing, Locating and Evaluating Undefined Values in Relational Databases

Contact Info

Product

Resources

About