259 Park Science Building
gtowell at brynmawr dot edu
|Lecture Hours||MW 11:40am -- 1:00pm|
|Lab Hours|| W 2:40 -- 4:00
If it is more convenient for you, lab may also be done W 1:10-2:30. (See my office hours below)
|Lab Room||Park 231|
|Office Hours|| T 11am-Noon, W 1:10 -- 2:30
Also by appointment
|Zoom||Meeting code: 232 840 6920. Password: given in class, or ask me|
|Computer Lab||Park 231
Instructions for using the lab computers
Remote accessible lab computer status
by Silberschatz, Korth and Sudarshan
Not required But I have found useful
Learning SQL by Beaulieu
Not required But I have found useful
MongoDB: The definitive guide
by Bradshaw, Brazil and Chodorow
- Jan 19, First Class
March 2Feb 28 Midterm
- Exam period, Final Exam
All assignments must be turned in on time. If there are compelling reasons why you cannot turn in an assignment on time, you must ask for permission at least 48 hours in advance of the due date.
Despite my best efforts, homeworks may have sections that are not quite correct. If you find an error, let me know. If I agree that the issue is an issue and you have told me of the issue at least 48 hours prior to the due date then I will give bonus points as follows:
3 points for the first issue reported 2 points for the second issue reported 1 point for the third issue reportedOrdering of the bonus points is based on date of email receipt. One bonus per person per assignment.
|Homework 1||Jan 27||A lot of setup steps, making sure that everything works for you.|
|Homework 2||Feb 13||Some fairly complex SQL queries|
|Homework 3||Feb 23||Your own dataset and writeup thereon|
|Homework 4||April 6||Putting your data into databases|
|Homework 5||April 28||A web site for access to your data|
- Lab 1: Jan 19.
Access and login
- Lab 2: Jan 26.
SQL queries on one table
Answers to the SQL queries
- Lab 3: Feb 2 SQL queries, mostly on more than one table.
Answers to the SQL queries.
- Lab 4: Feb 9 Making a home page
- Lab 6: Feb 23 Node.js
- Lab 7: Mar 16 Normalizing a database
- Lab 8: Mar 23 CSV to PostgreSQL
family table creation
family filler in python
- Lab 9: Mar 30 Mongo Queries
- Lab 10: April 6 Heap's Law
- Lab 11: April 13 Computing TF-IDF weights
- Lab 12: April 20 Using TF-IDF weights
This course is intended to be fairly free-flowing with a lot of discussion. Therefore, I will not normally publish powerpoint lecture notes. I will try to restrict my commentary to topics covered in the text.
- Jan 19: Introductory remarks.
Slides used in class
- Jan 24. Finish intro; relational algebra; PostgreSQL
Slides for class
- Jan 26. SQL -- without joins
Slides for class
Rachel -- 3.3
Judy -- 3.4-3.5
SQL to list all columns of all tables in a DB. to use psql -d DATABASE < AllColumns.sql
Python to show size fo every table in DB to use python AllSizes.py DATABASE
- Jan 31. SQL Joins
- Feb 2: SQL from other places
ODBC using Go
Python to Postgres slides
Python program from class
- Feb 7: URI and HTML
Issac's slides on URIs
Tova's slides on the basics of html
Joseph's slides on the DOM
Paige's slides on long and short polling
Short Polling page
Long Polling page
look over shoulder
replace with random string
Simpler closure and timer
ugly closure and timer
Trang on functions and triggers in SQL
Al on Closures
SQL for functions on last slide
Sara's node.js presentation
Node.js instructions for Hello world
Node.js instructions for long and short polling
- Feb 23: Node.js
node.js for use
static html page served by node.js
node.js for get
static page with form doing a get
node.js for urlencoded post
static page with form doing post
node.js for POST with JSON
Adrian's WebSockets slides
node.js for server sent events
html page for Server Seent events
a simple node server just to spit out static html pages.
html page for browser side of server sent events
node.js to actually run the websocket server
Slices for node - postgres connection
Node.js for ODBC communications with PostGreSQL
html page doing fetch and client side formatting
html page using forms. Response is a fully formatted new web page.
- March 2 -- Making Databases in SQL
My slides This version of the slides has the query/view from class uncovered. We only got to slide 14.
- March 14 -- More on database construction in Relations DBs
Menna on Normalizing databases
- March 16 -- SQL advanced alternatives
Xinran on more data types
Olga on Json in Postgres
- March 21 -- Mongo
Sarah's intro slides
William -- Create and drop in Mongo
Femi -- updating data in Mongo
Converting an rdbms to mongo
- March 23 -- Mongo finding data
Menna -- Basic Mongo queries
Adrian -- Array Queries in Mongo
Paige -- Mongo Aggregation framework
Embedded documents and usage ideas
- March 28 -- Mongo Review, Indexing
My mongo review slides
Iryna -- indexing RDBMS -- the underlying mechanics
Tova -- Indexing Mongo
- March 30 -- Mongo from Python/Java, B+ Trees
Keeton -- Mongo Python
Keeton -- Python code from demo
Ellie -- B+ Trees
Java jar file for Mongo
java jar file for PostGreSQL
- April 6, Map-Reduce, Page Rank, Starting IR
Information Retrieval - Pt 1
Ellie F -- PageRank
Alec -- Map-Reduce
- April 11, Text DB System, Transactions, IR pt 2
Information retrieval -- part 2
Mohamed -- Google structure -->
Angie -- concurrency handling part 1
Rachel -- concurrency pt 2
Isaac -- timestamp based transaction protocols
- April 13, Concurrency, IR pt 3
Information retrieval -- part 2
Joseph -- Intro to Transactions
Trang -- Transactions Pt 2
- April 18, Spreadsheets as databases, Mongo and Node
accessing Mongo from Node.js
Anna -- spreadsheet intro
Xinran -- spreadsheet basics
Isabelle -- spreadsheets in practice
Isabelle -- VBA example
- April 20, Parallelism and Databases, Evaluating IR, HW5 Sample
starting page for example
The example, working
Attendance and active participation are
expected in every class. Participation includes asking questions,
contributing answers, proposing ideas, and providing constructive
Please stay in touch with me, particularly if you feel stuck on a topic or assignment and can't figure out how to proceed. Often a quick e-mail, or face-to-face conference can reveal solutions to problems and generate renewed creative and scholarly energy. It is essential that you begin assignments early.
GradingGrades will be awarded based on the number of points earned and according to the percentage breakdowns shown.
|Class Presentations (2)|
|Presentation on Hw5 Project||5%|
The mid-term exam will be on a class day and timed to take a class period. However, it will be self-scheduled. You may take it any time starting about 9am. You must complete it before midnight. All exams will be open everything. The only restriction is that you may not discuss the exam, in any way, with anyone until 24 hours after the exam (unless you are told otherwise).
Incomplete grades will be given only for verifiable medical
illness or other such dire circumstances. Incomplete grades must be approved through the Dean's
ALL work submitted for grading should be entirely YOUR OWN (except for labs) and group work. Sharing of programs, code snippets, etc. is not permitted under ANY circumstances. That said, I encourage you to discuss assignments at an algorithmic level with other students. That is, talk about the problem, and general approaches to problems. Do not share or discuss actual code.
- Kernighan's book on programming style. Most of the examples in this book are in languages rarely if ever used, but the lessons still apply.
Learning AccommodationsStudents requesting accommodations in this course because of the impact of disability are encouraged to meet with me privately early in the semester with a verification letter. Students not yet approved to receive accommodations should also contact Deb Alder, Coordinator of Accessibility Services, at 610-526-7351 in Guild Hall, as soon as possible, to verify their eligibility for reasonable accommodations. Early contact will help avoid unnecessary inconvenience and delays.
This class may be recorded.
Creating a Welcoming EnvironmentAll members of the Instruction Staff are dedicated to the cause of improving diversity, equity, and inclusion in the field of computing, and to supporting the wellness and mental health of our students.
Diversity and InclusionIt is essential that all members of the course community – the instructor, TAs, and students – work together to create a supportive, inclusive environment that welcomes all students, regardless of their race, ethnicity, gender identity, sexuality, or socioeconomic status. All participants in this course deserve to and should expect to be treated with respect by other members of the community. Class meetings, lab sessions, office hours, and group working time should be spaces where everyone feels welcome and included. In order to foster a welcoming environment, students of this course are expected to: exercise consideration and respect in their speech and actions; attempt collaboration and consideration, including listening to opposing perspectives and authentically and respectfully raising concerns, before conflict; refrain from demeaning, discriminatory, or harassing behavior and speech.
WellnessAdditionally, your mental health and wellness are of utmost importance to the course Instruction Staff, if not the College as a whole. All members of the instruction staff will be happy to chat or just to listen if you need someone to talk to, even if it’s not specifically about this course. If you or someone you know is in distress and urgently needs to speak with someone, please do not hesitate to contact BMC Counseling Services: 610-526-7360 (610-526-7778 nights and weekends). If you are uncomfortable reaching out to Counseling Services, any member of the Instruction Staff will be happy to contact them on your behalf. We understand that student life can be extremely difficult, both mentally and emotionally. If you are living with mental health issues such as anxiety, depression, ADHD, or other conditions that may affect you this semester, you are encouraged to discuss these with the Instructor. Although the details are up to you to disclose, the Instruction Staff will do their best to support and accommodate you in order to ensure that you can succeed this course while staying healthy.
Created on January 2021. Subject to constant revision.