CS411-Proj-DB_Progra - CS411 Database Systems Term Project Introduction to Database Programming Reza Shiftehfar PhD Student and Research Assistant

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
September 20, 2011 Reza Shiftehfar PhD. Student and Research Assistant in Computer Science Dept. of Computer Science University of Illinois at Urbana Champaign E-mail: [email protected] CS411: Database Systems:: Term Project Introduction to Database Programming
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Project Groups should be all finalized by now: If you are still not in a group, send an email to Reza immediately ( [email protected] ) If you need additional member in your group, send an email to Reza. Additional member is not guaranteed Remember: Everyone in class must do project Track 1 Both Grad. / undergrad regardless of 3 or 4 credit-hours CS411 Course Project Track 1
Background image of page 2
3 Today’s Objective: Quick overview of the project‟s server and cPanel Logging in Transferring files to your Server Creating Databases and DB Users PHPMYAdmin DB Programming Using SQL in PHP Using SQL in Java Using Stored Procedures CS411 Course Project Track 1
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Part 1: Project Server and cPanel CS411 Course Project
Background image of page 4
5 Project Server:: General: Everyone should have access to the project servers by the end of this week Project server will be at http://accounts.cs.illinois.edu/projects Accounts will be enabled by the end of this week Use your netID and your Active Directory Password to log in Try logging in early. In case of any problem email [email protected] Check the link below for more info: https://wiki.engr.illinois.edu/display/engineeringit/Database+and+We b+Resources+%28cPanel%29 CS411 Course Project Track 1
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 Project Server:: Server Generals: Everyone has: 500mb of disk space Access to MySQL database with up to 10 databases PHPMyAdmin for managing MySQL databases Ability to run PHP scripts PHP and html editors Website access logs Website located at http://netid.projects.cs.illinois.edu CS411 Course Project Track 1
Background image of page 6
7 Project Server:: cPanel: cPanel is a Linux based web hosting control panel that provides graphical interface and automation tools designed to simplify the process of hosting a website. CS411 Course Project Track 1
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
8 Project Server:: cPanel: Demo of cPanel: Logging on - http://accounts.cs.illinois.edu/projects Adding/Modifying Files Adding DB Adding User PHPMyAdmin I recommend writing your file on your computer and then transfering it to server using either cPanel or FTP programs (e.g. FileZilla) Find help on cPanel website at http://cpanel.net/ CS411 Course Project Track 1
Background image of page 8
9 DB Programming SQL is a very high-level language Not intended for general purpose computations Solutions: Outside DBMS: use SQL together with general-purpose programming languages Inside DBMS: augment SQL with constructs from general-purpose programming languages CS411 Course Project
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
10 Part 2: Programming outside the DBMS CS411 Course Project
Background image of page 10
11 How to use a database: Connect to a DB Server Say what database you want to use Create a string containing an SQL statement Get the DBMS to prepare a plan for executing the statement Execute the statement Extract the results into variables in the local programming language
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/17/2012 for the course CS 411 taught by Professor Winslett during the Fall '07 term at University of Illinois at Urbana–Champaign.

Page1 / 58

CS411-Proj-DB_Progra - CS411 Database Systems Term Project Introduction to Database Programming Reza Shiftehfar PhD Student and Research Assistant

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online