Oracle8i Data Warehousing
Michael Corey, Michael Abbey, Ian Abramson, Ben Taub
Résumé
- Plan, implement, and manage a data warehouse project
- Build star schemas and design data marts
- Set up a data warehouse using Oracle8i as its repository
- Extract, transform, and load data using the Oracle Warehouse Builder
- Index your data warehouse for optimal access
- Manage storage and handle backup, recovery, tuning, and security
- Enable data warehouse querying and analysis with Oracle Discoverer and Oracle Express
- Convert a legacy database system into an Oracle8i data warehouse
- Implement data webhousing to enable access via an intranet or the Internet
Contents
- 1. Warehouse: What Is It, Who Needs It, and Why?
- 2. Things to Consider
- 3. Finding and Building the Team
- 4. Managing the Data Warehouse Project
- 5. Data Warehouse Design Methodology
- 6. Data Warehouse Development Methodology
- 7. Data Marts and Star Schema Design
- 8. The Physical Data Warehouse
- 9. Fundamentals of an ETL Architecture
- 10. Loading the Oracle Warehouse
- 11. Oracle Warehouse Builder
- 12. Partitioning Data
- 13. Indexing the Warehouse
- 14. Backing up the Warehouse
- 15. Securing the Warehouse
- 16. Storage Considerations
- 17. Tuning Data Access
- 18. Publishing Data for the Users
- 19. Oracle Summarization Features
- 20. OLAP
- 21. Relational OLAP and Aggregate Navigators
- 22. The Oracle Discoverer Solution
- 23. The Oracle Express Solution
- 24. Data Mining
- 25. Data Webhousing
- Index
L'auteur - Michael Corey
Michael J. Corey (Newton, MA) is co-owner of Database Technologies, former president of IOUG-A, and has more than 12 years experience using Oracle products. He has garnered a huge following in the Oracle Community and is considered to have the ear of the Oracle Corporation by the community.
L'auteur - Michael Abbey
is a successful author, and has co-written five works in the Oracle Press series. Michael's thirst for knowledge about Oracle the company and the software has been fueled by 11 years of exposure. He is a frequent presenter at conferences throughout the user community, and has become a point of contact for users around the world. His forte is performance tuning, disaster recovery, and instance management. His passion for Pink Floyd and Boston almost, but not quite, exceeds that for Oracle, with which he is comfortably numb. Michael can be reached via email at masint@istar.ca most any time of the day or night.
L'auteur - Ian Abramson
Ian Abramson (Toronto, Ontario) is the principal at IAS Inc., in Toronto, CA, and is currently the Director of Education Programming for IOUG-A and specializes in building applications and data warehousing.
L'auteur - Ben Taub
Ben Taub (Ann Arbor, MI) is a Project Manager/Senior Warehouse architect with Dataspace Incorporated, as well as founder of the firm. He is the data warehousing focus area manager for IOUG-A.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Mc Graw Hill |
| Auteur(s) | Michael Corey, Michael Abbey, Ian Abramson, Ben Taub |
| Parution | 01/01/2001 |
| Nb. de pages | 831 |
| Format | 18,6 x 23 |
| Couverture | Broché |
| Poids | 1656g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780072126754 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
