topic Re: normalization in Application Development and Automation Discussions

normalization

Former Member — Wed, 13 Jun 2007 07:00:28 GMT

hi ,

can anybody explain me abt normalization and types of normal forms?

and their explaination

Re: normalization

Former Member — Wed, 13 Jun 2007 07:13:18 GMT

command to set the Unicode normalization to use for the lifetime of the session. It should be set after the session is authenticated.

Unicode normalization is important when a text string is represented differently depending on the normalization used. The MDM server always store text strings in one normalization format. An user providing a text string to the MDM server and later on tries to retrieve back the same text string might get the text string back in a different normalization. To resolve this issue, the user can use this class to specify the normalization the user wants to work with. The MDM server will always return text strings in the normalization specified by this class.

static int NORMALIZATION_COMPOSED

static int NORMALIZATION_DECOMPOSED

static int NOT_NORMALIZED

please see for more information :

<a href="http://">http://help.sap.com/javadocs/MDM/current/com/sap/mdm/commands/SetUnicodeNormalizationCommand.html</a>

reward points if it is usefull ...

Girish

Re: normalization

Former Member — Wed, 13 Jun 2007 07:22:57 GMT

What is Normalization ?

Normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and often results in the creation of additional tables. (While normalization tends to increase the duplication of data, it does not introduce redundancy, which is unnecessary duplication.) Normalization is typically a refinement process after the initial exercise of identifying the data objects that should be in the database, identifying their relationships, and defining the tables required and the columns within each table.

You will get good information on <b>Normal Forms types</b> @

http://www.datamodel.org/NormalizationRules.html

<b>@</b> Rewared points if you find this information useful

Regards, Srikanth