Background: Pathology data contained within the electronic health record (EHR), and laboratory information system (LIS) of hospitals represents a potentially powerful resource to improve clinical care. However, existing reporting tools within commercial EHR and LIS software may not be able to efficiently and rapidly mine data for quality improvement and research applications. Materials and Methods: We present experience using a data warehouse produced collaboratively between an academic medical center and a private company. The data warehouse contains data from the EHR, LIS, admission/discharge/transfer system, and billing records and can be accessed using a self-service data access tool known as Starmaker. The Starmaker software allows users to use complex Boolean logic, include and exclude rules, unit conversion and reference scaling, and value aggregation using a straightforward visual interface. More complex queries can be achieved by users with experience with Structured Query Language. Queries can use biomedical ontologies such as Logical Observation Identifiers Names and Codes and Systematized Nomenclature of Medicine. Result: We present examples of successful searches using Starmaker, falling mostly in the realm of microbiology and clinical chemistry/toxicology. The searches were ones that were either very difficult or basically infeasible using reporting tools within the EHR and LIS used in the medical center. One of the main strengths of Starmaker searches is rapid results, with typical searches covering 5 years taking only 1-2 min. A "Run Count" feature quickly outputs the number of cases meeting criteria, allowing for refinement of searches before downloading patient-identifiable data. The Starmaker tool is available to pathology residents and fellows, with some using this tool for quality improvement and scholarly projects. Conclusion: A data warehouse has significant potential for improving utilization of clinical pathology testing. Software that can access data warehouse using a straightforward visual interface can be incorporated into pathology training programs.

Introduction: Smartphone applications in medicine are becoming increasingly prevalent. Given that most pathologists and pathology trainees today use smartphones, an obvious modality for pathology education is through smartphone applications. "MyDermPath" is a novel smartphone application that was developed as an interactive reference tool for dermatology and dermatopathology, available for iOS and Android. Materials and Methods: "MyDermPath" was developed using Apple Xcode and Google Android SDK. Dermatology images (static and virtual slides) were annotated and configured into an algorithmic format. Each image comprised educational data (diagnosis, clinical information, histopathology, special stains, differential diagnosis, clinical management, linked PubMed references). Added functionality included personal note taking, pop quiz, and image upload capabilities. A website was created (http://mydermpath.com) to mirror the app. Results: The application was released in August 2011 and updated in November 2013. More than 1,100 reference diagnoses, with over 2,000 images are available via the application and website. The application has been downloaded approximately 14,000 times. The application is available for use on iOS and Android platforms. Conclusions: Smartphone applications have tremendous potential for advancing pathology education. "MyDermPath" represents an interactive reference tool for dermatology and dermatopathologists.