Suzanne Dietrich
Professor,
School of Mathematical and Natural Sciences
-
Phone: 602-543-5628
-
-
CLCC 250F ASU at the West Campus, Mail Code 2352 PO BOX 37100 Phoenix, AZ 85069-7100
-
Mail code: 2352Campus: West
-
Long Bio
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 is known for her research in the field of databases and computer science education. Her current research focuses on interdisciplinary applications of databases, including Multispecies Ovary Tissue Histology Electronic Repository (MOTHER) and the NeuroML database. Her database systems research has emphasized the incremental maintenance of materialized views and the monitoring of conditions in active environments that respond to events and streaming information. Her educational efforts have involved the WinRDBI educational tool for understanding relational database query languages, integrating the 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 Databases: Concepts and Practice", "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
Selected Publications (in reverse chronological order):
- S. W. Dietrich, Understanding Databases: Concepts and Practice, John Wiley and Sons, Inc, 2021.
- S. W. Dietrich, D. Goelman, J. Broatch, S. M. Crook, B. Ball, K. Kobojek, and J. Ortiz, Introducing Databases in Context Through Customizable Visualizations, Frontiers in Education, September 2021.
- S. W. Dietrich, D. Goelman, J. Broatch, S. M. Crook, B. Ball, K. Kobojek, and J. Ortiz, Using Formative Assessment for Improving Pedagogy: Reflections on Feedback Informing Database Visualizations, ACM Inroads: Volume 11 Issue 4, December 2020, pp. 27-34.
- S. W. Dietrich, Teaching Introduction to Programming Languages with a Database Twist , Journal of Computing Sciences in Colleges, Volume 36, Number 3, 2020.
- J. E. Broatch, S. W. Dietrich and D. Goelman, Introducing Data Science Techniques by Connecting Database Concepts and dplyr, Journal of Statistics Education, September 2019.
- R. Bingham, S. W. Dietrich and D. Goelman, Strategies to improve accessibility for learners with color vision deficiency ACM Inroads: Volume 10 Issue 1, March 2019, pp. 52-56.
- D. Goelman and S. W. Dietrich, A Visual Introduction to Conceptual Database Design for All, SIGCSE '18 Proceedings of the 49th ACM Technical Symposium on Computer Science Education, Baltimore, MD, 21-24 February 2018, pp. 320-325,
- 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
- K. Watanabe, S. W. Dietrich, J. Sluka, and M. Zelinski, CIBR Multispecies Ovary Tissue Histology Electronic Repository (MOTHER), NSF DBI-2054061 (3/15/21 - 3/14/24).
- 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).
Courses
2025 Spring
| Course Number | Course Title |
|---|---|
| ACO 499 | Individualized Instruction |
| ACO 320 | Database Systems |
| ACO 499 | Individualized Instruction |
2024 Fall
| Course Number | Course Title |
|---|---|
| CSE 795 | Continuing Registration |
| CSE 799 | Dissertation |
| CSE 580 | Practicum |
| ACO 399 | Supervised Research |
| ACO 494 | Special Topics |
| ACO 499 | Individualized Instruction |
| ACO 593 | Applied Project |
| ACO 321 | Database Development & Apps |
| ACO 499 | Individualized Instruction |
2024 Summer
| Course Number | Course Title |
|---|---|
| ACO 499 | Individualized Instruction |
2024 Spring
| Course Number | Course Title |
|---|---|
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| CSE 590 | Reading and Conference |
| CSE 790 | Reading and Conference |
| CSE 599 | Thesis |
| ACO 499 | Individualized Instruction |
| ACO 592 | Research |
| ACO 593 | Applied Project |
| ACO 494 | Special Topics |
| ACO 320 | Database Systems |
2023 Fall
| Course Number | Course Title |
|---|---|
| CSE 795 | Continuing Registration |
| CSE 799 | Dissertation |
| CSE 580 | Practicum |
| CSE 790 | Reading and Conference |
| ACO 320 | Database Systems |
| ACO 499 | Individualized Instruction |
| ACO 593 | Applied Project |
2023 Summer
| Course Number | Course Title |
|---|---|
| ACO 499 | Individualized Instruction |
2023 Spring
| Course Number | Course Title |
|---|---|
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| CSE 590 | Reading and Conference |
| CSE 790 | Reading and Conference |
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| ACO 240 | Intro to Programming Languages |
| ACO 499 | Individualized Instruction |
| ACO 592 | Research |
| ACO 593 | Applied Project |
2022 Fall
| Course Number | Course Title |
|---|---|
| CSE 795 | Continuing Registration |
| CSE 799 | Dissertation |
| CSE 580 | Practicum |
| CSE 790 | Reading and Conference |
| LSC 499 | Individualized Instruction |
| LSC 394 | Special Topics |
| ACO 320 | Database Systems |
| ACO 592 | Research |
| ACO 499 | Individualized Instruction |
| ACO 593 | Applied Project |
2022 Summer
| Course Number | Course Title |
|---|---|
| ACO 499 | Individualized Instruction |
| ACO 484 | Internship |
| ACO 484 | Internship |
| ACO 484 | Internship |
2022 Spring
| Course Number | Course Title |
|---|---|
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| CSE 590 | Reading and Conference |
| CSE 790 | Reading and Conference |
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| ACO 240 | Intro to Programming Languages |
| ACO 501 | Database Systems & Python |
| ACO 499 | Individualized Instruction |
| ACO 592 | Research |
| ACO 593 | Applied Project |
2021 Fall
| Course Number | Course Title |
|---|---|
| CSE 795 | Continuing Registration |
| CSE 799 | Dissertation |
| CSE 580 | Practicum |
| CSE 790 | Reading and Conference |
| ACO 320 | Database Systems |
| ACO 592 | Research |
| ACO 484 | Internship |
| ACO 499 | Individualized Instruction |
| ACO 593 | Applied Project |
| ACO 484 | Internship |
2021 Summer
| Course Number | Course Title |
|---|---|
| ACO 399 | Supervised Research |
| ACO 484 | Internship |
| ACO 484 | Internship |
| ACO 484 | Internship |
2021 Spring
| Course Number | Course Title |
|---|---|
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| LSC 499 | Individualized Instruction |
| CSE 590 | Reading and Conference |
| CSE 790 | Reading and Conference |
| ACO 499 | Individualized Instruction |
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| CSE 790 | Reading and Conference |
| ACO 399 | Supervised Research |
| ACO 240 | Intro to Programming Languages |
| ACO 501 | Database Systems & Python |
| ACO 499 | Individualized Instruction |
2020 Fall
| Course Number | Course Title |
|---|---|
| CSE 795 | Continuing Registration |
| CSE 799 | Dissertation |
| CSE 580 | Practicum |
| CSE 790 | Reading and Conference |
| ACO 499 | Individualized Instruction |
| ACO 320 | Database Systems |
| ACO 484 | Internship |
| ACO 399 | Supervised Research |
| ACO 499 | Individualized Instruction |
| ACO 321 | Database Development & Apps |
2020 Summer
| Course Number | Course Title |
|---|---|
| ACO 399 | Supervised Research |
2020 Spring
| Course Number | Course Title |
|---|---|
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| LSC 499 | Individualized Instruction |
| CSE 590 | Reading and Conference |
| CSE 790 | Reading and Conference |
| ACO 499 | Individualized Instruction |
| CSE 595 | Continuing Registration |
| CSE 599 | Thesis |
| CSE 790 | Reading and Conference |
| ACO 399 | Supervised Research |
| ACO 240 | Intro to Programming Languages |
| ACO 399 | Supervised Research |
| ACO 501 | Database Systems & Python |
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)