---

Designing A Data Warehouse: Supporting Customer Relationship Management

ISBN: 0130897124
EAN: 2147483647

Year: 2000
Pages: 96

Authors: Chris Todman

BUY ON AMAZON

• Starting Page
• Table of Content
• Front Matter
• List of Figures
• Preface
• FIRST GENERATION DATA WAREHOUSES
• SECOND-GENERATION DATA WAREHOUSES AND CUSTOMER RELATIONSHIP MANAGEMENT
• WHO SHOULD READ THIS BOOK
• Acknowledgments
• Chapter 1. Customer Relationship Management
• THE BUSINESS DIMENSION
• BUSINESS GOALS
• BUSINESS STRATEGY
• THE VALUE PROPOSITION
• CUSTOMER RELATIONSHIP MANAGEMENT
• SUMMARY
• Chapter 2. An Introduction to Data Warehousing
• INTRODUCTION
• WHAT IS A DATA WAREHOUSE?
• DIMENSIONAL ANALYSIS
• BUILDING A DATA WAREHOUSE
• PROBLEMS WHEN USING RELATIONAL DATABASES
• SUMMARY
• Chapter 3. Design Problems We Have to Face Up To
• DIMENSIONAL DATA MODELS
• WHAT WORKS FOR CRM
• SUMMARY
• Chapter 4. The Implications of Time in Data Warehousing
• THE ROLE OF TIME
• PROBLEMS INVOLVING TIME
• CAPTURING CHANGES
• FIRST-GENERATION SOLUTIONS FOR TIME
• VARIATIONS ON A THEME
• CONCLUSION TO THE REVIEW OF FIRST-GENERATION METHODS
• Chapter 5. The Conceptual Model
• REQUIREMENTS OF THE CONCEPTUAL MODEL
• THE IDENTIFICATION OF CHANGES TO DATA
• DOT MODELING
• DOT MODELING WORKSHOPS
• SUMMARY
• Chapter 6. The Logical Model
• LOGICAL MODELING
• THE IMPLEMENTATION OF RETROSPECTION
• THE USE OF THE TIME DIMENSION
• LOGICAL SCHEMA
• PERFORMANCE CONSIDERATIONS
• CHOOSING A SOLUTION
• FREQUENCY OF CHANGED DATA CAPTURE
• CONSTRAINTS
• EVALUATION AND SUMMARY OF THE LOGICAL MODEL
• Chapter 7. The Physical Implementation
• THE DATA WAREHOUSE ARCHITECTURE
• CRM APPLICATIONS
• BACKUP OF THE DATA
• ARCHIVAL
• EXTRACTION AND LOAD
• SUMMARY
• Chapter 8. Business Justification
• THE INCREMENTAL APPROACH
• THE SUBMISSION
• SUMMARY
• Chapter 9. Managing the Project
• INTRODUCTION
• WHAT ARE THE DELIVERABLES?
• WHAT ASSUMPTIONS AND RISKS SHOULD I INCLUDE?
• WHAT SORT OF TEAM DO I NEED?
• Summary
• Chapter 10. Software Products
• EXTRACTION, TRANSFORMATION, AND LOADING
• OLAP
• QUERY TOOLS
• DATA MINING
• CAMPAIGN MANAGEMENT
• PERSONALIZATION
• METADATA TOOLS
• SORTS
• Chapter 11. The Future
• TEMPORAL DATABASES (TEMPORAL EXTENSIONS)
• OLAP EXTENSIONS TO SQL
• ACTIVE DECISION SUPPORT
• EXTERNAL DATA
• UNSTRUCTURED DATA
• SEARCH AGENTS
• DSS AWARE APPLICATIONS
• Appendix A. Wine Club Temporal Classifications
• Appendix B. Dot Model for the Wine Club
• APPENDIX B DOT MODEL FOR THE WINE CLUB
• Appendix C. Logical Model for the Wine Club
• Appendix D. Customer Attributes
• HOUSEHOLD AND PERSONAL ATTRIBUTES
• BEHAVIORAL ATTRIBUTES
• FINANCIAL ATTRIBUTES
• EMPLOYMENT ATTRIBUTES
• INTERESTS AND HOBBY ATTRIBUTES
• References