Đang chuẩn bị liên kết để tải về tài liệu:
Database Modeling & Design Fourth Edition- P41

Database Modeling & Design Fourth Edition- P41: Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems. While many specialized database systems (object-oriented, spatial, multimedia, etc.) have found substantial user communities in the science and engineering fields, relational systems remain the dominant database technology for business enterprises. | CASE Tools for Logical Database Design Database design is just one part of the analysis and design phase of creating effective business application software see Figure 9.1 but it is often the part that is the most challenging and the most critical to performance. In the previous chapters we explored the classic ways of creating efficient and effective database designs including ER modeling and the transformation of the ER models into constructs by transformation rules. We also examined normalization normal forms and denormalization and specific topologies used in warehousing such as star schema. All this information may leave your head spinning This chapter focuses on commercially available tools to simplify these design processes. These computer-aided system engineering or CASE tools provide functions that assist in system design. CASE tools are widely used in numerous industries and domains such as circuit design manufacturing and architecture. Logical database design is another area where CASE tools have proven effective. This chapter explores the offerings of the major vendors in this space IBM Computer Associates and Sybase. Each of these companies offers powerful featurerich technology for developing logical database designs and transitioning them into physical databases you can use. Although it is impossible to present information on software products without some subjectivity and comment we have sincerely attempted to discuss the capabilities of these products with minimal product bias or critique. Also it is impossible to describe the features of 187 188 CHAPTER 9 CASE Tools for Logical Database Design Figure 9.1 Business system life cycle courtesy IBM Corp. these products in great detail in a chapter of this sort a user manual of many hundred pages could be written describing each so we have set the bar slightly lower with the aim of surveying these products to give the reader a taste for the capabilities they provide. Further details can be obtained from