Chapters 4 and 5 show how to use data modeling concepts in the database design process. Chapter 4 is devoted to direct application of conceptual data modeling in logical database design. Chapter 5 explains the transformation of the conceptual model to the relational model, and to Structured Query Language (SQL) syntax specifically.
Chapter 6 is devoted to the fundamentals of database normalization through third normal form and its variation,
Boyce-Codd normal form, showing the functional equivalence between the conceptual model (both ER and UML) and the relational model for third normal form.
The case study in Chapter 7 summarizes the techniques presented in Chapters 1 through 6 with a new problem environment.
Chapter 8 illustrates the basic features of object-oriented database systems and how they differ from relational database systems. An “impedance mismatch” problem often arises due to data being moved between tables in a relational database and objects in an application program.
Extensions made to relational systems to handle this problem are described.
Chapter 9 looks at Web technologies and how they impact databases and database design. XML is perhaps the best known Web technology. An overview of XML is given, and we explore database design issues that are specific to XML.
Chapter 10 describes the major logical database design issues in business intelligence - data warehousing, online analytical processing (OLAP) for decision support systems, and data mining.
Chapter 11 discusses three of the currently most popular software tools for logical design: IBM’s Rational Data
Architect, Computer Associates’ AllFusion ERwin Data Modeler, and Sybase’s PowerDesigner. Examples are given to demonstrate how each of these tools can be used to handle complex data modeling problems.
The Appendix contains a review of the basic data definition and data manipulation components of the relational database query language SQL (SQL-99) for those readers who lack familiarity with database query languages. A simple example database is used to illustrate the SQL query capability.
The database practitioner can use this book as a guide to database modeling and its application to database design for business and office environments and for well-structured scientific and engineering databases. Whether you are a novice database user or an experienced professional, this book offers new insights into database modeling and the ease of transition from the ER model or UML model to the relational model, including the building of standard SQL data definitions. Thus, no matter whether you are using IBM’s DB2, Oracle, Microsoft’s SQL Server,
Access, or MySQL for example, the design rules set forth here will be applicable. The case studies used for the examples throughout the book are from real-life databases that were designed using the principles formulated here.
This book can also be used by the advanced undergraduate or beginning graduate student to supplement a course textbook in introductory database management, or for a stand-alone course in data modeling or database design.
|Database Modeling and DESIGN|
Enregistrez-vous ou connectez-vous pour récupérer des fichiers de cette catégorie.
|2012-10-25 10.49 MB 69|
Mot de passe: www.almohandiss.com