KMITL

Permanent URI for this communityhttps://dspace.kmitl.ac.th/handle/123456789/1

Browse

Settings

Author: search.filters.author.Jitkajornwanich, KulsawasdSubject: search.filters.subject.SQL

Search Results

Now showing 1 - 2 of 2
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    A survey on spatial, temporal, and spatio-temporal database research and an original example of relevant applications using sql ecosystem and deep learning
    (2020-01-01)
    Jitkajornwanich, Kulsawasd
    ;
    Pant, Neelabh
    ;
    Fouladgar, Mohammadhani
    ;
    Elmasri, Ramez
    Spatio-temporal data serves as a foundation for most location-based applications nowadays. To handle spatio-temporal data, an appropriate methodology needs to be properly followed, in which space and time dimensions of data must be taken into account ‘altogether’ –unlike spatial (or temporal) data management tools which consider space (or time) separately and assumes no dependency on one another. In this paper, we conducted a survey on spatial, temporal, and spatio-temporal database research. Additionally, to use an original example to illustrate how today’s technologies can be used to handle spatio-temporal data and applications, we categorize the current technologies into two groups: (1) traditional, mainstay tools (e.g. SQL ecosystem) and (2) emerging, data-intensive tools (e.g. deep learning). Specifically, in the first group, we use our spatio-temporal application based on SQL system, ‘hydrological rainstorm analysis’, as an original example showing how analysis and mining tasks can be performed on the conceptual storm stored in a spatio-temporal RDB. In the second group, we use our spatio-temporal application based on deep learning, ‘users’ future locations prediction based on historical trajectory GPS data using hyper optimized ANNs and LSTMs’, as an original example showing how deep learning models can be applied to spatio-temporal data.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    Proving completeness of open GIS SQL spatial relationships and operations
    (2017-10-19)
    Jitkajornwanich, Kulsawasd
    ;
    Elmasri, Ramez
    OpenGIS SQL is a standard for incorporating GIS and spatial concepts into SQL. Two types of methods are part of OpenGIS SQL: (1) boolean methods for topological relationships among spatial objects, and (2) methods for specifying spatial operations. We prove that the complete set of 2-dimensional spatial relationships defined by Egenhofer can all be specified using OpenGIS SQL operations and relationships. Our proof shows how each spatial relationship can be specified using OpenGIS SQL and thus provides users with the means of determining how each spatial relationship can be written in SQL. This provides users with enhanced usability and flexibility by providing the specific OpenGIS conditions for every possible 2- dimensional spatial relationship.