Search

What to Expect and What to Focus on in SQL Query Teaching

2019

In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured Query Language (SQL) consists of a number of different concepts such as expressions, joins, grouping and ordering, all of which by nature invite different possible errors in the query writing process. Furthermore, some of these errors are relatively easy for a student to fix when compared to others. Using a data set from three student cohorts with the total of 744 students, we set out to explore which types of errors are persistent, i.e., more likely to be left uncorrected by…

SQLComputer scienceProcess (engineering)Relational databaseJoins02 engineering and technologycomputer.software_genreQuery languagekyselykieletSet (abstract data type)020204 information systems0202 electrical engineering electronic engineering information engineeringerrorscomputer.programming_languageta113SQLSyntax (programming languages)business.industry05 social sciencesquery languagerelaatiotietokannatopetusdatabase educationrelational databasevirheetArtificial intelligence0509 other social sciences050904 information & library sciencesbusinesscomputerNatural language processing

researchProduct

Expressive and efficient pattern languages for tree-structured data (extended abstract)

2000

It would be desirable to have a query language for tree-structured data that is (1) as easily usable as SQL, (2) as expressive as monadic second-order logic (MSO), and (3) efficiently evaluable. The paper develops some ideas in this direction. Towards (1) the specification of sets of vertices of a tree by combining conditions on their induced subtree with conditions on their path to the root is proposed. Existing query languages allow regular expressions (hence MSO logic) in path conditions but are limited in expressing subtree conditions. It is shown that such query languages fall short of capturing all MSO queries. On the other hand, allowing a certain guarded fragment of MSO-logic in the…

SQLRoot (linguistics)Theoretical computer scienceProgramming languageComputer scienceUSablecomputer.software_genreQuery languageTree (data structure)TheoryofComputation_MATHEMATICALLOGICANDFORMALLANGUAGESFragment (logic)Path (graph theory)Regular expressioncomputercomputer.programming_languageProceedings of the nineteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS '00

researchProduct

Baltu filoloģija, 8

1999

Salīdzināmā valodniecībaDatorlingvistikaLanguage contactsLatviešu valodaRudzīte Marta (publikācijas)Latviešu valodas gramatikaLatviešu valodas dialektoloģijaValodu kontakti:HUMANITIES and RELIGION::Languages and linguistics::Other languages::Baltic languages [Research Subject Categories]Baltu valodasLatvian language

researchProduct

Adjektīvu semantiskā diferenciācija latviešu un lietuviešu valodā

2005

Advisor: Pēteris Vanags

Salīdzināmā valodniecībaLithuanian language - adjectivesLatviešu valoda - semantikaLatvian language - semanticsLatvian language - adjectivesLietuviešu valoda - semantikaLithuanian language - semanticsComparative linguisticsLatviešu valoda - īpašības vārdiLatviešu diahroniskā valodniecība:HUMANITIES and RELIGION::Languages and linguistics::Other languages::Baltic languages [Research Subject Categories]Lietuviešu valoda - īpašības vārdi

researchProduct

Sastatāmā un lietišķā valodniecība: Kontrastīvie pētījumi.10

2001

Krājuma rakstu autori analizē dažādu valodas līmeņu parādības angļu, latviešu, lietuviešu, krievu, norvēģu valodā un tulkojumos.Valodu sastatījums veikts kā strukturālā, tā arī funkcionālā un kultūrvēsturiskā aspektā. Atklātas šo valodu īpatnības, arī to kopīgās īpašības. Vairāki raksti veltīti pedagoģijas problēmām. Aplūkota arī valodu vienību mijiedarbība gan valodu kontaktu, gan tulkošanas procesā.