cs562 project 1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Implementing a simple application with embedded SQLs PowerPoint Presentation
Download Presentation
Implementing a simple application with embedded SQLs

Loading in 2 Seconds...

play fullscreen
1 / 13

Implementing a simple application with embedded SQLs - PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on

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 :

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Implementing a simple application with embedded SQLs' - ayanna


Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
cs562 project 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

interactive sql
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
embedded sql
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.
how to embedding sql
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
embedded sql1
Embedded SQL
  • For example,
    • JDBC, java
    • Get names of awards which ‘Winona Ryder ‘ won.
queries
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
queries1
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.
output example
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.

environments
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.
submission
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
due date score
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%)