Title:
Distributed data warehousing using web technology : how to build a more cost-effective and flexible warehouse
Personal Author:
Publication Information:
New York : Amacom, 2001
ISBN:
9780814405888
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000004455568 | QA76.9.D37 M64 2001 | Open Access Book | Book | Searching... |
Searching... | 30000004789990 | SPSKD QA76.9.D37 | Open Access Book | Book | Searching... |
Searching... | 30000004455600 | QA76.9.D37 M64 2001 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
This text presents an overview of what's required to set up and use a distributed data warehouse. It includes topics such as, basic functions and benefits, Web-enabling computing technologies, and a full idea of what a data warehouse can deliver.
Table of Contents
Preface | p. xi |
Acknowledgments | p. xiii |
1. Introduction | p. 1 |
A Brief History of Data Warehousing | p. 2 |
What Is a Data Warehouse? | p. 5 |
Pressure to Distribute Data | p. 8 |
Data Mart Issues | p. 16 |
The Web and Other Emerging Technologies | p. 22 |
In Brief | p. 27 |
2. Data Warehouse Architecture | p. 29 |
Role of a Data Warehouse | p. 32 |
Data Warehouse Definition | p. 34 |
Traditional Data Warehouse Architecture | p. 45 |
Challenges of a Centralized Data Warehouse | p. 58 |
Distributed Data Warehouse Architecture | p. 63 |
Challenges of a Distributed Data Warehouse | p. 75 |
What to Choose | p. 80 |
3. Data Placement in Distributed Warehouses--Distribution and Transformation | p. 83 |
The Data Placement Problem | p. 83 |
A Practical Approach to the Placement Problem | p. 88 |
Integration of Diverse Database Systems | p. 98 |
The Global Data Model | p. 102 |
What to Remember | p. 109 |
4. Concurrency Control in Distributed Warehouses | p. 115 |
Transactions | p. 117 |
Interference between Concurrent Transactions | p. 122 |
Schedules and Serialization | p. 126 |
Concurrency Control Techniques | p. 132 |
Special Case Concurrency Control | p. 147 |
Data Warehousing and Concurrency Control | p. 153 |
5. The Web and the Data Warehouse | p. 159 |
Emerging Trends | p. 161 |
Intranet Basics | p. 167 |
The Advantages of Intranets and Data Warehousing | p. 174 |
The Challenges of Intranets and Data Warehousing | p. 176 |
Common Gateway Interfaces | p. 180 |
The Future of Web-Enabled Data Warehousing | p. 184 |
6. Data Marts | p. 187 |
Data Mart Solutions | p. 188 |
What Is a Data Mart? | p. 189 |
Implementing a Data Mart | p. 201 |
Data Mart Architecture | p. 208 |
The Future of Data Marts | p. 216 |
7. Object Technologies | p. 219 |
Object-Oriented Technologies | p. 220 |
Distributed Object Computing | p. 226 |
ORB Architecture | p. 230 |
Standards | p. 232 |
Data Warehouses and Object Technologies | p. 234 |
Extended Relational Database Management Systems | p. 235 |
In Brief | p. 236 |
8. Security Issues for the Distributed Data Warehouse | p. 239 |
Key Concepts of Security Planning | p. 242 |
Network Security Issues | p. 248 |
Overview of Network Architecture | p. 252 |
Common Gateway Interface (CGI) | p. 259 |
Managing Security | p. 262 |
9. Tools for Distributed Warehouse and Web Security | p. 265 |
Firewalls | p. 266 |
Encryption | p. 270 |
Authentication Services | p. 279 |
Secure Sockets Layer/Transport Layer Security | p. 284 |
Internet Protocol Security | p. 287 |
Virtual Private Networks | p. 289 |
Browser Security Options | p. 293 |
Host Security | p. 295 |
Final Thoughts | p. 298 |
10. Implementing a Distributed Data Warehouse | p. 301 |
Overview | p. 302 |
Data Marts | p. 303 |
To Be Considered | p. 306 |
Pitfalls | p. 312 |
Business Factors | p. 316 |
Implementation Plan | p. 319 |
Final Considerations | p. 324 |
11. Future Developments | p. 327 |
Evolution | p. 328 |
Intelligent Distributed Systems | p. 333 |
The Economic Reality of the Web | p. 340 |
The New Paradigm | p. 344 |
Conclusions | p. 346 |
Glossary | p. 349 |
Index | p. 375 |