| David M. Kroenke是一位多产的计算机畅销书作家。他撰写或与他人合著的图书专业性强，涉及面广。注重专业理论与实践应用的结合，精通数据库处理、数据库概念、商用计算机系统和管理信息等。 .. << 查看详细 |
| preface .ix 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 codd outdoor sports 28 the sol 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 entitg-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 carclinality 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 sql 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 sql server 2000 372 creating a sql server 2000 database 372 application logic 382 concurrency control 393 sol server security 397 sql server backup and recovery 400 topics not discussed in this chapter 404 part 5: database access standards 409 chapter 12: odbc, ole 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 4.56 ado.net 474 additional xml standards 488 chapter 14: jdbc, java server pages, and mgsql 497 jdbc 498 java server pages .507 mysql 519 part 6: conclusion 529 chapter 15: database processing for business intelligence systems 531 reposting 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 ideflx standard 575 appendix c 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 |
内容加载中，请稍后...
商品评论（0条）