{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Session9 - Application Programming for Relational Databases...

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

View Full Document Right Arrow Icon
1 C. Shahabi Application Programming for Relational Databases Cyrus Shahabi Computer Science Department University of Southern California [email protected]
Background image of page 1

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

View Full Document Right Arrow Icon
2 C. Shahabi ° Overview ° JDBC Package ° Connecting to databases with JDBC ° Executing select queries ° Executing update queries
Background image of page 2
3 C. Shahabi Overview ° Role of an application: Update databases, extract info, through: ° User interfaces ° Non-interactive programs ° Development tools (Access, Oracle): ° For user Interfaces ° Programming languages (C, C++, Java,… ): ° User Interfaces ° Non-Interactive programs ° More professional
Background image of page 3

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

View Full Document Right Arrow Icon
4 C. Shahabi Client server architecture ° Database client: ° Connects to DB to manipulate data: ° Software package ° Application (incorporates software package) ° Client software: ° Provide general and specific capabilities ° Oracle provides different capabilities as Sybase (its own methods, … )
Background image of page 4
5 C. Shahabi Client server architecture ° Client-Server architectures: ° 2 tier ° 3 tier ° Layer 1: ° user interface ° Layer 2: ° Middleware ° Layer 3: ° DB server ° Middleware: ° Server for client ° Client for DB
Background image of page 5

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

View Full Document Right Arrow Icon
6 C. Shahabi Client server architecture ° Example: Web interaction with DB ° Layer 1: web browser ° Layer 2: web server + cgi program ° Layer 3: DB server
Background image of page 6
7 C. Shahabi Client server architecture ° Application layer (1): ° User interfaces ° Other utilities (report generator, …) ° Connect to middleware ° Can connect to DB too ° Can have more than one connection ° Can issue SQL, or invoke methods in lower layers. ° Middleware layer (2): ° More reliable than user applications
Background image of page 7

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

View Full Document Right Arrow Icon
8 C. Shahabi Database interaction in Access ° Direct interaction with DB ° For implementing applications ° Not professional ° Developer edition: ° Generates stand alone application ° Access application: ° GUI + “Visual Basic for Applications” code
Background image of page 8
9 C. Shahabi Database interaction in Access ° Connection to DB through: ° Microsoft Jet database engine ° Support SQL access ° Different file formats ° Other Database Connectivity (ODBC) ° Support SQL DBs ° Requires driver for each DB server Driver allows the program to become a client for DB ° Client behaves Independent of DB server
Background image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}