Preface Part 1: Getting Started 1 Chapter 1: Introduction 3 The Characteristics of Databases 4 Database Examples 5 Components of a Database System 8 The Database 11 Database Design 13 What You Need to Learn 17 A Brief History of Database Processing 18 Chapter 2: Introduction to Structured Query Language 27 SQL Background 28 Cape Codcl Outdoor Sports 28 The SQL SELECT/FROM/WHERE Framework 31 Continuation of SQL for Querying a Single Table 40 Performing Calculations in SQL Queries 45 Grouping 50 Looking for Patterns in NASDAQ Trading 52 Querying Two or More Tables with SQL 55 Part 2: Database Design 67 Chapter 3: The Relational Model and Normalization 69 Relational Model Terminology 71 Normal Forms 81 Chapter 4: Database Design Using Normalization 101 Assess Table Structure 102 Designing Updatable Databases 103 Designing Read-Only Databases 106 Common Design Problems 109 Chapter 5: Data Modeling with the Entity-Relationship Model 119 The Purpose of a Data Model 120 The Entity-Relationship Model 120 Patterns in Forms, Reports, and Entity-Relationship Models 135 The Data Modeling Process 153 Chapter 6: Transforming Data Models into Database Designs 171 Create a Table for Each Entity 172 Create Relationships 177 Design for Minimum Cardinality 194 The View Ridge Gallery Database 204 Part 3: Database Implementation 217 Chapter 7: SQL for Database Construction and Application Processing 219 SQL DDL, DML, and Joins 220 SQL DML 232 New Forms of Join 234 Using SQL Views 239 Embedding SQL in Program Code 247 Use Triggers 248 Using Stored Procedures 254 Chapter 8: Database Redesign 265 The Need for Database Redesign 266 Additional SCIL Statements 266 Analyzing the Existing Database 271 Changing Table Names and Table Columns 275 Changing Relationship Cardinalities and Properties 279 Adding and Deleting Tables and Relationships 283 Forward Engineering (?) 284 Part 4: Multiuser Database Processing 291 Chapter 9: Managing Multiuser Databases 293 Database Administration 294 Concurrency Control 296 Database Security 309 Database Recovery 314 Managing the DMBS 317 Chapter 10: Managing Databases with Oracle 325 Installing Oracle 326 Creating an Oracle Database 326 Data Dictionary 354 Concurrency Control 356 Oracle Security 358 Oracle Backup and Recovery 363 Topics Not Discussed in This Chapter 365 Chapter 11 : Managing Databases with SQL Server 2000 371 Installing SQLServer 2000 372 Creating a SQL Server 2000 Database 372 Application Logic 382 Concurrency Control 393 SQL Server Security 397 SQL Server Backup and Recovery 40o Topics Not Discussed in This Chapter 404 Part 5: Database Access Standards 409 Chapter 12: ODBC, aLE DB, ADO, and ASP 411 The Web Server Data Environment 412 Open Database Connectivity (ODBC) Standard 414 OLE DB 418 Active Data Objects (ADO) 422 ADO Examples 428 Chapter 13: XML and ADO.NET 449 The Importance of XML 450 XML as a Markup Language 451 XML Schema 456 ADO.NET 474 Additional XML Standards 488 Chapter 14: JDBC, Java Server Pages, and MySQL 497 JDBC 498 Java Server Pages 5o7 MySOL 519 Part 6: Conclusion 529 Chapter 15: Database Processing for Business Intelligence Systems 531 Repasting and Data Mining Applications 532 Data Warehouses and Data Marts 533 Reporting Systems 537 Data Mining 549 Appendix A Introduction to Microsoft Access 561 Appendix B The IDEF1XStandard 575 Appendix G UML-Style Entity-Relationship Diagrams 583 Appendix D Data Structures for Database Processing 589 Appendix E The Semantic Object Model 609 Bibliography 643 Glossary 645 Index 663
鄂公網(wǎng)安備 42010302001612號 