Jun 28 2006

CAPitalZ

Normalizing Your Database Structure

Posted at 4:38 pm under Database

Access databases often have a flat structure, that is, there are few tables and many fields in each table. Access works efficiently with tables containing many fields and fewer joins between tables, whereas SQL Server works more efficiently with narrower tables containing fewer fields and more relationships between tables. Combined with properly used indexes, you will see a vast improvement in database reads and updates, because SQL Server is efficient at selecting rapid, efficient joins between tables.
http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx#EBAA

=======================

  • A table should store only data for a single type of entity.

Attempting to store too much information in a table can prevent the efficient and reliable management of the data in the table.

  • A table should avoid nullable columns.

Tables can have columns defined to allow null values. A null value indicates that there is no value. Although it can be useful to allow null values in isolated cases, it is best to use them sparingly because they require special handling that increases the complexity of data operations. If you have a table with several nullable columns and several of the rows have null values in the columns, you should consider placing these columns in another table linked to the primary table. Storing the data in two separate tables allows the primary table to be simple in design but able to accommodate the occasional need for storing this information.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_2oby.asp

_____
CAPital

No responses yet




Trackback URI | Comments RSS

கருத்து ஒன்றை விடவும்


நீங்கள் இயந்திரம் இல்லை (கசடு [Spam] உருவாக்கும் மென்பொருள் அல்ல) என்று நிரூபிக்க, கீழே தெரியும் சொல்லை தட்டச்சுங்கள்.
நீங்கள் இங்கு தெரியும் முதல் தமிழ் சொல்லையோ அல்லது இரண்டாவது ஆங்கில சொல்லையோ தட்டச்சலாம். ஆனால், இரண்டையும் சேர்த்து தட்டச்சாதீர்கள்.
கசடு எதிர்மறை (Anti-Spam) படம்