lundi 20 septembre 2021
Se Connecter à votre compte

Connexion à votre compte

Mot de passe
Maintenir la connexion active sur ce site

    Si vous etes déjà abonné sur notre site et vous n'arrivez pas à vous connecter, contacter nous !

Database Modeling and DESIGN

  • Database Modeling and DESIGNTitre : Database Modeling and DESIGN
  • Nombre de page : 335

Description: The database life cycle is described in Chapter 1. In Chapter2, we present the most fundamental concepts of data modeling and provide a simple set of notational constructs (the Chen notation for the ER model) to represent them.

The ER model has traditionally been a very popular method of conceptualizing users’ data requirements. Chapter 3 introduces the UML notation for data modeling.UML(actually

UML-2) has become a standard method of modeling large-scale systems for object-oriented languages such as

C++ and Java, and the data modeling component of UML is rapidly becoming as popular as the ER model. We feel it is important for the reader to understand both notations and how much they have in common.

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.

Date 2012-10-25 Taille du fichier 10.49 MB Téléchargement 82


Mot de passe:

Connectez-vous pour commenter