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…

This work describes the design and construction of an open source, entity resolution system that enables users to assign and maintain persistent identifiers for master data items. Two key features of this system that are not available in current ER systems and that make persistent identification possible are (1) The capture and management of…

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…

Models in Software Engineering are considered as abstract representations of software systems. Models highlight relevant details for a certain purpose, whereas irrelevant ones are hidden. Models are supposed to make system comprehension easier by reducing complexity. Therefore, models should play a key role in education, since they would ease the…

Purpose: Linking Open Data (LOD) provides a vast amount of well structured semantic information, but many inconsistencies may occur, especially if the data are generated with the help of automated methods. Data cleansing approaches enable detection of inconsistencies and overhauling of affected data sets, but they are difficult to apply…

Semantic integrity constraints are business-specific rules that limit the permissible values in a database. For example, a university rule dictating that an "incomplete" grade cannot be changed to an A constrains the possible states of the database. To maintain database integrity, business rules should be identified in the course of database…

Different simple and inexpensive ways of building a database using common computer software and data from local newspaper are presented. Creating one's own database provides an opportunity to discuss ethical issues in data collection as well as data integrity.

Business intelligence derived from data warehousing and data mining has become one of the most strategic management tools today, providing organizations with long-term competitive advantages. Business school curriculums and popular database textbooks cover data warehousing, but the examples and problem sets typically are small and unrealistic. The…

Outlines some of the major considerations in developing an image database system with an emphasis on continuous tone images and network-accessible multiuser databases. Topics include: definition/description of a digital image; matching technology to use; documentation/standards; access; image quality; software systems; scanners; and sources of…

This paper presents a goal-based scenario approach to teaching introductory database concepts to undergraduates using two different scaffolding methods. One method, termed "worked-out examples," attempts to reduce extraneous cognitive load by requiring students to complete increasingly complex missing parts of worked out examples. The other…

Discusses the development of the "Dictionary of Old English," a database of approximately three million running words. Examines how technological advancements have changed the design process since it began in 1970, stating that error checking and protection of the database against accidental intrusion have remained as key issues. (GEA)

ArtShow is a digital image database that employs sophisticated features for interactive presentations of data. To demonstrate the program, an example database was prepared, based on the collection at the National Bank of Greece with names, comments and keywords in the Greek language. Discussion includes: the database platform and internal…

Describes the use of the Z39.50 information retrieval protocol as the basis for Infocal, a read-only, client/server-based campus information system. Technical considerations in adapting the protocol to nonbibliographic data, including semantic modules, dynamic attribute sets, and dynamic record syntax, are described in detail. (Contains 11…

Discusses important factors to consider before deciding on hardware or software to use in building qualitative databases. Examines using the computer to store and retrieve text, store and retrieve graphics, analyze text, analyze graphic materials, distribute data stored on one machine to others, allow researchers access to data from remote sites,…