Wrox Programmer Forums
|
BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4
This is the forum to discuss the Wrox book Beginning Database Design Solutions by Rod Stephens; ISBN: 9780470385494
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 22nd, 2008, 11:31 AM
Rod Stephens's Avatar
Wrox Author
 
Join Date: Jan 2006
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default Welcome!

Welcome to the discussion forum for my book "Beginning Database Design Solutions." If you have questions or feedback about the book, feel free to post them here.

If you have questions about how to design a database, post them here, too. Between everyone watching this forum, perhaps we can help find a solution.

Rod

Rod Stephens, Visual Basic MVP

Visual Basic 2008 Programmer's Reference
http://www.amazon.com/exec/obidos/AS...2628/vbhelper/
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
 
Old April 11th, 2009, 04:23 PM
Registered User
 
Join Date: Apr 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database design

My name is Laz I am from the UK and I have just bought two of your books. The database design solutions ( and the vb reference) I am pleased with the books I feel the data base design could have debated the followings:

1 - I have a model consisting of over 200 tables and 1200 stored procedures. Should I split the model over few databases which would make sense as each database would reflect
an area.

2 - Some of the tables have more than 200 columns should I split the table into several tables and have one-to-one relationship. Again this would make sense as far as the real world is concerned but would increase the number of stored procedures.

Could you please let me have your opinion, these are the sort of design tips I need at present.

thank you for two good books. Do you have any DVD courses by any chance?
 
Old April 12th, 2009, 09:18 AM
Rod Stephens's Avatar
Wrox Author
 
Join Date: Jan 2006
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default RE: Database design

Hi Laz,

I've worked with some big databases, some probably as big as that one, but such big databases can be intimidating.

I think the most important issue is what makes logical sense to you. If the tables naturally break into coherent pieces that make sense to you and you will often use only one piece at a time, then it might make sense to split them apart. If you're going to use data from several of the pieces most of the time, then you may be better off keeping the tables together in their larger forms.

The same logic applies to splitting the database. If the pieces are logically separate and you will use them separately, then it makes sense to split them up. If you're going to use them together, then it probably makes sense to keep them together in the same database.

All that aside, the only other reason to split things up is for performance reasons. If a table has 200 fields and they are large fixed-size fields, then it may take a little time to rewrite its records. This doesn't matter as much if the fields are small or are stored as references. (For example, BLOB and some other large field types are not stored with the main record but are stored as pointers to another location.)

Even then, modern databases do a pretty good job of handling big tables and some other ways to improve performance in those cases use methods such as striping the table across multiple disks. The database has some capabilities that let you keep the table in one logical piece. If you break the database apart or split up the tables, then the database's optimization tools can't help you as much and you need to perform a lot of extra work yourself to make everything fit together.

So in summary, I think I'd keep everything together if it makes logical sense to you. If you discover there's a performance problem, I would look at the database's capabilities for improving performance: indexing, splitting tables across multiple disks, etc. Only as a last resort would I split the database or tables.

And be sure to use good database design techniques. Proper normalization helps split the unrelated pieces of the database apart and can greatly improve performance.

I hope that helps.

> thank you for two good books.

I'm glad you find them useful! Post reviews on Amazon or wherever you like to buy books.

> Do you have any DVD courses by any chance?

Sorry, I don't.

Best wishes,
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
 
Old July 17th, 2009, 06:04 PM
Registered User
 
Join Date: Jan 2009
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default PowerPoints ?

In an effort to not reinvent the wheel, I'm enquiring to find out if you have any PPTs prepared & available to educators before I have to spend time creating them from scratch.
 
Old July 18th, 2009, 09:35 AM
Rod Stephens's Avatar
Wrox Author
 
Join Date: Jan 2006
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Unhappy Unfortunately I don't have PPTs right now

Hi Kayes,

Unfortunately I don't have a PPT for this. Some have also suggested a collection of exercises without solutions. I'm willing to try to connect interested educators and help build a library of supplemental materials but those I was talking to didn't show too much interest. I'm still willing if a few people want to get together on this. If everyone makes a few and pools their resources ...
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)









Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.