| Author |
Message |
    
Kittigadu
Kurra Bewarse
Username: Kittigadu
Post Number: 1162
Registered: 12-2011
Posted From: 170.88.180.1
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 8:32 am: |
|
Vizagyouth:
annai..thanks for the information..XML SPY already download chesa trail version..andulo ekkada nunche code teyyala anede choodali
neeku okasari trail code pampana? nee tdp mail ki ?
Inka Decide cheyyaleee
|
Vizagyouth
Kurra Bewarse
Username: Vizagyouth
Post Number: 1839
Registered: 02-2005
Posted From: 212.120.136.5
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 7:17 am: |
|
Kitti
ask them the XSD for the XML which is similar to copybook in mainframes. It has the rules defined how the XML should be.
Adhi vunte kani you cannot create an accurate table.
for suppose ledhu anuko
ID_XML meedha query rasi max length functions use cheyi a record thesukoni note pad meedha copy ••••• enni elements vunnayo chusi dhani batti go ahead and create the table
elements kanipettatam kastam gaa vunte
XMLSPY download cheyyi free version dhantlo
DTD/SChema tab kinda generate schema ani vuntadhi
nuvvu save chesina xml file(note pad lo copy kottindhi) isthe ..neeku XSD create avuthadhi based on that XML file that you have created.
a generate ayyina schema lo manual gaa count cheyavachu
screen shots kavali ante XMLSPY use ki mail tdp2093@gmail.com
I have recently learnt a great tummy exercise.
|
J2ee
Kurra Bewarse
Username: J2ee
Post Number: 4805
Registered: 08-2004
Posted From: 24.185.22.29
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 7:06 am: |
|
Best solution is use EAV pattern to design table too .
It's more like a column wise store approach . Advantage is you can store any record with indefinite columns for each record . Look for EAV pattern it's known as entity attribute value pattern in DB design |
Kittigadu
Kurra Bewarse
Username: Kittigadu
Post Number: 1161
Registered: 12-2011
Posted From: 107.10.145.155
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 6:50 am: |
|
Droid:
columns standard ga 50 vunte ade pane settunu..in all XML standard ga 10 common columns vunnaru..remaining ID batti bonus..starting from 15 to 150 
Inka Decide cheyyaleee
|
Kittigadu
Kurra Bewarse
Username: Kittigadu
Post Number: 1160
Registered: 12-2011
Posted From: 107.10.145.155
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 6:48 am: |
|
Lenevo:
Thanks Lenovo mama.. A link lo susi try chesta eyyala
Inka Decide cheyyaleee
|
Droid
Pilla Bewarse
Username: Droid
Post Number: 112
Registered: 01-2014
Posted From: 50.129.121.207
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, March 27, 2014 - 12:16 am: |
|
Naaku ardam kaaledu kani, why not create 50 columns as NULL and then update the ID1 and XML fields? |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 941
Registered: 05-2011
Posted From: 65.74.157.84
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, March 26, 2014 - 10:36 pm: |
|
http://technet.microsoft.com/en-us/library/aa224820(v=sql.80).aspx |
Lenevo
Pilla Bewarse
Username: Lenevo
Post Number: 940
Registered: 05-2011
Posted From: 65.74.157.84
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, March 26, 2014 - 10:30 pm: |
|
fIRST STRIP OFF THE XML BASED ON SEGMENTS AND THEN ATTRIBUTES ..
SO A SINGLE SEGMENT CAN HAVE MULTIPLE ATTRIBUTES ( FIELDS IN YOUR DB).. AND THEN PROCESS IN TO A TABLE . THIS CAN BE CALLED AS STAGING TABLE, AND THEN PROCESS FROM THERE.. ITS AS COMPLICATED AS YOU THINK..
SEARCH GOOGLE OR BING WITH XML_DOCUMENT..
fyI, DONT USE SSIS PACKAGE. IT WILL GIVE WRONG RESULTS THOUGH YOU SPECIFY XSD. |
Kittigadu
Kurra Bewarse
Username: Kittigadu
Post Number: 1159
Registered: 12-2011
Posted From: 107.10.145.155
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, March 26, 2014 - 9:03 pm: |
|
XML experts evvarina vunte koddiga help seyyandri..
naaku oka table vundi SQL DB lo..it has two columns.
One columns is ID(int)
Another columns is ID_XML(XML)
....
ekkada ID_XML column lo XML data vundi ID related..this XML may have 20 to 50 columns depends on the ID..
naa requirement..
XML data ni ID base chesukundi inko table lo raayali..
now the new table will have..
ID + XML columns..
twist enti ante..
suppose ID1 ki related ga 20 xml columns vunnay..ade table lo rasesam..
ID2 ki 30 columns vunnayi
ekkada malli table ki new columns add sese ID1 place lo NULL pettali..
emina ardam ayyite..koddiga help cheyyandi..
Ela modalettalo ardam kavadam leedu....any inputs appreciated
Inka Decide cheyyaleee
|
Archives - 2014