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)

https://bytes.usc.edu/cs585/s23-da-taaa

https://courses.uscden.net/d2l/home/25323

https://piazza.com/usc/spring2023/cs585 [access code: OMG-data]














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!