Integrated Search Menu

Suzanne Dietrich

Professor
Faculty, WEST Campus, Mailcode 2352
Biography

Suzanne W. Dietrich is a professor in the School of Mathematical and Natural Sciences in the New College of Interdisciplinary Arts and Sciences at ASU's West campus. She received her doctorate degree from Stony Brook University as an Office of Naval Research Graduate Fellow. Professor Dietrich joined the faculty of the Department of Computer Science and Engineering at Arizona State University's College of Engineering and Applied Sciences (today's Fulton School of Engineering), where she established her teaching and research interests in the educational, practical and theoretical aspects of databases.  In August 2005, she joined the faculty at the West campus to contribute to the new applied computing program. 

Professor Dietrich's research interests emphasize incremental maintenance of materialized views and the monitoring of conditions in active environments that respond to events and streaming information, such as in dataspaces and grid-based virtual organizations. Her educational efforts have involved the WinRDBI educational tool for understanding relational database query languages and the development of an advanced database course for undergraduates, including object-oriented conceptual data models (EER and UML), object-oriented databases, object-relational databases, and databases and the Web (JDBC and XML). Dietrich's recent educational efforts include the integration of the new LINQ query language into the database curriculum and interdisciplinary efforts in making databases accessible to students of many majors.

Her research has been supported by grants from the National Science Foundation, and she is widely published and has presented at national and international conferences relative to her database and educational research. She has authored several database textbooks "Understanding Relational Database Query Languages," "Foundations of Object Databases: Object-Oriented and Object-Relational Design," and "An Advanced Course in Database Systems: Beyond Relational Databases." Professor Dietrich is recognized by the ACM (Association for Computing Machinery) as a Distinguished Educator for her significant accomplishments and impact in the computing field, including the authorship of educational courseware and textbooks, as well as curriculum innovation. She is also a member of the ACM Special Interest Group on the Management of Data (SIGMOD) and the ACM Special Interest Group on Computer Science Education (SIGCSE). 

At ASU's West campus, Dietrich teaches coursework in computer science and database systems. 

Education
  • Ph.D. Computer Science, Stony Brook University
  • M.S. Computer Science, Stony Brook University
  • B.S. Computer Science and Applied Mathematics, Stony Brook University
Publications

Publications by Topic 

Selected Publications (in reverse chronological order):

  • S. W. Dietrich and D. Goelman, Formative Self-Assessment for Customizable Database Visualizations: Checkpoints for Learning, 2017 ASEE Annual Conference & Exposition, Columbus, Ohio (2017).
  • M. B. Chaudhari and S. W. Dietrich,  Detecting Common Subexpressions for Multiple Query Optimization over Heterogeneous Data Sources, Distributed and Parallel Databases, Volume 34, pp. 119-143 (2016).
  • M. B. Chaudhari, S. W. Dietrich, J. Ortiz, and S. Pearson, Towards A Hybrid Relational and XML Benchmark for Loosely-Coupled Distributed Data Sources, Journal of Systems and Software, Volume 109, pp. 78-87 (2015).
  • S. W. Dietrich, D. Goelman, C. M. Borror, and S. M. Crook,  An Animated Introduction to Relational Databases for Many Majors, IEEE Transactions on Education, Volume 58, Issue 2, pp. 81-89,http://dx.doi.org/10.1109/TE.2014.2326834 (2015).
  • J. Birgiolas, S. W. Dietrich, S. Crook, A. Rajadesingan, C. Zhang, S. V. Penchala, and V. Addepalli,  Ontology-assisted keyword search for NeuroML models, Proceedings of the 27th International Conference on Scientific and Statistical Database Management (SSDBM '15), San Diego, CA (2015).
  • S. W. Dietrich. A metaphor for understanding objects and classes in CS1. ACM Inroads (2014).
  • Y. N. Silva, S. W. Dietrich, J. M. Reed, and L. M. Tsosie. Integrating Big Data into the Computing Curricula. ACM SIGCSE (Technical Symposium on Computer Science Education) (2014).
  • S. W. Dietrich. Is LINQ in your toolbox?. ACM Inroads (2013).
  • J. Ortiz, S. W. Dietrich and M. Chaudhari. Learning from Database Performance Benchmarks. Journal of Computing in Small Colleges, Proceedings of CCSC Southwest 2012 (2012).
  • S. W. Dietrich and S. D. Urban. Fundamentals of Object Databases: Object-Oriented and Object-Relational Design. Morgan Claypool (2011).
  • S. W. Dietrich and M. Chaudhari. LINQ ROX! Integrating LINQ into the Database Curriculum. ACM SIGCSE 2011, March 2011 (2011).
  • Suzanne Dietrich and Mahesh Chaudhari. The LINQ between XML and Databases: A Gentle Introduction. Journal of Computing in Small Colleges (2010).
  • M. B. Chaudhari and S. W. Dietrich. Metadata Services for Distributed Event Stream Processing Agents. 19th International Conference on Software Engineering and Data Engineering (SEDE 2010) (2010).
  • Susan D. Urban and Suzanne W. Dietrich. Object Data Models. Encyclopedia of Database Systems (2009).
  • Suzanne W. Dietrich. Maintenance of Recursive Views. Encyclopedia of Database Systems (2009).
  • Susan D. Urban, Yang Xiao, Luther Blake, and Suzanne W. Dietrich. Monitoring data dependencies in concurrent process execution through delta-enabled grid services. International Journal of Web and Grid Services (2009).
  • Suzanne Dietrich and Mahesh Chaudhari. The Missing LINQ between Databases and Object-Oriented Programming Languages: LINQ as an Object Query Language for a Database Course. Journal of Computing in Small Colleges (2009).
  • Suzanne Dietrich, Susan Haag, Leah Folkestad. Quality-Based Assessment of Papers and Projects in Computer Science. Journal of Computing in Small Colleges (2008).
  • Suzanne Dietrich, Susan Urban, Susan Haag. Developing Advanced Courses for Undergraduates: A Case Study in Databases. IEEE Transactions on Education (2008).
  • Y Jin, Susan Urban, Suzanne Dietrich. A Concurrent Rule Scheduling Algorithm for Active Rules. Data and Knowledge Engineering (2007).
  • Jin Ying, Susan Urban, Suzanne Dietrich. Extending the OBJECTIVE Benchmark for Evaluation of Active Rules in a Distributed Component Integration Environment. Journal of Database Management (2006).
  • Jin Ying, Susan Urban, Suzanne Dietrich, Amy Sundermier. An Integration Rule Processing Algorithm and Execution Environment for Distributed Component Integration. Informatica (2006).
  • Suzanne Dietrich, Rohini Patil, Amy Sundermier, Susan Urban. Component Adaptation for Event-Based Application Integration using Active Rules. Journal of Systems and Software (2006).
  • Urban, S, Biswas, I, Dietrich, Suzanne. Filtering Features for a Composite Event Definition Language. International Symposium on Applications and the Internet (SAINT) (2006).
  • Xiao, Y, Urban, S, Dietrich, Suzanne. A Process History Capture System for Analysis of Data Dependencies in Concurrent Process Execution. Data Engineering Issues in E-Commerce and Services, Springer Verlag Lecture Notes in Computer Science (2006).
  • Dietrich, Suzanne Wagner, Urban, Susan Darling. An Advanced Course in Database Systems: Beyond Relational Databases. (2005).
  • Dietrich, Suzanne, Urban, Susan, Ma, H., Xiao, Y., Patel, S. Exploring XML for Data Exchange in the Context of an Undergraduate Database Curriculum. ACM Special Interest Group on Computer Science Education (2005).
  • Ma, H., Urban, Susan, Xiao, Y., Dietrich, Suzanne. GridPML: A Process Modeling Language and History Capture System for Grid Service Composition. International Conference on e-Business Engineering (2005).
  • Urban, Susan, Kumar, V., Dietrich, Suzanne. A Prototype for Integration of Web Services into the IRules Approach to Component Integration. International Conference on Enterprise Information Systems (2005).
Research Activity
  • S. M. Crook*, R. Gerkin* and S. W. Dietrich, Tools for Model Discovery: Validation and Selection in Neuroscience with NeuroML. NIH (9/1/2015 - 8/31/2019).
  • S. W. Dietrich*, R. Ball, C. M. Borror, S. M. Crook, K. S. Kobojek. Collaborative Research: Databases for Many Majors: Customizable Visualizations to Improve STEM Learning. NSF-EHR(9/1/2014 - 8/31/2017).
  • S. M. Crook*, S. W. Dietrich. CRCNS Data Sharing: NeuroML Database for Multiscale Neuroscience Models. HHS-NIH-NIBIB(9/1/2011 - 8/31/2015).
  • S. W. Dietrich*, P. J. Clark, S. M. Crook. Collaborative Research: Databases for Many Majors: A Student-Centered Approach. NSF-EHR(3/15/2010 - 2/28/2013).
  • S. W. Dietrich*. CSR: Small: Materialized Views Over Heterogeneous Structured Data Sources in a Distributed Event Stream Processing Environment. NSF-MPS-DMS(9/1/2009 - 8/31/2014).
  • S. M. Crook*, S. W. Dietrich. NeuroML: Standards and Tools for Multiscale Model Specification and Exchange. HHS-NIH-NIMH(7/1/2009 - 5/31/2014).
  • T. Farley*, S. W. Dietrich. CSE 180: Computer Literacy. AZ BOARD OF REGENTS(7/15/2007 - 6/30/2009).
  • S. W. Dietrich*, S. D. Urban*. ADVANCED DATABASE CONCEPTS FOR UNDERGRADUATES. NSF-EHR(1/1/2000 - 9/30/2003).
  • S. D. Urban*, S. W. Dietrich*.  ACTIVE, DECLARATIVE INTEGRATION RULES FOR DEVELOPING DISTRIBUTED MULTI-TIERED APPLICAITONS. NSF-CISE(10/1/1999 - 8/31/2003).
  • S. D. Urban*, S. W. Dietrich*. TESTING & ANALYSIS OF ACTIVE DATABASE RULES. NSF-CISE(6/1/1995 - 12/31/1998).
  • S. W. Dietrich*. DATABASE LAB INSTRUCTION FOR UNDERGRADS: A COOPERATIVE LEARN. NSF-EHR(7/1/1994 - 12/31/1997).
  • S. W. Dietrich*.. EXTENDABLE DOOD FOR IMCA. BULL HN INFORMATION SYSTEMS(4/1/1993 - 8/15/1994).
  • S. W. Dietrich*. DISTRIBUTED PERFORMANCE: BENCH MARKS AND FRAG. TRANS. BULL HN INFORMATION SYSTEMS(1/2/1992 - 8/15/1993).
  • S. W. Dietrich*. PERFORMANCE BENCHMARKS FOR DISTRIBUTED HETEROGENEOUS DATABAS. BULL HN INFORMATION SYSTEMS(1/2/1991 - 12/31/1992).
  • S. W. Dietrich*. APPROXIMATE EVALUATION OF LOGIC PROGRAMS. NSF(10/1/1990 - 9/30/1992).
Summer 2019
Course NumberCourse Title
ACO 399Supervised Research
Fall 2018
Course NumberCourse Title
ACO 484Internship
ACO 499Individualized Instruction
CSE 580Practicum
CSE 790Reading and Conference
CSE 795Continuing Registration
CSE 799Dissertation
Spring 2018
Course NumberCourse Title
ACO 240Intro to Programming Languages
ACO 399Supervised Research
ACO 484Internship
ACO 499Individualized Instruction
Fall 2017
Course NumberCourse Title
ACO 101Intro to Computer Science
ACO 321Database Development & Apps
ACO 484Internship
ACO 499Individualized Instruction
CSE 580Practicum
CSE 790Reading and Conference
CSE 792Research
CSE 795Continuing Registration
CSE 799Dissertation
Summer 2017
Course NumberCourse Title
ACO 484Internship
Spring 2017
Course NumberCourse Title
ACO 102Object-Oriented Programming
ACO 240Intro to Programming Languages
ACO 399Supervised Research
ACO 484Internship
ACO 499Individualized Instruction
CSE 792Research
Fall 2016
Course NumberCourse Title
ACO 102Object-Oriented Programming
ACO 320Database Systems
ACO 399Supervised Research
ACO 484Internship
ACO 499Individualized Instruction
CSE 580Practicum
CSE 790Reading and Conference
CSE 792Research
CSE 795Continuing Registration
CSE 799Dissertation
Summer 2016
Course NumberCourse Title
ACO 484Internship
Spring 2016
Course NumberCourse Title
ACO 102Object-Oriented Programming
ACO 321Database Development & Apps
ACO 399Supervised Research
ACO 484Internship
ACO 499Individualized Instruction
CSE 790Reading and Conference
CSE 792Research
Fall 2015
Course NumberCourse Title
ACO 102Object-Oriented Programming
ACO 394Special Topics
ACO 422XML and Databases
ACO 484Internship
ACO 499Individualized Instruction
CSE 580Practicum
CSE 790Reading and Conference
CSE 792Research
CSE 795Continuing Registration
CSE 799Dissertation
Summer 2015
Course NumberCourse Title
ACO 484Internship
Spring 2015
Course NumberCourse Title
ACO 102Object-Oriented Programming
ACO 321Database Development & Apps
ACO 399Supervised Research
ACO 484Internship
ACO 493Honors Thesis
ACO 499Individualized Instruction
CSE 790Reading and Conference
CSE 792Research
Fall 2014
Course NumberCourse Title
ACO 100All About Data
ACO 320Database Systems
ACO 484Internship
ACO 499Individualized Instruction
CSE 580Practicum
CSE 790Reading and Conference
CSE 792Research
CSE 795Continuing Registration
CSE 799Dissertation
Honors / Awards

ACM Distinguished Educator

Editorships

ACM Transactions on Computing Education, Associate Editor

Professional Associations

ACM, ACM SIGCSE (Computer Science Education), SIGMOD (Management of Data)