CSCI 585: Database Systems
Dr. Saty Raghavachary, Associate Professor, CS Dept.
5:00-8:20pm, on Mon (SGM 123); 5:00-8:20pm, on Wed (SGM 124)
Blurb
What this course is about - here is a short description, from the course catalog.
Overview
This course covers the essential concepts, principles, techniques, and mechanisms for the design, analysis, use, and implementation of computerized database systems. Key information management concepts and techniques are examined: information modeling and representation; information interfaces - access, query, and manipulation, implementation structures, and issues of distribution.
The database and information management system technology examined in this course represents the state-of-the-art, including traditional approaches as well as recent research developments. By providing a balanced view of "theory" and "practice," the course should allow the student to understand, evaluate, and utilize practical database and information management systems.
The course is intended to provide a basic understanding of the issues and problems involved in database systems, knowledge of currently practical techniques for satisfying the needs of such a system, and an indication of the current research approaches that are likely to provide a basis for tomorrow's solutions.
In a single word, this course is about - data :) Another single word: 'fun'!!
Pre-requisites
As stated in the university catalog, a passing grade in CSCI485 or departmental permission is required to register for this class. Knowledge of relational databases, SQL, relational algebra and physical database design is desired [but not essential].
Note that this course involves several programming assignments/projects, for which some programming ability might be required. Assignments might call for the use of [the basics of] R, Python, etc.
Course links
1. Permalink to these pages you are looking at: https://bytes.usc.edu/cs585/s23-da-taaa . FYI, this entire site is created using Markdown (opposite of 'markup'), so the pages should come up nicely (on account of "responsive web design") on every device. Also, the look of the site will change periodically, fyi.. We'll use this site for lecture notes (and "extras").
2. D2L - the course involves the use of Desire2Learn (aka 'D2L', a somewhat-new-to-USC learning portal). You will submit your homeworks through D2L, and will access your scores there as well. This is also where you have the WebEx meeting link (under 'Virtual Meetings'), and lecture videos (which are recordings of the WebEx sessions). Note: we're not going to use Blackboard for anything.
3. Piazza page - this is a 'discussion' site, for you to post questions related to HWs and lecture material, and post related answers/comments. Instead of mailing me or the TAs or the graders, it's oftentimes better to post a note on Piazza instead, on account of more 'eyeballs' being able to look at them, and us not having to answer same/similar questions repeatedly.
People
Professor
Dr. Saty Raghavachary
I work in, teach, write about, lecture, consult, code and do informal research on computer graphics (CG), data science/ML, and 'AGI'. Here is my brief bio.
• office hours: by appt.
• email: saty@usc.edu, satychary@gmail.com (I'm also on Facebook, Linkedin and Twitter) - several ways to be in touch!
TAs+CPs
TAs
Tushar Sharma - tusharsh@usc.edu [Co-Lead]
Aneeta George - aneetage@usc.edu [Co-Lead]
Yuming Gu - yuminggu@usc.edu
Quankai Gao - quankaig@usc.edu
Cho-Ying Wu - choyingw@usc.edu
Zhehui Huang - zhehuihu@usc.edu
Zitong Li - zitong@usc.edu
Wenbin Teng - wenbinte@usc.edu
Pengda Xiang - pxiang@usc.edu
Ziqi Zeng - ziqizeng@usc.edu
Yiqi Zhong - yiqizhon@usc.edu
CPs
Potchara - pheungth@usc.edu
Ashutosh Tiwari - tiwaria@usc.edu
Vinutha - ananthac@usc.edu
Yuke - yuke@usc.edu
Dan Liu - dliu3405@usc.edu
Melody P - mvpereir@usc.edu
Rakshita - sbalivad@usc.edu
Swapnil - swapnilg@usc.edu
Ankita Singh - ankitasi@usc.edu
Ketaki Lolage - klolage@usc.edu
Sowmiya - smathana@usc.edu
Ning - nnie@usc.edu
SeanM - sjmirand@usc.edu
Qianmian - qgai@usc.edu
Aashna Dikshit - adikshit@usc.edu
Vineesha Beri - vberi@usc.edu
Sneha Bandi - snehaban@usc.edu
Chanda - c676498@usc.edu
Mingzhe Piao - mingzhep@usc.edu
Soham Dave - sohammay@usc.edu
Sejal Agr - sejalagr@usc.edu
Anu - ak98783@usc.edu
Lahari - palem@usc.edu
Harini - harinias@usc.edu
Bhaven Vikas Gore - bhavenvi@usc.edu
Purvil Mehta - purvilpr@usc.edu
Vatsal Khandor - khandor@usc.edu
Darshil Patel - darshilh@usc.edu
Charith Balne - balne@usc.edu
Chinmay Patil - cpatil@usc.edu
Mahek Sota - sota@usc.edu
Khyati Gupta - khyatigu@usc.edu
Tirth Patel - tirthjit@usc.edu
In addition to communicating with me, do make it a point to get to know your TAs/CPs! They are all quite knowledgeable and can help you.. Please get in touch with them, to make a 'live' or Zoom (etc) appointment, meet with them!
Policies
Attendance
Attendance is mandatory, for in-class as well as online (excluding DEN) students. Since it's impractical to do a full 'roll call', I will use https://bytes.usc.edu/~saty/tools/xem/run.html?x=att--23s to pick out names (email addresses, actually) at random - if your name comes up, and if you don't respond right away, you will lose 5 points (off your cumulative total for the course) EACH time this happens. If you have a valid+pre-approved reason to be out/away, you most certainly can, it's not a heartless, zero-exceptions policy!
Students with disabilities
Any student requesting academic accommodations based on a disability is required to register with Disability Services and Programs (DSP) each semester. A letter of verification for approved accommodations can be obtained from DSP. Please be sure the letter is delivered to me as early in the semester as possible. DSP is located in STU 301 and is open 8:30 a.m. - 5:00 p.m., Monday through Friday. The phone number for DSP is (213) 740-0776.
Academic integrity
USC seeks to maintain an optimal learning environment. General principles of academic honesty include the concept of respect for the intellectual property of others, the expectation that individual work will be submitted unless otherwise allowed by an instructor, and the obligations both to protect one's own academic work from misuse by others as well as to avoid using another's work as one's own. All students are expected to understand and abide by these principles.
Scampus, the Student Guidebook, contains the Student Conduct Code and also the recommended sanctions for violating academic integrity. The PDF is here.
Students will be referred to the Office of Student Judicial Affairs and Community Standards (SJACS) for further review, should there be any suspicion of academic dishonesty. The Review process can be found here.
Copying (and then modification) of any portion of code from Internet sources or fellow students is prohibited unless cleared with the instructor. In addition, working together on a programming assignment is also a gray area. If your code resembles that of your friend's too closely, that will be considered a VIOLATION.
Here is my policy in plain language: if I come to find out that your submission resembles another submission (from a fellow student in your section or another section, a roommate's submission from an earlier class, submission from someone else who took the class earlier, code found on GitHub etc..), I WILL REPORT YOU TO SJACS, AND GIVE YOU A 0 FOR YOUR SUBMISSION. You can then deal with SJACS to convince them if you need to, that you did not cheat. Please take this very seriously, and BELIEVE it - if you decide to flout the rules, you do so at your own risk.
Translation/bottom line: DO NOT CHEAT under ANY circumstance(s)!!
Emergency preparedness/course continuity in a crisis
In case of a declared emergency if travel to campus is not feasible, USC executive leadership will announce an electronic way for instructors to teach students in their residence halls or homes using a combination of our course site, D2L, teleconferencing, and other technologies. LIKEWISE, on account of COVID-19!