1 / 13

Implementing a simple application with embedded SQLs

CS562 Project #1. Implementing a simple application with embedded SQLs. TA: Lee, Min-Joong. Assignment Date : October 11th, 2012 Due Date : October 28th, 2012. Interactive SQL. SQL queries which you can type in at the SQL prompt. INTERACTIVE SQL is good for :

ayanna
Download Presentation

Implementing a simple application with embedded SQLs

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. CS562 Project #1 Implementing a simple application with embedded SQLs TA: Lee, Min-Joong Assignment Date : October 11th, 2012 Due Date : October 28th, 2012

  2. Interactive SQL • SQL queries which you can type in at the SQL prompt. • INTERACTIVE SQL is good for: • defining database structure • Create database, tables …. • generating low-volume, ad hoc queries • prototyping

  3. Embedded SQL • SQL is a ‘non-procedural’ language. • INTERACTIVE SQL is not good for the more sophisticated applications. • SQL can be embedded within procedural programming languages(host language). • Supports • highly customized applications • background applications running without user intervention • database manipulation which exceeds the abilities of simple SQL.

  4. HOW to embedding SQL? • USE ESQL - old school style! • ESQL/c, ESQL/C++ , ESQL/COBOL ,… • ESQL is precompiled by preprocessor. • Use APIs • JDBC • ADO.NET • ODBC • …

  5. Embedded SQL • For example, • JDBC, java • Get names of awards which ‘Winona Ryder ‘ won.

  6. Queries • Translate given statements into SQLs and process the query using your application. • Initial data input • Insert award data • Insert rating data • Select statements • Update statements • Delete statements

  7. Initial data

  8. Queries • Some queries are should be implemented using an embedded SQL method rather than using a single SQL statement or a trigger. • Unspecified queries can be implemented in any ways.

  9. Output-Example Before run your application, assume that the database is empty. You should show the results for translated inserts/deletes/updates queries and all the updated tables for each statement.

  10. Environments • Recommended environments • Language : JAVA • IDE : Eclipse • DBMS : MySQL • JDBC download: http://dev.mysql.com/downloads/connector/j/ • DBMS setting • Database name : CS562_studentID (ex., CS562_20111234) • Root id : root // password : cs562 • Tables are should be named as I descried in the initial data table. • Database should be installed at localhost(local machine) • If cannot understand above description, read JDBC Introduction.

  11. Submission • Files to submit : cs562_studentid.zip includes the following files. • Program source files • README.txt • How to run your program. • What you have implemented and what you have not. • Your implementation assumption if there are any. • Submission • E mail : mjlee@islab.kaist.ac.kr • Mail subject : [cs562 project#1] studentid_name • ex) [cs562 project#1] 20111234_John

  12. Due date & Score • Due date : Oct. 28, 2012 Midnight • Penalty : 20% per day • Score • Create table processing (20%) • Insert processing (20%) • Update processing (15%) • Query processing (15%) • Delete processing (15%) • README and comment (15%)

  13. Q & A

More Related