Post reply

DataBase Design

  • September 24, 2008 at 3:14 am

    #382793

    Hi, I am given the task to design the new SQL Server 2005 database for a new web application. What are the basic rules which I should follow to design a flexible databas ?

    ------------

    dkhandka

  • September 24, 2008 at 3:28 am

    #876187

    Check the following links

    http://www.ibm.com/developerworks/web/library/wa-dbdsgn1.html

    http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

  • November 5, 2008 at 8:13 am

    #894273

    We'll that fact that you are asking is a start in the right direction. But not something that can be answered in a forum.

    1) really focus on what are the objectives of the application, and read some basic concepts of database design and data normalization.

    2) try to identify the hot spots for query selection. These will require special attention so that once in production, the select queries will be resolved quickly.

    3) understand the concept of normalization, but keep #2 in focus, or you will have a highly normalized database that does not support the key goals of the system.

    The more you are prepared, the less you need it.

  • November 5, 2008 at 9:11 am

    #894326

    Thanks for your valuable comments.

    dkhandka

  • November 5, 2008 at 9:21 am

    #894338

    I understand the normalization concepts and RDBMS rules.

    But would like to know good practices or the rule of thumb which we should follow while designing the database of an enterprize level.

    thanks

    dkhandka:)

  • November 5, 2008 at 9:38 am

    #894350

    the rules are the same at a small or large level. You design to store and query data efficiently. You might need to add things at a large level like indexed views, partitioning, etc., but you don't design those up front, or I think it's a waste to do so. You never know if you'll hit scale levels.

  • November 5, 2008 at 9:51 am

    #894365

    I agree with you.

    Thanks for the comments.

    dkhandka 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply