LectureSet4 - COP 4610L: Operating Systems Lab Distributed...

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

View Full Document Right Arrow Icon
COP 4610L: Operating Systems Lab Distributed Applications in the Enterprise Lecture Set 4 Dr. R. Lent
Background image of page 1

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

View Full DocumentRight Arrow Icon
Introduction l Database ¡ Collection of data l DBMS ¡ Database management system ¡ Storing and organizing data l SQL ¡ Relational database ¡ Structured Query Language l JDBC ¡ Java Database Connectivity ¡ JDBC driver
Background image of page 2
Relational-Database Model l Relational database ¡ A DB = one or more tables ¡ Table = a number of records ¡ Record = a row of a table ¡ Field = a column of a table ¡ Primary key = Unique data l SQL statement ¡ Query ¡ Record sets
Background image of page 3

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

View Full DocumentRight Arrow Icon
Example RDB model Number Name Department Salary Location 23603 Jones 413 1100 New Jersey 24568 Kerwin 2000 34589 Larson 642 1800 Los Angeles 35761 Myers 611 1400 Orlando 47132 Neumann 9000 78321 Stephens 8500 Row/Record Column/Field Primary key Relational-database structure of an Employee table.
Background image of page 4
Relational-Database Model (cont’d) Department Location 413 611 642 New Jersey Orlando Los Angeles Result set formed by selecting Department and data from the Employee table.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example: The books Database Sample books database ¡ Four tables l Authors , publishers authorISBN and titles ¡ Relationships among the tables
Background image of page 6
The books Database (cont’d) Field Description authorID Author’s ID number in the database. In the books database, this integer field is defined as an autoincremented field . For each new record inserted in this table, the database automatically increments the authorID value to ensure that each record has a unique authorID . This field represents the table’s primary key. firstName Author’s first name (a string). lastName Author’s last name (a string). Fig. 8.3 authors table from books . authorID firstName lastName 1 Harvey Deitel 2 Paul 3 Tem Nieto 4 Sean Santry Fig. 8.4 Data from the authors table of books .
Background image of page 7

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

View Full DocumentRight Arrow Icon
The books Database (cont’d) Field De sc ription publisherID The publisher’s ID number in the database. This autoincremented integer is the table’s primary-key field. publisherName The name of the publisher (a string). Fig. 8.5 publishers table from books . 1 Prentice Hall 2 Prentice Hall PTG Fig. 8.6 Data from the table of .
Background image of page 8
The books Database (cont’d) Field Description authorID The author’s ID number, which allows the database to associate each book with a specific author. The integer ID number in this field must also appear in the authors table. isbn The ISBN number for a book (a string). Fig. 8.7 authorISBN table from books .
Background image of page 9

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

View Full DocumentRight Arrow Icon
The books Database (cont’d) authorID isbn 1 0130895725 2 0139163050 0132261197 013028419x 0130895717 0130161438 0135289106 0130856118 0130125075 0138993947 0130852473 0130829277 0134569555 0130829293 0130284173 0130284181 0130895601 3 4 Fig. 8 .8 Data from the authorISBN table of books .
Background image of page 10
The books Database (cont’d) Field De sc ription isbn ISBN number of the book (a string). title Title of the book (a string). editionNumber Edition number of the book (an integer). copyright Copyright year of the book (a string). publisherID Publisher’s ID number (an integer). This value must correspond to an ID number in the publishers table. imageFile Name of the file containing the book’s cover image (a string). price Suggested retail price of the book (a real number). [ Note: The prices shown in this book are for example purposes only.] Fig. 8.9 titles table from books .
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 07/14/2011 for the course COP 4610L taught by Professor Staff during the Spring '09 term at University of Central Florida.

Page1 / 62

LectureSet4 - COP 4610L: Operating Systems Lab Distributed...

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