Database systems / (Record no. 3481)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 05637fam a2200181 a 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9788131509708 (pb) |
| 040 ## - CATALOGING SOURCE | |
| Transcribing agency | CUS |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.74 |
| Item number | ROB/D |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Rob, Peter. |
| 245 10 - TITLE STATEMENT | |
| Title | Database systems / |
| Statement of responsibility, etc. | Peter Ro and, Carlos Coronel. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc. | New Delhi : |
| Name of publisher, distributor, etc. | Cengage Learning , |
| Date of publication, distribution, etc. | c2008. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 594 p. |
| Other physical details | ill. ; |
| Dimensions | 24 cm. |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes bibliographical references and index. |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | PARTI DATABASE CONCEPTS<br/>CHAPTER I DATABASE SYSTEMS<br/>1.1 Data vs. Information<br/>i .2 Introducing the Database and the DBMS<br/>1.3 Why Database Design Is Important<br/>1.4 Historical Roots: Files and File Systems<br/>1.5 Problems with File System Data Management<br/>1.6 Database Systems<br/>Review Questions<br/>Problems<br/>CHAPTER 2 DATA MODELS<br/>2.1 Data Modeling and Data Models<br/>2.2 The Importance of Data Models<br/>2.3 Data Model Basic Building Blocks<br/>2.4 Business Rules<br/>2.5 The Evolution of Data Models<br/>2.6 Degrees of Data Abstraction<br/>Review Questions<br/>Problems<br/>PART II DESIGN CONCEPTS<br/>CHAPTER 3 THE RELATIONAL DATABASE MODEL<br/>3.1 A Logical View of Data<br/>3.2 Keys<br/>3.3 Integrity Rules<br/>3.4 Relational Set Operators<br/>3.5 The Data Dictionary and the System Catalog<br/>3.6 Relationships within the Relational Database<br/>3.7 Data Redundancy Revisited<br/>3.8 Indexes<br/>3.9 Codd's Relational Database Rules<br/>Review Questions<br/>Problems ' '<br/>CHAPTER 4 ENTITY RELATIONSHIP (ER) MODELING<br/>4.1 The Entity Relationship Model (ERM)<br/>4.2 Developing an ER Diagram )<br/>4.3 Database Design Challenges: Conflicting Goals<br/>Review Questions " -C' i<br/>Problems r . sfn! :i<br/>CHAPTER 5 NORMALIZATION OF DATABASE TABLES<br/>5.1 Database Tables and Normalization<br/>5.2 The Need for Normalization<br/>5.3 The Normalization Process<br/>5.4 Improving the Design<br/>5.5 Surrogate Key Considerations<br/>5.6 Higher-Level Normal Forms<br/>5.7 Normalization and Database Design<br/>5.8 Denormalization<br/><br/><br/><br/><br/>Review Questions '<br/>Problems <br/>CHAPTER 6 ADVANCED DATA MODELING The Extended Entity Relationship Model A<br/>6.2 Entity Clustering<br/>6.3 Entity Integrity: Selecting Primary Keys<br/>6.4 Design Cases: Learning Flexible Database Design<br/>6.5 Data Modeling Checklist<br/>Review Questions<br/>Problems<br/>PART III ADVANCED DESIGN AND IMPLEMENTATION<br/>CHAPTER 7 introduction TO STRUCTURED QUERY LANGUAGE (SQL)<br/>7.1 Introduction to SQL<br/>7.2 Data Definition Commands<br/>7.3 Data Manipulation Commands<br/><br/><br/>7.4 SELECT Queries<br/>7.5 Advanced Data Definition Commands<br/>7.6 Advanced SELECT Queries<br/>7.7 Virtual Tables: Creating a View<br/>7.8 Joining Database Tables '<br/>Review Questions<br/>Problems<br/>CHAPTER 8 ADVANCED SQL<br/>&;l Relational Set Operators ^ .<br/>8.2 SQL Join Operators<br/>8.3 Subqueries and Correlated Queries<br/>8.4 SQL Functions<br/>8.5 Oracle Sequences<br/>8.6 Updatable Views<br/>8.7 Procedural SQL<br/>8.8 Embedded SQL<br/>Review Questions<br/>Problems ■<br/>CHAPTER 9 DATABASE DESIGN<br/>9.1 The Information System , . .<br/>9.2 The Systems Development Life Cycle (SDLC)<br/>9.3 The Database Life Cycle (DBLC)<br/>9.4 Database Design Strategies<br/>9.5 Centralized vs. Decentralized Design<br/>Review Questions<br/>Problems<br/>PART IV ADVANCED DATABASE CONCEPTS<br/>CHAPTER 10 TRANSACTION MANAGEMENT<br/>AND CONCURRENCY CONTROL<br/>10.1 What Is a Transaction?<br/>10.2 Concurrency Control<br/>10.3 Concurrency Control with Locking Methods<br/>10.4 Concurrency Control with Time Stamping Methods<br/>10.5 Concurrency Control with Optimistic Methods<br/>10.6 Database Recovery Management -<br/>Review Questions ^ by<br/>Problems 11 - r o -. -A<br/>CHAPTER II DATABASE PERFORMANCE TUNING AND .<br/>.<br/><br/>QUERY OPTIMIZATION . ^Database Performance-Tuning Concepts ^<br/>1.2 Query Processing<br/>1.3 Indexes and Query Optimization<br/>1.4 Optimizer Choices <br/>1.5 SQL Performance Tuning <br/>1.6 Query Formulation<br/>1.7 DBMS Performance Tuning <br/>1.8 Query Optimization Example p^- '.<br/>Review Questions ' <br/>Problems T) <br/>CHAPTER 12 DISTRIBUTED DATABASE MANAGEMENT SYSTEMS<br/>12.1 The Evolution of Distributed Database Management Systems<br/>12.2 DDBMS Advantages and Disadvantages<br/>12.3 Distributed Processing and Distributed Databases<br/>12.4 Characteristics of Distributed Database Management Systems <br/>12.5 DDBMS Components '<br/>12.6 Levels of Data and Process Distribution t .<br/>12.7 Distributed Database Transparency Features <br/>12.8 Distribution Transparency <br/>12.9 Transaction Transparency<br/>12.10 Performance Transparency and Query Optimization<br/>12.1 I Distributed Database Design<br/>12.12 Client/Server vs. DDBMS<br/>12.13 C. J. Date's Twelve Commandments for Distributed Databases "<br/>Review Questions<br/>Problems<br/>CHAPTER 13 BUSINESS INTELLIGENCE AND DATA WAREHOUSES<br/>13.1 The Need for Data Analysis<br/>13.2 Business Intelligence<br/>13.3 Business Intelligence Architecture<br/>13.4 Decision Support Data<br/>13.5 The Data Warehouse<br/>13.6 Online Analytical Processing<br/>13.7 Star Schemas<br/>13.8 Implementing a Data Warehouse<br/>13.9 Data Mining<br/>13.10 SQL Extensions For CLAP<br/>Review Questions<br/>Problems<br/>PART V DATABASES AND THE INTERNET<br/>CHAPTER 14 DATABASE CONNECTIVITY AND WEB TECHNOLOGIES<br/>14.1 Database Connectivity<br/>14.2 Internet Databases<br/>14.3 Extensible Markup Language (XML)<br/>Review Questions<br/>Problems ,<br/>FART VI DATAgASE ADMINISTRATION<br/>CHAPTER 15 DATABASE ADMINISTRATION AND SECURITY<br/>15.1 Data as a Corporate Asset<br/>15.2 The Need for and Role of a Database in an Organization<br/>15.3 Introduction of a Database: Special Considerations<br/>15.4 The Evolution of the Database Administration Function<br/>15.5 The Database Environment's Human Component<br/>15.6 Security<br/>15.7 Database Administration Ibols<br/>15.8 Developing a Data Administration Strategy<br/>15.9 The DBA at Work: Using Oracle for Database Administration<br/>Review Questions<br/>Index |
| 650 #0 - SUBJECT | |
| Keyword | Database Design. |
| 650 #0 - SUBJECT | |
| Keyword | Database Management. |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | GN Books |
| Withdrawn status | Lost status | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Full call number | Accession number | Date last seen | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Central Library, Sikkim University | Central Library, Sikkim University | General Book Section | 23/06/2016 | 005.74 ROB/D | P21232 | 23/06/2016 | General Books |