August 11, 2011 at 4:27 am
Hi,
I want to know about the best practices of data base design. can any body help me please?
Best Regards,
archana
August 11, 2011 at 4:51 am
There are way too many of them to answer that question very easily. And each "best practice" has a caveat. It depends on what kind of database you're designing (OLTP, Data Warehouse, ODS / EDS, OLAP, etc.)
What is it you're trying to accomplish? Are you actually stuck with the job of designing a database for work? Is this a homework assignment? Are you starting out and want to learn?
We can recommend resources based on what your situation is.
August 11, 2011 at 5:27 am
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
August 11, 2011 at 5:29 am
There are scads of books on the topic. You're not going to be able to learn how to do it from a post on a forum.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 11, 2011 at 5:30 am
There are also plenty of software packages out there that already do this (provide a sales order processing system) - and might be more cost effective if you have time constraints and don't have the skill set to do this on your own.
-Ki
August 11, 2011 at 5:35 am
archanab (8/11/2011)
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
Fortunately for you, Microsoft has a wonderful sample database set up exactly for that type of thing. It's called Adventure Works. Now, please note that this db is set up to train people how to use SQL Server, so don't steal the design. Just use it to learn how to design your own.
I advise going to your local bookstore and picking up a Microsoft Cert book on database design. Granted, the book is intended for people studying for their MS certification, but it can still teach you a lot on how to get things done. Or, if you can find one, a Sybex book on database design. (I like Sybex Press a bit better than MS, but that's just me).
August 11, 2011 at 5:52 am
August 11, 2011 at 6:09 am
archanab (8/11/2011)
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
Hire someone.
Seriously. If you have no idea where to start with a complex database design/system design you are setting yourself up for failure in trying to do it. If you don't get someone in to help with the design, you'll almost certainly have to get someone in later to fix it and tune it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply