Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
Rob P., Coronel C. — Database systems: Design, Implementation, and Management
Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå Íàøëè îïå÷àòêó?
Íàçâàíèå: Database systems: Design, Implementation, and ManagementÀâòîðû: Rob P., Coronel C. Àííîòàöèÿ: Database Systems: Design, Implementation, and Management, Fifth Edition takes you clearly and effectively through the entire process of database development and implementation. The most comprehensive and detailed coverage of database basics is complemented with ample exercises and problems at the end of each chapter to encourage hands-on learning, and a two-chapter step-by-step running case. Because the Internet has become so firmly established as an extension of the everyday business data environment, this revised edition contains two new chapters, "Databases in Electronic Commerce" and "Web Database Development," that stress the need for solid planning and management in order to maximize the resources that the Internet provides.
ßçûê: Ðóáðèêà: Computer science /Ñòàòóñ ïðåäìåòíîãî óêàçàòåëÿ: Ãîòîâ óêàçàòåëü ñ íîìåðàìè ñòðàíèö ed2k: ed2k stats Èçäàíèå: 6th editionÃîä èçäàíèÿ: 2004Êîëè÷åñòâî ñòðàíèö: 795Äîáàâëåíà â êàòàëîã: 29.03.2006Îïåðàöèè: Ïîëîæèòü íà ïîëêó |
Ñêîïèðîâàòü ññûëêó äëÿ ôîðóìà | Ñêîïèðîâàòü ID
Ïðåäìåòíûé óêàçàòåëü
Pointer system 548 policies 723—724 Polymorphism 518—519 533 Portability 38 418 Precedence, rules of 257—258 Premature binding 539 (see also Binding) preorder traversal 35 PREPARE TO COMMrT message 490 Presentation, data independence and 22 Presentation, described 22 Presentation, formats, relational model and 79 Presentation, tools 560 566—567 573 preventive maintenance 425 (see also Maintenance) PRIMARY KEY constraint, described 227 239 PRIMARY KEY constraint, Oracle and 236 PRIMARY KEY constraint, when to use 237 Primary key(s), defining 271—272 Primary key(s), described 79 80 85 Primary key(s), ER models and 125—126 130 134 139 Primary key(s), identifying 189 Primary key(s), many-to-many relationships and 101 Primary key(s), normalization and 189 194 195 199 Primary key(s), one-to-many relationships and 98 Primary key(s), refining 195 Primary key(s), relational model and 79 80 85 98 101 Primary key(s), rules governing 295 Primary key(s), updating 292 294 358 Prime attributes 191 Printer spooling 668 Privacy (see also Security) Privacy, database administration and 713 725—726 Privacy, described 628 Privacy, e-commerce and 617 628—635 Privileges, assignment of 725 Problems, defining 403—404 Procedural SQL (PL/SQL) 383 540 Procedural SQL (PL/SQL) and 359 Procedural SQL (PL/SQL) and query optimization and 491 Procedural SQL (PL/SQL), blocks, anonymous 361 Procedural SQL (PL/SQL), cursors and 378—381 Procedural SQL (PL/SQL), described 359—381 Procedural SQL (PL/SQL), functions 360 Procedural SQL (PL/SQL), stored functions 381 Procedural SQL (PL/SQL), stored procedures and 373—378 Procedural SQL (PL/SQL), triggers and 364—373 Procedure(s) (see also Stored procedures) Procedure(s), database administration and 723—724 746—747 Procedure(s), described 21 Procedure(s), flow 407 Processing, logic 208 576 577—579 582 Processing, mismatches 382 Product operator 86 88 90 Production managers 404 Profiles, described 747 Prognosis phase 599—600 Programmers, described 20 PROJECT operator 89 Protocols, DDBMSs and 477 Protocols, DO — UNDO — REDO protocol 490 protocols, FTP (File Transfer Protocol) 625 632 Protocols, HTTP (HyperText Transfer Protocol) 624 625 632 669 Protocols, OO (object oriented) databases and 513—514 Protocols, S-HTTP (Secure Hypertext Transfer Protocol) 632 protocols, TCP/IP (Transmission Control Protocol/Internet Protocol) 472 624 625 669 703 Protocols, two-phase commit protocol 489—490 Protocols, write-ahead protocol 490 Protocols, write-ahead-log protocol 459 prototypes 425 proxy settings 634—635 PSBs (program specific blocks). 422 PSM (persistent stored module) 360 QBE (Query by Example) query generator 251—253 Quality assurance 723 Queries (see also SQL (Structured Query Language)) Queries, ad hoc 7 43 Queries, ColdFusion and 674—680 Queries, correlated 335—347 queries, creating 674—680 Queries, data warehouses and 580—581 Queries, described 7 Queries, languages for 24 Queries, OODBMs and 539 Queries, optimization of 475 490—492 499 732 Queries, QBE generator and 251—253 Queries, SELECT command and 251—264 272—275 Queries, tools for 560 573 question mark (?) 261 RDBMSs (Relational Database Management Systems) (see also Relational model) RDBMSs (relational database management systems), advantages/disadvantages of 43—45 RDBMSs (relational database management systems), automatic start of, ensuring 742—743 RDBMSs (relational database management systems), data dictionaries and 92—93 RDBMSs (relational database management systems), data redundancy and 104—106 RDBMSs (relational database management systems), data warehouses and 565 579—582 587 RDBMSs (relational database management systems), database administration and 738 742—743 RDBMSs (relational database management systems), described 41—45 56 75—121 RDBMSs (relational database management systems), indexes and 106—107 RDBMSs (relational database management systems), keys and 80—85 RDBMSs (relational database management systems), OO (object oriented) databases and 546—549 RDBMSs (relational database management systems), relationships within 95—103 RDBMSs (relational database management systems), system catalog and 92—93 RDBMSs (relational database management systems), terminology for 77 RDBMSs (relational database management systems), Web database development and 702 703 Read operation 449 497 Read phase 457 REAL data type 235 509 Recovery (see also Backups) recovery and 460 Recovery, database administration and 724 726—727 729 733 Recovery, DBLC and 423 425 Recovery, DDBMSs and 476 Recovery, described 458 Recovery, maintenance phase and 425 Recovery, management 23 458—462 Recovery, transactions and 443 Recursive queries 288—289 Red Cross 618 Redundancy, controlled 83 104 Redundancy, DBLC and 413 Redundancy, described 9 17—18 Redundancy, design issues and 9 Redundancy, normalization and 187 190—191 Referential integrity (see also Integrity) Referential integrity, constraints and 241 Referential integrity, described 84 Referential integrity, enforcement of 238 Referential integrity, normalization and 198 Referential, constraint actions 239 Referential, object sharing 524 Reiner, D. 154 Relational algebra 86—87 Relational model (see also RDBMSs (relational database management systems)) Relational model and SELECT subqueries 249—250 Relational model and selecting 251—257 Relational model and SQL and 23 Relational model, advantages/disadvantages 43—45 Relational model, data dictionaries and 92—93 Relational model, data redundancy and 104 106 Relational model, database models and 41—44 Relational model, described 41—45 56 75—121 Relational model, ER modei and, integration of 48 Relational model, indexes and 106—107 Relational model, keys and 80—85 Relational model, operators and 86—92 Relational schema 42 Relational set operators, correlated queries and 335—347 Relational set operators, described 320—325 Relational set operators, INTERSECT command and 323—324 326—328 Relational set operators, MINUS command and 324—327 Relational set operators, subqueries and 335—347 Relational set operators, UNION ALL command and 322—323 Relational set operators, UNION command and 321—322 Relations, described 41 76 Relations, union-compatible 320 relationships (see also Specific types) Relationships within 95—103 Relationships within system catalog and 92—93 Relationships within table characteristics and 75—79 Relationships within terminology for 77 Relationships, adding 195 Relationships, binary 142 Relationships, conceptual models and 59 Relationships, converting 101 Relationships, converting many-to-many relationships into 101 Relationships, converting, into two one-to-many relationships 101 Relationships, database models and 46 167 Relationships, degree 142—147 Relationships, described 31—32 Relationships, ER models and 130—131 Relationships, four-entity 142 Relationships, general rules governing 296—297 Relationships, hierarchical models and 37 Relationships, interobject 525—531 Relationships, many-to-many described 31 Relationships, normalization and 204 relationships, one-to-many 39 46 Relationships, OO (object oriented) databases and 526—528 Relationships, OODM and 535 Relationships, participation 135—139 relationships, recursive 142—147 167 Relationships, strength of 133—135 139—142 Relationships, strong (identifying) 135 Relationships, symbols for 154 Relationships, ternary 142—144 Relationships, unary 142 146 Relationships, weak (non-identifying) 133—134 137 Relationships, weak entities and 139—142 Remote 485—486 Remote access 482 485—486 Remote, requirements, gathering 722 724 Remote, transactions and 439 485—489 Remote, transparency and 485—489 Repeating groups 188 190 Replica transparency 491 Replication, data allocation and 497—498 Replication, data warehouses and 594—595 Replication, DDBMSs and 495—497 Replication, mutual consistency rule and 496 Requests, DDBMSs and 485—489 Requests, described 439 Requests, distributed 485—489 Reserved words 238 Resource(s), classification of data as 712 Resource(s), security 633—635 Restoring table contents with 246—249 Restoring table contents with sequences and 356 Retrievals, inconsistent 447—448 Reusability, of classes 547 REVOKE command 703 right outer joins 91—92 291 ROLAP (relational online analytical processing) 579—582 584 Roles, described 747 Roll up, described 562 588 ROLLBACK command, described 228 243 248—249 Root, described 35 ROUND function 350 routers 624 Row(s) (see also Tuples) Row(s), adding 243—246 270 Row(s), cursors and 379—380 Row(s), deleting 249 Row(s), inserting 249—250 Row(s), listing 246—247 Row(s), null attributes and 244—245 Row(s), OODBMs and 540 542 Row(s), optional attributes and 245 Rules governing 296—297 SAS Institute 600 Scheduler 448 449 Schema Manager 746—747 Schema, data warehouses-and 564—566 580 Schema, database administration and 746—747 Schema, database models and 38 42 Schema, described 231—232 Schema, ER models and 134 Schema, relational 42 106 133 Scope, defining 405—406 scripts, CGI (Common Gateway Interface) 665—666 668 Scripts, described 671—672 SDLC (Systems Development Life Cycle), analysis phase 399 400 SDLC (Systems Development Life Cycle), database administration and 736 SDLC (Systems Development Life Cycle), DBLC and, comparison of 426 SDLC (Systems Development Life Cycle), described 398—401 SDLC (Systems Development Life Cycle), detailed systems design phase 399 400 SDLC (Systems Development Life Cycle), diagram of 399 SDLC (Systems Development Life Cycle), implementation phase 399 400—401 SDLC (Systems Development Life Cycle), maintenance phase 399 401 SDLC (Systems Development Life Cycle), planning phase 398—399 SDM (semantic data model) 49 Search, pages 679—683 SEC (Securities and Exchange Commission) 663 Second normal form (2NF) 184 191—192 199 Secondary keys 84—85 Security (see also Privacy) Security Manager 747—748 Security, authentication 231 629—630 Security, database administration and 713 724—727 747—748 Security, database models and 36 Security, DBLC and 423 Security, DDBMSs and 472 475 Security, e-commerce and 617 626 628—635 Security, encryption and 423 631 Security, overview of 23 security, passwords 15 423 630 723—725 Security, physical 423 725 727 Security, resource 633—635 Security, Web database development and 703—704 Sega 558 Segments, described 35 SELECT command, aggregate functions and 281 SELECT command, computed columns and 256—257 SELECT command, DDBMSs and 487 492 SELECT command, described 227 243 SELECT command, embedded SQL and 383 SELECT command, GROUP BY clause and 283 SELECT command, HAVING clause and 284 SELECT command, inserting rows with 249 SELECT command, joins and 286 329 SELECT command, listing rows with 246—247 SELECT command, OO (object oriented) databases and 542 SELECT command, Procedural SQL (PL/SQL) and 363 372 SELECT command, queries and 251—264 272—275 SELECT command, relational operators and 247 327 SELECT command, ROLLBACK command and 248 SELECT command, subqueries and 249—250 336—337 340—342 SELECT command, transactions and 439 SELECT command, triggers and 372 SELECT operator 86 88 Semicolon {;) 231 238 Sequence(s), described 353—356 Sequence(s), hierarchical 35 Serializability property 442 454 Servers, described 624 Servers, interfaces 665—667 Servers, OO (object oriented) databases and 549 servers, proxy 634—635 Servers, XML and 656 Servers-side extensions 664—669 Services 626 SET (Secure Electronic Transactions) 636 SET TRANSACTION statement 443
Ðåêëàìà
|
|
Î ïðîåêòå