Enterprise success depends on the ability to efficiently understand and timely response to customer consumption behavior. Database marketing is to analyze customer consumption messages obtained from the customer transaction database, and development of marketing strategies and related activities. This work comprises a case study of Company Z. Based on the firm business and data characteristics, this work first provides the process and steps involved in devising database marketing strategies, as well as the architecture of the database marketing model. The architecture uses a mixture of clustering analysis and sequential pattern to process customer segmentation and product categorization, respectively. This work not only presents a measurement of customer loyalty and studies how price and promotion activities affect the customer; but also analyses the experimental results as reference of advanced marketing strategy. We believe that segmentation analysis and using different marketing strategies based on clusters can improve customer loyalty.