QUERY HANDLING OF TEMPORAL DATA WITH DIFFERENT CALENDAR SYSTEMS AND TIME GRANULARITIES

• Main Author: Dwisaputra, Radiyya
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/43804
• Institution: Institut Teknologi Bandung

Temporal data is a type of data that changes over time, this kind of data have been used in information systems that involves recording the history of the entity. Those things make temporal data processing becomes important. Temporal data itself can have different time granularities or different calendar systems. Meanwhile, different time granularity and different calendar system cannot be handled yet with a well-known DBMS. Hence, in this thesis, a tool will be built to make a DBMS supports temporal data with different calendar systems and different time granularities. This tool consists of two parts, i.e. DBMS extension and application modules. DBMS extension can be used to handle processing of temporal data with different calendar systems and time granularities with an implementation of some data types to store time, metadata to store time information, and functions to validate and convert time in the DBMS. Application module can be used to translate the query given by the user, so the user doesn’t have to enter complex query. The application module also simplifies the process done by the database administrator when they enter the definition of a new time granularities. The evaluation is done by add two different calendar systems and two new time granularities. Next, simple queries are executed that operate data using the calendar systems and time granularities. Simple queries that are tested cover data temporal operation SELECT, INSERT, DELETE, and JOIN. This testing is done to make sure that the tool can handle different calendar systems and time granularities. The test result shows that the tool can run the queries and give expected query results.