A Complete Guide to DB2 Universal Database

Přední strana obálky
Morgan Kaufmann, 1998 - Počet stran: 816

DB2 Universal Database (UDB) supports many different types of applications, on many different kinds of data, in many different software and hardware environments.

This book provides a complete guide to DB2 UDB Version 5 in all its aspects, including the interfaces that support end users, application developers, and database administrators. It is complementary to the IBM product documentation, providing a clear and informal explanation of how the features of DB2 were intended to be used. It is an extensive revision of the author's earlier book, Using the New DB2: IBM's Object-Relational Database System.

Features:


  • Offers complete and self-contained information, and does not assume prior knowledge of DB2, SQL, or relational database concepts
  • Covers elementary principles of database management as well as the advanced features of UDB, including recursive queries, constraints, triggers, user-defined datatypes, stored procedures, parallel databases, and graphical tools for database administration
  • Includes dozens of practical tips that will save readers many hours of work in developing database applications
  • Provides hundreds of tested examples written in SQL, C, C++, and Java, all of which are available on the MKP web site
 

Vybrané stránky

Obsah

VI
2
VII
4
VIII
5
IX
7
XI
8
XII
12
XIII
15
XIV
17
CLX
383
CLXI
384
CLXII
389
CLXIV
390
CLXV
391
CLXVII
393
CLXIX
394
CLXX
395

XV
18
XVI
20
XVII
22
XVIII
23
XIX
25
XX
26
XXI
27
XXII
28
XXIII
32
XXIV
35
XXV
36
XXVI
39
XXVIII
41
XXIX
43
XXX
44
XXXI
48
XXXII
49
XXXIII
50
XXXIV
56
XXXV
58
XXXVI
60
XXXVII
62
XXXVIII
65
XXXIX
69
XL
71
XLI
73
XLII
74
XLIV
76
XLV
78
XLVI
80
XLVII
81
XLVIII
82
XLIX
83
L
84
LI
86
LII
91
LIII
94
LIV
95
LV
97
LVI
99
LVII
103
LVIII
109
LIX
115
LX
116
LXI
118
LXIII
120
LXVI
122
LXVII
125
LXVIII
131
LXX
132
LXXI
136
LXXII
137
LXXIII
139
LXXIV
141
LXXVI
143
LXXVII
145
LXXVIII
146
LXXX
147
LXXXII
149
LXXXIV
150
LXXXVI
151
LXXXVII
153
LXXXVIII
155
LXXXIX
157
XC
160
XCI
162
XCII
165
XCIII
166
XCIV
167
XCV
168
XCVI
169
XCVII
172
XCVIII
173
XCIX
175
C
184
CI
188
CII
191
CIII
195
CIV
199
CVI
200
CVII
202
CVIII
206
CIX
207
CX
208
CXI
213
CXII
215
CXIII
219
CXIV
221
CXV
228
CXVI
231
CXVII
233
CXVIII
238
CXIX
243
CXX
244
CXXI
247
CXXII
251
CXXIII
254
CXXIV
259
CXXV
271
CXXVII
272
CXXVIII
274
CXXIX
277
CXXX
282
CXXXI
287
CXXXII
290
CXXXIII
292
CXXXIV
296
CXXXVI
299
CXXXVII
302
CXXXVIII
303
CXXXIX
306
CXL
307
CXLI
310
CXLIII
313
CXLIV
319
CXLV
328
CXLVI
331
CXLVII
341
CXLVIII
343
CXLIX
349
CL
358
CLI
365
CLII
367
CLIII
369
CLIV
370
CLV
372
CLVI
373
CLVII
380
CLVIII
381
CLXXI
400
CLXXIII
401
CLXXIV
408
CLXXV
410
CLXXVI
414
CLXXVII
416
CLXXVIII
417
CLXXIX
418
CLXXX
422
CLXXXI
427
CLXXXII
431
CLXXXIII
432
CLXXXIV
434
CLXXXV
452
CLXXXVI
453
CLXXXVII
455
CLXXXVIII
461
CXC
462
CXCI
464
CXCII
465
CXCIII
466
CXCIV
471
CXCV
472
CXCVI
482
CXCVII
498
CXCVIII
502
CXCIX
507
CC
514
CCI
519
CCII
526
CCIII
530
CCIV
534
CCV
539
CCVI
551
CCVIII
552
CCIX
553
CCX
558
CCXI
559
CCXII
565
CCXIII
566
CCXIV
567
CCXV
572
CCXVI
576
CCXVII
579
CCXIX
580
CCXX
586
CCXXI
587
CCXXII
589
CCXXIII
591
CCXXIV
596
CCXXV
599
CCXXVI
603
CCXXVIII
604
CCXXX
607
CCXXXI
608
CCXXXII
613
CCXXXIII
620
CCXXXIV
624
CCXXXV
625
CCXXXVI
626
CCXXXVII
627
CCXXXVIII
628
CCXXXIX
630
CCXL
632
CCXLI
633
CCXLII
635
CCXLIII
642
CCXLIV
643
CCXLV
644
CCXLVI
645
CCXLVII
646
CCXLVIII
649
CCXLIX
653
CCL
656
CCLI
659
CCLIII
660
CCLIV
662
CCLV
667
CCLVI
670
CCLVII
674
CCLIX
676
CCLX
680
CCLXI
683
CCLXIII
687
CCLXIV
688
CCLXV
690
CCLXVI
706
CCLXVII
709
CCLXVIII
713
CCLXIX
714
CCLXXII
715
CCLXXIV
716
CCLXXV
717
CCLXXVII
718
CCLXXVIII
720
CCLXXIX
721
CCLXXX
722
CCLXXXII
724
CCLXXXIV
725
CCLXXXV
729
CCLXXXVII
731
CCLXXXVIII
732
CCXC
733
CCXCI
734
CCXCIII
737
CCXCV
739
CCXCVI
740
CCXCVII
741
CCXCVIII
742
CCC
743
CCCI
744
CCCII
747
CCCIII
748
CCCIV
749
CCCV
750
CCCVII
751
CCCVIII
752
CCCX
753
CCCXI
754
CCCXII
755
CCCXIII
757
CCCXIV
758
CCCXV
759
CCCXVI
761
CCCXVIII
762
CCCXIX
765
CCCXXI
767
CCCXXII
769
Autorská práva

Běžně se vyskytující výrazy a sousloví

access plan application program argument backup bytes called catalog table char check constraint clause client Clob column names command configuration connection constraint contains Control Center CREATE TABLE cursor database administrator database system Decimal DECLARE SECTION default defined DELETE deptno described in Section descriptor distinct type dynamic SQL example EXEC SQL executed external function FETCH foreign key GROUP hdbc host variable indicator indicator variable input INSERT Integer interface invoke Java JDBC length locator node nodegroup null value object operators optimizer option package parameter markers partitioning partno precompiler primary key privilege query optimization recursive referential integrity result set rows schema name scratchpad SELECT server Smallint specify SQL statement SQLCA SQLCODE SQLDA SQLSTATE static SQL stored procedure strcpy string subquery syntax SYSFUN SYSIBM table function table named TABLE statement tablespace Timestamp tion transaction trigger UPDATE user-defined Varchar Vargraphic VisualAge

Oblíbené pasáže

Strana ii - Interfaces, & the Incremental Approach Michael L. Brodie and Michael Stonebraker Atomic Transactions Nancy Lynch, Michael Merritt, William Weihl, and Alan Fekete Query Processing for Advanced Database Systems Edited by Johann Christoph Freytag, David Maier, and Gottfried Vossen Transaction Processing: Concepts and Techniques Jim Gray and Andreas Reuter Understanding the New SQL: A Complete Guide Jim Melton and Alan R.‎
Objevuje se u 62 knih od 1993-2006.
Strana ii - Advanced Database Systems Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, VS Subrahmanian, and Roberto Zicari Principles of Transaction Processing Philip A. Bernstein and Eric Newcomer Using the New DB2: IBM's ObjectRelational Database System Don Chamberlin Distributed Algorithms Nancy A.‎
Objevuje se u 43 knih od 1995-2006.

Odkazy na tuto knihu

O autorovi (1998)

Don Chamberlin is a member of the DB2 development team at the IBM Almaden Research Center, and an adjunct professor of computer engineering at Santa Clara University. Dr. Chamberlin is co-inventor of the original SQL database language. He is an ACM Fellow, a member of the National Academy of Engineering and holds a Ph.D. in electrical engineering from Stanford University.

Bibliografické údaje

NázevA Complete Guide to DB2 Universal Database
The Morgan Kaufmann Series in Data Management Systems
AutorDon Chamberlin
VydavatelMorgan Kaufmann, 1998
ISBN1558604820, 9781558604827
DélkaPočet stran: 816
  
Exportovat citaciBiBTeX EndNote RefMan