English School of International Relations Theory – Archived Papers

Marco Pagni

Description

• cours - matière : economics
• mémoire
• cours - matière potentielle : analysis
• cours - matière potentielle : theory
• cours - matière potentielle : approach

English School of International Relations Theory – Archived Papers If you would like a copy of any of the following papers, please contact Dr Jason Ralph, School of Politics and International Studies, University of Leeds, Leeds, LS2 9JT, UK. 2006 Papers Mariano Bertucci, We could remember it for you wholesale: On the constitution of national memories, ISA San Diego, March 2006 2005 Papers The following papers are available from the BISA Annucal Conference held at St.

• constitution of national memories
• territorial borders as dynamic norms
• grotian conception of international society
• international society
• norms
• annual conference

Sujets

• Economics
• Mémoire
• Analysis
• Theory
• Approach
• Realism
• Molloy

Informations

• Publié par: phyaf
• Nombre de lectures: 39
• Langue: English
• Poids de l'ouvrage: 4 Mo

Extrait

Introduction to
Information Systems
Lecture 1
Priv.-Doz. Dr. Heinz Stockinger
Spring Term 2009
1
Outline for Today!s Lecture
• Overview of database systems
• Course Outline
• First Steps in SQL
2Staff
• Lecturer
– Heinz Stockinger
• [e-mail]
– Office hours: by appointment
• Teaching Assistant
– Toufic Saad
• Toufic.Saad@epfl.ch
3
Contact details
• Lecturer:
– [e-mail]
• Swiss Institute of Bioinformatics
– Batiment Genopode, office 2016 (UNIL
campus)
– Personal Web site: http://cern.ch/hst
4Communications
• Web page: lsirwww.epfl.ch:
– http://lsirwww.epfl.ch/courses/iis/2009ss
– Lecture slides will be available here
– Homework and solutions will be posted here
– The project description and resources will be
here
• Newsgroup:
– epfl.ic.cours.IIS
5
Main Textbook
• Databases and Transaction
Processing,
An application-oriented approach
Philip M. Lewis, Arthur Bernstein,
Michael Kifer, Addison-Wesley 2002.
6Other Texts
Many classic textbooks (each of them will do it)
• Database Systems: The Complete Book, Hector Garcia-
Molina, Jeffrey Ullman, Jennifer Widom
• Database Management Systems, Ramakrishnan
• Fundamentals of Database Systems, Elmasri, Navathe
• Database Systems, Date (7th edition)
• Modern Database Management, Hoffer, (4th edition)
• Database Systems Concepts, Silverschatz, (4th edition)
7
Material on the Web
SQL Introdution
• SQL for Web Nerds, by Philip Greenspun,
http://philip.greenspun.com/sql/
Java Technology:
– java.sun.com
Web Technology
– www.w3c.org (Specifications/standards)
– http://www-128.ibm.com/developerworks/
8The Course
• Goal: Teaching
– relational database management system (RDBMS)
(standard)
– with a strong emphasis on the Web
• Fortunately, others already did it aready
– Alon Halevy, Dan Suciu, Univ. of Washington
– http://www.cs.washington.edu/education/courses/cse444/
– http://www.acm.org/sigmod/record/issues/0309/4.AlonLevy.pdf
– Lecture was even awarded a price!
9
Acknowledgement
• Build on UoW course
– many slides
– many exercise
– ideas for the project
• Main difference
– less theory
– will use real Web data in the project
• Prof. Aberer previously taught this course in
Summer Term 2004 and 2005
10Let!s get started with databases
11
What is behind this Web Site?
• http://immo.search.ch/
• Search on a large database
• Specify search conditions
• Many users
• Updates
• Access through a Web interface
1213
Database Management
Systems
Database Management System = DBMS
• A collection of files that store the data
• A big C program written by someone else that
accesses and updates those files for you
Relational DBMS = RDBMS
• Data files are structured as relations (tables)
14Where are RDBMS used ?
• Backend for traditional “database”
applications
– EPFL administration
• Backend for large Websites
– Immosearch
• Backend for Web services
– Amazon
15
Example of a Traditional
Database Application
Suppose we are building a system
to store the information about:
• students
• courses
• professors
• who takes what, who teaches what
16Can we do it without a DBMS?
Sure we can! Start by storing the data in files:
students.txt courses.txt professors.txt
Now write C++ or Java programs to implement
specific tasks
17
Doing it without a DBMS...
• Enroll “Mary Johnson” in “CSE444”:
Write a C++/Java program to do the following:
Read ‘students.txt’
Read ‘courses.txt’
Find&update the record “Mary Johnson”“CSE444”
Write “students.txt”“courses.txt”
18Problems without an DBMS...
Read ‘students.txt’ CRASH !• System crashes:
Read ‘courses.txt’
Find&update the record “Mary Johnson”
Find&update the record “CSE444”
Write “students.txt”
Write “courses.txt”
– What is the problem ?
• Large data sets (say 50GB)
– Why is this a problem ?
• Simultaneous access by many users
– Lock students.txt – what is the problem ?
19
Using a DBMS
“Two tier system” or “client-server”
connection
(ODBC, JDBC)
Database server
(someone else’s
ApplicationsData files 20C/C++ program)