1 / 16

Carnegie Mellon Univ. Dept. of Computer Science 15-415 - Database Applications

Carnegie Mellon Univ. Dept. of Computer Science 15-415 - Database Applications. C. Faloutsos Guidelines for project. Overview. concepts of SQL programs walkthrough of HW3_Create.java walkthrough of showAll.java (all on the web site). ORACLE. see the two Java programs: HW3_Create.java

nanda
Download Presentation

Carnegie Mellon Univ. Dept. of Computer Science 15-415 - Database Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Carnegie Mellon Univ.Dept. of Computer Science15-415 - Database Applications C. Faloutsos Guidelines for project

  2. Overview • concepts of SQL programs • walkthrough of HW3_Create.java • walkthrough of showAll.java • (all on the web site) 15-415 - C. Faloutsos

  3. ORACLE see the two Java programs: HW3_Create.java showAll.java Concepts embedded SQL cursor 15-415 - C. Faloutsos

  4. Outline of an SQL application establish connection with ORACLE server authenticate (user/password) execute SQL statement(s) process results close connection 15-415 - C. Faloutsos

  5. Pictorially: dbclass.intro.cs.cmu.edu andrew machine eg., sun4.andrew JDBC/ODBC Windows NT box; with ORACLE Server HW3_Create.java HW3_Create.class 15-415 - C. Faloutsos

  6. interesting observation very important point HW1_Create.java • Purpose: to load the parent-child table • No need for you to understand it fully - but you MUST run it, to load the (parent, child) table! legend: 15-415 - C. Faloutsos

  7. Walk-through HW3_Create.java 15-415 - C. Faloutsos

  8. Walk-through HW3_Create.java 15-415 - C. Faloutsos

  9. Walk-through HW3_Create.java 15-415 - C. Faloutsos

  10. Walk-through HW3_Create.java • rest of program: • read input file • insert one tuple at a time • close connection 15-415 - C. Faloutsos

  11. Walk-through HW3_Create.java 15-415 - C. Faloutsos

  12. Overview • concepts of SQL programs • walkthrough of HW3_Create.java • walkthrough of showAll.java 15-415 - C. Faloutsos

  13. Walk-through showAll.java • purpose: print all (parent, child) pairs • note: very useful for the project: just change • (a) the SQL statements • (b) the processing of the results 15-415 - C. Faloutsos

  14. Walk-through showAll.java 15-415 - C. Faloutsos

  15. Walk-through showAll.java 15-415 - C. Faloutsos

  16. Conclusions • concepts of SQL programs • necessary: HW1_Create.java • modify showAll.java wrt • SQL statements • result processing 15-415 - C. Faloutsos

More Related