Principles of Database Systems with Internet and Java Applications / Edition 1
by Gregory Riccardi, Greg Riccardi
This book is a concise and modern treatment of introductory database topics that enlists Java and the Internet to present core 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 this
… See more details belowOverview
This book is a concise and modern treatment of introductory database topics that enlists Java and the Internet to present core 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 this book. It motivates the development of data models and the representation of information in relational database systems. Readers 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. This book is appropriate for readers interested in learning about database systems while applying the theory using Java and the Internet.
Product Details
- ISBN-13:
- 9780201612479
- Publisher:
- Pearson
- Publication date:
- 07/27/2000
- Pages:
- 518
- Product dimensions:
- 7.40(w) x 9.00(h) x 1.10(d)
Table of Contents
(Most chapters contain "Chapter Summary," "Key Terms," "Exercises," and "Further Readings.")1. Information Management and Database Systems.
The Importance of Databases to the Economy.
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 Cyclè.
History of Database Systems.
I. INFORMATION MODELS AND RELATIONAL DATABASES.
2. Representing Information with Data Models.
Discovering and Specifying Requirements.
Organizing Information.
Entity-Relationship Modeling.
Entity-Relationship Diagrams.
An ER Model for BigHit Video.
3. Advanced Data Models.
Enhanced ER Modeling.
Object-Oriented Data Modeling.
An OO Model for BigHit.
4. The Relational Data Model.
Introduction to the Relational Model.
Relation Schemas.
Translation From ER Model to Relation Schemas.
Building Databases in Microsoft Access.
5. Improving the Quality of Database Designs.
Functional Dependencies Between Attributes.
Normal Forms.
Normalization Examples.
Referential Integrity and Other Constraints.
II. MANIPULATING RELATIONAL DATA.
6. Techniques for Manipulating Relational Data.
Manipulating Information with the Relational Algebra.
Describing Queries with Relational Calculus.
Defining Queries with QBE and Microsoft Access.
7. SQL, the Standard Query Language.
Using SQL Select Statements for Queries.
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.
Overview of Database Applications Programming.
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.
Introduction to HTML.
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.
Transactions in 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.
Hardware Characteristics of File Systems.
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.
Using Indexes to Access Records by Content.
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 Selection Queries.
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.
Basic Transaction Management.
Concurrent Transaction Processing.
Recoverable Transaction Schedules.
Serializable Transaction Schedules.
15. Reliability and Security in Database Servers.
Backup and Recovery From Failures.
Security in Relational Database Systems.
Stored Procedures and Functions.
Distributed Databases.
VI. OBJECT-ORIENTED AND DISTRIBUTED INFORMATION SYSTEMS.
16. Developing Object-Oriented Distributed Applications.
Creating Distributed Applications.
Enterprise JavaBeans.
Transactions in Java.
17. Representing Information with Object-Oriented Data Models.
Representing Information and Operations in the Java Data Model.
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.
Similarities and Differences between Java and C++.
Compilation and Execution.
Packages and Names.
Class and Virtual Method Hierarchies.
Exceptions and Exception Handling.
Application Programming Interfaces (API).
References.
Index.
Customer Reviews
Average Review: