[TYPO3-dev] RFC: Change roadmap for 4.5 and 5.0

[Ricardo Scachetti Pereira]

Johannes Reichardt wrote:

>Hi Thomas,
>  
>
>>I have to add a wish for the next version.
>>Please think about the database structure. The TYPO3 DB is not even in the first 
>>normal form! I know that this will end up in an incredible amount of tables in 
>>the database but it would be much more elegant in many cases!
>>  
>>    
>>
>Just interested since i have not many DB knowledge in theory - what 
>exactly do you mean?
>  
>
Correct if I'm wrong, but Thomas means that there are several columns in 
Typo3 database that are used to store multiple values, while the 
correct, normalized representation would be to turn the column into a 
separate table and link the two using foreign keys.

An example is the usergroup field in the be_users table. It stores all 
groups the user belongs to in a single column like this: 
"22,6,9,10,7,20,14,8". For this table to be in 1st normal form, you 
would need to create another table, called, say "usergroups" and store 
these rows (assuming the user above has uid=1):

User_uid | Group_uid
1 | 22
1 | 6
1 | 9
1 | 10
1 | 7
1 | 20
1 | 14
1 | 8

Google for more information on this. Use these keywords: database 
normalization, normal forms, 1NF. Here are some examples:
http://databases.about.com/od/specificproducts/a/normalization.htm
http://databases.about.com/od/specificproducts/l/aa1nf.htm

>- Johannes
>
>
>  
>
>>Greets,
>>Thomas
>>
>>
>>--
>>typo3-unleashed.net
>>_______________________________________________
>>TYPO3-dev mailing list
>>TYPO3-dev at lists.netfielders.de
>>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>
>>  
>>    
>>
>
>_______________________________________________
>TYPO3-dev mailing list
>TYPO3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>
>  
>