High Performance Relational Database Design

Available through our Marketplace sellers.
Other sellers (Hardcover)
  • All (7) from $2.48   
  • New (1) from $124.9   
  • Used (6) from $2.48   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$124.90
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(194)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0130301981 New. Looks like an interesting title!

Ships from: Naperville, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Product Details

Table of Contents

1 Introduction 1
2 Relational model 7
Historical perspective 8
Three schema architecture 15
Performance design strategy 17
Relational model 19
Structure component 20
Manipulation component 23
Integrity component 25
3 Physical design: general concepts 43
Role of logical model 44
Other logical models 46
Performance objectives 50
Macro design criteria 52
System configuration 55
Memory sizing 55
4 Mapping entities to tables 61
Storage structures 62
Heap storage 63
Sequenced storage 66
Row sizes 69
Fillfactor 70
Collocation in a page 71
Segmentation 73
Placement on disk 77
Storage methods: summary of techniques 81
5 Mapping keys to indexes 83
Hashing 85
Hashing collisions 86
Random distribution 93
B-tree 93
Linked pointers 101
Summary of usage 103
First cut physical design worked example 105
6 Recovery and locking 117
Recovery 118
Media failure 118
System failure 121
Dump and restore 126
Concurrency control and locking 128
Contention resolution 135
Deadlock 135
Demand locking 136
Read consistency 137
7 Denormalisation and overnormalisation 141
Denormalisation 142
Duplicated data 143
Derived data 146
Surrogate keys 149
Vector data 154
Denormalisation summary 156
Overnormalisation 158
Table segmentation 165
Database segmentation 166
Overnormalisation summary 168
8 Optimiser and index selection 175
Examples 178
Search arguments 181
Example 183
OR strategy 192
Join clauses 194
Join strategy 196
Nested iteration 196
Reformatting 200
Statistics 205
Density 207
Optimiser assists 208
9 Sybase 213
Architecture 214
Storage structure and indexing 218
Index structure 220
Page/node splitting 228
Fillfactor 223
Index summary 223
Optimiser 226
Single table plans 227
OR strategy 228
Join strategy 229
Statistics 230
Locking 231
Answers to selected questions 235
Bibliography 261
Index 265
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)