Welcome to UE Central Library

Keep Smiling

An introduction to database systems (Record no. 11270)

MARC details
000 -LEADER
fixed length control field 05943cam a22002174a 4500
001 - CONTROL NUMBER
control field 13216768
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20200828112324.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 030529s2004 maua b 001 0 eng
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 0321197844
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9788177585568
040 ## - CATALOGING SOURCE
Transcribing agency DLC
082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.74
Edition number 21
Item number D2329
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Date, C. J.
245 13 - TITLE STATEMENT
Title An introduction to database systems
Statement of responsibility, etc / C.J. Date, A. Kannan, S. Swamynathan
250 ## - EDITION STATEMENT
Edition statement 8th ed.
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication, distribution, etc New Delhi :
Name of publisher, distributor, etc Pearson/Addison Wesley,
Date of publication, distribution, etc 2013
300 ## - PHYSICAL DESCRIPTION
Extent xxxii, 931 p.
Other physical details ill. ;
Dimensions 24 cm.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Database management.
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Koha item type Books
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note (All chapters begin with an Introduction end with a Summary, Exercises, and Reference and Bibliography)I. PRELIMINARIES. 1. An Overview of Database Management. What is a database system?What is a database?Why database?Data independence.Relational systems and others.2. Database System Architecture. The three levels of the architecture.The external level.The conceptual level.The internal level.Mappings.The database administrator.The database management system.Data communications.Client/server architecture.Utilities.Distributed processing.3. An Introduction to Relational Databases. An informal look at the relational model.Relations and relvars.What relations mean.Optimization.The catalog.Base relvars and views.Transactions.The suppliers-and-parts database.4. An Introduction to SQL. Overview.The catalog.Views.Transactions.Embedded SQL.Dynamic SQL and SQL/CLI.SQL is not perfect.II. THE RELATIONAL MODEL. 5. Types. Values v Variables.Types v Representations.Type Definition.Operators.Type generators.SQL facilities.6. Relations. Tuples.Relation types.Relation values.Relation variables.SQL facilities.7. Relational Algebra. Closure revisited.The original algebra: Syntax.The original algebra: Semantics.Examples.What is the algebra for?Further points.Additional operators.Grouping and ungrouping.8. Relational Calculus. Tuple calculus.Examples.Calculus vs. algebra.Computational capabilities.SQL facilities.Domain calculus.Query-By-Example.9. Integrity. A closer look.Predicates and propositions.Relvar predicates and database predicates.Checking the constraints.Internal v external constraints.Correctness v consistency.Integrity and views.A constraint classification scheme.Keys.Triggers (a digression).SQL facilities.10. Views. What are views for?View retrievals.View updates.Snapshots (a digression).SQL facilities.III. DATABASE DESIGN. 11. Functional Dependencies. Basic definitions.Trivial and nontrivial dependencies.Closure of a set of dependencies.Closure of a set of attributes.Irreducible sets of dependencies.12. Further Normalization I: 1NF, 2NF, 3NF, BCNF. Nonloss decomposition and functional dependencies.First, second, and third normal forms.Dependency preservation.Boyce/Codd normal form.A note on relation-valued attributes.13. Further Normalization II: Higher Normal Forms. Multi-valued dependencies and fourth normal form.Join dependencies and fifth normal form.The normalization procedure summarized.A note on denormalization.Orthogonal design (a digression).Other normal forms.14. Semantic Modeling. The overall approach.The E/R model.E/R diagrams.Database design with the E/R model.A brief analysis.IV. TRANSACTION MANAGEMENT. 15. Recovery. Transactions.Transaction recovery.System recovery.Media recovery.Two-phase commit.Savepoints (a digression).SQL facilities.16. Concurrency. Three concurrency problems.Locking.The three concurrency problems revisited.Deadlock.Serializability.Recovery revisited.Isolation levels.Intent locking.ACID dropping.SQL facilities.V. FURTHER TOPICS. 17. Security. Discretionary access control.Mandatory access control.Statistical databases.Data encryption.SQL facilities.18. Optimization. A motivating example.An overview of query processing.Expression transformation.Database statistics.A divide-and-conquer strategy.Implementing the relational operators.19. Missing Information. An overview of the 3VL approach.Some consequences of the foregoing scheme.Nulls and keys.Outer join (a digression).Special values.SQL facilities.20. Type Inheritance. Type hierarchies.Polymorphism and substitutability.Variables and assignments.Specialization by constraint.Comparisons.Operators, versions, and signatures.Is a circle an ellipse?Specialization by constraint revisited.SQL facilities.21. Distributed Databases. Some preliminaries.The twelve objectives.Problems of distributed systems.Client/server systems.DBMS independence.SQL facilities.22. Decision Support. Aspects of decision support.Database design for decision support.Data preparation.Data warehouses and data marts.Online analytical processing.Data mining.SQL facilities.23. Temporal Databases. What is the problem?Intervals.Packing and unpacking relations.Generalizing the relational operators.Database work design.Integrity constraints.24. Logic-Based Databases. Overview.Propositional calculus.Predicate calculus.A proof-theoretic view of databases.Deductive database systems.Recursive query processing.VI. OBJECTS, RELATIONS, AND XML. 25. Object Databases. Objects, classes, methods, and messages.A closer look.A cradle-to-grave example.Miscellaneous issues.26. Object / Relational Databases. The First Great Blunder.The Second Great Blunder.Implementation issues.Benefits of true rapprochement.SQL facilities.27. The World Wide Web and XML. The Web and the Internet.An overview of XML.XML data definition.XML data manipulation.XML and databases.SQL facilities.APPENDIXES. Appendix A: The TransRelational (TM) Model. Three levels of abstraction.The basic idea.Condensed columns.Merged columns.Implementing the relational operators.Appendix B: SQL Expressions, Table Expressions, and Boolean Expressions. Appendix C: Abbreviations, Acronyms, and Symbol. Appendix D: Online storage structures and access methods, database access: an overview, page sets and files, indexing, hashing, pointer chains, and compression techniques. Index.
Holdings
Withdrawn status Damaged status Not for loan Home library Current library Date acquired Source of acquisition Full call number Barcode Date last seen Price effective from Koha item type
      UE-Central Library UE-Central Library 22.10.2018 U.E.25200 005.74 D2329 T10216 22.10.2018 22.10.2018 Books
      UE-Central Library UE-Central Library 22.10.2018 U.E.25201 005.74 D2329 T10217 22.10.2018 22.10.2018 Books
      UE-Central Library UE-Central Library 22.10.2018 U.E. 005.74 D2329 T1915 22.10.2018 22.10.2018 Books
      UE-Central Library UE-Central Library 22.10.2018 U.E.25203 005.74 D2329 T10219 22.10.2018 22.10.2018 Books
      UE-Central Library UE-Central Library 22.10.2018 U.E.25202 005.74 D2329 T10218 22.10.2018 22.10.2018 Books
      UE-Central Library UE-Central Library 13.11.2018 U.E.23784 005.74 D2329 T9454 13.11.2018 13.11.2018 Books
      UE-Central Library UE-Central Library 13.11.2018 U.E.25199 005.74 D2329 T10215 23.09.2022 13.11.2018 Books
Copyright © 2023, University of Education, Lahore. All Rights Reserved.
Email:centrallibrary@ue.edu.pk