Abstract
A temporal database may contain time-related data and handling such kind of database is a challenging task. It is difficult to extract data from a temporal database using natural language (NL) queries. Many NL queries to database interfaces have been developed but these interfaces are not suitable to handle time-related NL queries. The proposed system can handle time-related NL queries in the healthcare domain. A temporal database has been created where various Autism Spectrum Disorders (ASD) real-life problem statements have been stored with time. The proposed system is able to extract data from a temporal database using time-related NL queries with aggregation. Time tick has been assigned for handling temporal queries whereas aggregation methods have been used for handling computational type queries. Auxiliary verbs are used as an indication of whether the NL query is a temporal query. The proposed system has the capacity to produce structured query language (SQL) from temporal and computational types of queries which are frequently occurring in NL. This system will help the parents of an autistic child to enhance their knowledge about autism after getting many real-life autism problems according to time.