Авторизация
Поиск по указателям
Rob P., Coronel C. — Database systems: Design, Implementation, and Management
Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: 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
Предметный указатель
%(percent sign) 261
'(apostrophe) 244
()(parentheses) 244 258 259
*(asterisk) 78 246 261 277
,(comma) 244 273
-(dash) 17 78 372
. (period) 78
/(forward slash) 12 78 361 0
:(colon) 382 383
; (semicolon) 231 238
? (question mark) 261
ABORT message 490
abs function 350
Abstract data types (ADTs), binding and 532
Abstract data types (ADTs), columns and 540
Abstract data types (ADTs), defining 522—523
Abstract data types (ADTs), described 79 519
Abstract data types (ADTs), encapsulation and 534
Abstract data types (ADTs), increase in semantic content of objects due to 534
Abstract data types (ADTs), OO (object oriented) databases and 519 522—523 532 534 546
Abstract data types (ADTs), relational modei and 79
Abstraction, degrees of 55—57
ACCESS (see also Access rights)
Access (Microsoft), AutoNumber feature 535
Access (Microsoft), case-sensitivity and 262
Access (Microsoft), COMMIT command and 246
Access (Microsoft), computed columns and 256—257
Access (Microsoft), constraints and 240
Access (Microsoft), COUNT function and 277
Access (Microsoft), creating databases and 231
Access (Microsoft), creating tables and 271
Access (Microsoft), data dictionaries and 21
Access (Microsoft), data sets and 76
Access (Microsoft), data types and 235 236
Access (Microsoft), dates and 79 232 348
Access (Microsoft), DBLC and 418
Access (Microsoft), embedded SQL 382
Access (Microsoft), joins and 290 291
Access (Microsoft), naming conventions and 78
Access (Microsoft), OO (object oriented) databases and 535
Access (Microsoft), relational modei and 76 78—79
Access (Microsoft), relational set operators and 321
Access (Microsoft), ROLLBACK command and 248
Access (Microsoft), sequences and 353
Access (Microsoft), SQL and 226
Access (Microsoft), transactions and 441
Access (Microsoft), views and 284 357
Access (Microsoft), Web database development and 668 677—674
Access (Microsoft), wildcard characters and 261
access rights (see also Access)
Access rights, assignment of 422 423 425
Access rights, DBLC and 422 423
Access rights, DDBMSs and 482
Access rights, passwords and 423
access, management 23 725—726
Access, OO (object oriented) databases and 535—536
Access, set-oriented 535—536
Active Server Pages (see ASP (Active Server Pages))
ActiveX controls (Microsoft) 669—670
Ad hoc queries, described 7
Ad hoc queries, models and 43
Ada, embedded SQL and 382
Ada, OO (object oriented) databases and 506
Adaptive maintenance 401 425
Adaptive maintenance, CASE tools and 736—738
Adaptive maintenance, described 710—759
Adaptive maintenance, evolution of 715—718
Adaptive maintenance, human component of 719—733
Adaptive maintenance, strategies 738—740
Adaptive maintenance, tools 734—738
Adding columns with 264 265—266
Adding columns with described 264
Adding columns with reestablishing integrity rules with 271
ADTs (abstract data types), binding and 532
ADTs (abstract data types), columns and 540
ADTs (abstract data types), defining 522—523
ADTs (abstract data types), described 79 519
ADTs (abstract data types), encapsulation and 534
ADTs (abstract data types), increase in semantic content of objects due to 534
ADTs (abstract data types), OO (object oriented) databases and 519 522—523 532 534 546
ADTs (abstract data types), relational model and 79
Aggregate functions 276—280
Aggregation, data warehouses and 591 593
Aggregation, level of (granularity) 561—562 563 564
Aggregation, problems 430
Air Force (United States) 154
Algol 506
Algorithms, concurrency control 424
Algorithms, data allocation 498
Algorithms, query optimization and 491 92
Aliases, column 256—257 344
Aliases, described 256
Aliases, joins and 288 289
Aliases, subqueries and 344
all operator 340
Allocation, data 497—498
ALTER TABLE command 227
Amazon.com 615 617
American National Standards Institute (see ANSI (American National Standards Institute))
American Standard Code for Information Interchange (see ASCII (American Standard Code for Information Interchange))
Ameritech 537
Analysis (see also analysis phase (SDLQ))
Analysis phase (SDLC) (see also Analysis)
Analysis phase (SDLC), DBLC and 402 03 408—410
Analysis phase (SDLC), described 399—400
Analysis phase (SDLC), requirements and 408—410
Analysis, data mining and 599—600
Analysis, data warehouses and 558—559
Analysis, e-commerce and 627
Analysis, need for 558—559
Analysis, techniques, multidimensional 573—574
Analysis, use of the term 402
Analytical processing logic 576 577—579 582
AND operator, Boolean algebra and 260
AND operator, described 228 258—260
AND operator, joins and 328
Anomalies, data redundancy and 104
Anomalies, described 18
Anomalies, modification 18
Anomalies, normalization and 187
ANSI (American National Standards Institute) (see also ANSI SQL standards)
ANSI (American National Standards institute), date data types and 347
ANSI (American National Standards institute), OO (object oriented) databases and 536
ANSI (American National Standards institute), outer joins and 332
ANSI (American National Standards institute), relational set operators and 332
ANSI (American National Standards institute), SPARC (Standards Planning and Requirements Committee) 39 55
ANSI (American National Standards institute), transactions and 442—443
ANSI (American National Standards institute), Web site 320
ANSI SQL standards 231—236 239 295 328 442—443
any operator 340
AP (application processor) 477
APIs (application programming interfaces), embedded SQL and 382
APIs (application programming interfaces), ISAPI (Internet Server API) 666
APIs (application programming interfaces), NSAPI (Netscape API) 666
APIs (application programming interfaces), Web database development and 665—666
APIs (application programming interfaces), Web servers and 666 668
Apollo project 34
Apostrophe ( 1 244
Appiication(s) (see also Software)
Appiication(s) operation of 731—733
Appiication(s) overview of 20
Appiication(s) programming interfaces (APIs) 382 665—666 668
Appiication(s) testing and 731
Apple Computer 547
arithmetic operators 257—258
ASCII (American Standard Code for Information Interchange) case-sensitivity and 262
ASCII (American Standard Code for Information Interchange) comparison operators and 254
ASCII (American Standard Code for Information Interchange) SQL and 254—255 262
ASP (Active Server Pages) 381 382
Associated, class links 525—531
Associated, composite 127 522
Associated, database models and 31 46 77 78
Associated, derived 130 522 585—588
Associated, described 31
Associated, domains 77
Associated, ER models and 124—125 127—130
Associated, hierarchy 588—590
Associated, multivalued 127—130 509
Associated, names 78 414
Associated, nonkey 199
Associated, normalization and 191—193
Associated, OO (object oriented) databases and 508—509
Associated, relational model and 77 78
Associated, representing relationships with 529—531
Associated, simple 127
Asterisk 78 246 261 277
Atkinson, Malcolm 538
ATMs (Automatic teller machines) 614
Atomic property 195 442 458 561
Attribute(s) adding 195
Auditing, database administration and 726
Auditing, DBLC and 423 425
Auditing, SDLC and 399
Authentication 231 629—630
Authorization management 725—726
Automatic query optimization 491
AutoNumber data type 101 353
AutoNumber feature 535
AVERAGE function 83
AVG function 228 276—277 280—283
B2B (business to business) e-commerce 617—620 628 655
B2B2C (business to business to consumer) e-commerce 621
B2C (business to consumer) e-commerce 617 621
BaBar Physics experiment 537
Bachman, C. W. 153
Backups (see also Recovery)
Backups, concurrent 727
Backups, database administration and 724—727 729 732
Backups, DBLC and 423 425
Backups, DDBMSs and 476
Backups, described 23 458 727
backups, differential 458
Backups, full 458 727
Backups, incremental 727
Backups, levels of 458
Backups, maintenance phase and 425
Backups, physical storage of 458
backups, Transaction Log 458
Base, data types 508 531 546 547
Base, tables 284
BASIC (Beginner’s All-purpose Symbolic Instruction Code) 14
Batch update routines 356
Bay Networks 537
BCNF (Boyce — Codd normal form) 199—201
Begin clause, OO (object oriented) databases and 541
Begin clause, Procedural SQL (PL/SQL) and 361
Begin clause, transactions and 443
Begin keyword 366 379 383
Begin WORK transaction format 485 488
Beginner’s All-purpose Symbolic Instruction Coda See BASIC (Beginner’s All-purpose Symbolic Instruction Code) BETWEEN Operator 228 260
Bezos, Jeff 615
Binding, early 531—533
Binding, late 531—533
Binding, premature 539
Blank spaces 82
Boolean algebra 260
Bottlenecks 425
Boundaries, defining 405—406
Boyce-Codd normal form (see BCNF (Boyce-Codd normal form))
Bridge (composite) entities 101 147—150 411 545
Browsers (see also Internet Explorer)
Browsers, browser (Microsoft) communication interfaces and 24
Browsers, described 624
Browsers, e-commerce and 622 624 653—655
Browsers, proxy settings 634—635
Browsers, stateless systems and 683—684
Browsers, Web database development and 668—670 683—684
Browsers, Web servers and 668
browsers, XML and 653—655
Business Intelligence Series (Cognos) 600
Business rules (see also Rules)
Business rules, cardinality and 132
Business rules, connectivity and 132
Business rules, database models and 229
Business rules, DBLC and 409—410
Business rules, described 32—33 409
Business rules, ER models and 132
Business rules, SQL and 229
Business, logic 364
Business, managers 406
C (high-level language) 359
C++ (high-level language), embedded SQL and 381 382
C++ (high-level language), OO (object oriented) databases and 506 540
C++ (high-level language), OODBMs and 540
C++ (high-level language), Web database development and 666 672
C2B2C (consumer to business to consumer) e-commerce 621
C2C (consumer to consumer) e-commerce 617
CACHE clause 353
Caching 547 627
CAD (computer-aided design), MOLAP and 582
CAD (computer-aided design), OO (object oriented) databases and 533 537 540 547 550
CAD (computer-aided design), versioning and 533
CAM (computer-aided manufacturing), MOLAP and 582
CAM (computer-aided manufacturing), OO (object oriented) databases and 533 540 547 550
Candidate keys, cardinality 131
Candidate keys, described 85
Candidate keys, one-to-many relationships and 98
Candidate keys, relational model and 82 85
Cartesian products 287 328 329
CAs (certification authorities) 630 632
Cascading order sequence 273
CASE (computer-assisted systems engineering), tools 153 401 537 736—738
case sensitivity 261—262
CEIL function 350
central processing units (see CPUs (central processing units))
Centralized, data allocation 497 98
Centralized, databases, described 8
certificates, digital 630
CFML (ColdFusion Markup Language) 671 (see also ColdFusion)
CGI (Common Gateway Interface) scripts 665—666 668
CHAR data type, described 235
CHAR data type, Procedural SQL (PL/SQL) and 363
CHAR data type, relational set operators and 320
CHAR data type, SQL and 232—236 363
Character data, described 79 (see also CHAR data type)
CHECK constraint, described 227 240
CHECK constraint, validating dates with 241
checkpoints 459
Chen ER model 46 48 142—143
Chen ER model, attributes and 127
Chen ER model, composite entities and 147—149
Chen ER model, described 153
Chen ER model, multivalued attributes and 128
Chen ER model, supertype/subtype relationships and 159
Chen ER model, symbols 154
Chen ER model, weak entities and 140
Chen ER model, weak relationships and 133
Chen, Peter 153 (see also Chen ER model)
Class(es), attribute-class links and 525—531
Class(es), characteristics of 527
Class(es), described 50 511
Class(es), hierarchy 50 514 517—519 524—527
Class(es), methods 514 519
Class(es), OO (object oriented) databases and 511—512 517—517 525—531 534 539
Class(es), reusability of 547
Class(es), sub 514—517 524—525
Class(es), super 514—517 525
client-side extensions 669—670
client/server computing 575—576 581 583
Client/server computing, advantages of 498
Реклама