August 27, 2013 at 4:48 am
Hi All,
I have an hierarchy table as below which stores the key data.And the value for this key will be stored in another table.And the Value can be multiple i e Key-Value 1:n.And this values can be associated with an Item.
Now I have to De normalize this table so that I can use the same in Query builder search?
What is the best solution and design?
IDNameParent IDCategory ID
19IdentifierNULL 3
20Type of Classification 193
21Entry193
22TitleNULL 3
23LanguageNULL 3
24DescriptionNULL 3
25Keyword NULL 3
26StructureNULL 3
27Aggregation level NULL 3
28VersionNULL 4
29StatusNULL 4
30ContributeNULL 4
31Role304
32Entity304
33Date304
34IdentifierNULL 5
35Type of Classification 345
36Entry345
37ContributeNULL 5
38Entity375
39Date375
40Metadata schemaNULL 5
41LanguageNULL 5
Thanks
Ningaraju
August 27, 2013 at 7:47 am
ningaraju.ne 46825 (8/27/2013)
Hi All,I have an hierarchy table as below which stores the key data.And the value for this key will be stored in another table.And the Value can be multiple i e Key-Value 1:n.And this values can be associated with an Item.
Now I have to De normalize this table so that I can use the same in Query builder search?
What is the best solution and design?
IDNameParent IDCategory ID
19IdentifierNULL 3
20Type of Classification 193
21Entry193
22TitleNULL 3
23LanguageNULL 3
24DescriptionNULL 3
25Keyword NULL 3
26StructureNULL 3
27Aggregation level NULL 3
28VersionNULL 4
29StatusNULL 4
30ContributeNULL 4
31Role304
32Entity304
33Date304
34IdentifierNULL 5
35Type of Classification 345
36Entry345
37ContributeNULL 5
38Entity375
39Date375
40Metadata schemaNULL 5
41LanguageNULL 5
Thanks
Ningaraju
Why do you have to denormalize your data for the front end? With the really vague details you have posted it is difficult if not impossible to offer any solid advice.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply