Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 98%)
Other sellers (Other Format)
-
All (8)
from
$1.99
-
New (3)
from
$94.45
-
Used (5)
from
$1.99
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$94.45
Seller since Tue Oct 07 09:35:53 EDT 2014
Brand New Item.
Ships from: Chatham, NJ
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
- •Express, 48 States
- •Express (AK, HI)
$105.00
Seller since Tue Oct 07 09:37:03 EDT 2014
Brand new.
Ships from: acton, MA
Usually ships in 1-2 business days
- •Standard, 48 States
- •Standard (AK, HI)
$124.50
Seller since Tue Jan 01 01:01:01 EST 2008
0321185560 New. Looks like an interesting title!
Ships from: Naperville, IL
Usually ships in 1-2 business days
- •Standard, 48 States
- •Standard (AK, HI)
More About This Textbook
Overview
This book provides a concise and modern treatment of introductory database topics that enlists Java and the Internet to present core Database Management (DBMS) theory from an applications perspective. It incorporates programming and database applications when presenting the core theory behind DBMS and their applications.
Information management is the central theme of Principles of Database Systems with Internet and Java Applications. The book motivates the development of data models and the representation of information in relational database systems. Students learn how to define database content with Entity-Relationship models, and how to represent that content in relational systems.They become thoroughly familiar with the SQL language, and learn exactly what is required to build quality information-rich applications. Students also learn how the World Wide Web and Java can work together to publish and collect information in the widest possible context.
This book covers the basic material of information management in detail. Topics covered include analyzing information requirements, conceptual data modeling, translation of conceptual models to relational needs, normalization of relational schemas, SQL, and database application programming. Additional topics include object-oriented modeling and object databases, database performance and optimization, constraints and triggers, transactions, and file structures.
The interaction between applications and databases is discussed and illustrated in the context of Web sites. The JDBC classes of Java provide a database- and platform-independent method of creating database applications, and all of these classes are thoroughly discussed with abundant examples. After learning the fundamentals of HTML and CGI programming, students create their own Web sites using Java programs to service CGI requests and generate HTML responses. Further topics include the use of Java servlets to replace CGI programs and the useof Java I/O classes for the development of file structures.
The Java language provides the foundation for all programming examples because of its portable approach to database access through the JDBC classes. Students do not need extensive experience with Java before using this book, only knowledge of an object-oriented language.
Product Details
Related Subjects
Meet the Author
Greg Riccardi is a professor of computer science at Florida State University and an associate of the Supercomputer Computations Research Institute. Professor Riccardiis research interests include scientific databases, object-oriented databases, and parallel computation. He is also affiliated with the Thomas Jefferson National Accelerator Facility where he works on the acquisition, management, and analysis of data for experimental physics. He received a University Teaching Award in 1997 from Florida State University.
020161247XAB04062001
Table of Contents
(Most chapters contain "Chapter Summary," "Key Terms," "Exercises," and "Further Readings.")
1. Information Management and Database Systems.
How Databases Represent Information.
People in Database Systems.
Management of Information.
Databases and the World Wide Web.
Database Concepts and Architecture.
Phases of an Information System Life Cycle`.
History of Database Systems.
I. INFORMATION MODELS AND RELATIONAL DATABASES.
2. Representing Information with Data Models.
Organizing Information.
Entity-Relationship Modeling.
Entity-Relationship Diagrams.
An ER Model for BigHit Video.
3. Advanced Data Models.
Object-Oriented Data Modeling.
An OO Model for BigHit.
4. The Relational Data Model.
Relation Schemas.
Translation From ER Model to Relation Schemas.
Building Databases in Microsoft Access.
5. Improving the Quality of Database Designs.
Normal Forms.
Normalization Examples.
Referential Integrity and Other Constraints.
II. MANIPULATING RELATIONAL DATA.
6. Techniques for Manipulating Relational Data.
Describing Queries with Relational Calculus.
Defining Queries with QBE and Microsoft Access.
7. SQL, the Standard Query Language.
Modifying Database Content with SQL.
Creating and Manipulating Schemas with SQL.
III. DATABASE APPLICATIONS AND THE WORLD WIDE WEB.
8. Applications Programming for Relational Databases.
JDBC Packages and Database Connections.
Connecting to Databases with JDBC.
Connecting to Databases with Class DBConnect.
Executing Select Statements.
A simple Java SQL Application.
Executing Insert and Update Statements.
Executing Other Statements.
A Sample BigHit Video Application in Java.
User Interfaces in Microsoft Access.
9. Supporting Database Interaction on the World Wide Web.
Active Urls and Forms in HTML.
Using Java to Generate HTML.
CGI Programming with Java.
Java Servlets.
Servlet Applications for BigHit Video.
10. Enhancing Object-Oriented Applications with JDBC.
Prepared Statements and Callable Statements.
Advanced Features of JDBC.
Result Sets in JDBC.
Integrating Result Sets and HTML Forms.
IV. PHYSICAL CHARACTERISTICS OF DATABASES.
11. Managing Information in Files.
Manipulating Streams and Files in Java.
Methods for Representing Values in Streams.
Reading and Writing Binary Values with Data Streams.
Representing Relational Tables as Files.
Files of Records.
Direct Access to Records by Address.
Updating and Deleting Records.
12. Techniques for Improving Access to Information by Value.
Secondary Indexes.
Multi-Level Indexes and B+ Trees.
Representing Indexes with Hash Tables.
Specifying Physical Database Characteristics.
V. ACHIEVING PERFORMANCE AND RELIABILITY WITH RELATIONAL DATABASE SYSTEMS.
13. Query Processing and Query Optimization.
Processing Projection Queries and Eliminating Duplicates.
Processing Join Queries.
Query Plans and Query Optimization for Complex Relational Expressions.
Query Optimization and Database Analysis in Oracle8.
14. Transaction Processing.
Concurrent Transaction Processing.
Recoverable Transaction Schedules.
Serializable Transaction Schedules.
15. Reliability and Security in Database Servers.
Security in Relational Database Systems.
Stored Procedures and Functions.
Distributed Databases.
VI. OBJECT-ORIENTED AND DISTRIBUTED INFORMATION SYSTEMS.
16. Developing Object-Oriented Distributed Applications.
Enterprise JavaBeans.
Transactions in Java.
17. Representing Information with Object-Oriented Data Models.
Implementing Conceptual Model Inheritance in Java.
Making Objects Persistent.
Translation From ER Model to the Java Object Model.
Using Java for BigHit Video Case Study.
Object Databases.
Object-Relational Databases.
Appendix: A Brief Introduction to Java.
Compilation and Execution.
Packages and Names.
Class and Virtual Method Hierarchies.
Exceptions and Exception Handling.
Application Programming Interfaces (API).
References.
Index.