tailieunhanh - Database Management Systems -Second Edition

Database management systems have become ubiquitous as a fundamental tool for managing information, and a course on the principles and practice of database systems is now an integral part of computer science curricula. This book covers the fundamentals of modern database management systems, in particular relational database systems. It is intended as a text for an introductory database course for undergraduates, and we have attempted to present the material in a clear, simple style. | Database Management Systems Second Edition Raghu Ramakrishnan Johannes Gehrke CONTENTS PREFACE xxii Part I BASICS 1 1 INTRODUCTION TO DATABASE SYSTEMS 3 Overview 4 A Historical Perspective 5 File Systems versus a DBMS 7 Advantages of a DBMS 8 Describing and Storing Data in a DBMS 9 The Relational Model 10 Levels of Abstraction in a DBMS 11 Data Independence 14 Queries in a DBMS 15 Transaction Management 15 Concurrent Execution of Transactions 16 Incomplete Transactions and System Crashes 17 Points to Note 18 Structure of a DBMS 18 People Who Deal with Databases 20 Points to Review 21 2 THE ENTITY-RELATIONSHIP MODEL 24 Overview of Database Design 24 Beyond the ER Model 25 Entities Attributes and Entity Sets 26 Relationships and Relationship Sets 27 Additional Features of the ER Model 30 Key Constraints 30 Participation Constraints 32 Weak Entities 33 Class Hierarchies 35 Aggregation 37 vii viii Database Management Systems Conceptual Database Design With the ER Model 38 Entity versus Attribute 39 Entity versus Relationship 40 Binary versus Ternary Relationships 41 Aggregation versus Ternary Relationships 43 Conceptual Design for Large Enterprises 44 Points to Review 45 3 THE RELATIONAL MODEL 51 Introduction to the Relational Model 52 Creating and Modifying Relations Using SQL-92 55 Integrity Constraints over Relations 56 Key Constraints 57 Foreign Key Constraints 59 General Constraints 61 Enforcing Integrity Constraints 62 Querying Relational Data 64 Logical Database Design ER to Relational 66 Entity Sets to Tables 67 Relationship Sets without Constraints to Tables 67 Translating Relationship Sets with Key Constraints 69 Translating Relationship Sets with Participation Constraints 71 Translating Weak Entity Sets 73 Translating

• Cơ sở dữ liệu
• Systems versus
• DATABASE SYSTEMS
• Transaction Management
• Database Design
• Relational Model
• Relational Algebra
• Relational Calculus
• Basic SQL Query
• Simulating the Behaviour
• Older versus Younger Users when Interacting
• Spoken Dialogue Systems
• báo cáo khoa học
• báo cáo ngôn ngữ
• xử lý ngôn ngữ tự nhiên
• BMC Pediatrics
• Weekend versus weekday
• Quality of health care
• Poor patient outcomes
• Health care systems
• Cost accounting
• Fundamentals of cost accounting
• Cost analysis
• Cost management systems
• Management control systems
• Cost versus expenses
• Data Versus Information
• File Processing Systems
• Database Management Systems
• Database Development Process
• Analyzing Database Requirements
• Modeling Multiple Relationships
• dự án
• project
• BASIC PRINCIPLES
• UML NOTATION
• ABSTRACT CLASSES
• VERSUS INTERFACES
• UML DIAGRAMS
• DESIGN PATTERNS
• New Models
• 3D Culture Systems
• Role of Bioreactors
• prioritized and addressed
• cost effective option
• risk assessments
• báo cáo hóa học
• công trình nghiên cứu về hóa học
• tài liệu về hóa học
• cách trình bày báo cáo
• complete systems
• minutes
• ensuring high
• avoiding business
• interruption threats
• Complete data
• Microelectronics
• Electronics versus
• Electronic Systems
• Basic Physics
• Semiconductors
• Diode Models
• Circuits
• Personality disorders
• Conceptual issues
• Theoretical versus inductive approaches
• Contemporary personality pathology
• Official classification systems
• BMC Cancer
• Colorrectal cancer
• Lymph node
• Log ratio
• TNM system
• Ganglion quotients
• BMC Musculoskeletal Disorders
• Multiple systems injured
• Ligamentous knee injuries
• Patient demographics
• Associated injuries
• BMC Pulmonary Medicine
• Primary spontaneous
• Chest tubes
• Drainage system
• Actual air leakage
• Lecture Operating system concepts
• Operating system concepts
• Distributed File Systems
• Naming and Transparency
• Remote File Access
• Stateful versus Stateless Service
• Building Web Services with Java
• Distributed computing systems
• Web services basics
• Service Oriented architectures
• Document versus data centric XML
• Simple object access protocol (SOAP)