April 16, 2021
April 16, 2021
April 17, 2021
Labs and experiential learning
With more organizations relying on data to make crucial business decisions, database systems have become essential in managing financial, medical, and scientific data. Consequently, managing databases has become a necessary skill for programmers, data analysts, and data scientists to accelerate scientific inquiry and business decision-making. However, with the abundance of database models (types), such as relational, graph, document-oriented, beginner learners often find it challenging to decide what database model they should learn. Experienced developers also struggle to learn new database models as different models have different data structures and query languages.
In this paper, we introduce TriQL: Tribus linguis query, Latin for three query languages. TriQL is a system for helping novices learn the structures (schema) and query languages of three major database systems, including MySQL (a relational, SQL-Structured Query Language, database), Neo4J (a graph database), and MongoDB (a document/collection-oriented database). TriQL offers learners a GUI (Graphical User Interface) that allows users to design and execute a query against a generic database schema without requiring them to have any database programming experience. TriQL converts the generated user-query into three database query languages: SQL, Cypher (Neo4J's query language), and MongoDB. The user will then examine the generated queries and can view the results of each of the generated queries on its native data model. For instance, TriQL produces an interactive Neo4J graph for the Cypher query. It allows users to interact with the graph giving them the same experience as working with the native Neo4J database engine.
Alawini, A., & Rao, P., & Zhou, L., & Kang, L., & HO, P. (2021, April), Work-In-Progress: TriQL: A tool for learning relational, graph and document-oriented database programming. Paper presented at 2021 Illinois-Indiana Regional Conference, Virtual. 10.18260/1-2--38288
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2021 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015