Cargando…

Database systems : a pragmatic approach /

Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been teste...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Foster, Elvis C. (Autor), Godbole, Shripad (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley, CA] : Apress, 2014.
Colección:Expert's voice in database.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000Ii 4500
001 OR_ocn899211342
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu|||unuuu
008 150105s2014 cau ob 001 0 eng d
040 |a N$T  |b eng  |e rda  |e pn  |c N$T  |d GW5XE  |d N$T  |d YDXCP  |d CDX  |d UPM  |d COO  |d UMI  |d E7B  |d OCLCF  |d IDEBK  |d DEBBG  |d EBLCP  |d B24X7  |d OCLCQ  |d Z5A  |d LIV  |d OCLCQ  |d MERUC  |d ESU  |d VT2  |d IOG  |d REB  |d OCLCO  |d VLB  |d UUM  |d CEF  |d DEHBZ  |d OCLCQ  |d U3W  |d OCLCQ  |d WYU  |d YOU  |d OCLCQ  |d UAB  |d UKAHL  |d OCLCQ  |d DCT  |d ERF  |d UHL  |d OCLCQ  |d WURST  |d VLY  |d BRF  |d OCLCO  |d OCLCQ  |d OCLCO 
019 |a 900882994  |a 1005837206  |a 1026464914  |a 1048135783  |a 1066454844  |a 1066621849  |a 1086554250  |a 1110760804  |a 1112573852  |a 1113801447  |a 1129375671  |a 1153025553  |a 1162344149  |a 1192338760  |a 1203995225  |a 1240518434 
020 |a 9781484208779  |q (electronic bk.) 
020 |a 1484208773  |q (electronic bk.) 
020 |a 1484208781  |q (print) 
020 |a 9781484208786  |q (print) 
020 |z 9781484208786 
024 7 |a 10.1007/978-1-4842-0877-9  |2 doi 
029 1 |a AU@  |b 000056059424 
029 1 |a CHNEW  |b 000890484 
029 1 |a CHVBK  |b 374492018 
029 1 |a DEBBG  |b BV042490983 
029 1 |a DEBBG  |b BV043617674 
029 1 |a DEBSZ  |b 434841609 
029 1 |a GBVCP  |b 882845055 
029 1 |a NLGGC  |b 387315195 
029 1 |a AU@  |b 000067092271 
035 |a (OCoLC)899211342  |z (OCoLC)900882994  |z (OCoLC)1005837206  |z (OCoLC)1026464914  |z (OCoLC)1048135783  |z (OCoLC)1066454844  |z (OCoLC)1066621849  |z (OCoLC)1086554250  |z (OCoLC)1110760804  |z (OCoLC)1112573852  |z (OCoLC)1113801447  |z (OCoLC)1129375671  |z (OCoLC)1153025553  |z (OCoLC)1162344149  |z (OCoLC)1192338760  |z (OCoLC)1203995225  |z (OCoLC)1240518434 
037 |a CL0500000540  |b Safari Books Online 
050 4 |a QA76.9.D26 
072 7 |a COM  |x 013000  |2 bisacsh 
072 7 |a COM  |x 014000  |2 bisacsh 
072 7 |a COM  |x 018000  |2 bisacsh 
072 7 |a COM  |x 067000  |2 bisacsh 
072 7 |a COM  |x 032000  |2 bisacsh 
072 7 |a COM  |x 037000  |2 bisacsh 
072 7 |a COM  |x 052000  |2 bisacsh 
072 7 |a UY  |2 bicssc 
082 0 4 |a 004.2/1  |2 23 
049 |a UAMI 
100 1 |a Foster, Elvis C.,  |e author. 
245 1 0 |a Database systems :  |b a pragmatic approach /  |c Elvis C. Foster, Shripad V. Godbole. 
264 1 |a [Berkeley, CA] :  |b Apress,  |c 2014. 
264 2 |a New York, NY :  |b Distributed to the Book trade worldwide by Springer 
264 4 |c ©2014 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |b PDF  |2 rda 
490 1 |a The expert's voice in database 
504 |a Includes bibliographical references and index. 
588 0 |a Online resource; title from PDF title page (SpringerLink, viewed January 6, 2015). 
520 |a Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success. Upholding his aim for brevity, comprehensive coverage, and relevance, author Elvis C. Foster's practical and methodical discussion style gets straight to the salient issues, and avoids unnecessary fluff as well as an overkill of theoretical calculations. The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Foster's original methodologies that add clarity and creativity to the database modeling and design experience while making a novel contribution to the discipline. Everything combines to make Database Systems: A Pragmatic Approach an excellent textbook for students, and an excellent resource on theory for the practitioner. 
505 0 |a At a Glance -- Contents -- About the Authors -- Preface -- Acknowledgments -- Part1: Preliminary Topics -- Chapter 1: Introduction to Database Systems -- 1.1 Definitions and Rationale -- 1.2 Objectives of a Database System -- Clarification on Data Independence -- 1.3 Advantages of a Database System -- 1.4 Approaches to Database Design -- 1.5 Desirable Features of a DBS -- 1.6 Database Development Life Cycle -- 1.7 Summary and Concluding Remarks -- 1.8 Review Questions -- 1.9 References and/or Recommended Readings -- Chapter 2: The Database System Environment -- 2.1 Levels of Architecture -- 2.1.1 External Level -- 2.1.2 Conceptual Level -- 2.1.3 Internal Level -- 2.2 Inter-level Mappings -- 2.3 The Database Administrator -- 2.4 The Database Management System -- 2.5 Components of DBMS Suite -- 2.5.1 The DBMS Engine -- 2.5.2 Definition Tools Subsystem -- 2.5.3 The User Interface Subsystem -- 2.5.4 Application Development Subsystem -- 2.5.5 Data Administration Subsystem -- 2.5.6 Data Dictionary Subsystem -- 2.5.7 Data Communications Manager -- 2.5.8 Utilities Subsystem -- 2.6 The Front-end and Back-end Perspectives -- 2.7 Database System Architecture -- 2.8 Summary and Concluding Remarks -- 2.9 Review Questions -- 2.10 References and/or Recommended Readings -- Part2: The Relational Database Model -- Chapter 3: The Relational Model -- 3.1 Basic Concepts -- 3.2 Domains -- Significance of Domains -- 3.3 Relations -- 3.3.1 Properties of a Relation -- 3.3.2 Kinds of Relations -- 3.4 Relational Database System -- Steps in Building a Relational Database System -- 3.5 Identifying, Representing, and Implementing Relationships -- 3.5.1 Identifying Relationships -- 3.5.2 Representing Relationships -- The Entity-Relationship Model -- The Object-Relationship Model -- Database Tree -- Database Networks -- 3.5.3 Multiplicity of Relationships. 
505 8 |a 3.5.4 Implementing Relationships -- 3.6 The Relation-Attributes List and Relationship List -- 3.7 Non-Relational Approaches -- 3.8 Summary and Concluding Remarks -- 3.9 Review Questions -- 3.10 References and/or Recommended Readings -- Chapter 4: Integrity Rules and Normalization -- 4.1 Fundamental Integrity Rules -- 4.2 Foreign Key Concept -- Deletion of Referenced Tuples -- 4.3 Rationale for Normalization -- 4.4 Functional Dependence and Non-loss Decomposition -- 4.4.1 Functional Dependence -- 4.4.2 Non-loss Decomposition -- Corollary of Heath's Theorem -- Conclusion -- 4.5 The First Normal Form -- Problems with Relations in 1NF Only -- 4.6 The Second Normal Form -- Problems with Relations in 2NF Only -- 4.7 The Third Normal Form -- Problems with Relations in 3NF Only -- 4.8 The Boyce-Codd Normal Form -- 4.9 The Fourth Normal Form -- 4.9.1 Multi-valued Dependency -- 4.9.2 Fagin's Theorem -- 4.10 The Fifth Normal Form -- 4.10.2 Fagin's Theorem -- 4.11 Other Normal Forms -- 4.11.1 The Domain-Key Normal Form -- 4.11.2 The Sixth Normal Form -- 4.12 Summary and Concluding Remarks -- 4.13 Review Questions -- 4.14 References and/or Recommended Readings -- Chapter 5: Database Modeling and Design -- 5.1 Database Model and Database Design -- 5.1.1 Database Model -- 5.1.2 Database Design -- 5.2 The E-R Model Revisited -- 5.3 Database Design via the E-R Model -- 5.4 The Extended Relational Model -- 5.4.1 Entity Classifications -- 5.4.2 Surrogates -- 5.4.3 E-Relations and P-Relations -- 5.4.4 Integrity Rules -- 5.5 Database Design via the XR Model -- 5.5.1 Determining the Kernel Entities -- 5.5.2 Determining the Characteristic Entities -- 5.5.3 Determining the Designative Entities -- 5.5.4 Determining the Associations -- 5.5.5 Determining Entity Subtypes and Super-types -- 5.5.6 Determining Component Entities -- 5.5.7 Determining the Properties. 
505 8 |a 5.6 The UML Model -- 5.7 Database Design via the UML Model -- 5.8 Innovation: The Object/Entity Specification Grid -- 5.9 Database Design via Normalization Theory -- 5.9.1 Example: Mountaineering Problem -- 5.9.2 Determining Candidate Keys and then Normalizing -- 5.10 Database Model and Design Tools -- 5.11 Summary and Concluding Remarks -- 5.12 Review Questions -- 5.13 References and/or Recommended Readings -- Chapter 6: Database User Interface Design -- 6.1 Introduction -- 6.2 Deciding on User Interface -- 6.3 Steps in User Interface Design -- 6.3.1 Menu or Graphical User Interface -- 6.3.2 Command-Based User Interface -- 6.4 User Interface Development and Implementation -- 6.5 Summary and Concluding Remarks -- 6.6 Review Questions -- 6.7 References and/or Recommend Readings -- Chapter 7: Relational Algebra -- 7.1 Introduction -- 7.2 Basic Operations of Relational Algebra -- 7.2.1 Primary and Secondary Operations -- 7.2.2 Codd's Original Classification of Operations -- 7.2.3 Nested Operations -- 7.3 Syntax of Relational Algebra -- 7.3.1 Select Statement -- 7.3.2 Projection Statement -- 7.3.3 Natural Join Statement -- 7.3.4 Cartesian Product -- 7.3.5 Theta-Join -- 7.3.6 Union, Intersection, Difference Statements -- 7.3.7 Division Statement -- 7.4 Aliases, Renaming and the Relational Assignment -- 7.4.1 The Alias Operation -- 7.4.2 The Assignment Operation -- 7.4.3 The Rename Operation -- 7.5 Other Operators -- 7.6 Summary and Concluding Remarks -- 7.7 Review Questions -- 7.8 References and/or Recommended Readings -- Chapter 8: Relational Calculus -- 8.1 Introduction -- 8.2 Calculus Notations and Illustrations -- 8.3 Quantifiers, Free and Bound Variables -- 8.3.1 Well-Formed Formula -- 8.3.2 Free and Bound Variables -- 8.4 Substitution Rule and Standardization Rules -- 8.5 Query Optimization -- 8.6 Domain Oriented Relational Calculus. 
505 8 |a 8.7 Summary and Concluding Remarks -- 8.8 Review Questions -- 8.9 References and/or Recommended Readings -- Chapter 9: Relational System -- a Closer Look -- 9.1 The Relational Model Summarized -- 9.2 Ramifications of the Relational Model -- 9.2.1 Codd's Early Benchmark -- 9.2.2 Revised Definition of a Relational System -- Date's Zero-Rule -- Codd's Twelve Rules -- 9.2.3 Far Reaching Consequences -- 9.3 Summary and Concluding Remarks -- 9.4 Review Questions -- 9.5 References -- Part3: The Structured Query Language -- Chapter 10: Overview of SQL -- 10.1 Important Facts -- 10.1.1 Commonly Used DDL Statements -- 10.1.2 Commonly Used DML and DCL Statements -- 10.1.3 Syntax Convention -- 10.2 Advantages of SQL -- 10.3 Summary and Concluding Remarks -- 10.4 Review Questions -- 10.5 Recommended Readings -- Chapter 11: SQL Data Definition Statements -- 11.1 Overview of Oracle's SQL Environment -- 11.2 Database Creation -- 11.3 Database Management -- 11.4 Tablespace Creation -- 11.5 Tablespace Management -- 11.6 Table Creation Statement -- 11.7 Dropping or Modifying a Table -- 11.8 Working with Indexes -- 11.9 Creating and Managing Sequences -- 11.10 Altering and Dropping Sequences -- 11.11 Creating and Managing Synonyms -- 11.12 Summary and Concluding Remarks -- 11.13 Review Questions -- 11.14 References and/or Recommended Readings -- Chapter 12: SQL Data Manipulation Statements -- 12.1 Insertion of Data -- 12.2 Update Operations -- 12.3 Deletion of Data -- 12.4 Commit and Rollback Operations -- 12.5 Basic Syntax for Queries -- 12.6 Simple Queries -- 12.7 Queries Involving Multiple Tables -- 12.7.1 The Traditional Method -- 12.7.2 The ANSI Method -- 12.8 Queries Involving the use of Functions -- 12.8.1 Row Functions -- 12.8.2 Date Functions -- 12.8.3 Data Conversion Functions -- 12.8.4 Programmer-Defined Functions -- 12.8.5 Aggregation Functions. 
505 8 |a 12.9 Queries Using LIKE, BETWEEN and IN Operators -- 12.10 Nested Queries -- 12.11 Queries Involving Set Operators -- 12.12 Queries with Runtime Variables -- 12.13 Queries Involving SQL Plus Format Commands -- 12.14 Embedded SQL -- 12.15 Dynamic Queries -- 12.16 Summary and Concluding Remarks -- 12.17 Review Questions -- 12.18 References and/or Recommended Readings -- Chapter 13: SQL Views and System Security -- 13.1 Traditional Logical Views -- 13.1.1 View Creation -- 13.1.2 View Modification and Removal -- 13.1.3 Usefulness and Manipulation of Logical Views -- 13.2 System Security -- 13.2.1 Access to the System -- 13.2.2 Access to the System Resources -- Development Privileges -- Roles -- 13.2.3 Access to the System Data -- Security via Object Privileges -- Security via Views -- Security via Database Design -- 13.3 Materialized Views -- 13.3.1 Creating a Materialized View -- 13.3.2 Altering or Dropping a Materialized View -- 13.4 Summary and Concluding Remarks -- 13.5 Review Questions -- 13.6 References and/or Recommended Readings -- Chapter 14: The System Catalog -- 14.1 Introduction -- 14.2 Three Important Catalog Tables -- 14.2.1 The User_Tables View -- 14.2.2 The User_Tab_Columns View -- 14.2.3 The User_Indexes View -- 14.3 Other Important Catalog Tables -- 14.4 Querying the System Catalog -- 14.5 Updating the System Catalog -- 14.6 Summary and Concluding Remarks -- 14.7 Review Questions -- 14.8 References and/or Recommended Readings -- Chapter 15: Some Limitations of SQL -- 15.1 Programming Limitations -- 15.2 Limitations on Views -- 15.2.1 Restriction on use of the Order-By-Clause -- 15.2.2 Restriction on Data Manipulation for Views involving UNION, INTERSECT or JOIN -- 15.3 Foreign Key Constraint Specification -- 15.4 Superfluous Enforcement of Referential Integrity -- 15.5 Limitations on Calculated Columns -- 15.6 If-Then Limitation. 
546 |a English. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a Database design. 
650 0 |a Database management. 
650 6 |a Bases de données  |x Conception. 
650 6 |a Bases de données  |x Gestion. 
650 7 |a COMPUTERS  |x Computer Literacy.  |2 bisacsh 
650 7 |a COMPUTERS  |x Computer Science.  |2 bisacsh 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a COMPUTERS  |x Hardware  |x General.  |2 bisacsh 
650 7 |a COMPUTERS  |x Information Technology.  |2 bisacsh 
650 7 |a COMPUTERS  |x Machine Theory.  |2 bisacsh 
650 7 |a COMPUTERS  |x Reference.  |2 bisacsh 
650 7 |a Database design  |2 fast 
650 7 |a Database management  |2 fast 
653 0 0 |a computerwetenschappen 
653 0 0 |a computer sciences 
653 0 0 |a databasebeheer 
653 0 0 |a database management 
653 1 0 |a Information and Communication Technology (General) 
653 1 0 |a Informatie- en communicatietechnologie (algemeen) 
700 1 |a Godbole, Shripad,  |e author. 
773 0 |t Springer eBooks 
776 0 8 |i Print version:  |a Foster, Elvis.  |t Database systems  |z 9781484208786  |w (OCoLC)894301524 
830 0 |a Expert's voice in database. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484208779/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a Askews and Holts Library Services  |b ASKH  |n AH29648489 
938 |a Books 24x7  |b B247  |n bks00078479 
938 |a Coutts Information Services  |b COUT  |n 29972827 
938 |a EBL - Ebook Library  |b EBLB  |n EBL1964865 
938 |a ebrary  |b EBRY  |n ebr11003478 
938 |a EBSCOhost  |b EBSC  |n 933677 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis36942781 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis30422265 
938 |a YBP Library Services  |b YANK  |n 12230758 
994 |a 92  |b IZTAP