SPATIO-TEMPORAL OPERATION HANDLING ON MOVING OBJECT DATABASE

• Main Author: Putra Pamungkas, Naufal
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/51571
• Institution: Institut Teknologi Bandung

A moving object database is a database capable of handling geometrical data that moves over time. Currently, there is an extension that implements data types and operations for moving objects in the PostgreSQL called stpqueries extension. The extension handles queries called spatial-temporal pattern requests using an approach that uses lifted operations groups. Therefore, most of the operations implemented in the extension are lifted operations groups. The Spatio-temporal operations are another operation group on a moving object database that has not been widely implemented in the stpqueries extension. This research focuses on the implementation of the Spatio-temporal operation group using stpqueries extension. The analysis was carried out to determine the Spatio-temporal operation that could be implemented and to identify the need for new data types to implement it. The Spatio-temporal operation implementation was aimed to be generic enough so that if a new spatio-temporal operation is needed, it can be implemented using the generic functions without the need to implement it from scratch. The generic operations are made by generalizing Spatio-temporal operations that have been known and defined in previous studies. The Spatio-temporal operation was generalized into three generic operations that were successfully implemented. By implementing range and interval data types, Spatio-temporal operations can be implemented in stpqueries extension. The new extension successfully handles Spatio-temporal operation using generic functions. This can be seen from the operation testing by executing several queries that involve Spatio-temporal operations.