Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
Indexes, schema and 231—232 Indexes, sort order and 243 Indexes, SQL and 241—243 indexes, unique 107 242 information (see also information systems (IS)) information systems (IS) (see also Information) Information systems (IS), concurrency control and 415 424 Information systems (IS), DBLC and 401—426 Information systems (IS), described 715 Information systems (IS), ER models and 400 410—417 427 Information systems (IS), hardware requirements and 399 418 Information systems (IS), overview of 396—433 Information systems (IS), SDLC and 398—401 Information, accuracy of, importance of 6 Information, age, described 6 Information, changing data into 396—398 Information, data-information-decision cycle and 712 Information, generating, for decision making 397 Information, islands of 17 44 576 Information, minimal data rule and 408 Information, use of the term 6 Informix 41 Ingress 41 Inheritance, described 50 515 inheritance, multiple 516—517 540 Inheritance, OO (object oriented) databases and 514—517 534 539—540 547 549 inheritance, single 515—516 Initialization parameters 749—750 753 inline 342—343 Inmon, William H. 567 572 inner joins 328 (see also Joins) Inner queries (subqueries), aggregate functions and 279 Inner queries (subqueries), attribute list 342—344 Inner queries (subqueries), correlated 344—347 Inner queries (subqueries), described 249 Inner queries (subqueries), FROM 341—342 344 Inner queries (subqueries), HAVING 339 Inner queries (subqueries), IN 338—339 Inner queries (subqueries), inserting rows with 249 Inner queries (subqueries), operators and 340 Inner queries (subqueries), WHERE 337—338 INSERT command, adding rows with 243—246 270 349 INSERT command, column types and 542 INSERT command, described 227 243 INSERT command, embedded SQL and 383 INSERT command, normalization and 187 INSERT command, OO (object oriented) databases and 542 INSERT command, ROLLBACK command and 248 INSERT command, subqueries and 249 336 INSERT command, syntax 243 249 INSERT command, transactions and 439 461 Instance Manager (Oracle) 749—750 instance variables 508—509 instructions (see Procedures) Insurance coverage 727 INTEGER data type, described 235 INTEGER data type, lack of support for 236 INTEGER data type, OO (object oriented) databases and 509 INTEGER data type, SQL and 234 235 Integrated character, of data warehouses 567—568 Integrity (see also Referential integrity) Integrity, database administration and 725—726 729 Integrity, database models and 36 40 51 Integrity, DBLC and 424 Integrity, described 17 Integrity, entities and 82 85—86 Integrity, management 23 Integrity, rules 85—86 271 Integrity, transactions and 442 444 IntemetSecure, Inc. 636 Internal model 59—60 Internet (see also World Wide Web) Internet Explorer browser (Microsoft) 24 653—655 Internet, database models and 54—55 Internet, history of 614 Internet, services, basic 623—626 Internet, technologies, characteristics/benefits of 663 Interoperability 729 INTERSECT command, alternatives to 326—327 INTERSECT command, lack of support for 325 326 INTERSECT command, relational set operators and 320 323—324 326—328 INTERSECT command, updatable views and 358 INTERSECT operator 86 87 Intersection (bridge) classes 529—531 INTO clause 363 372 INTO keyword 363 Intra-business e-commerce 617 intranets 614 621—622 IRM (information resource manager) 718 IS keyword 373 IS NULL operator 228 260 261 ISA (information systems architecture) 738 ISAPI (Internet Server API) 666 ISO (International Standards Organization) 226 Isolation property 442 448 iterative processes 157 Java, described 506 Java, embedded SQL and 381 382 Java, OO (object oriented) databases and 506 540 549 Java, Web database development and 669—670 672 705 JavaScript 669—670 684 705 Job functions, overview of 20—21 Join(s), aliases and 288 289 Join(s), columns 90 Join(s), conditions 286 Join(s), cross 328 329 Join(s), described 286—291 Join(s), expression styles 328 Join(s), inner 328 Join(s), left outer 91—92 290 Join(s), natural 329—330 Join(s), operators 86 89—91 327—328 Join(s), outer 91—92 290—291 328 332—334 Join(s), recursive 288—289 Join(s), results of 286 Join(s), right outer 91—92 291 Join(s), updatable views and 358 Join(s), USING clause and 330—331 Julian calendar 79 Kelley, Chuck 572 Key(s) (see also Keys foreign Keys primary) Key(s), attributes 81—82 191 Key(s), described 80—85 Key(s), determination and 80 Key(s), super 82 Keys, attributes and 128 Keys, constraints and 241 Keys, data redundancy and 104 Keys, defining 241 271—272 Keys, described 84 85 Keys, ER models and 128 134 keys, foreign (see also Keys) Keys, identifying 189 Keys, many-to-many relationships and 101 Keys, normalization and 189 194 195 199 Keys, one-to-many relationships and 98 keys, primary (see also Keys) Keys, referential integrity and 84 238 Keys, refining 195 Keys, relational model and 104 Keys, rules governing 295 296—297 Keys, updating 292 294 358 Knowledge-acquisition phase 599—600 LANs (local area networks) (see also networks) LANs (local area networks), DDBMSs and 471 472 478—479 LANs (local area networks), MPSD and 479 LANs (local area networks), transactions and 442 LASTDAY function 349 late binding 531—533 (see also Binding) Learning curves 51—52 left outer joins 91—92 290 Legacy systems integration 655 length function 351 Life Cycle, Database (DBLC), database administration and 717 Life Cycle, Database (DBLC), database initial study phase 401—406 Life Cycle, Database (DBLC), described 401—426 Life Cycle, Database (DBLC), design phase 402 406—420 Life Cycle, Database (DBLC), ER models and 410—415 Life Cycle, Database (DBLC), implementation and loading phase 402 420—424 Life Cycle, Database (DBLC), logical design and 418—420 Life Cycle, Database (DBLC), maintenance and evaluation phase 402 425—426 Life Cycle, Database (DBLC), normalization and 410—415 Life Cycle, Database (DBLC), operation phase 402 425 Life Cycle, Database (DBLC), physical design and 420 Life Cycle, Database (DBLC), SDLC and, comparison of 426 Life Cycle, Database (DBLC), software selection and 417—418 Life Cycle, Database (DBLC), testing and evaluation phase 402 425 Life Cycle, Systems Development (SDLC), analysis phase 399—400 Life Cycle, Systems Development (SDLC), database administration and 736 Life Cycle, Systems Development (SDLC), DBLC and, comparison of 426 Life Cycle, Systems Development (SDLC), described 398 401 Life Cycle, Systems Development (SDLC), detailed systems design phase 399 400 Life Cycle, Systems Development (SDLC), diagram of 399 Life Cycle, Systems Development (SDLC), implementation phase 399 400—401 Life Cycle, Systems Development (SDLC), maintenance phase 399 401 Life Cycle, Systems Development (SDLC), planning phase 398—399 Life Cycle, Systems Development (SDLC), software selection and 405 LIKE operator 228 260 261—262 LIKE operator, Unking tables 101—102 LIKE operator, USP 506 Listings, ordering 272—275 Load, balancing 627 Load, testing 627 local area networks (LANs) (see also networks) Local area networks (LANs), DDBMSs and 471 472 478—479 Local area networks (LANs), MPSD and 479 Local area networks (LANs), transactions and 442 Local mapping transparency 483 484 location transparency 483 484 499 LOCK TABLE command 452 Lock(s), binary 452 53 Lock(s), concurrency control with 449—458 Lock(s), conflicting 454 Lock(s), database-level 450 Lock(s), DDBMSs and 480 Lock(s), described 449 Lock(s), exclusive 453—454 Lock(s), field-level 452 Lock(s), granularity 450—452 Lock(s), locking methods and 449—458 Lock(s), managers 449 Lock(s), page-level 451 Lock(s), row-level 452 Lock(s), shared/exclusive 453—455 Lock(s), table-level 450—451 Lock(s), time stamping and 457 Lock(s), transactions and 449—458 Lock(s), two-phase 454—455 Lock(s), types of 452—454 Logic, analytical processing 576 577—579 582 Logic, data-processing 576 577—579 582 LOGICAL data type 235 Logical, data, described 15—16 79 Logical, design 10 418—420 232 Logical, operators 228 258—260 Login, default 742 (see also Authentication passwords) Logs, audit 726 Logs, backing up 458 Logs, DDBMSs and 490 Logs, recovery and 459 460—461 Logs, transaction 443—444 458—461 490 Loops 344 363 Lotus 577 LOWER function 351 Machine operators 404 Macintosh 547 Mainframes, DBLC and 420 421 Mainframes, DDBMSs and 478 Mainframes, transactions and 442 Maintenance and evaluation phase (DBLC) 402 425—426 Maintenance, adaptive 401 425 maintenance, corrective 401 425 Maintenance, database administration and 724 733 Maintenance, perfective 401 Maintenance, phase (SDLC) 399 401 maintenance, preventive 425 Manual, query optimization 491 Manual, statistical generation mode 492 Many-to-many relationships, converting, into two one-to-many relationships 101 Many-to-many relationships, described 31 Many-to-many relationships, hierarchical models and 37 Many-to-many relationships, normalization and 204 Many-to-many relationships, relational model and 99—103 Many-to-many relationships, rules governing 296—297 Mapping, DDBMSs and 475 483 484 Mapping, transparency 483 484 MAX function, described 228 276—279 MAX function, GROUP BY clause and 281 MAX function, Procedural SQL (PL/SQU) and 360 MAXSPEED variable 516—517 MDBMSs (multidimensional database management systems) 582—587 MEMBER FUNCTION clause 541 Member records 39 Memory, cursors and 378 memory, management 668 Memory, OODBMs and 539 Messages 510—511 627 Meta-dictionaries 656 Metadata, described 7 Method(s), body 510 Method(s), components 510—511 Method(s), described 510 Method(s), names 510 Method(s), OO (object oriented) databases and 510—511 Method(s), overriding 517—519 Method(s), relational model and 79 Method(s), sets of 79 Microsoft Access, AutoNumber feature 535 Microsoft Access, case-sensitivity and 262 Microsoft Access, COMMIT command and 246 Microsoft Access, computed columns and 256—257 Microsoft Access, constraints and 240 Microsoft Access, COUNT function and 277 Microsoft Access, creating databases and 231 Microsoft Access, creating tables and 271 Microsoft Access, data dictionaries and 21 Microsoft Access, data sets and 76 Microsoft Access, data types and 235 236 Microsoft Access, dates and 79 232 348 Microsoft Access, DBLC and 418 Microsoft Access, embedded SQL and 382 Microsoft Access, ER models and 134 Microsoft Access, joins and 290 291 Microsoft Access, naming conventions and 78 Microsoft Access, OO (object oriented) databases and 535 Microsoft Access, relational model and 76 78—79 Microsoft Access, relational set operators and 321 Microsoft Access, ROLLBACK command and 248 Microsoft Access, sequences and 353 Microsoft Access, SQL and 226 Microsoft Access, transactions and 441 Microsoft Access, views and 284 357 Microsoft Access, Web database development and 668 677—674 Microsoft Access, wildcard characters and 261 Microsoft ActiveX controls 669—670 Microsoft COM (Component Object Model) 547 Microsoft Excel 577 668 Microsoft Internet Explorer browser 24 653—655 Microsoft OLE (object linking and embedding) 547 666 702 703 Microsoft SQL Server 226 441
Ðåêëàìà
|
|
Î ïðîåêòå