PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL
The aim of our research presented was to evaluate the semantic coverability of PQL (Public Query Language) as a query language, compared to SQL (Structured Query Language). Our approach in doing the evaluation was to develop conversion rules from SQL to PQL statements, by using relational expression...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Petra Christian University
2007-01-01
|
| Series: | Jurnal Informatika |
| Subjects: | |
| Online Access: | http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/16771 |
| _version_ | 1811344358751862784 |
|---|---|
| author | Benhard Sitohang Tricya Esterina Widagdo |
| author_facet | Benhard Sitohang Tricya Esterina Widagdo |
| author_sort | Benhard Sitohang |
| collection | DOAJ |
| description | The aim of our research presented was to evaluate the semantic coverability of PQL (Public Query Language) as a query language, compared to SQL (Structured Query Language). Our approach in doing the evaluation was to develop conversion rules from SQL to PQL statements, by using relational expressions as the intermediate language. The SQL syntaxes were grouped into four categories, based on the number of relations used in the queries and whether the queries were nested or not. Based on the conversions results, it can be concluded that all of SQL statements that include one or more relations with natural join operations - with or without nested sub queries - can be converted into PQL statements. Abstract in Bahasa Indonesia : Evaluasi cakupan semantik PQL (Public Query Language) sebagai satu query, dibandingkan dengan SQL, merupakan kajian utama pada penelitian tentang konversi yang dijelaskan pada makalah ini. Pendekatan dalam evaluasi tersebut, dilakukan dengan mengembangkan dan uji-coba konversi dari SQL menjadi PQL, dengan menggunakan operator relasi sebagai media konversi. Dari pengembangan konversi ini telah dapat mengelompokkan, bahwa semua sintaks SQL yang didasarkan pada natural join dan melibatkan 1 atau beberapa relasi, dapat dikonversi menjadi sintaks PQL, baik query yang bersarang (nested) maupun tidak bersarang. Kata kunci: Public Query Language (PQL), Structured Query Language (SQL), model relasi, operator relasi. |
| first_indexed | 2024-04-13T19:46:15Z |
| format | Article |
| id | doaj.art-41ad7921cb364ac0b5b2cb44f0baec80 |
| institution | Directory Open Access Journal |
| issn | 1411-0105 |
| language | English |
| last_indexed | 2024-04-13T19:46:15Z |
| publishDate | 2007-01-01 |
| publisher | Petra Christian University |
| record_format | Article |
| series | Jurnal Informatika |
| spelling | doaj.art-41ad7921cb364ac0b5b2cb44f0baec802022-12-22T02:32:43ZengPetra Christian UniversityJurnal Informatika1411-01052007-01-0182pp.7986PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQLBenhard SitohangTricya Esterina WidagdoThe aim of our research presented was to evaluate the semantic coverability of PQL (Public Query Language) as a query language, compared to SQL (Structured Query Language). Our approach in doing the evaluation was to develop conversion rules from SQL to PQL statements, by using relational expressions as the intermediate language. The SQL syntaxes were grouped into four categories, based on the number of relations used in the queries and whether the queries were nested or not. Based on the conversions results, it can be concluded that all of SQL statements that include one or more relations with natural join operations - with or without nested sub queries - can be converted into PQL statements. Abstract in Bahasa Indonesia : Evaluasi cakupan semantik PQL (Public Query Language) sebagai satu query, dibandingkan dengan SQL, merupakan kajian utama pada penelitian tentang konversi yang dijelaskan pada makalah ini. Pendekatan dalam evaluasi tersebut, dilakukan dengan mengembangkan dan uji-coba konversi dari SQL menjadi PQL, dengan menggunakan operator relasi sebagai media konversi. Dari pengembangan konversi ini telah dapat mengelompokkan, bahwa semua sintaks SQL yang didasarkan pada natural join dan melibatkan 1 atau beberapa relasi, dapat dikonversi menjadi sintaks PQL, baik query yang bersarang (nested) maupun tidak bersarang. Kata kunci: Public Query Language (PQL), Structured Query Language (SQL), model relasi, operator relasi.http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/16771Public Query Language (PQL)Structured Query Language (SQL)relational modelrelational operator. |
| spellingShingle | Benhard Sitohang Tricya Esterina Widagdo PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL Jurnal Informatika Public Query Language (PQL) Structured Query Language (SQL) relational model relational operator. |
| title | PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL |
| title_full | PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL |
| title_fullStr | PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL |
| title_full_unstemmed | PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL |
| title_short | PQL: KONVERSI SINTAKS SQL MENJADI SINTAKS PQL |
| title_sort | pql konversi sintaks sql menjadi sintaks pql |
| topic | Public Query Language (PQL) Structured Query Language (SQL) relational model relational operator. |
| url | http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/16771 |
| work_keys_str_mv | AT benhardsitohang pqlkonversisintakssqlmenjadisintakspql AT tricyaesterinawidagdo pqlkonversisintakssqlmenjadisintakspql |