Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
27 used & new from £3.74

Have one to sell? Sell yours here
 
   
Designing Effective Database Systems
 
See larger image
 

Designing Effective Database Systems (Paperback)

by Rebecca M. Riordan (Author)
5.0 out of 5 stars See all reviews (1 customer review)
RRP: £35.99
Price: £30.59 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £5.40 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want guaranteed delivery by Saturday, July 18? Choose Express delivery at checkout. See Details
19 new from £9.95 8 used from £3.74

Frequently Bought Together

Customers buy this book with Database Solutions: A Step-by-Step Approach to Building Databases by Thomas Connolly

Designing Effective Database Systems + Database Solutions: A Step-by-Step Approach to Building Databases
Price For Both: £74.28

Show availability and shipping details


Customers Who Bought This Item Also Bought

Database Solutions: A Step-by-Step Approach to Building Databases

Database Solutions: A Step-by-Step Approach to Building Databases

by Thomas Connolly
5.0 out of 5 stars (1)  £43.69
Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series)

Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science Series)

by Thomas Connolly
4.0 out of 5 stars (15)  £47.49
Third

Third

~ Portishead
3.7 out of 5 stars (90)  £7.98
Explore similar items

Product details

  • Paperback: 384 pages
  • Publisher: Addison Wesley; illustrated edition edition (20 Jan 2005)
  • Language English
  • ISBN-10: 0321290933
  • ISBN-13: 978-0321290939
  • Product Dimensions: 23.4 x 17.5 x 2.8 cm
  • Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
  • Amazon.co.uk Sales Rank: 594,026 in Books (See Bestsellers in Books)
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Database Developers
   ApprovedDatabaseDevelopers.co.uk    Need a developer? Use our form, get free quotes from top programmers. 
Need a Database?
   DatabaseDev.ComputerWeekly.com    Choose the Right Database Developer Get Free Quotes from 6 suppliers 
System Design
   Autodesk.co.uk/Inventor    3D power and 2D design tools in one package. Try Before You Buy! 
  
 

Product Description

Product Description

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.”

Duncan Mackenzie, developer, Microsoft (MSDN)“Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.”

Patrick Birch, database and technical writing consultant“If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.”

Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP“A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!”

Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.”

Paul Irvine, vice president, engineering, Via Training“Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!”

Mike Gunderloy, contributing editor, Application Development Trends“This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.”

Amy Sticksel, Sticksel Data Systems, Inc.“In Designing Effective Database Systems, Riordan’s style, wit, and attention to detail are outstanding.”

Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design

World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it.

Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications.

One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability.

This book will teach you to

  • Understand relational database models, structures, relationships, and data integrity principles
  • Define database system goals, criteria, scope, and work processes
  • Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
  • Build efficient, secure database schema
  • Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more
  • Architect and construct easy, efficient interfaces for querying and reporting
  • Learn from practice examples based on Microsoft’s Northwind sample database

Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.





From the Back Cover

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.”

Duncan Mackenzie, developer, Microsoft (MSDN)“Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.”

Patrick Birch, database and technical writing consultant“If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.”

Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP“A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!”

Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.”

Paul Irvine, vice president, engineering, Via Training“Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!”

Mike Gunderloy, contributing editor, Application Development Trends“This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.”

Amy Sticksel, Sticksel Data Systems, Inc.“In Designing Effective Database Systems, Riordan’s style, wit, and attention to detail are outstanding.”

Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design

World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it.

Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications.

One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability.

This book will teach you to

  • Understand relational database models, structures, relationships, and data integrity principles
  • Define database system goals, criteria, scope, and work processes
  • Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
  • Build efficient, secure database schema
  • Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more
  • Architect and construct easy, efficient interfaces for querying and reporting
  • Learn from practice examples based on Microsoft’s Northwind sample database

Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.





See all Product Description

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below

Your tags: Add your first tag
 

 

Customer Reviews

1 Review
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
5.0 out of 5 stars Great book, 2 April 2009
By J. Hotchkiss "teatime" (UK) - See all my reviews
(REAL NAME)   
I bought this book a few of years ago and since then have recommended it to various colleagues who have also enjoyed reading it.

I have worked with databases since before the start of my career and despite learning formal design at college and university decided to read a refresher. I chose this book after seeing it recommended on various development blogs and wasn't disappointed.

Rebecca has a very easy to read style written with the right level of humour that only adds to the enjoyment of reading the book. The book itself covers all the main areas of database design in enough detail to be very useful.

Despite covering a technical area, I would also have no problem recommending this book for non-technical people who might have to utilise SQL or an advanced reporting tool, as it would certainly aid in understanding what might be going on under the hood.

Overall very happy with the purchase and will continue to recommend as I have never read anything better.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Feedback


The Body Shop

The Body Shop - Vitamin C Skin Boost
Protect and boost your glow with The Body Shop Vitamin C Skin Boost.

Shop The Body Shop

 

Make A Wish

Get what you want with an Amazon.co.uk Wish List Make sure you always get what you want with an Amazon.co.uk Wish List.

More info on Wish Lists

 

Train Hard...Play Hard

Nike, Gola, Converse, and more
Gear up with up to 60% off athletic and outdoor shoes.

Shop now

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates