LogiQL and SQL
SQL is a standard language used for defining, manipulating, and querying relational databases. This appendix provides a brief discussion of how basic queries conveyed in SQL may be expressed in LogiQL. Consider the following relational database, which includes two relational tables (Tables H.1...
| Main Authors: | , |
|---|---|
| Format: | Book Section |
| Language: | English |
| Published: |
Taylor & Francis Group
2015
|
| Subjects: | |
| Online Access: | http://eprints.intimal.edu.my/339/ http://eprints.intimal.edu.my/339/1/18_ft.pdf |
| _version_ | 1848766453371633664 |
|---|---|
| author | Halpin, Terry Rugaber, Spencer |
| author_facet | Halpin, Terry Rugaber, Spencer |
| author_sort | Halpin, Terry |
| building | INTI Institutional Repository |
| collection | Online Access |
| description | SQL is a standard language used for defining, manipulating, and
querying
relational databases. This appendix provides a brief discussion
of how basic queries conveyed in SQL may be expressed in LogiQL.
Consider the following relational database, which includes two relational
tables (Tables H.1 and H.2) describing countries in 2011. The country
table lists the ISO two-letter code, name, and population of various
countries. For discussion purposes, the population of Finland (5,396,292)
is omitted simply to illustrate SQL’s use of a null value to indicate that
a data value is missing (e.g., because it is unknown or inapplicable). To
save space, only a small number of countries are included. For those
countries that have presidents, the president table lists the name, country,
gender, and birth year of those presidents. Australia, Canada, and the
United Kingdom have prime ministers instead of presidents, so they are
not included in the president table.
Throughout the database, countries are standardly identified by their
country codes. The entries in the first two columns of the tables are necessarily
unique, so each of these columns is a candidate key for its table. The
country table has countryCode as its primary key and countryName as an
alternate key. |
| first_indexed | 2025-11-14T11:51:23Z |
| format | Book Section |
| id | intimal-339 |
| institution | INTI International University |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-14T11:51:23Z |
| publishDate | 2015 |
| publisher | Taylor & Francis Group |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | intimal-3392016-06-20T02:34:30Z http://eprints.intimal.edu.my/339/ LogiQL and SQL Halpin, Terry Rugaber, Spencer QA76 Computer software SQL is a standard language used for defining, manipulating, and querying relational databases. This appendix provides a brief discussion of how basic queries conveyed in SQL may be expressed in LogiQL. Consider the following relational database, which includes two relational tables (Tables H.1 and H.2) describing countries in 2011. The country table lists the ISO two-letter code, name, and population of various countries. For discussion purposes, the population of Finland (5,396,292) is omitted simply to illustrate SQL’s use of a null value to indicate that a data value is missing (e.g., because it is unknown or inapplicable). To save space, only a small number of countries are included. For those countries that have presidents, the president table lists the name, country, gender, and birth year of those presidents. Australia, Canada, and the United Kingdom have prime ministers instead of presidents, so they are not included in the president table. Throughout the database, countries are standardly identified by their country codes. The entries in the first two columns of the tables are necessarily unique, so each of these columns is a candidate key for its table. The country table has countryCode as its primary key and countryName as an alternate key. Taylor & Francis Group 2015 Book Section PeerReviewed text en http://eprints.intimal.edu.my/339/1/18_ft.pdf Halpin, Terry and Rugaber, Spencer (2015) LogiQL and SQL. In: LogiQL: A Query Language for Smart Databases. Taylor & Francis Group, pp. 289-301. ISBN 9781482244939 |
| spellingShingle | QA76 Computer software Halpin, Terry Rugaber, Spencer LogiQL and SQL |
| title | LogiQL and SQL |
| title_full | LogiQL and SQL |
| title_fullStr | LogiQL and SQL |
| title_full_unstemmed | LogiQL and SQL |
| title_short | LogiQL and SQL |
| title_sort | logiql and sql |
| topic | QA76 Computer software |
| url | http://eprints.intimal.edu.my/339/ http://eprints.intimal.edu.my/339/1/18_ft.pdf |