INFO-I308

Information Representation

• Syllabus and Course Pack
• Topics
  • Foundations
  • Relational and SQL
  • Database Design
  • Application Development and Transactions
  • Introduction to XML
  • Structuring XML
  • Processing and Querying XML
  • Beyond XML
  • Final
  • Additional Topics
• Reference
  • Textbooks
  • Lab Guide
  • Other Software
  • XML
  • Recreation
  • Not Smoking
  • Home Pages
• Canvas
• Instructor
• Credits

Topics

Syllabus and Course Pack

• Syllabus
  • H Option Requirements
• Coursepack, version 3.0, revised 2015 Jan 11 (PDF, 749 KB)
  • Relational operators: data for examples (PDF)
  • SQL examples from the coursepack

Foundations: Primitive Data, Logic, Sets, and Relations

• Primitive data
  • Lecture notes
  • S5 lecture slides
  • Lab 1: Bits
• Logic, sets, and relations
  • Lecture notes
  • S5 lecture slides
  • Lecture recordings: The Relational Model (restricted)
  • See also the coursepack, chapters 1 and 2.
  • Lab 2: Logical Representations (PDF)
  • Lab 3: Relational Algebra (PDF)

Relational Databases: SQL

• Lecture notes: see the coursepack, chapters 3 and 4.
• Lab 4: SQL 1, Basic Queries
• SQL: The Art of Select Queries with Grouping
• Lab 5: SQL 2, Advanced Queries
• SQL: The Art of the Subselect
• Lab 6: SQL 3, More Advanced Queries

Relational Database Design

• Lecture notes: see the coursepack, chapters 5, 6, and 7.
• Lab 7: Database Design

Relational Databases: Application Development and Transactions

• Coursepack:
  • Chapter 8, “Application Design and Development”
  • Chapter 9, “Transactions”
• Revised JDBC Notes and Examples
  • JDBC Slides
• Lecture recordings: JDBC and Transactions (restricted)
• ACM Code of Ethics

Introducing XML

• New XML Overview
  • Slides
• New XML Syntax
  • Slides
• New Exercise 1: Writing Well-Formed XML
• New Lecture recordings (restricted)

Structuring XML

• Revised Namespaces
  • Slides
• Revised DTDs
  • Slides
• New Lecture recordings (restricted)
• Revised Lab 8: Restaurant Basic XML

Processing and Querying XML

Part I: DOM and XPath

• Revised Document Object Model (DOM)
  • Slides
• New XPath
  • Slides
• New Lecture recordings for (restricted)
• New Exercise 2: XPath Expressions

Part II: XQuery

• Revised XQuery
  • Slides
• New Lecture recordings (restricted)
• Revised Lab 9: Restaurant XQuery

Beyond XML

• XML and HTML
• XML Criticism
• Revised JSON: JavaScript Object Notation
• YAML: YAML Ain’t Markup Language

Final Review and Exam

• Revised Final Review Study Guide (PDF), version 5.0, revised 2017 Apr 15.
• We did not have a midterm exam this year. But if you want some extra materials for review of pre-midterm topics, here is an old Midterm Review Study Guide (PDF).

Additional Topics

Not covered in spring 2017.

• CSS
  • PDF Slides
• SVG
• XSD
• RELAX NG
• XSLT
• RDF: Resource Description Framework

Reference

Textbooks

• 1. Coursepack (PDF)
• 2. (Recommended) Neeraj Sharma et al., Database Fundamentals (free-to-read PDF book, copyright 2010 IBM Corporation)
• 3. Fawcett, Quin, and Ayers, Beginning XML, 5th edition. Wiley (WROX books), 2012. 864 pages. ISBN: 978-1-118-16213-2.
  • WROX page for this book with links to Download Code, Errata, and P2P Forum.

Lab Guide

• A Guide to Linux at IU East
• IUE Linux Lab Manual
• PostgreSQL

Other Software

• Prolog/Datalog
  • SWI Prolog
  • GNU Prolog
• PostgreSQL
  • Downloads for various operating systems, Live CDs, etc.
  • Documentation —note that we are using version 8.4.13 on merlin, so the manuals for 8.4 (8.4.15) would be the closest match.
  • On merlin you can also view documentation with the command ‘evince /usr/share/doc/postgresql-docs-8.4.13/postgresql-8.4.13-US.pdf’ (18 MB PDF file), or by browsing file:///usr/share/doc/postgresql-8.4.13/html/index.html
• Comparisons of SQL dialects (with each other and with the SQL:2008 standard)
  • MySQL Hazards and Nuisances by G. Weber
  • Comparison by Troels Arvin
  • SQL Dialects Reference in Wikibooks
• Dia (diagram editor). The Dia Manual can be read online through the Dia Help menu; you can also find the online documentation in the file system at /usr/share/gnome/help/dia/en/index.html
• CouchDB
• MongoDB
• DB-Engines, a knowledge base of relational and NoSQL DBMSs
• JDBC Tutorial
• Weka data mining toolkit
• SQuirreL SQL universal SQL client
• iSQL Independent SQL Tool
• MonetDB
• Oracle Berkely DB
• XML Resources
• More database links
• Object-relational and object-oriented databases

XML

• XML Resources
• Is Codd Dead? —the beginning of a blog

Recreation

• xkcd: Query
• Foxtrot
• Cut the Knot

Not Smoking

• Learning to program can be stressful. Does stress make you want to smoke? ACS Guide to Quitting Smoking (why and how)

Home Pages

• Informatics
• Management Information Systems
• IU East
• IU

Powered by Freedom

Credits

“box with folders” by Nicu Buculei: Open Clip Art Library

Bald eagle photos: BaldEagles.com