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…

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

Eleven states have worked with CIID, over the past three years, to integrate their IDEA data and to implement Generate, a software application that improves data quality and automates reporting through standardization. These eleven states have realized notable data quality improvements that will be shared in this brief to help states across the…

CIID has implemented Generate in 9 state education agencies (SEAs), and through this work SEAs have realized a variety of improvements to their special education data in terms of overall data quality, improvements to data governance structures, and ease of federal reporting. This brief is the second in a series looking at data quality. Here, we…

In this paper, we describe a Relational Algebra Query Language (RAQL) and Relational Algebra Query (RAQ) software product we have developed that allows database instructors to teach relational algebra through programming. Instead of defining query operations using mathematical notation (the approach commonly taken in database textbooks), students…

With their budgets under increasing pressure, many campus IT directors are considering open source projects for the first time. On the face of it, the savings can be significant. Commercial emergency-planning software can cost upward of six figures, for example, whereas the open source Kuali Ready might run as little as $15,000 per year when…

This paper describes the use and benefits of Microsoft's Adventure Works (AW) database to teach advanced database skills in a hands-on, realistic environment. Database management and querying skills are a key element of a robust information systems curriculum, and active learning is an important way to develop these skills. To facilitate active…

Learning is enhanced with repetition, either through more exercises in individual courses, or through the integration of concepts in a capstone experience. A well planned and integrated curriculum can utilize a capstone course, not only to provide a service learning component, but also as an opportunity to refresh students on key discipline topics…

The interpretation of single-case data requires systematic visual analysis across and within conditions. Graphs are a vital component for analyzing and communicating single-case design data and a necessary tool for applied researchers and practitioners. Several articles have been published with task analyses for graphing data with the new versions…

Advancement technology is reshaping the business of fundraising, alumni relations, communications, and marketing. Through all of these innovations, the backbone of advancement systems remains the constituent database. This article takes a look at advancement databases that track constituent data.

This paper presents a practitioner's view on student system implementations in the Australian university sector. A student information system is a core system of any university and integral to its operations and services to students. These systems are constantly on the list of major projects and at any point in time, a university is either…

The patients receiving treatment from a hospital need to interact with multiple entities when claiming reimbursements. The complexities of the medical service supply chain can be simplified with an electronic clearance management system that allows hospitals, medical insurance bureau, bank, and patients to interact in a seamless and cashless…

Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable…

Darien Library, where the author serves as head of knowledge and learning services, launched a new website on September 1, 2008. The website is built with Drupal, an open source content management system (CMS). In this article, the author describes how she and her colleagues overhauled the library's website to provide an open source content…

Web Access Pattern (WAP), which is the sequence of accesses pursued by users frequently, is a kind of interesting and useful knowledge in practice. Sequential Pattern mining is the process of applying data mining techniques to a sequential database for the purposes of discovering the correlation relationships that exist among an ordered list of…