Introduction To Database Systems. (Record no. 25683)
[ view plain ]
000 -LEADER | |
---|---|
fixed length control field | 06339nam a22003373i 4500 |
001 - CONTROL NUMBER | |
control field | EBC5127402 |
003 - CONTROL NUMBER IDENTIFIER | |
control field | MiAaPQ |
005 - DATE AND TIME OF LATEST TRANSACTION | |
control field | 20190110104403.0 |
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION | |
fixed length control field | m o d | |
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
fixed length control field | cr cnu|||||||| |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
fixed length control field | 181231s2010 xx o ||||0 eng d |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
International Standard Book Number | 9788131743195 |
Qualifying information | (electronic bk.) |
035 ## - SYSTEM CONTROL NUMBER | |
System control number | (MiAaPQ)EBC5127402 |
035 ## - SYSTEM CONTROL NUMBER | |
System control number | (Au-PeEL)EBL5127402 |
035 ## - SYSTEM CONTROL NUMBER | |
System control number | (CaONFJC)MIL265259 |
035 ## - SYSTEM CONTROL NUMBER | |
System control number | (OCoLC)732019174 |
040 ## - CATALOGING SOURCE | |
Original cataloging agency | MiAaPQ |
Language of cataloging | eng |
Description conventions | rda |
-- | pn |
Transcribing agency | MiAaPQ |
Modifying agency | MiAaPQ |
082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
Edition number | 23rd |
Classification number | 005.74 |
100 1# - MAIN ENTRY--PERSONAL NAME | |
Personal name | Limited, Itl Educatinon Solutions. |
245 10 - TITLE STATEMENT | |
Title | Introduction To Database Systems. |
300 ## - PHYSICAL DESCRIPTION | |
Extent | 1 online resource (593 pages) |
505 0# - FORMATTED CONTENTS NOTE | |
Formatted contents note | Cover -- Introduction to Database Systems -- Copyright -- Contents -- Preface -- Database System -- Need of Database System -- Advantages of Database System -- Developments in Database System -- Application Areas of Database System -- Cost and Risk of Database System -- People Who Interact with Databases -- DBMS Architecture and Data Independence -- Database Models -- Database Schema versus Database Instance -- DBMS Languages -- Component Modules of DBMS -- Centralized and Client/Server Database Systems -- Classification of DBMSs -- Database Design Process -- Summary -- Key Terms -- Exercises -- Conceptual Modeling -- Concepts of Entity-Relationship Model -- Entity-Relationship Diagram -- Enhanced E-R Model -- Alternative Notations for E-R Diagrams -- Unified Modeling Language -- Summary -- Key Terms -- Exercises -- The Relational Model -- Relational Model Concepts -- Relational Database Schema -- Relational Database Instance -- Keys -- Data Integrity -- Constraint Violation while Updating Data -- Mapping E-R Model to Relational Model -- Summary -- Key Terms -- Exercises -- Relational Algebra and Calculus -- Relational Algebra -- Relational Calculus -- Expressive Power of Relational Algebra and Relational Calculus -- Summary -- Key Terms -- Exercises -- Structured Query Language -- Basic Features of SQL -- Data Definition -- Data Manipulation Language -- Complex Queries in SQL -- Additional Features of SQL -- Accessing Databases from Applications -- Summary -- Key Terms -- Exercises -- Relational Database Design -- Features of Good Relational Design -- Decomposition -- Functional Dependencies -- Normal Forms -- Insufficiency of Normal Forms -- Comparison of BCNF and 3NF -- Higher Normal Forms -- Denormalization -- Summary -- Key Terms -- Exercises -- Data Storage and Indexing -- Hierarchy of Storage Devices. |
505 8# - FORMATTED CONTENTS NOTE | |
Formatted contents note | Redundant Arrays of Independent Disks -- New Storage Systems -- Accessing Data from Disk -- Placing File Records on Disk Blocks -- Organization of Records in Files -- Indexing -- Summary -- Key Terms -- Exercises -- Queryp Rocessing and Optimization -- Query Processing Steps -- External Sort-Merge Algorithm -- Algorithms for Relational Algebra Operations -- Expressions Containing Multiple Operations -- Query Optimization -- Query Optimization in Oracle -- Summary -- Key Terms -- Exercises -- Introduction to Transaction Processing -- Desirable Properties of a Transaction -- States of a Transaction -- Concurrent Execution of Transactions -- Transaction Schedules -- SQL Transaction Statements -- Summary -- Key Terms -- Exercises -- Concurrency Control Tenchniques -- Locking -- Lock-Based Techniques -- Specialized Locking Techniques -- Performance of Locking -- Timestamp-Based Technique -- Optimistic Technique -- Multiversion Technique -- Dealing with Deadlock -- Summary -- Key Terms -- Exercises -- Database Recovery System -- Types of Failures -- Caching of Disk Pages -- Recovery Related Steps During Normal Execution -- Recovery Techniques -- Recovery for Concurrent Transactions -- ARIES Recovery Algorithm -- Recovery from Catastrophic Failures -- Summary -- Key Terms -- Exercises -- Database Security -- Security Issues -- Role of DBA in Database Security -- Authorization -- Authentication -- Access Control -- Encryption -- Statistical Database -- Summary -- Key Terms -- Exercises -- Databasesy Stem Architectures -- Overview of Parallel DBMS -- Distributed DBMS -- Client/Server Systems -- Summary -- Key Terms -- Exercises -- Data Warehousing, Olap, and Data Mining -- Data Warehousing -- Online Analytical Processing -- Data Mining Technology -- Summary -- Key Terms -- Exercises -- Information Retrieval -- Information Retrieval Systems. |
505 8# - FORMATTED CONTENTS NOTE | |
Formatted contents note | Indexing of Text Documents -- Web Search Engines -- Summary -- Key Terms -- Exercises -- Object-Based Databases -- Need for Object-Based Databases -- Object Relational Database Systems -- Object-Oriented Database Management Systems -- OODBMS versus ORDBMS -- Summary -- Key Terms -- Exercises -- XML -- Structured, Semi-Structured, and Unstructured Data -- Overview of XML -- Structure of XML Data -- DTD and XML Schema -- Querying XML Data -- Approaches to Store XML Data -- Uses of XML -- Summary -- Key Terms -- Exercises -- Leading Database Systems -- Postgre SQL -- Oracle -- Microsoft SQL Server -- IBM DB2 Universal Database -- Summary -- Key Terms -- Exercises -- Hospital Management System -- Aim -- Description -- Tables Description -- E-R Diagram -- Relational Database Schema for Case Study -- Implementation in SQL Server -- Railway Reservation -- Aim -- Description -- List of Assumptions -- E-R Diagram -- Description of Tables and Procedures -- Relational Database Schema for Case Study -- Microsoft Access as Database Management System -- Components of Access -- Starting Access -- Working with Tables -- Working with Queries -- Working with Forms -- Working with Reports -- SQL Extensions for Data Analysis -- Extensions to GROUP bY Clause -- New Analytic Functions -- Top-N Queries -- Windowing in SQL:1999 -- Abbreviations, Acronyms, and Symbols -- E. F. Codd's Rules -- Glossary -- Index. |
590 ## - LOCAL NOTE (RLIN) | |
Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2018. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
655 #4 - INDEX TERM--GENRE/FORM | |
Genre/form data or focus term | Electronic books. |
776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
Display text | Print version: |
Main entry heading | Limited, Itl Educatinon Solutions |
Title | Introduction To Database Systems |
Place, publisher, and date of publication | Noida : Pearson India,c2010 |
797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
856 40 - ELECTRONIC LOCATION AND ACCESS | |
Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/cethalassery/detail.action?docID=5127402">https://ebookcentral.proquest.com/lib/cethalassery/detail.action?docID=5127402</a> |
Public note | Click to View |
942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
Source of classification or shelving scheme | Dewey Decimal Classification |
Koha item type | Books |
Withdrawn status | Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Total Checkouts | Full call number | Barcode | Date last seen | Price effective from | Koha item type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Dewey Decimal Classification | Online access | CENTRAL LIBRARY | Digital Library | Digital Library | 10/01/2019 | 005.74 INT | E0163 | 10/01/2019 | 10/01/2019 | E- Books |