|
Database Design (Sams Teach Yourself)
Product Review Database design and administration may be the last refuge of the true gurus, now that visual languages have made programming more accessible and network administration certifications have proliferated to the extent that they have. Database Design explains the process of building data-storage systems to people who may have hacked around in databases before, but have never really engineered one from the ground up. Though they both specialize in Oracle work as consultants, authors Ryan Stephens and Ronald Plew remain mostly independent of implementation specifics here, focusing instead on generic relationship diagrams that illustrate structure and ANSI-standard structured query language (SQL) for code examples. Revealing their consultancy roots, Stephens and Plew start with methods of determining business requirements and stay focused on business issues throughout their tutorials. The section on data normalization exemplifies the authors' method of explaining technical issues: they present a considerable amount of prose on why normalization (the process by which "Steve Jones," in entered data, is recognized as the same human being as "Stephen P. Jones" where it is appropriate to do so) is a good idea, as well as some of its drawbacks and alternatives. They then present a series of table schema that shows how normalization works in practice. It's a worthwhile read for working and soon-to-be-working database designers. --David Wall Topics covered: Database design for people who haven't designed databases before or who have done so without the background knowledge they should have had. The authors cover business requirements, entities and relationships, normalization, integrity maintenance, and query design. There are also sections on modifying legacy databases and implementing ancillary features such as security. Product Description Database Design is the book you need to master the basics of relational database design in today's ever-evolving world of database technologies. This book takes an approach to database design to teach the reader how to reach into the inner depths of an organization to understand the business needs, data, and daily processes that will all blend together to formulate a successful database. Much emphasis is placed on logical design as it is imperative to understand the inner workings of an organization to produce the highest quality database, while proactively eliminating future problems that are not so easy for a beginner to foresee. Additionally, topics such as change control, business rule integration, database security implementation, and legacy database redesign are covered in detail. Examples of SQL code are shown to portray implementation tasks of a relational database. Examples are compliant with ANSI standard. Reader Reviews After thumbing through a half-dozen books on data modelling and database design, I finally picked up this book. It is the best intro to data modelling that I've come across yet. I've been playing with Oracle and MySQL for a year or so, but I knew I wasn't going to get very far if I didn't know how to build databases from scratch. This book was the first one I've come across that didn't take on the airs of an academic dissertation. Highly recommended for people who want to build Database Analyst skills. Comment | | (Report this)
|
 |
|||
|
|||
|
|||
Current Page: engineeringbookmonster > Database Engineering > Database Design (Sams Teach Yourself) Try the Arcspider search for hard to find Database Engineering texts and references. Locate authoritative works by top researchers and authors in Database Engineering and other science and engineering fields. Our database includes a huge collection of tools for the practicing engineer or student. Find the latest edition of a textbook, specification or an obscure periodical - and buy at a discount!
NOTE: All prices, specifications, and availability Copyright © 2008, engineeringbookmonster.com info@engineeringbookmonster.com Privacy Policy |
|||
