tailieunhanh - Database Design for Real-World

This paper discusses the structure and components of databases for real-world e-commerce systems. We first present an integrated 8-process value chain needed by the e-commerce system and its associated data in each stage of the value chain. We then discuss logical components of a typical e-commerce database system. Finally, we illustrate a detailed design of an e-commerce transaction processing system and comment on a few design considerations specific to e-commerce database systems, such as the primary key, foreign key, outer join, use of weak entity, and schema partition. Understanding the structure of ecommerce database systems will help database designers effectively develop and maintain e-commerce systems | Database Design for Real-World E-Commerce Systems Il-Yeol Song College of Inf. Science and Technology Drexel University Philadelphia PA 19104 song@ Kyu-Young Whang Department of EE and CS Korea Adv. Inst. of Science and Technology KAIST and Adv. Information Technology Research Ctr AITrc Taejeon Korea kywhang@ Abstract This paper discusses the structure and components of databases for real-world e-commerce systems. We first present an integrated 8-process value chain needed by the e-commerce system and its associated data in each stage of the value chain. We then discuss logical components of a typical e-commerce database system. Finally we illustrate a detailed design of an e-commerce transaction processing system and comment on a few design considerations specific to e-commerce database systems such as the primary key foreign key outer join use of weak entity and schema partition. Understanding the structure of ecommerce database systems will help database designers effectively develop and maintain e-commerce systems. 1 Introduction In this paper we present the structure and components of databases for real-world e-commerce systems. In general an e-commerce system is built by following one of two approaches. The first approach is the customization approach using a suite of tools such as IBM s WebSphere Commerce Suite Shur99 . For example the Commerce Suite provides tools for creating the infrastructure of a virtual shopping mall including catalog templates registration shopping cart order and payment processing and a generalized database. The second approach is the bottom-up development of a system in-house by experts of an individual company. In this case the developer is manually building a virtual shopping mall with mix-and-match tools. In addition a database supporting the business model of the e-commerce system must be manually developed. Whether a developer is using the customization or the bottom-up approach understanding the .