Ramdan Hours:
Sun - Thu
9.30 AM - 2.30 PM
Iftar in --:--:--
🌙 Maghrib: --:--

Fundamentals of database systems / (Record no. 3301)

MARC details
000 -LEADER
fixed length control field 12608cam a22003974i 4500
001 - CONTROL NUMBER
control field 14234572
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20220810131726.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 060118s2007 maua b 001 0 eng
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 0321369572
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 0321122267 (hbk.)
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9780321369574
040 ## - CATALOGING SOURCE
Original cataloging agency DLC
Description conventions rda
Transcribing agency DLC
Modifying agency UKM
-- C#P
-- YUS
-- BAKER
-- DLC
-- EG-NcFUE
Language of cataloging eng
082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.74
Edition number 22
Item number E.R.S
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Elmasri, Ramez.
9 (RLIN) 13196
245 10 - TITLE STATEMENT
Title Fundamentals of database systems /
Statement of responsibility, etc Ramez Elmasri, Shamkant B. Navathe.
250 ## - EDITION STATEMENT
Edition statement Fifth edition
264 #1 - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication, distribution, etc Boston :
Name of publisher, distributor, etc Pearson/Addison Wesley,
Date of publication, distribution, etc [2007]
264 #4 - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Date of publication, distribution, etc c2007
300 ## - PHYSICAL DESCRIPTION
Extent xxviii, 1139 pages :
Other physical details illustrations ;
Dimensions 24 cm.
336 ## - CONTENT TYPE
Content type term text
Content type code txt
Source rdacontent
337 ## - MEDIA TYPE
Media type term unmediated
Media type code n
Source rdamedia
338 ## - CARRIER TYPE
Carrier type term volume
Carrier type code nc
Source rdacarrier
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc Includes bibliographical references (pages 1067-1095) and index.
505 #0 - FORMATTED CONTENTS NOTE
Formatted contents note Chapter 1 - Databases and Database Users<br/><br/>1.1 Introduction<br/><br/>1.2 An Example<br/><br/>1.3 Characteristics of the Database Approach<br/><br/>1.4 Actors on the Scene<br/><br/>1.5 Workers behind the Scene<br/><br/>1.6 Advantages of Using the DBMS Approach<br/><br/>1.7 A Brief History of Database Applications<br/><br/>1.8 When Not to Use a DBMS<br/><br/>1.9 Summary<br/><br/>Chapter 2 - Database System Concepts and Architecture<br/><br/>2.1 Data Models, Schemas, and Instances<br/><br/>2.2 Three-Schema Architecture and Data Independence<br/><br/>2.3 Database Languages and Interfaces<br/><br/>2.4 The Database System Environment<br/><br/>2.5 Centralized and Client/Server Architectures for DBMSs<br/><br/>2.6 Classification of Database Management Systems<br/><br/>2.7 Summary<br/><br/>Chapter 3 - Data Modeling Using the Entity-Relationship (ER) Model<br/><br/>3.1 Using High-Level Conceptual Data Models for Database Design<br/><br/>3.2 An Example Database Application<br/><br/>3.3 Entity Types, Entity Sets, Attributes, and Keys<br/><br/>3.4 Relationship Types, Relationship Sets, Roles, and Structural Constraints<br/><br/>3.5 Weak Entity Types<br/><br/>3.6 Refining the ER Design for the COMPANY Database<br/><br/>3.7 ER Diagrams, Naming Conventions, and Design Issues<br/><br/>3.8 Example of Other Notation: UML Class Diagrams<br/><br/>3.9 Relationship Types of Degree Higher Than Two<br/><br/>3.10 Summary<br/><br/>Chapter 4 - The Enhanced Entity-Relationship (EER) Model<br/><br/>4.1 Subclasses, Superclasses, and Inheritance<br/><br/>4.2 Specialization and Generalization<br/><br/>4.3 Constraints and Characteristics of Specialization and Generalization Hierarchies<br/><br/>4.4 Modelin of UNION Types Using Categories<br/><br/>4.5 An Example UNIVERSITY EER Schema, Design Choices, and Formal Definitions<br/><br/>4.6 Example of Other Notation: Representing Specialization and Generalization in UML Class Diagrams<br/><br/>4.7 Data Abstraction, Knowledge Representation, and Ontology Concepts<br/><br/>Part 2- Relational Model: Concepts, Constraints, Languages, Design, and Programming<br/><br/>Chapter 5 - The Relational Data Model and Relational Database Constraints<br/><br/>5.1 Relational Model Concepts<br/><br/>5.2 Relational Model Constraints and Relational Database Schemas<br/><br/>5.3 Update Operations, Tranactions, and Dealing with Constraint Violations<br/><br/>5.4 Summary<br/><br/>Chapter 6 - The Relational Algebra and Relational Calculus<br/><br/>6.1 Unary Relational Operations: SELECT and PROJECT<br/><br/>6.2 Relational Algebra Operations from Set Theory<br/><br/>6.3 Binary Relational Operations: JOIN and DIVISION<br/><br/>6.4 Additional Relational Operations<br/><br/>6.5 Examples of Queries in Relational Algebra<br/><br/>6.6 The Tuple Relational Calculus<br/><br/>6.7 The Domain Relational Calculus<br/><br/>6.8 Summary
505 #0 - FORMATTED CONTENTS NOTE
Formatted contents note Chapter 7 - Relational Database Design by ERand EER-to-Relational Mapping<br/><br/>7.1 Relational Database Design Using ER-to-Relational Mapping<br/><br/>7.2 Mapping EER Model Constructs to Relations<br/><br/>7.3 Summary<br/><br/>Chapter 8 - SQL-99: Schema Definition, Constraints, Queries, and Views<br/><br/>8.1 SQL Data Definition and Data Types<br/><br/>8.2 Specifying Constraints in SQL<br/><br/>8.3 Schema Change Statements in SQL<br/><br/>8.4 Basic Queries in SQL<br/><br/>8.5 More Complex SQL Queries<br/><br/>8.6 INSERT, DELETE, and UPDATE Statements in SQL<br/><br/>8.7 Specifying Constraints as Assertions and Triggers<br/><br/>8.8 Views (Virtual Tables) in SQL<br/><br/>8.9 Additional Features of SQL<br/><br/>8.10 Summary<br/><br/>Chapter 9 - Introduction to SQL Programming Techniques<br/><br/>9.1 Database Programming: Issues and Techniques<br/><br/>9.2 Embedded SQL, Dynamic SQL, and SQLJ<br/><br/>9.3 Database Programming with Function Calls: SQL/CLI and JDBC<br/><br/>9.4 Database Stored Procedures and SQL/PSM<br/><br/>9.5 Summary<br/><br/>Part 3 - Database Design Theory and Methodology<br/><br/>Chapter 10 - Functional Dependencies and Normalization for Relational Databases<br/><br/>10.1 Informal Design Guidelines for Relation Schemas<br/><br/>10.2 Functional Dependencies<br/><br/>10.3 Normal Forms Based on Primary Keys<br/><br/>10.4 General Definitions of Second and Third Normal Forms<br/><br/>10.5 Boyce-Codd Normal Form<br/><br/>10.6 Summary<br/><br/>Chapter 11 - Relational Database Design Algorithms and Further Dependencies<br/><br/>11.1 Properties of Relational Decompositions<br/><br/>11.2 Algorithms for Relational Database Schema Design<br/><br/>11.3 Multivalued Dependencies and Fourth Normal Form<br/><br/>11.4 Join Dependencies and Fifth Normal Form<br/><br/>11.5 Inclusion Dependencies<br/><br/>11.6 Other Dependencies and Normal Forms<br/><br/>11.7 Summary<br/><br/>Chapter 12 - Practical Database Design Methodology and Use of UML Diagrams<br/><br/>12.1 The Role of Information Systems in Organizations<br/><br/>12.2 The Database Design and Implementation Process<br/><br/>12.3 Use of UML Diagrams As an Aid to Database Design Specification<br/><br/>12.4 Rational Rose, a UML-Based Design Tool<br/><br/>12.5 Automated Database Design Tools<br/><br/>12.6 Summary
505 #0 - FORMATTED CONTENTS NOTE
Formatted contents note Part 4 - Data Storage, Indexing, Query Processing, and Physical Design<br/><br/>Chapter 13 - Disk Storage, Basic File Structures, and Hashing<br/><br/>13.1 Introduction<br/><br/>13.2 Secondary Storage Devices<br/><br/>13.3 Buffering of Blocks<br/><br/>13.4 Placing File Records on Disk<br/><br/>13.5 Operations on Files<br/><br/>13.6 Files of Unordered Records (Heap Files)<br/><br/>13.7 Files of Ordered Records (Sorted Files)<br/><br/>13.8 Hashing Techniques<br/><br/>13.9 Other Primary File Organizations<br/><br/>13.10 Parallelizing Disk Access Using RAID Technology<br/><br/>13.11 New Storage Systems<br/><br/>13.12 Summary<br/><br/>Chapter 14 - Indexing Structures for Files<br/><br/>14.1 Types of Single-Level Ordered Indexes<br/><br/>14.2 Multilevel Indexes<br/><br/>14.3 Dynamic Multilevel Indexes Using B-Trees and B+-Trees<br/><br/>14.4 Indexes on Multiple Keys<br/><br/>14.5 Other Types of Indexes<br/><br/>14.6 Summary<br/><br/>Chapter 15 - Algorithms for Query Processing and Optimization<br/><br/>15.1 Translating SQL Queries into Relational Algebra<br/><br/>15.2 Algorithms for External Sorting<br/><br/>15.3 Algorithms for SELECT and JOIN Operations<br/><br/>15.4 Algorithms for PROJECT and SET Operations<br/><br/>15.5 Implementing Aggregate Operations and OUTER JOINS<br/><br/>15.6 Combining Operations Using Pipelining<br/><br/>15.7 Using Heuristics in Query Optimization<br/><br/>15.8 Using Selectivity and Cost Estimates in Query Optimization<br/><br/>15.9 Overview of Query Optimization in Oracle<br/><br/>15.10 Semantic Query Optimization<br/><br/>15.11 Summary
505 #0 - FORMATTED CONTENTS NOTE
Formatted contents note Chapter 16 - Physical Database Design and Tuning<br/><br/>16.1 Physical Database Design in Relational Databases<br/><br/>16.2 An Overview of Database Tuning in Relational Systems<br/><br/>16.3 Summary<br/><br/>Part 5 - Transaction Processing Concepts<br/><br/>Chapter 17 - Introduction to Transaction Processing Concepts and Theory<br/><br/>17.1 Introduction to Transaction Processing<br/><br/>17.2 Transaction and System Concepts<br/><br/>17.3 Desirable Properties of Transactions<br/><br/>17.4 Characterizing Schedules Based on Recoverability<br/><br/>17.5 Characterizing Schedules Based on Serializability<br/><br/>17.6 Transaction Support in SQL<br/><br/>17.7 Summary<br/><br/>Chapter 18 - Concurrency Control Techniques<br/><br/>18.1 Two-Phase Locking Techniques for Concurrency Control<br/><br/>18.2 Concurrency Control Based on Timestamp Ordering<br/><br/>18.3 Multiversion Concurrency Control Techniques<br/><br/>18.4 Validation (Optimistic) Concurrency Control Techniques<br/><br/>18.5 Granularity of Data Items and Multiple Granularity Locking<br/><br/>18.6 Using Locks for Concurrency Control in Indexes<br/><br/>18.7 Other Concurrency Control Issues<br/><br/>18.8 Summary<br/><br/>Chapter 19 - Database Recovery Techniques<br/><br/>19.1 Recovery Concepts<br/><br/>19.2 Recovery Techniques Based on Deferred Update<br/><br/>19.3 Recovery Techniques Based on Immediate Update<br/><br/>19.4 Shadow Paging<br/><br/>19.5 The ARIES Recovery Algorithm<br/><br/>19.6 Recovery in Multidatabase Systems<br/><br/>19.7 Database Backup and Recovery from Catastrophic Failures<br/><br/>19.8 Summary<br/><br/>Part 6 - Object and Object-Relational Databases<br/><br/>Chapter 20 - Concepts for Object Databases<br/><br/>20.1 Overview of Object-Oriented Concepts<br/><br/>20.2 Object Identity, Object Structure, and Type Constructors<br/><br/>20.3 Encapsulation of Operations, Methods, and Persistence<br/><br/>20.4 Type and Class Hierarchies and Inheritance<br/><br/>20.5 Complex Objects<br/><br/>20.6 Other Objected-Oriented Concepts<br/><br/>20.7 Summary<br/><br/>Chapter 21 Object Database Standards, Languages, and Design<br/><br/>21.1 Overview of the Object Model of ODMG<br/><br/>21.2 The Object Definition Language ODL<br/><br/>21.3 The Object Query Language OQL<br/><br/>21.4 Overview of the C++ Language Binding<br/><br/>21.5 Object Database Conceptual Design<br/><br/>21.6 Summary
505 #0 - FORMATTED CONTENTS NOTE
Formatted contents note Chapter 22 - Object-Relational and Extended-Relational Systems<br/><br/>22.1 Overview of SQL and Its Object-Relational Features<br/><br/>22.2 Evolution of Data Models and Current Trends of Database Technology<br/><br/>22.3 The Informix Universal Server<br/><br/>22.4 Object-Relational Features of Oracle 8<br/><br/>22.5 Implementation and Related Issues for Extended Type Systems<br/><br/>22.6 The Nested Relational Model<br/><br/>22.7 Summary<br/><br/>Part 7 - Further Topics: Security, Advanced Modeling, and Distribution<br/><br/>Chapter 23 - Database Security<br/><br/>23.1 Introduction to Database Security Issues<br/><br/>23.2 Discretionary Access Control Based on Granting and Revoking Privileges<br/><br/>23.3 Mandatory Access Control and Role-Based Access Control for Multilevel Security<br/><br/>23.4 Introduction to Statistical Database Security<br/><br/>23.5 Introduction to Flow Control<br/><br/>23.6 Encryption and Public Key Infrastructures<br/><br/>23.7 Privacy Issues and Preservation<br/><br/>23.8 Challenges of Database Security<br/><br/>23.9 Summary<br/><br/>Chapter 24 - Enhanced Data Models for Advanced Applications<br/><br/>24.1 Active Database Concepts and Triggers<br/><br/>24.2 Temporal Database Concepts<br/><br/>24.3 Spatial and Multimedia Databases<br/><br/>24.4 Introduction to Deductive Databases<br/><br/>24.5 Summary<br/><br/>Chapter 25 - Distributed Databases and Client-Server Architectures<br/><br/>25.1 Distributed Database Concepts<br/><br/>25.2 Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design<br/><br/>25.3 Types of Distributed Database Systems<br/><br/>25.4 Query Processing in Distributed Databases<br/><br/>25.5 Overview of Concurrency Control and Recovery in Distributed Databases<br/><br/>25.6 An Overview of 3-Tier Client-Server Architecture<br/><br/>25.7 Distributed Databases in Oracle<br/><br/>25.8 Summary<br/><br/>Part 8 - Emerging Technologies<br/><br/>Chapter 26 - Web Database Programming Using PHP<br/><br/>26.1 Structured, Semistructured, and Unstructured Data<br/><br/>26.2 A Simple PHP Example<br/><br/>26.3 Overview of Basic Features of PHP<br/><br/>26.4 Overview of PHP Database Programming<br/><br/>26.5 Summary<br/><br/>Chapter 27 - XML: Extensible Markup Language<br/><br/>27.1 XML Hierarchical (Tree) Data Model<br/><br/>27.2 XML Documents, DTD, and XML Schema<br/><br/>27.3 XML Documents and Databases<br/><br/>27.4 XML Querying<br/><br/>27.5 Summary<br/><br/>Chapter 28 - Data Mining Concepts<br/><br/>28.1 Overview of Data Mining Technology<br/><br/>28.2 Association Rules<br/><br/>28.3 Classification<br/><br/>28.4 Clustering<br/><br/>28.5 Approaches to Other Data Mining Problems<br/><br/>28.6 Applications of Data Mining<br/><br/>28.7 Commercial Data Mining Tools<br/><br/>28.8 Summary<br/><br/>Chapter 29 - Overview of Data Warehousing and OLAP<br/><br/>29.1 Introduction, Definitions, and Terminology<br/><br/>29.2 Characteristics of Data Warehouses<br/><br/>29.3 Data Modeling for Data Warehouses<br/><br/>29.4 Building a Data Warehouse<br/><br/>29.5 Typical Functionality of a Data Warehouse<br/><br/>29.6 Data Warehouse versus Views<br/><br/>29.7 Problems and Open Issues in Data Warehouses<br/><br/>29.8 Summary<br/><br/>Chapter 30 - Emerging Database Technologies and Applications<br/><br/>30.1 Mobile Databases<br/><br/>30.2 Multimedia Databases<br/><br/>30.3 Geographic Information Systems (GIS)<br/><br/>30.4 Genome Data Management<br/><br/>Appendix A Alternative Diagrammatic Notations for ER Models<br/><br/>Appendix B Parameters of Disks<br/><br/>Appendix C Overview of the QBE Language
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Database management.
9 (RLIN) 13197
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Navathe, Sham.
9 (RLIN) 13198
856 41 - ELECTRONIC LOCATION AND ACCESS
Materials specified Table of contents only
Uniform Resource Identifier <a href="http://www.loc.gov/catdir/toc/ecip067/2006002008.html">http://www.loc.gov/catdir/toc/ecip067/2006002008.html</a>
906 ## - LOCAL DATA ELEMENT F, LDF (RLIN)
a 7
b cbc
c orignew
d 1
e ecip
f 20
g y-gencatlg
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Dewey Decimal Classification
Koha item type Books
Holdings
Lost status Source of classification or shelving scheme Damaged status Not for loan Collection code Home library Current library Shelving location Date acquired Source of acquisition Inventory number Total Checkouts Full call number Barcode Date last seen Price effective from Koha item type Cost, normal purchase price Total Renewals Date checked out
  Dewey Decimal Classification       Main library Main library A2 01/01/2009 Academic bookshop DO   005.74 E.R.S 00007236 19/02/2025 11/11/2010 Books      
  Dewey Decimal Classification       Main library Main library A2 25/05/2008 Textbooks PU 2 005.74 E.R.S 00003364 19/02/2025 11/11/2010 Books 130.00 2 10/03/2024
  Dewey Decimal Classification       Main library Main library A2 17/11/2011 Textbooks DO   005.74 E.R.S 00005833 19/02/2025 17/11/2011 Books