The data warehouse ebusiness DBA handbook

Cover......Page 1
Table Of Contents......Page 6
Conventions Used in this Book......Page 11
About the Authors......Page 13
Foreword......Page 15
Making the Most of E- business......Page 17
The Data Warehouse Foundation......Page 25
References......Page 34
Why the Internet?......Page 35
Intelligent Messages......Page 36
Integration, History and Versatility......Page 37
The Value of Historical Data......Page 38
Integrated Data......Page 39
Looking Smarter......Page 42
The Classic Role of the DBA......Page 44
The Trend of Storing Process With Data......Page 46
Database Code Objects and e- Business......Page 48
Database Code Object Programming Languages......Page 50
The Duality of the DBA......Page 51
The Role of the Procedural DBA......Page 53
Synopsis......Page 54
Introduction......Page 55
Data Volume......Page 56
Frequency......Page 57
Conclusion......Page 58
Data Modeling and Database Design......Page 59
Physical Database Design......Page 61
The DBA Management Discipline......Page 62
The 17 Skills Required of a DBA......Page 63
Meeting the Demand......Page 67
Living at Web Speed......Page 68
Database Design Steps......Page 70
Database Design Traps......Page 73
Taming the Hostile Database......Page 75
E- Business and Infrastructure......Page 77
Environment......Page 84
The Issues of the E- Business Infrastructure......Page 93
Large Volumes of Data......Page 95
Performance......Page 99
Integration......Page 101
Addressing the Issues......Page 103
Data Quality Problems in the Real World......Page 104
Why Data Quality Problems Go Unresolved......Page 105
Fraudulent Data Quality Problems......Page 106
The Seriousness of Data Quality Problems......Page 107
Option 1: Integrated Data Warehouse......Page 108
Periodic sampling averts future disasters......Page 110
Conclusion......Page 112
" Just the Facts, Ma'am"......Page 113
Modeling Atomic Data......Page 114
Areas Are Accumulated......Page 116
Other Possibilities -- - Generic Data Models......Page 119
Development to the Next......Page 120
Interacting with the Internet Viewer......Page 121
IN SUMMARY......Page 129
Historically Speaking......Page 130
At the Price Breaking Point......Page 132
How Good Are the Numbers......Page 133
How Elastic Is the Price......Page 134
Conclusion......Page 136
What is Java?......Page 137
Why is Java Important to an eDBA?......Page 138
How can Java improve availability?......Page 139
How Will Java Impact the Job of the eDBA?......Page 140
Resistance is Futile......Page 143
Conclusion......Page 144
What is XML?......Page 145
Some Skepticism......Page 148
Integrating XML......Page 149
Defining the Future Web......Page 150
MultiValue Lacks Value......Page 152
References......Page 160
Data Security Internals......Page 162
Traditional Oracle Security......Page 163
Concerns About Role- based Security......Page 166
Closing the Back Doors......Page 167
Oracle Virtual Private Databases......Page 168
Procedure Execution Security......Page 174
Conclusion......Page 176
eDBA: Online Database Reorganization......Page 178
Reorganizing Tablespaces......Page 182
Online Reorganization......Page 183
Synopsis......Page 184
The eDBA and Data Availability......Page 186
What is Implied by e- vailability?......Page 187
The Impact of Downtime on an e- business......Page 191
Conclusion......Page 192
The eDBA and Recovery......Page 193
eDatabase Recovery Strategies......Page 195
Recovery- To- Current......Page 197
Point- in- Time Recovery......Page 199
Transaction Recovery......Page 200
Choosing the Optimum Recovery Strategy......Page 204
Reducing the Risk......Page 205
Intelligent Automation of DBA Tasks......Page 207
Duties of the DBA......Page 208
A Lot of Effort......Page 210
Intelligent Automation......Page 211
Synopsis......Page 212
Usenet Newsgroups......Page 213
Mailing Lists......Page 216
Websites and Portals......Page 217
No eDBA Is an Island......Page 219