Principles of Database Systems With Internet and Java Applications
Greg Riccardi
- 出版商: Addison Wesley
- 出版日期: 2000-08-06
- 定價: $1,000
- 售價: 5.0 折 $499
- 語言: 英文
- 頁數: 544
- 裝訂: Paperback
- ISBN: 020161247X
- ISBN-13: 9780201612479
-
相關分類:
Java 程式語言、資料庫
立即出貨(限量) (庫存=4)
買這商品的人也買了...
-
Concrete Mathematics: A Foundation for Computer Science, 2/e (Hardcover)$3,390$3,221 -
Computer Organization & Design: The Hardware/Software Interface, 2/e$1,200$1,176 -
Design Patterns: Elements of Reusable Object-Oriented Software (Hardcover)$2,500$2,375 -
Data Mining: Concepts and Techniques$2,610$2,480 -
$1,068Software Engineering, 6/e -
LPI Linux Certification in a Nutshell (Paperback)$1,550$1,473 -
$1,029Operating System Concepts, 6/e -
$1,009Concepts of Programming Languages, 5/e (精裝) -
$1,045Java How to Program, 4/e -
$199Web Design in a Nutshell, 2/e (Paperback) -
$970Introduction to Algorithms, 2/e -
Evaluating Software Architectures: Methods and Case Studies (Hardcover)$2,475$2,351 -
Building Linux Virtual Private Networks (VPNS) (Paperback)$1,575$1,496 -
$825Cisco CCNA Exam #640-607 Certification Guide, 3/e -
802.11 Wireless Networks: The Definitive Guide$1,710$1,625 -
Linux Kernel Programming, 3/e$1,120$1,098 -
$1,274Computer Architecture: A Quantitative Approach, 3/e(精裝本) -
$1,029Operating System Concepts, 6/e (Windows XP Update) -
Cryptography and Network Security Principles and Practices, 3/e$1,030$1,009 -
JavaScript 範例活用辭典$450$351 -
Programming the Microsoft Windows Driver Model, 2/e (Paperback)$2,340$2,223 -
Programming Jakarta Struts$1,550$1,473 -
Understanding the Linux Kernel, 2/e (Paperback)$1,860$1,767 -
Embedded Software Development with eCos$1,650$1,568 -
重構─改善既有程式的設計$720$569
相關主題
商品描述
Description
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 use of 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. 
Database Systems.
Features
- Presents the traditional topics covered in a first database course with emphasis on working with DBMS (as opposed to focusing on theoretical concepts behind creating DBMS, and advanced topics).
- Includes a running case study—"Big Hit Video, Inc."—to illustrate the implementation of core concepts in Microsoft Access and SQL by building from simple to complex.
- Introduces Java in an appendix so students can cover the necessary aspects of the language to complete the exercises in the text.
- Provides an actual full DB implementation in Access and in SQL and a sample Web site with all required Java classes.
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.
商品描述(中文翻譯)
這本書提供了簡潔且現代的介紹性資料庫主題，並利用Java和互聯網從應用的角度呈現核心的資料庫管理（DBMS）理論。在介紹DBMS及其應用的核心理論時，它結合了編程和資料庫應用。信息管理是《具有互聯網和Java應用的資料庫系統原理》的核心主題。本書激發了數據模型的發展以及在關聯式資料庫系統中的信息表示。學生學習如何使用實體關係模型定義資料庫內容，以及如何在關聯系統中表示該內容。他們對SQL語言非常熟悉，並且了解構建資訊豐富應用程序所需的確切內容。學生還學習了網際網路和Java如何共同工作以在最廣泛的上下文中發布和收集信息。本書詳細介紹了信息管理的基本材料。涵蓋的主題包括分析信息需求，概念數據建模，將概念模型轉化為關聯需求，關聯模式的規範化，SQL和資料庫應用程序編程。其他主題包括面向對象建模和對象資料庫，資料庫性能和優化，約束和觸發器，事務和文件結構。討論並以網站為背景介紹了應用程序和資料庫之間的交互作用。Java的JDBC類提供了一種獨立於資料庫和平台的方法來創建資料庫應用程序，並且所有這些類都有豐富的例子進行了詳細討論。在學習了HTML和CGI編程的基礎知識後，學生使用Java程序創建自己的網站，以服務CGI請求並生成HTML響應。進一步的主題包括使用Java servlet替換CGI程序以及使用Java I/O類開發文件結構。由於Java通過JDBC類提供了可移植的資料庫訪問方法，因此Java語言成為所有編程示例的基礎。學生在使用本書之前不需要對Java有廣泛的經驗，只需要對面向對象的語言有所了解。適合的課程包括資料庫系統。特點包括：強調與DBMS一起工作而不是專注於創建DBMS和高級主題的理論概念；包含一個案例研究“Big Hit Video, Inc.”，通過從簡單到複雜的構建，演示了在Microsoft Access和SQL中實現核心概念；在附錄中介紹Java，以便學生可以掌握完成教材中的練習所需的語言方面；提供了在Access和SQL中的實際完整的資料庫實現以及包含所有所需Java類的示例網站。目錄包括：1.信息管理和資料庫系統。大多數章節包含“章節摘要”，“關鍵詞”，“練習”和“進一步閱讀”。
