While geographic search filters exist, few of them are validated and there are currently none that focus on Germany. We aimed to develop and validate a highly sensitive geographic search filter for MEDLINE (PubMed) that identifies studies about Germany. First, using the relative recall method, we created a gold standard set of studies about…

Exploratory data analysis (EDA), data visualization, and visual analytics are essential for understanding and analyzing complex datasets. In this project, we explored these techniques and their applications in data analytics. The case discusses Tableau, a powerful data visualization tool, and Google BigQuery, a cloud-based data warehouse that…

The utilization of virtual compound libraries and virtual screening has become a routine method in drug discovery and has accelerated the research of pharmacy and translational medicine. With the development of computer-aided drug design (CADD), it is essential to incorporate virtual experiments into the education of medicinal chemistry. Herein,…

The National Institute of Mental Health created the National Database for Autism Research (NDAR) to accelerate autism knowledge through data sharing and collaboration. However, our experience using NDAR reveals systematic challenges across several aspects of data submission, selection, management, and analysis that limit utility of this resource.…

Shoeprints are a common type of evidence found at crime scenes and are regularly used in forensic investigations. However, their utility is limited by the lack of reference footwear databases that cover the large and growing number of distinct shoe models. Additionally, existing methods for matching crime-scene shoeprints to reference databases…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

In this article we discuss the use of RapidMiner, a data science software platform, in a Database Management Systems course. For further understanding of the database and the skill learned, students are given an assignment to complete, to not only use another software beside SQL Server Management Studio but also translate their findings in a more…

"Not only SQL" (NoSQL) databases have become widespread across organizations, enabling sophisticated, data-driven applications to be highly available, distributed, and cloud-based, such as e-commerce, social media, online multiplayer games, and video streaming. However, NoSQL is still sparsely found in MIS and analytics curricula. This…

Case studies allow for in-depth exploration of multi-faceted issues found in real world information system development projects. The TheatreWorks of Southern Indiana case examines the requirements of a local community theatre group as it strives to incorporate and leverage database technology in a unique non-profit performing arts setting.

Quantum computing is the beginning of a new age for diverse industries, and educational technologies will significantly benefit from such quantum developments. This is a novel approach, applying quantum algorithms to enhance educational technologies, with no previous studies addressing the integration of quantum computing for personalized…

Beginning on July 1, 2022, in the state of Connecticut, all new Individualized Education Programs (IEPs) for special education began to be written in the new Connecticut Special Education Data System commonly known as CT-SEDS. This investigation sought to understand to what extent Connecticut's implementation of CT-SEDS had impacted parents'…

The purpose of this teaching case is to develop a hands-on exercise on graph processing using a hybrid system. The paper provides a background on graph databases and how graph processing is supported in a hybrid system, SAP HANA. It also details step-by-step instructions on how to create, modify, and process a graph database using SAP HANA. The…

The case provides a realistic scenario that can be used in a systems analysis and design, database development or graduate level management information systems course. The case focuses upon the development of an event management system for a small conference with participants and exhibitors. Multiple assignment options are provided allowing…

Despite enacting well-intentioned policies to improve teacher recruitment and retention, many states continue to face significant staffing challenges, particularly in high-need schools and hard-to-staff subjects such as math, science, and special education. Two years ago, the National Council on Teacher Quality (NCTQ) set out to explore the…

SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature,…