KMITL

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

Browse

Settings

Author: search.filters.author.Chittayasothorn, SuphamitSubject: search.filters.subject.SQL

Search Results

Now showing 1 - 5 of 5
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    Using LLM Artificial Intelligence Systems as Complex SQL Programming Assistants
    (2024-01-01)
    Pornphol, Putsadee
    ;
    Chittayasothorn, Suphamit
    Learning database programming such as SQL programming is a challenging task when the queries become more complex. SQL is a declarative language based on relational calculus which describes the definition of the query results instead of describing the procedure or steps used to obtain the query result. Tutorial sessions using tutorial assistances are generally required to support the learning of advanced part of the language. Recently generative AI systems demonstrated question answering capabilities including programming codes generation. This paper verifies the SQL code generating capabilities of four generative AI systems: Bing, Bard, ChatGPT, and Copilot and their suitability as SQL programming assistants.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    Verification of Relational Database Languages Codes Generated by ChatGPT
    (2023-10-27)
    Pornphol, Putsadee
    ;
    Chittayasothorn, Suphamit
    The potential of using large language model artificial intelligence systems to generate program codes for application development is significant. Database codes in SQL (Structured Query Language), which is the standard relational database language, can be generated by such systems. Generative AI systems know database languages syntax through their training data and the text patterns from various sources that include SQL queries and related text. Thus, the generated codes may not be perfect and need verification before usage. This paper verifies the relational completeness of the SQL codes generated by ChatGPT, one of the most widely used large language model systems. Relational algebra operators are used for the relational complete verification. An equivalent relational calculus statement is generated for each SQL and relational algebra statement. The results confirmed that ChatGPT has the ability to generate relational complete SQL, relational algebra, and relational calculus codes.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    Relational Database Principles Consideration for SQL Programming
    (2023-01-01)
    Pornphol, Putsadee
    ;
    Chittayasothorn, Suphamit
    In practice, SQL programmers often encounter queries which are hard to formulate using SQL statements. Many of them do not know if the queries are too hard beyond their capabilities, or they are the limitations of the language. Many of these programmers only know that SQL statements work on database tables and are not aware of relational database and the relational complete language principle. This paper presents the common problems that SQL programmers encounter and refers to the relevant relational database principles as solutions.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    A temporal object relational SQL language with attribute timestamping in a temporal transparency environment
    (2008-12-01)
    Chau, Vo Thi Ngoc
    ;
    Chittayasothorn, Suphamit
    In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of any type is naturally handled. With temporal logic, users can issue temporal queries in an intuitively expressive manner. The language provides valid time support for upward compatibility, temporal upward compatibility, sequenced and non-sequenced variants to serve both non-temporal and temporal users. Using object relational technology, the implementation is made for embedded and interactive SQL modes. All existing interfaces of an ORDBMS are inherited with temporal transparency. © 2008 Elsevier B.V. All rights reserved.
  • Loading...
    Thumbnail Image
    Some of the metrics are blocked by your 
    consent settings
    Item type:Item,
    A temporal compatible object relational database system
    (2007-01-01)
    Vo, Thi Ngoc Chau
    ;
    Chittayasothorn, Suphamit
    Time-varying data management has been much taken into consideration with either the tuple(object)timestamping or attribute-timestamping scheme. The first scheme is simpler with first normal form relations; but the second is more expressive and natural with unnormalized tables. However, no existing database management system has supported the handling of attribute timestamping on such unnormalized tables. In addition, even though planned for a long time, standards SQL have not yet been published with any temporal semantics. Moreover, there exists no available environment where both temporal and nontemporal database users work together with different awareness of temporal aspects of a database. Therefore, to facilitate the temporal data management according to users' needs and their own ability in data manipulations, a database system is figured out with several types of database users in this paper. It is a temporal object relational database system following the attribute timestamping scheme, allowing upward compatibility with SQL:2003 and temporal upward compatibility. The implementation is carried out on Oracle 10g without the introduction of any new temporal clauses into SQL:2003. As a result, both temporal and nontemporal database users do not have to make any effort to use this system © 2007 IEEE.