Database Systems: A Practical Approach to Design, Implementation, and Management

Description: Database Systems: A Practical Approach to Design, Implementation, and Management by Thomas Connolly, Carolyn Begg This text includes material on distributed databases, object-oriented databases, data mining, data warehouses, multimedia databases and the Internet and provides a strong foundation in good design practice. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description KEY MESSAGE: This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases-conceptual, logical, and physical database design. KEY TOPICS: Background: Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database System Lifecycle; Database Analysis and the DreamHome Case Study; Entity--Relationship Modeling; Enhanced Entity--Relationship Modeling; Normalization; Advanced Normalization. Methodology: Methodology-Conceptual Database Design; Methodology-Logical Database Design for Relational Model; Methodology-Physical Database Design for Relational Databases; Methodology-Monitoring and Tuning the Operational System. Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication: Distributed DBMSs-Concepts and Design; Distributed DBMSs-Advanced Concepts; Replication and Mobile Databases. Object DBMSs: Object-Oriented DBMSs-Concepts and Design; Object-Oriented DBMSs-Standards and Languages; Object-Relational DBMSs. Web and DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices: Users Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho-A Liteweight RDBMS. Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational?; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts. MARKET: This book is ideal for readers interested in database management or database design. Author Biography Thomas M. Connolly is the head of the Computing and Information Systems division at the University of Paisley. Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine. Table of Contents Table of Contents Part 1 Background Chapter 1 Introduction to Databases 1.1 Introduction 1.2 Traditional File-Based Systems 1.2.1 File-Based Approach 1.2.2 Limitations of the File-Based Approach 1.3 Database Approach 1.3.1 The Database 1.3.2 The Database Management System (DBMS) 1.3.3 (Database) Application Programs 1.3.4 Components of the DBMS Environment 1.3.5 Database Design: The Paradigm Shift 1.4 Roles in the Database Environment 1.4.1 Data and Database Administrators 1.4.2 Database Designers 1.4.3 Application Developers 1.4.4 End-Users 1.5 History of Database Management Systems 1.6 Advantages and Disadvantages of DBMSs Chapter Summary Review Questions Exercises Chapter 2 Database Environment 2.1 The Three-Level ANSI-SPARC Architecture 2.1.1 External Level 2.1.2 Conceptual Level 2.1.3 Internal Level 2.1.4 Schemas, Mappings, and Instances 2.1.5 Data Independence 2.2 Database Languages 2.2.1 The Data Definition Language (DDL) 2.2.2 The Data Manipulation Language (DML) 2.2.3 Fourth-Generation Languages (4GLs) 2.3 Data Models and Conceptual Modeling 2.3.1 Object-Based Data Models 2.3.2 Record-Based Data Models 2.3.3 Physical Data Models 2.3.4 Conceptual Modeling 2.4 Functions of a DBMS Chapter Summary Review Questions Exercises Chapter 3 Database Architectures and the Web 3.1 Multi-user DBMS Architectures 3.1.1 Teleprocessing 3.1.2 File-Server Architecture 3.1.3 Traditional Two-Tier Client--Server Architecture 3.1.4 Three-Tier Client--Server Architecture 3.1.5 N-Tier Architectures 3.1.6 Middleware 3.1.7 Transaction Processing Monitors 3.2 Web Services and Service-Oriented Architectures 3.2.1 Web Services 3.2.2 Service-Oriented Architectures (SOA) 3.3 Distributed DBMSs 3.4 Data Warehousing 3.5 Cloud Computing 3.5.1 Benefits and Risks of Cloud Computing 3.5.2 Cloud-based database solutions 3.6 Components of a DBMS 3.7 Oracle Architecture 3.7.1 Oracles Logical Database Structure 3.7.2 Oracles Physical Database Structure Chapter Summary Review Questions Exercises Part 2 The Relational Model and Languages Chapter 4 The Relational Model 4.1 Brief History of the Relational Model 4.2 Terminology 4.2.1 Relational Data Structure 4.2.2 Mathematical Relations 4.2.3 Database Relations 4.2.4 Properties of Relations 4.2.5 Relational Keys 4.2.6 Representing Relational Database Schemas 4.3 Integrity Constraints 4.3.1 Nulls 4.3.2 Entity Integrity 4.3.3 Referential Integrity 4.3.4 General Constraints 4.4 Views 4.4.1 Terminology 4.4.2 Purpose of Views 4.4.3 Updating Views Chapter Summary Review Questions Exercises Chapter 5 Relational Algebra and Relational Calculus 5.1 The Relational Algebra 5.1.1 Unary Operations 5.1.2 Set Operations 5.1.3 Join Operations 5.1.4 Division Operation 5.1.5 Aggregation and Grouping Operations 5.1.6 Summary of the Relational Algebra Operations 5.2 The Relational Calculus 5.2.1 Tuple Relational Calculus 5.2.2 Domain Relational Calculus 5.3 Other Languages Chapter Summary Review Questions Exercises Chapter 6 SQL: Data Manipulation 6.1 Introduction to SQL 6.1.1 Objectives of SQL 6.1.2 History of SQL 6.1.3 Importance of SQL 6.1.4 Terminology 6.2 Writing SQL Commands 6.3 Data Manipulation 6.3.1 Simple Queries 6.3.2 Sorting Results (ORDER BY Clause) 6.3.3 Using the SQL Aggregate Functions 6.3.4 Grouping Results (GROUP BY Clause) 6.3.5 Subqueries 6.3.6 ANY and ALL 6.3.7 Multi-table Queries 6.3.8 EXISTS and NOT EXISTS 6.3.9 Combining Result Tables (UNION, INTERSECT, EXCEPT) 6.3.10 Database Updates Chapter Summary Review Questions Exercises Chapter 7 SQL: Data Definition 7.1 The ISO SQL Data Types 7.1.1 SQL Identifiers 7.1.2 SQL Scalar Data Types 7.2 Integrity Enhancement Feature 7.2.1 Required Data 7.2.2 Domain Constraints 7.2.3 Entity Integrity 7.2.4 Referential Integrity 7.2.5 General Constraints 7.3 Data Definition 7.3.1 Creating a Database 7.3.2 Creating a Table (CREATE TABLE) 7.3.3 Changing a Table Definition (ALTER TABLE) 7.3.4 Removing a Table (DROP TABLE) 7.3.5 Creating an Index (CREATE INDEX) 7.3.6 Removing an Index (DROP INDEX) 7.4 Views 7.4.1 Creating a View (CREATE VIEW) 7.4.2 Removing a View (DROP VIEW) 7.4.3 View Resolution 7.4.4 Restrictions on Views 7.4.5 View Updatability 7.4.6 WITH CHECK OPTION 7.4.7 Advantages and Disadvantages of Views 7.4.8 View Materialization 7.5 Transactions 7.5.1 Immediate and Deferred Integrity Constraints 7.6 Discretionary Access Control 7.6.1 Granting Privileges to Other Users (GRANT) 7.6.2 Revoking Privileges from Users (REVOKE) Chapter Summary Review Questions Exercises Chapter 8 Advanced SQL 8.1 The SQL Programming Language 8.1.1 Declarations 8.1.2 Assignments 8.1.3 Control Statements 8.1.4 Exceptions in PL/SQL 8.1.5 Cursors in PL/SQL 8.2 Subprograms, Stored Procedures, Functions, and Packages 8.3 Triggers 8.4 Recursion Chapter Summary Review Questions Exercises Chapter 9 Object-Relational DBMSs 9.1 Advanced Database Applications 9.2 Weaknesses of RDBMSs 9.3 Storing Objects in a Relational Database 9.3.1 Mapping Classes to Relations 9.3.2 Accessing Objects in the Relational Database 9.4 Introduction to Object-Relational Database Systems 9.5 SQL:2011 9.5.1 Row Types 9.5.2 User-Defined Types 9.5.3 Subtypes and Supertypes 9.5.4 User-Defined Routines 9.5.5 Polymorphism 9.5.6 Reference Types and Object Identity 9.5.7 Creating Tables 9.5.8 Querying Data 9.5.9 Collection Types 9.5.10 Typed Views 9.5.11 Persistent Stored Modules 9.5.12 Triggers 9.5.13 Large Objects 9.5.14 Recursion 9.6 Object-Oriented Extensions in Oracle 9.6.1 User-Defined Data Types 9.6.2 Manipulating Object Tables 9.6.3 Object Views 9.6.4 Privileges Chapter Summary Review Questions Exercises Part 3 Database Analysis and Design Chapter 10 Database System Development Lifecycle 10.1 The Information Systems Lifecycle 10.2 The Database System Development Lifecycle 10.3 Database Planning 10.4 System Definition 10.4.1 User Views 10.5 Requirements Collection and Analysis 10.5.1 Centralized Approach 10.5.2 View Integration Approach 10.6 Database Design 10.6.1 Approaches to Database Design 10.6.2 Data Modeling 10.6.3 Phases of Database Design 10.7 DBMS Selection 10.7.1 Selecting the DBMS 10.8 Application Design 10.8.1 Transaction Design 10.8.2 User Interface Design Guidelines 10.9 Prototyping 10.10 Implementation 10.11 Data Conversion and Loading 10.12 Testing 10.13 Operational Maintenance 10.14 CASE Tools Chapter Summary Review Questions Exercises Chapter 11 Database Analysis and the DreamHome Case Study 11.1 When Are Fact-Finding Techniques Used? 11.2 What Facts Are Collected? 11.3 Fact-Finding Techniques 11.3.1 Examining Documentation 11.3.2 Interviewing 11.3.3 Observing the Enterprise in Operation 11.3.4 Research 11.3.5 Questionnaires 11.4 Using Fact-Finding Techniques: A Worked -Example 11.4.1 The DreamHome Case Study-An Overview of the Current System 11.4.2 The DreamHome Case Study-Database Planning 11.4.3 The DreamHome Case Study-System Definition 11.4.4 The DreamHome Case Study-Requirements Collection and Analysis 11.4.5 The DreamHome Case Study-Database Design Chapter Summary Long Description Database Systems is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With its comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases--conceptual, logical, and physical database design. Feature Details A print text Free shipping New Feature A Comprehensive Introduction to the Theory behind Databases Extended chapter on database architectures and the Web, covering cloud computing New Section on Data Warehousing and Temporal Databases Updated treatment to cover the latest version of the SQL standard, which was released late 2011 (SQL:2011) Extended chapter on replication and mobile databases Updated chapters on Web-DBMS integration and XML Extended treatment of XML, SPARQL, XQuery 1.0 and XPath 2.0 (including the new XQuery Update facility), and the new SQL:2011 SQL/XML standard Coverage updated to Oracle 11g A Clear Introduction to the Theory behind Databases New review questions and exercises at the end of chapters allow readers to test their understanding Details ISBN0132943263 Author Carolyn Begg Language English Edition 6th ISBN-10 0132943263 ISBN-13 9780132943260 Media Book Format Paperback Pages 1440 DEWEY 005.743 Year 2014 Publication Date 2014-01-03 Short Title DATABASE SYSTEMS REV/E 6/E Edition Description Revised Illustrations Yes Publisher Pearson Imprint Addison-Wesley Subtitle A Practical Approach to Design, Implementation, and Management Audience College/Higher Education We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:78167572;

Price: 580.95 AUD

Location: Melbourne

End Time: 2025-01-15T03:03:05.000Z

Shipping Cost: 0 AUD