Muutke küpsiste eelistusi

Database Systems: A Practical Approach to Design, Implementation and Management: United States Edition 5th edition [Pehme köide]

3.66/5 (346 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 1400 pages, kõrgus x laius x paksus: 232x190x43 mm, kaal: 1800 g
  • Ilmumisaeg: 16-Apr-2009
  • Kirjastus: Pearson
  • ISBN-10: 0321523067
  • ISBN-13: 9780321523068
Teised raamatud teemal:
  • Pehme köide
  • Hind: 165,24 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Database Systems: A Practical Approach to Design, Implementation and Management: United States Edition 5th editionSuurem pilt
  • Formaat: Paperback / softback, 1400 pages, kõrgus x laius x paksus: 232x190x43 mm, kaal: 1800 g
  • Ilmumisaeg: 16-Apr-2009
  • Kirjastus: Pearson
  • ISBN-10: 0321523067
  • ISBN-13: 9780321523068
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780321523068.html
Märksõnad:
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design.

Background: Introduction to Databases; Database Environment; Database Architectures and the Web.The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE).Database Analysis and Design: Database System Lifecycle; Database Analysis and theDreamHome Case Study; Entity–Relationship Modeling; Enhanced Entity–Relationship Modeling; Normalization; Advanced Normalization.Methodology: Methodology—Conceptual Database Design; Methodology—Logical Database Design for Relational Model; Methodology—Physical Database Design for Relational Databases; Methodology—Monitoring and Tuning the Operational System.Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing.Distributed DBMSs and Replication: Distributed DBMSs—Concepts and Design; Distributed DBMSs—Advanced Concepts; Replication and Mobile Databases.Object DBMSs: Object-Oriented DBMSs—Concepts and Design; Object-Oriented DBMSs—Standards and Languages; Object-Relational DBMSs.Web and DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies:Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices:Users' Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho—A Liteweight RDBMS.Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational ; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts.

This book is ideal for readers interested in database management or database design.
Preface xxxv
Part 1 Background
1(88)
Introduction to Databases
3(32)
Introduction
4(3)
Traditional File-Based Systems
7(7)
File-Based Approach
7(5)
Limitations of the File-Based Approach
12(2)
Database Approach
14(7)
The Database
15(1)
The Database Management System (DBMS)
16(1)
(Database) Application Programs
17(1)
Components of the DBMS Environment
18(3)
Database Design: The Paradigm Shift
21(1)
Roles in the Database Environment
21(2)
Data and Database Administrators
21(1)
Database Designers
22(1)
Application Developers
23(1)
End-Users
23(1)
History of Database Management Systems
23(4)
Advantages and Disadvantages of DBMSs
27(8)
Chapter Summary
31(1)
Review Questions
32(1)
Exercises
32(3)
Database Environment
35(22)
The Three-Level ANSI-SPARC Architecture
36(5)
External Level
37(1)
Conceptual Level
38(1)
Internal Level
38(1)
Schemas, Mappings, and Instances
39(1)
Data Independence
40(1)
Database Languages
41(4)
The Data Definition Language (DDL)
42(1)
The Data Manipulation Language (DML)
42(2)
Fourth-Generation Languages (4GLs)
44(1)
Data Models and Conceptual Modeling
45(4)
Object-Based Data Models
46(1)
Record-Based Data Models
46(3)
Physical Data Models
49(1)
Conceptual Modeling
49(1)
Functions of a DBMS
49(8)
Chapter Summary
54(1)
Review Questions
55(1)
Exercises
55(2)
Database Architectures and the Web
57(32)
Multi-user DBMS Architectures
58(11)
Teleprocessing
58(1)
File-Server Architecture
59(1)
Traditional Two-Tier Client-Server Architecture
60(3)
Three-Tier Client-Server Architecture
63(1)
N-Tier Architectures
64(1)
Middleware
65(2)
Transaction Processing Monitors
67(2)
Web Services and Service-Oriented Architectures
69(3)
Web Services
69(1)
Service-Oriented Architectures (SOA)
70(2)
Distributed DBMSs
72(2)
Data Warehousing
74(3)
Components of a DBMS
77(3)
Oracle Architecture
80(9)
Oracle's Logical Database Structure
80(2)
Oracle's Physical Database Structure
82(4)
Chapter Summary
86(1)
Review Questions
87(1)
Exercises
87(2)
Part 2 The Relational Model and Languages
89(170)
The Relational Model
91(18)
Brief History of the Relational Model
92(2)
Terminology
94(9)
Relational Data Structure
94(3)
Mathematical Relations
97(1)
Database Relations
98(1)
Properties of Relations
98(2)
Relational Keys
100(1)
Representing Relational Database Schemas
101(2)
Integrity Constraints
103(2)
Nulls
103(1)
Entity Integrity
104(1)
Referential Integrity
104(1)
General Constraints
105(1)
Views
105(4)
Terminology
105(1)
Purpose of Views
106(1)
Updating Views
107(1)
Chapter Summary
107(1)
Review Questions
108(1)
Exercises
108(1)
Relational Algebra and Relational Calculus
109(24)
The Relational Algebra
110(13)
Unary Operations
110(3)
Set Operations
113(3)
Join Operations
116(3)
Division Operation
119(1)
Aggregation and Grouping Operations
120(2)
Summary of the Relational Algebra Operations
122(1)
The Relational Calculus
123(5)
Tuple Relational Calculus
123(3)
Domain Relational Calculus
126(2)
Other Languages
128(5)
Chapter Summary
129(1)
Review Questions
129(1)
Exercises
130(3)
SQL: Data Manipulation
133(42)
Introduction to SQL
134(3)
Objectives of SQL
134(1)
History of SQL
135(2)
Importance of SQL
137(1)
Terminology
137(1)
Writing SQL Commands
137(1)
Data Manipulation
138(37)
Simple Queries
139(8)
Sorting Results (Order By Clause)
147(2)
Using the SQL Aggregate Functions
149(2)
Grouping Results (Group By Clause)
151(3)
Subqueries
154(2)
ANY and ALL
156(2)
Multi-table Queries
158(6)
EXISTS and NOT EXISTS
164(1)
Combining Result Tables (UNION, INTERSECT, EXCEPT)
165(2)
Database Updates
167(4)
Chapter Summary
171(1)
Review Questions
172(1)
Exercises
172(3)
SQL: Data Definition
175(38)
The ISO SQL Data Types
176(5)
SQL Identifiers
176(1)
SQL Scalar Data Types
177(1)
Exact Numeric Data
178(3)
Integrity Enhancement Feature
181(4)
Required Data
182(1)
Domain Constraints
182(1)
Entity Integrity
183(1)
Referential Integrity
184(1)
General Constraints
185(1)
Data Definition
185(8)
Creating a Database
186(1)
Creating a Table (CREATE TABLE)
187(3)
Changing a Table Definition (ALTER TABLE)
190(1)
Removing a Table (DROP TABLE)
191(1)
Creating an Index (CREATE INDEX)
192(1)
Removing an Index (DROP INDEX)
192(1)
Views
193(10)
Creating a View (CREATE VIEW)
193(2)
Removing a View (DROP VIEW)
195(1)
View Resolution
196(1)
Restrictions on Views
197(1)
View Updatability
197(1)
WITH CHECK OPTION
198(2)
Advantages and Disadvantages of Views
200(2)
View Materialization
202(1)
Transactions
203(1)
Immediate and Deferred Integrity Constraints
204(1)
Discretionary Access Control
204(9)
Granting Privileges to Other Users (GRANT)
206(1)
Revoking Privileges from Users (REVOKE)
207(2)
Chapter Summary
209(1)
Review Questions
210(1)
Exercises
210(3)
Advanced SQL
213(20)
The SQL Programming Language
214(8)
Declarations
214(1)
Assignments
215(1)
Control Statements
216(2)
Exceptions in PL/SQL
218(1)
Cursors in PL/SQL
219(3)
Subprograms, Stored Procedures, Functions, and Packages
222(1)
Triggers
223(6)
Recursion
229(4)
Chapter Summary
230(1)
Review Questions
231(1)
Exercises
231(2)
Query-By-Exaple
233(26)
Introduction to Microsoft Office Access Queries
234(2)
Building Select Queries Using QBE
236(6)
Specifying Criteria
237(2)
Creating Multi-table Queries
239(3)
Calculating Totals
242(1)
Using Advanced Queries
242(8)
Parameter Query
242(1)
Crosstab Query
243(3)
Find Duplicates Query
246(2)
Find Unmatched Query
248(1)
Autolookup Query
249(1)
Changing the Content of Tables Using Action Queries
250(9)
Make-Table Action Query
250(1)
Delete Action Query
250(3)
Update Action Query
253(1)
Append Action Query
253(5)
Exercises
258(1)
Part 3 Database Analysis and Design
259(256)
Database System Development Lifecycle
261(30)
The Information Systems Lifecycle
262(1)
The Database System Development Lifecycle
263(1)
Database Planning
263(3)
System Definition
266(1)
User Views
266(1)
Requirements Collection and Analysis
266(4)
Centralized Approach
268(1)
View Integration Approach
268(2)
Database Design
270(5)
Approaches to Database Design
271(1)
Data Modeling
271(1)
Phases of Database Design
272(3)
DBMS Selection
275(4)
Selecting the DBMS
275(4)
Application Design
279(4)
Transaction Design
280(1)
User Interface Design Guidelines
281(2)
Prototyping
283(1)
Implementation
283(1)
Data Conversion and Loading
284(1)
Testing
284(1)
Operational Maintenance
285(1)
CASE Tools
286(5)
Chapter Summary
288(1)
Review Questions
289(1)
Exercises
290(1)
Database Analysis and the DreamHome Case Study
291(30)
When Are Fact-Finding Techniques Used?
292(1)
What Facts are Collected?
293(1)
Fact-Finding Techniques
294(3)
Examining Documentation
294(1)
Interviewing
294(1)
Observing the Enterprise in Operation
295(1)
Research
296(1)
Questionnaires
296(1)
Using Fact-Finding Techniques: A Worked Example
297(24)
The DreamHome Case Study---An Overview of the Current System
298(4)
The DreamHome Case Study---Database Planning
302(6)
The DreamHome Case Study---System Definition
308(1)
The DreamHome Case Study---Requirements Collection and Analysis
309(8)
The DreamHome Case Study---Database Design
317(1)
Chapter Summary
318(1)
Review Questions
318(1)
Exercises
318(3)
Entity-Relationship Modeling
321(28)
Entity Types
322(2)
Relationship Types
324(5)
Degree of Relationship Type
326(2)
Recursive Relationship
328(1)
Attributes
329(4)
Simple and Composite Attributes
329(1)
Single-valued and Multi-valued Attributes
330(1)
Derived Attributes
330(1)
Keys
331(2)
Strong and Weak Entity Types
333(1)
Attributes on Relationships
334(1)
Structural Constraints
335(7)
One-to-One (1:1) Relationships
336(1)
One-to-Many (1:*) Relationships
337(1)
Many-to-Many (*:*) Relationships
338(1)
Multiplicity for Complex Relationships
339(1)
Cardinality and Participation Constraints
340(2)
Problems with ER Models
342(7)
Fan Traps
342(2)
Chasm Traps
344(2)
Chapter Summary
346(1)
Review Questions
346(1)
Exercises
347(2)
Enhanced Entity-Relationship Modeling
349(16)
Specialization/Generalization
350(11)
Superclasses and Subclasses
350(1)
Superclass/Subclass Relationships
351(1)
Attribute Inheritance
352(1)
Specialization Process
352(1)
Generalization Process
353(3)
Constraints on Specialization/Generalization
356(1)
Worked Example of using Specialization/Generalization to Model the Branch View of the DreamHome Case Study
357(4)
Aggregation
361(1)
Composition
362(3)
Chapter Summary
363(1)
Review Questions
364(1)
Exercises
364(1)
Normalization
365(28)
The Purpose of Normalization
366(1)
How Normalization Supports Database Design
367(1)
Data Redundancy and Update Anomalies
368(2)
Insertion Anomalies
369(1)
Deletion Anomalies
369(1)
Modification Anomalies
370(1)
Functional Dependencies
370(8)
Characteristics of Functional Dependencies
370(4)
Identifying Functional Dependencies
374(3)
Identifying the Primary Key for a Relation Using Functional Dependencies
377(1)
The Process of Normalization
378(2)
First Normal Form (INF)
380(4)
Second Normal Form (2NF)
384(1)
Third Normal Form (3NF)
385(2)
General Definitions of 2NF and 3NF
387(6)
Chapter Summary
389(1)
Review Questions
389(1)
Exercises
390(3)
Advanced Normalization
393(102)
More on Functional Dependencies
394(80)
Inference Rules for Functional Dependencies
394(2)
Minimal Sets of Functional Dependencies
396(78)
The Physical Database Design Methodology for Relational Database
474(21)
Step 3: Translate Logical Data Model for Target DBMS
474(5)
Step 4
479(13)
Step 5: Design User Views
492(1)
Step 6: Design Security Mechanisms
492(1)
Chapter Summary
493(1)
Review Questions
494(1)
Exercises
494(1)
Methodology---Monitoring and Tuning the Operational System
495(20)
Denormalizing and Introducing Controlled Redundancy
495(13)
Step 7: Consider the Introduction of Controlled Redundancy
495(13)
Monitoring the System to Improve Performance
508(7)
Step 8: Monitor and Tune the Operational System
508(4)
Chapter Summary
512(1)
Review Questions
513(1)
Exercises
513(2)
Part 5 Selected Database Issues
515(164)
Security and Administration
517(32)
Database Security
518(3)
Threats
519(2)
Countermeasures---Computer-Based Controls
521(10)
Authorization
522(1)
Access Controls
523(3)
Views
526(1)
Backup and Recovery
526(1)
Integrity
527(1)
Encryption
527(1)
RAID (Redundant Array of Independent Disks)
528(3)
Security in Microsoft Office Access DBMS
531(2)
Security in Oracle DBMS
533(4)
DBMSs and Web Security
537(7)
Proxy Servers
538(1)
Firewalls
538(1)
Message Digest Algorithms and Digital Signatures
539(1)
Digital Certificates
539(1)
Kerberos
540(1)
Secure Sockets Layer and Secure HTTP
540(1)
Secure Electronic Transactions and Secure Transaction Technology
541(1)
Java Security
542(2)
ActiveX Security
544(1)
Data Administration and Database Administration
544(5)
Data Administration
545(1)
Database Administration
546(1)
Comparison of Data and Database Administration
546(1)
Chapter Summary
547(1)
Review Questions
548(1)
Exercises
548(1)
Professional, Legal, and Ethical Issues in Data Management
549(20)
Defining Legal and Ethical Issues in IT
550(3)
Defining Ethics in the Context of IT
550(1)
The Difference Between Ethical and Legal Behavior
551(1)
Ethical Behavior in IT
552(1)
Legislation and Its Impact on the IT Function
553(5)
Securities and Exchange Commission (SEC) Regulation National Market System (NMS)
553(1)
The Sarbanes-Oxley Act, COBIT, and COSO
553(2)
The Health Insurance Portability and Accountability Act
555(1)
The European Union (EU) Directive on Data Protection of 1995
555(1)
The United Kingdom's Data Protection Act of 1998
556(1)
International Banking---Basel II Accords
557(1)
Establishing a Culture of Legal and Ethical Data Stewardship
558(5)
Developing an Organization-Wide Policy for Legal and Ethical Behavior
558(1)
Professional Organizations and Codes of Ethics
559(2)
Developing an Organization-Wide Policy for Legal and Ethical Behavior for DreamHome
561(2)
Intellectual Property
563(6)
Patent
563(1)
Copyright
564(1)
Trademark
564(1)
Intellectual Property Rights Issues for Software
565(1)
Intellectual Property Rights Issues for Data
566(1)
Chapter Summary
566(1)
Review Questions
567(1)
Exercises
567(2)
Transaction Management
569(58)
Transaction Support
570(4)
Properties of Transactions
573(1)
Database Architecture
573(1)
Concurrency Control
574(28)
The Need for Concurrency Control
574(3)
Serializability and Recoverability
577(8)
Locking Methods
585(6)
Deadlock
591(3)
Timestamping Methods
594(3)
Multiversion Timestamp Ordering
597(1)
Optimistic Techniques
598(1)
Granularity of Data Items
599(3)
Database Recovery
602(9)
The Need for Recovery
602(1)
Transactions and Recovery
603(3)
Recovery Facilities
606(3)
Recovery Techniques
609(2)
Recovery in a Distributed DBMS
611(1)
Advanced Transaction Models
611(7)
Nested Transaction Models
613(1)
Sagas
614(1)
Multilevel Transaction Model
615(1)
Dynamic Restructuring
616(1)
Workflow Models
617(1)
Concurrency Control and Recovery in Oracle
618(9)
Oracle's Isolation Levels
619(1)
Multiversion Read Consistency
619(2)
Deadlock Detection
621(1)
Backup and Recovery
621(3)
Chapter Summary
624(1)
Review Questions
625(1)
Exercises
625(2)
Query Processing
627(52)
Overview of Query Processing
629(3)
Query Decomposition
632(4)
Heuristical Approach to Query Optimization
636(6)
Transformation rules for the Relational Algebra Operations
636(5)
Heuristical Processing Strategies
641(1)
Cost Estimation for the Relational Algebra Operations
642(18)
Database Statistics
642(1)
Selection Operation (S = Σp(R))
643(7)
Join Operation (T = (R F S))
650(7)
Projection Operation ( S = II A1, A2,...., Am (R))
657(2)
The Relational Algebra Set Operations (T = R U S, T = R ∪ S, T = R - S)
659(1)
Enumeration of Alternative Execution Strategies
660(8)
Pipelining
661(1)
Linear Trees
661(1)
Physical Operators and Execution Strategies
662(2)
Reducing the Search Space
664(1)
Enumerating Left-Deep Trees
665(1)
Semantic Query Optimization
666(1)
Alternative Approaches to Query Optimization
667(1)
Distributed Query Optimization
668(1)
Query Optimization in Oracle
668(11)
Rule-Based and Cost-Based Optimization
668(4)
Histograms
672(2)
Viewing the Execution Plan
674(1)
Chapter Summary
675(1)
Review Questions
676(1)
Exercises
676(3)
Part 6 Distributed DBMSs and Replication
679(120)
Distributed DBMSs---Concepts and Design
681(46)
Introduction
682(11)
Concepts
683(4)
Advantages and Disadvantages of DDBMSs
687(3)
Homogeneous and Heterogeneous DDBMSs
690(3)
Overview of Networking
693(4)
Functions and Architectures of a DDBMS
697(4)
Functions of a DDBMS
697(1)
Reference Architecture for a DDBMS
697(2)
Reference Architecture for a Federated MDBS
699(1)
Component Architecture for a DDBMS
700(1)
Distributed Relational Database Design
701(11)
Data Allocation
702(1)
Fragmentation
703(9)
Transparencies in a DDBMS
712(9)
Distribution Transparency
712(3)
Transaction Transparency
715(3)
Performance Transparency
718(2)
DBMS Transparency
720(1)
Summary of Transparencies in a DDBMS
720(1)
Date's Twelve Rules for a DDBMS
721(6)
Chapter Summary
723(1)
Review Questions
724(1)
Exercises
724(3)
Distributed DBMSs---Advanced Concepts
727(44)
Distributed Transaction Management
728(1)
Distributed Concurrency Control
729(4)
Objectives
729(1)
Distributed Serializability
730(1)
Locking Protocols
730(3)
Timestamp Protocols
733(1)
Distributed Deadlock Management
733(4)
Distributed Database Recovery
737(13)
Failures in a Distributed Environment
737(1)
How Failures Affect Recovery
738(1)
Two-Phase Commit (2PC)
739(6)
Three-Phase Commit (3PC)
745(4)
Network Partitioning
749(1)
The X/Open Distributed Transaction Processing Model
750(3)
Distributed Query Optimization
753(10)
Data Localization
754(4)
Distributed Joins
758(1)
Global Optimization
759(4)
Distribution in Oracle
763(8)
Oracle's DDBMS Functionality
763(5)
Chapter Summary
768(1)
Review Questions
769(1)
Exercises
770(1)
Replication and Mobile Databases
771(28)
Introduction to Database Replication
772(2)
Synchronous Versus Asynchronous Replication
773(1)
Applications of Replication
774(1)
Replication Servers
774(8)
Replication Server Functionality
775(1)
Data Ownership
775(4)
Implementaion Issues
779(3)
Introduction to Mobile Databases
782(2)
Mobile DBMSs
784(6)
Issues with Mobile DBMSs
784(6)
Oracle Replication
790(9)
Oracle's Replication Functionality
790(6)
Chapter Summary
796(1)
Review Questions
797(1)
Exercises
797(2)
Part 7 Object DBMSs
799(172)
Object-Oriented DBMSs---Concepts and Design
801(70)
Advanced Database Applications
803(4)
Weaknesses of RDBMSs
807(5)
Storing Objects in a Relational Database
812(4)
Mapping Classes to Relations
813(1)
Accessing Objects in the Relational Database
814(2)
Next-Generation Database Systems
816(1)
Introduction to OODBMSs
817(12)
Definition of Object-Oriented DBMSs
818(1)
Functional Data Models
819(5)
Persistent Programming Languages
824(1)
The Object-Oriented Database System Manifesto
825(3)
Alternative Strategies for Developing an OODBMS
828(1)
Persistence in OODBMSs
829(10)
Pointer Swizzling Techniques
831(3)
Accessing an Object
834(2)
Persistence Schemes
836(1)
Orthogonal Persistence
837(2)
Issues in OODBMSs
839(10)
Transactions
839(1)
Versions
840(1)
Schema Evolution
841(3)
Architecture
844(2)
Benchmarking
846(3)
Advantages and Disadvantages of OODBMSs
849(4)
Advantages
849(2)
Disadvantages
851(2)
Object-Oriented Database Design
853(5)
Comparison of Object-Oriented Data Modeling and Conceptual Data Modeling
853(1)
Relationships and Referential Integrity
854(2)
Behavioral Design
856(2)
Object-Oriented Analysis and Design with UML
858(13)
UML Diagrams
859(5)
Usage of UML in the Methodology for Database Design
864(2)
Chapter Summary
866(1)
Review Questions
867(1)
Exercises
868(3)
Object-Oriented DBMSs---Standards and Systems
871(50)
Object Management Group
872(11)
Background
872(3)
The Common Object Request Broker Architecture
875(5)
Other OMG Specifications
880(3)
Model-Driven Architecture
883(1)
Object Data Standard ODMG 3.0, 1999
883(24)
Object Data Management Group
885(1)
The Object Model
886(8)
The Object Definition Language
894(3)
The Object Query Language
897(6)
Other Parts of the ODMG Standard
903(3)
Mapping the Conceptual Design to a Logical (Object-Oriented) Design
906(1)
Object Store
907(14)
Architecture
907(3)
Building an ObjectStore Application
910(1)
Data Definition in ObjectStore
911(4)
Data Manipulation in ObjectStore
915(3)
Chapter Summary
918(1)
Review Questions
919(1)
Exercises
919(2)
Object-Relational DBMSs
921(50)
Introduction to Object-Relational Database Systems
922(3)
The Third-Generation Database Manifestos
925(4)
The Third-Generation Database System Manifesto
926(1)
The Third Manifesto
926(3)
Postgres---An Early ORDBMS
929(3)
Objectives of Postgres
929(1)
Abstract Data Types
929(1)
Relations and Inheritance
930(1)
Object Identity
931(1)
SQL:2008
932(23)
Row Types
933(1)
User-Defined Types
934(2)
Subtypes and Supertypes
936(3)
User-Defined Routines
939(1)
Polymorphism
940(1)
Reference Types and Object Identity
941(1)
Creating Tables
942(3)
Querying Data
945(1)
Collection Types
946(4)
Typed Views
950(1)
Persistent Stored Modules
950(1)
Triggers
951(3)
Large Objects
954(1)
Recursion
955(1)
Query Processing and Optimization
955(4)
New Index Types
959(1)
Object-Oriented Extensions in Oracle
959(9)
User-Defined Data Types
960(5)
Manipulating Object Tables
965(1)
Object Views
966(1)
Privileges
967(1)
Comparison of ORDBMS and OODBMS
968(3)
Chapter Summary
969(1)
Review Questions
969(1)
Exercises
970(1)
Part 8 The Web and DBMSs
971(172)
Web Technology and DBMSs
973(82)
Introduction to the Internet and the Web
974(4)
Intranets and Extranets
976(1)
e-Commerce and e-Business
977(1)
The Web
978(13)
Hyper Text Transfer Protocol
979(2)
Hyper Text Markup Language
981(1)
Uniform Resource Locators
982(1)
Static and Dynamic Web Pages
982(2)
Web Services
984(1)
Requirements for Web DBMS Integration
985(1)
Advantages and Disadvantages of the Web---DBMS Approach
986(4)
Approaches to Integrating the Web and DBMSs
990(1)
Scripting Languages
991(2)
JavaScript and Jscript
991(1)
VBScript
992(1)
Perl and PHP
993(1)
Common Gateway Interface (CGI)
993(5)
Passing Information to a CGI Script
995(2)
Advantages and Disadvantages of CGI
997(1)
HTTP Cookies
998(1)
Extending the Web Server
999(1)
Comparison of CGI and API
1000(1)
Java
1000(32)
JDBC
1004(6)
SQLJ
1010(1)
Comparison of JDBC and SQLJ
1010(1)
Container-Managed Persistence (CMP)
1011(4)
Java Data Objects (JDO)
1015(7)
JPA (Java Persistence API)
1022(8)
Java Servlets
1030(1)
JavaServer Pages
1030(1)
Java Web Services
1031(1)
Microsoft's Web Platform
1032(12)
Universal Data Access
1034(1)
Active Server Pages and Active X Data Objects
1035(1)
Remote Data Services
1036(3)
Comparison of ASP and JSP
1039(1)
Microsoft.NET
1039(5)
Microsoft Web Services
1044(1)
Oracle Internet Platform
1044(11)
Oracle Application Server (Oracle AS)
1045(6)
Chapter Summary
1051(1)
Review Questions
1052(1)
Exercises
1053(2)
Semistructured Data and XML
1055(88)
Semistructured Data
1056(7)
Object Exchange Model (OEM)
1058(1)
Lore and Lorel
1059(4)
Introduction to XML
1063(8)
Overview of XML
1066(2)
Document Type Definitions (DTDs)
1068(3)
XML-Related Technologies
1071(10)
DOM and SAX Interfaces
1072(1)
Namespaces
1073(1)
XSL and XSLT
1073(1)
XPath (XML Path Language)
1074(1)
XPointer (XML Pointer Language)
1075(1)
XLink (XML Linking Language)
1076(1)
XHTML
1076(1)
Simple Object Access Protocol (SOAP)
1077(1)
Web Services Description Language (WSDL)
1077(1)
Universal Discovery, Description and Integration (UDDI)
1078(3)
XML Schema
1081(10)
Resource Description Framework (RDF)
1087(4)
XML Query Languages
1091(30)
Extending Lore and Lorel to Handle XML
1092(1)
XML Query Working Group
1093(1)
XQuery---A Query Language for XML
1094(10)
XML Information Set
1104(1)
XQuery 1.0 and XPath 2.0 Data Model (XDM)
1105(6)
XQuery Update Facility 1.0
1111(2)
Formal Semantics
1113(8)
XML and Databases
1121(15)
Storing XML in Databases
1121(3)
XML and SQL
1124(11)
Native XML Databases
1135(1)
XML in Oracle
1136(7)
Chapter Summary
1139(2)
Review Questions
1141(1)
Exercises
1142(1)
Business Intelligence
1143(100)
Data Warhousing Concepts
1145(28)
Introduction to Data Warehousing
1146(7)
The Evolution of Data Warehousing
1146(1)
Data Warehousing Concepts
1147(1)
Benefits of Data Warehousing
1148(1)
Comparison of OLTP Systems and Data Warehousing
1148(2)
Problems of Data Warehousing
1150(2)
Real-Time Data Warehouse
1152(1)
Data Warehouse Architecture
1153(4)
Operational Data
1153(1)
Operational Data Store
1153(1)
ETL Manager
1154(1)
Warehouse Manager
1154(1)
Query Manager
1155(1)
Detailed Data
1155(1)
Lightly and Highly Summarized Data
1155(1)
Archive/Backup Data
1155(1)
Metadata
1156(1)
End-User Access Tools
1156(1)
Data Warehousing Tools and Technologies
1157(7)
Extraction, Transformation, and Loading (ETL)
1158(1)
Data Warehouse DBMS
1159(3)
Data Warehouse Metadata
1162(2)
Administration and Management Tools
1164(1)
Data Mart
1164(1)
Reasons for Creating a Data Mart
1165(1)
Data Warehousing Using Oracle
1165(8)
New Warehouse Features in Oracle 10g/11g
1168(1)
Chapter Summary
1169(1)
Review Questions
1170(1)
Exercise
1171(2)
Data Warehousing Design
1173(26)
Designing a Data Warehouse Database
1174(1)
Data Warehouse Development Methodologies
1174(2)
Kimball's Business Dimensional Lifecycle
1176(1)
Dimensionality Modeling
1177(4)
Comparison of DM and ER models
1180(1)
The Dimensional Modeling Stage of Kimball's Business Dimensional Lifecycle
1181(8)
Create a High-Level Dimensional Model (Phase I)
1181(1)
Select Business Process
1181(2)
Declare Grain
1183(1)
Choose Dimensions
1183(2)
Identify Facts
1185(1)
Identify All Dimension Attributes for the Dimensional Model (Phase II)
1186(3)
Data Warehouse Development Issues
1189(1)
Data Warehouse Design Using Oracle
1190(9)
Oracle Warehouse Builder Components
1190(1)
Using Oracle Warehouse Builder
1191(4)
New Warehouse Builder Features in Oracle 10g/11g
1195(1)
Chapter Summary
1196(1)
Review Questions
1197(1)
Exercises
1198(1)
OLAP
1199(30)
Online Analytical Processing
1200(1)
OLAP Benchmarks
1201(1)
OLAP Application
1201(2)
Multidimensional Data Model
1203(4)
Alternative Multidimensional Data Representations
1203(2)
Dimensional Hierarchy
1205(2)
Multidimensional Operations
1207(1)
Multidimensional Schemas
1207(1)
OLAP Tools
1207(7)
Codd's Rules for OLAP Tools
1208(1)
OLAP Server---Implementation Issues
1209(1)
Categories of OLAP Server
1210(4)
OLAP Extensions to the SQL Standard
1214(7)
Extended Grouping Capabilities
1214(5)
Elememtary OLAP Operators
1219(2)
Oracle OLAP
1221(8)
Oracle OLAP Environment
1221(1)
Platform for Business Intelligence Applications
1222(1)
Oracle Database
1222(2)
Oracle OLAP
1224(1)
Performance
1225(1)
System Management
1226(1)
System Requirements
1226(1)
New OLAP Features in Oracle IIg
1226(1)
Chapter Summary
1226(1)
Review Questions
1227(1)
Exercises
1227(2)
Data Mining
1229(14)
Data Mining
1230(1)
Data Mining Techniques
1230(6)
Predictive Modeling
1232(1)
Database Segmentation
1233(1)
Link Analysis
1234(1)
Deviation Detection
1235(1)
The Data Mining Process
1236(1)
The CRISP-DM Model
1236(1)
Data Mining Tools
1237(1)
Data Mining and Data Warehousing
1238(1)
Oracle Data Mining (ODM)
1239(4)
Data Mining Capabilities
1239(1)
Enabling Data Mining Applications
1239(1)
Predictions and Insights
1240(1)
Oracle Data Mining Environment
1240(1)
New Data Mining Features in Oracle 11g
1241(1)
Chapter Summary
1241(1)
Review Questions
1242(1)
Exercises
1242(1)
Appendices
1243
A Users' Requirements Specification for DreamHome Case Study
1(1)
Branch User Views of DreamHome
1(1)
Data Requirements
1(2)
Transaction Requirements (Sample)
3(1)
Staff User Views of DreamHome
4(1)
Data Requirements
4(1)
Transaction Requirements (Sample)
5
B Other Case Studies
1(1)
The University Accommodation Office Case Study
1(1)
Data Requirements
1(2)
Query Transactions (Sample)
3(1)
The Easy Drive School of Motoring Case Study
4(1)
Data Requirements
4(1)
Query Transactions (Sample)
5(1)
The Wellmeadows Hospital Case Study
5(1)
Data Requirements
5(7)
Transaction Requirements (Sample)
12
C Alternative ER Modeling Notations
1(1)
ER Modeling Using the Chen Notation
1(1)
ER Modeling Using the Crow's Feet Notation
1(1)
D Summary of the Database Design Methodology for Relational Databases
1(1)
Build Conceptual Data Model
1(1)
Build Logical Data Model
2(3)
Translate Logical Data Model for Target DBMS
5(1)
Design File Organizations and Indexes
5(1)
Design User Views
5(1)
Design Security Mechanisms
5(1)
Consider the Introduction of Controlled Redundancy
6(1)
Monitor and Tune the Operational System
6
E Introduction to Pyrrho: A Lightweight RDBMS
1(1)
Pyrrho Features
2(1)
Download and Install Pyrrho
2(1)
Getting Started
3(1)
The Connection String
3(1)
Pyrrho's Security Model
4(1)
Pyrrho SQL Syntax
4
F File Organizations and Indexes (Online)
1(1)
G When Is a DBMS Relational? (Online)
1(1)
H Commercial DBMSs: Access and Oracle (Online)
1(1)
I Programmatic SQL (Online
1(1)
J Estimating Disk Space Requirements (Online)
1(1)
K Introduction to Object-Orientation (Online)
1(1)
L Example Web Scripts (Online)
1(1)
References 1(1)
Further Reading 1(1)
Index 1
Thomas M. Connolly is the head of the Computing and Information Systems division at the University of Paisley.

Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine.