Database Modeling and Design: Logical Design (The Morgan Kaufmann Series in Data Management Systems)

Item as described and fast shipping.

I have a Computer Science background and I have worked in various capacities ranging from software design and development to systems engineering and project management. I work on a lot of large scale software programs which rely on robust, properly designed relational database systems.The authors start off with a very accurate statement in the introduction; knowing and understanding both data modeling and database design techniques and applying that knowledge to logical and physical database design are important knowledge assets.The book starts with an introduction to ER diagrams which are frequently used in conceptual data modeling. Some sage advice is given in the "Tips and Insights for Database Professionals". The next chapter delves into UML, which I have seen used on every program I have worked on. Indeed, having a working knowledge of ER and UML diagrams helps convey your designs in a more-or-less standardized language format. Not all organizations embrace all types of UML diagrams, so a generalized knowledge is key, and this book only touches the surface of both UML and ER diagramming. I would recommend supplemental references for really getting into UML or ER diagramming.The next chapter is on requirements analysis and conceptual data modeling. The authors contend that RA feeds conceptual data modeling using ER and UML diagrams, which I have found to be common. Moving along, there is a discussion on transforming the conceptual data model to SQL. This is a good high level introductory chapter. From this chapter, we move into normalization. Normalization is difficult and requires proper performance analysis.Chapter 7 introduces an example of logical database design. This example is short and simplistic but it does convey some good points. The next chapter on object relational design takes the reader a step farther. All programs I have worked on involved object oriented design and implementation, and this chapter attempts to reduce the impedance mismatch typical of marrying object oriented software with a relational DBMS.Chapter 9 involves XML and Web Databases, or web technologies and how they impact database design. A brief discussion on web technologies and the architecture of databases in websites is given. Next, we have a very long chapter on Business Intelligence, covering aspects of data warehousing, OLAP and data mining. Chapter 11 discusses commonly used CASE tools useful in database design. This is relatively good information, but keep in mind that you will typically be bound to the software or CASE tools that have been chosen for your organization. The rest of the book is a reference appendix on SQL and references.Overall, this book covers a lot of ground, lending itself to an introductory database modeling and design course and the undergraduate or graduate level. Since there is a lot to the art of database modeling and design, this relatively small book can't provide the depth needed to readily assist a seasoned professional, but it is ideal for someone starting out or a junior level engineer in industry. I have used this book a couple of times as a reference but I typically find myself wanting to know less about theory and more about practical application of knowledge. So for the right audience, this is a good introduction and reference.

As described and on time.

really basic stuff. not helpful. Read Database Design for Smarties Robert Muller

This book is well written and organized. The book offers easily indexed chapters that allow one to quickly find the resource that they need. The book is also easily read from start to finish, with a logical flow, building up to advance chapters, essentially going from the basic ideas of database modeling, how UML works what is needed to develop the concept of what your database will be, then the book goes into designing your database by using the concepts you created in the earlier chapter. In later chapters you will see examples of finished databases, and examples of different forms of databases, followed by case tools to help you in the future (the majority of the tools are expensive, and not very practical for practice [due to the price, more for a real world job]). The book is easy to read and is written in terms that do not overwhelm and confuse new programmers. The book also provides numerous diagrams and examples to help one visualize the idea outcome. The book offers numerous ER diagrams, Database examples, and screenshot of what the outcome will be on your computer.In the end this book is a great reference for anyone thinking about playing around with database modeling or design. This book would also make a great textbook (don't worry, it is not a textbook and does not have questions at the end of each chapter, with no answers -- instead each chapter ends with tips and summaries, to help real world users out). This book is a great addition to anyone's computer science library and a must for anyone learning or working with databases!

This book covers relational database design as well as physical database design.The database life cycle is described in Chapter 1. In Chapter 2, the authors present the fundamental concepts of data modeling and provide some constructs to represent them. Chapter 3 introduces the UML notation for data modeling. Chapter 4 and 5 show how to use data modeling concepts in the database design process. Chapter 4 talks about logical database design while Chapter 5 explains transformation of conceptual model to relational model and to SQL specifically. Chapter 6 covers fundamentals of database normalization. Chapter 7 summarizes Chapter 1-6. Chapter 8 illustrates basic features of Object- oriented database systems. Chapter 9 delves into web technologies like XML and how they impact database design. Chapter 10 describes the major issues in BI such as warehousing, OLAP for decision support systems and data mining,Chapter 11 discusses popular software tools and how they can be used to handle complex problems.This is a well written book providing a good overview on database design. This is a great handbook for a database architect and also for someone trying to understand the fundamentals of database modeling and design.

I bought this book for my Advanced Database Modeling class. Where I would have encountered problems in trying to set up all of the keys within large databases, this book make it very clear on how to set up my ideas on paper, and then implement them in SQL. This book does contain some reference material for learning SQL, but if you don't already know the basics of the language, you should find a beginner level book that is written for that purpose. That said, I think this book is a great reference for those new or experienced with Database Modeling.

This book needs revision to discuss non-RDBMS databases more fully. The authors do a good job of discussing RDBMS logical design issues, but there is no significant coverage (a brief chapter on XML datastores) on non-RDBMS logical design. With solutions like MongoDB, Neo4J, CouchBase and Datatomic, to name a few, becoming more prevalent, this is a major gap that needs to be filled in the next edition.

Great introductory book on database design. Plenty of illustrative examples and a nice progression of concepts through the book.

Fast turn around and very useful subject matter