Home Page Icon
Home Page
Table of Contents for
Dot Model for the Wine Club
Close
Dot Model for the Wine Club
by Chris Todman
Designing a Data Warehouse: Supporting Customer Relationship Management
Copyright
List of Figures
Preface
Acknowledgments
Customer Relationship Management
THE BUSINESS DIMENSION
BUSINESS GOALS
BUSINESS STRATEGY
THE VALUE PROPOSITION
CUSTOMER RELATIONSHIP MANAGEMENT
SUMMARY
An Introduction to Data Warehousing
INTRODUCTION
WHAT IS A DATA WAREHOUSE?
DIMENSIONAL ANALYSIS
BUILDING A DATA WAREHOUSE
PROBLEMS WHEN USING RELATIONAL DATABASES
SUMMARY
Design Problems We Have to Face Up To
DIMENSIONAL DATA MODELS
WHAT WORKS FOR CRM
SUMMARY
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
The Conceptual Model
REQUIREMENTS OF THE CONCEPTUAL MODEL
THE IDENTIFICATION OF CHANGES TO DATA
DOT MODELING
DOT MODELING WORKSHOPS
SUMMARY
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
The Physical Implementation
THE DATA WAREHOUSE ARCHITECTURE
CRM APPLICATIONS
BACKUP OF THE DATA
ARCHIVAL
EXTRACTION AND LOAD
SUMMARY
Business Justification
THE INCREMENTAL APPROACH
THE SUBMISSION
SUMMARY
Managing the Project
INTRODUCTION
WHAT ARE THE DELIVERABLES?
WHAT ASSUMPTIONS AND RISKS SHOULD I INCLUDE?
WHAT SORT OF TEAM DO I NEED?
Summary
Software Products
EXTRACTION, TRANSFORMATION, AND LOADING
OLAP
QUERY TOOLS
DATA MINING
CAMPAIGN MANAGEMENT
PERSONALIZATION
METADATA TOOLS
SORTS
The Future
TEMPORAL DATABASES (TEMPORAL EXTENSIONS)
OLAP EXTENSIONS TO SQL
ACTIVE DECISION SUPPORT
EXTERNAL DATA
UNSTRUCTURED DATA
SEARCH AGENTS
DSS AWARE APPLICATIONS
Wine Club Temporal Classifications
Dot Model for the Wine Club
APPENDIX B DOT MODEL FOR THE WINE CLUB
Logical Model for the Wine Club
Customer Attributes
HOUSEHOLD AND PERSONAL ATTRIBUTES
BEHAVIORAL ATTRIBUTES
FINANCIAL ATTRIBUTES
EMPLOYMENT ATTRIBUTES
INTERESTS AND HOBBY ATTRIBUTES
References
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Wine Club Temporal Classifications
Next
Next Chapter
APPENDIX B DOT MODEL FOR THE WINE CLUB
Appendix B. Dot Model for the Wine Club
APPENDIX B DOT MODEL FOR THE WINE CLUB
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset