The telematics device, which is a typical embedded system on the transportation or vehicle, requires the embedded spatial DBMS based on RTOS (Real Time Operating System) for processing the huge spatial data in real time. This spatial DBMS can be developed very easily by SQL3 functions of the ORDBMS such as UDT (user-defined type) and UDF (user-defined function). However, developing index suitable for the embedded spatial DBMS is very difficult. This is due to the fact that there is no built-in SQL3 functions to construct spatial indexes. In this study, we compare and analyze both Generalized Search Tree and Relational Indexing methods which are suggested as common ways of developing User-Defined Indexes nowadays. Two implementations of R-Tree based on each method were done and region query performance test results were evaluated for suggesting a suitable indexing method of an embedded spatial DBMS, especially for telematics devices.
[1]
Antonin Guttman,et al.
R-trees: a dynamic index structure for spatial searching
,
1984,
SIGMOD '84.
[2]
Carsten Kleiner,et al.
OraGiST - How to Make User-Defined Indexing Become Usable and Useful
,
2003,
BTW.
[3]
정호영.
A GML Data Storage Method for Spatial Databases
,
2004
.
[4]
Jim Melton,et al.
SQL: 1999, formerly known as SQL3
,
1999,
SGMD.
[5]
Jeffrey F. Naughton,et al.
Generalized Search Trees for Database Systems
,
1995,
VLDB.
[6]
Hans-Peter Kriegel,et al.
The Paradigm of Relational Indexing: a Survey
,
2003,
BTW.
[7]
Christos Faloutsos,et al.
Parallel R-trees
,
1992,
SIGMOD '92.