Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
DSSs (decision support systems), architectural styles and 570—571 DSSs (decision support systems), data warehouse implementations and 595 DSSs (decision support systems), database requirements and 564—567 DSSs (decision support systems), described 558 559—567 DSSs (decision support systems), main components of 561 DSSs (decision support systems), schema and 564—566 585 DTDs (Document Type Definitions 650—653 Dummy variables 86 Durability property 442 444 Dynamic pages and 625 Dynamic pages, middleware and 664—669 Dynamic pages, security and 703—704 Dynamic pages, server-side extensions and 664 669 Dynamic pages, static pages and 625 Dynamic, query optimization 491 Dynamic, SQL 385—386 Dynamic, statistical generation mode 492 E-commerce (see also Transactions) E-commerce, architecture 622—628 E-commerce, B2B (business to business) 617—620 628 655 E-commerce, B2B2C (business to business to consumer) 621 E-commerce, B2C (business to consumer) 617 621 E-commerce, benefits of 616 E-commerce, business services 628 E-commerce, business-enabling services 626—627 E-commerce, C2B2C (consumer to business to consumer) 621 E-commerce, C2C (consumer to consumer) 617 E-commerce, described 610—659 E-commerce, design for 637—648 E-commerce, disadvantages of 617 E-commerce, impact of 615—617 E-commerce, security and 617 626 628—635 E-commerce, Web payment processing and 635—637 early binding 531—533 eBay 617 EDGAR database 663 EDI (electronic data interchange) 614 618 655 EDP (electronic data processing) 715 EFT (electronic funds transfers) 614 Embedded SQL 381—386 Encapsulation, described 511 Encapsulation, OO (object oriented) databases and 511 521 534 539 Encapsulation, relational model and 79 Encryption 423 631 END clause 361 366 379 541 END keyword 366 379 End users (see also Users) End users, browsers and 24 End users, business rules and 33 End users, communication interfaces and 24 End users, described 20 End users, perceptions of, verifying 33 Enterprise databases, described 8 714 Enterprise Manager (Oracle) 741 Entities (see also ER (entity relationship)) Entities, aggregation problems and 430 Entities, business rules and 32—33 Entities, cardinality and 131—132 Entities, characteristics of 124—125 Entities, composite {bridge) 101 147—150 411 545 Entities, connectivity and 131—132 Entities, described 31 Entities, ER models and 124 Entities, existence-dependent 133 139 Entities, existence-independent 133 Entities, instances (occurrences) of 45 124 Entities, integrity of 82 85—86 00 Entities, object oriented) databases and 507 533—534 Entities, relational model and 76 82—83 Entities, sets of 46 50 124 534 Entities, subtype 150—157 430 Entities, supertype 150—157 Entities, symbols for 154 Entities, weak 139—142 154 296 Equijoin, described 91 (see also Joins) ER (entity relationship) models (see also Chen ER model) ER (entity relationship) models, advantages/disadvantages 48 ER (entity relationship) models, attributes and 124—130 ER (entity relationship) models, basic structure of 45—47 ER (entity relationship) models, cardinality and 131—132 ER (entity relationship) models, classification of, as conceptual models 57—58 ER (entity relationship) models, components of 45—46 164 ER (entity relationship) models, connectivity and 131—132 ER (entity relationship) models, converting, into database structures 291—297 ER (entity relationship) models, database administration and 737—738 ER (entity relationship) models, DBLC and 410—415 ER (entity relationship) models, described 45—48 56 ER (entity relationship) models, developing 157—165 ER (entity relationship) models, iterative processes and 412 ER (entity relationship) models, modules and 415 416 ER (entity relationship) models, normalization and 202—205 ER (entity relationship) models, OIDs and 535 ER (entity relationship) models, OO (object oriented) databases and 509 521 533—535 545—546 ER (entity relationship) models, relationships and 130—131 ER (entity relationship) models, SDLC and 400 ER (entity relationship) models, top-down design and 427 ER (entity relationship) models, verifying 415—417 ERDM (extended relational data model) 52—53 54 ERDs (entity relationship diagrams) 45—48 57—58 ERDs (entity relationship diagrams), composite entities and 149 ERDs (entity relationship diagrams), described 45—47 ERDs (entity relationship diagrams), relationship lines in 134 ERDs (entity relationship diagrams), weak entities and 140 Ericsson 537 ERM (extended relational model) 549 ERP (Enterprise Resource Planning) 619 Error(s) file system data management and 15 Error(s) GROUP BY clause and 281 Error(s) maintenance and 401 Error(s) naming conventions and 18 Error(s) Procedural SQL (PL/SQL) and 362 Error(s) relational model and 100 Error(s) SDLC and 401 Error(s) SQL and 236 Error(s) subqueries and 336—339 Error(s) updatable views and 357—358 ERwin Data Modeler (Computer Associates) 738 Essbase XTD (Hyperion) 600 Excel (Microsoft) 577 668 EXCEPT keyword 320 EXISTS operator 228 260 263—264 346 Exit command 381 Extensibility, described 520 Extensibility, OO (object oriented) databases and 520 539 547 549—550 Extensibility, SQL 3 Extensibility, standard and 550 Extensible markup language (XML) 614 648—656 Extensible Markup Language (XML), applications 655—656 Extensible Markup Language (XML), B2B and 619 Extensible Markup Language (XML), DTDs and 650—653 Extensible Markup Language (XML), schema 651—652 Extensible Markup Language (XML), services 656 External model 60—62 Extraction, of data 560 566 extranets 621—622 F — THEN — ELSE loops 359—360 Fact(s) described 585 Fact(s) tables 585 591 593—594 FCHAR data type 236 FETCH command, embedded SQL and 385 FETCH command, Procedural SQL (PIVSQL) and 379 381 Field(s) definitions 16—17 Field(s) described 12 77 Field(s) names 16 Field(s) relational model and 77 Field(s) sample 16 Fifth normal form (1NF) 207 File(s), described 12 File(s), history of databases and 10—13 File(s), systems 10—18 File(s), terminology 12 Filtering data 560 566 Firewalls 634 First normal form (INF) 184 188—191 Flags, described 86 float data type 235 Floor function 350 foreign key constraint 227 239 Foreign key(s), attributes 128 Foreign key(s), constraints 241 Foreign key(s), data redundancy and 104 Foreign key(s), defining 241 271—272 Foreign key(s), described 84 85 Foreign key(s), ER models and 128 134 Foreign key(s), many-to-many relationships and 101 Foreign key(s), one-to-many relationships and 98 Foreign key(s), referential integrity and 84 238 Foreign key(s), relational model and 104 Foreign key(s), rules governing 295 296—297 FORTRAN (FORmula TRANsiation) 14 359 382 forward slash (/) 12 78 361 Fourth normal form (4NF) 184 Fourth-generation languages (4GL) 14 44 Fragmentation, DDBMSs and 473 477 484 Fragmentation, described 492—495 Fragmentation, horizontal 492 493—494 Fragmentation, mixed 492 495 Fragmentation, transparency 483 484 499 Fragmentation, vertical 492 494 FROM clause, computed columns and 256 FROM clause, joins and 286 288 332 FROM clause, subqueries and 337 341—342 344 Fry, J. P. 153 ftp (file transfer protocol) 625 632 Fully heterogeneous DDBMSs 481 (see also DDBMSs (distributed database management systems)) Fully replicated databases 497 (see also Replication) Function(s) (see also Functions (listed by name)) Function(s) conversion 351—353 Function(s) date and time 347—349 Function(s) numeric 350 Function(s) stored 381 Function(s) string 350—351 Functional dependence 80—82 Functions (listed by name) (see also Functions) Functions (listed by name), ABS function 350 Functions (listed by name), AVERAGE function 83 Functions (listed by name), AVG function 228 276—277 280—283 Functions (listed by name), CEIL function 350 Functions (listed by name), DATE function 257 348 Functions (listed by name), DAY function 348 Functions (listed by name), DECODE function 353 Functions (listed by name), FLOOR function 350 Functions (listed by name), LASTJDAY function 349 Functions (listed by name), LENGTH function 351 Functions (listed by name), LOWER function 351 Functions (listed by name), MONTH function 348 Functions (listed by name), NVL function 352 Functions (listed by name), ROUND function 350 Functions (listed by name), SUBSTR function 351 Functions (listed by name), SYSDATE function 257 349 Functions (listed by name), TO.NUMBER function 351 352 Functions (listed by name), TO_CHAR function 348 351 352 Functions (listed by name), TO_DATE function 349 351 Functions (listed by name), TRUNC function 350 Functions (listed by name), UPPER function 262 351 Functions (listed by name), YEAR function 348 G2B (government to business), e-commerce 617 G2C (government to consumer), e-commerce 617 Generalized hierarchy 151 GIS (Geographic Information Systems) 537 582 Global schema, distributed 485 GO/NO GO decision points 400 GRANT command 703 Granularity (level of aggregation) 561—562 563 564 graphical user interfaces (see GUIs (graphical user interfaces)) GROUPBYdause, AVG function and 280—281 GROUPBYdause, described 227 GROUPBYdause, growing phase 454 GROUPBYdause, subqueries and 339 GROUPBYdause, updatable views and 358 GUAM (Generalized Update Access Method) 34 GUIs (graphical user interfaces), database models and 55 GUIs (graphical user interfaces), DDBMSs and 472 GUIs (graphical user interfaces), embedded SQL and 382 GUIs (graphical user interfaces), OLAPand 576 577—579 GUIs (graphical user interfaces), OO (object oriented) databases and 506 GUIs (graphical user interfaces), ROLAP and 582 hackers 634 Hammer, M. 49 Hardware, database models and 44 Hardware, DDBMSs and 477 499 Hardware, failures 458 539 Hardware, independence 59 499 Hardware, OODBMs and 539 Hardware, overview of 19 hardware, requirements 399 418 HAVING clause 227 283—284 339 Heterogeneous DDBMSs 481 (see also DDBMSs (distributed database management systems) Hewlett — Packard 547 Hierarchical data models, advantages/disadvantages of 36—38 Hierarchical data models, described 34—38 56 Hierarchical input process output (HIPO), diagrams 400 Hierarchical path, described 35 Historical accuracy, maintaining 195—196 Homogenous DDBMSs 481 (see also DDBMSs (distributed database management systems)) Homonyms 94 430 Horizontal fragmentation 492 493—494 Host languages, described 382 Host languages, embedded SQL and 382 383 HTML (HyperText Markup Language), ColdFusion and 671 672 HTML (Hypertext Markup Language), described 624 HTML (HyperText Markup Language), e-commerce and 622 624 625 648—649 HTML (HyperText Markup Language), server-side extensions and 664 HTML (HyperText Markup Language), stateless systems and 684 HTML (HyperText Markup Language), Web database development and 664 668 671—672 684 705 HTML (HyperText Markup Language), XML and 648—649 HTTP (Hypertext Transfer Protocol) 624 625 632 669 Hughes Aircraft 154 Hyperion 600 Hyperlinks 624 (see also URLs (Uniform Resource Locators)) I/O (input/output) operations, DDBMSs and 475 I/O (input/output) operations, MFSDand 480 I/O (input/output) operations, normalization and 208 I/O (input/output) operations, performance transparency and 491 IBM (International Business Machines), data warehouses and 600 IBM (International Business Machines), database administration and 735 738 740 IBM (International Business Machines), database models and 34 38 41 IBM (International Business Machines), DBLC and 418 420—421 IBM (International Business Machines), embedded SQL and 382 IBM (International Business Machines), IBM DB 2 41 226 548—549 600 668 IBM (International Business Machines), OO (object oriented) databases and 547 549 IBM (International Business Machines), schema and 231 IBM (International Business Machines), SOM (System Object Model) 547 IBM (International Business Machines), transactions and 441 IC Verify 636 ICAM (integrated computer-aided manufacturing) 154 ICAM (integrated computer-aided manufacturing), DEFIX model 154 156 IE (information engineering) 738 Implementation and loading phase (DBLC) 402 420—424 Implementation, phase {SDLC) 399 400—401 IMS (information management system) 34 38 IN operator, described 228 260 263 IN operator, subqueries and 338—339 Independence {data) 22 36 40 51 Indexes, components of 107 Indexes, composite 242 indexes, creating 242—243 Indexes, described 106 Indexes, OODBMs and 539 Indexes, relational model and 106—107
Ðåêëàìà
|
|
Î ïðîåêòå