Dave Patric Headshot

Dave Patric

Lecturer

School of Information
Golisano College of Computing and Information Sciences

585-475-5384
Office Hours
Monday / Wednesday / Friday 9:00am - 11:00am Tuesday / Thursday 2:00pm - 4:00pm And by appointment: calendly.com/dkpvcs
Office Location

Dave Patric

Lecturer

School of Information
Golisano College of Computing and Information Sciences

585-475-5384

Currently Teaching

ISTE-230
3 Credits
A presentation of the fundamental concepts and theories used in organizing and structuring data. Coverage includes the data modeling process, basic relational model, normalization theory, relational algebra, and mapping a data model into a database schema. Structured Query Language is used to illustrate the translation of a data model to physical data organization. Modeling and programming assignments will be required. Note: students should have one course in object-oriented programming.
ISTE-608
3 Credits
An introduction to the theory and practice of designing and implementing database systems. Current software environments are used to explore effective database design and implementation concepts and strategies. Topics include conceptual data modeling, methodologies, logical/physical database design, normalization, relational algebra, schema creation and data manipulation, and transaction design. Database design and implementation projects are required.
ISTE-436
3 Credits
Students will be introduced to issues in client/server database implementation and administration. Students will configure, test, and establish client-server communication and server-server communication with single and multiple database servers. Topics such as schema implementation, storage allocation and management, user creation and access security, backup and recovery, and performance measurement and enhancement will be presented in lecture and experienced in a laboratory environment. Students will configure and demonstrate successful communication between a database file server and multiple clients.
ISTE-121
4 Credits
A second course in using the object-oriented approach to solving problems in the information domain. Students will learn: basic design principles and guidelines for developing graphical user interfaces, and use of the Event Model to implement graphical interfaces; algorithms for processing data structures; multithreading concepts and use of the Multithreading Model to design and implement advanced processing methods. Additional topics include the relational model of information organization, and the Client-Server model. Individual implementation projects are required. A team implementation exercise is used to provide students an opportunity to apply basic software development and project management practices in the context of a medium-scale project.
ISTE-610
3 Credits
This course provides students with exposure to foundational information sciences and technologies. Topics include an overview of data types, structuring and processing data and knowledge, data transformation, and data storage and warehousing. Students will work with non-traditional (noSQL) data stores to manage large datasets in the context of specific problem scenarios.
NSSA-220
3 Credits
An introduction to the Unix operating system and scripting in the Perl and Unix shell languages. The course will cover basic user-level commands to the Unix operating system, followed by basic control structures, and data structures in Perl. Examples will include GUI programming, and interfacing to an underlying operating system. Following Perl, students will be introduced to the basics of shell programming using the Unix bash shell. Students will need one year of programming in an object-oriented language.