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…

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

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…

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

Estimating prescription medicine use is challenging due to recall bias associated with surveys and coverage bias in administrative data. This study assesses how making operational improvements and combining both survey and administrative data sources can increase data quality on filled prescriptions. We use data from the Medicare Current…

Scientific integrity stands as a fundamental principle and benchmark for the conduct of research and the dissemination of scholarly content. The objective of this research aims to explore the impact of research, new and emerging areas of research, and to identify potential research collaborators and journals of scientific integrity for scholarly…

Machines produce and operate using complex systems of metadata that need to be catalogued, sorted, and processed. Many students lack the experience with metadata and sufficient knowledge about it to understand it as part of their data literacy skills. This paper describes an educational and interactive database activity designed for teaching…