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…

Continuing to fill the literature gap, this research replicated and expands a prior study of student performance in database normalization in an introductory database course. The data was collected from four different universities, each having different prerequisite courses for their database course. Student performance on a database normalization…

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,…

With the growing entrepreneurial spirit and ease of selling items online, many people are turning to virtual marketplaces to earn extra income or, in some instances, build a career. This case focuses upon the development of a database to assist in inventory management for an online reselling business that has grown from an occasional hobby to a…

The pet care service industry is booming. The U.S. Census Bureau (2019) recorded pet service industry payroll numbers at almost $11.2 billion (excluding veterinarian services). In this teaching case, Mark, the owner of a successful dog boarding business, is looking to capitalize on that growth as he expands his customer demographic to welcome cats…

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…

Designers are always pursuing design with suitable emotions. Effective emotional fusion not only produces a good user experience but also extends the product lifecycle. The decoding of design emotion and the use of design emotion language should run through the entire design process. In this study, we propose a new emotion-embedded design flow…

Large-scale assessments are rich sources of data that can inform a diverse range of research questions related to educational policy and practice. For this reason, datasets from large-scale assessments are available to enable secondary analysts to replicate and extend published reports of assessment results. These datasets include multiple imputed…

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…

There has been intense debate within the autistic and autism communities about the use of autism biobanks -- repositories containing biological and phenotypic materials -- and of genomic autism research more broadly. Here, we sought to understand the views and experiences of those contributing to one specific biobank, the Australian Autism…

This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with…

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…