Search results for "Query formulation"

showing 3 items of 3 documents

ViziQuer: A Visual Notation for RDF Data Analysis Queries

2019

Visual SPARQL query notations aim at easing the RDF data querying task. At the current state of the art there is still no generally accepted visual graph-based notation suitable to describe RDF data analysis queries that involve aggregation and subqueries. In this paper we present a visual diagram-centered notation for SPARQL select query formulation, capable to handle aggregate/statistics queries and hierarchic queries with subquery structure. The notation is supported by a web-based prototype tool. We present the notation examples, describe its syntax and semantics and describe studies with possible end users, involving both IT and medicine students.

Computer scienceEnd userProgramming languageInformationSystems_INFORMATIONSTORAGEANDRETRIEVAL010401 analytical chemistry05 social sciencesQuery formulationInformationSystems_DATABASEMANAGEMENTcomputer.file_formatNotationcomputer.software_genre01 natural sciences0104 chemical sciencesSPARQLGraph (abstract data type)0501 psychology and cognitive sciencesVisual notationRDFcomputer050107 human factors
researchProduct

The Effects of Database Complexity on SQL Query Formulation (journal-first)

2020

The learning of practical Structured Query Language (SQL) skills often takes place in digital environments, where the learner writes queries against an exercise database. The exercise database is usually designed and implemented by the teacher, and populated with makeshift data. Although this approach is common, and SQL taught in almost all database courses, little scientific attention has been given to the nature of the exercise database.

SQLDatabaseComputer science05 social sciencesQuery formulationInformationSystems_DATABASEMANAGEMENT020207 software engineering02 engineering and technologycomputer.software_genre0502 economics and businessComputingMilieux_COMPUTERSANDEDUCATION0202 electrical engineering electronic engineering information engineeringStudent learningcomputer050203 business & managementcomputer.programming_language2020 46th Euromicro Conference on Software Engineering and Advanced Applications (SEAA)
researchProduct

The Effects of Database Complexity on SQL Query Formulation

2020

In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises more interesting and useful, as these databases more accurately mimic databases students are likely to encounter in their future work environments. However, using even the most engaging database can be counterproductive to learning, if a student is not able to formulate correct queries due to the complexity of the database schema. Scientific evidence on the effects of database complexity on student’s query formulation is limited, and with queries from 744 students against thr…

SQLoppiminenComputer scienceQuery formulation02 engineering and technologycomputer.software_genrestructured query language (SQL)kyselykieletScientific evidenceSet (abstract data type)Simple (abstract algebra)0502 economics and business0202 electrical engineering electronic engineering information engineeringComputingMilieux_COMPUTERSANDEDUCATIONdatabase complexitytietokannatdatabasecomputer.programming_languageeducationSQLDatabaseScale (chemistry)05 social sciencesDatabase schemaInformationSystems_DATABASEMANAGEMENT020207 software engineeringkompleksisuuskoulutusHardware and Architecturestudent learningcomputer050203 business & managementSoftwareInformation Systems
researchProduct